elvisAll EVM Block stats (2023 06-07)
Updated 2023-08-02
999
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
›
⌄
WITH EVM_tx_data as (
SELECT 'Ethereum' as blockchain,
1 as Llama_ID,
'ethereum' as currency,
block_timestamp, tx_hash, status, from_address, gas_price
FROM ethereum.core.fact_transactions
WHERE block_timestamp >= '2023-06-01'
AND block_timestamp < '2023-08-01'
UNION
SELECT 'BSC' as blockchain,
2 as Llama_ID,
'bnb' as currency,
block_timestamp, tx_hash, status, from_address, gas_price
FROM bsc.core.fact_transactions
WHERE block_timestamp >= '2023-06-01'
AND block_timestamp < '2023-08-01'
UNION
SELECT 'Arbitrum' as blockchain,
3 as Llama_ID,
'ethereum' as currency,
block_timestamp, tx_hash, status, from_address, gas_price_paid as gas_price
FROM arbitrum.core.fact_transactions
WHERE block_timestamp >= '2023-06-01'
AND block_timestamp < '2023-08-01'
UNION
SELECT 'Optimism' as blockchain,
4 as Llama_ID,
'ethereum' as currency,
block_timestamp, tx_hash, status, from_address, gas_price
FROM optimism.core.fact_transactions
WHERE block_timestamp >= '2023-06-01'
AND block_timestamp < '2023-08-01'
UNION
SELECT 'Polygon' as blockchain,
5 as Llama_ID,
'matic' as currency,
Run a query to Download Data