PREVIEW / futures_1hour / 2025-05-08
file: by_date/futures_1hour/2025/2025-05-08.parquet size: 70 KB rows: 2,115
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-05-08 00:00:00 | ES | Futures | 5788.56 | 5792.62 | 5786.27 | 5789.83 | 6908.0 |
| 2025-05-08 01:00:00 | ES | Futures | 5789.83 | 5791.1 | 5781.44 | 5783.48 | 5419.0 |
| 2025-05-08 02:00:00 | ES | Futures | 5783.22 | 5783.48 | 5774.84 | 5779.41 | 8073.0 |
| 2025-05-08 03:00:00 | ES | Futures | 5779.41 | 5792.11 | 5777.12 | 5784.24 | 13768.0 |
| 2025-05-08 04:00:00 | ES | Futures | 5784.24 | 5798.97 | 5780.94 | 5798.21 | 15911.0 |
| 2025-05-08 05:00:00 | ES | Futures | 5798.46 | 5808.12 | 5796.43 | 5804.05 | 12363.0 |
| 2025-05-08 06:00:00 | ES | Futures | 5804.31 | 5809.64 | 5800.75 | 5809.39 | 12692.0 |
| 2025-05-08 07:00:00 | ES | Futures | 5808.88 | 5809.9 | 5790.33 | 5793.13 | 22843.0 |
| 2025-05-08 08:00:00 | ES | Futures | 5793.38 | 5798.21 | 5773.06 | 5785.25 | 56956.0 |
| 2025-05-08 09:00:00 | ES | Futures | 5785.51 | 5787.03 | 5763.15 | 5769.5 | 106710.0 |
| 2025-05-08 10:00:00 | ES | Futures | 5769.5 | 5779.92 | 5744.35 | 5753.5 | 178301.0 |
| 2025-05-08 11:00:00 | ES | Futures | 5753.5 | 5826.15 | 5747.91 | 5813.71 | 254565.0 |
| 2025-05-08 12:00:00 | ES | Futures | 5813.71 | 5833.78 | 5813.2 | 5831.74 | 123628.0 |
| 2025-05-08 13:00:00 | ES | Futures | 5831.49 | 5832.51 | 5805.32 | 5806.59 | 94009.0 |
| 2025-05-08 14:00:00 | ES | Futures | 5806.34 | 5821.33 | 5803.54 | 5813.2 | 91882.0 |
| 2025-05-08 15:00:00 | ES | Futures | 5813.2 | 5824.63 | 5774.33 | 5778.39 | 244044.0 |
| 2025-05-08 16:00:00 | ES | Futures | 5778.65 | 5785.25 | 5774.33 | 5776.36 | 52505.0 |
| 2025-05-08 18:00:00 | ES | Futures | 5780.43 | 5782.46 | 5773.31 | 5777.63 | 4722.0 |
| 2025-05-08 19:00:00 | ES | Futures | 5777.38 | 5779.92 | 5767.73 | 5771.28 | 5415.0 |
| 2025-05-08 20:00:00 | ES | Futures | 5770.77 | 5771.28 | 5756.8 | 5766.71 | 8896.0 |
| 2025-05-08 21:00:00 | ES | Futures | 5766.96 | 5777.38 | 5765.18 | 5776.62 | 5503.0 |
| 2025-05-08 22:00:00 | ES | Futures | 5776.87 | 5787.79 | 5774.58 | 5776.11 | 6854.0 |
| 2025-05-08 23:00:00 | ES | Futures | 5775.85 | 5783.73 | 5767.98 | 5782.46 | 6417.0 |
| 2025-05-08 00:00:00 | NQ | Futures | 20540.04 | 20573.91 | 20531.64 | 20559.14 | 6135.0 |
| 2025-05-08 01:00:00 | NQ | Futures | 20559.14 | 20571.11 | 20522.47 | 20531.89 | 5652.0 |
| 2025-05-08 02:00:00 | NQ | Futures | 20530.87 | 20535.2 | 20498.53 | 20520.69 | 6354.0 |
| 2025-05-08 03:00:00 | NQ | Futures | 20520.18 | 20568.31 | 20511.26 | 20552.77 | 7818.0 |
| 2025-05-08 04:00:00 | NQ | Futures | 20553.03 | 20607.78 | 20528.83 | 20602.17 | 8058.0 |
| 2025-05-08 05:00:00 | NQ | Futures | 20601.66 | 20639.61 | 20590.46 | 20622.29 | 6250.0 |
| 2025-05-08 06:00:00 | NQ | Futures | 20623.06 | 20634.26 | 20602.94 | 20630.7 | 6821.0 |
| 2025-05-08 07:00:00 | NQ | Futures | 20630.44 | 20634.26 | 20560.67 | 20573.65 | 11007.0 |
| 2025-05-08 08:00:00 | NQ | Futures | 20573.91 | 20602.94 | 20509.23 | 20550.23 | 23188.0 |
| 2025-05-08 09:00:00 | NQ | Futures | 20550.73 | 20559.39 | 20434.36 | 20463.9 | 56867.0 |
| 2025-05-08 10:00:00 | NQ | Futures | 20464.41 | 20498.79 | 20350.83 | 20389.79 | 71634.0 |
| 2025-05-08 11:00:00 | NQ | Futures | 20389.03 | 20694.61 | 20365.35 | 20650.3 | 101734.0 |
| 2025-05-08 12:00:00 | NQ | Futures | 20650.3 | 20715.75 | 20645.97 | 20710.15 | 45240.0 |
| 2025-05-08 13:00:00 | NQ | Futures | 20709.38 | 20714.22 | 20623.57 | 20627.64 | 36696.0 |
| 2025-05-08 14:00:00 | NQ | Futures | 20626.88 | 20695.89 | 20610.83 | 20661.25 | 36909.0 |
| 2025-05-08 15:00:00 | NQ | Futures | 20661.51 | 20709.64 | 20516.1 | 20527.31 | 72018.0 |
| 2025-05-08 16:00:00 | NQ | Futures | 20528.07 | 20555.06 | 20518.39 | 20531.38 | 16538.0 |
| 2025-05-08 18:00:00 | NQ | Futures | 20532.14 | 20558.12 | 20511.77 | 20536.22 | 4299.0 |
| 2025-05-08 19:00:00 | NQ | Futures | 20535.96 | 20547.42 | 20498.53 | 20514.06 | 4599.0 |
| 2025-05-08 20:00:00 | NQ | Futures | 20513.05 | 20514.83 | 20454.48 | 20496.24 | 6146.0 |
| 2025-05-08 21:00:00 | NQ | Futures | 20496.24 | 20535.96 | 20486.56 | 20533.93 | 4143.0 |
| 2025-05-08 22:00:00 | NQ | Futures | 20535.2 | 20576.96 | 20523.74 | 20528.32 | 5956.0 |
| 2025-05-08 23:00:00 | NQ | Futures | 20527.05 | 20565.25 | 20498.79 | 20560.16 | 5373.0 |
| 2025-05-08 00:00:00 | YM | Futures | 42655.9 | 42678.5 | 42637.4 | 42663.1 | 633.0 |
| 2025-05-08 01:00:00 | YM | Futures | 42665.2 | 42672.4 | 42626.1 | 42636.3 | 655.0 |
| 2025-05-08 02:00:00 | YM | Futures | 42632.2 | 42632.2 | 42570.5 | 42588.0 | 1021.0 |
| 2025-05-08 03:00:00 | YM | Futures | 42591.1 | 42681.6 | 42577.7 | 42610.6 | 1458.0 |
> showing 50 of 2,115 rows — these rows as CSV