SOURCE_TRANSACTIONS | UNIQUE_ADDRESSES | TOTAL_AMOUNT_USD | |
|---|---|---|---|
1 | 95440 | 58028 | 15805919.2608223 |
nickpcoral aggregate
Updated 3 days ago
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
›
⌄
-- forked from distant-coral @ https://flipsidecrypto.xyz/studio/queries/1d2d8a41-3384-4e35-8f12-832704674b06
WITH all_transfers AS (
-- Base Chain Token Transfers
SELECT
tt.block_timestamp,
tt.tx_hash,
tt.origin_from_address as from_address,
tt.symbol,
tt.amount_usd,
'base' as chain,
'token' as transfer_type
FROM base.core.ez_token_transfers tt
INNER JOIN (
SELECT topics[0], tx_hash
FROM base.core.fact_event_logs
WHERE block_timestamp::date > '2024-11-01'
AND (contract_address = lower('0xA4cE01bD7Dd91DA968a7C4A8D04282a3f5eA06bB') or contract_address = lower('0xdf4fFDa22270c12d0b5b3788F1669D709476111E'))
AND topics[0] = '0x181de28643611afcf1cb4c095a1ef99c157e78437294f478c978e4a56e1ca77e'
) bt ON bt.tx_hash = tt.tx_hash
WHERE tt.block_timestamp::date > '2024-11-01'
AND (tt.to_address = lower('0xA4cE01bD7Dd91DA968a7C4A8D04282a3f5eA06bB') or tt.to_address = lower('0xdf4fFDa22270c12d0b5b3788F1669D709476111E'))
UNION ALL
-- Base Chain Native Transfers
SELECT
tt.block_timestamp,
tt.tx_hash,
tt.origin_from_address as from_address,
'ETH' as symbol,
tt.amount_usd,
'base' as chain,
'native' as transfer_type
FROM base.core.ez_native_transfers tt
INNER JOIN (
Last run: 3 days ago
1
32B
193s