Query editor
WITH relocks AS(SELECT DATE_TRUNC('day', evt_block_time) AS day,SUM(CAST(amount AS DOUBLE)/1e18) AS relock_amountFROM redacted_ethereum.RLBTRFLY_evt_WithdrawnWHERE relock = TRUEGROUP BY 1),withdrawals AS(SELECT DATE_TRUNC('day', evt_block_time) AS day,SUM(CAST(amount AS DOUBLE)/1e18) AS withdrawal_amountFROM redacted_ethereum.RLBTRFLY_evt_WithdrawnWHERE relock = FALSEGROUP BY 1),lock AS(SELECT DATE_TRUNC('day', evt_block_time) AS day,SUM(CAST(amount AS DOUBLE)/1e18) AS lock_amountFROM redacted_ethereum.RLBTRFLY_evt_LockedGROUP BY 1),txs AS(SELECT DATE_TRUNC('day', evt_block_time) AS day,SUM(CAST(value AS DOUBLE)/1e18) AS valueFROM redacted_ethereum.BTRFLY_evt_TransferWHERE evt_block_time >= CAST('2022-08-08' AS TIMESTAMP)GROUP BY 1),btrfly_eth AS(SELECT DATE_TRUNC('day', block_time) AS day,SUM(token_sold_amount)/SUM(token_bought_amount) AS btrfly_ethFROM curvefi.tradesWHERE token_bought_address = 0xc55126051B22eBb829D00368f4B12Bde432de5DaGROUP BY 1)SELECTtxs.day,CAST(relock_amount AS DOUBLE) AS relock_amount,CAST(withdrawal_amount AS DOUBLE) AS withdrawal_amount,CAST(lock_amount AS DOUBLE) AS lock_amount,(CAST(lock_amount AS DOUBLE)+CAST(relock_amount AS DOUBLE))/CAST(withdrawal_amount AS DOUBLE) AS ratio,btrfly_eth.btrfly_ethFROM txsLEFT JOIN relocks ON txs.day = relocks.dayLEFT JOIN withdrawals ON txs.day = withdrawals.dayLEFT JOIN lock ON txs.day = lock.dayLEFT JOIN btrfly_eth ON txs.day = btrfly_eth.dayORDER BY txs.day DESC