Query editor
---------------------------- USDC ----------------------------WITH-- varlamore_usdc_growth AS (-- SELECT Date, MAX(varlamore_usdc_growth_supply) AS varlamore_usdc_growth_supply-- FROM (-- SELECT-- DATE_TRUNC('day' , evt_block_time) AS Date-- , SUM(assets) OVER (ORDER BY evt_block_time) AS varlamore_usdc_growth_supply-- FROM (-- SELECT-- evt_block_time-- , CAST(assets AS DOUBLE)/1e6 AS assets-- FROM silo_finance_v2_sonic.varlamore_usdc_growth_evt_deposit-- UNION ALL-- SELECT-- evt_block_time-- , - 1 * CAST(assets AS DOUBLE)/1e6 AS assets-- FROM silo_finance_v2_sonic.varlamore_usdc_growth_evt_withdraw))-- WHERE Date >= CAST('2025-05-10 00:00' AS TIMESTAMP)-- GROUP BY 1),-- apostro_usdc AS (-- SELECT Date, MAX(apostro_usdc_supply) AS apostro_usdc_supply-- FROM (-- SELECT-- DATE_TRUNC('day' , evt_block_time) AS Date-- , SUM(assets) OVER (ORDER BY evt_block_time) AS apostro_usdc_supply-- FROM (-- SELECT-- evt_block_time-- , CAST(assets AS DOUBLE)/1e6 AS assets-- FROM silo_finance_v2_sonic.apostro_usdc_evt_deposit-- UNION ALL-- SELECT-- evt_block_time-- , - 1 * CAST(assets AS DOUBLE)/1e6 AS assets-- FROM silo_finance_v2_sonic.apostro_usdc_evt_withdraw))-- WHERE Date >= CAST('2025-05-10 00:00' AS TIMESTAMP)-- GROUP BY 1),-- re7_usdc AS (-- SELECT Date, MAX(re7_usdc_supply) AS re7_usdc_supply-- FROM (-- SELECT-- DATE_TRUNC('day' , evt_block_time) AS Date-- , SUM(assets) OVER (ORDER BY evt_block_time) AS re7_usdc_supply-- FROM (-- SELECT-- evt_block_time-- , CAST(assets AS DOUBLE)/1e6 AS assets-- FROM silo_finance_v2_sonic.re7_usdc_evt_deposit