0-MIDdaily and total fee
Updated 2024-12-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select date_trunc('week',BLOCK_TIMESTAMP) as week
,sum(TX_FEE) as "Tx Fee $AVAX"
,sum(PLATFORM_FEE) as "Platform Fee $AVAX"
,sum(CREATOR_FEE) as "Creator Fee $AVAX"
,sum(TX_FEE)+sum(PLATFORM_FEE)+sum(CREATOR_FEE) as "Total Generated Fee $AVAX"
,sum(TX_FEE_USD) as "Tx Fee USD"
,sum(PLATFORM_FEE_USD) as "Platform Fee USD"
,sum(CREATOR_FEE_USD) as "Creator Fee USD"
,sum(TX_FEE_USD)+sum(PLATFORM_FEE_USD)+sum(CREATOR_FEE_USD) as "Total Generated Fee USD"
,sum("Tx Fee $AVAX")over(order by week) as "Total Tx Fee $AVAX"
,sum("Platform Fee $AVAX")over(order by week) as "Total Platform Fee $AVAX"
,sum("Creator Fee $AVAX")over(order by week) as "Total Creator Fee $AVAX"
,sum("Total Generated Fee $AVAX")over(order by week) as "Total Fees Generated $AVAX"
,sum("Tx Fee USD")over(order by week) as "Total Tx Fee USD"
,sum("Platform Fee USD")over(order by week) as "Total Platform Fee USD"
,sum("Creator Fee USD")over(order by week) as "Total Creator Fee USD"
,sum("Total Generated Fee USD")over(order by week) as "Total Fees Generated USD"
from avalanche.nft.ez_nft_sales
where PLATFORM_NAME='salvor'
group by 1
QueryRunArchived: QueryRun has been archived