sprigithasen22Untitled Query
Updated 2022-11-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
trunc(block_timestamp,'day') as date,
--distinct contract_name as contract,
count(distinct tx_id) as n_daily_sales,
sum(event_data:price) as daily_sales_volume,
count(distinct event_data:seller) as daily_sellers,
sum(n_daily_sales) over (order by date) as cum_sales,
sum(daily_sales_volume) over (order by date) as cum_volume_sales,
sum(daily_sellers) over (order by date) as cum_sellers
from flow.core.fact_events x
join flow.core.dim_contract_labels y
on x.event_contract=y.event_contract
and contract_name like '%AllDay%'
group by 1
order by 1 asc
--limit 10
Run a query to Download Data