Elprognerd10 - luna <-> swaps
Updated 2023-01-17Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select
'Others -> LUNA' as type,
--date_trunc('hour',block_timestamp) as date,
count(distinct tx_id) as "Number of TXs",
count(distinct trader) as "Number of Swappers"
from terra.core.ez_swaps
where block_timestamp >= '2023-01-08' and to_currency ='uluna'
GROUP by 1
union
select
'LUNA -> Others' as type,
--date_trunc('hour',block_timestamp) as date,
count(distinct tx_id) as "Number of TXs",
count(distinct trader) as "Number of Swappers"
from terra.core.ez_swaps
where block_timestamp >= '2023-01-08' and from_currency ='uluna'
GROUP by 1
Run a query to Download Data