TT.BLOCK_TIMESTAMP::DATE | TX_HASH | FROM_ADDRESS | SYMBOL | AMOUNT_USD | CHAIN | |
---|---|---|---|---|---|---|
1 | 2024-12-04 00:00:00.000 | 0x8648100c3438f828e8725379440037f188e83af9af37556b10d13c5d36d36f01 | 0x9c1931a1b1aa6363f681720499d082a545867b62 | USDC | 144.537404814 | base |
nickpCoral
Updated 2024-12-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- spoke address 0xA4cE01bD7Dd91DA968a7C4A8D04282a3f5eA06bB
with base_from_transactions as(
select topics[0], * from base.core.fact_event_logs
where tx_hash = lower('0x8648100c3438f828e8725379440037f188e83af9af37556b10d13c5d36d36f01')
ANd block_timestamp::date > '2024-11-01'
and contract_address = lower('0xA4cE01bD7Dd91DA968a7C4A8D04282a3f5eA06bB')
and topics[0] = '0x181de28643611afcf1cb4c095a1ef99c157e78437294f478c978e4a56e1ca77e'
)
select tt.block_timestamp::date, tt.tx_hash, tt.origin_from_address as from_address, tt.symbol, tt.amount_usd, 'base' as chain
from base.core.ez_token_transfers tt
inner join base_from_transactions bt on bt.tx_hash = tt.tx_hash and bt.contract_address = tt.to_address
where
tt.block_timestamp::date > '2024-11-01'
and tt.to_address = '0xa4ce01bd7dd91da968a7c4a8d04282a3f5ea06bb'
Last run: 30 days ago
1
171B
7s