oooooblahbayc basic
    Updated 2022-08-21
    with
    bayc_sales as(
    select min(price) as daily_low,
    sum(price) as daily_volume,
    date(block_timestamp)
    from ethereum.core.ez_nft_sales
    where project_name = 'boredapeyachtclub'
    and block_timestamp >= CURRENT_DATE - 90
    group by date(block_timestamp)
    order by date(block_timestamp) desc
    ),
    bayc_transactions as(
    select block_timestamp,
    date(block_timestamp),
    event_type,
    platform_name,
    project_name,
    tokenid,
    price,
    currency_symbol
    from ethereum.core.ez_nft_sales
    where project_name = 'boredapeyachtclub'
    and block_timestamp >= CURRENT_DATE - 90
    and price < 400
    order by price desc
    )


    select * from bayc_transactions where price < (select avg(price)*2 from bayc_transactions)

    Run a query to Download Data