headitmanagerAre there any trends with these collections
    Updated 2022-04-25
    with tokens as (select
    distinct event_inputs:token::string as token
    from Ethereum_core.fact_event_logs
    where contract_address='0x85aa7f78bdb2de8f3e0c0010d99ad5853ffcfc63'
    and event_name = 'Mint'
    )
    , Deposit as (select tx_hash from Ethereum_core.fact_event_logs where contract_address in (select token from tokens) and event_name = 'Deposit'
    )
    , Approval as (select tx_hash from Ethereum_core.fact_event_logs where tx_hash in (select tx_hash from Deposit) and event_name = 'Approval'
    )
    , Transfer as (select * from Ethereum_core.fact_event_logs where tx_hash in (select tx_hash from Approval) and event_name = 'Transfer'
    )
    select count(*),contract_address,date(block_timestamp) from Transfer
    where contract_address in
    ('0x417cf58dc18edd17025689d13af2b85f403e130c','0xbb3d13260b3f6893ace34a4284be70eccf4cc0f1',
    '0xfd082f6e5fc7cf1b6393969c64bf4d7cff774e7a','0xc22616e971a670e72f35570337e562c3e515fbfe','0xb159f1a0920a7f1d336397a52d92da94b1279838')
    group by contract_address,date(block_timestamp)


    Run a query to Download Data