from ethereum.udm_events

where to_address in ('0xdef171fe48cf0115b1d80b88dc8eab59176fee57','0x1bD435F3C054b6e901B7b108a0ab7617C808677b') and from_label_type is null

and to_label_type is null and event_type = 'erc20_transfer'

group by 1),

counts as (select date_trunc('day', block_timestamp) as dt, count(distinct tx_id) as counts

from ethereum.events_emitted

where event_inputs:sender::string in ('0xdef171fe48cf0115b1d80b88dc8eab59176fee57', '0x1bD435F3C054b6e901B7b108a0ab7617C808677b') and tx_succeeded = 'TRUE' and event_name = 'Swap'

group by 1)

select a.dt, a.vol_usd, b.counts

from vol a

left outer join counts b on a.dt = b.dt