LTirrellNFTs Whale with metadata
    Updated 2023-08-02
    with
    large_sales as (
    select
    block_timestamp,
    marketplace,
    tx_id,
    purchaser,
    mint,
    sales_amount,
    p.close as sol_price,
    (sales_amount * sol_price) as usd_amount,
    l.address_name,
    l.label,
    l.label_subtype,
    l.label_type
    from
    solana.core.fact_nft_sales
    join solana.core.ez_token_prices_hourly p on date_trunc(hour, block_timestamp) = p.recorded_hour
    left join solana.core.dim_labels l on l.address = mint
    where
    date(block_timestamp) >= current_date() -30
    and p.token_address = 'So11111111111111111111111111111111111111112'
    and usd_amount >= 1000
    and succeeded = 'true'
    order by
    block_timestamp desc
    ),
    mints as (
    select distinct
    mint as m
    from
    large_sales
    ),
    mints_with_rn as (
    select
    m,
    Run a query to Download Data