KaskoazulTop 20 wallets activity programs
    Updated 2022-03-09
    WITH TOP20_ACTIVITY AS (
    SELECT
    t.tx_id,
    t.tx_from_address as wallet,
    t.program_id,
    l.address_name,
    l.label,
    l.label_subtype,
    l.label_type
    FROM
    solana.transactions t
    INNER JOIN solana.labels l
    ON t.program_id = l.address
    WHERE
    block_timestamp >= '2022-02-01'
    AND wallet IN ('5vzjFqyZ2mgm7EryL82EWCeGwykJCC6FkqyXEx3MTPsu',
    '6HFxHT4tFVB19weeMGYQrepa51rzxjydkhWAaomsf6g4',
    '9qZwCKnNCTbZD91B34gk8XX3aPn4wALbUZiL3YpVBEvK',
    'DyLrwLtfhFGo2mbr2Dx4LPDcTvrgsV6wZsdpphHUgH3r',
    '2asR4HQHhZrMHq4vGykzSHhRqhMZq9Q6C6Wb3JKgjg55',
    'CkkKEC59UsmfxZTGmsgfSdy1UEox69NNhuD5nPjitqKM',
    '8xg9H6GfxBN2nmbEkf4LBD1sWJct2LfsVpCDKKn8tc3M',
    'D3KNHjYntZcZtQrCjJkT1nmMpCirvTZCbLf2t9y4FnR6',
    '2j1554XSRq9ByBb2m1xoxQf2FaA1mAv9UZLoD7dgedt1',
    'B9ytpw6fHdGVDGxY9NhwJeKQyqStRGzcWkaEaRQb4LT1',
    '4zYicQNY8FGdNcimLr9RAY8Q6eGN6SyQHu4ssC8MoG1o',
    'DHDRgcrqY7VWd6kzbD7GogJAeetcMrVH2u6xqEn83KNU',
    'HCMezjwENhcgPfxpTfUhL4USCXNC8cHCYe191qx4sQYZ',
    '9fkenN9cVyYgdmuRiPKGUbm88dDih9YxFMjXNJsHgrrJ',
    'C3DGZ4yMo6PU1vJ47hLJAxDoUjJpms6TFPTnKFGwMWuL',
    'D2y6VMajt6yS4a2Kek3pUqDxerDQWhF8FJNgEsaVD4dy',
    '3MPBiNkw8u4Hf2vL4NpRQkatbpde14eLBjjenzpTLNR5',
    '55J4kCCGa8D5mcmpTYZi6868a35gN3JhHr1tNWR6Topg',
    '99FrbDQBhdFbnoji8LiTMgVahMUSwM12xgk68d8oC5XK',
    '2vqqAXy1b7adhu4oYZNgrgeW5m1efaLuo86DTZFNyX84')
    )
    Run a query to Download Data