@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

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);

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

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

@NFTDailyNews And from studying his recent videos and how he is now bullish on BTC, I won't be surprised if he comes out with the integration of MillionToken on Bitcoin-defi or SOV. Something definitely on that ecosystem. Just me speculating here.

@Cam_271 He could have an update tomorrow or 10 years. So if you are waiting for something, honestly it's best to sell everything. And I don't bet on hope, uncertainty, or waiting for people.

If he needs to focus on Defi Pro, then it makes sense for him to do so. Defi Pro is expected to reach $1 million in revenue this year, and it has not even reached 1 full month years old. There are now 1400 members on that discord channel with some serious people. I expect it could hit about $3 million in revenue by the end of this year.

In the meanwhile, we are just testing Metafora. Nothing wrong with that. @TL can query all our tickets by %TL% and work on the issues later. It really makes sense and practicality for him to focus on Defi Pro. It makes the MM system also more attractive from a value proposition.
And honestly metafora does not generate money. 😂😂

So far Metafora is fine for me. The only feature I want is a full 100% block feature. UI stuff is low on my priority list. Entry level.

@NFTDailyNews TL will figure it out. I don't sweat it. I like where Defi Pro is going already.