Monitize AI2024-07-10 08:18 PM
Updated 2024-07-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with total as (
select
distinct TX_HASH
from ethereum.defi.ez_dex_swaps
where
--token_in = lower('0x24fcFC492C1393274B6bcd568ac9e225BEc93584')
--or
token_out = lower('0x24fcFC492C1393274B6bcd568ac9e225BEc93584')
order by BLOCK_TIMESTAMP DESC
limit 100
)
select
*
from ethereum.core.ez_token_transfers
where TX_HASH in (select TX_HASH from total)
order by BLOCK_TIMESTAMP DESC
limit 100
QueryRunArchived: QueryRun has been archived