WITH dayly_summary AS (

SELECT

DATE_TRUNC('day', block_timestamp) AS day,

SUM(amount) AS dayly_amount_sent,

COUNT(DISTINCT tx_id) AS num_swaps,

COUNT(DISTINCT tx_from) AS unique_senders,

COUNT(DISTINCT tx_to) AS unique_receivers

FROM

solana.core.fact_transfers

WHERE

mint = 'ErGB9xa24Szxbk1M28u2Tx8rKPqzL6BroNkkzk5rG4zj'

AND block_timestamp >='2024-02-12'

AND tx_to = '9yiH3GuyuQF9Q5edRdbhKxfXdxmervr8DnGF2Z8FLa7c'

GROUP BY

day

SELECT *

FROM dayly_summary

ORDER BY day DESC;