Updated 2023-08-14
    SELECT
    c.address,
    c.name,
    c.symbol,
    m.contract_address,
    m.block_timestamp,
    m.origin_from_address,
    m.tx_hash,
    ft.cumulative_gas_used,
    ft.gas_limit,
    ft.gas_price,
    ft.gas_used,
    ft.tx_fee,
    ft.chain_id,
    ft.tx_type


    FROM ethereum.core.dim_contracts c
    LEFT JOIN ethereum.core.fact_event_logs m
    ON c.address=m.contract_address
    LEFT JOIN ethereum.core.fact_transactions ft
    ON ft.tx_hash=m.tx_hash
    WHERE ORIGIN_FROM_ADDRESS ='0x537ce43f03142dabd2e543a7f6a484fe5985364d'
    Run a query to Download Data