Query editor
with btrfly_withdrawn AS(SELECT date_trunc ('day', evt_block_time) AS day,SUM(cast(amount/1e18 AS DOUBLE)) AS btrfly_withdrawnFROM redacted_ethereum.RLBTRFLY_evt_WithdrawnWHERE relock = falseGROUP BY 1),btrfly_relocked AS(SELECT date_trunc ('day', evt_block_time) AS day,SUM(cast(amount/1e18 AS DOUBLE)) AS btrfly_relockedFROM redacted_ethereum.RLBTRFLY_evt_WithdrawnWHERE relock = trueGROUP BY 1),btrfly_price AS(SELECT date_trunc ('day', block_time) AS day,SUM(cast(amount_usd AS DOUBLE))/SUM(cast(token_bought_amount AS DOUBLE)) AS btrfly_priceFROM dex.tradesWHERE token_bought_symbol = 'BTRFLY'GROUP BY 1)SELECTbtrfly_withdrawn.day,btrfly_withdrawn.btrfly_withdrawn,SUM(btrfly_withdrawn) over (ORDER BY btrfly_withdrawn.day) AS cumulative_btrfly_withdrawn,btrfly_relocked.btrfly_relocked,SUM(btrfly_relocked) over (ORDER BY btrfly_withdrawn.day) AS cumulative_btrfly_relocked,SUM(btrfly_relocked) over (ORDER BY btrfly_withdrawn.day)/SUM(btrfly_withdrawn) over (ORDER BY btrfly_withdrawn.day) AS ratio,btrfly_price.btrfly_priceFROM btrfly_withdrawnLEFT JOIN btrfly_relocked ON btrfly_withdrawn.day = btrfly_relocked.dayLEFT JOIN btrfly_price ON btrfly_withdrawn.day = btrfly_price.dayORDER BY day DESC