flipside

    marketplace
    steven-sabol-dir-of-economymarketplace
    Updated 2025-04-06
    -- forked from decoded program idl chedk @ https://flipsidecrypto.xyz/studio/queries/b1d06073-c4c0-4f28-9ddf-742636cbc34c

    with w1 as (
    -- select
    -- block_timestamp,
    -- tx_id,
    -- value:parsed:info:mint::string as currency,
    -- case WHEN value:parsed:info:destination::string in ('XPqzMnL4K8fvtEeyfu4P6xtBsihXH3QbdQnB6kvp6HK','4JNeLiZwa9AQz6iqfRXAbtZesNrfAHcM6cA7GHCicu6G') THEN
    -- value:parsed:info:tokenAmount:uiAmount end as fee_amount,
    -- case WHEN value:parsed:info:destination::string not in ('XPqzMnL4K8fvtEeyfu4P6xtBsihXH3QbdQnB6kvp6HK','4JNeLiZwa9AQz6iqfRXAbtZesNrfAHcM6cA7GHCicu6G')
    -- THEN value:parsed:info:tokenAmount:uiAmount end as sale_amount,
    -- zeroifnull(fee_amount) + zeroifnull(sale_amount) as money_amount
    -- -- sum(value:parsed:info:tokenAmount:uiAmount) as money_amount
    -- from solana.core.fact_events, lateral flatten(input => inner_instruction:instructions)
    -- WHERE program_id = 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg'
    -- AND succeeded = 'true'
    -- AND value:parsed:info:authority != 'CPnhL83FXTgvRXXtZ2SvDfvNMiJWCqG9rFS75gqoyucP'
    -- AND value:parsed:info:mint::string in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx')
    -- and value:parsed:type = 'transferChecked'
    -- AND fact_events.block_timestamp > '2023-01-01'
    -- group by 1,2,3,4,5

    --- 'STARa4YPDx8D3f64wmkDcgNMahNzB5Acb9Rn7kZPm8U' got to be a star atlas wallet..

    SELECT
    block_timestamp,
    tx_id,
    MAX(value:parsed:info:mint::string) AS currency,

    MAX(CASE
    WHEN value:parsed:info:destination::string IN (
    'XPqzMnL4K8fvtEeyfu4P6xtBsihXH3QbdQnB6kvp6HK',
    '4JNeLiZwa9AQz6iqfRXAbtZesNrfAHcM6cA7GHCicu6G'
    )
    THEN value:parsed:info:tokenAmount:uiAmount
    END) AS fee_amount,
    Last run: 23 days ago
    DATE
    CURRENCY
    MINT
    REFERRAL_USD_VALUE
    VALUE
    SALE_VALUE
    FEE_VALUE
    USD_VALUE
    VOLUME
    CLOSE
    1
    		2023-10-01 00:00:00.000EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1vSDUsgfSZaDhhZ76U3ZgvtFiXsfnHbf2VrzYxjBZ5YbM194.91728561460.24857458125.2862243334.9623561460.248574109187970.005628847993
    2
    		2025-03-01 00:00:00.000ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXxGbnpYifv1QX44PTxYynnB2v9RA9zMz5eZSSm7x2FBvSr01458980.026135611883.668549404110.3203204571993.98886986114745714280.000001352249767
    3
    		2023-10-01 00:00:00.000EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1vCPPRam7wKuBkYzN5zCffgNU17RKaeMEns4ZD83BqBVNR0.920506193.190304184.6848218.505483193.19030479641090.00002425761677
    4
    		2025-03-01 00:00:00.000ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXxGWiduLtgSXx9QgLf8TFmJu1qbw5A1D6oDD8nutU7b5a6032000004294.130219843213.9369210114508.06714085416000000.002817541963
    5
    		2023-10-01 00:00:00.000ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXxCUore1tNkiubxSwDEtLc3Ybs1xfWLs8uGjyydUYZ25xc4.6629672651787032.04540862636.1028119134.9384644812771.0412763813386485970.000008182645081
    6
    		2023-12-01 00:00:00.000EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1vHYDR4EPHJcDPcaLYUcNCtrXUdt1PnaN4MvE655pevBYp3.713988521.662634495.63257626.030058521.6626341558246970.000003347753238
    7
    		2023-12-01 00:00:00.000ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXxMAGNMDeDJLvGAnriBvzWruZHfXNwWHhxnoNF75AQYM513.399824318682193.679670214066.347263257115.5090642184181.8563274751475604180.00002833995989
    8
    		2025-02-01 00:00:00.000ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXxSDUsgfSZaDhhZ76U3ZgvtFiXsfnHbf2VrzYxjBZ5YbM47.9916937796457822.8014796510895.881220507526.66688924611422.548109753449539980.0002540941544
    9
    		2024-01-01 00:00:00.000ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXxRCH1Zhg4zcSSQK8rw2s6rDMVsgBEWa4kiv1oLFndrN514.553999846634928.736017272993.192883786159.7057011923152.8985849771573921640.00002003211917
    10
    		2023-04-01 00:00:00.000EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1vEv3xUhc1Leqi4qR2E5VoG9pcxCvHHmnAaSRVPg485xAT04084.322663861.461989222.8606714084.3226613013.13937176
    11
    		2024-12-01 00:00:00.000ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXxSDUsgfSZaDhhZ76U3ZgvtFiXsfnHbf2VrzYxjBZ5YbM200.5077458047812819.0920743831562.0561512431534.77225594733096.82840719628556990.0005265525471
    12
    		2024-05-01 00:00:00.000ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXxEMAGoQSP89CJV5focVjrpEuE4CeqJ4k1DouQW7gUu7yX44.3164519582146276.446224798042.141761667429.3943709658471.5361326321793072640.00004724591711
    13
    		2023-06-01 00:00:00.000EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v2iMhgB4pbdKvwJHVyitpvX5z1NBNypFonUgaSAt9dtDt02708.8354092557.139134151.6962752708.8354098683.120778121
    14
    		2024-05-01 00:00:00.000EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v8RveLFEyteyL1vbCKPQJxjf3JT1ACyrzs46TXbJStrHG58.94643716973.16256316098.452483874.7100816973.162563149113.913842705
    15
    		2025-04-01 00:00:00.000ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXxC5LrPv75LY7bLbV1ZwzzvTtRdqRUkUfMcDhm1b71rqFX0261776308.81122154914.47174038323.2829619291308880.002469920557
    16
    		2025-03-01 00:00:00.000ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXxFMWKb7YJA5upZHbu5FjVRRoxdDw2FYFAu284VqUGF9C27.6286383611843971.656088672388.506599401110.1028181792498.609417586982942980.000003578160991
    17
    		2024-08-01 00:00:00.000EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1vCPS1gTEio7PqnAmDmWuCfiTBbtDRRsA8cwdQe3TqgGsf460.51665884503.01814980248.4045344254.61361584503.018149253303.336084412
    18
    		2024-08-01 00:00:00.000EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1vRUCHH4AcvodBcndmcT17KUBbd5ee5LQtmpsfvBVNnPH63.79350411069.52117510505.891898563.62927711069.52117528073.943541566
    19
    		2024-08-01 00:00:00.000ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXxPTCLSWbwZ3mqZqHAporphY2ofio8acsastaHfoP87Dc28.1180615052699322.899240984266.736922097231.9242698634498.66119196444392780.0001012316445
    20
    		2023-11-01 00:00:00.000EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v8RveLFEyteyL1vbCKPQJxjf3JT1ACyrzs46TXbJStrHG67.99739943496.34691641252.6601932243.68672343496.346916332131.01309312
    ...
    8930
    2MB
    126s