PREVIEW / futures_1hour / 2008-11-16
file: by_date/futures_1hour/2008/2008-11-16.parquet size: 13 KB rows: 230
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-16 18:00:00 | ES | Futures | 815.97 | 816.91 | 810.76 | 813.6 | 12564.0 |
| 2008-11-16 19:00:00 | ES | Futures | 813.6 | 814.78 | 804.61 | 807.21 | 11440.0 |
| 2008-11-16 20:00:00 | ES | Futures | 807.45 | 815.02 | 807.45 | 815.02 | 11261.0 |
| 2008-11-16 21:00:00 | ES | Futures | 814.78 | 815.49 | 810.29 | 812.65 | 8468.0 |
| 2008-11-16 22:00:00 | ES | Futures | 812.42 | 823.07 | 812.42 | 821.88 | 12626.0 |
| 2008-11-16 23:00:00 | ES | Futures | 821.65 | 823.07 | 818.57 | 820.7 | 5295.0 |
| 2008-11-16 18:00:00 | NQ | Futures | 1309.84 | 1313.52 | 1302.76 | 1306.72 | 925.0 |
| 2008-11-16 19:00:00 | NQ | Futures | 1306.44 | 1307.86 | 1289.46 | 1292.01 | 667.0 |
| 2008-11-16 20:00:00 | NQ | Futures | 1293.99 | 1305.31 | 1292.29 | 1305.31 | 623.0 |
| 2008-11-16 21:00:00 | NQ | Futures | 1305.59 | 1307.29 | 1298.24 | 1303.9 | 278.0 |
| 2008-11-16 22:00:00 | NQ | Futures | 1302.48 | 1318.61 | 1302.48 | 1317.19 | 856.0 |
| 2008-11-16 23:00:00 | NQ | Futures | 1317.48 | 1319.74 | 1311.82 | 1313.23 | 106.0 |
| 2008-11-16 18:00:00 | YM | Futures | 7630.9 | 7630.9 | 7576.3 | 7598.1 | 725.0 |
| 2008-11-16 19:00:00 | YM | Futures | 7598.1 | 7609.9 | 7525.4 | 7547.2 | 660.0 |
| 2008-11-16 20:00:00 | YM | Futures | 7547.2 | 7615.4 | 7542.6 | 7615.4 | 681.0 |
| 2008-11-16 21:00:00 | YM | Futures | 7615.4 | 7618.1 | 7570.8 | 7594.5 | 496.0 |
| 2008-11-16 22:00:00 | YM | Futures | 7597.2 | 7682.7 | 7597.2 | 7669.1 | 676.0 |
| 2008-11-16 23:00:00 | YM | Futures | 7669.1 | 7680.0 | 7640.9 | 7657.2 | 355.0 |
| 2008-11-16 18:00:00 | CL | Futures | 210.9 | 210.9 | 207.68 | 208.87 | 360.0 |
| 2008-11-16 19:00:00 | CL | Futures | 208.5 | 208.61 | 207.94 | 208.13 | 337.0 |
| 2008-11-16 20:00:00 | CL | Futures | 208.13 | 209.31 | 207.94 | 209.31 | 449.0 |
| 2008-11-16 21:00:00 | CL | Futures | 209.31 | 209.31 | 208.35 | 208.61 | 82.0 |
| 2008-11-16 22:00:00 | CL | Futures | 208.53 | 210.05 | 208.53 | 209.53 | 246.0 |
| 2008-11-16 23:00:00 | CL | Futures | 209.68 | 210.31 | 209.49 | 209.49 | 201.0 |
| 2008-11-16 18:00:00 | GC | Futures | 1056.1 | 1061.9 | 1051.4 | 1055.4 | 1143.0 |
| 2008-11-16 19:00:00 | GC | Futures | 1055.4 | 1058.1 | 1050.6 | 1057.1 | 1296.0 |
| 2008-11-16 20:00:00 | GC | Futures | 1057.4 | 1059.1 | 1055.4 | 1058.7 | 830.0 |
| 2008-11-16 21:00:00 | GC | Futures | 1058.7 | 1059.1 | 1055.1 | 1056.3 | 789.0 |
| 2008-11-16 22:00:00 | GC | Futures | 1056.3 | 1058.0 | 1055.7 | 1056.1 | 450.0 |
| 2008-11-16 23:00:00 | GC | Futures | 1056.1 | 1057.9 | 1053.0 | 1056.6 | 889.0 |
| 2008-11-16 18:00:00 | ZN | Futures | 88.746103 | 88.757915 | 88.627979 | 88.675229 | 2415.0 |
| 2008-11-16 19:00:00 | ZN | Futures | 88.687041 | 88.840601 | 88.627979 | 88.73429 | 2213.0 |
| 2008-11-16 20:00:00 | ZN | Futures | 88.722478 | 88.757915 | 88.604355 | 88.616167 | 1699.0 |
| 2008-11-16 21:00:00 | ZN | Futures | 88.616167 | 88.651604 | 88.616167 | 88.627979 | 549.0 |
| 2008-11-16 22:00:00 | ZN | Futures | 88.616167 | 88.616167 | 88.462607 | 88.533481 | 2216.0 |
| 2008-11-16 23:00:00 | ZN | Futures | 88.533481 | 88.58073 | 88.474419 | 88.545293 | 1593.0 |
> showing 36 of 230 rows — these rows as CSV