SocioCryptocontract_address: most frequently used
    Updated 2023-06-01
    SELECT contract_address,
    address_name,
    label_type,
    label_subtype,
    project_name,
    count(DISTINCT tx_hash) as n_txns
    FROM optimism.core.fact_event_logs a
    LEFT JOIN optimism.core.dim_labels b
    ON a.contract_address = b.address
    WHERE date_trunc('day',block_timestamp) = current_date-1
    GROUP BY contract_address,address_name, label_type,label_subtype,project_name
    ORDER BY n_txns DESC
    LIMIT 10
    Run a query to Download Data