PREVIEW / futures_1hour / 2021-06-13
file: by_date/futures_1hour/2021/2021-06-13.parquet size: 17 KB rows: 362
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-06-13 18:00:00 | ES | Futures | 4774.23 | 4778.16 | 4772.83 | 4775.92 | 3673.0 |
| 2021-06-13 19:00:00 | ES | Futures | 4776.2 | 4777.88 | 4774.23 | 4776.2 | 1269.0 |
| 2021-06-13 20:00:00 | ES | Futures | 4776.2 | 4779.29 | 4772.26 | 4775.07 | 2586.0 |
| 2021-06-13 21:00:00 | ES | Futures | 4775.07 | 4775.92 | 4772.54 | 4775.92 | 1205.0 |
| 2021-06-13 22:00:00 | ES | Futures | 4775.64 | 4778.73 | 4775.07 | 4778.16 | 1720.0 |
| 2021-06-13 23:00:00 | ES | Futures | 4778.45 | 4778.45 | 4775.64 | 4776.2 | 708.0 |
| 2021-06-13 18:00:00 | NQ | Futures | 16210.58 | 16238.66 | 16209.42 | 16233.16 | 1560.0 |
| 2021-06-13 19:00:00 | NQ | Futures | 16233.16 | 16240.4 | 16225.34 | 16234.03 | 1336.0 |
| 2021-06-13 20:00:00 | NQ | Futures | 16234.61 | 16245.03 | 16221.87 | 16236.92 | 1903.0 |
| 2021-06-13 21:00:00 | NQ | Futures | 16237.5 | 16240.97 | 16227.66 | 16237.79 | 1034.0 |
| 2021-06-13 22:00:00 | NQ | Futures | 16238.08 | 16242.71 | 16236.05 | 16239.82 | 938.0 |
| 2021-06-13 23:00:00 | NQ | Futures | 16239.82 | 16240.4 | 16231.71 | 16233.74 | 617.0 |
| 2021-06-13 18:00:00 | YM | Futures | 38375.4 | 38424.5 | 38375.4 | 38410.0 | 1171.0 |
| 2021-06-13 19:00:00 | YM | Futures | 38411.1 | 38425.6 | 38400.0 | 38417.8 | 653.0 |
| 2021-06-13 20:00:00 | YM | Futures | 38416.7 | 38442.4 | 38381.0 | 38395.5 | 1076.0 |
| 2021-06-13 21:00:00 | YM | Futures | 38395.5 | 38408.9 | 38379.8 | 38408.9 | 520.0 |
| 2021-06-13 22:00:00 | YM | Futures | 38410.0 | 38433.5 | 38400.0 | 38430.1 | 564.0 |
| 2021-06-13 23:00:00 | YM | Futures | 38431.2 | 38431.2 | 38411.1 | 38415.6 | 315.0 |
| 2021-06-13 18:00:00 | CL | Futures | 47.96 | 48.2 | 47.96 | 48.18 | 601.0 |
| 2021-06-13 19:00:00 | CL | Futures | 48.18 | 48.21 | 48.13 | 48.15 | 173.0 |
| 2021-06-13 20:00:00 | CL | Futures | 48.15 | 48.2 | 48.06 | 48.13 | 629.0 |
| 2021-06-13 21:00:00 | CL | Futures | 48.13 | 48.33 | 48.11 | 48.33 | 675.0 |
| 2021-06-13 22:00:00 | CL | Futures | 48.32 | 48.36 | 48.28 | 48.35 | 693.0 |
| 2021-06-13 23:00:00 | CL | Futures | 48.35 | 48.35 | 48.29 | 48.3 | 361.0 |
| 2021-06-13 18:00:00 | GC | Futures | 2267.8 | 2267.9 | 2262.5 | 2265.2 | 2957.0 |
| 2021-06-13 19:00:00 | GC | Futures | 2265.1 | 2265.4 | 2262.5 | 2263.1 | 2250.0 |
| 2021-06-13 20:00:00 | GC | Futures | 2262.9 | 2263.2 | 2258.8 | 2259.1 | 7550.0 |
| 2021-06-13 21:00:00 | GC | Futures | 2259.2 | 2260.3 | 2251.0 | 2252.2 | 12826.0 |
| 2021-06-13 22:00:00 | GC | Futures | 2252.3 | 2254.3 | 2250.4 | 2253.9 | 4591.0 |
| 2021-06-13 23:00:00 | GC | Futures | 2253.9 | 2254.0 | 2250.4 | 2252.7 | 2960.0 |
| 2021-06-13 18:00:00 | ZN | Futures | 135.131983 | 135.16376 | 135.116095 | 135.116095 | 7622.0 |
| 2021-06-13 19:00:00 | ZN | Futures | 135.131983 | 135.131983 | 135.100206 | 135.116095 | 3627.0 |
| 2021-06-13 20:00:00 | ZN | Futures | 135.116095 | 135.116095 | 135.068429 | 135.084318 | 9573.0 |
| 2021-06-13 21:00:00 | ZN | Futures | 135.084318 | 135.084318 | 135.052541 | 135.068429 | 7536.0 |
| 2021-06-13 22:00:00 | ZN | Futures | 135.068429 | 135.100206 | 135.052541 | 135.084318 | 5383.0 |
| 2021-06-13 23:00:00 | ZN | Futures | 135.084318 | 135.100206 | 135.068429 | 135.084318 | 2012.0 |
> showing 36 of 362 rows — these rows as CSV