Discussions from the Metaverse

@MM-Matt

WITH
SUM_BUYS AS (
SELECT
"to" AS address,
SUM(value/1e18) AS amount
FROM erc20."ERC20_evt_Transfer"
WHERE contract_address = '\x6b4c7a5e3f0b99fcd83e9c089bddd6c7fce5c611'
GROUP BY 1),
SUM_SELLS AS (
SELECT
"from" AS address,
SUM(value/1e18) AS amount
FROM erc20."ERC20_evt_Transfer"
WHERE contract_address = '\x6b4c7a5e3f0b99fcd83e9c089bddd6c7fce5c611'
GROUP BY 1)
SELECT
'no_diamond_hands',
COUNT(DISTINCT CASE WHEN ss.amount IS NOT NULL THEN sb.address END)
FROM SUM_BUYS sb
LEFT JOIN SUM_SELLS ss ON(sb.address = ss.address)

UNION

SELECT
'yes_diamond_hands',
COUNT(DISTINCT CASE WHEN ss.amount IS NULL THEN sb.address END)
FROM SUM_BUYS sb
LEFT JOIN SUM_SELLS ss ON(sb.address = ss.address);

@dolphin this is the query behind the diamond hands KPI

@MM-Matt Yes exact. The flaw of this query is the fact that probably many holders are stuck with their MM because moving them on Ethereum network is impossible due to fees

@MM-Matt we should definitely dive further into those data

@dolphin @MM I like where this going. Nice work. If ETH transaction fees start getting smaller, it will be interesting. Think the other day it was around $30 if I am not mistaken.

@Flock Nice.

@Mya 😂😂😂

@Mya I think TL will be impressed with the commitment, fwiw 😂

1) It's the haters that force you to become better.
2) Adversity breeds creativity.

I say keep up the good work mate 🤟

@Mya oh no despair

@justdreamforever i think it could jump to 0,0003 BTC

@AodaiVietnamNFT yes. So many Karens
In mm community lmao.

@SkepticGhostHunting Very novel idea.

@Cam_271 yeah. Invest in alphabet.

@Cam_271
Did you delete your post or was it an admin?

@JamesHuckle Looks like it'll be a cannibalistic blood bath after you sell / take profits. God help us! xD

@OnlineMeditate 15 days Left !!!!

@NFTDailyNews what a legend!