Query editor
1SELECT DATE_TRUNC('month', timestamp),2 COUNT(DISTINCT fid)3FROM dune.neynar.dataset_farcaster_casts4WHERE timestamp > cast('2022-07-01' AS timestamp)5GROUP BY 16ORDER BY 1
SELECT DATE_TRUNC('month', timestamp),
COUNT(DISTINCT fid)
FROM dune.neynar.dataset_farcaster_casts
WHERE timestamp > cast('2022-07-01' AS timestamp)
GROUP BY 1
ORDER BY 1