PREVIEW / futures_1hour / 2009-01-11
file: by_date/futures_1hour/2009/2009-01-11.parquet size: 13 KB rows: 223
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 |
|---|---|---|---|---|---|---|---|
| 2009-01-11 18:00:00 | ES | Futures | 839.64 | 839.64 | 835.13 | 838.21 | 6780.0 |
| 2009-01-11 19:00:00 | ES | Futures | 837.98 | 839.16 | 836.55 | 838.21 | 3319.0 |
| 2009-01-11 20:00:00 | ES | Futures | 838.21 | 839.16 | 836.79 | 838.45 | 2230.0 |
| 2009-01-11 21:00:00 | ES | Futures | 838.45 | 838.92 | 836.79 | 837.74 | 2077.0 |
| 2009-01-11 22:00:00 | ES | Futures | 837.74 | 838.45 | 835.84 | 836.32 | 1284.0 |
| 2009-01-11 23:00:00 | ES | Futures | 836.08 | 836.32 | 834.42 | 835.13 | 1948.0 |
| 2009-01-11 18:00:00 | NQ | Futures | 1379.15 | 1379.15 | 1370.96 | 1376.61 | 397.0 |
| 2009-01-11 19:00:00 | NQ | Futures | 1376.61 | 1377.17 | 1373.22 | 1376.32 | 98.0 |
| 2009-01-11 20:00:00 | NQ | Futures | 1375.76 | 1378.58 | 1374.63 | 1378.3 | 75.0 |
| 2009-01-11 21:00:00 | NQ | Futures | 1378.02 | 1378.02 | 1375.19 | 1376.61 | 49.0 |
| 2009-01-11 22:00:00 | NQ | Futures | 1376.61 | 1376.61 | 1373.78 | 1374.06 | 60.0 |
| 2009-01-11 23:00:00 | NQ | Futures | 1374.06 | 1374.35 | 1371.52 | 1372.37 | 63.0 |
| 2009-01-11 18:00:00 | YM | Futures | 7782.3 | 7782.3 | 7740.4 | 7764.1 | 398.0 |
| 2009-01-11 19:00:00 | YM | Futures | 7763.1 | 7771.3 | 7751.3 | 7765.0 | 133.0 |
| 2009-01-11 20:00:00 | YM | Futures | 7765.0 | 7772.3 | 7753.1 | 7770.4 | 154.0 |
| 2009-01-11 21:00:00 | YM | Futures | 7770.4 | 7771.3 | 7755.9 | 7759.5 | 143.0 |
| 2009-01-11 22:00:00 | YM | Futures | 7759.5 | 7765.0 | 7749.5 | 7753.1 | 114.0 |
| 2009-01-11 23:00:00 | YM | Futures | 7750.4 | 7750.4 | 7732.2 | 7736.7 | 210.0 |
| 2009-01-11 18:00:00 | CL | Futures | 141.54 | 142.09 | 140.14 | 141.92 | 610.0 |
| 2009-01-11 19:00:00 | CL | Futures | 142.06 | 142.09 | 140.42 | 140.77 | 289.0 |
| 2009-01-11 20:00:00 | CL | Futures | 140.8 | 141.99 | 140.77 | 141.64 | 257.0 |
| 2009-01-11 21:00:00 | CL | Futures | 141.85 | 142.41 | 141.47 | 141.99 | 116.0 |
| 2009-01-11 22:00:00 | CL | Futures | 141.99 | 142.16 | 140.98 | 140.98 | 161.0 |
| 2009-01-11 23:00:00 | CL | Futures | 141.33 | 141.33 | 139.96 | 140.21 | 302.0 |
| 2009-01-11 18:00:00 | GC | Futures | 1220.6 | 1222.6 | 1214.2 | 1214.8 | 1195.0 |
| 2009-01-11 19:00:00 | GC | Futures | 1215.9 | 1217.1 | 1210.7 | 1212.7 | 1109.0 |
| 2009-01-11 20:00:00 | GC | Futures | 1212.9 | 1216.6 | 1209.9 | 1216.2 | 742.0 |
| 2009-01-11 21:00:00 | GC | Futures | 1215.8 | 1218.6 | 1214.2 | 1216.5 | 363.0 |
| 2009-01-11 22:00:00 | GC | Futures | 1216.5 | 1216.8 | 1211.2 | 1211.7 | 738.0 |
| 2009-01-11 23:00:00 | GC | Futures | 1211.5 | 1215.2 | 1210.1 | 1213.2 | 607.0 |
| 2009-01-11 18:00:00 | ZN | Futures | 96.932875 | 97.041382 | 96.932875 | 97.017269 | 345.0 |
| 2009-01-11 19:00:00 | ZN | Futures | 97.017269 | 97.065494 | 97.005213 | 97.053438 | 598.0 |
| 2009-01-11 20:00:00 | ZN | Futures | 97.041382 | 97.065494 | 97.029325 | 97.053438 | 243.0 |
| 2009-01-11 21:00:00 | ZN | Futures | 97.041382 | 97.041382 | 96.908762 | 96.944931 | 959.0 |
| 2009-01-11 22:00:00 | ZN | Futures | 96.944931 | 97.005213 | 96.932875 | 96.993156 | 449.0 |
| 2009-01-11 23:00:00 | ZN | Futures | 96.993156 | 97.029325 | 96.993156 | 96.993156 | 558.0 |
> showing 36 of 223 rows — these rows as CSV