flipside

    Multi ICO
    dethectiveMulti ICO
    Updated 2025-04-07
    WITH token_raises AS (
    SELECT
    tx_from as buyer,
    tx_to AS token,
    sum(amount) as tot_sol_bought
    FROM
    solana.core.fact_transfers
    WHERE
    tx_to IN (
    'BL1gBdtuYRYSepKKpoy1GCNSmS1JeGSiNb7tdB2HQzor',
    '4gHb9tUASDRgpe2vdi6Y2jh8mbSqPCmyf1ZvSUcazKSc',
    '2Y8hZh5on4q9wyqXoNYC8oYPUVQMunrzqW8qDmxup4R8',
    --'5agSjW9MZEXntG9kw8fzY6cPPbdhWGBgKSLXfDLFeEqZ',
    'CZ5aEKMBsiVyAKCig8R2RQYF9T1rPdPDrdonWvS4v6iz',
    '31bbrnPrWKqJYkdHCWPYNBLnAZ3yqRBmLJDtSEwBNgQE',
    'GsjtZXs5cGKSdUoW6CveUu5z7JDT5UL6rPkQEsDwbKww',
    '97xH1PV8zGhMbEZCuMN2TQTCTsZ5HgkvQvm2ncfqT2TZ',
    'E9E6Nxc8DdfLj7vQHLyuXuZxAWYLs3Q5UAaEwByBidz6',
    '6jfC9p4jzTBTGpMrbR8H464kNo1SBGNCW17oDETzSJrf',
    '6JR5Jgy9bTvEeuMh5QKRRPXCWq38s97Eba6PxGvdafTQ',
    'HdENn8wP6srk1AuE2CaJj6bRbjcU2kYs12H4C4HgNAsF'

    )
    AND mint IN (
    'So11111111111111111111111111111111111111112',
    'So11111111111111111111111111111111111111111'
    )
    GROUP BY
    buyer, token
    ),
    buyer_table as
    (SELECT
    r.token,
    r.buyer,
    m.symbol,
    r.tot_sol_bought
    Last run: about 2 months ago
    BUYER
    TOKENS_BOUGHT
    TOKEN_COUNT
    TOTAL_SOL_SPENT
    1
    		5tzFkiKscXHK5ZXCGbXZxdw7gTjjD1mBwuoFbhUvuAi9
    [ "$PAIN", "$SMOLE", "$BOBAOPPA", "$MOONKE", "$GM", "$TOGO", "$SLERF", "$BOME", "$LIKE" ]
    		916347.34947695
    2
    		2CMoyCqHPEjto7Ck6UjF7gawjFF3Jcvbn7UPCW8epuK6
    [ "$GM", "$BOBAOPPA", "$MOONKE", "$PAIN", "$LIKE", "$SLERF", "$TOGO", "$SMOLE" ]
    		811.29
    3
    		AC5RDfQFmDS1deWZos921JfqscXdByf8BKHs5ACWjtW2
    [ "$TOGO", "$SLERF", "$SMOLE", "$PAIN", "$BOME", "$MOONKE", "$BOBAOPPA" ]
    		756.14986375
    4
    		7XDXZMNWgNTi2VhE2xEx1jMxYLp1oN4Wbu3e9hWS6wtm
    [ "$CONDOM", "$BOME", "$MOONKE", "$BOBAOPPA", "$SLERF", "$LIKE", "$SMOLE" ]
    		715
    5
    		H8sMJSCQxfKiFTCfDR3DUMLPwcRbM61LGFJ8N4dK3WjS
    [ "$CONDOM", "$SLERF", "$MOONKE", "$PAIN", "$BOME", "$BOBAOPPA", "$SMOLE" ]
    		746.699599604
    6
    		D2qu5tjBFE3DLxAwd3xRJoYrxDzuTwiehApXbcxNMKWe
    [ "$CONDOM", "$SMOLE", "$BOBAOPPA", "$SLERF", "$PAIN", "$LIKE", "$MOONKE" ]
    		717.5
    7
    		Hk2xajvNqfyZMymirQWSUQps1xQ4WP45Yhrx7nhpWf1G
    [ "$GM", "$BOME", "$LIKE", "$MOONKE", "$SLERF", "$BOBAOPPA", "$SMOLE" ]
    		7114
    8
    		GJRs4FwHtemZ5ZE9x3FNvJ8TMwitKTh21yxdRPqn7npE
    [ "$SMOLE", "$BOME", "$PAIN", "$BOBAOPPA", "$CONDOM", "$MOONKE" ]
    		649.204435939
    9
    		2Nb4iYtP2dBrn6YZCRN9sU5YFzLB9NmZBnNdNRwCxFrn
    [ "$BOME", "$MOONKE", "$SLERF", "$PAIN", "$SMOLE", "$BOBAOPPA" ]
    		618.6
    10
    		5VCwKtCXgCJ6kit5FybXjvriW3xELsFDhYrPSqtJNmcD
    [ "$PAIN", "$LIKE", "$TOGO", "$SLERF", "$SMOLE", "$BOBAOPPA" ]
    		643.65429042
    11
    		BVV4byXfZ3McTtwLRgk9LfuYTm2ErnhpNna4oVw6DvmN
    [ "$BOBAOPPA", "$GM", "$SMOLE", "$LIKE", "$MOONKE", "$SLERF" ]
    		615
    12
    		4LJ4zhTWESb3XCTHUK3cJj3C8qDW77vE9baWE7mB7LSx
    [ "$LIKE", "$GM", "$MOONKE", "$BOBAOPPA", "$SMOLE", "$SLERF" ]
    		621.64
    13
    		fcaUw97hWfzXfV5x5nP6yaK174PV1ekQB1VMDFMa6uw
    [ "$SLERF", "$SMOLE", "$GM", "$MOONKE", "$LIKE", "$BOBAOPPA" ]
    		651
    14
    		2J2gAYC2iuoQeLM6kR31Ar8JAC1f2gKyHY3TeJcVKddh
    [ "$SMOLE", "$SLERF", "$GM", "$LIKE", "$BOBAOPPA", "$MOONKE" ]
    		66.09
    15
    		XpisacyLSyNDQpKe8VG2VT1MJt9sdADhzvcPzZWissJ
    [ "$GM", "$SMOLE", "$LIKE", "$SLERF", "$BOBAOPPA", "$CONDOM" ]
    		6119.8
    16
    		7tjMpWNQGsB36u3eSArDqnEp64xW6G8n6y8bZmN8UWmj
    [ "$BOBAOPPA", "$SLERF", "$GM", "$LIKE", "$BOME", "$SMOLE" ]
    		616
    17
    		6rDi7yasDNk1XArH9feTPdnPV8CsnNr2j5zGkdCkjz4o
    [ "$SLERF", "$MOONKE", "$PAIN", "$BOBAOPPA", "$BOME", "$SMOLE" ]
    		616.5
    18
    		FKbmbqA6uxW77Sxn6taUxDkU6DzQf4GLWZshhymFaWnE
    [ "$GM", "$SMOLE", "$LIKE", "$BOBAOPPA", "$SLERF", "$MOONKE" ]
    		68.5
    19
    		F3R8VSFRyR1LZvkFyinJjmKGrxacv8HMwTzJ3hrghi4L
    [ "$GM", "$BOBAOPPA", "$SLERF", "$LIKE", "$MOONKE", "$BOME" ]
    		625.5
    20
    		8qRxg8NYJJhW3hGw3kQLofaxDsrufdLdXevfwwTpiQQ4
    [ "$SMOLE", "$LIKE", "$MOONKE", "$BOBAOPPA", "$SLERF", "$GM" ]
    		6130
    ...
    79732
    5MB
    10s