PREVIEW / futures_1hour / 2008-11-12
file: by_date/futures_1hour/2008/2008-11-12.parquet size: 46 KB rows: 1,277
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-11-12 00:00:00 | ES | Futures | 853.12 | 856.2 | 851.94 | 855.73 | 2715.0 |
| 2008-11-12 01:00:00 | ES | Futures | 855.73 | 858.33 | 855.25 | 856.67 | 3556.0 |
| 2008-11-12 02:00:00 | ES | Futures | 857.14 | 859.98 | 855.96 | 857.14 | 5761.0 |
| 2008-11-12 03:00:00 | ES | Futures | 856.91 | 859.51 | 846.73 | 848.39 | 27879.0 |
| 2008-11-12 04:00:00 | ES | Futures | 848.63 | 850.76 | 841.53 | 843.66 | 17639.0 |
| 2008-11-12 05:00:00 | ES | Futures | 843.66 | 846.97 | 843.18 | 846.97 | 13543.0 |
| 2008-11-12 06:00:00 | ES | Futures | 846.97 | 853.83 | 845.08 | 853.6 | 17664.0 |
| 2008-11-12 07:00:00 | ES | Futures | 853.83 | 854.54 | 840.34 | 841.29 | 42828.0 |
| 2008-11-12 08:00:00 | ES | Futures | 841.53 | 843.42 | 834.43 | 836.32 | 81114.0 |
| 2008-11-12 09:00:00 | ES | Futures | 836.56 | 838.45 | 828.27 | 834.19 | 309672.0 |
| 2008-11-12 10:00:00 | ES | Futures | 833.95 | 837.98 | 819.04 | 824.01 | 575293.0 |
| 2008-11-12 11:00:00 | ES | Futures | 824.01 | 826.85 | 817.62 | 823.54 | 394977.0 |
| 2008-11-12 12:00:00 | ES | Futures | 823.54 | 828.51 | 818.81 | 827.33 | 196079.0 |
| 2008-11-12 13:00:00 | ES | Futures | 827.56 | 828.98 | 815.02 | 816.91 | 224654.0 |
| 2008-11-12 14:00:00 | ES | Futures | 816.68 | 822.12 | 812.65 | 813.36 | 308581.0 |
| 2008-11-12 15:00:00 | ES | Futures | 813.13 | 814.31 | 803.19 | 806.98 | 600782.0 |
| 2008-11-12 16:00:00 | ES | Futures | 807.21 | 811.0 | 805.32 | 807.92 | 144270.0 |
| 2008-11-12 17:00:00 | ES | Futures | 807.92 | 807.92 | 796.33 | 799.4 | 19565.0 |
| 2008-11-12 18:00:00 | ES | Futures | 798.93 | 801.77 | 798.46 | 801.06 | 5614.0 |
| 2008-11-12 19:00:00 | ES | Futures | 800.82 | 803.43 | 799.17 | 799.4 | 5745.0 |
| 2008-11-12 20:00:00 | ES | Futures | 799.4 | 804.37 | 799.17 | 803.43 | 3368.0 |
| 2008-11-12 21:00:00 | ES | Futures | 803.43 | 803.9 | 800.35 | 801.53 | 2622.0 |
| 2008-11-12 22:00:00 | ES | Futures | 801.53 | 803.19 | 799.4 | 800.82 | 2880.0 |
| 2008-11-12 23:00:00 | ES | Futures | 801.06 | 801.06 | 797.98 | 800.59 | 3676.0 |
| 2008-11-12 00:00:00 | NQ | Futures | 1396.14 | 1399.82 | 1394.44 | 1399.82 | 184.0 |
| 2008-11-12 01:00:00 | NQ | Futures | 1399.82 | 1402.93 | 1398.4 | 1400.39 | 115.0 |
| 2008-11-12 02:00:00 | NQ | Futures | 1400.39 | 1406.61 | 1399.25 | 1402.37 | 133.0 |
| 2008-11-12 03:00:00 | NQ | Futures | 1400.67 | 1403.22 | 1385.11 | 1387.65 | 1680.0 |
| 2008-11-12 04:00:00 | NQ | Futures | 1387.65 | 1389.35 | 1369.26 | 1373.22 | 2148.0 |
| 2008-11-12 05:00:00 | NQ | Futures | 1372.66 | 1379.73 | 1372.66 | 1379.45 | 740.0 |
| 2008-11-12 06:00:00 | NQ | Futures | 1379.16 | 1393.03 | 1377.18 | 1392.75 | 933.0 |
| 2008-11-12 07:00:00 | NQ | Futures | 1392.18 | 1394.16 | 1371.81 | 1373.22 | 1837.0 |
| 2008-11-12 08:00:00 | NQ | Futures | 1372.66 | 1375.2 | 1363.32 | 1367.56 | 7054.0 |
| 2008-11-12 09:00:00 | NQ | Futures | 1367.56 | 1371.24 | 1353.7 | 1362.75 | 43710.0 |
| 2008-11-12 10:00:00 | NQ | Futures | 1362.47 | 1368.98 | 1347.47 | 1357.38 | 67576.0 |
| 2008-11-12 11:00:00 | NQ | Futures | 1357.38 | 1359.64 | 1344.08 | 1350.3 | 44847.0 |
| 2008-11-12 12:00:00 | NQ | Futures | 1350.02 | 1355.96 | 1340.96 | 1355.68 | 29806.0 |
| 2008-11-12 13:00:00 | NQ | Futures | 1355.96 | 1357.66 | 1337.0 | 1339.27 | 30578.0 |
| 2008-11-12 14:00:00 | NQ | Futures | 1339.27 | 1341.81 | 1327.95 | 1328.23 | 41334.0 |
| 2008-11-12 15:00:00 | NQ | Futures | 1328.23 | 1333.89 | 1318.04 | 1320.87 | 79186.0 |
| 2008-11-12 16:00:00 | NQ | Futures | 1320.87 | 1324.83 | 1312.95 | 1314.65 | 19132.0 |
| 2008-11-12 17:00:00 | NQ | Futures | 1314.08 | 1314.08 | 1290.31 | 1295.41 | 3615.0 |
| 2008-11-12 18:00:00 | NQ | Futures | 1296.54 | 1296.82 | 1292.29 | 1295.97 | 563.0 |
| 2008-11-12 19:00:00 | NQ | Futures | 1296.26 | 1301.63 | 1294.56 | 1294.84 | 338.0 |
| 2008-11-12 20:00:00 | NQ | Futures | 1295.69 | 1301.63 | 1295.69 | 1300.5 | 200.0 |
| 2008-11-12 21:00:00 | NQ | Futures | 1300.5 | 1301.35 | 1296.82 | 1297.67 | 169.0 |
| 2008-11-12 22:00:00 | NQ | Futures | 1298.8 | 1300.5 | 1295.12 | 1299.08 | 185.0 |
| 2008-11-12 23:00:00 | NQ | Futures | 1298.8 | 1298.8 | 1293.99 | 1297.39 | 141.0 |
| 2008-11-12 00:00:00 | YM | Futures | 7908.3 | 7940.1 | 7897.4 | 7928.3 | 241.0 |
| 2008-11-12 01:00:00 | YM | Futures | 7931.0 | 7952.8 | 7929.2 | 7938.3 | 266.0 |
> showing 50 of 1,277 rows — these rows as CSV