MPLPolygon Fee's (Updated)
Updated 2022-10-28Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
to_char(block_timestamp::date,'YYYY-MM-DD') as polygon_day,
COUNT((tx_id)) as transaction_count,
sum(fee_usd) as pfees_usd,
avg(fee_usd) as pfees_usdavg,
median(fee_usd) as pfees_usdmed,
stddev(fee_usd) as pfees_usdstd,
pFEES_USDmed + pfees_usdstd as pZ1,
pFEES_USDmed - pfees_usdstd as pZn1
--pFEES_USDstd/pFEES_USDavg as pctavg
-- nullif(pFEES_USDstd/(pFEES_USDmed),0) * 100 as pctmed
FROM polygon.transactions
GROUP BY polygon_day
ORDER BY polygon_day DESC
Run a query to Download Data