FredoC-iyBb0SZED paid racing & SNG turnover copy
Updated 2024-04-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from bg_alt / ZED paid racing & SNG turnover @ https://flipsidecrypto.xyz/bg_alt/q/APIIUbrEjJTj/zed-paid-racing-sng-turnover
WITH zed_usd AS (
SELECT
DATE_TRUNC({{ duration }}, hour) AS time,
AVG(price) AS zed_price
FROM
polygon.price.ez_hourly_token_prices
WHERE
token_address = '0x5ec03c1f7fa7ff05ec476d19e34a22eddb48acdc'
GROUP BY
time
ORDER BY
time ASC
),
weth_usd AS (
SELECT
DATE_TRUNC({{ duration }}, hour) AS time,
AVG(price) AS weth_price
FROM
polygon.price.ez_hourly_token_prices
WHERE
token_address = '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619'
GROUP BY
time
ORDER BY
time ASC
),
turnover AS (
SELECT
DATE_TRUNC(
{{ duration }},
events.block_timestamp
) AS time,
SUM(
CASE
QueryRunArchived: QueryRun has been archived