neoswapns_tx_data copy
Updated 2024-06-05
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 ns_tx_data @ https://flipsidecrypto.xyz/edit/queries/ff52ae27-0c85-4980-bb8f-2732789cf6e0
WITH
-- ns_fee AS (
-- SELECT
-- TX_ID
-- FROM
-- solana.core.fact_transfers
-- WHERE
-- TX_TO = 'FjecsBcSXQh4rjPSksh2eBiXUswcMpAwU25ykcr842j8'
-- AND block_timestamp >= '2024-01-01'
-- ),
price as (
SELECT
TOKEN_ADDRESS as MINT,
RECORDED_HOUR :: DATE as PRICE_DATE,
FIRST_VALUE(CLOSE) OVER (PARTITION BY MINT, RECORDED_HOUR :: DATE ORDER BY RECORDED_HOUR) AS PRICE
FROM
solana.price.ez_token_prices_hourly
WHERE
TOKEN_ADDRESS IN (
'So11111111111111111111111111111111111111112',
'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v',
'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx'
)
AND RECORDED_HOUR >= '2024-01-01'
),
day_price as (
SELECT
MINT,
PRICE_DATE,
ANY_VALUE(PRICE) as PRICE
FROM price
GROUP BY 1, 2
)
SELECT
QueryRunArchived: QueryRun has been archived