granadohoOpensea Shared Mint vs Foundation Token Transfer Volume
    Updated 2022-04-23
    (select
    block_timestamp::date as date,
    'Foundation' as platform,
    count(distinct tx_hash) as token_transfer_vol
    from ethereum_core.fact_event_logs
    where contract_address = '0x3b3ee1931dc30c1957379fac9aba94d1c48a5405'
    and event_name = 'Transfer'
    group by 1
    order by 1)
    union
    (select
    block_timestamp::date as date,
    'Opensea Shared Mint' as platform,
    count(distinct tx_hash) as token_transfer_vol
    from ethereum_core.fact_event_logs
    where event_name = 'TransferSingle'
    and contract_address = '0x495f947276749ce646f68ac8c248420045cb7b5e'
    group by 1
    order by 1)
    Run a query to Download Data