jkhuhnke11Daily Fees
Updated 2023-03-10
9
1
2
3
4
5
6
7
›
⌄
SELECT date_trunc('day', block_timestamp) as metric_date,
sum(tx_fee_usd) as fee,
avg(fee) OVER (ORDER by metric_date ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as avg
FROM gold.near_events
WHERE metric_date >= '2020-10-14'
GROUP BY 1
ORDER BY 1 DESC
Run a query to Download Data