Query editor
WITH UniqueAddresses AS (SELECTDISTINCT SUBSTRING(topic1 FROM 13 FOR 20) AS address,date_trunc('minute', block_time AT TIME ZONE 'UTC') AS block_timeFROMethereum.logsWHEREcontract_address = 0xf19308f923582a6f7c465e5ce7a9dc1bec6665b1AND topic0 = 0x2109b8587b0ddbd9adf8ec24ce76bef548f2aee7aac34bc6aa0bb51b7cba9d67),SinceLaunch AS (SELECTCOUNT(DISTINCT address) AS UniqueAddressesSinceLaunchFROMUniqueAddresses),TodayContractDay AS (SELECTCOUNT(DISTINCT address) AS UniqueAddressesSinceTodayContractDayFROMUniqueAddressesWHEREblock_time BETWEEN CURRENT_TIMESTAMP - INTERVAL '1' day + INTERVAL '7' hour + INTERVAL '15' minute + INTERVAL '23' second AND CURRENT_TIMESTAMP),YesterdayContractDay AS (SELECTCOUNT(DISTINCT address) AS UniqueAddressesSinceYesterdayContractDayFROMUniqueAddressesWHEREblock_time BETWEEN CURRENT_TIMESTAMP - INTERVAL '2' day + INTERVAL '7' hour + INTERVAL '15' minute + INTERVAL '23' second AND CURRENT_TIMESTAMP - INTERVAL '1' day + INTERVAL '7' hour + INTERVAL '15' minute + INTERVAL '23' second),Last24Hours AS (SELECTCOUNT(DISTINCT address) AS UniqueAddressesLast24HFROMUniqueAddressesWHEREblock_time > CURRENT_TIMESTAMP - INTERVAL '1' day),Previous24Hours AS (SELECTCOUNT(DISTINCT address) AS UniqueAddressesPrevious24HFROMUniqueAddressesWHEREblock_time BETWEEN CURRENT_TIMESTAMP - INTERVAL '2' day AND CURRENT_TIMESTAMP - INTERVAL '1' day),Last7Days AS (SELECTCOUNT(DISTINCT address) AS UniqueAddressesLast7DFROMUniqueAddressesWHEREblock_time > CURRENT_TIMESTAMP - INTERVAL '7' day),Previous7Days AS (SELECTCOUNT(DISTINCT address) AS UniqueAddressesPrevious7DFROM