marqusol nft wash - [marketplaces] organic volume over time
    Updated 2025-01-23
    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
    DATE
    MARKETPLACE
    COUNT
    SOL
    1
    2024-12-08 00:00:00.000magic eden68713369.811142137
    2
    2024-11-11 00:00:00.000magic eden103044124.670551211
    3
    2024-12-11 00:00:00.000magic eden83606043.475119736
    4
    2025-01-13 00:00:00.000hadeswap27442.81662376
    5
    2024-11-29 00:00:00.000solsniper8412.94538
    6
    2024-11-01 00:00:00.000tensor28123.24851895
    7
    2024-12-01 00:00:00.000tensor86.23
    8
    2024-11-01 00:00:00.000tensorswap196226352.640575378
    9
    2025-01-16 00:00:00.000tensorswap70662014.697599318
    10
    2025-01-20 00:00:00.000magic eden53743630.4329705
    11
    2024-11-24 00:00:00.000solsniper8123.2834514
    12
    2024-11-10 00:00:00.000solsniper10246.8340571
    13
    2024-10-31 00:00:00.000tensor2144.61645435
    14
    2024-11-14 00:00:00.000solanart25
    15
    2024-11-29 00:00:00.000tensor114.22499
    16
    2024-12-23 00:00:00.000tensor1329.962
    17
    2024-12-08 00:00:00.000solanart10.03
    18
    2024-12-19 00:00:00.000tensorswap1260610512.712113175
    19
    2024-11-15 00:00:00.000tensorswap73675184.051419967
    20
    2024-11-27 00:00:00.000magic eden61203843.951651853
    ...
    514
    28KB
    519s