PREVIEW / futures_1hour / 2021-07-18
file: by_date/futures_1hour/2021/2021-07-18.parquet size: 18 KB rows: 392
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-18 18:00:00 | ES | Futures | 4865.74 | 4866.59 | 4855.04 | 4859.26 | 14785.0 |
| 2021-07-18 19:00:00 | ES | Futures | 4859.26 | 4859.83 | 4847.16 | 4852.22 | 13667.0 |
| 2021-07-18 20:00:00 | ES | Futures | 4852.22 | 4853.63 | 4839.55 | 4841.52 | 22289.0 |
| 2021-07-18 21:00:00 | ES | Futures | 4841.24 | 4846.59 | 4840.12 | 4841.24 | 12767.0 |
| 2021-07-18 22:00:00 | ES | Futures | 4840.96 | 4846.31 | 4839.55 | 4845.47 | 8877.0 |
| 2021-07-18 23:00:00 | ES | Futures | 4845.75 | 4849.41 | 4845.75 | 4848.28 | 7732.0 |
| 2021-07-18 18:00:00 | NQ | Futures | 17004.29 | 17012.98 | 16977.06 | 16988.36 | 5635.0 |
| 2021-07-18 19:00:00 | NQ | Futures | 16988.07 | 16991.25 | 16931.0 | 16967.5 | 7295.0 |
| 2021-07-18 20:00:00 | NQ | Futures | 16967.79 | 16988.94 | 16937.95 | 16946.35 | 9050.0 |
| 2021-07-18 21:00:00 | NQ | Futures | 16946.06 | 16966.92 | 16933.03 | 16941.72 | 6376.0 |
| 2021-07-18 22:00:00 | NQ | Futures | 16940.56 | 16962.29 | 16932.74 | 16957.07 | 4702.0 |
| 2021-07-18 23:00:00 | NQ | Futures | 16958.23 | 16975.32 | 16957.94 | 16971.56 | 3564.0 |
| 2021-07-18 18:00:00 | YM | Futures | 38606.6 | 38633.5 | 38527.3 | 38562.0 | 3079.0 |
| 2021-07-18 19:00:00 | YM | Futures | 38559.7 | 38567.5 | 38464.8 | 38490.4 | 3212.0 |
| 2021-07-18 20:00:00 | YM | Futures | 38489.3 | 38502.7 | 38377.6 | 38393.2 | 4541.0 |
| 2021-07-18 21:00:00 | YM | Futures | 38393.2 | 38441.3 | 38381.0 | 38389.9 | 2219.0 |
| 2021-07-18 22:00:00 | YM | Futures | 38388.8 | 38435.7 | 38378.7 | 38429.0 | 1717.0 |
| 2021-07-18 23:00:00 | YM | Futures | 38431.2 | 38461.4 | 38431.2 | 38448.0 | 1600.0 |
| 2021-07-18 18:00:00 | CL | Futures | 48.82 | 49.03 | 48.54 | 48.96 | 6655.0 |
| 2021-07-18 19:00:00 | CL | Futures | 48.96 | 48.98 | 48.77 | 48.85 | 2144.0 |
| 2021-07-18 20:00:00 | CL | Futures | 48.85 | 48.85 | 48.46 | 48.55 | 6865.0 |
| 2021-07-18 21:00:00 | CL | Futures | 48.55 | 48.72 | 48.35 | 48.4 | 10983.0 |
| 2021-07-18 22:00:00 | CL | Futures | 48.4 | 48.48 | 48.3 | 48.44 | 5240.0 |
| 2021-07-18 23:00:00 | CL | Futures | 48.44 | 48.6 | 48.42 | 48.59 | 3857.0 |
| 2021-07-18 18:00:00 | GC | Futures | 2185.7 | 2187.2 | 2184.9 | 2186.9 | 1195.0 |
| 2021-07-18 19:00:00 | GC | Futures | 2186.9 | 2191.8 | 2186.7 | 2191.5 | 2459.0 |
| 2021-07-18 20:00:00 | GC | Futures | 2191.4 | 2193.5 | 2189.7 | 2190.6 | 2843.0 |
| 2021-07-18 21:00:00 | GC | Futures | 2190.4 | 2192.2 | 2187.2 | 2187.5 | 4755.0 |
| 2021-07-18 22:00:00 | GC | Futures | 2187.5 | 2189.1 | 2186.3 | 2186.6 | 2724.0 |
| 2021-07-18 23:00:00 | GC | Futures | 2186.5 | 2189.1 | 2185.5 | 2188.0 | 2038.0 |
| 2021-07-18 18:00:00 | ZN | Futures | 136.101184 | 136.196515 | 136.069407 | 136.196515 | 18396.0 |
| 2021-07-18 19:00:00 | ZN | Futures | 136.180627 | 136.323623 | 136.180627 | 136.275958 | 45185.0 |
| 2021-07-18 20:00:00 | ZN | Futures | 136.291846 | 136.323623 | 136.228292 | 136.244181 | 35421.0 |
| 2021-07-18 21:00:00 | ZN | Futures | 136.244181 | 136.260069 | 136.180627 | 136.196515 | 22090.0 |
| 2021-07-18 22:00:00 | ZN | Futures | 136.212404 | 136.228292 | 136.180627 | 136.180627 | 9699.0 |
| 2021-07-18 23:00:00 | ZN | Futures | 136.180627 | 136.196515 | 136.164738 | 136.180627 | 10769.0 |
> showing 36 of 392 rows — these rows as CSV