Query editor
WITHtokens(contract_address, symbol, decimals, ticker) AS (VALUES(0x1a35ee4640b0a3b87705b0a4b45d227ba60ca2ad, 'axlWBTC', 8, 'axlWBTC'),(0x2ae3f1ec7f1f5012cfeab0185bfc7aa3cf0dec22, 'cbETH', 18, 'cbETH'),(0x9eaf8c1e34f05a589eda6bafdf391cf6ad3cb239, 'YFI', 18, 'YFI'),(0x833589fcd6edb6e08f4c7c32d4f71b54bda02913, 'USDC', 6, 'USDC'),(0x4200000000000000000000000000000000000006, 'WETH', 18, 'WETH'),(0x50c5725949a6f0c72e6c4a641f24049a917db0cb, 'DAI', 18, 'DAI'),(0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca, 'USDbC', 6, 'USDbC'),(0x940181a94a35a4569e4529a3cdfb74e38fd98631, 'AERO', 18, 'AERO'),(0x2Da56AcB9Ea78330f947bD57C54119Debda7AF71, 'MOG', 18, 'MOG'),(0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42, 'EUROC', 6, 'EURC'),(0xcbB7C0000aB88B473b1f5aFd9ef808440eed33Bf, 'cbBTC', 8, 'cbBTC'),(0xA88594D404727625A9437C3f886C7643872296AE, 'WELL', 18, 'WELL')),blt_flows AS (SELECTDATE_TRUNC('day', evt_block_time) AS block_date, tokens.symbol, tokens.ticker, SUM(amount / POW(10, tokens.decimals)) AS amountFROM bmx_multichain.vault_evt_increasepoolamount AS increase_poolJOIN tokens ON increase_pool.token = tokens.contract_addressGROUP BY DATE_TRUNC('day', evt_block_time), tokens.symbol, tokens.tickerUNION ALLSELECTDATE_TRUNC('day', evt_block_time) AS block_date, tokens.symbol, tokens.ticker, -SUM(amount / POW(10, tokens.decimals)) AS amountFROM bmx_multichain.vault_evt_decreasepoolamount AS decrease_poolJOIN tokens ON decrease_pool.token = tokens.contract_addressGROUP BY DATE_TRUNC('day', evt_block_time), tokens.symbol, tokens.ticker),recent_prices AS (SELECTDATE_TRUNC('day', minute) AS block_date, symbol, AVG(price) AS avg_priceFROM prices.usdWHERE symbol IN ( SELECT symbol FROM tokens )AND minute >= TIMESTAMP '2021-08-30 00:00'GROUP BY 1,2ORDER BY 1 DESC),token_values AS (SELECTblt_flows.block_date, blt_flows.symbol, recent_prices.avg_price, recent_prices.avg_price * SUM(SUM(amount)) OVER ( PARTITION BY blt_flows.symbol ORDER BY blt_flows.block_date ) AS token_cum_value, recent_prices.avg_price * SUM(amount) AS token_tot_valueFROM blt_flowsINNER JOIN recent_pricesON blt_flows.symbol = recent_prices.symbol AND blt_flows.block_date = recent_prices.block_dateGROUP BY blt_flows.block_date, blt_flows.symbol, recent_prices.avg_priceORDER BY blt_flows.block_date DESC)SELECT