tx_hash,

block_timestamp,

decoded_log:depositor as actor,

decoded_log:amount/pow(10,18) as amount,

'Deposit' as action

from bsc.core.ez_decoded_event_logs

where event_name in ('Deposit')

and contract_address in ('0xac4a30d5343fd28afea2ea70b1dea93f35183b18')

and origin_function_signature = '0x6e553f65'

and decoded_log:token = '0x0000000000000000000000000000000000000000'

and tx_status = 'SUCCESS'

and block_timestamp > '2022-08-01'

tx_hash,

block_timestamp,

decoded_log:depositor as actor,

decoded_log:amount/pow(10,18) as amount,

'Withdraw' as action

from bsc.core.ez_decoded_event_logs

where event_name = 'Withdraw'

and contract_address = '0xac4a30d5343fd28afea2ea70b1dea93f35183b18')

and origin_function_signature = '0x00f714ce'

and decoded_log:token = '0x0000000000000000000000000000000000000000'

and tx_status = 'SUCCESS'

and block_timestamp > '2022-08-01'

select

date_trunc('day', block_timestamp::date) as time,

count(tx_hash) as number_of_transaction,