Query editor
with claims as (selecttx_hash,block_time,tx_from as player,bytearray_to_int256(substring(data from 1 for 32)) as tokenid,bytearray_to_int256(substring(data from 65 for 32))/1e18 as amountfrom abstract.logswhere contract_address = 0x06D7Ee1D50828Ca96e11890A1601f6fe61F1e584and topic0 = 0x9cdcf2f7714cca3508c7f0110b04a90a80a3a8dd0e35de99689db74d28c5383eand block_time > cast('2025-02-10' as timestamp)),upgrade_tx as (selectblock_time,hash as tx_hashfrom abstract.transactionswhere to = 0x06D7Ee1D50828Ca96e11890A1601f6fe61F1e584and substring(data from 1 for 4) = 0x1228f555),upgrade_cost as (selectevt_tx_hash as tx_hash,sum(value)/1e18 as amount,count(*) as num_upgradesfrom erc20_abstract.evt_transferwhere contract_address = 0x33EE11cE309854a45B65368C078616ABcb5c6e3dand to = 0x06D7Ee1D50828Ca96e11890A1601f6fe61F1e584group by 1),upgrade_combo as(selectdate_trunc('day', t.block_time) as day,count(*) as num_txs,count(distinct(t.tx_hash)) as num_tx_check,sum(c.amount) as tokens_spent,sum(c.num_upgrades) as num_level_upsfrom upgrade_tx tleft join upgrade_cost c on t.tx_hash = c.tx_hashgroup by 1),claims_daily as (selectdate_trunc('day', c.block_time) as day,sum(c.amount) as hero_claimed,count(distinct(c.player)) as unique_address_claiming,count(distinct(c.tokenid)) as unique_hero_claimingfrom claims cgroup by 1),corn_integrated AS (SELECTevt_block_time, "from" as wallet, -1 as helperFROM erc721_abstract.evt_TransferWHERE contract_address = 0x7c47ea32fd27d1a74fc6e9f31ce8162e6ce070eband not to = 0x06D7Ee1D50828Ca96e11890A1601f6fe61F1e584UNION ALLSELECTevt_block_time, to as wallet, +1 as helperFROM erc721_abstract.evt_Transfer