Query editor
WITH EVM_DATA AS (SELECTDATE_TRUNC('day', block_time) AS block_date, blockchain, NULL as string_address, "from" as binary_address, NULL as varchar_addressFROMevms.transactionsWHEREblock_time >= NOW() - INTERVAL '365' DAYUNION ALLSELECTDATE_TRUNC('day', block_time) AS block_date, blockchain, NULL as string_address, "to" as binary_address, NULL as varchar_addressFROMevms.transactionsWHEREblock_time >= NOW() - INTERVAL '365' DAY), SOLANA_DATA AS (SELECTDATE_TRUNC('day', block_time) AS block_date, 'solana' as blockchain, NULL as string_address, NULL as binary_address, signer as varchar_addressFROMsolana.transactionsWHEREblock_time >= NOW() - INTERVAL '365' DAY-- UNION ALL-- SELECT-- DATE_TRUNC('day', block_time) AS block_date-- , 'solana' as blockchain-- , NULL as string_address-- , NULL as binary_address-- , account_key as varchar_address-- FROM-- solana.transactions,-- UNNEST(solana.transactions.account_keys) AS account_key-- WHERE-- block_time >= NOW() - INTERVAL '365' DAY), TRON_DATA AS (SELECTDATE_TRUNC('day', block_time) AS block_date, 'tron' as blockchain, NULL as string_address, "from" as binary_address, NULL as varchar_addressFROM