Pine AnalyticsEthersvista 1
Updated 2025-01-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
--SELECT *
--FROM ethereum.core.ez_decoded_event_logs
--FROM ethereum.core.fact_event_logs
--FROM ethereum.core.fact_transactions
--WHERE tx_hash LIKE '0xd2bc6ac2deadf77237f1cbb112743e86087c1d61c3294711f90b0f42ebfd794d'
SELECT
date_trunc('day', block_timestamp) as day,
count(*) as new_pools,
count(DISTINCT ORIGIN_FROM_ADDRESS) as creators,
sum(new_pools) over (order by day) as total_pools
from ethereum.core.fact_event_logs
--where to_address LIKE lower('0xEAaa41cB2a64B11FE761D41E747c032CdD60CaCE')
--WHERE tx_hash LIKE '0x365731d0d32631e2a7ccd7e63af9b5c988862fe1b11d982c3a45cca8ad3d2171'
WHERE contract_address like '0x9a27cb5ae0b2cee0bb71f9a85c0d60f3920757b4'
--limit 100
GROUP BY 1
order by 1
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived