DATE | CHAIN | FULLY_BAL | |
---|---|---|---|
1 | 2025-05-20 00:00:00.000 | Aptos | 53526483.24 |
2 | 2025-05-20 00:00:00.000 | Polygon | 23472102.41 |
3 | 2025-05-20 00:00:00.000 | Avalanche | 52948567.59 |
4 | 2025-05-20 00:00:00.000 | Arbitrum | 31065866.25 |
5 | 2025-05-20 00:00:00.000 | Optimism | 26235986.42 |
6 | 2025-05-20 00:00:00.000 | Ethereum | -75586857.136146 |
7 | 2025-05-19 00:00:00.000 | Aptos | 53526483.24 |
8 | 2025-05-19 00:00:00.000 | Polygon | 23472102.41 |
9 | 2025-05-19 00:00:00.000 | Avalanche | 52948567.59 |
10 | 2025-05-19 00:00:00.000 | Arbitrum | 31065866.25 |
11 | 2025-05-19 00:00:00.000 | Optimism | 26235986.42 |
12 | 2025-05-19 00:00:00.000 | Ethereum | -75586857.136146 |
13 | 2025-05-18 00:00:00.000 | Aptos | 53508331.71 |
14 | 2025-05-18 00:00:00.000 | Polygon | 23464142.6 |
15 | 2025-05-18 00:00:00.000 | Avalanche | 52930611.95 |
16 | 2025-05-18 00:00:00.000 | Arbitrum | 31056096.72 |
17 | 2025-05-18 00:00:00.000 | Optimism | 26227735.88 |
18 | 2025-05-18 00:00:00.000 | Ethereum | -86234597.236146 |
19 | 2025-05-17 00:00:00.000 | Aptos | 53508331.71 |
20 | 2025-05-17 00:00:00.000 | Polygon | 23464142.6 |
tkvresearchconceptual-salmon
Updated 2025-05-20Copy Reference Fork
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: 2 months ago
1800
84KB
68s