SELECT
DATE_TRUNC('day', t.block_timestamp) AS day,
COUNT(*) AS transaction_count,
AVG(p.price) AS avg_price
FROM
near.core.fact_transactions t
JOIN
near.price.ez_prices_hourly p
ON
DATE_TRUNC('day', t.block_timestamp) = p.hour
WHERE
p.SYMBOL = 'SWEAT'
GROUP BY
DATE_TRUNC('day', t.block_timestamp)
ORDER BY
day