Query editor
withinternal_addrs_eth as (selectaddr from query_3166894 where blockchain = 'ethereum'),internal_addrs_op as (selectaddr from query_3166894 where blockchain = 'optimism'),-- transfers from non-internal to internal addresses (> 0) and vice versa (< 0)-- mint events are included b/c 0x0 is not internal. burns are not supported.transfers_ei_eth as (selectevt_block_time as "time","from", "to",-cast(value as double)/1e18 as amountFROM erc20_ethereum.evt_Transfer trwhere contract_address = 0x163f8C2467924be0ae7B5347228CABF260318753and "from" in (select addr from internal_addrs_eth)and "to" not in (select addr from internal_addrs_eth)UNION ALLselectevt_block_time as "time","from", "to",cast(value as double)/1e18 as amountFROM erc20_ethereum.evt_Transfer trwhere contract_address = 0x163f8C2467924be0ae7B5347228CABF260318753and "to" in (select addr from internal_addrs_eth)and "from" not in (select addr from internal_addrs_eth)),transfers_ei_op as (selectevt_block_time as "time","from", "to",-cast(value as double)/1e18 as amountFROM erc20_optimism.evt_Transfer trwhere contract_address = 0xdC6fF44d5d932Cbd77B52E5612Ba0529DC6226F1and "from" in (select addr from internal_addrs_op)and "to" not in (select addr from internal_addrs_op)UNION ALLselectevt_block_time as "time","from", "to",cast(value as double)/1e18 as amountFROM erc20_optimism.evt_Transfer trwhere contract_address = 0xdC6fF44d5d932Cbd77B52E5612Ba0529DC6226F1and "to" in (select addr from internal_addrs_op)and "from" not in (select addr from internal_addrs_op)),correction_terms as (-- correction terms for lockups not visible on chainselect *from query_3681469where "time" <= now()),foundation_team_liquid as (select cast("date" as timestamp) as "date",foundation_team_liquid as amountfrom dune.worldcoin.token_unlocks_summary