Berachain (4th Session)

matejchiBerachain (4th Session)

Updated 2024-10-12

-- naključna selekcija `sample` v intervalu

-- SELECT *

-- FROM berachain.testnet.fact_transactions sample (25 rows)

-- WHERE block_timestamp >= sysdate() - interval '7 days'

-- select

-- l.block_number,

-- l.block_timestamp,

-- l.origin_function_signature,

-- l.origin_from_address,

-- l.origin_to_address,

-- contract_address,

-- topics,

-- data,

-- c.symbol,

-- c.name,

-- c.decimals,

-- t.value,

-- t.VALUE_PRECISE

-- from

-- -- berachain.testnet.fact_transactions

-- berachain.testnet.fact_event_logs l

-- left join berachain.testnet.dim_contracts c ON lower(l.contract_address) = lower(c.address)

-- left join berachain.testnet.fact_transactions t ON l.block_number = t.block_number AND l.tx_hash = t.tx_hash

-- -- sample (25 rows)

-- where l.block_timestamp >= sysdate() - interval '8 days'

-- and l.tx_hash = '0x3abf8261c185d1dbc3d5db8b01a45f011c8c9a191c4f45ba5710c96ab325ca14'

--analiza Berachain testnet transferji WETH in WBERA

-- with

-- token_transfers AS (

-- select

-- block_timestamp,

-- tx_hash,

QueryRunArchived: QueryRun has been archived

flipside