PREVIEW / futures_1hour / 2024-05-13
file: by_date/futures_1hour/2024/2024-05-13.parquet size: 63 KB rows: 2,056
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 |
|---|---|---|---|---|---|---|---|
| 2024-05-13 00:00:00 | ES | Futures | 5570.15 | 5572.27 | 5569.09 | 5572.01 | 3942.0 |
| 2024-05-13 01:00:00 | ES | Futures | 5572.01 | 5573.6 | 5571.48 | 5573.07 | 3878.0 |
| 2024-05-13 02:00:00 | ES | Futures | 5573.07 | 5574.66 | 5572.01 | 5572.27 | 5303.0 |
| 2024-05-13 03:00:00 | ES | Futures | 5572.54 | 5574.13 | 5570.15 | 5573.6 | 7097.0 |
| 2024-05-13 04:00:00 | ES | Futures | 5573.33 | 5574.66 | 5570.15 | 5571.21 | 9367.0 |
| 2024-05-13 05:00:00 | ES | Futures | 5570.94 | 5575.19 | 5570.15 | 5573.6 | 6840.0 |
| 2024-05-13 06:00:00 | ES | Futures | 5573.33 | 5576.52 | 5572.54 | 5576.25 | 5736.0 |
| 2024-05-13 07:00:00 | ES | Futures | 5576.25 | 5581.82 | 5574.39 | 5581.29 | 12470.0 |
| 2024-05-13 08:00:00 | ES | Futures | 5581.03 | 5582.88 | 5576.25 | 5581.56 | 15266.0 |
| 2024-05-13 09:00:00 | ES | Futures | 5581.29 | 5586.07 | 5568.29 | 5574.13 | 151921.0 |
| 2024-05-13 10:00:00 | ES | Futures | 5574.39 | 5576.25 | 5568.56 | 5570.15 | 116991.0 |
| 2024-05-13 11:00:00 | ES | Futures | 5570.15 | 5572.27 | 5560.6 | 5567.76 | 113295.0 |
| 2024-05-13 12:00:00 | ES | Futures | 5567.76 | 5571.21 | 5566.97 | 5567.23 | 61910.0 |
| 2024-05-13 13:00:00 | ES | Futures | 5567.23 | 5567.5 | 5553.44 | 5563.78 | 117575.0 |
| 2024-05-13 14:00:00 | ES | Futures | 5564.05 | 5567.23 | 5559.8 | 5566.43 | 59897.0 |
| 2024-05-13 15:00:00 | ES | Futures | 5566.17 | 5568.82 | 5561.66 | 5566.43 | 137825.0 |
| 2024-05-13 16:00:00 | ES | Futures | 5566.7 | 5568.82 | 5562.46 | 5563.78 | 36757.0 |
| 2024-05-13 18:00:00 | ES | Futures | 5562.46 | 5565.37 | 5562.46 | 5564.84 | 4163.0 |
| 2024-05-13 19:00:00 | ES | Futures | 5564.84 | 5566.17 | 5564.05 | 5565.11 | 1669.0 |
| 2024-05-13 20:00:00 | ES | Futures | 5565.37 | 5566.97 | 5563.25 | 5564.58 | 3634.0 |
| 2024-05-13 21:00:00 | ES | Futures | 5564.31 | 5565.11 | 5562.19 | 5563.78 | 3260.0 |
| 2024-05-13 22:00:00 | ES | Futures | 5564.05 | 5564.31 | 5562.99 | 5562.99 | 1776.0 |
| 2024-05-13 23:00:00 | ES | Futures | 5562.99 | 5563.52 | 5561.39 | 5562.19 | 2815.0 |
| 2024-05-13 00:00:00 | NQ | Futures | 19557.75 | 19567.92 | 19552.4 | 19566.58 | 2451.0 |
| 2024-05-13 01:00:00 | NQ | Futures | 19566.58 | 19579.69 | 19565.24 | 19578.08 | 2613.0 |
| 2024-05-13 02:00:00 | NQ | Futures | 19578.08 | 19582.1 | 19569.79 | 19570.86 | 3108.0 |
| 2024-05-13 03:00:00 | NQ | Futures | 19571.13 | 19579.15 | 19558.29 | 19571.66 | 5033.0 |
| 2024-05-13 04:00:00 | NQ | Futures | 19571.4 | 19577.01 | 19553.21 | 19558.82 | 5263.0 |
| 2024-05-13 05:00:00 | NQ | Futures | 19558.56 | 19583.7 | 19555.61 | 19570.33 | 4370.0 |
| 2024-05-13 06:00:00 | NQ | Futures | 19568.99 | 19586.38 | 19565.51 | 19585.84 | 3550.0 |
| 2024-05-13 07:00:00 | NQ | Futures | 19585.57 | 19603.77 | 19578.35 | 19600.56 | 6368.0 |
| 2024-05-13 08:00:00 | NQ | Futures | 19599.75 | 19612.06 | 19578.08 | 19608.31 | 10608.0 |
| 2024-05-13 09:00:00 | NQ | Futures | 19608.05 | 19620.08 | 19530.2 | 19566.31 | 81894.0 |
| 2024-05-13 10:00:00 | NQ | Futures | 19566.58 | 19593.6 | 19557.22 | 19574.61 | 60607.0 |
| 2024-05-13 11:00:00 | NQ | Futures | 19574.61 | 19590.39 | 19537.16 | 19574.61 | 49497.0 |
| 2024-05-13 12:00:00 | NQ | Futures | 19574.61 | 19591.46 | 19573.0 | 19574.87 | 27188.0 |
| 2024-05-13 13:00:00 | NQ | Futures | 19574.87 | 19577.55 | 19511.74 | 19564.44 | 50754.0 |
| 2024-05-13 14:00:00 | NQ | Futures | 19563.91 | 19569.79 | 19546.52 | 19568.19 | 24835.0 |
| 2024-05-13 15:00:00 | NQ | Futures | 19568.45 | 19582.1 | 19552.4 | 19576.75 | 42106.0 |
| 2024-05-13 16:00:00 | NQ | Futures | 19576.75 | 19582.36 | 19562.57 | 19566.31 | 8921.0 |
| 2024-05-13 18:00:00 | NQ | Futures | 19562.03 | 19570.59 | 19552.94 | 19563.1 | 3247.0 |
| 2024-05-13 19:00:00 | NQ | Futures | 19563.1 | 19568.19 | 19559.09 | 19563.91 | 1090.0 |
| 2024-05-13 20:00:00 | NQ | Futures | 19564.17 | 19570.33 | 19553.47 | 19557.49 | 2140.0 |
| 2024-05-13 21:00:00 | NQ | Futures | 19556.95 | 19560.7 | 19548.66 | 19556.42 | 2517.0 |
| 2024-05-13 22:00:00 | NQ | Futures | 19556.42 | 19558.56 | 19550.53 | 19550.8 | 1524.0 |
| 2024-05-13 23:00:00 | NQ | Futures | 19551.07 | 19552.14 | 19541.44 | 19544.91 | 2208.0 |
| 2024-05-13 00:00:00 | YM | Futures | 42085.9 | 42091.2 | 42074.2 | 42090.1 | 440.0 |
| 2024-05-13 01:00:00 | YM | Futures | 42091.2 | 42103.9 | 42082.7 | 42093.3 | 523.0 |
| 2024-05-13 02:00:00 | YM | Futures | 42094.4 | 42113.5 | 42080.6 | 42097.6 | 1435.0 |
| 2024-05-13 03:00:00 | YM | Futures | 42095.4 | 42108.2 | 42078.4 | 42098.6 | 937.0 |
> showing 50 of 2,056 rows — these rows as CSV