boomer77swap to $THOR
Updated 2022-05-28
9
1
2
3
4
5
6
7
8
›
⌄
select date_trunc('day', block_timestamp) as dt, sum(from_amount_usd) as swap_vol_usd, sum(from_amount) as swap_vol_rune, count(distinct from_address) as address_count,
count(distinct tx_id) as transaction_count, case
when dt > '2022-05-04' then 'Post-Yield $THOR'
when dt < '2022-05-04' then 'Pre-Yield $THOR'
else 'yield $THOR' end as typez
from thorchain.swaps
where to_asset = 'ETH.THOR-0XA5F2211B9B8170F694421F2046281775E8468044' and date(block_timestamp) >= '2022-03-01'
group by 1
Run a query to Download Data