oooooblahparallel_legendaries
    Updated 2023-11-29
    select
    block_timestamp,
    platform_name,
    tokenid,
    currency_symbol,
    price,
    price_usd,
    CASE
    WHEN tokenid = '10842' THEN 'Ottius'
    WHEN tokenid = '10395' THEN 'Magna'
    WHEN tokenid = '10947' THEN 'Akara'
    WHEN tokenid = '10867' THEN 'Tane'
    WHEN tokenid = '10309' THEN 'JRJ'
    ELSE NULL
    END AS Name
    from
    ethereum.nft.ez_nft_sales
    where
    (
    tokenid = '10395'
    or tokenid = '10842'
    or tokenid = '10947'
    or tokenid = '10867'
    or tokenid = '10309'
    )
    AND nft_address = lower('0x76be3b62873462d2142405439777e971754e8e77')
    and date(block_timestamp) > '2023-09-01'
    and price_usd < 600
    Run a query to Download Data