PREVIEW / futures_1hour / 2025-03-18
file: by_date/futures_1hour/2025/2025-03-18.parquet size: 66 KB rows: 2,071
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2025-03-18 00:00:00 | ES | Futures | 5804.82 | 5808.12 | 5799.73 | 5802.53 | 4445.0 |
| 2025-03-18 01:00:00 | ES | Futures | 5802.27 | 5806.59 | 5802.02 | 5806.09 | 2275.0 |
| 2025-03-18 02:00:00 | ES | Futures | 5806.09 | 5813.2 | 5804.31 | 5811.93 | 3522.0 |
| 2025-03-18 03:00:00 | ES | Futures | 5811.93 | 5816.5 | 5808.88 | 5812.94 | 6808.0 |
| 2025-03-18 04:00:00 | ES | Futures | 5812.94 | 5828.19 | 5810.4 | 5824.88 | 16983.0 |
| 2025-03-18 05:00:00 | ES | Futures | 5824.88 | 5827.93 | 5815.48 | 5816.25 | 12880.0 |
| 2025-03-18 06:00:00 | ES | Futures | 5815.99 | 5816.75 | 5797.19 | 5812.44 | 21137.0 |
| 2025-03-18 07:00:00 | ES | Futures | 5812.44 | 5817.77 | 5801.26 | 5814.47 | 21643.0 |
| 2025-03-18 08:00:00 | ES | Futures | 5814.47 | 5815.23 | 5796.69 | 5798.46 | 21438.0 |
| 2025-03-18 09:00:00 | ES | Futures | 5798.72 | 5803.54 | 5758.07 | 5759.85 | 194107.0 |
| 2025-03-18 10:00:00 | ES | Futures | 5760.1 | 5773.06 | 5753.24 | 5759.6 | 180561.0 |
| 2025-03-18 11:00:00 | ES | Futures | 5759.85 | 5761.37 | 5742.07 | 5747.4 | 121425.0 |
| 2025-03-18 12:00:00 | ES | Futures | 5747.66 | 5770.52 | 5744.35 | 5760.36 | 111437.0 |
| 2025-03-18 13:00:00 | ES | Futures | 5760.36 | 5767.47 | 5743.34 | 5760.1 | 113575.0 |
| 2025-03-18 14:00:00 | ES | Futures | 5760.1 | 5774.33 | 5748.67 | 5765.95 | 102692.0 |
| 2025-03-18 15:00:00 | ES | Futures | 5765.69 | 5769.5 | 5750.45 | 5763.41 | 170266.0 |
| 2025-03-18 16:00:00 | ES | Futures | 5763.41 | 5770.52 | 5760.1 | 5761.37 | 45768.0 |
| 2025-03-18 18:00:00 | ES | Futures | 5762.14 | 5765.18 | 5751.97 | 5762.64 | 8467.0 |
| 2025-03-18 19:00:00 | ES | Futures | 5762.64 | 5765.44 | 5758.58 | 5764.17 | 3708.0 |
| 2025-03-18 20:00:00 | ES | Futures | 5764.17 | 5781.44 | 5762.9 | 5778.14 | 14043.0 |
| 2025-03-18 21:00:00 | ES | Futures | 5777.89 | 5778.65 | 5772.04 | 5774.08 | 7875.0 |
| 2025-03-18 22:00:00 | ES | Futures | 5774.08 | 5776.87 | 5771.03 | 5771.54 | 5660.0 |
| 2025-03-18 23:00:00 | ES | Futures | 5771.54 | 5774.58 | 5770.27 | 5772.55 | 3074.0 |
| 2025-03-18 00:00:00 | NQ | Futures | 20311.36 | 20327.66 | 20291.5 | 20299.39 | 2121.0 |
| 2025-03-18 01:00:00 | NQ | Futures | 20299.9 | 20325.62 | 20299.39 | 20322.82 | 2535.0 |
| 2025-03-18 02:00:00 | NQ | Futures | 20321.8 | 20352.11 | 20312.12 | 20347.01 | 3064.0 |
| 2025-03-18 03:00:00 | NQ | Futures | 20347.27 | 20361.02 | 20332.5 | 20352.11 | 3497.0 |
| 2025-03-18 04:00:00 | NQ | Futures | 20352.61 | 20411.44 | 20340.14 | 20396.67 | 7108.0 |
| 2025-03-18 05:00:00 | NQ | Futures | 20397.43 | 20410.42 | 20349.81 | 20352.87 | 6680.0 |
| 2025-03-18 06:00:00 | NQ | Futures | 20352.11 | 20357.71 | 20293.28 | 20353.38 | 11507.0 |
| 2025-03-18 07:00:00 | NQ | Futures | 20353.63 | 20369.93 | 20300.41 | 20342.94 | 9643.0 |
| 2025-03-18 08:00:00 | NQ | Futures | 20341.66 | 20348.29 | 20271.38 | 20275.71 | 11667.0 |
| 2025-03-18 09:00:00 | NQ | Futures | 20275.2 | 20300.92 | 20023.09 | 20038.63 | 73707.0 |
| 2025-03-18 10:00:00 | NQ | Futures | 20039.14 | 20101.02 | 19999.92 | 20046.01 | 72725.0 |
| 2025-03-18 11:00:00 | NQ | Futures | 20046.27 | 20068.42 | 19969.11 | 20024.88 | 49904.0 |
| 2025-03-18 12:00:00 | NQ | Futures | 20025.39 | 20121.14 | 20015.45 | 20099.23 | 41203.0 |
| 2025-03-18 13:00:00 | NQ | Futures | 20100.0 | 20117.32 | 20018.51 | 20077.84 | 41931.0 |
| 2025-03-18 14:00:00 | NQ | Futures | 20078.61 | 20151.69 | 20023.6 | 20112.99 | 40570.0 |
| 2025-03-18 15:00:00 | NQ | Futures | 20112.48 | 20119.86 | 20028.19 | 20073.77 | 53680.0 |
| 2025-03-18 16:00:00 | NQ | Futures | 20072.75 | 20104.33 | 20067.15 | 20070.71 | 13690.0 |
| 2025-03-18 18:00:00 | NQ | Futures | 20071.48 | 20090.07 | 20032.26 | 20074.79 | 5147.0 |
| 2025-03-18 19:00:00 | NQ | Futures | 20075.55 | 20085.74 | 20052.63 | 20076.32 | 3094.0 |
| 2025-03-18 20:00:00 | NQ | Futures | 20075.3 | 20165.95 | 20073.01 | 20144.05 | 7869.0 |
| 2025-03-18 21:00:00 | NQ | Futures | 20143.54 | 20154.49 | 20129.54 | 20138.2 | 5303.0 |
| 2025-03-18 22:00:00 | NQ | Futures | 20139.47 | 20147.87 | 20120.63 | 20121.9 | 4504.0 |
| 2025-03-18 23:00:00 | NQ | Futures | 20122.15 | 20142.53 | 20121.64 | 20131.07 | 3083.0 |
| 2025-03-18 00:00:00 | YM | Futures | 43343.4 | 43361.9 | 43321.8 | 43337.2 | 658.0 |
| 2025-03-18 01:00:00 | YM | Futures | 43340.3 | 43360.9 | 43335.1 | 43349.6 | 404.0 |
| 2025-03-18 02:00:00 | YM | Futures | 43352.6 | 43385.6 | 43339.3 | 43378.4 | 532.0 |
| 2025-03-18 03:00:00 | YM | Futures | 43375.3 | 43401.0 | 43355.7 | 43375.3 | 1138.0 |
> showing 50 of 2,071 rows — these rows as CSV