-- avg(count(distinct tx_id)) over (order by date_trunc('day', block_timestamp) rows between 7 preceding and 1 preceding) as "prior_7_days_avg_no_of_txs",
-- sum(count(distinct tx_id)) over (order by date_trunc('day', block_timestamp)) as cum_no_of_txs,
sum(price)asvolume
-- avg(sum(price)) over (order by date_trunc('day', block_timestamp) rows between 7 preceding and 1 preceding) as "prior_7_days_avg_volume",
-- sum(sum(price)) over (order by date_trunc('day', block_timestamp)) as cum_volume,
-- count(distinct buyer) as no_of_buyers,
-- avg(count(distinct buyer)) over (order by date_trunc('day', block_timestamp) rows between 7 preceding and 1 preceding) as "prior_7_days_avg_no_of_buyers",
-- sum(count(distinct buyer)) over (order by date_trunc('day', block_timestamp)) as cum_no_of_buyers,
-- count(distinct seller) as no_of_sellers,
-- avg(count(distinct seller)) over (order by date_trunc('day', block_timestamp) rows between 7 preceding and 1 preceding) as "prior_7_days_avg_no_of_sellers",
-- sum(count(distinct seller)) over (order by date_trunc('day', block_timestamp)) as cum_no_of_sellers