PREVIEW / futures_1hour / 2025-03-31
file: by_date/futures_1hour/2025/2025-03-31.parquet size: 69 KB rows: 2,129
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-31 00:00:00 | ES | Futures | 5669.67 | 5679.32 | 5667.89 | 5677.54 | 7527.0 |
| 2025-03-31 01:00:00 | ES | Futures | 5677.29 | 5682.11 | 5672.97 | 5676.02 | 9603.0 |
| 2025-03-31 02:00:00 | ES | Futures | 5675.76 | 5678.56 | 5666.36 | 5671.95 | 13367.0 |
| 2025-03-31 03:00:00 | ES | Futures | 5671.44 | 5680.08 | 5662.55 | 5677.8 | 26616.0 |
| 2025-03-31 04:00:00 | ES | Futures | 5677.8 | 5681.86 | 5662.3 | 5663.06 | 27319.0 |
| 2025-03-31 05:00:00 | ES | Futures | 5663.06 | 5667.89 | 5652.39 | 5659.0 | 30224.0 |
| 2025-03-31 06:00:00 | ES | Futures | 5659.0 | 5666.62 | 5655.95 | 5662.55 | 16319.0 |
| 2025-03-31 07:00:00 | ES | Futures | 5662.81 | 5665.86 | 5641.72 | 5652.65 | 33480.0 |
| 2025-03-31 08:00:00 | ES | Futures | 5652.9 | 5665.09 | 5647.06 | 5664.33 | 36612.0 |
| 2025-03-31 09:00:00 | ES | Futures | 5664.33 | 5667.63 | 5623.18 | 5652.39 | 263386.0 |
| 2025-03-31 10:00:00 | ES | Futures | 5652.65 | 5675.76 | 5649.09 | 5671.7 | 264391.0 |
| 2025-03-31 11:00:00 | ES | Futures | 5671.95 | 5697.36 | 5667.89 | 5688.97 | 209903.0 |
| 2025-03-31 12:00:00 | ES | Futures | 5688.97 | 5702.44 | 5674.75 | 5688.97 | 155124.0 |
| 2025-03-31 13:00:00 | ES | Futures | 5689.23 | 5708.03 | 5682.62 | 5687.19 | 134507.0 |
| 2025-03-31 14:00:00 | ES | Futures | 5687.19 | 5736.22 | 5685.67 | 5720.22 | 214321.0 |
| 2025-03-31 15:00:00 | ES | Futures | 5720.22 | 5764.42 | 5719.71 | 5747.66 | 463033.0 |
| 2025-03-31 16:00:00 | ES | Futures | 5747.66 | 5748.93 | 5731.91 | 5735.72 | 90752.0 |
| 2025-03-31 18:00:00 | ES | Futures | 5735.46 | 5736.73 | 5716.66 | 5730.13 | 17836.0 |
| 2025-03-31 19:00:00 | ES | Futures | 5730.13 | 5736.99 | 5722.51 | 5726.82 | 10736.0 |
| 2025-03-31 20:00:00 | ES | Futures | 5726.57 | 5726.82 | 5711.07 | 5717.17 | 14445.0 |
| 2025-03-31 21:00:00 | ES | Futures | 5716.92 | 5723.27 | 5710.06 | 5722.0 | 10839.0 |
| 2025-03-31 22:00:00 | ES | Futures | 5722.0 | 5731.91 | 5720.22 | 5731.65 | 8569.0 |
| 2025-03-31 23:00:00 | ES | Futures | 5731.65 | 5733.18 | 5723.52 | 5724.54 | 6794.0 |
| 2025-03-31 00:00:00 | NQ | Futures | 19557.08 | 19595.28 | 19538.74 | 19587.38 | 4809.0 |
| 2025-03-31 01:00:00 | NQ | Futures | 19586.87 | 19617.69 | 19575.92 | 19596.55 | 5778.0 |
| 2025-03-31 02:00:00 | NQ | Futures | 19595.28 | 19604.95 | 19550.97 | 19577.96 | 9424.0 |
| 2025-03-31 03:00:00 | NQ | Futures | 19576.94 | 19623.8 | 19555.81 | 19618.96 | 14772.0 |
| 2025-03-31 04:00:00 | NQ | Futures | 19618.71 | 19630.93 | 19560.13 | 19561.92 | 11905.0 |
| 2025-03-31 05:00:00 | NQ | Futures | 19560.9 | 19591.2 | 19520.15 | 19553.26 | 13202.0 |
| 2025-03-31 06:00:00 | NQ | Futures | 19553.51 | 19589.17 | 19539.76 | 19573.63 | 8828.0 |
| 2025-03-31 07:00:00 | NQ | Futures | 19574.65 | 19586.62 | 19474.32 | 19527.54 | 19224.0 |
| 2025-03-31 08:00:00 | NQ | Futures | 19528.81 | 19580.76 | 19504.88 | 19578.22 | 18005.0 |
| 2025-03-31 09:00:00 | NQ | Futures | 19577.71 | 19594.77 | 19329.93 | 19444.52 | 110865.0 |
| 2025-03-31 10:00:00 | NQ | Futures | 19445.29 | 19524.74 | 19410.65 | 19495.71 | 110527.0 |
| 2025-03-31 11:00:00 | NQ | Futures | 19495.71 | 19622.27 | 19469.48 | 19579.23 | 88881.0 |
| 2025-03-31 12:00:00 | NQ | Futures | 19578.47 | 19645.19 | 19531.1 | 19574.9 | 62572.0 |
| 2025-03-31 13:00:00 | NQ | Futures | 19575.41 | 19667.09 | 19564.97 | 19580.51 | 59201.0 |
| 2025-03-31 14:00:00 | NQ | Futures | 19580.25 | 19777.35 | 19575.92 | 19708.6 | 83165.0 |
| 2025-03-31 15:00:00 | NQ | Futures | 19708.34 | 19852.48 | 19706.05 | 19811.99 | 121287.0 |
| 2025-03-31 16:00:00 | NQ | Futures | 19811.73 | 19816.57 | 19753.16 | 19774.3 | 20012.0 |
| 2025-03-31 18:00:00 | NQ | Futures | 19772.52 | 19775.06 | 19686.44 | 19735.59 | 8397.0 |
| 2025-03-31 19:00:00 | NQ | Futures | 19735.34 | 19768.19 | 19699.94 | 19718.53 | 6504.0 |
| 2025-03-31 20:00:00 | NQ | Futures | 19719.29 | 19725.15 | 19651.56 | 19678.04 | 7995.0 |
| 2025-03-31 21:00:00 | NQ | Futures | 19677.53 | 19706.31 | 19642.13 | 19700.7 | 6280.0 |
| 2025-03-31 22:00:00 | NQ | Futures | 19700.7 | 19742.98 | 19695.61 | 19740.68 | 4226.0 |
| 2025-03-31 23:00:00 | NQ | Futures | 19740.94 | 19747.81 | 19714.71 | 19721.84 | 3122.0 |
| 2025-03-31 00:00:00 | YM | Futures | 42884.4 | 42933.8 | 42873.1 | 42919.4 | 574.0 |
| 2025-03-31 01:00:00 | YM | Futures | 42920.4 | 42939.9 | 42887.5 | 42902.9 | 723.0 |
| 2025-03-31 02:00:00 | YM | Futures | 42899.8 | 42922.5 | 42841.1 | 42870.0 | 1415.0 |
| 2025-03-31 03:00:00 | YM | Futures | 42865.8 | 42908.0 | 42793.8 | 42891.6 | 2643.0 |
> showing 50 of 2,129 rows — these rows as CSV