kaibladeMerge data
    Updated 2022-09-25
    -- 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