block_timestamp::date AS day,

SUM(FEE/1000000000) AS sol_fees

FROM SOLANA.core.fact_transactions

WHERE signers = ['{{Wallet}}'] AND block_timestamp > '2024-01-07' AND block_timestamp < '2024-01-08'

GROUP BY day

ORDER BY day DESC