date(block_timestamp) as day,

count(distinct tx_id) as no_of_swaps,

count(distinct swapper) as no_of_wallets,

sum(swap_to_amount) as total_tokens_swapped,

avg(swap_to_amount) as avg_tokens_swapped

from

solana.core.fact_swaps

JOIN solana.core.dim_labels

ON solana.core.fact_swaps.swap_to_mint = solana.core.dim_labels.address

SUCCEEDED = true and label='aurory'

GROUP BY

day

ORDER BY

day asc