StangFAST015 - new and old buyer
    Updated 2024-01-29
    --- 0x00000000000000adc04c56bf30ac9d3c0aaf14dc opensea

    with

    price1 AS
    (
    SELECT
    date_trunc( 'day' , a.hour ) AS date
    , avg( a.price ) AS price
    , a.token_address AS token
    , a.symbol AS symbol
    , a.decimals AS decimal
    FROM
    avalanche.price.ez_hourly_token_prices a
    WHERE
    a.symbol = 'WAVAX'
    GROUP BY 1 , 3 , 4 , 5
    ORDER BY 1 DESC
    )
    ,
    --- mint
    tab1 AS
    (
    SELECT
    a.block_timestamp
    , a.tx_hash
    , b.origin_to_address
    , b.avax_from_address
    , b.avax_to_address
    , a.nft_from_address
    , a.nft_to_address
    , a.project_name
    , a.tokenid
    , b.amount_precise
    , b.amount_usd
    FROM
    Last run: about 1 year ago
    date
    total buyers
    new buyers
    old buyers
    % of new buyers
    1
    2024-01-28 00:00:00.0001026965.8824
    2
    2024-01-27 00:00:00.0001401412610
    3
    2024-01-26 00:00:00.00010110919.901
    4
    2024-01-25 00:00:00.0002387416431.0924
    5
    2024-01-24 00:00:00.0002298714237.9913
    6
    2024-01-23 00:00:00.0002148912541.5888
    7
    2024-01-22 00:00:00.0001965214426.5306
    8
    2024-01-21 00:00:00.0002179012741.4747
    9
    2024-01-20 00:00:00.0002249313141.5179
    10
    2024-01-19 00:00:00.0001795312629.6089
    11
    2024-01-18 00:00:00.0001585210632.9114
    12
    2024-01-17 00:00:00.0002144417020.5607
    13
    2024-01-16 00:00:00.0001502412616
    14
    2024-01-15 00:00:00.0001823614619.7802
    15
    2024-01-14 00:00:00.0002085815027.8846
    16
    2024-01-13 00:00:00.0001442811619.4444
    17
    2024-01-12 00:00:00.0002184317519.7248
    18
    2024-01-11 00:00:00.0001473211521.7687
    19
    2024-01-10 00:00:00.000141131289.2199
    20
    2024-01-09 00:00:00.0001542113313.6364
    ...
    130
    6KB
    94s