banterlyticsFT V2 tx copy
Updated 2024-05-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
-- forked from FT tx copy @ https://flipsidecrypto.xyz/edit/queries/28b3b059-f595-48e4-a67f-fa36727ad5d9
-- forked from FT tx @ https://flipsidecrypto.xyz/edit/queries/0bed858b-17a5-4832-b34c-a965c35e2c25
SELECT DATE_TRUNC('hour', BLOCK_TIMESTAMP) AS HOUR,
COUNT(*) AS Tx
FROM base.core.fact_transactions
WHERE TO_ADDRESS = lower('0x201e95f275F39a5890C976Dc8A3E1b4Af114E635')
GROUP BY 1
ORDER BY 1 ASC;
QueryRunArchived: QueryRun has been archived