flipside

    multi wallet coin sells
    jackiehighnoonmulti wallet coin sells
    Updated 2024-02-02
    SELECT
    SUM(SWAP_TO_AMOUNT) as SOL_GAIN,
    SWAP_FROM_MINT as TOKEN,
    DATE_TRUNC('day', BLOCK_TIMESTAMP) as Date,
    SWAPPER
    FROM
    solana.defi.fact_swaps
    WHERE
    SWAP_TO_MINT = 'So11111111111111111111111111111111111111112' --ONLY SOL TO SPL
    AND SWAPPER IN(
    SELECT
    swapper
    FROM
    solana.defi.fact_swaps
    WHERE
    SWAP_TO_MINT = '{{memecoins}}'
    AND SWAP_FROM_AMOUNT > 0.1
    --token
    ORDER BY
    block_timestamp
    LIMIT
    5
    ) --WALLET DOING SWAPPING
    --AND SWAP_TO_MINT = 'F7tFuW9GGkxNp8HeLgDYV5Z7EDkQUvhknhkN9TqCXaVx' --SPECIFIC COIN
    AND DATE >= current_date - 7
    AND TOKEN != 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    GROUP BY
    swap_from_mint,
    Date,
    SWAPPER
    ORDER BY
    Date
    Last run: about 1 year ago
    SOL_GAIN
    TOKEN
    DATE
    SWAPPER
    1
    		0.4971564946Cs5C85FHBxD1T14LhCpNaCvgDUXeToXhfb6bm5es8tz2024-01-26 00:00:00.000V7bZJGSjSR2KekZi3KFiyjpNqy3DSD3rRmipzdhHEGi
    2
    		0.2544969442TZhyrawGgmB9Mhru1GYpp3mza2vPm3rHtbGdW6A9n1f2024-01-26 00:00:00.000GpDb1yX3o4Zch82qLF7DzvHECQU92SpQ31zESe5QDcHC
    3
    		1.017662016EuJvySEfo6vdz9zc9GsJUF1xD592WgiCcozXVPCfChvA2024-01-26 00:00:00.000GpDb1yX3o4Zch82qLF7DzvHECQU92SpQ31zESe5QDcHC
    4
    		0.5507479616iQU2VikNweQtj6mA5WMCVp7KDhtUtFcwY22PsQ5Ftr62024-01-26 00:00:00.000V7bZJGSjSR2KekZi3KFiyjpNqy3DSD3rRmipzdhHEGi
    5
    		1.4430723G7jg3bA33q8PuuEUjfG82a15JzMpgUMbHspwf1fGwezZ2024-01-26 00:00:00.000GpDb1yX3o4Zch82qLF7DzvHECQU92SpQ31zESe5QDcHC
    6
    		2.874005782HE2PqzJnsqU2epKifvNThioRWRCfDRSSAEafZQG5C8172024-01-26 00:00:00.000V7bZJGSjSR2KekZi3KFiyjpNqy3DSD3rRmipzdhHEGi
    7
    		1.7249854233jckBSUtWbbPPAvkDXeGFEpQn85BNERXdKxZC3vJJBWo2024-01-26 00:00:00.000GpDb1yX3o4Zch82qLF7DzvHECQU92SpQ31zESe5QDcHC
    8
    		10.66826586338CAFkcd2aueDujUBDomQTKrrnNdWSnwyPicztVDovLp2024-01-26 00:00:00.000GpDb1yX3o4Zch82qLF7DzvHECQU92SpQ31zESe5QDcHC
    9
    		3.1512655037bkReV57eFGWNBq72xzhQ5QzhMdUeFDhySKybCK2dRfm2024-01-26 00:00:00.000GpDb1yX3o4Zch82qLF7DzvHECQU92SpQ31zESe5QDcHC
    10
    		1.7942581474rQ3G91vMa9dLuGsQ2pi7iaME2fVewtu61pc7QDygiS82024-01-26 00:00:00.000V7bZJGSjSR2KekZi3KFiyjpNqy3DSD3rRmipzdhHEGi
    11
    		12.7489995719WsedJgKS21a5qg8WqwYZ3t43wWq4EudaKTEa5nqZbJA2024-01-26 00:00:00.000V7bZJGSjSR2KekZi3KFiyjpNqy3DSD3rRmipzdhHEGi
    12
    		20.653420506BySr9SWVMBkRyju8vxTW7ZyLB9AouihS2r5Qy6eyHyHk2024-01-26 00:00:00.000GpDb1yX3o4Zch82qLF7DzvHECQU92SpQ31zESe5QDcHC
    13
    		12.932363268EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v2024-01-26 00:00:00.000V7bZJGSjSR2KekZi3KFiyjpNqy3DSD3rRmipzdhHEGi
    14
    		9.700964678CKc155oUQq72bGx5xMYpnioVjopE8rD6Fyyx7ehcUWsm2024-01-26 00:00:00.000GpDb1yX3o4Zch82qLF7DzvHECQU92SpQ31zESe5QDcHC
    15
    		0.450994754WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk2024-01-26 00:00:00.000V7bZJGSjSR2KekZi3KFiyjpNqy3DSD3rRmipzdhHEGi
    16
    		0.070790887HcD1X1zaQkDmT5MM4UU9Z6fsip27imqkpvcNDRBb5ioW2024-01-26 00:00:00.000V7bZJGSjSR2KekZi3KFiyjpNqy3DSD3rRmipzdhHEGi
    17
    		14.3413233843wyvEBsSfJdFubDF8w8DgXNMt6CGQfhhPFokrxUjFDkn2024-01-26 00:00:00.000GpDb1yX3o4Zch82qLF7DzvHECQU92SpQ31zESe5QDcHC
    18
    		0.690854467xnGzpKpw4NS6uvkGhCKxnxYBKZ4G9hGjhc4ujMtNa7E2024-01-26 00:00:00.000V7bZJGSjSR2KekZi3KFiyjpNqy3DSD3rRmipzdhHEGi
    19
    		18.122486695QBcpLgJyqmntZPDVuxGWhK49yt5wydjDY2VAm5qeQjc2024-01-26 00:00:00.000GpDb1yX3o4Zch82qLF7DzvHECQU92SpQ31zESe5QDcHC
    20
    		0.992287235B7TGP5ez1vBxHJ83jrkN7NFxr2dHB36oJh3Si3G1QFMV2024-01-26 00:00:00.000GpDb1yX3o4Zch82qLF7DzvHECQU92SpQ31zESe5QDcHC
    ...
    948
    124KB
    10s