flipside

    LAIKA copy copy copy copy
    Pine AnalyticsLAIKA copy copy copy copy
    Updated 2025-03-19
    -- forked from LAIKA copy copy copy @ https://flipsidecrypto.xyz/studio/queries/32ca6ead-eb58-40f6-bacf-1c46dd7b8b55

    -- forked from LAIKA copy copy @ https://flipsidecrypto.xyz/studio/queries/da1cf40e-594f-433c-a6ab-752a193c5c84

    -- forked from LAIKA @ https://flipsidecrypto.xyz/studio/queries/ba5e8765-0df7-4940-abaf-a5c09258abb4

    with tab1 as (
    SELECT
    tx_id,
    signers
    FROM
    eclipse.core.fact_transactions t,
    TABLE(FLATTEN(log_messages)) f
    where
    value like 'Program log: INVARIANT: SWAP'
    and SUCCEEDED
    ),
    tab2 as (
    SELECT
    block_timestamp,
    a.tx_id as tx_out,
    signers [0] as wallet_out,
    mint as mint_out,
    case
    when mint in (
    'So11111111111111111111111111111111111111112',
    'Eth1111111111111111111111111111111111111111'
    ) then 'ETH'
    when mint like 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE' then 'USDC'
    when mint like '841P4tebEgNux2jaWSjCoi9LhrVr9eHGjLc758Va3RPH' then 'WIF'
    when mint like 'BeRUj3h7BqkbdfFU7FBNYbodgf8GCHodzKvF9aVjNNfL' then 'SOL'
    when mint like 'GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn' then 'tETH'
    when mint like 'LaihKXA47apnS599tyEyasY2REfEzBNe4heunANhsMx' then 'LAIKA'
    when mint like 'trbts2EsWyMdnCjsHUFBKLtgudmBD7Rfbz8zCg1s4EK' then 'Turbo'
    else 'Other'
    end as token_out,
    Last run: about 1 month ago
    WALLET_OUT
    VOLUME_USD
    SWAPS
    1
    9rXhiXGzY4Jht77LAPTz2jYVwmsGVcA3e3Ur4U64hkYR
    		40012594.871216766
    2
    97Qhv1jG8G5M47FvkvaZCu9y4oVfgdTPHFqtpVjRZ2k2
    		28481062.61387734565
    3
    5X3To2fubqEmyDjbVzaSjYRsnP8Vs93hscBUSFbHwWdR
    		11284891.12896283062
    4
    H9QLYG5nr8LcygMWMpvGypSHyywcj2H5vYxeCgRzYvAt
    		6021656.238732633686
    5
    F1kHCTwQ68DPYnyQRA4ayiou4VfbTpbzxhCRWiU3HZg4
    		5384522.634705753127
    6
    45UXt6Y3zcHZUXFYWj8GCxe1wDBrQyVAJS3AfxiVjznZ
    		5049448.6708482313250
    7
    C6ChsVfbKwigHNtKbYiP493KLbQLUnpD6wgyay6AXBXf
    		4840557.845430661802
    8
    3AmqJ9UMxHPMWVTg7TUUH3SktMamebkUFEv53sfJECZY
    		4704989.421922321429
    9
    urtfw65ARUMneY2nddtCXkTtcasJnKpdkJ15RaYRpfo
    		4122553.129307332838
    10
    BtGH2WkM1oNyPVgzYT51xV2gJqHhVQ4QiGwWirBUW5xN
    		3122263.79181728506
    11
    CcrusvQssLDSfsfvWsbViKrb9f5sWtVx9FDmcMJMzTF8
    		2745172.082193671130
    12
    BEYRYh1CpamPdE8k1B5QrFTfhQVjaEPyZC2P4zLgTedD
    		2506440.368957674333
    13
    4VE4S3d8uVb3gPc6U9McAjnkarjSw8En2ps8y1dtqYQW
    		2256139.10195442770
    14
    L1TqCPtWxkfyRx2TymBHVMRBM3M44UEL7zEtpGNwMxr
    		2208033.63519521906
    15
    FkAxnPrvQmuptSLR6vEKzpYDBMfSd5higYBMvRchcYPU
    		2162923.1847755748
    16
    9FGJotQyq86rGaFD8ZyjP2vvWskMqPAtyypPGkARKFWF
    		2058378.65276065753
    17
    FyHWxUAdDy2PqfCqf3teRKanHjjsAAoNz3UxcY9heMsM
    		1981555.6918389898
    18
    42YQzriGXmqZGoedcyvrMQn6zz3uuHjRiBqadJG9ircY
    		1873576.293367134298
    19
    DZqN1XFCseT4sf7nABgeaEgY6U8DwxErnS6XkVD7rb3G
    		1859564.26879881786
    20
    BarRnWCcE3E5LvevF8esVL5GsAvSirtHhLSj7pEfm5aZ
    		1802018.44028133597
    ...
    100000
    6MB
    1119s