Query editor
WITHvolume AS (SELECTamount_usd,DATE_TRUNC('week', block_time) AS week,DATE_TRUNC('month', block_time) AS monthFROMdex.tradesWHEREtoken_bought_address IN (0xdab396ccf3d84cf2d07c4454e10c8a6f5b008d2b,0xe0bCEEF36F3a6eFDd5EEBFACD591423f8549B9D5,0xc221b7E65FfC80DE234bbB6667aBDd46593D34F0,0x33349b282065b0284d756f0577fb39c158f935e6,0xfAbA6f8e4a5E8Ab82F62fe7C39859FA577269BE3,0xf21661d0d1d76d3ecb8e1b9f1c923dbfffae4097,0x6e5970dbd6fc7eb1f29c6d2edf2bc4c36124c0c1,0x4c19596f5aaff459fa38b0f7ed92f11ae6543784,0x509a38b7a1cc0dcd83aa9d06214663d9ec7c7f4a)OR token_sold_address IN (0xdab396ccf3d84cf2d07c4454e10c8a6f5b008d2b,0xe0bCEEF36F3a6eFDd5EEBFACD591423f8549B9D5,0xc221b7E65FfC80DE234bbB6667aBDd46593D34F0,0x33349b282065b0284d756f0577fb39c158f935e6,0xfAbA6f8e4a5E8Ab82F62fe7C39859FA577269BE3,0xf21661d0d1d76d3ecb8e1b9f1c923dbfffae4097,0x6e5970dbd6fc7eb1f29c6d2edf2bc4c36124c0c1,0x4c19596f5aaff459fa38b0f7ed92f11ae6543784,0x509a38b7a1cc0dcd83aa9d06214663d9ec7c7f4a))SELECT*,SUM(weekly_volume) OVER (ORDER BYweek NULLS FIRST ROWS BETWEEN UNBOUNDED PRECEDINGAND CURRENT ROW) AS total_volume,SUM(weekly_volume) OVER (PARTITION BYmonth) AS monthly_volumeFROM(SELECTSUM(amount_usd) AS weekly_volume,week,monthFROMvolumeGROUP BYweek,month)