afonsoUntitled Query
Updated 2023-01-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with t as (
select
block_timestamp::date as day,
count(distinct tx_id) as txns_count,
count(distinct trader) as traders_count
from terra.core.ez_swaps
where from_currency = 'uluna'
and block_timestamp >= '2022-12-01'
and to_currency in (
'ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4', --axlUSDT
'ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858' --axlUSDC
)
group by day
)
select
avg(txns_count) as average_txns_count,
avg(traders_count) as average_traders_count
from t
Run a query to Download Data