Query editor
with addresses_list as(SELECTCONTRACT_ADDRESS,DECIMALS,SYMBOLFROM TOKENS.ERC20WHERE BLOCKCHAIN = 'ethereum'AND CONTRACT_ADDRESS IN ((0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48) /* USDC */,(0xdAC17F958D2ee523a2206206994597C13D831ec7) /* USDT */))selecttime,sum(cast(amounts as double)) as net,sum(cast(amounts as double)) filter(where amounts >=0) as mints,sum(cast(amounts as double)) filter(where amounts < 0) as burnsfrom (selectdate_trunc('day', evt_block_time) as time,eth.symbol,-sum(value/pow(10, decimals)) as amountsfrom erc20_ethereum.evt_transfer as trleft join addresses_list as ethon eth.contract_address = tr.contract_addresswhere tr.contract_address in(select contract_address from addresses_list)and "to" = 0x0000000000000000000000000000000000000000and evt_block_time >= timestamp '2017-01-01'group by 1,2union allselectdate_trunc('day', evt_block_time) as time,eth.symbol,sum(value/pow(10, decimals)) as amountsfrom erc20_ethereum.evt_transfer as trleft join addresses_list as ethon eth.contract_address = tr.contract_addresswhere tr.contract_address in(select contract_address from addresses_list)and "from" = 0x0000000000000000000000000000000000000000and evt_block_time >= timestamp '2017-01-01'group by 1,2union allselectdate_trunc('day', evt_block_time) as time,eth.symbol,-sum(value/pow(10, decimals)) as amountsfrom erc20_ethereum.evt_transfer as trleft join addresses_list as ethon eth.contract_address = tr.contract_addresswhere tr.contract_address in(select contract_address from addresses_list where symbol = 'USDT')and "to" = 0xc6cde7c39eb2f0f0095f41570af89efc2c1ea828and evt_block_time >= timestamp '2017-01-01'