banbannardUser Behavior 2
Updated 2022-06-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with base as (select date_trunc('day', block_timestamp) as day,
count(distinct(tx_id)) as count_swaps
from flow.core.fact_swaps
group by 1),
base2 as (select date_trunc('day', block_timestamp) as day,
count(distinct(tx_id)) as count_nft_sales
from flow.core.fact_nft_sales
where tx_succeeded = 'TRUE'
group by 1)
select a.day,
count_swaps,
count_nft_sales
from base a
join base2 b
on a.day = b.day
Run a query to Download Data