PREVIEW / futures_1hour / 2021-07-11
file: by_date/futures_1hour/2021/2021-07-11.parquet size: 18 KB rows: 386
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 |
|---|---|---|---|---|---|---|---|
| 2021-07-11 18:00:00 | ES | Futures | 4913.05 | 4916.71 | 4911.64 | 4913.33 | 5561.0 |
| 2021-07-11 19:00:00 | ES | Futures | 4913.61 | 4916.43 | 4910.51 | 4914.45 | 4908.0 |
| 2021-07-11 20:00:00 | ES | Futures | 4914.17 | 4915.02 | 4907.98 | 4910.79 | 9110.0 |
| 2021-07-11 21:00:00 | ES | Futures | 4911.08 | 4911.64 | 4904.32 | 4904.88 | 10029.0 |
| 2021-07-11 22:00:00 | ES | Futures | 4904.88 | 4907.13 | 4903.47 | 4904.88 | 5974.0 |
| 2021-07-11 23:00:00 | ES | Futures | 4905.16 | 4906.01 | 4901.22 | 4901.78 | 4435.0 |
| 2021-07-11 18:00:00 | NQ | Futures | 17176.94 | 17198.96 | 17176.94 | 17185.63 | 3030.0 |
| 2021-07-11 19:00:00 | NQ | Futures | 17186.5 | 17189.98 | 17174.91 | 17183.31 | 1936.0 |
| 2021-07-11 20:00:00 | NQ | Futures | 17182.44 | 17185.63 | 17164.48 | 17178.68 | 3583.0 |
| 2021-07-11 21:00:00 | NQ | Futures | 17179.26 | 17182.44 | 17148.26 | 17150.87 | 3635.0 |
| 2021-07-11 22:00:00 | NQ | Futures | 17151.74 | 17161.88 | 17149.71 | 17154.63 | 2528.0 |
| 2021-07-11 23:00:00 | NQ | Futures | 17154.63 | 17158.11 | 17141.6 | 17147.97 | 2048.0 |
| 2021-07-11 18:00:00 | YM | Futures | 38841.3 | 38872.5 | 38825.6 | 38844.6 | 1445.0 |
| 2021-07-11 19:00:00 | YM | Futures | 38844.6 | 38875.9 | 38817.8 | 38861.4 | 1443.0 |
| 2021-07-11 20:00:00 | YM | Futures | 38861.4 | 38870.3 | 38804.4 | 38826.7 | 1825.0 |
| 2021-07-11 21:00:00 | YM | Futures | 38826.7 | 38833.4 | 38783.2 | 38789.9 | 2092.0 |
| 2021-07-11 22:00:00 | YM | Futures | 38791.0 | 38807.7 | 38778.7 | 38793.2 | 1115.0 |
| 2021-07-11 23:00:00 | YM | Futures | 38793.2 | 38798.8 | 38756.4 | 38760.8 | 932.0 |
| 2021-07-11 18:00:00 | CL | Futures | 50.95 | 51.08 | 50.87 | 50.99 | 2212.0 |
| 2021-07-11 19:00:00 | CL | Futures | 50.98 | 50.98 | 50.88 | 50.92 | 1026.0 |
| 2021-07-11 20:00:00 | CL | Futures | 50.92 | 50.98 | 50.82 | 50.92 | 2582.0 |
| 2021-07-11 21:00:00 | CL | Futures | 50.92 | 50.98 | 50.79 | 50.79 | 5145.0 |
| 2021-07-11 22:00:00 | CL | Futures | 50.79 | 50.85 | 50.75 | 50.81 | 2759.0 |
| 2021-07-11 23:00:00 | CL | Futures | 50.81 | 50.86 | 50.72 | 50.75 | 1619.0 |
| 2021-07-11 18:00:00 | GC | Futures | 2182.0 | 2182.4 | 2180.9 | 2181.4 | 1193.0 |
| 2021-07-11 19:00:00 | GC | Futures | 2181.4 | 2182.4 | 2179.6 | 2179.8 | 1239.0 |
| 2021-07-11 20:00:00 | GC | Futures | 2179.9 | 2183.3 | 2178.5 | 2182.6 | 2621.0 |
| 2021-07-11 21:00:00 | GC | Futures | 2182.6 | 2185.0 | 2177.0 | 2178.5 | 6058.0 |
| 2021-07-11 22:00:00 | GC | Futures | 2178.5 | 2180.9 | 2177.8 | 2178.1 | 3382.0 |
| 2021-07-11 23:00:00 | GC | Futures | 2178.3 | 2178.5 | 2174.5 | 2175.4 | 4000.0 |
| 2021-07-11 18:00:00 | ZN | Futures | 135.640416 | 135.688082 | 135.608639 | 135.688082 | 13045.0 |
| 2021-07-11 19:00:00 | ZN | Futures | 135.688082 | 135.703971 | 135.640416 | 135.656305 | 5832.0 |
| 2021-07-11 20:00:00 | ZN | Futures | 135.640416 | 135.751636 | 135.640416 | 135.703971 | 16896.0 |
| 2021-07-11 21:00:00 | ZN | Futures | 135.719859 | 135.735748 | 135.640416 | 135.672193 | 20449.0 |
| 2021-07-11 22:00:00 | ZN | Futures | 135.656305 | 135.703971 | 135.656305 | 135.688082 | 10704.0 |
| 2021-07-11 23:00:00 | ZN | Futures | 135.672193 | 135.719859 | 135.672193 | 135.703971 | 10196.0 |
> showing 36 of 386 rows — these rows as CSV