PREVIEW / futures_1hour / 2008-12-23
file: by_date/futures_1hour/2008/2008-12-23.parquet size: 41 KB rows: 1,184
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-23 00:00:00 | ES | Futures | 826.35 | 828.49 | 826.12 | 827.78 | 1218.0 |
| 2008-12-23 01:00:00 | ES | Futures | 827.78 | 828.73 | 825.17 | 825.4 | 1266.0 |
| 2008-12-23 02:00:00 | ES | Futures | 825.4 | 826.83 | 824.69 | 824.93 | 1670.0 |
| 2008-12-23 03:00:00 | ES | Futures | 824.93 | 830.15 | 824.93 | 827.54 | 7744.0 |
| 2008-12-23 04:00:00 | ES | Futures | 827.54 | 831.81 | 826.35 | 830.86 | 8396.0 |
| 2008-12-23 05:00:00 | ES | Futures | 831.1 | 832.99 | 829.67 | 831.33 | 5735.0 |
| 2008-12-23 06:00:00 | ES | Futures | 831.33 | 831.81 | 826.59 | 828.49 | 6047.0 |
| 2008-12-23 07:00:00 | ES | Futures | 828.49 | 831.57 | 824.93 | 826.35 | 10411.0 |
| 2008-12-23 08:00:00 | ES | Futures | 826.35 | 829.67 | 825.88 | 828.49 | 14946.0 |
| 2008-12-23 09:00:00 | ES | Futures | 828.25 | 831.33 | 825.64 | 829.67 | 81645.0 |
| 2008-12-23 10:00:00 | ES | Futures | 829.67 | 832.52 | 824.69 | 827.78 | 163550.0 |
| 2008-12-23 11:00:00 | ES | Futures | 827.78 | 829.2 | 819.0 | 819.24 | 119569.0 |
| 2008-12-23 12:00:00 | ES | Futures | 819.24 | 819.71 | 815.44 | 818.76 | 109422.0 |
| 2008-12-23 13:00:00 | ES | Futures | 818.76 | 822.32 | 816.87 | 821.61 | 81439.0 |
| 2008-12-23 14:00:00 | ES | Futures | 821.61 | 823.03 | 812.83 | 814.97 | 130212.0 |
| 2008-12-23 15:00:00 | ES | Futures | 814.73 | 819.48 | 811.89 | 815.21 | 184242.0 |
| 2008-12-23 16:00:00 | ES | Futures | 815.21 | 816.15 | 811.41 | 814.97 | 51577.0 |
| 2008-12-23 17:00:00 | ES | Futures | 814.97 | 815.92 | 814.02 | 814.73 | 967.0 |
| 2008-12-23 18:00:00 | ES | Futures | 814.49 | 816.87 | 813.78 | 816.63 | 2291.0 |
| 2008-12-23 19:00:00 | ES | Futures | 816.63 | 817.34 | 814.73 | 815.21 | 1498.0 |
| 2008-12-23 20:00:00 | ES | Futures | 815.21 | 815.44 | 813.31 | 813.31 | 1294.0 |
| 2008-12-23 21:00:00 | ES | Futures | 813.55 | 814.97 | 812.83 | 813.78 | 1329.0 |
| 2008-12-23 22:00:00 | ES | Futures | 813.78 | 815.21 | 813.31 | 814.26 | 665.0 |
| 2008-12-23 23:00:00 | ES | Futures | 814.49 | 815.21 | 814.02 | 814.49 | 403.0 |
| 2008-12-23 00:00:00 | NQ | Futures | 1349.78 | 1352.32 | 1349.78 | 1349.78 | 53.0 |
| 2008-12-23 01:00:00 | NQ | Futures | 1350.34 | 1351.19 | 1348.37 | 1348.37 | 37.0 |
| 2008-12-23 02:00:00 | NQ | Futures | 1348.37 | 1349.5 | 1345.54 | 1347.52 | 125.0 |
| 2008-12-23 03:00:00 | NQ | Futures | 1348.09 | 1354.86 | 1347.52 | 1350.06 | 660.0 |
| 2008-12-23 04:00:00 | NQ | Futures | 1350.06 | 1353.73 | 1348.37 | 1352.6 | 422.0 |
| 2008-12-23 05:00:00 | NQ | Futures | 1352.6 | 1355.71 | 1351.19 | 1353.45 | 498.0 |
| 2008-12-23 06:00:00 | NQ | Futures | 1353.45 | 1353.73 | 1347.24 | 1350.34 | 287.0 |
| 2008-12-23 07:00:00 | NQ | Futures | 1350.34 | 1354.86 | 1345.26 | 1347.52 | 580.0 |
| 2008-12-23 08:00:00 | NQ | Futures | 1347.52 | 1351.47 | 1345.26 | 1348.93 | 2467.0 |
| 2008-12-23 09:00:00 | NQ | Futures | 1348.65 | 1359.38 | 1345.54 | 1358.25 | 17555.0 |
| 2008-12-23 10:00:00 | NQ | Futures | 1357.97 | 1362.77 | 1348.65 | 1354.86 | 26449.0 |
| 2008-12-23 11:00:00 | NQ | Futures | 1354.86 | 1357.97 | 1340.46 | 1341.31 | 13496.0 |
| 2008-12-23 12:00:00 | NQ | Futures | 1341.03 | 1342.44 | 1332.84 | 1339.05 | 16330.0 |
| 2008-12-23 13:00:00 | NQ | Futures | 1339.05 | 1342.72 | 1335.94 | 1341.59 | 8331.0 |
| 2008-12-23 14:00:00 | NQ | Futures | 1341.59 | 1342.44 | 1328.6 | 1332.55 | 15635.0 |
| 2008-12-23 15:00:00 | NQ | Futures | 1332.55 | 1343.0 | 1329.73 | 1337.35 | 23881.0 |
| 2008-12-23 16:00:00 | NQ | Futures | 1336.79 | 1341.31 | 1333.4 | 1340.18 | 6550.0 |
| 2008-12-23 17:00:00 | NQ | Futures | 1339.33 | 1340.46 | 1338.48 | 1339.05 | 108.0 |
| 2008-12-23 18:00:00 | NQ | Futures | 1339.61 | 1340.46 | 1337.35 | 1340.46 | 79.0 |
| 2008-12-23 19:00:00 | NQ | Futures | 1340.46 | 1342.16 | 1339.05 | 1339.05 | 42.0 |
| 2008-12-23 20:00:00 | NQ | Futures | 1338.77 | 1339.61 | 1335.94 | 1335.94 | 30.0 |
| 2008-12-23 21:00:00 | NQ | Futures | 1337.35 | 1337.92 | 1335.94 | 1336.79 | 79.0 |
| 2008-12-23 22:00:00 | NQ | Futures | 1335.66 | 1337.92 | 1335.66 | 1337.92 | 16.0 |
| 2008-12-23 23:00:00 | NQ | Futures | 1337.92 | 1339.61 | 1336.79 | 1339.61 | 191.0 |
| 2008-12-23 00:00:00 | YM | Futures | 7765.9 | 7783.2 | 7765.9 | 7775.0 | 168.0 |
| 2008-12-23 01:00:00 | YM | Futures | 7774.1 | 7782.3 | 7755.9 | 7756.8 | 191.0 |
> showing 50 of 1,184 rows — these rows as CSV