ZookDex Agg Transactions Take 2 - daily stats
Updated 2022-08-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
Select
date_trunc('day', block_timestamp) as date,
count(distinct(tx_hash)) as number_of_swaps,
sum(amount_in_usd) as sum_swap_amount_usd
from ethereum.core.ez_dex_swaps
where date between '2022-08-23' and current_date - 1
and origin_to_address IN (lower('0xd31f7e39afECEc4855fecc51b693F9A0Cec49fd2'), lower('0x7C38b8B2efF28511ECc14a621e263857Fb5771d3'), lower('0x0747c681e5ADa7936Ad915CcfF6cD3bd71DBF121'), lower('0xd1ea5F7cE9dA98D0bd7B1F4e3E05985E88b1EF10')
, lower('0x94a852F0a21E473078846cf88382dd8d15bD1Dfb'), lower('0x3660dE6C56cFD31998397652941ECe42118375DA'), lower('0x0F2CD5dF82959e00BE7AfeeF8245900FC4414199'), lower('0x2a7813412b8da8d18Ce56FE763B9eb264D8e28a8')
, lower('0xbB8De86F3b041B3C084431dcf3159fE4827c5F0D'), lower('0x7a68c37D8AFA3078f3Ad51D98eA23Fe57a8Ae21a'))
or origin_from_address IN (lower('0xd31f7e39afECEc4855fecc51b693F9A0Cec49fd2'), lower('0x7C38b8B2efF28511ECc14a621e263857Fb5771d3'), lower('0x0747c681e5ADa7936Ad915CcfF6cD3bd71DBF121'), lower('0xd1ea5F7cE9dA98D0bd7B1F4e3E05985E88b1EF10')
, lower('0x94a852F0a21E473078846cf88382dd8d15bD1Dfb'), lower('0x3660dE6C56cFD31998397652941ECe42118375DA'), lower('0x0F2CD5dF82959e00BE7AfeeF8245900FC4414199'), lower('0x2a7813412b8da8d18Ce56FE763B9eb264D8e28a8')
, lower('0xbB8De86F3b041B3C084431dcf3159fE4827c5F0D'), lower('0x7a68c37D8AFA3078f3Ad51D98eA23Fe57a8Ae21a'))
group by 1 order by 1 desc
--where TX_HASH = lower('0xc473355167a0d3303a0d8acb4f8a9cd449e4e6946beb1cf375e5a48afd9d1960') -- SwapIN
Run a query to Download Data