rezarwzTOTAL DEFI Distribution
Updated 2024-06-25
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
SELECT
*,
(
TOTAL_USER /(
SELECT
count(DISTINCT from_address)
from
blast.core.fact_transactions
where
from_Address in (
SELECT
from_address
from
blast.core.fact_transactions
group by
1
having
count(DISTINCT tx_hash) > 5
)
)
) * 100 as ratio
from
(
SELECT
case
when to_address in (
'0x0ea92deaf7141f405f00bfaad76a8ac74e155c00',
'0x4a1d9220e11a47d8ab22ccd82da616740cf0920a',
'0x9aecedcd6a82d26f2f86d331b17a1c1676442a87',
'0xfadfb0bc400427663020887e7c8073d03a35dc3c',
'0x434575eaea081b735c985fa9bf63cd7b87e227f9',
'0xeff87a51f5abd015f1afcd5737bbab450ea15a24',
'0xc02819a157320ba2859951a1dfc1a5e76c424dd4',
'0x8e2b50413a53f50e2a059142a9be060294961e40',
'0x44f33bc796f7d3df55040cd3c631628b560715c2',
'0x57dcc7b8867a61d82af5b9763687480aa0f040b6',
QueryRunArchived: QueryRun has been archived