USERS | |
|---|---|
1 | 1692 |
jackguy2023-08-03 07:10 PM
Updated 2024-01-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
with tab1 as (
SELECT
tx_hash
FROM base.core.ez_decoded_event_logs
WHERE FULL_DECODED_LOG:name LIKE 'ERC721OrderFilled'
AND contract_address LIKE lower('0xdef1c0ded9bec7f1a1670819833240f027b25eff')
ORDER by block_timestamp
)
SELECT
count(DISTINCT from_address) as users
FROM base.core.fact_transactions
WHERE tx_hash in (SELECT tx_hash from tab1)
Last run: about 1 year agoAuto-refreshes every 3 hours
1
8B
57s