maybeyonasArtBlocks - daily stats
    Updated 2021-09-08
    with artblocks as(
    select
    contract_address,
    creator_name,
    project_name,
    token_id,
    -- token_metadata,
    token_metadata:platform::string as platform,
    token_metadata:collection_name::string as collection,
    token_metadata:artist::string as artist,
    -- token_metadata:features as traits,
    token_metadata:name::string as nft_name
    from ethereum.nft_metadata
    where
    platform like '%Art Blocks%'
    ),
    art_blocks_events as(
    select
    tx_id,block_timestamp,
    case when price is null then 'transfer' else event_type end as event_type,
    n.contract_address,n.token_id,platform,collection,artist,
    event_from as seller, event_to as buyer,
    tx_currency, price, price_usd
    from ethereum.nft_events n
    inner join artblocks s on s.contract_address = n.contract_address and s.token_id = n.token_id
    ),
    sales as(
    select * from art_blocks_events
    where event_type = 'sale'
    ),
    mints as(
    select * from art_blocks_events
    where event_type = 'mint'
    ),
    over_stats as(
    select
    Run a query to Download Data