ben-wyattfind-high-tx
Updated 2025-02-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- select *,
-- FROM avalanche.core.ez_token_transfers
-- where amount_usd is not null
-- order by amount_usd desc
-- limit 10
select *
from
(
select amount_usd, block_timestamp, symbol
FROM ethereum.core.ez_token_transfers
where amount_usd > 1e15
union all
select amount_usd, block_timestamp, 'AVAX' as symbol
FROM ethereum.core.ez_native_transfers
where amount_usd > 1e15)
order by amount_usd desc
QueryRunArchived: QueryRun has been archived