saber-jlQuixotic daily trading volume
Updated 2022-08-02Copy 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
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with OP_Price as(
SELECT date_trunc('day', HOUR) as date, avg(price) as OP_price
From optimism.core.fact_hourly_token_prices
WHERE SYMBOL = 'OP'
AND hour >= '2022-06-15'
GROUP BY 1
ORDER BY 1),
Eth_price as (
SELECT date_trunc('day', BLOCK_TIMESTAMP) as date, avg(amount_out / amount_in) as ETH_price
From ethereum.core.ez_dex_swaps
WHERE SYMBOL_IN = 'WETH'
And SYMBOL_OUT = 'USDC'
AND BLOCK_TIMESTAMP >= '2022-06-15'
and PLATFORM = 'uniswap-v2'
GROUP BY 1
ORDER BY 1),
OPvol as (
SELECT date_trunc('day', block_timestamp) as date, CURRENCY_SYMBOL as Currency, sum(PRICE) as Volume
FROM optimism.core.ez_nft_sales
WHERE PLATFORM_NAME = 'quixotic'
AND block_timestamp >= '2022-06-15'
AND EVENT_TYPE = 'sale'
and currency_symbol = 'OP'
AND nft_address != '0xbe81eabdbd437cba43e4c1c330c63022772c2520'
GROUP BY 1 , 2
ORDER BY 1
),
ETHvol as (
SELECT date_trunc('day', block_timestamp) as date, CURRENCY_SYMBOL as Currency, sum(PRICE) as Volume
Run a query to Download Data