FULLY_BAL | CHANGE_7D | CHANGE_30D | SINCE_LAUNCHED | |
|---|---|---|---|---|
1 | 81170870.89 | -25.293966038 | -30.227131359 | -18.82912911 |
tkvresearchafraid-gold
Updated 2025-03-23
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
›
⌄
with list_contract as (
select *
from (values
('0x7712c34205737192402172409a8F7ccef8aA2AEc'),
('0xA6525Ae43eDCd03dC08E775774dCAbd3bb925872'),
('0xa1CDAb15bBA75a80dF4089CaFbA013e376957cF5'),
('0x2893Ef551B6dD69F661Ac00F11D93E5Dc5Dc0e99'),
('0x53FC82f14F009009b440a706e31c9021E1196A2F')
) as l(address)
),
--ethereum, optimism, arbitrum, polygon, avalanche
pre_data as
(select datetime,
chain,
sum(amt) as bal
from
(select date(block_timestamp) as datetime,
'Ethereum' as chain,
symbol,
amount as amt
from ethereum.core.ez_token_transfers
where contract_address in (select lower(address) from list_contract)
and
from_address = '0x0000000000000000000000000000000000000000'
union all
select date(block_timestamp) as datetime,
'Ethereum',
symbol,
-amount
from ethereum.core.ez_token_transfers
where contract_address in (select lower(address) from list_contract)
and
to_address = '0x0000000000000000000000000000000000000000'
union all
select date(block_timestamp) as datetime,
Last run: about 1 month ago
1
56B
22s