Query editor
with base_contracts as (-- old token launcherselectvarbinary_ltrim(varbinary_substring(data, 33, 32)) as token_addressfrom base.logswhere contract_address = 0x94Bf9622348Cf5598D9A491Fa809194Cf85A0D61-- newPersona Eventand topic0 = 0xf9d151d23a5253296eb20ab40959cf48828ea2732d337416716e302ed83ca658union all-- 2nd old token launcherselectvarbinary_ltrim(varbinary_substring(data, 33, 32)) as token_addressfrom base.logswhere contract_address = 0x5706d5A36c2Cc90a6d46E851efCb3C6Ac0372EB2-- newPersona Eventand topic0 = 0xf9d151d23a5253296eb20ab40959cf48828ea2732d337416716e302ed83ca658union all-- bonding contractselectvarbinary_ltrim(varbinary_substring(data, 33, 32)) as token_addressfrom base.logswhere contract_address = 0x71B8EFC8BCaD65a5D9386D07f2Dff57ab4EAf533-- newPersona Eventand topic0 = 0xf9d151d23a5253296eb20ab40959cf48828ea2732d337416716e302ed83ca658union all-- new token launcher pumpfunselectvarbinary_ltrim(topic1) as token_addressfrom base.logswhere contract_address = 0xF66DeA7b3e897cD44A5a231c61B6B4423d613259-- Launch Eventand topic0 = 0x714aa39317ad9a7a7a99db52b44490da5d068a0b2710fffb1a1282ad3cadae1funion all-- LUNA addressselect *from (values(0x55cD6469F597452B5A7536e2CD98fDE4c1247ee4)) as t (token_address)),vir_cbbtc_txns_into_tax_wallets as (select evt_tx_hash, "value" / power(10,18) as amt, 'virtuals' as currencyfrom erc20_base.evt_transferwhere trueand contract_address = 0x0b3e328455c4059EEb9e3f84b5543F74E24e7E1band "to" = 0x86CbAC9d9Ac726F729eEf6627Dc4817BcBB03A9cand evt_block_time >= timestamp '2024-10-01'union allselect evt_tx_hash, "value" / power(10,8) as amt, 'cbbtc' as currencyfrom erc20_base.evt_transfer