Query editor
WITHconstants AS (SELECT0xd218103918c19d0a10cf35300e4cfafbd444c5fe AS clearinghouse),spot_products AS (SELECTCAST(json_extract_scalar(p, '$.product_id') AS bigint) AS product_id,CAST(from_hex(substr(lower(json_extract_scalar(p, '$.config.token')), 3)) AS varbinary) AS tokenFROM UNNEST(CAST(json_extract(json_parse(http_get('https://gateway.prod.nado.xyz/query?type=all_products')),'$.data.spot_products') AS array(json))) AS t(p)WHERE json_extract_scalar(p, '$.config.token') IS NOT NULL),token_meta AS (SELECTsp.product_id,sp.token,e.decimals,e.name,e.symbol,e.contract_addressFROM spot_products spJOIN tokens.erc20 eON e.blockchain = 'ink'AND e.contract_address = sp.token),daily_delta AS (SELECTtm.product_id,tm.token,CAST(DATE_TRUNC('day', t.evt_block_time) AS date) AS day,SUM(CASEWHEN t."to" = (SELECT clearinghouse FROM constants) THEN t.valueWHEN t."from" = (SELECT clearinghouse FROM constants) THEN -t.valueELSE 0END) AS delta_rawFROM erc20_ink.evt_Transfer tJOIN token_meta tmON tm.token = t.contract_addressWHERE t."to" = (SELECT clearinghouse FROM constants)OR t."from" = (SELECT clearinghouse FROM constants)GROUP BY 1, 2, 3),bounds AS (SELECTproduct_id,token,MIN(day) AS start_day,