PREVIEW / futures_1hour / 2022-03-20
file: by_date/futures_1hour/2022/2022-03-20.parquet size: 18 KB rows: 400
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-03-20 18:00:00 | ES | Futures | 5056.57 | 5060.26 | 5049.77 | 5052.61 | 11913.0 |
| 2022-03-20 19:00:00 | ES | Futures | 5052.89 | 5052.89 | 5046.65 | 5047.79 | 5831.0 |
| 2022-03-20 20:00:00 | ES | Futures | 5047.79 | 5048.92 | 5038.43 | 5044.39 | 7992.0 |
| 2022-03-20 21:00:00 | ES | Futures | 5044.39 | 5046.65 | 5033.9 | 5035.32 | 9108.0 |
| 2022-03-20 22:00:00 | ES | Futures | 5035.6 | 5040.13 | 5033.61 | 5035.32 | 6262.0 |
| 2022-03-20 23:00:00 | ES | Futures | 5035.32 | 5038.72 | 5034.18 | 5037.58 | 3193.0 |
| 2022-03-20 18:00:00 | NQ | Futures | 16707.2 | 16743.16 | 16705.17 | 16721.7 | 6332.0 |
| 2022-03-20 19:00:00 | NQ | Futures | 16722.28 | 16722.86 | 16705.46 | 16707.78 | 2390.0 |
| 2022-03-20 20:00:00 | NQ | Futures | 16708.36 | 16710.1 | 16669.8 | 16692.7 | 3849.0 |
| 2022-03-20 21:00:00 | NQ | Futures | 16692.7 | 16696.76 | 16642.25 | 16642.83 | 4749.0 |
| 2022-03-20 22:00:00 | NQ | Futures | 16642.25 | 16678.49 | 16634.13 | 16659.65 | 4609.0 |
| 2022-03-20 23:00:00 | NQ | Futures | 16660.52 | 16674.15 | 16656.17 | 16668.64 | 1519.0 |
| 2022-03-20 18:00:00 | YM | Futures | 39084.6 | 39104.8 | 39036.1 | 39046.2 | 1337.0 |
| 2022-03-20 19:00:00 | YM | Futures | 39045.1 | 39048.5 | 38996.6 | 39005.6 | 989.0 |
| 2022-03-20 20:00:00 | YM | Futures | 39007.9 | 39018.0 | 38936.9 | 38979.7 | 1475.0 |
| 2022-03-20 21:00:00 | YM | Futures | 38980.8 | 38996.6 | 38908.7 | 38922.2 | 1332.0 |
| 2022-03-20 22:00:00 | YM | Futures | 38922.2 | 38941.4 | 38900.8 | 38916.6 | 1318.0 |
| 2022-03-20 23:00:00 | YM | Futures | 38916.6 | 38933.5 | 38905.3 | 38926.7 | 516.0 |
| 2022-03-20 18:00:00 | CL | Futures | 77.3 | 77.94 | 76.44 | 77.84 | 3399.0 |
| 2022-03-20 19:00:00 | CL | Futures | 77.84 | 78.28 | 77.83 | 78.1 | 1928.0 |
| 2022-03-20 20:00:00 | CL | Futures | 78.12 | 78.84 | 78.12 | 78.5 | 2923.0 |
| 2022-03-20 21:00:00 | CL | Futures | 78.52 | 79.42 | 78.5 | 79.18 | 4949.0 |
| 2022-03-20 22:00:00 | CL | Futures | 79.15 | 79.37 | 79.06 | 79.34 | 2293.0 |
| 2022-03-20 23:00:00 | CL | Futures | 79.36 | 79.54 | 79.07 | 79.26 | 2319.0 |
| 2022-03-20 18:00:00 | GC | Futures | 2307.7 | 2314.7 | 2303.1 | 2305.2 | 2298.0 |
| 2022-03-20 19:00:00 | GC | Futures | 2305.4 | 2306.9 | 2302.9 | 2303.7 | 1219.0 |
| 2022-03-20 20:00:00 | GC | Futures | 2303.6 | 2310.2 | 2303.4 | 2307.9 | 1751.0 |
| 2022-03-20 21:00:00 | GC | Futures | 2307.7 | 2315.6 | 2306.9 | 2315.0 | 3654.0 |
| 2022-03-20 22:00:00 | GC | Futures | 2315.0 | 2315.6 | 2311.4 | 2312.9 | 2280.0 |
| 2022-03-20 23:00:00 | GC | Futures | 2312.7 | 2314.2 | 2311.5 | 2312.9 | 1440.0 |
| 2022-03-20 18:00:00 | ZN | Futures | 127.818409 | 127.866533 | 127.738202 | 127.818409 | 5905.0 |
| 2022-03-20 19:00:00 | ZN | Futures | 127.83445 | 127.850492 | 127.786326 | 127.802367 | 3263.0 |
| 2022-03-20 20:00:00 | ZN | Futures | 127.786326 | 127.882575 | 127.754243 | 127.786326 | 5402.0 |
| 2022-03-20 21:00:00 | ZN | Futures | 127.786326 | 127.818409 | 127.770285 | 127.818409 | 2170.0 |
| 2022-03-20 22:00:00 | ZN | Futures | 127.802367 | 127.866533 | 127.802367 | 127.850492 | 4408.0 |
| 2022-03-20 23:00:00 | ZN | Futures | 127.866533 | 127.866533 | 127.770285 | 127.770285 | 3497.0 |
> showing 36 of 400 rows — these rows as CSV