fb3ce38c-7bfe-475c-bca8-3f1e44ae80a6DD_Contract_table
Updated 2023-08-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
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