PREVIEW / futures_1hour / 2010-03-21
file: by_date/futures_1hour/2010/2010-03-21.parquet size: 12 KB rows: 224
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-21 18:00:00 | ES | Futures | 1127.54 | 1127.54 | 1122.65 | 1123.38 | 17276.0 |
| 2010-03-21 19:00:00 | ES | Futures | 1123.63 | 1124.61 | 1123.14 | 1124.36 | 3473.0 |
| 2010-03-21 20:00:00 | ES | Futures | 1124.36 | 1125.34 | 1123.63 | 1124.12 | 3850.0 |
| 2010-03-21 21:00:00 | ES | Futures | 1124.36 | 1125.09 | 1123.38 | 1123.63 | 5320.0 |
| 2010-03-21 22:00:00 | ES | Futures | 1123.63 | 1123.87 | 1122.16 | 1122.65 | 9059.0 |
| 2010-03-21 23:00:00 | ES | Futures | 1122.89 | 1124.61 | 1122.89 | 1123.87 | 4495.0 |
| 2010-03-21 18:00:00 | NQ | Futures | 2207.65 | 2209.94 | 2200.49 | 2201.35 | 1203.0 |
| 2010-03-21 19:00:00 | NQ | Futures | 2201.35 | 2203.64 | 2201.35 | 2202.78 | 485.0 |
| 2010-03-21 20:00:00 | NQ | Futures | 2203.06 | 2204.21 | 2202.49 | 2202.78 | 312.0 |
| 2010-03-21 21:00:00 | NQ | Futures | 2202.78 | 2202.78 | 2201.35 | 2201.63 | 689.0 |
| 2010-03-21 22:00:00 | NQ | Futures | 2201.92 | 2201.92 | 2199.91 | 2201.06 | 624.0 |
| 2010-03-21 23:00:00 | NQ | Futures | 2201.06 | 2202.21 | 2200.49 | 2201.63 | 493.0 |
| 2010-03-21 18:00:00 | YM | Futures | 10032.7 | 10032.7 | 9993.2 | 10001.7 | 945.0 |
| 2010-03-21 19:00:00 | YM | Futures | 10001.7 | 10008.3 | 9999.8 | 10006.4 | 374.0 |
| 2010-03-21 20:00:00 | YM | Futures | 10006.4 | 10012.0 | 10003.6 | 10005.4 | 162.0 |
| 2010-03-21 21:00:00 | YM | Futures | 10006.4 | 10013.0 | 10001.7 | 10004.5 | 270.0 |
| 2010-03-21 22:00:00 | YM | Futures | 10003.6 | 10005.4 | 9997.0 | 10001.7 | 507.0 |
| 2010-03-21 23:00:00 | YM | Futures | 10001.7 | 10014.8 | 10001.7 | 10012.0 | 579.0 |
| 2010-03-21 18:00:00 | CL | Futures | 171.15 | 171.27 | 170.09 | 170.22 | 1277.0 |
| 2010-03-21 19:00:00 | CL | Futures | 170.26 | 170.57 | 170.13 | 170.19 | 373.0 |
| 2010-03-21 20:00:00 | CL | Futures | 170.24 | 170.34 | 170.07 | 170.15 | 505.0 |
| 2010-03-21 21:00:00 | CL | Futures | 170.13 | 170.3 | 170.0 | 170.13 | 791.0 |
| 2010-03-21 22:00:00 | CL | Futures | 170.13 | 170.22 | 170.0 | 170.19 | 447.0 |
| 2010-03-21 23:00:00 | CL | Futures | 170.15 | 170.34 | 170.09 | 170.13 | 321.0 |
| 2010-03-21 18:00:00 | GC | Futures | 1559.9 | 1559.9 | 1553.9 | 1554.0 | 1040.0 |
| 2010-03-21 19:00:00 | GC | Futures | 1554.3 | 1556.3 | 1553.6 | 1554.6 | 943.0 |
| 2010-03-21 20:00:00 | GC | Futures | 1554.6 | 1559.2 | 1554.6 | 1557.5 | 1546.0 |
| 2010-03-21 21:00:00 | GC | Futures | 1557.5 | 1558.9 | 1556.7 | 1557.5 | 1242.0 |
| 2010-03-21 22:00:00 | GC | Futures | 1557.2 | 1558.9 | 1557.1 | 1558.9 | 832.0 |
| 2010-03-21 23:00:00 | GC | Futures | 1558.8 | 1559.9 | 1558.1 | 1559.1 | 867.0 |
| 2010-03-21 18:00:00 | ZN | Futures | 96.151989 | 96.177684 | 96.139141 | 96.151989 | 2185.0 |
| 2010-03-21 19:00:00 | ZN | Futures | 96.151989 | 96.190532 | 96.126294 | 96.177684 | 2002.0 |
| 2010-03-21 20:00:00 | ZN | Futures | 96.177684 | 96.216227 | 96.177684 | 96.190532 | 2313.0 |
| 2010-03-21 21:00:00 | ZN | Futures | 96.190532 | 96.216227 | 96.177684 | 96.20338 | 1248.0 |
| 2010-03-21 22:00:00 | ZN | Futures | 96.20338 | 96.229075 | 96.190532 | 96.216227 | 1194.0 |
| 2010-03-21 23:00:00 | ZN | Futures | 96.216227 | 96.216227 | 96.20338 | 96.20338 | 154.0 |
> showing 36 of 224 rows — these rows as CSV