namanasync2024-06-27 01:40 PM
Updated 2024-07-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select t.*, l.address_name, l.label_type, l.label_subtype, l.label
FROM (SELECT contract_address, symbol, sum(amount_usd) amount_usd
FROM ethereum.core.ez_token_transfers
WHERE block_timestamp >= DATEADD(day, -30, CURRENT_TIMESTAMP)
and has_price
group by contract_address, symbol
order by amount_usd desc
limit 200) t
INNER JOIN
ethereum.core.dim_labels l
on t.contract_address = l.address
ORDER BY amount_usd DESC
QueryRunArchived: QueryRun has been archived