Query editor
WITH daily_volume AS (SELECTDATE_TRUNC('day', evt_block_time) AS date,SUM(value) / 1e18 AS daily_volume_in_tokenFROM erc20_ethereum.evt_TransferWHEREcontract_address = 0xd8b90d2e680ea535eacce1b025c998b347892f68AND DATE_TRUNC('day', evt_block_time) > TRY_CAST('2023-07-22' /* Excluding the launch date */ AS TIMESTAMP)GROUP BY1), token_price AS (SELECTdate,priceFROM prices.usd -- Replace with the actual schema and table name)SELECTdaily_volume.date,daily_volume.daily_volume_in_token,daily_volume.daily_volume_in_token * token_price.price AS daily_volume_in_usdFROM daily_volumeJOIN token_priceON daily_volume.date = token_price.dateORDER BYdaily_volume.date;