PREVIEW / futures_1hour / 2008-10-03
file: by_date/futures_1hour/2008/2008-10-03.parquet size: 39 KB rows: 1,033
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-03 00:00:00 | ES | Futures | 1070.37 | 1070.37 | 1068.71 | 1069.66 | 2709.0 |
| 2008-10-03 01:00:00 | ES | Futures | 1069.66 | 1070.37 | 1068.0 | 1069.89 | 2762.0 |
| 2008-10-03 02:00:00 | ES | Futures | 1070.13 | 1071.08 | 1067.53 | 1071.08 | 7464.0 |
| 2008-10-03 03:00:00 | ES | Futures | 1070.84 | 1072.5 | 1067.53 | 1068.24 | 18974.0 |
| 2008-10-03 04:00:00 | ES | Futures | 1068.24 | 1072.5 | 1067.29 | 1068.24 | 11308.0 |
| 2008-10-03 05:00:00 | ES | Futures | 1068.24 | 1072.26 | 1067.05 | 1070.84 | 9347.0 |
| 2008-10-03 06:00:00 | ES | Futures | 1070.84 | 1072.73 | 1068.95 | 1070.6 | 12208.0 |
| 2008-10-03 07:00:00 | ES | Futures | 1070.6 | 1075.1 | 1064.45 | 1067.76 | 35576.0 |
| 2008-10-03 08:00:00 | ES | Futures | 1067.76 | 1076.28 | 1060.19 | 1072.97 | 124685.0 |
| 2008-10-03 09:00:00 | ES | Futures | 1072.73 | 1081.96 | 1070.37 | 1080.54 | 263295.0 |
| 2008-10-03 10:00:00 | ES | Futures | 1080.54 | 1090.24 | 1073.68 | 1089.06 | 422104.0 |
| 2008-10-03 11:00:00 | ES | Futures | 1088.82 | 1094.03 | 1082.67 | 1085.99 | 267667.0 |
| 2008-10-03 12:00:00 | ES | Futures | 1085.75 | 1093.08 | 1078.41 | 1092.61 | 190678.0 |
| 2008-10-03 13:00:00 | ES | Futures | 1092.85 | 1099.0 | 1063.74 | 1072.97 | 670901.0 |
| 2008-10-03 14:00:00 | ES | Futures | 1072.73 | 1077.47 | 1051.43 | 1067.53 | 494745.0 |
| 2008-10-03 15:00:00 | ES | Futures | 1067.53 | 1071.31 | 1043.62 | 1046.7 | 484511.0 |
| 2008-10-03 16:00:00 | ES | Futures | 1046.94 | 1051.67 | 1045.99 | 1049.78 | 110120.0 |
| 2008-10-03 00:00:00 | NQ | Futures | 1717.02 | 1718.72 | 1715.32 | 1717.87 | 65.0 |
| 2008-10-03 01:00:00 | NQ | Futures | 1717.59 | 1719.29 | 1717.02 | 1717.59 | 49.0 |
| 2008-10-03 02:00:00 | NQ | Futures | 1717.59 | 1720.13 | 1716.74 | 1720.13 | 395.0 |
| 2008-10-03 03:00:00 | NQ | Futures | 1720.13 | 1722.4 | 1717.02 | 1717.02 | 1134.0 |
| 2008-10-03 04:00:00 | NQ | Futures | 1717.02 | 1721.27 | 1716.46 | 1718.15 | 732.0 |
| 2008-10-03 05:00:00 | NQ | Futures | 1717.87 | 1720.13 | 1716.17 | 1719.57 | 720.0 |
| 2008-10-03 06:00:00 | NQ | Futures | 1719.29 | 1721.27 | 1715.89 | 1719.29 | 582.0 |
| 2008-10-03 07:00:00 | NQ | Futures | 1719.0 | 1724.66 | 1710.51 | 1714.19 | 1836.0 |
| 2008-10-03 08:00:00 | NQ | Futures | 1714.19 | 1727.21 | 1702.31 | 1720.98 | 9623.0 |
| 2008-10-03 09:00:00 | NQ | Futures | 1720.98 | 1742.21 | 1712.78 | 1728.91 | 67601.0 |
| 2008-10-03 10:00:00 | NQ | Futures | 1728.91 | 1753.52 | 1723.81 | 1748.71 | 58061.0 |
| 2008-10-03 11:00:00 | NQ | Futures | 1749.28 | 1757.2 | 1743.9 | 1749.0 | 38969.0 |
| 2008-10-03 12:00:00 | NQ | Futures | 1748.71 | 1757.49 | 1736.55 | 1756.35 | 31014.0 |
| 2008-10-03 13:00:00 | NQ | Futures | 1756.64 | 1767.67 | 1693.25 | 1720.42 | 112271.0 |
| 2008-10-03 14:00:00 | NQ | Futures | 1720.42 | 1739.09 | 1682.78 | 1717.59 | 80892.0 |
| 2008-10-03 15:00:00 | NQ | Futures | 1717.3 | 1720.13 | 1669.2 | 1670.05 | 82527.0 |
| 2008-10-03 16:00:00 | NQ | Futures | 1670.62 | 1677.69 | 1669.2 | 1673.16 | 12048.0 |
| 2008-10-03 00:00:00 | YM | Futures | 9637.3 | 9638.2 | 9627.3 | 9630.0 | 75.0 |
| 2008-10-03 01:00:00 | YM | Futures | 9628.2 | 9637.3 | 9618.2 | 9634.5 | 135.0 |
| 2008-10-03 02:00:00 | YM | Futures | 9634.5 | 9643.6 | 9616.3 | 9634.5 | 746.0 |
| 2008-10-03 03:00:00 | YM | Futures | 9634.5 | 9649.1 | 9613.6 | 9614.5 | 1525.0 |
| 2008-10-03 04:00:00 | YM | Futures | 9613.6 | 9649.1 | 9608.2 | 9621.8 | 917.0 |
| 2008-10-03 05:00:00 | YM | Futures | 9620.0 | 9650.0 | 9613.6 | 9639.1 | 694.0 |
| 2008-10-03 06:00:00 | YM | Futures | 9639.1 | 9657.3 | 9622.7 | 9640.0 | 1219.0 |
| 2008-10-03 07:00:00 | YM | Futures | 9639.1 | 9676.4 | 9582.7 | 9609.1 | 2504.0 |
| 2008-10-03 08:00:00 | YM | Futures | 9608.2 | 9663.6 | 9531.8 | 9635.4 | 6557.0 |
| 2008-10-03 09:00:00 | YM | Futures | 9636.4 | 9691.8 | 9616.3 | 9682.7 | 17655.0 |
| 2008-10-03 10:00:00 | YM | Futures | 9683.6 | 9764.6 | 9632.7 | 9757.3 | 34511.0 |
| 2008-10-03 11:00:00 | YM | Futures | 9757.3 | 9795.5 | 9711.8 | 9738.2 | 24782.0 |
| 2008-10-03 12:00:00 | YM | Futures | 9738.2 | 9814.6 | 9680.0 | 9810.1 | 19278.0 |
| 2008-10-03 13:00:00 | YM | Futures | 9811.0 | 9847.4 | 9560.0 | 9640.9 | 72621.0 |
| 2008-10-03 14:00:00 | YM | Futures | 9640.9 | 9689.1 | 9486.3 | 9607.2 | 47741.0 |
| 2008-10-03 15:00:00 | YM | Futures | 9606.3 | 9628.2 | 9396.2 | 9415.3 | 42363.0 |
> showing 50 of 1,033 rows — these rows as CSV