Sandesh1. forefront Top 10 holders
    Updated 2022-03-30
    with forefront_table_latest as
    (
    select * from ethereum.erc20_balances
    where contract_address='0x7e9d8f07a64e363e97a648904a89fb4cd5fb94cd'
    and balance_date = '2022-03-29'
    ),
    top10 as
    (
    select USER_ADDRESS,balance from forefront_table_latest
    order by amount_usd DESC
    limit 10
    )
    select user_address,balance, balance/100000 as "percentage",
    case
    when user_address='0x2fb9f0ef424b24a8d293999298f392a33fe6a8b5' then 'Treasury'
    when user_address='0xc22103115ea757c427788622880be6afb8a4eb64' then 'Team tokens'
    when user_address='0xfe3ea7f424b3cdfe2a3cfeccebc8f4114c955858' then 'Team tokens'
    when user_address='0xc5d5c20ee7ec75292fc58c44972120d403e0decf' then 'Address'
    when user_address='0x52544e5a0c02925eaf874fc539b7717619de0825' then 'Address'
    when user_address='0xd61dbd8ad20de957a7ff9ad4be0782f335cdb688' then 'Address'
    when user_address='0x0028ce89ff53fecc0708000cc9ca8962f3c43b25' then 'Address'
    when user_address='0xd069efa415ef5113598b36619305dbf88dcd363e' then 'Parnter'
    when user_address='0xc8f2cda4243d365db018d5b5207dea5ef200d29f' then 'Parnter'
    when user_address='0x70b0969a069516e117aa777fc87b819d0334a419' then 'Contract'
    else 'Unknown'
    end as "Type of holder"
    from top10
    Run a query to Download Data