adambalaUntitled Query
Updated 2022-06-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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