Query editor
-- BCT Price Querywith dex_trades AS (SELECTtoken_a_address as contract_address,usd_amount/(token_a_amount_raw / 10e17) as price,block_timeFROM dex.tradesWHERE 1=1AND usd_amount > 0AND category = 'DEX'AND token_a_amount_raw > 0AND token_a_address = '\x2f800db0fdb5223b3c3f354886d907a671414a7f'::byteaAND block_time >= '2021-10-18'UNION ALLSELECTtoken_b_address as contract_address,usd_amount/(token_b_amount_raw / 10e17) as price,block_timeFROM dex.tradesWHERE 1=1AND usd_amount > 0AND category = 'DEX'AND token_b_amount > 0AND token_b_address = '\x2f800db0fdb5223b3c3f354886d907a671414a7f'::byteaAND block_time >= '2021-10-18'),rawdata as (SELECTdate_trunc('hour', block_time) as hour,d.contract_address,(PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY price)) AS price,count(1) AS sample_sizeFROM dex_trades dGROUP BY 1, 2),leaddata as(SELECThour,contract_address,price,sample_size,lead(hour, 1, now() ) OVER (PARTITION BY contract_address ORDER BY hour asc) AS next_hourfrom rawdatawhere sample_size > 3),hours AS(SELECTgenerate_series('2021-10-18'::TIMESTAMP, date_trunc('hour', NOW()), '1 hour') AS hour),