Elprognerd11 - luna <-> swaps daily
Updated 2023-01-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
select
'Swap to LUNA (BUY)' as type,
date_trunc('day',block_timestamp) as date,
count(distinct tx_id) as "Number of TXs",
count(distinct trader) as "Number of Swappers",
sum("Number of Swappers") over (order by date) as "Cumulative Number of Swappers",
sum("Number of TXs") over (order by date) as "Cumulative Number of Swaps"
from terra.core.ez_swaps
where block_timestamp >= '2023-01-08' and to_currency ='uluna'
GROUP by 1, 2
union
select
'Swap from LUNA (SELL)' as type,
date_trunc('day',block_timestamp) as date,
count(distinct tx_id) as "Number of TXs",
count(distinct trader) as "Number of Swappers",
sum("Number of Swappers") over (order by date) as "Cumulative Number of Swappers",
sum("Number of TXs") over (order by date) as "Cumulative Number of Swaps"
from terra.core.ez_swaps
where block_timestamp >= '2023-01-08' and from_currency ='uluna'
GROUP by 1, 2
order by 2
Run a query to Download Data