PREVIEW / futures_1hour / 2008-10-19
file: by_date/futures_1hour/2008/2008-10-19.parquet size: 13 KB rows: 231
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-10-19 18:00:00 | ES | Futures | 887.44 | 890.75 | 876.08 | 884.12 | 17267.0 |
| 2008-10-19 19:00:00 | ES | Futures | 884.12 | 891.7 | 883.41 | 891.7 | 8030.0 |
| 2008-10-19 20:00:00 | ES | Futures | 891.7 | 893.59 | 886.25 | 893.12 | 7474.0 |
| 2008-10-19 21:00:00 | ES | Futures | 893.12 | 893.59 | 886.73 | 888.62 | 5538.0 |
| 2008-10-19 22:00:00 | ES | Futures | 888.86 | 892.64 | 888.15 | 891.93 | 3106.0 |
| 2008-10-19 23:00:00 | ES | Futures | 891.93 | 894.54 | 890.75 | 894.06 | 3375.0 |
| 2008-10-19 18:00:00 | NQ | Futures | 1487.26 | 1494.33 | 1469.15 | 1482.16 | 1397.0 |
| 2008-10-19 19:00:00 | NQ | Futures | 1481.88 | 1497.44 | 1477.35 | 1497.44 | 591.0 |
| 2008-10-19 20:00:00 | NQ | Futures | 1496.03 | 1498.01 | 1486.69 | 1496.88 | 392.0 |
| 2008-10-19 21:00:00 | NQ | Futures | 1496.59 | 1499.71 | 1488.67 | 1492.35 | 404.0 |
| 2008-10-19 22:00:00 | NQ | Futures | 1491.78 | 1498.86 | 1491.78 | 1498.57 | 277.0 |
| 2008-10-19 23:00:00 | NQ | Futures | 1498.57 | 1502.54 | 1496.88 | 1502.25 | 181.0 |
| 2008-10-19 18:00:00 | YM | Futures | 8004.7 | 8032.0 | 7912.8 | 7974.7 | 944.0 |
| 2008-10-19 19:00:00 | YM | Futures | 7969.2 | 8045.6 | 7967.4 | 8045.6 | 698.0 |
| 2008-10-19 20:00:00 | YM | Futures | 8044.7 | 8050.2 | 7996.5 | 8048.3 | 842.0 |
| 2008-10-19 21:00:00 | YM | Futures | 8048.3 | 8051.1 | 7990.1 | 8006.5 | 454.0 |
| 2008-10-19 22:00:00 | YM | Futures | 8010.1 | 8042.0 | 8004.7 | 8038.3 | 338.0 |
| 2008-10-19 23:00:00 | YM | Futures | 8036.5 | 8062.9 | 8028.3 | 8052.9 | 356.0 |
| 2008-10-19 18:00:00 | CL | Futures | 272.69 | 275.28 | 269.99 | 271.94 | 261.0 |
| 2008-10-19 19:00:00 | CL | Futures | 272.35 | 274.08 | 271.56 | 274.08 | 141.0 |
| 2008-10-19 20:00:00 | CL | Futures | 273.74 | 274.45 | 273.52 | 274.23 | 245.0 |
| 2008-10-19 21:00:00 | CL | Futures | 274.19 | 274.49 | 273.82 | 274.0 | 116.0 |
| 2008-10-19 22:00:00 | CL | Futures | 274.27 | 275.02 | 273.97 | 274.45 | 155.0 |
| 2008-10-19 23:00:00 | CL | Futures | 274.49 | 276.14 | 274.49 | 275.92 | 303.0 |
| 2008-10-19 18:00:00 | GC | Futures | 1119.8 | 1126.2 | 1117.2 | 1124.2 | 309.0 |
| 2008-10-19 19:00:00 | GC | Futures | 1123.8 | 1129.5 | 1122.4 | 1127.5 | 545.0 |
| 2008-10-19 20:00:00 | GC | Futures | 1127.5 | 1143.9 | 1127.4 | 1141.2 | 2217.0 |
| 2008-10-19 21:00:00 | GC | Futures | 1141.2 | 1142.2 | 1134.8 | 1137.5 | 989.0 |
| 2008-10-19 22:00:00 | GC | Futures | 1136.8 | 1140.3 | 1136.4 | 1140.2 | 486.0 |
| 2008-10-19 23:00:00 | GC | Futures | 1140.2 | 1143.9 | 1138.2 | 1143.9 | 915.0 |
| 2008-10-19 18:00:00 | ZN | Futures | 84.729907 | 84.753532 | 84.635409 | 84.706283 | 679.0 |
| 2008-10-19 19:00:00 | ZN | Futures | 84.706283 | 84.706283 | 84.517285 | 84.54091 | 1250.0 |
| 2008-10-19 20:00:00 | ZN | Futures | 84.529098 | 84.647221 | 84.517285 | 84.647221 | 1423.0 |
| 2008-10-19 21:00:00 | ZN | Futures | 84.635409 | 84.670846 | 84.611784 | 84.647221 | 642.0 |
| 2008-10-19 22:00:00 | ZN | Futures | 84.647221 | 84.647221 | 84.576347 | 84.611784 | 443.0 |
| 2008-10-19 23:00:00 | ZN | Futures | 84.611784 | 84.647221 | 84.588159 | 84.611784 | 1553.0 |
> showing 36 of 231 rows — these rows as CSV