kaibladeMerge data
Updated 2022-09-25
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
›
⌄
-- WITH pow_miners AS
-- (SELECT DISTINCT(miner) AS miners
-- FROM ethereum.core.fact_blocks
-- WHERE block_timestamp<'2022-09-15 06:43:00.000')
-- SELECT DISTINCT (miner)
-- FROM ethereum.core.fact_blocks
-- WHERE block_timestamp >= '2022-09-15 06:43:00.000'
-- AND miner NOT IN (SELECT miners FROM pow_miners)
WITH validators AS
(SELECT *
FROM ethereum.core.fact_event_logs
WHERE contract_address ='0x00000000219ab540356cbb839cbe05303d7705fa'),
val_joined AS
(SELECT logs.tx_hash,
logs.block_timestamp,
logs.contract_address,
logs.contract_name,
tx.eth_value,
logs.origin_from_address,
logs.origin_to_address,
logs.event_inputs,
logs.tx_status
FROM ethereum.core.fact_transactions tx
RIGHT JOIN validators logs
ON tx.tx_hash = logs.tx_hash
WHERE tx.eth_value > 0),
raw_real AS
(SELECT ROW_NUMBER() OVER (PARTITION BY tx_hash ORDER BY block_timestamp DESC) AS row_number,
*
FROM val_joined),
daily_val AS
Run a query to Download Data