Query editor
WITHink_calls as (SELECTDATE_TRUNC({{time_granularity}}, block_time) as "date","from","to",input,COUNT(DISTINCT tx_hash) as "txns"FROMink.traces trWHEREblock_time >= CAST('{{start_date}}' AS TIMESTAMP)and successand to IN (0xb81131B6368b3F0a83af09dB4E39Ac23DA96C2Db, -- ACRED/USD0x13433B1949d9141Be52Ae13Ad7e7E4911228414e, -- BTC/USD0xe5867B1d421f0b52697F16e2ac437e87d66D5fbF, -- ETH/USD0xb4fe9028A4D4D8B3d00e52341F2BB0798860532C, -- USDT/USD0x58fa68A373956285dDfb340EDf755246f8DfCA16, -- USDC/USD0xD15862FC3D5407A03B696548b6902D6464A69b8c -- SOL/USD)and bytearray_substring(input, 1, 4) NOT IN (0xb7a16251, 0xc8337760, 0xc14c9204)GROUP BY1,2,3,4),to_table as (SELECT 0xb81131B6368b3F0a83af09dB4E39Ac23DA96C2Db as "to", 'ACRED/USD' as "name"UNION ALLSELECT 0x13433B1949d9141Be52Ae13Ad7e7E4911228414e as "to", 'BTC/USD' as "name"UNION ALLSELECT 0xe5867B1d421f0b52697F16e2ac437e87d66D5fbF as "to", 'ETH/USD' as "name"UNION ALLSELECT 0xb4fe9028A4D4D8B3d00e52341F2BB0798860532C as "to", 'USDT/USD' as "name"UNION ALLSELECT 0x58fa68A373956285dDfb340EDf755246f8DfCA16 as "to", 'USDC/USD' as "name"UNION ALLSELECT 0xD15862FC3D5407A03B696548b6902D6464A69b8c as "to", 'SOL/USD' as "name"),function_table AS (SELECT 0xfeaf968c AS function_signature, 'latestRoundData()' AS function_nameUNION ALLSELECT 0x9a6fc8f5 AS function_signature, 'getRoundData()' AS function_nameUNION ALLSELECT 0x668a0f02 AS function_signature, 'latestRound()' AS function_nameUNION ALLSELECT 0x50d25bcd AS function_signature, 'latestAnswer()' AS function_nameUNION ALLSELECT 0x44e02982 AS function_signature, 'getValueForDataFeed()' AS function_nameUNION ALLSELECT 0x1b2758ee AS function_signature, 'getBlockTimestampFromLatestUpdate()' AS function_nameUNION ALLSELECT 0xc14c9204 AS function_signature, 'updateDataFeedsValues()' AS function_nameUNION ALLSELECT 0xc8337760 AS function_signature, 'getDataFeedId()' AS function_nameUNION ALLSELECT 0x26bf15ff AS function_signature, 'getRoundDataFromAdapter(bytes32,uint256)' AS function_nameUNION ALL