flipside

    BLOCK 2 (cummunity)
    Monitize AIBLOCK 2 (cummunity)
    Updated 2024-07-15
    /*with supplyt as (
    select
    1000000000 as total_supply,
    sum(Holding_Volume) as circulating_supply
    from (
    select
    distinct user_address,
    sum(volume) as Holding_Volume
    from(
    select
    from_address as user_address,
    -1 * amount as volume
    from ethereum.core.ez_token_transfers
    where CONTRACT_ADDRESS = lower('0x8fc17671D853341D9e8B001F5Fc3C892d09CB53A')

    union all

    select
    to_address as user_address,
    amount as volume
    from ethereum.core.ez_token_transfers
    where CONTRACT_ADDRESS = lower('0x8fc17671D853341D9e8B001F5Fc3C892d09CB53A')
    )
    group by user_address
    having sum(volume) > 0
    order by 2 desc
    )
    where user_address not in ('0x9aff9ecbbe5d1261d8f0c98476c0c985902c950c', --tressury
    '0xe8025ee2275e3602bd461dd9eba39fef5246ac1a', --ecosystem reserve
    '0x897f00e052261171f98a69c6a429eecdf86639b8', --inverstors
    '0xdeae6c4d84a79d131e7453895d761532f1ea4e74', --Team
    '0xa2cd89a5af16ddb782f25a4ea1d62777de245108', --stake pools
    '0x478b4de898d3669d6d2d27f73fe2d11d7b837770', --not claimed
    '0x3008670070b4222659d8eacddf53324476f54c88'
    )
    ),*/
    QueryRunArchived: QueryRun has been archived