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,AVG(value/1e+18) AS average_transfer_size,AVG(AVG(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.average_transfer_size AS average_transfers_size_tbtc,n.thirty_day_moving_average AS MA30d_tbtc,n.average_transfer_size * b.btc_price AS average_transfers_size_usd,n.thirty_day_moving_average* b.btc_price AS MA30d_usdFROMnominal_token_transfer nLEFT JOINbtc_token_price bONn.day = b.day