binhachonSwaps to $THOR
Updated 2022-05-27
9
1
2
3
4
5
6
7
8
9
›
⌄
select
date_trunc('day', block_timestamp) as time,
case when from_asset = 'THOR.RUNE' then 'Buy THOR' else 'Sell THOR' end as category,
sum(from_amount_usd) as volume,
count(*) as number_of_transactions
from flipside_prod_db.thorchain.swaps
where pool_name like 'ETH.THOR%'
and time >= '2022-05-01'
group by 1, 2
Run a query to Download Data