COUNT(DISTINCT FROM_ADDRESS) | |
|---|---|
1 | 62144 |
jackguyopensea sales 3
Updated 2024-01-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with tab1 as (
SELECT
tx_hash
FROM base.core.ez_decoded_event_logs
WHERE contract_address LIKE lower('0x00000000000000ADc04C56Bf30aC9d3c0aAF14dC')
AND event_name LIKE 'OrderFulfilled'
ORDER by block_timestamp
)
SELECT count(DISTINCT from_address)
FROM base.core.fact_transactions
WHERE tx_hash in (SELECT * from tab1)
Last run: about 1 year agoAuto-refreshes every 3 hours
1
9B
63s