PREVIEW / futures_1hour / 2024-01-29
file: by_date/futures_1hour/2024/2024-01-29.parquet size: 68 KB rows: 2,110
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-01-29 00:00:00 | ES | Futures | 5277.0 | 5278.61 | 5276.19 | 5278.61 | 3941.0 |
| 2024-01-29 01:00:00 | ES | Futures | 5278.61 | 5281.3 | 5278.07 | 5279.42 | 5294.0 |
| 2024-01-29 02:00:00 | ES | Futures | 5279.15 | 5283.71 | 5278.88 | 5283.71 | 7838.0 |
| 2024-01-29 03:00:00 | ES | Futures | 5283.45 | 5286.13 | 5281.03 | 5285.33 | 13528.0 |
| 2024-01-29 04:00:00 | ES | Futures | 5285.06 | 5286.67 | 5278.07 | 5278.88 | 12585.0 |
| 2024-01-29 05:00:00 | ES | Futures | 5278.88 | 5284.79 | 5277.81 | 5283.71 | 7743.0 |
| 2024-01-29 06:00:00 | ES | Futures | 5283.98 | 5286.67 | 5282.64 | 5284.79 | 6360.0 |
| 2024-01-29 07:00:00 | ES | Futures | 5285.06 | 5287.74 | 5281.57 | 5283.18 | 12550.0 |
| 2024-01-29 08:00:00 | ES | Futures | 5283.18 | 5285.86 | 5279.42 | 5281.83 | 21168.0 |
| 2024-01-29 09:00:00 | ES | Futures | 5281.83 | 5289.09 | 5280.22 | 5287.74 | 106646.0 |
| 2024-01-29 10:00:00 | ES | Futures | 5287.47 | 5290.43 | 5278.07 | 5279.69 | 161948.0 |
| 2024-01-29 11:00:00 | ES | Futures | 5279.69 | 5289.35 | 5278.07 | 5288.55 | 84555.0 |
| 2024-01-29 12:00:00 | ES | Futures | 5288.82 | 5293.92 | 5285.59 | 5289.09 | 91253.0 |
| 2024-01-29 13:00:00 | ES | Futures | 5289.35 | 5293.11 | 5285.59 | 5289.89 | 54869.0 |
| 2024-01-29 14:00:00 | ES | Futures | 5289.62 | 5299.29 | 5288.28 | 5296.88 | 84808.0 |
| 2024-01-29 15:00:00 | ES | Futures | 5297.14 | 5324.54 | 5297.14 | 5323.2 | 330459.0 |
| 2024-01-29 16:00:00 | ES | Futures | 5322.93 | 5323.73 | 5316.48 | 5318.36 | 91494.0 |
| 2024-01-29 18:00:00 | ES | Futures | 5318.36 | 5322.93 | 5317.56 | 5321.05 | 6390.0 |
| 2024-01-29 19:00:00 | ES | Futures | 5320.78 | 5324.54 | 5318.9 | 5323.2 | 5841.0 |
| 2024-01-29 20:00:00 | ES | Futures | 5323.2 | 5325.88 | 5321.32 | 5322.66 | 7490.0 |
| 2024-01-29 21:00:00 | ES | Futures | 5322.66 | 5323.73 | 5321.32 | 5323.47 | 3034.0 |
| 2024-01-29 22:00:00 | ES | Futures | 5323.47 | 5324.27 | 5320.78 | 5321.05 | 3495.0 |
| 2024-01-29 23:00:00 | ES | Futures | 5321.05 | 5322.93 | 5320.51 | 5321.05 | 2823.0 |
| 2024-01-29 00:00:00 | NQ | Futures | 19018.29 | 19023.72 | 19012.06 | 19019.38 | 2382.0 |
| 2024-01-29 01:00:00 | NQ | Futures | 19019.65 | 19042.16 | 19016.4 | 19033.75 | 3821.0 |
| 2024-01-29 02:00:00 | NQ | Futures | 19033.21 | 19047.31 | 19028.87 | 19046.5 | 4721.0 |
| 2024-01-29 03:00:00 | NQ | Futures | 19046.5 | 19075.79 | 19028.87 | 19073.35 | 9536.0 |
| 2024-01-29 04:00:00 | NQ | Futures | 19073.35 | 19083.65 | 19028.06 | 19036.19 | 11110.0 |
| 2024-01-29 05:00:00 | NQ | Futures | 19035.38 | 19063.31 | 19031.58 | 19053.55 | 6066.0 |
| 2024-01-29 06:00:00 | NQ | Futures | 19053.82 | 19065.21 | 19045.41 | 19057.35 | 4798.0 |
| 2024-01-29 07:00:00 | NQ | Futures | 19057.62 | 19069.82 | 19034.57 | 19044.6 | 8080.0 |
| 2024-01-29 08:00:00 | NQ | Futures | 19044.33 | 19056.26 | 19025.62 | 19034.29 | 10706.0 |
| 2024-01-29 09:00:00 | NQ | Futures | 19034.02 | 19074.98 | 19016.67 | 19047.58 | 67674.0 |
| 2024-01-29 10:00:00 | NQ | Futures | 19047.86 | 19060.87 | 19012.6 | 19016.67 | 94029.0 |
| 2024-01-29 11:00:00 | NQ | Futures | 19017.21 | 19073.62 | 19005.82 | 19072.26 | 55320.0 |
| 2024-01-29 12:00:00 | NQ | Futures | 19071.99 | 19103.18 | 19067.11 | 19089.89 | 53140.0 |
| 2024-01-29 13:00:00 | NQ | Futures | 19090.43 | 19096.94 | 19069.28 | 19079.59 | 33609.0 |
| 2024-01-29 14:00:00 | NQ | Futures | 19079.86 | 19129.76 | 19074.43 | 19121.08 | 44208.0 |
| 2024-01-29 15:00:00 | NQ | Futures | 19121.35 | 19218.99 | 19121.35 | 19210.04 | 101829.0 |
| 2024-01-29 16:00:00 | NQ | Futures | 19210.04 | 19212.75 | 19187.25 | 19201.63 | 16715.0 |
| 2024-01-29 18:00:00 | NQ | Futures | 19214.1 | 19236.89 | 19200.82 | 19225.22 | 6191.0 |
| 2024-01-29 19:00:00 | NQ | Futures | 19224.95 | 19240.14 | 19213.29 | 19232.82 | 4681.0 |
| 2024-01-29 20:00:00 | NQ | Futures | 19232.0 | 19235.26 | 19204.07 | 19214.38 | 6142.0 |
| 2024-01-29 21:00:00 | NQ | Futures | 19214.92 | 19222.24 | 19207.6 | 19220.34 | 2595.0 |
| 2024-01-29 22:00:00 | NQ | Futures | 19220.34 | 19226.31 | 19211.12 | 19212.21 | 2575.0 |
| 2024-01-29 23:00:00 | NQ | Futures | 19212.48 | 19220.61 | 19211.39 | 19214.65 | 2272.0 |
| 2024-01-29 00:00:00 | YM | Futures | 41024.4 | 41037.3 | 41020.1 | 41037.3 | 374.0 |
| 2024-01-29 01:00:00 | YM | Futures | 41038.4 | 41051.2 | 41036.2 | 41042.7 | 659.0 |
| 2024-01-29 02:00:00 | YM | Futures | 41042.7 | 41085.6 | 41042.7 | 41084.5 | 1235.0 |
| 2024-01-29 03:00:00 | YM | Futures | 41085.6 | 41089.9 | 41057.7 | 41072.7 | 1687.0 |
> showing 50 of 2,110 rows — these rows as CSV