select block_timestamp::date as fecha,

count(distinct tx_id) as swaps,

count(distinct sender) as unique_users,

count(distinct (concat_ws('-', token0_address,token1_address))) as pairs,

sum(amount0_usd) as volume_swapped

from uniswapv3.swaps

where fecha >= '2022-01-01'

group by fecha

order by fecha

),

TINYMAN as (

select block_timestamp::date as fecha,

count(distinct tx_group_id) as swaps,

count(distinct swapper) as unique_users,

count(distinct concat_ws('-', swap_from_asset_id,swap_to_asset_id)) as pairs

from algorand.swaps

where fecha >= '2022-01-01'

and swap_program = 'tinyman'

group by fecha

order by fecha

),

JUPITER as (

select block_timestamp::date as fecha,

count(distinct tx_id) as swaps,

count(distinct swapper) as unique_users,

count(distinct (concat_ws('-', swap_from_mint,swap_to_mint))) as pairs

--distinct concat_ws('-', 'swap_from_mint','swap_to_mint') as pair

from solana.swaps

where fecha >= '2022-01-01'

and succeeded = 'TRUE'

and swap_program like 'jupiter%'

group by fecha

order by fecha