0x_jeanOptimism Transaction Volume
Updated 2023-01-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
⌄
⌄
⌄
/* SELECT
block_timestamp,
eth_value,
from_address,
tx_fee,
tx_hash,
tx_json
FROM
optimism.core.fact_transactions
WHERE
status = 'SUCCESS'
AND eth_value > 0
LIMIT 100 */
/* SELECT *
FROM optimism.core.dim_contracts
LIMIT 100 */
/* SELECT
tx_json,
tx_hash,
tx_json:receipt:logs[0]:decoded:contractName
FROM
optimism.core.fact_transactions
WHERE
block_timestamp >= CURRENT_DATE - 6
AND tx_hash = '0x1029bc8ec65098dc731e762d4a7e11737cca132a0b95d144911bc1da713110f7'
LIMIT 20 */
/* with tx_data as (
SELECT
block_timestamp as date,
contract_address as contract,
Run a query to Download Data