mmdrezatoken balance
    Updated 2024-11-18
    with tab3 as (with tab2 as (with tab1 as (select
    distinct owner
    from solana.core.fact_token_balances
    where date(block_timestamp) = '2024-11-18'
    and mint = 'HwPtbFpd3VTe3tfyosoVtPf9WPuSk5gAKkN5xp6Npump')

    select
    distinct owner
    from solana.core.fact_token_balances
    where mint = '9EwutmiMiLHoH5hj5aCLMDJUdsLZVg926ZmDdr8Ppump'
    and owner in (select * from tab1)
    and date(block_timestamp) = '2024-11-18')

    select
    distinct owner
    from solana.core.fact_token_balances
    where mint = 'AEDEBKCEkxHvFx69vKD8EmZ7VqmhAqobubfgMt32pump'
    and owner in (select * from tab2)
    and date(block_timestamp) = '2024-11-18')

    select
    distinct owner
    from solana.core.fact_token_balances
    where mint = 'HMoUMwXmqQM7Yrfv2xFTKwQDqBKwRTJikFzxg4mepump'
    and owner in (select * from tab3)
    and date(block_timestamp) = '2024-11-18'

    Last run: about 1 month ago
    OWNER
    1
    AQ8wxdKgzh52prLydqhXh8UrceY3yxWcYZi1FY7qY8y3
    2
    DUDXQZEkm93dpcLuVr9SiZN5CJ5FYFBajJn9TjzHk6n
    3
    4ghQMFuxob6iWj3iVoQWioamwToMrbr3NJYCumAEijVW
    4
    DEn2j8DNyekiASionGDkWpWdYEKSwMPhnFQr3bXApBYw
    5
    6duiChQ8yLiS7N3UzF2QSbQTNGiuYEh6updcYm8bBNNf
    6
    J8T6eSs7PgLPtRhMo3wBDMuUB5E3fkTV3Be44XigyJtG
    7
    EzxmY5juADjqdMJTrzrJXjZ5bNHF6YhemfA1bfSefkti
    8
    HGrKwRCvtt9VjCsuiveFqLCEKEvywroG1kA6VK6wxvfF
    9
    FJd9vmNmSPFGPA24Dt81Gamwz7pvKi1HPaTkRcUh5Dys
    10
    4og3a8E2UaqQYSkFVbuFoZGia6WiNc1vJYS8sQcebnn9
    11
    AixdwT5jz1soiMoVCvSfp6LstYdLsVRgUMinFQCELdiq
    12
    KVn4tcRajCBHWygggxz1Bw1cjc45tG6qws5HVwAv85V
    13
    CxYPnnNtPLWk7786J8d3Rurk6dgbcgZV1fT17V4Ry1D9
    14
    A81JmiRvddewqnYPbiMvm3P8ATm7vAMKbpruDxDsJkhn
    15
    MpRCRTWZJCNhSvGyZZF5PQiQbLGcxa7ot8YL2x33Vwa
    16
    2J6kAPi27Wf8zaHYbteGXXiyKfo4TqGnR4GEWrhck21B
    17
    8qgMmnDvKJTQVkQCmZPvpNS6aoh1urHMD2o8YPZEWR3M
    18
    EDeootJdhJ1AtAehSKKcqqmB1aFGMse1NF4TVQtiPJ8Y
    19
    G7gw9zsGtn26CkB8M7GVAbF1oQ81L6jEwW9FxiUQasWn
    20
    4zEcmRcQLsDng8BhPgjJTqjYkAtkigMnqu9JTnpaabCF
    ...
    718
    34KB
    4s