sarathop_air3.6
    Updated 2022-09-28
    with contracts as (
    SELECT *
    FROM optimism.core.dim_labels
    where project_name IN (
    'perpetual protocol',
    'synthetix',
    'lyra',
    'chainlink',
    'uniswap',
    'hop protocol',
    'stargate finance',
    'celer',
    'synapse',
    'pika protocol',
    'rubicon',
    'kwenta',
    'thales',
    'polynomial protocol',
    'aelin',
    'zipswap',
    '0x',
    'layer zero',
    'band protocol',
    'clipper',
    'layer2dao',
    'gelato'
    )
    ), tab1 as (
    SELECT
    date_trunc('day', block_timestamp) as day,
    project_name,
    COUNT(DISTINCT tx_hash) as txn,
    count(DISTINCT origin_from_address) as users
    FROM optimism.core.fact_event_logs
    LEFT outer JOIN contracts
    ON address = contract_address
    Run a query to Download Data