zakkisyedENS top sales daily on Opensea
    Updated 2021-12-24


    with top_sales_daily as
    (
    select distinct e1.tx_id, e1.block_timestamp, e1.event_platform,e1. event_type, e1.project_name, e1.price_usd, e2.event_inputs
    --e2.token_name, e2.token_metadata
    from
    (
    select *
    from ethereum.nft_events
    where event_platform = 'opensea' AND event_type = 'sale'
    AND project_name = 'ens'
    AND block_timestamp > current_date - interval '24 hour'
    AND price_usd != 0
    order by price_usd desc
    ) as e1

    INNER JOIN ethereum.events_emitted as e2
    ON e1.tx_id = e2.tx_id

    )


    select * from top_sales_daily
    order by top_sales_daily.price_usd desc
    Run a query to Download Data