date(block_timestamp) as txdate,

from_address,

to_address,

symbol,

token_price,

amount,

amount_usd,

_inserted_timestamp

ethereum.core.ez_token_transfers

where (from_address = '0x10a19e7ee7d7f8a52822f6817de8ea18204f2e4f'

and block_timestamp >= '2022-07-01'

and block_timestamp <= '2022-09-30')

order by to_address),

sum_spend as (

select

sum(amount_usd) as total_spent,

count(distinct to_address) as recipients

from all_spend

select *

from all_spend

order by txdate asc