PREVIEW / futures_1hour / 2008-12-02
file: by_date/futures_1hour/2008/2008-12-02.parquet size: 43 KB rows: 1,235
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-12-02 00:00:00 | ES | Futures | 776.45 | 777.16 | 773.37 | 773.61 | 3474.0 |
| 2008-12-02 01:00:00 | ES | Futures | 773.61 | 776.21 | 772.19 | 773.84 | 3287.0 |
| 2008-12-02 02:00:00 | ES | Futures | 774.08 | 775.26 | 771.0 | 774.08 | 15050.0 |
| 2008-12-02 03:00:00 | ES | Futures | 774.32 | 776.92 | 769.82 | 774.08 | 33392.0 |
| 2008-12-02 04:00:00 | ES | Futures | 774.08 | 780.94 | 772.9 | 780.47 | 25486.0 |
| 2008-12-02 05:00:00 | ES | Futures | 780.23 | 788.04 | 780.0 | 783.31 | 36763.0 |
| 2008-12-02 06:00:00 | ES | Futures | 783.31 | 791.36 | 782.84 | 790.88 | 39606.0 |
| 2008-12-02 07:00:00 | ES | Futures | 790.88 | 792.07 | 784.02 | 787.1 | 44418.0 |
| 2008-12-02 08:00:00 | ES | Futures | 787.33 | 789.94 | 781.89 | 788.28 | 62929.0 |
| 2008-12-02 09:00:00 | ES | Futures | 788.28 | 788.52 | 774.08 | 777.16 | 305936.0 |
| 2008-12-02 10:00:00 | ES | Futures | 777.39 | 796.33 | 776.45 | 792.07 | 475876.0 |
| 2008-12-02 11:00:00 | ES | Futures | 791.83 | 798.69 | 787.33 | 796.8 | 329928.0 |
| 2008-12-02 12:00:00 | ES | Futures | 796.8 | 802.72 | 796.09 | 798.93 | 195032.0 |
| 2008-12-02 13:00:00 | ES | Futures | 798.69 | 801.3 | 787.33 | 788.52 | 251878.0 |
| 2008-12-02 14:00:00 | ES | Futures | 788.28 | 789.94 | 774.08 | 787.81 | 489331.0 |
| 2008-12-02 15:00:00 | ES | Futures | 788.04 | 805.08 | 779.05 | 804.14 | 718092.0 |
| 2008-12-02 16:00:00 | ES | Futures | 803.9 | 806.5 | 801.53 | 803.43 | 117975.0 |
| 2008-12-02 17:00:00 | ES | Futures | 803.19 | 804.14 | 802.01 | 802.01 | 3168.0 |
| 2008-12-02 18:00:00 | ES | Futures | 801.77 | 802.01 | 799.88 | 800.11 | 4286.0 |
| 2008-12-02 19:00:00 | ES | Futures | 800.35 | 802.01 | 799.4 | 799.88 | 4911.0 |
| 2008-12-02 20:00:00 | ES | Futures | 799.88 | 799.88 | 796.56 | 798.46 | 4813.0 |
| 2008-12-02 21:00:00 | ES | Futures | 798.46 | 799.88 | 797.75 | 799.4 | 3314.0 |
| 2008-12-02 22:00:00 | ES | Futures | 799.17 | 799.88 | 796.56 | 798.93 | 3141.0 |
| 2008-12-02 23:00:00 | ES | Futures | 798.93 | 798.93 | 796.56 | 797.75 | 1686.0 |
| 2008-12-02 00:00:00 | NQ | Futures | 1242.78 | 1243.06 | 1238.81 | 1239.95 | 100.0 |
| 2008-12-02 01:00:00 | NQ | Futures | 1239.95 | 1243.34 | 1236.83 | 1242.21 | 140.0 |
| 2008-12-02 02:00:00 | NQ | Futures | 1240.23 | 1241.36 | 1235.98 | 1239.95 | 254.0 |
| 2008-12-02 03:00:00 | NQ | Futures | 1240.51 | 1247.87 | 1234.85 | 1247.3 | 1912.0 |
| 2008-12-02 04:00:00 | NQ | Futures | 1247.3 | 1255.51 | 1245.6 | 1255.23 | 2120.0 |
| 2008-12-02 05:00:00 | NQ | Futures | 1255.23 | 1263.15 | 1254.38 | 1256.07 | 1678.0 |
| 2008-12-02 06:00:00 | NQ | Futures | 1256.92 | 1270.79 | 1256.64 | 1270.51 | 2238.0 |
| 2008-12-02 07:00:00 | NQ | Futures | 1270.51 | 1272.2 | 1258.34 | 1261.45 | 2582.0 |
| 2008-12-02 08:00:00 | NQ | Futures | 1261.17 | 1261.45 | 1252.11 | 1257.21 | 5915.0 |
| 2008-12-02 09:00:00 | NQ | Futures | 1256.92 | 1258.06 | 1234.0 | 1243.34 | 41868.0 |
| 2008-12-02 10:00:00 | NQ | Futures | 1243.06 | 1272.2 | 1240.79 | 1269.37 | 55650.0 |
| 2008-12-02 11:00:00 | NQ | Futures | 1269.66 | 1277.3 | 1261.73 | 1274.75 | 36162.0 |
| 2008-12-02 12:00:00 | NQ | Futures | 1274.47 | 1282.39 | 1271.07 | 1277.01 | 25934.0 |
| 2008-12-02 13:00:00 | NQ | Futures | 1276.73 | 1280.69 | 1260.6 | 1262.02 | 25276.0 |
| 2008-12-02 14:00:00 | NQ | Futures | 1261.73 | 1264.0 | 1240.51 | 1261.73 | 57483.0 |
| 2008-12-02 15:00:00 | NQ | Futures | 1261.45 | 1281.82 | 1246.17 | 1280.98 | 95953.0 |
| 2008-12-02 16:00:00 | NQ | Futures | 1280.69 | 1286.35 | 1277.01 | 1282.11 | 18807.0 |
| 2008-12-02 17:00:00 | NQ | Futures | 1281.54 | 1282.11 | 1280.41 | 1280.41 | 196.0 |
| 2008-12-02 18:00:00 | NQ | Futures | 1279.84 | 1280.13 | 1277.58 | 1277.86 | 121.0 |
| 2008-12-02 19:00:00 | NQ | Futures | 1277.3 | 1279.84 | 1276.73 | 1276.73 | 100.0 |
| 2008-12-02 20:00:00 | NQ | Futures | 1277.3 | 1277.3 | 1271.64 | 1276.45 | 143.0 |
| 2008-12-02 21:00:00 | NQ | Futures | 1275.6 | 1277.3 | 1273.9 | 1275.32 | 323.0 |
| 2008-12-02 22:00:00 | NQ | Futures | 1275.32 | 1276.45 | 1270.51 | 1273.62 | 175.0 |
| 2008-12-02 23:00:00 | NQ | Futures | 1271.35 | 1272.77 | 1270.79 | 1272.2 | 54.0 |
| 2008-12-02 00:00:00 | YM | Futures | 7452.6 | 7457.1 | 7422.6 | 7427.1 | 343.0 |
| 2008-12-02 01:00:00 | YM | Futures | 7425.3 | 7448.0 | 7415.3 | 7429.9 | 224.0 |
> showing 50 of 1,235 rows — these rows as CSV