PREVIEW / futures_1hour / 2008-10-24
file: by_date/futures_1hour/2008/2008-10-24.parquet size: 40 KB rows: 1,086
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-24 00:00:00 | ES | Futures | 851.47 | 854.78 | 847.44 | 847.44 | 8547.0 |
| 2008-10-24 01:00:00 | ES | Futures | 847.44 | 848.63 | 835.14 | 835.14 | 10997.0 |
| 2008-10-24 02:00:00 | ES | Futures | 835.37 | 835.37 | 816.91 | 821.65 | 28439.0 |
| 2008-10-24 03:00:00 | ES | Futures | 821.41 | 829.93 | 821.17 | 827.56 | 44232.0 |
| 2008-10-24 04:00:00 | ES | Futures | 827.56 | 827.56 | 809.58 | 809.82 | 50348.0 |
| 2008-10-24 05:00:00 | ES | Futures | 809.58 | 810.76 | 809.58 | 809.58 | 14658.0 |
| 2008-10-24 06:00:00 | ES | Futures | 809.58 | 809.58 | 809.58 | 809.58 | 1217.0 |
| 2008-10-24 07:00:00 | ES | Futures | 809.58 | 809.58 | 809.58 | 809.58 | 1131.0 |
| 2008-10-24 08:00:00 | ES | Futures | 809.58 | 809.58 | 809.58 | 809.58 | 2279.0 |
| 2008-10-24 09:00:00 | ES | Futures | 809.58 | 827.33 | 795.38 | 822.59 | 446178.0 |
| 2008-10-24 10:00:00 | ES | Futures | 822.59 | 831.11 | 808.87 | 823.78 | 575134.0 |
| 2008-10-24 11:00:00 | ES | Futures | 823.78 | 840.82 | 819.28 | 830.4 | 427427.0 |
| 2008-10-24 12:00:00 | ES | Futures | 830.4 | 835.14 | 817.86 | 822.36 | 253779.0 |
| 2008-10-24 13:00:00 | ES | Futures | 822.36 | 834.9 | 813.13 | 813.13 | 261125.0 |
| 2008-10-24 14:00:00 | ES | Futures | 813.36 | 839.87 | 811.23 | 837.27 | 379349.0 |
| 2008-10-24 15:00:00 | ES | Futures | 837.27 | 849.1 | 825.67 | 827.09 | 588959.0 |
| 2008-10-24 16:00:00 | ES | Futures | 826.85 | 827.09 | 816.2 | 821.65 | 163167.0 |
| 2008-10-24 00:00:00 | NQ | Futures | 1406.61 | 1412.27 | 1401.8 | 1406.33 | 1204.0 |
| 2008-10-24 01:00:00 | NQ | Futures | 1405.76 | 1407.74 | 1384.82 | 1386.52 | 1322.0 |
| 2008-10-24 02:00:00 | NQ | Futures | 1385.11 | 1385.67 | 1350.3 | 1352.56 | 2322.0 |
| 2008-10-24 03:00:00 | NQ | Futures | 1352.56 | 1367.84 | 1348.89 | 1364.73 | 2551.0 |
| 2008-10-24 04:00:00 | NQ | Futures | 1364.45 | 1364.73 | 1332.47 | 1335.59 | 2766.0 |
| 2008-10-24 05:00:00 | NQ | Futures | 1335.59 | 1335.59 | 1322.57 | 1327.38 | 3001.0 |
| 2008-10-24 06:00:00 | NQ | Futures | 1328.8 | 1336.72 | 1322.57 | 1322.57 | 1656.0 |
| 2008-10-24 07:00:00 | NQ | Futures | 1322.57 | 1325.68 | 1322.57 | 1322.57 | 334.0 |
| 2008-10-24 08:00:00 | NQ | Futures | 1322.57 | 1329.36 | 1322.57 | 1322.57 | 295.0 |
| 2008-10-24 09:00:00 | NQ | Futures | 1322.57 | 1365.58 | 1301.35 | 1355.11 | 68293.0 |
| 2008-10-24 10:00:00 | NQ | Futures | 1355.68 | 1373.22 | 1328.23 | 1353.7 | 85862.0 |
| 2008-10-24 11:00:00 | NQ | Futures | 1353.98 | 1387.94 | 1344.92 | 1375.2 | 69060.0 |
| 2008-10-24 12:00:00 | NQ | Futures | 1375.77 | 1385.11 | 1349.74 | 1358.51 | 51570.0 |
| 2008-10-24 13:00:00 | NQ | Futures | 1358.22 | 1376.62 | 1337.57 | 1337.85 | 49364.0 |
| 2008-10-24 14:00:00 | NQ | Futures | 1338.13 | 1379.73 | 1336.15 | 1376.05 | 71023.0 |
| 2008-10-24 15:00:00 | NQ | Futures | 1376.33 | 1392.75 | 1355.68 | 1358.79 | 93196.0 |
| 2008-10-24 16:00:00 | NQ | Futures | 1359.07 | 1359.07 | 1339.55 | 1351.43 | 19983.0 |
| 2008-10-24 00:00:00 | YM | Futures | 7824.6 | 7850.1 | 7790.0 | 7791.8 | 538.0 |
| 2008-10-24 01:00:00 | YM | Futures | 7793.7 | 7800.0 | 7678.2 | 7680.9 | 787.0 |
| 2008-10-24 02:00:00 | YM | Futures | 7678.2 | 7681.8 | 7559.9 | 7598.1 | 1702.0 |
| 2008-10-24 03:00:00 | YM | Futures | 7602.7 | 7674.5 | 7595.4 | 7648.1 | 3640.0 |
| 2008-10-24 04:00:00 | YM | Futures | 7642.7 | 7643.6 | 7503.5 | 7519.0 | 4123.0 |
| 2008-10-24 05:00:00 | YM | Futures | 7510.8 | 7539.0 | 7479.9 | 7479.9 | 957.0 |
| 2008-10-24 06:00:00 | YM | Futures | 7479.9 | 7496.3 | 7479.9 | 7479.9 | 830.0 |
| 2008-10-24 07:00:00 | YM | Futures | 7479.9 | 7479.9 | 7479.9 | 7479.9 | 74.0 |
| 2008-10-24 08:00:00 | YM | Futures | 7479.9 | 7479.9 | 7479.9 | 7479.9 | 46.0 |
| 2008-10-24 09:00:00 | YM | Futures | 7479.9 | 7626.3 | 7258.0 | 7585.4 | 35271.0 |
| 2008-10-24 10:00:00 | YM | Futures | 7585.4 | 7644.5 | 7447.1 | 7569.0 | 56625.0 |
| 2008-10-24 11:00:00 | YM | Futures | 7569.9 | 7728.2 | 7535.4 | 7637.2 | 39109.0 |
| 2008-10-24 12:00:00 | YM | Futures | 7637.2 | 7675.4 | 7521.7 | 7560.8 | 27361.0 |
| 2008-10-24 13:00:00 | YM | Futures | 7560.8 | 7671.8 | 7476.2 | 7479.9 | 29257.0 |
| 2008-10-24 14:00:00 | YM | Futures | 7478.1 | 7720.9 | 7466.2 | 7699.1 | 42407.0 |
| 2008-10-24 15:00:00 | YM | Futures | 7699.1 | 7789.1 | 7578.1 | 7589.9 | 66645.0 |
> showing 50 of 1,086 rows — these rows as CSV