h4wkFlow Swapping For
Updated 2022-06-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
-- Q11. What are users swapping for?
-- What activities are the most common for users on Flow right now?
-- Create a visualization on what’s causing spikes in swapping behavior.
select date_trunc(day, block_timestamp) as compact_date,
split_part(token_out_contract, '.', 3) as token,
count(tx_id) as swap_count,
count(distinct trader) as trader,
sum(token_out_amount) as vol,
sum(vol) over (partition by token order by compact_date asc) as com_vol
from flow.core.fact_swaps
group by token, compact_date
Run a query to Download Data