PREVIEW / futures_1hour / 2008-10-12
file: by_date/futures_1hour/2008/2008-10-12.parquet size: 14 KB rows: 237
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-12 18:00:00 | ES | Futures | 860.93 | 877.5 | 860.69 | 870.87 | 59052.0 |
| 2008-10-12 19:00:00 | ES | Futures | 870.87 | 880.34 | 868.03 | 878.68 | 15984.0 |
| 2008-10-12 20:00:00 | ES | Futures | 878.68 | 881.28 | 873.95 | 875.13 | 11345.0 |
| 2008-10-12 21:00:00 | ES | Futures | 875.13 | 875.37 | 871.82 | 872.76 | 9425.0 |
| 2008-10-12 22:00:00 | ES | Futures | 872.76 | 873.71 | 866.37 | 869.69 | 15401.0 |
| 2008-10-12 23:00:00 | ES | Futures | 869.45 | 875.6 | 867.56 | 875.37 | 8738.0 |
| 2008-10-12 18:00:00 | NQ | Futures | 1468.58 | 1494.05 | 1468.58 | 1483.86 | 3948.0 |
| 2008-10-12 19:00:00 | NQ | Futures | 1484.43 | 1500.55 | 1483.58 | 1498.29 | 1660.0 |
| 2008-10-12 20:00:00 | NQ | Futures | 1499.42 | 1501.97 | 1492.63 | 1494.9 | 671.0 |
| 2008-10-12 21:00:00 | NQ | Futures | 1495.18 | 1496.88 | 1490.09 | 1490.09 | 471.0 |
| 2008-10-12 22:00:00 | NQ | Futures | 1491.78 | 1493.48 | 1481.03 | 1488.1 | 747.0 |
| 2008-10-12 23:00:00 | NQ | Futures | 1486.97 | 1493.76 | 1483.58 | 1493.76 | 322.0 |
| 2008-10-12 18:00:00 | YM | Futures | 7720.9 | 7871.9 | 7720.9 | 7816.4 | 1804.0 |
| 2008-10-12 19:00:00 | YM | Futures | 7816.4 | 7891.0 | 7803.7 | 7877.3 | 1007.0 |
| 2008-10-12 20:00:00 | YM | Futures | 7878.3 | 7894.6 | 7838.2 | 7846.4 | 861.0 |
| 2008-10-12 21:00:00 | YM | Futures | 7849.1 | 7850.1 | 7822.8 | 7828.2 | 311.0 |
| 2008-10-12 22:00:00 | YM | Futures | 7825.5 | 7834.6 | 7768.2 | 7798.2 | 773.0 |
| 2008-10-12 23:00:00 | YM | Futures | 7796.4 | 7845.5 | 7781.8 | 7843.7 | 660.0 |
| 2008-10-12 18:00:00 | CL | Futures | 302.18 | 305.12 | 301.35 | 302.9 | 1242.0 |
| 2008-10-12 19:00:00 | CL | Futures | 302.63 | 305.05 | 302.3 | 304.56 | 475.0 |
| 2008-10-12 20:00:00 | CL | Futures | 304.6 | 305.77 | 304.22 | 304.37 | 519.0 |
| 2008-10-12 21:00:00 | CL | Futures | 304.18 | 305.5 | 304.14 | 304.45 | 253.0 |
| 2008-10-12 22:00:00 | CL | Futures | 304.22 | 304.94 | 302.48 | 303.2 | 272.0 |
| 2008-10-12 23:00:00 | CL | Futures | 303.35 | 303.35 | 299.66 | 300.26 | 614.0 |
| 2008-10-12 18:00:00 | GC | Futures | 1221.4 | 1225.3 | 1202.9 | 1225.0 | 1430.0 |
| 2008-10-12 19:00:00 | GC | Futures | 1224.6 | 1237.7 | 1216.8 | 1225.7 | 1749.0 |
| 2008-10-12 20:00:00 | GC | Futures | 1225.7 | 1236.4 | 1222.6 | 1225.4 | 1546.0 |
| 2008-10-12 21:00:00 | GC | Futures | 1224.6 | 1231.7 | 1222.6 | 1228.1 | 2136.0 |
| 2008-10-12 22:00:00 | GC | Futures | 1229.1 | 1248.8 | 1229.1 | 1246.0 | 2205.0 |
| 2008-10-12 23:00:00 | GC | Futures | 1246.4 | 1247.7 | 1236.0 | 1238.5 | 836.0 |
| 2008-10-12 18:00:00 | ZN | Futures | 85.533147 | 85.533147 | 85.202401 | 85.261463 | 4216.0 |
| 2008-10-12 19:00:00 | ZN | Futures | 85.261463 | 85.308712 | 85.155152 | 85.226026 | 2048.0 |
| 2008-10-12 20:00:00 | ZN | Futures | 85.214213 | 85.24965 | 85.072465 | 85.190589 | 1711.0 |
| 2008-10-12 21:00:00 | ZN | Futures | 85.202401 | 85.379586 | 85.190589 | 85.320524 | 966.0 |
| 2008-10-12 22:00:00 | ZN | Futures | 85.332337 | 85.367774 | 85.273275 | 85.367774 | 793.0 |
| 2008-10-12 23:00:00 | ZN | Futures | 85.367774 | 85.403211 | 85.320524 | 85.332337 | 461.0 |
> showing 36 of 237 rows — these rows as CSV