1select *
2from @blt.base.blocks
3where year=2023 and month=6 and day=15 AND number=0| hash | number | number_hex | gas_limit | gas_limit_hex | gas_used | gas_used_hex | base_fee_per_gas | base_fee_per_gas_hex | blob_gas_used | blob_gas_used_hex | excess_blob_gas | excess_blob_gas_hex | nonce | difficulty | difficulty_hex | total_difficulty | size | size_hex | parent_hash | requests_hash | miner | parent_beacon_block_root | withdrawals_root | receipts_root | state_root | transactions_root | extra_data | mix_hash | withdrawals | block_timestamp | day | month | year |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0xf712aa9241cc24369b143cf6dce85f0902a9731e70d66818a3a5845b296c73dd | 0 | 0x0 | 30000000 | 0x1c9c380 | 0 | 0x0 | 1000000000 | 0x3b9aca00 | null | null | null | null | 0x0000000000000000 | 0 | 0x0 | null | 546 | 0x222 | 0x0000000000000000000000000000000000000000000000000000000000000000 | null | 0x4200000000000000000000000000000000000011 | null | null | 0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421 | 0xb2afcb88cd1d0ab228f0415d99b0fb90a18e8515daf5eb31f55b5c4697e18328 | 0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421 | 0x616c6c20796f75722062617365206172652062656c6f6e6720746f20796f752e | 0x0000000000000000000000000000000000000000000000000000000000000000 | null | 2023-06-15 00:35:47+00 | 15 | 6 | 2023 |