PREVIEW / futures_1hour / 2021-06-27
file: by_date/futures_1hour/2021/2021-06-27.parquet size: 17 KB rows: 376
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-27 18:00:00 | ES | Futures | 4815.06 | 4819.0 | 4815.06 | 4817.59 | 6122.0 |
| 2021-06-27 19:00:00 | ES | Futures | 4817.87 | 4818.43 | 4815.06 | 4817.31 | 3861.0 |
| 2021-06-27 20:00:00 | ES | Futures | 4817.59 | 4818.15 | 4813.08 | 4814.77 | 6958.0 |
| 2021-06-27 21:00:00 | ES | Futures | 4814.77 | 4815.62 | 4811.96 | 4814.21 | 4263.0 |
| 2021-06-27 22:00:00 | ES | Futures | 4814.21 | 4814.49 | 4811.68 | 4813.37 | 3712.0 |
| 2021-06-27 23:00:00 | ES | Futures | 4813.65 | 4814.49 | 4812.24 | 4813.08 | 3914.0 |
| 2021-06-27 18:00:00 | NQ | Futures | 16627.7 | 16647.11 | 16612.64 | 16643.64 | 3775.0 |
| 2021-06-27 19:00:00 | NQ | Futures | 16642.77 | 16645.66 | 16619.59 | 16633.21 | 2466.0 |
| 2021-06-27 20:00:00 | NQ | Futures | 16633.5 | 16634.66 | 16614.96 | 16621.33 | 2750.0 |
| 2021-06-27 21:00:00 | NQ | Futures | 16620.75 | 16624.81 | 16608.3 | 16617.57 | 2426.0 |
| 2021-06-27 22:00:00 | NQ | Futures | 16616.7 | 16625.97 | 16611.77 | 16621.91 | 1976.0 |
| 2021-06-27 23:00:00 | NQ | Futures | 16622.49 | 16632.92 | 16621.62 | 16628.28 | 1840.0 |
| 2021-06-27 18:00:00 | YM | Futures | 38431.2 | 38445.8 | 38400.0 | 38413.4 | 1786.0 |
| 2021-06-27 19:00:00 | YM | Futures | 38412.2 | 38434.6 | 38405.5 | 38430.1 | 1064.0 |
| 2021-06-27 20:00:00 | YM | Futures | 38430.1 | 38433.5 | 38378.7 | 38398.8 | 1271.0 |
| 2021-06-27 21:00:00 | YM | Futures | 38395.5 | 38401.1 | 38378.7 | 38394.4 | 703.0 |
| 2021-06-27 22:00:00 | YM | Futures | 38395.5 | 38395.5 | 38373.1 | 38386.5 | 694.0 |
| 2021-06-27 23:00:00 | YM | Futures | 38385.4 | 38388.8 | 38369.8 | 38378.7 | 633.0 |
| 2021-06-27 18:00:00 | CL | Futures | 50.44 | 50.51 | 50.43 | 50.49 | 1852.0 |
| 2021-06-27 19:00:00 | CL | Futures | 50.49 | 50.57 | 50.47 | 50.55 | 1587.0 |
| 2021-06-27 20:00:00 | CL | Futures | 50.55 | 50.69 | 50.53 | 50.64 | 4055.0 |
| 2021-06-27 21:00:00 | CL | Futures | 50.63 | 50.75 | 50.46 | 50.47 | 8026.0 |
| 2021-06-27 22:00:00 | CL | Futures | 50.47 | 50.51 | 50.4 | 50.42 | 4382.0 |
| 2021-06-27 23:00:00 | CL | Futures | 50.41 | 50.47 | 50.35 | 50.45 | 3668.0 |
| 2021-06-27 18:00:00 | GC | Futures | 2150.0 | 2151.1 | 2148.4 | 2151.0 | 1407.0 |
| 2021-06-27 19:00:00 | GC | Futures | 2151.0 | 2151.0 | 2149.3 | 2150.0 | 1212.0 |
| 2021-06-27 20:00:00 | GC | Futures | 2150.0 | 2150.0 | 2147.4 | 2148.2 | 2615.0 |
| 2021-06-27 21:00:00 | GC | Futures | 2148.2 | 2149.5 | 2136.0 | 2139.4 | 13756.0 |
| 2021-06-27 22:00:00 | GC | Futures | 2139.2 | 2147.7 | 2137.3 | 2147.0 | 8242.0 |
| 2021-06-27 23:00:00 | GC | Futures | 2146.9 | 2147.8 | 2145.9 | 2146.5 | 3506.0 |
| 2021-06-27 18:00:00 | ZN | Futures | 134.146894 | 134.19456 | 134.146894 | 134.178671 | 6158.0 |
| 2021-06-27 19:00:00 | ZN | Futures | 134.178671 | 134.178671 | 134.131006 | 134.162783 | 8045.0 |
| 2021-06-27 20:00:00 | ZN | Futures | 134.162783 | 134.19456 | 134.146894 | 134.178671 | 8032.0 |
| 2021-06-27 21:00:00 | ZN | Futures | 134.162783 | 134.162783 | 134.115117 | 134.131006 | 9196.0 |
| 2021-06-27 22:00:00 | ZN | Futures | 134.131006 | 134.146894 | 134.115117 | 134.146894 | 4370.0 |
| 2021-06-27 23:00:00 | ZN | Futures | 134.131006 | 134.162783 | 134.115117 | 134.162783 | 7277.0 |
> showing 36 of 376 rows — these rows as CSV