StangFASTy002 - distribution usd volume
    Updated 2024-02-13
    -- forked from y001 - distribution transactions @ https://flipsidecrypto.xyz/edit/queries/8e6da4d8-43b6-47dd-af6b-40bdfe411c1b

    -- forked from 005 - collections @ https://flipsidecrypto.xyz/edit/queries/f2d443ff-3030-4fd6-95c4-d0d127d22360

    -- forked from 004 - type @ https://flipsidecrypto.xyz/edit/queries/8e5d96a9-875f-417d-a333-212e7bc93823

    -- forked from 001 - overview [ chart ] @ https://flipsidecrypto.xyz/edit/queries/55cd8d83-eb49-4819-be1c-ecf3abed0ce7

    with

    hon AS
    (
    SELECT
    a.address AS add
    , a.address_name AS adn
    , a.project_name AS pjn
    FROM
    avalanche.core.dim_labels a
    WHERE
    a.project_name = 'heroes of nft'
    GROUP BY 1 , 2 , 3
    )
    ,
    tkn AS
    (
    SELECT
    date_trunc( 'day' , a.hour ) AS day
    , avg( a.price ) AS price
    , a.token_address AS add
    FROM
    avalanche.price.ez_hourly_token_prices a
    GROUP BY 1 , 3
    ORDER BY 1 DESC
    )
    ,
    type AS
    Last run: about 1 year ago
    type
    user
    total users
    1
    b : < $10 2323
    2
    c : < $25 1336
    3
    d : < $75 945
    4
    e : < $150 449
    5
    f : > $150 1463
    5
    106B
    14s