PREVIEW / futures_1hour / 2024-01-16
file: by_date/futures_1hour/2024/2024-01-16.parquet size: 68 KB rows: 2,091
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-16 00:00:00 | ES | Futures | 5157.48 | 5157.75 | 5153.72 | 5153.99 | 3700.0 |
| 2024-01-16 01:00:00 | ES | Futures | 5153.99 | 5154.79 | 5150.76 | 5154.79 | 9791.0 |
| 2024-01-16 02:00:00 | ES | Futures | 5154.52 | 5157.21 | 5151.03 | 5154.25 | 9128.0 |
| 2024-01-16 03:00:00 | ES | Futures | 5153.99 | 5153.99 | 5141.9 | 5147.27 | 36734.0 |
| 2024-01-16 04:00:00 | ES | Futures | 5147.0 | 5151.03 | 5144.58 | 5148.08 | 17895.0 |
| 2024-01-16 05:00:00 | ES | Futures | 5148.08 | 5148.88 | 5141.09 | 5144.32 | 14167.0 |
| 2024-01-16 06:00:00 | ES | Futures | 5144.32 | 5155.6 | 5143.78 | 5153.99 | 15545.0 |
| 2024-01-16 07:00:00 | ES | Futures | 5153.99 | 5162.04 | 5149.96 | 5160.16 | 29629.0 |
| 2024-01-16 08:00:00 | ES | Futures | 5160.16 | 5162.31 | 5149.69 | 5151.84 | 46202.0 |
| 2024-01-16 09:00:00 | ES | Futures | 5151.84 | 5162.85 | 5139.21 | 5150.49 | 211058.0 |
| 2024-01-16 10:00:00 | ES | Futures | 5150.22 | 5173.05 | 5146.73 | 5168.76 | 260775.0 |
| 2024-01-16 11:00:00 | ES | Futures | 5169.03 | 5173.86 | 5151.84 | 5158.82 | 320975.0 |
| 2024-01-16 12:00:00 | ES | Futures | 5158.82 | 5160.43 | 5144.05 | 5144.58 | 164027.0 |
| 2024-01-16 13:00:00 | ES | Futures | 5144.58 | 5158.28 | 5142.7 | 5145.66 | 129711.0 |
| 2024-01-16 14:00:00 | ES | Futures | 5145.93 | 5149.15 | 5134.92 | 5148.34 | 124394.0 |
| 2024-01-16 15:00:00 | ES | Futures | 5148.08 | 5156.67 | 5142.7 | 5155.33 | 180373.0 |
| 2024-01-16 16:00:00 | ES | Futures | 5155.33 | 5157.75 | 5154.25 | 5155.87 | 53960.0 |
| 2024-01-16 18:00:00 | ES | Futures | 5156.67 | 5157.75 | 5154.25 | 5157.21 | 6210.0 |
| 2024-01-16 19:00:00 | ES | Futures | 5156.94 | 5157.21 | 5151.3 | 5152.91 | 7957.0 |
| 2024-01-16 20:00:00 | ES | Futures | 5152.91 | 5153.45 | 5148.88 | 5151.03 | 7028.0 |
| 2024-01-16 21:00:00 | ES | Futures | 5151.03 | 5151.57 | 5146.2 | 5146.46 | 6775.0 |
| 2024-01-16 22:00:00 | ES | Futures | 5146.46 | 5147.0 | 5141.36 | 5141.63 | 9074.0 |
| 2024-01-16 23:00:00 | ES | Futures | 5141.63 | 5147.0 | 5141.63 | 5145.93 | 5944.0 |
| 2024-01-16 00:00:00 | NQ | Futures | 18327.8 | 18329.16 | 18306.11 | 18309.36 | 3128.0 |
| 2024-01-16 01:00:00 | NQ | Futures | 18308.55 | 18314.79 | 18296.62 | 18312.89 | 5015.0 |
| 2024-01-16 02:00:00 | NQ | Futures | 18313.43 | 18326.72 | 18296.62 | 18311.26 | 5585.0 |
| 2024-01-16 03:00:00 | NQ | Futures | 18311.26 | 18311.26 | 18237.76 | 18269.22 | 17362.0 |
| 2024-01-16 04:00:00 | NQ | Futures | 18269.22 | 18295.8 | 18268.41 | 18284.14 | 9222.0 |
| 2024-01-16 05:00:00 | NQ | Futures | 18284.68 | 18287.39 | 18253.22 | 18274.65 | 6692.0 |
| 2024-01-16 06:00:00 | NQ | Futures | 18274.11 | 18320.75 | 18274.11 | 18313.16 | 7464.0 |
| 2024-01-16 07:00:00 | NQ | Futures | 18313.43 | 18351.67 | 18303.67 | 18346.52 | 12701.0 |
| 2024-01-16 08:00:00 | NQ | Futures | 18346.25 | 18366.32 | 18303.4 | 18325.91 | 23938.0 |
| 2024-01-16 09:00:00 | NQ | Futures | 18325.91 | 18383.67 | 18284.68 | 18348.42 | 91899.0 |
| 2024-01-16 10:00:00 | NQ | Futures | 18348.69 | 18478.59 | 18325.09 | 18457.44 | 108589.0 |
| 2024-01-16 11:00:00 | NQ | Futures | 18457.44 | 18466.93 | 18371.74 | 18387.47 | 124666.0 |
| 2024-01-16 12:00:00 | NQ | Futures | 18387.74 | 18399.67 | 18326.18 | 18330.79 | 70973.0 |
| 2024-01-16 13:00:00 | NQ | Futures | 18330.79 | 18385.84 | 18322.38 | 18335.94 | 57741.0 |
| 2024-01-16 14:00:00 | NQ | Futures | 18336.21 | 18367.94 | 18292.28 | 18362.79 | 51893.0 |
| 2024-01-16 15:00:00 | NQ | Futures | 18363.33 | 18409.17 | 18356.55 | 18407.27 | 59007.0 |
| 2024-01-16 16:00:00 | NQ | Futures | 18407.54 | 18421.64 | 18399.67 | 18418.12 | 12409.0 |
| 2024-01-16 18:00:00 | NQ | Futures | 18418.12 | 18422.46 | 18405.64 | 18419.74 | 3059.0 |
| 2024-01-16 19:00:00 | NQ | Futures | 18419.47 | 18421.64 | 18393.71 | 18398.86 | 3856.0 |
| 2024-01-16 20:00:00 | NQ | Futures | 18398.59 | 18401.57 | 18382.59 | 18388.28 | 3789.0 |
| 2024-01-16 21:00:00 | NQ | Futures | 18388.28 | 18392.35 | 18363.6 | 18364.69 | 4897.0 |
| 2024-01-16 22:00:00 | NQ | Futures | 18364.69 | 18366.32 | 18342.45 | 18343.26 | 4668.0 |
| 2024-01-16 23:00:00 | NQ | Futures | 18342.99 | 18363.87 | 18337.84 | 18357.09 | 3950.0 |
| 2024-01-16 00:00:00 | YM | Futures | 40466.9 | 40469.1 | 40441.2 | 40442.2 | 855.0 |
| 2024-01-16 01:00:00 | YM | Futures | 40442.2 | 40449.8 | 40418.6 | 40443.3 | 1464.0 |
| 2024-01-16 02:00:00 | YM | Futures | 40443.3 | 40456.2 | 40412.2 | 40434.7 | 2096.0 |
| 2024-01-16 03:00:00 | YM | Futures | 40434.7 | 40434.7 | 40364.9 | 40410.0 | 5569.0 |
> showing 50 of 2,091 rows — these rows as CSV