Calculate the value of your Sharx

rw2023Calculate the value of your Sharx

Updated 2024-03-02

-- forked from Calculate the value of your sharx @ https://flipsidecrypto.xyz/edit/queries/525945e6-6abc-4ec9-9bd2-b992ebb94a12

-- POR EL MOMENTO NO TRACKEAN EL PRECIO DE FISHY

with

-----------------------------------------

--price_fishy as (

--select

--RECORDED_HOUR::date as day,

--avg(CLOSE) as fishy_price

--from solana.price.ez_token_prices_hourly

--where day>= '2022-09-01'

-- and symbol in ('fishy')

-- group by 1

--),

price_sol as (

select

RECORDED_HOUR::date as day,

'{{fishy_price}}' as fishy_price,

avg(CLOSE) as sol_price

from solana.price.ez_token_prices_hourly

where day>= '2022-09-01'

and symbol in ('sol')

group by 1

-------------$fishy to level up --------------------------

sharx_level as (

select

QueryRunArchived: QueryRun has been archived