Query editor
WITH btc_token_price AS (SELECTCAST(date_trunc('day', minute) AS DATE) AS day,AVG(price) AS btc_priceFROM prices.usdWHERE symbol = 'BTC'AND (blockchain = '' OR blockchain IS NULL)GROUP BY1),nominal_token_transfer AS (SELECTCAST(date_trunc('day', evt_block_time) AS DATE) AS day,sum(value/1e+18) AS transfer_value,AVG(sum(value/1e+18)) OVER (ORDER BY CAST(date_trunc('day', evt_block_time) AS DATE)ROWS BETWEEN 30 PRECEDING AND CURRENT ROW) AS thirty_day_moving_averageFROM evms.erc20_transfersWHEREblockchain = 'ethereum'AND contract_address = 0x18084fbA666a33d37592fA2633fD49a74DD93a88GROUP BY 1)SELECTn.day,b.btc_price AS price_btc,n.transfer_value AS volume_transfers_tbtc,n.thirty_day_moving_average AS MA30d_tbtc,n.transfer_value * b.btc_price AS volume_transfers_usd,n.thirty_day_moving_average* b.btc_price AS MA30d_usdFROMnominal_token_transfer nLEFT JOINbtc_token_price bONn.day = b.day