datavikingMoonshot TotalActivity by Token L24H
    Updated 2 days ago
    -- forked from Moonshot TotalActivity by Token @ https://flipsidecrypto.xyz/studio/queries/37bae6ff-263e-45f9-acdf-7abe5869ab2a

    with start_date as (
    select dateadd(hour, -24, current_timestamp()) as start_date
    --select '2024-07-18' as start_date
    --select '{{start_date}}' as start_date
    )
    , moonshot_ca as (
    select '7rtiKSUDLBm59b1SBmD9oajcP8xE64vAGSMbAN5CXy1q' as ca
    , '5wkyL2FLEcyUUgc3UeGntHTAfWfzDrVuxMnaMm7792Gk' as fee_wallet
    )
    , txs as (
    select s.* ,
    t.signers[1] as user_wallet
    from solana.defi.ez_dex_swaps s
    left join solana.core.fact_transactions t on s.tx_id = t.tx_id
    where s.swapper in (select ca from moonshot_ca)
    and s.block_timestamp >= (select start_date from start_date)
    and t.block_timestamp >= (select start_date from start_date)
    )

    , trades as (
    select
    user_wallet,
    DATE_TRUNC('day', block_timestamp) AS tx_day,
    swap_from_mint as mint,
    swap_from_symbol as symbol,
    -(swap_from_amount) as amount,
    -(swap_from_amount_usd) as amount_usd,
    null as buy_amt,
    null as buy_amt_usd,
    swap_from_amount as sell_amt,
    swap_from_amount_usd as sell_amt_usd,
    'sell' as type
    from txs
    where swap_from_mint not in (
    Last run: 2 days ago
    SYMBOL
    EXPLORER
    TXS
    BUY_TXS
    SELL_TXS
    USERS
    TXS_PER_USER
    BUY_AMT
    SELL_AMT
    NET_VOLUME
    BUY_AMT_USD
    SELL_AMT_USD
    NET_VOLUME_USD
    1
    CALICOhttps://solscan.io/token/6sSKobm4TSRqJuXMuczGdV2BZityP76PGBJJ2ALHpump92835227405633202.796084660938914.949487649986271.29545710952643.65402971087400.951132175.65-44774.7
    2
    JAILSTOOLhttps://solscan.io/token/AxriehR6Xw3adzHopnvMn7GcpRFcD41ddpiTWMg6pump57203152256831261.82981419618815.84939118602859.1060351015956.743355991575626.251485164.2390462.02
    3
    https://solscan.io/token/AshG5mHt4y4etsjhKFb2wA2rq1XZxKks1EPzcuXwpump40112807120420311.97488959928002.39739229613401.28976730314601.107625
    4
    HAMMYhttps://solscan.io/token/26KMQVgDUoB6rEfnJ51yAABWWJND8uMtpnQgsHQ64Udr2541152810139792.595506101677422.86304391800397.6379999877025.22504397183846.78188593.94-4747.16
    5
    ETF500https://solscan.io/token/CWX6t6pGJ1zsnuywnyd2ZMZJ7inB2sWuPdsteoT6pump2384144793710702.22803741351623.40808637390810.1439373960813.26414899306270.72295646.1810624.54
    6
    https://solscan.io/token/CDhnDrvo6v32dwHz6DDkc1aqvVTFFCVny1CqWqAUpump2133922121110612.010368726523797.65078626821802.68218199701994.968599
    7
    HOODhttps://solscan.io/token/h5NciPdMZ5QCB5BYETJMYBMpVx9ZuitR6HcVjyBhood9197072126951.322302146655086.31867476738397.71188969916688.60678578768.4640390.4538378.01
    8
    https://solscan.io/token/313t1ZZcLBEmw4uWRjSei1xCDEK4B73KqawJ5xfCpump6084771311663.66265177833849.23627944849492.25904932984356.97723
    9
    SSEhttps://solscan.io/token/H4phNbsqjV5rqk8u6FUACTLB6rNZRTAPGnBb8KXJpump5802623183901.4871797284432.8335455796163.6796811488269.15386492668.4373505.5819162.85
    10
    🐕https://solscan.io/token/DLScRnWofxiYGqnvZWGy9Gt98MPqKdznaK4TRukxpump4923101822282.15789555415724.49783153398964.137882016760.35995137726.6637683.2543.41
    11
    https://solscan.io/token/ch7rTovcUK7C1zNFM7F93kXU2CByYUsJT4pwYx7pump4893761131662.94578373548080.51852345788374.71315327759705.80537
    12
    WOLFhttps://solscan.io/token/Faf89929Ni9fbg4gmVZTca7eW6NFg877Jqn6MizT3Gvw4872812062491.955823112753327.20408107249112.5923025504214.6117780140283.5740808.09-524.52
    13
    https://solscan.io/token/DFG23oVJMtxzExmR8AWaz4atCpmNwuAn25wqhpAdpump4072401671113.66666741435725.36945232343768.7620489091956.607404
    14
    https://solscan.io/token/3n9Dk5r3GWAqPhRtUFmhBxGRQ4cvU7gQ6zJBj4Y9pump3942531411303.03076951441764.58829847443550.6334193998213.95487901
    15
    ARChttps://solscan.io/token/61V8vBaqAGMpgDQi4JcAwo1dmBGHsyhzodcPqnEVpump3522211313291.069909341776.774777188207.980576153568.794201110457.7864968.3945489.39
    16
    https://solscan.io/token/FEj3KUtAXJoRHpStA5k5RxVpAHJuk8eUQ4WqpMyupump346212134704.9428575289288.5032611883845.8153813405442.68788
    17
    https://solscan.io/token/GL8DFZXKhfmoKf3gAQhv5wAkzKFYSBMYgz9wfT5wpump333200133973.4329927983251.10834222846417.4789755136833.62936701
    18
    OIIAOIIAhttps://solscan.io/token/VaxZxmFXV8tmsd72hUn22ex6GFzZ5uq9DVJ5wA5pump3011771241711.7602342652257.8131062344709.026662307548.78644421807.06197372070.06
    19
    BONGOhttps://solscan.io/token/HUdqc5MR5h3FssESabPnQ1GTgTcPvnNudAuLj5J6a9sU2931801131661.765063242799.77886142832326.04143338410473.73742802727146.2825030.142116.14
    20
    USAhttps://solscan.io/token/69kdRLyP5DTRkpHraaSZAQbWmAwzF9guKjZfzMXzcbAs2821111712291.2314415624060905.966416918223152.55632-1294162246.589919149.4811222.82-2073.34
    ...
    1482
    207KB
    13s