StangFASToverall of $HON holders overtime
    Updated 2024-02-13
    -- forked from @ https://flipsidecrypto.xyz/edit/queries/b4899e58-1733-48a1-b665-64a4e74e8823

    -- forked from 03 - distribution @ https://flipsidecrypto.xyz/edit/queries/46f572c5-c5ab-417f-9ce5-c44b6568d0d4

    -- forked from 01 - holder overview copy @ https://flipsidecrypto.xyz/edit/queries/b105808d-c575-45bf-aba9-ad6f604516bb

    -- forked from 01 - holder overview @ https://flipsidecrypto.xyz/edit/queries/a78035f2-dd42-4c60-a35f-7e6257eb3514

    with

    hon AS
    (
    SELECT
    a.address AS address
    , a.symbol AS symbol
    , a.name AS name
    , a.decimals AS decimals
    FROM
    avalanche.core.dim_contracts a
    WHERE
    a.address = lower( '0xEd2b42D3C9c6E97e11755BB37df29B6375ede3EB' )
    )
    ,
    hon_price AS
    (
    SELECT
    date_trunc( 'day' , a.hour ) AS day
    , avg( a.price ) AS price_usd
    , a.token_address AS token
    FROM
    avalanche.price.fact_hourly_token_prices a
    INNER JOIN
    hon b
    ON a.token_address = b.address
    GROUP BY 1 , 3
    ORDER BY 1 DESC LIMIT 1
    Last run: about 1 year ago
    address
    address name
    label type
    address type
    balance
    % of supply
    value
    1
    0xfa83d7888ae8b0a41fe4043733b28aa7c99f1b92heroes of nft: general contractnft 🟠 : contract address 43,349,355 $HON 32.53 %$ 1,044,427
    2
    0xdaef7fa6ce5aed1f5a9349d9f8e39f54e5f1b17a-- 🟢 : user address 33,279,640 $HON 24.97 %$ 801,815
    3
    0xdb87ba23c60e5fe6514f352a30b1170494045221trader joe wrapped avax/hontokendex 🟠 : contract address 12,911,915 $HON 9.69 %$ 311,090
    4
    0xafddc5ba9394186bde3fc98f019a91533731d4cb-- 🟢 : user address 11,225,029 $HON 8.42 %$ 270,448
    5
    0x643de20f8227d01deaa10331749aa19117728398heroes of nft: general contractnft 🟠 : contract address 5,325,500 $HON 4.00 %$ 128,309
    6
    0xe535542a7f1c836a277b18626b670dfc62721b9f-- 🟢 : user address 4,086,056 $HON 3.07 %$ 98,446
    7
    0x69a30d078e2e7be3874e65045e14e1c2faa4c989-- 🟢 : user address 2,414,921 $HON 1.81 %$ 58,183
    8
    0x670d49fa5a80f57eef65a1fd6cb9792cfc7d4be3-- 🟢 : user address 2,009,306 $HON 1.51 %$ 48,411
    9
    0xbd262fe718f79591258414b99a561ecc4a12b2dd-- 🟢 : user address 1,680,003 $HON 1.26 %$ 40,477
    10
    0xfbdbc5774fd483f69007591b819ba0ca27f379f6-- 🟢 : user address 1,637,588 $HON 1.23 %$ 39,455
    11
    0x9d900889a1a5ade0bd2b29eabdc99e734724bd71-- 🟢 : user address 1,017,660 $HON 0.76 %$ 24,519
    12
    0x238626a38d19bf63b1ef0eddc93e28148e6844fb-- 🟢 : user address 1,004,780 $HON 0.75 %$ 24,208
    13
    0x9fa643d80093a3fc7b2bc7baed33512d9dc77abdheroes of nft: general contractnft 🟠 : contract address 914,385 $HON 0.69 %$ 22,031
    14
    0xd19c4637df740abcf6ca163ea944cf17818589ddheroes of nft: general contractnft 🟠 : contract address 809,250 $HON 0.61 %$ 19,497
    15
    0xda7c10a23e58a154e2388135a2f3fd53619ea804-- 🟢 : user address 783,333 $HON 0.59 %$ 18,873
    16
    0x20b66f4bda4426a93de632c74b879dfa77fb6a03heroes of nft: general contractnft 🟠 : contract address 546,125 $HON 0.41 %$ 13,158
    17
    0xfb4334a5704e29df37efc9f16255759670018d9a-- 🟢 : user address 467,841 $HON 0.35 %$ 11,272
    18
    0x4d3f8959dcb15062eea3b4448da4f6e99b6cd0f9-- 🟢 : user address 448,767 $HON 0.34 %$ 10,812
    19
    0x59a78fb1e199fcb59c1a2a02112d320ba9caaeee-- 🟢 : user address 442,950 $HON 0.33 %$ 10,672
    20
    0x7b86ae45eaeb75faf518f81be827f5e799133ae7-- 🟢 : user address 306,076 $HON 0.23 %$ 7,374
    100
    15KB
    25s