DATE | MARKETPLACE | COUNT | SOL | |
---|---|---|---|---|
1 | 2024-12-08 00:00:00.000 | magic eden | 6871 | 3369.811142137 |
2 | 2024-11-11 00:00:00.000 | magic eden | 10304 | 4124.670551211 |
3 | 2024-12-11 00:00:00.000 | magic eden | 8360 | 6043.475119736 |
4 | 2025-01-13 00:00:00.000 | hadeswap | 27 | 442.81662376 |
5 | 2024-11-29 00:00:00.000 | solsniper | 84 | 12.94538 |
6 | 2024-11-01 00:00:00.000 | tensor | 28 | 123.24851895 |
7 | 2024-12-01 00:00:00.000 | tensor | 8 | 6.23 |
8 | 2024-11-01 00:00:00.000 | tensorswap | 19622 | 6352.640575378 |
9 | 2025-01-16 00:00:00.000 | tensorswap | 7066 | 2014.697599318 |
10 | 2025-01-20 00:00:00.000 | magic eden | 5374 | 3630.4329705 |
11 | 2024-11-24 00:00:00.000 | solsniper | 81 | 23.2834514 |
12 | 2024-11-10 00:00:00.000 | solsniper | 102 | 46.8340571 |
13 | 2024-10-31 00:00:00.000 | tensor | 21 | 44.61645435 |
14 | 2024-11-14 00:00:00.000 | solanart | 2 | 5 |
15 | 2024-11-29 00:00:00.000 | tensor | 11 | 4.22499 |
16 | 2024-12-23 00:00:00.000 | tensor | 13 | 29.962 |
17 | 2024-12-08 00:00:00.000 | solanart | 1 | 0.03 |
18 | 2024-12-19 00:00:00.000 | tensorswap | 12606 | 10512.712113175 |
19 | 2024-11-15 00:00:00.000 | tensorswap | 7367 | 5184.051419967 |
20 | 2024-11-27 00:00:00.000 | magic eden | 6120 | 3843.951651853 |
marqusol nft wash - [marketplaces] organic volume over time
Updated 2025-01-23
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
cnft_sales_txs as (
select
block_timestamp
, tx_id
, 'tensorswap' as marketplace
, case
when event_type = 'buy'
then decoded_instruction :accounts[9] :pubkey ::string
when event_type = 'takeBidFullMeta'
then decoded_instruction :accounts[12] :pubkey ::string
when event_type = 'takeBidLegacy'
then decoded_instruction :accounts[3] :pubkey ::string
when event_type = 'takeBidMetaHash'
then decoded_instruction :accounts[12] :pubkey ::string
else null
end as buyer
, case
when event_type = 'buy'
then decoded_instruction :accounts[11] :pubkey ::string
when event_type = 'takeBidFullMeta'
then decoded_instruction :accounts[2] :pubkey ::string
when event_type = 'takeBidLegacy'
then decoded_instruction :accounts[1] :pubkey ::string
when event_type = 'takeBidMetaHash'
then decoded_instruction :accounts[2] :pubkey ::string
else null
end as seller
, case
when event_type = 'buy'
then decoded_instruction :accounts[2] :pubkey ::string
when event_type = 'takeBidFullMeta'
then decoded_instruction :accounts[4] :pubkey ::string
Last run: about 1 month ago
...
514
28KB
519s