Ali3NOverview ($JACK Presale on Avalaunch)
    Updated 2025-03-27
    select count (distinct t1.tx_hash) as Registrations,
    count (distinct decoded_log:user) as Registrants,
    sum (amount) as AVAX_Volume,
    sum (amount_usd) as USD_Value,
    avg (amount) as Average_Volume,
    '1000000' as public_sale_distribution,
    '100000000' as total_supply
    from avalanche.core.ez_decoded_event_logs t1 join avalanche.core.ez_native_transfers t2 on t1.tx_hash = t2.tx_hash
    where topic_0 = '0xe29d35093005f4d575e1003753426b57a7f64378ba73332eef9c6ccc2b8decd6'
    and t1.origin_to_address = '0xfae88aed6ceb890a07f23fc567370b11cb583f2d'
    and t1.tx_succeeded

    select *
    from
    Last run: 29 days ago
    REGISTRATIONS
    REGISTRANTS
    AVAX_VOLUME
    USD_VALUE
    AVERAGE_VOLUME
    PUBLIC_SALE_DISTRIBUTION
    TOTAL_SUPPLY
    1
    75975975915340.311000000100000000
    1
    47B
    70s