nitsDOGE swaps impact net
Updated 2022-01-22
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with total_swaps as (select date(block_timestamp) as day, sum(from_amount_usd) as today_swaps from thorchain.swaps
where block_timestamp > (select min(block_timestamp) as first_ from thorchain.swaps
where contains(from_asset, 'DOGE') or contains(to_asset, 'DOGE'))
GROUP by day )
select sum(TODAY_SWAPS_DOGE)/ sum(TODAY_SWAPS)*100 as percent_impact from
(select date(block_timestamp) as day_, sum(from_amount_usd) as today_swaps_doge from thorchain.swaps
where contains(from_asset, 'DOGE') or contains(to_asset, 'DOGE')
GROUP by day_ )
inner join total_swaps
on day = day_
limit 100
Run a query to Download Data