DATE | CHAIN | FULLY_BAL | |
|---|---|---|---|
1 | 2025-03-20 00:00:00.000 | Optimism | 27467048.64 |
2 | 2025-03-20 00:00:00.000 | Polygon | 32998182.78 |
3 | 2025-03-20 00:00:00.000 | Aptos | 53163198.44 |
4 | 2025-03-20 00:00:00.000 | Avalanche | 53188864.37 |
5 | 2025-03-20 00:00:00.000 | Ethereum | -80169650.97 |
6 | 2025-03-20 00:00:00.000 | Arbitrum | 11864328.98 |
7 | 2025-03-19 00:00:00.000 | Optimism | 27464196.79 |
8 | 2025-03-19 00:00:00.000 | Polygon | 32994485.52 |
9 | 2025-03-19 00:00:00.000 | Aptos | 53157241.85 |
10 | 2025-03-19 00:00:00.000 | Avalanche | 53182904.86 |
11 | 2025-03-19 00:00:00.000 | Ethereum | -80208415.18 |
12 | 2025-03-19 00:00:00.000 | Arbitrum | 11863097.13 |
13 | 2025-03-21 00:00:00.000 | Optimism | 27069922.24 |
14 | 2025-03-21 00:00:00.000 | Polygon | 33001906.26 |
15 | 2025-03-21 00:00:00.000 | Aptos | 53169197.21 |
16 | 2025-03-21 00:00:00.000 | Avalanche | 53194866.1 |
17 | 2025-03-21 00:00:00.000 | Ethereum | -117631071.06 |
18 | 2025-03-21 00:00:00.000 | Arbitrum | 32366050.14 |
19 | 2025-03-22 00:00:00.000 | Optimism | 27069922.24 |
20 | 2025-03-22 00:00:00.000 | Polygon | 33001906.26 |
tkvresearchconceptual-salmon
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
...
1800
81KB
27s