flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
Untitled Query
takamori
Untitled Query
Updated 2023-03-08
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
select
extract
(
hour
from
block_timestamp
)
,
sum
(
tx_fee
)
/
count
(
tx_fee
)
from
ethereum
.
core
.
ez_nft_sales
where
block_timestamp
>
current_timestamp
(
)
-
interval
'23 hour'
group
by
1
order
by
1
desc
Results
Run a query to Download Data