select

gnosis.core.fact_event_logs.block_timestamp,

gnosis.core.fact_event_logs.tx_hash,

gnosis.core.fact_token_transfers.contract_address,

topics,

event_inputs,

from gnosis.core.fact_event_logs

join gnosis.core.fact_token_transfers on gnosis.core.fact_token_transfers.tx_hash = gnosis.core.fact_event_logs.tx_hash

where gnosis.core.fact_event_logs.origin_function_signature = '0xda75ada3'

and tx_status = 'SUCCESS'

and event_name ilike 'swap'

group by 1, 2, 3, 4, 5, 6

order by 1 desc),

addresses as (

select

date_trunc('day',block_timestamp) as day,

count(*) as swaps

from token

where event_inputs:amount0In::number = raw_amount

group by 1)

select

from addresses