StangFASTy001 - distribution transactions
    Updated 2024-02-13
    -- 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
    (
    SELECT
    Last run: about 1 year ago
    type
    user
    total users
    1
    a : only 1 time2424
    2
    b : < 5 times2953
    3
    c : < 10 times457
    4
    d : < 20 times461
    5
    e : < 30 times162
    6
    f : > 30 times163
    6
    147B
    12s