joel_a0Getting Started
Updated 2025-02-26Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with token_info as (
select *
from $query('75f58bb3-b2cd-4208-85e9-e3d75d901a1c')
)
SELECT
t.block_timestamp,
t.tx_hash,
t.from_address,
t.to_address,
t.amount as token_amount,
t.amount_usd,
t.symbol,
FROM polygon.core.ez_token_transfers t
JOIN token_info ti
ON t.symbol = ti.symbol
WHERE t.block_timestamp::date >= '2025-01-27'
AND t.block_timestamp > CURRENT_DATE - 100
AND t.block_timestamp <= CURRENT_DATE - 23
ORDER BY t.block_timestamp DESC;
QueryRunArchived: QueryRun has been archived