PREVIEW / futures_1hour / 2022-01-16
file: by_date/futures_1hour/2022/2022-01-16.parquet size: 18 KB rows: 379
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 |
|---|---|---|---|---|---|---|---|
| 2022-01-16 18:00:00 | ES | Futures | 5278.22 | 5284.72 | 5263.51 | 5267.47 | 17481.0 |
| 2022-01-16 19:00:00 | ES | Futures | 5267.47 | 5270.58 | 5257.29 | 5260.97 | 12113.0 |
| 2022-01-16 20:00:00 | ES | Futures | 5260.68 | 5261.25 | 5250.79 | 5256.44 | 9820.0 |
| 2022-01-16 21:00:00 | ES | Futures | 5256.73 | 5257.57 | 5247.39 | 5252.2 | 7616.0 |
| 2022-01-16 22:00:00 | ES | Futures | 5251.92 | 5262.38 | 5251.63 | 5259.27 | 6411.0 |
| 2022-01-16 23:00:00 | ES | Futures | 5259.27 | 5261.53 | 5253.05 | 5253.61 | 5247.0 |
| 2022-01-16 18:00:00 | NQ | Futures | 18104.01 | 18146.32 | 18046.91 | 18063.72 | 8438.0 |
| 2022-01-16 19:00:00 | NQ | Futures | 18065.17 | 18080.82 | 18028.66 | 18039.38 | 6403.0 |
| 2022-01-16 20:00:00 | NQ | Futures | 18039.09 | 18042.86 | 17983.15 | 18009.82 | 6858.0 |
| 2022-01-16 21:00:00 | NQ | Futures | 18010.4 | 18013.88 | 17977.07 | 17999.09 | 5125.0 |
| 2022-01-16 22:00:00 | NQ | Futures | 18000.25 | 18034.74 | 17997.65 | 18019.96 | 3836.0 |
| 2022-01-16 23:00:00 | NQ | Futures | 18020.54 | 18032.13 | 17999.96 | 18004.31 | 3643.0 |
| 2022-01-16 18:00:00 | YM | Futures | 40295.0 | 40345.6 | 40214.1 | 40244.4 | 4056.0 |
| 2022-01-16 19:00:00 | YM | Futures | 40243.3 | 40264.6 | 40173.6 | 40202.8 | 2845.0 |
| 2022-01-16 20:00:00 | YM | Futures | 40198.3 | 40205.1 | 40150.0 | 40187.1 | 1448.0 |
| 2022-01-16 21:00:00 | YM | Futures | 40188.2 | 40197.2 | 40126.4 | 40155.6 | 1098.0 |
| 2022-01-16 22:00:00 | YM | Futures | 40154.5 | 40226.4 | 40150.0 | 40206.2 | 1050.0 |
| 2022-01-16 23:00:00 | YM | Futures | 40209.6 | 40216.3 | 40159.0 | 40164.6 | 1108.0 |
| 2022-01-16 18:00:00 | CL | Futures | 59.89 | 60.12 | 59.81 | 59.94 | 4188.0 |
| 2022-01-16 19:00:00 | CL | Futures | 59.94 | 59.98 | 59.84 | 59.87 | 1484.0 |
| 2022-01-16 20:00:00 | CL | Futures | 59.87 | 60.03 | 59.75 | 59.97 | 4112.0 |
| 2022-01-16 21:00:00 | CL | Futures | 59.97 | 60.01 | 59.63 | 59.74 | 2923.0 |
| 2022-01-16 22:00:00 | CL | Futures | 59.74 | 59.79 | 59.66 | 59.74 | 1215.0 |
| 2022-01-16 23:00:00 | CL | Futures | 59.74 | 59.74 | 59.64 | 59.67 | 1306.0 |
| 2022-01-16 18:00:00 | GC | Futures | 2186.3 | 2186.5 | 2182.0 | 2182.8 | 1896.0 |
| 2022-01-16 19:00:00 | GC | Futures | 2182.7 | 2183.2 | 2180.5 | 2181.6 | 2177.0 |
| 2022-01-16 20:00:00 | GC | Futures | 2181.7 | 2183.0 | 2178.5 | 2182.2 | 4655.0 |
| 2022-01-16 21:00:00 | GC | Futures | 2182.2 | 2185.3 | 2182.0 | 2184.7 | 1874.0 |
| 2022-01-16 22:00:00 | GC | Futures | 2184.8 | 2186.6 | 2184.5 | 2185.8 | 1483.0 |
| 2022-01-16 23:00:00 | GC | Futures | 2185.8 | 2187.6 | 2185.8 | 2186.6 | 1279.0 |
| 2022-01-16 18:00:00 | ZN | Futures | 131.459856 | 131.475899 | 131.251291 | 131.267335 | 43102.0 |
| 2022-01-16 19:00:00 | ZN | Futures | 131.251291 | 131.331509 | 131.155031 | 131.187118 | 27721.0 |
| 2022-01-16 20:00:00 | ZN | Futures | 131.203161 | 131.219205 | 131.05877 | 131.155031 | 36235.0 |
| 2022-01-16 21:00:00 | ZN | Futures | 131.155031 | 131.235248 | 131.138987 | 131.155031 | 16886.0 |
| 2022-01-16 22:00:00 | ZN | Futures | 131.155031 | 131.187118 | 131.138987 | 131.155031 | 9453.0 |
| 2022-01-16 23:00:00 | ZN | Futures | 131.138987 | 131.203161 | 131.122944 | 131.171074 | 7538.0 |
> showing 36 of 379 rows — these rows as CSV