with app_events as (

SELECT

block_timestamp

, tx_hash

, from_address as tx_signer

, to_address as tx_receiver

, 'earn-lockups' as cat

from near.core.ez_token_transfers

WHERE 1=1

AND block_timestamp::date BETWEEN '2024-11-01' AND '2024-11-30'

AND contract_address = 'wallet.kaiching'

AND to_address= 'earn.kaiching'

AND from_address= 'hotwallet.kaiching'

UNION ALL

SELECT

block_timestamp

, tx_hash

, from_address as tx_signer

, to_address as tx_receiver

, 'redemptions' as cat

from near.core.ez_token_transfers

WHERE 1=1

AND block_timestamp::date BETWEEN '2024-11-01' AND '2024-11-30'

AND contract_address = 'wallet.kaiching'

AND to_address= 'hotwallet.kaiching'

AND from_address ilike '%users.kaiching'

UNION ALL

SELECT

block_timestamp

, tx_hash