flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Daily Marketcap
freemartian
Daily Marketcap
Updated 2025-03-05
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH
current_price
AS
(
SELECT
hour
,
AVG
(
price
)
AS
price
FROM
base
.
price
.
ez_prices_hourly
WHERE
token_address
=
'0x20ef84969f6d81ff74ae4591c331858b20ad82cd'
GROUP
BY
1
)
SELECT
hour
AS
time
,
1100000000
*
price
AS
marketcap
FROM
current_price
Results
Auto-refreshes every 1 hour
QueryRunArchived: QueryRun has been archived