2024-08-09 12:16 PM

Sniper2024-08-09 12:16 PM

Updated 2024-09-27

-- select

-- hour,

-- symbol,

-- price

-- from base.price.ez_prices_hourly

-- where token_address IN ('0x6b9bb36519538e0c073894e964e90172e1c0b41f','0x4200000000000000000000000000000000000006')

-- and hour::date >= '2024-07-07'

-- select platform from base.defi.ez_dex_swaps

-- where token_in = '0x6b9bb36519538e0c073894e964e90172e1c0b41f'

-- or token_out = '0x6b9bb36519538e0c073894e964e90172e1c0b41f'

-- GROUP by 1

-- SELECT

-- symbol,

-- hour::date as date,

-- avg(price) as price_

-- -- 'wGCKLAY' :: string AS token_symbol,

-- -- '0x42952b873ed6f7f0a7e4992e2a9818e3a9001995' :: string AS token_contract,

-- -- '0xb10528e8754f01b77b63ee2fe66e9437881fc410' :: string AS pool_contract_address

-- FROM kaia.price.ez_prices_hourly

-- WHERE symbol = 'sKLAY'

-- -- AND hour::date >= current_date - interval '365 day'

-- GROUP BY 1 ,2

-- order by 1 desc

-- limit 1

-- SELECT

-- hour::date as date,

-- avg(price)::string as price,

-- 'sKLAY' :: string AS token_symbol,

-- '0xa323d7386b671e8799dca3582d6658fdcdcd940a' :: string AS token_contract,

-- '0xd33db6dcfcbb57f604e6c731c6e278d36fa6912a' :: string AS pool_contract_address

-- FROM kaia.price.ez_prices_hourly

-- WHERE symbol = 'KLAY'

-- AND hour::date >= current_date - interval '365 day'

-- GROUP BY 1

QueryRunArchived: QueryRun has been archived

flipside