Hessishpyramid - daily
Updated 2023-10-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with x as (SELECT hour::date as date, avg(price) as pr
from crosschain.price.ez_hourly_token_prices
where SYMBOL = 'WETH'
and BLOCKCHAIN = 'ethereum'
and hour::date >= '2023-08-16'
GROUP by 1)
SELECT
count(DISTINCT tx_hash) AS trades,
sum((INPUTS[1]:value[3]:value)/pow(10,18)) as eth_volume,
eth_volume*avg(pr) as volume,
date_trunc('day', timestamp::date) as date,
case
when timestamp::date >= '2023-09-21' then 'After Pyramid Storefront launch'
else 'Before Pyramid Storefront launch' end as period
from external.tokenflow_starknet.decoded_traces
join x on timestamp::date=date
where
timestamp::date >= '2023-08-16'
and FUNCTION = 'buyFromMarketPrice'
and CONTRACT = '0x0364847c4f39b869760a8b213186b5b553127e9420e594075d13d1ce8a1d9157'
GROUP by 4,period
Run a query to Download Data