-- INTERACTION W SHOP CONTRACT

select

block_timestamp,

tx_hash,

origin_from_address as interacted_wallet

from blast.core.fact_event_logs

where true

and contract_address = '0xca4a0be8d75435ae10eb5a98ca91d35740682fd0'

union all

-- INTERACTION W GM CONTRACT

-- GM contract origin_function_signature list :

-- tempted - 0x7f4a9f30, tempt result - 0x77a084dd, lvl up - 0x0ce90ec2, eat - 0xb31625ac, feed - 0x679569e5, buy tofu - 0x60a06040, gift - 0x91a7a738, open gift - 0x1ef21e08.

-- One-off : renounce / grant role - 0x36568abe / 0x2f2ff15d, update tempt / level map - 0x033d3675 / 0xb6463ee0, update level cost - 0x43635284.

select

block_timestamp,

tx_hash,

origin_from_address as interacted_wallet

from blast.core.fact_event_logs

where true

and contract_address = '0x20a0284330d130d9d2b7a8ee238ec521233101ea'

-- exclude tempt result, because we ald track tempted method. Not sure tempt result method gets the defender address

and origin_function_signature != '0x77a084dd'

select date_trunc('day', block_timestamp) as date_time, count (distinct interacted_wallet) as no_active_players

from interactions

where date_time >= '2024-03-25'

group by 1