Query editor
WITH time_filters AS (SELECTcurrent_timestamp - interval '1' day AS last_24h,current_timestamp - interval '30' day AS last_30d),addresses AS (SELECTfid,from_hex(CAST(JSON_EXTRACT(d.claim, '$.address') AS VARCHAR)) AS extracted_addressFROMdune.neynar.dataset_farcaster_verifications d),unique_users_with_addresses AS (SELECT DISTINCT fidFROM addresses),total_unique_users AS (SELECT COUNT(*) AS total_usersFROM unique_users_with_addresses)SELECTtotal_usersFROMtotal_unique_users;