Spectertotal amount trend
Updated 2024-10-16
99
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
›
⌄
WITH ChainV AS (
SELECT Date_trunc('day', block_timestamp) AS date, 'blast' AS chain,
tx_hash, to_address, amount_usd
FROM blast.core.ez_native_transfers
WHERE from_address = '0x59b9ac688e39a14b938ac8c3269db66d8adb9af6'
UNION ALL
SELECT Date_trunc('day', block_timestamp) AS date, 'bsc' AS chain,
tx_hash, to_address, amount_usd
FROM bsc.core.ez_native_transfers
WHERE from_address = '0x7e2cf06f092c9f5cf5972ef021635b6c8e1c5bb2'
UNION ALL
SELECT Date_trunc('day', block_timestamp) AS date, 'polygon' AS chain,
tx_hash, to_address, amount_usd
FROM polygon.core.ez_native_transfers
WHERE from_address = '0x8ccd9c0a9c084412416a85fd748c7f1e9b86442d'
)
SELECT date, chain,
sum(amount_usd) AS total_amount
FROM ChainV
GROUP BY date, chain
ORDER BY Date DESC
QueryRunArchived: QueryRun has been archived