freemartianTop Users Based on Purchase Volume
Updated 2 hours ago
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH collections AS (
SELECT
value:address AS collection_address,
value:name AS collection_name
FROM (
SELECT livequery.live.udf_api('https://raw.githubusercontent.com/mehdimarjan/magiceden-on-monad/refs/heads/main/collections.json') AS response
), LATERAL FLATTEN (input => response:data)
),
transactions AS (
-- ======= single sale =======
select
el.block_timestamp,
el.tx_hash,
el.origin_from_address AS buyer,
tr.value AS amount,
count(*) as nft_count,
'MON' as token_paid,
1 as rank,
FROM monad.testnet.fact_event_logs el
LEFT JOIN monad.testnet.fact_transactions tr ON (el.tx_hash = tr.tx_hash)
WHERE
el.origin_to_address = '0x0000000000000068f116a894984e2db1123eb395'
AND el.contract_address <> '0x0000000000000068f116a894984e2db1123eb395'
AND el.origin_function_signature = '0xe7acab24'
AND el.tx_succeeded
-- AND el.block_timestamp::date > current_date - 30
group by
el.block_timestamp,
el.tx_hash,
tr.to_address,
el.origin_from_address,
tr.value
union all
-- ======= bulk sale (single buyer) =======
Last run: about 2 hours agoAuto-refreshes every 1 hour
...
1000
1MB
882s