oooooblahUntitled Query
    Updated 2022-08-22
    with lil_pudgy_sales as (
    select block_timestamp, platform_name, project_name, price from ethereum.core.ez_nft_sales where nft_address = loweR('0x524cAB2ec69124574082676e6F654a18df49A048') and block_timestamp >= CURRENT_DATE - 2
    ),
    flowers_sales as (
    select block_timestamp,

    platform_name,
    price,
    case when nft_address = loweR('0x7D8820FA92EB1584636f4F5b8515B5476B75171a') then 'Mari Flowers' end as project
    from ethereum.core.ez_nft_sales
    where nft_address = loweR('0x7D8820FA92EB1584636f4F5b8515B5476B75171a')
    and block_timestamp >= CURRENT_DATE - 2
    )



    select * from flowers_sales
    Run a query to Download Data