select

date_trunc('day', block_timestamp) as date,

origin_from_address,

origin_to_address,

event_index,

contract_address,

contract_name,

event_name,

event_inputs,

event_inputs['from'] as from_ad,

event_inputs['to'] as to_ad,

event_inputs['amount'] as amount,

event_inputs['value']/power(10,18) as value_tx

from ethereum.core.fact_event_logs

where contract_address = '0xe340ebfcaa544da8bb1ee9005f1a346d50ec422e'

or contract_address = '0xb460daa847c45f1c4a41cb05bfb3b51c92e41b36'

or contract_address = '0x8eb6c82c3081bbbd45dcac5afa631aac53478b7c'

or contract_address = '0xefaa1604e82e1b3af8430b90192c1b9e8197e377'

or contract_address = '0x85370d9e3bb111391cc89f6de344e80176046183'

or contract_address = '0x32296969ef14eb0c6d29669c550d4a0449130230'),

ap_aad as (

select

*

from ap

where from_ad = '0x1e7267fa2628d66538822fc44f0edb62b07272a4'

or from_ad = '0xc0a893145ad461af44241a7db5bb99b8998e7d2c'

or from_ad = '0xae0baf66e8f5bb87a6fd54066e469cdfe93212ec'

select

date,

sum(value_tx) as daily_amount,

contract_address