adambalaUntitled Query
    Updated 2022-06-23
    WITH
    hop AS (
    SELECT address
    FROM ethereum_core.dim_labels
    WHERE address_name ilike '%hop protocol%'
    ),
    bridge_to_wallet AS (SELECT date_trunc('day',block_timestamp) as date,
    contract_address,
    tx_hash ,EVENT_INPUTS:"amount"/pow(10,18)
    FROM ethereum_core.fact_event_logs
    WHERE
    event_name='TransferSentToL2'
    and contract_address in (select address from hop )
    limit 5 )select* from bridge_to_wallet
    Run a query to Download Data