piperTreats over Time
Updated 2024-04-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
DATE_TRUNC('hour', BLOCK_TIMESTAMP) AS "Date",
COUNT(DISTINCT TX_HASH) AS "Hourly send Treats",
SUM("Hourly send Treats") OVER (ORDER BY "Date") AS "Total send Treats"
FROM
polygon.nft.ez_nft_transfers
WHERE
(
NFT_FROM_ADDRESS = lower('0x324e9b92eA628E7c06741fC75D4A0F58a652A840')
OR
NFT_FROM_ADDRESS = lower('0xD25A945Cf021cD2748eeD53e18CFF50EB8bcFeB0')
)
GROUP BY 1
ORDER BY 1 DESC
Auto-refreshes every 3 hours
QueryRunArchived: QueryRun has been archived