PREVIEW / futures_1hour / 2008-02-24
file: by_date/futures_1hour/2008/2008-02-24.parquet size: 12 KB rows: 200
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-02-24 18:00:00 | ES | Futures | 1263.24 | 1266.97 | 1262.77 | 1266.27 | 6591.0 |
| 2008-02-24 19:00:00 | ES | Futures | 1266.5 | 1272.1 | 1266.5 | 1270.93 | 8619.0 |
| 2008-02-24 20:00:00 | ES | Futures | 1271.17 | 1271.63 | 1269.54 | 1269.77 | 4249.0 |
| 2008-02-24 21:00:00 | ES | Futures | 1270.0 | 1270.0 | 1267.67 | 1268.84 | 4273.0 |
| 2008-02-24 22:00:00 | ES | Futures | 1268.84 | 1270.0 | 1268.37 | 1269.07 | 1623.0 |
| 2008-02-24 23:00:00 | ES | Futures | 1269.07 | 1271.17 | 1268.84 | 1270.93 | 1264.0 |
| 2008-02-24 18:00:00 | NQ | Futures | 2016.43 | 2026.64 | 2015.57 | 2022.67 | 476.0 |
| 2008-02-24 19:00:00 | NQ | Futures | 2023.24 | 2032.32 | 2023.24 | 2030.33 | 325.0 |
| 2008-02-24 20:00:00 | NQ | Futures | 2030.05 | 2033.17 | 2030.05 | 2030.33 | 237.0 |
| 2008-02-24 21:00:00 | NQ | Futures | 2031.19 | 2031.19 | 2026.93 | 2028.63 | 212.0 |
| 2008-02-24 22:00:00 | NQ | Futures | 2027.5 | 2029.77 | 2027.21 | 2028.63 | 86.0 |
| 2008-02-24 23:00:00 | NQ | Futures | 2028.63 | 2032.6 | 2028.35 | 2032.04 | 170.0 |
| 2008-02-24 18:00:00 | YM | Futures | 11259.9 | 11285.4 | 11249.0 | 11274.5 | 450.0 |
| 2008-02-24 19:00:00 | YM | Futures | 11276.3 | 11315.3 | 11276.3 | 11308.1 | 782.0 |
| 2008-02-24 20:00:00 | YM | Futures | 11308.1 | 11315.3 | 11299.0 | 11299.9 | 411.0 |
| 2008-02-24 21:00:00 | YM | Futures | 11299.0 | 11300.8 | 11281.7 | 11293.5 | 276.0 |
| 2008-02-24 22:00:00 | YM | Futures | 11294.4 | 11309.0 | 11292.6 | 11298.1 | 137.0 |
| 2008-02-24 23:00:00 | YM | Futures | 11300.8 | 11314.4 | 11294.4 | 11314.4 | 98.0 |
| 2008-02-24 18:00:00 | CL | Futures | 369.62 | 372.24 | 369.29 | 371.49 | 1033.0 |
| 2008-02-24 19:00:00 | CL | Futures | 371.53 | 372.27 | 371.26 | 371.53 | 599.0 |
| 2008-02-24 20:00:00 | CL | Futures | 371.53 | 372.01 | 371.3 | 371.45 | 279.0 |
| 2008-02-24 21:00:00 | CL | Futures | 371.41 | 371.82 | 371.23 | 371.82 | 191.0 |
| 2008-02-24 22:00:00 | CL | Futures | 371.79 | 371.82 | 371.45 | 371.71 | 116.0 |
| 2008-02-24 23:00:00 | CL | Futures | 371.75 | 372.27 | 371.53 | 371.53 | 245.0 |
| 2008-02-24 18:00:00 | GC | Futures | 1380.0 | 1384.4 | 1379.6 | 1384.0 | 1327.0 |
| 2008-02-24 19:00:00 | GC | Futures | 1383.7 | 1385.4 | 1381.9 | 1383.1 | 2032.0 |
| 2008-02-24 20:00:00 | GC | Futures | 1383.5 | 1384.1 | 1382.1 | 1383.1 | 630.0 |
| 2008-02-24 21:00:00 | GC | Futures | 1383.2 | 1383.5 | 1382.2 | 1383.0 | 226.0 |
| 2008-02-24 22:00:00 | GC | Futures | 1382.8 | 1385.6 | 1382.1 | 1384.8 | 619.0 |
| 2008-02-24 23:00:00 | GC | Futures | 1384.7 | 1384.8 | 1382.5 | 1383.7 | 617.0 |
| 2008-02-24 18:00:00 | ZN | Futures | 84.838733 | 84.87291 | 84.804556 | 84.838733 | 7648.0 |
| 2008-02-24 19:00:00 | ZN | Futures | 84.838733 | 84.838733 | 84.770379 | 84.804556 | 5199.0 |
| 2008-02-24 20:00:00 | ZN | Futures | 84.793164 | 84.804556 | 84.781772 | 84.804556 | 2412.0 |
| 2008-02-24 21:00:00 | ZN | Futures | 84.815949 | 84.838733 | 84.804556 | 84.804556 | 1957.0 |
| 2008-02-24 22:00:00 | ZN | Futures | 84.804556 | 84.815949 | 84.781772 | 84.804556 | 1469.0 |
| 2008-02-24 23:00:00 | ZN | Futures | 84.804556 | 84.815949 | 84.793164 | 84.793164 | 1982.0 |
> showing 36 of 200 rows — these rows as CSV