Discussions from the Metaverse

@Flock Nice.

@Flock Not sure where you can improve on this. Art is a bit subjective. I look like the balance of the green and black texture blending in. Was there a theme or genre that you are specifically trying to follow?

@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.

@NFTDailyNews I think ETH fees will only increase over time.

ETH allows around 15 tx/second. Assuming that crypto industry will keep expanding, the demand of those txs will increase too, so people will be willing to spend more in order to let their txs passing through the network. This will inevitably push the fees to new high we can barely imagine nowdays.

In 2030 an ETH tx will costs dozen of thousands of dollars

@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
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