StangFASTauto pool
Updated 2023-06-11
999
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 auto pool @ https://flipsidecrypto.xyz/edit/queries/1221ca5f-3fb9-46ba-ab46-c47e2e8d2c12
with
avax_price AS
(
SELECT
date_trunc( 'day' , a.hour ) AS day
, avg( a.price ) AS price
, a.symbol AS symbol
FROM
avalanche.core.fact_hourly_token_prices a
WHERE
a.symbol = 'WAVAX'
GROUP BY
1 , 3
ORDER BY
1 DESC
)
,
tx_d AS
(
SELECT
a.tx_hash
FROM
avalanche.core.ez_decoded_event_logs a
LEFT OUTER JOIN
avalanche.core.fact_transactions c
ON a.tx_hash = c.tx_hash
WHERE
a.contract_address = lower( '0x32833a12ed3fd5120429fb01564c98ce3c60fc1d' )
AND a.origin_function_signature = '0x5a5757f9'
)
-- ,
-- tab_d AS
-- (
Run a query to Download Data