Query editor
WITHsupply AS (SELECTSUM(supply) OVER (ORDER BYhour) AS supply,hourFROM(SELECTSUM(supply) AS supply,DATE_TRUNC('hour', evt_block_time) AS hourFROM(SELECTvalue / CAST(1e18 AS DOUBLE) AS supply,evt_block_timeFROMerc20_ethereum.evt_TransferWHERE"contract_address" = 0xfeef77d3f69374f66429c91d732a244f074bdf74AND "from" = 0x0000000000000000000000000000000000000000AND evt_block_time > CAST('2021-01-01 00:00:00' AS TIMESTAMP)UNIONSELECT- value / CAST(1e18 AS DOUBLE) AS supply,evt_block_timeFROMerc20_ethereum.evt_TransferWHERE"contract_address" = 0xfeef77d3f69374f66429c91d732a244f074bdf74AND "to" = 0x0000000000000000000000000000000000000000AND evt_block_time > CAST('2021-01-01 00:00:00' AS TIMESTAMP)) AS tGROUP BY2) AS tr),prices AS (WITHswap AS (SELECTDATE_TRUNC('hour', sw."block_time") AS hour,("token_sold_amount") AS a0_amt1,("amount_usd") AS a1_amt1FROMdex."trades" AS swWHEREsw.blockchain = 'ethereum'AND sw.blockchain = 'ethereum'AND "token_sold_address" = 0x3432b6a60d23ca0dfca7761b7ab56459d9c964d0 /* liq pair address I am searching the price for */AND "amount_usd" >= 1AND block_time > CAST('2021-01-01 00:00:00' AS TIMESTAMP)),a1_prcs AS (SELECTDATE_TRUNC('hour', sw."block_time") AS hour,("token_sold_amount") AS a0_amt,("amount_usd") AS a1_amt