boomer77Tx daily thorchain
Updated 2022-01-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with swaps as (select date_trunc('day', block_timestamp) as dt, count(distinct tx_id) as swap_count
from thorchain.swaps
group by 1),
lp as (select date_trunc('day', block_timestamp) as dt, count(distinct tx_id) as add_lp_count
from thorchain.liquidity_actions
where lp_action = 'add_liquidity'
group by 1)
select a.dt, a.swap_count, b.add_lp_count
from swaps a
left outer join lp b on a.dt = b.dt
Run a query to Download Data