PREVIEW / futures_30min / 2008-09-26
file: by_date/futures_30min/2008/2008-09-26.parquet size: 59 KB rows: 1,838
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-09-26 00:00:00 | ES | Futures | 1130.24 | 1130.24 | 1128.11 | 1129.06 | 2802.0 |
| 2008-09-26 00:30:00 | ES | Futures | 1129.29 | 1129.77 | 1127.4 | 1128.58 | 3586.0 |
| 2008-09-26 01:00:00 | ES | Futures | 1128.82 | 1129.77 | 1127.64 | 1129.77 | 3377.0 |
| 2008-09-26 01:30:00 | ES | Futures | 1129.53 | 1131.9 | 1129.53 | 1131.9 | 1553.0 |
| 2008-09-26 02:00:00 | ES | Futures | 1131.19 | 1132.13 | 1130.95 | 1131.66 | 4154.0 |
| 2008-09-26 02:30:00 | ES | Futures | 1131.66 | 1132.84 | 1131.19 | 1131.42 | 6948.0 |
| 2008-09-26 03:00:00 | ES | Futures | 1131.19 | 1131.42 | 1128.35 | 1128.35 | 11830.0 |
| 2008-09-26 03:30:00 | ES | Futures | 1128.35 | 1130.71 | 1128.11 | 1130.24 | 7396.0 |
| 2008-09-26 04:00:00 | ES | Futures | 1130.0 | 1130.95 | 1128.35 | 1130.48 | 5200.0 |
| 2008-09-26 04:30:00 | ES | Futures | 1130.71 | 1134.03 | 1129.77 | 1132.61 | 6141.0 |
| 2008-09-26 05:00:00 | ES | Futures | 1132.61 | 1134.03 | 1132.13 | 1132.61 | 4433.0 |
| 2008-09-26 05:30:00 | ES | Futures | 1132.84 | 1133.55 | 1128.58 | 1129.53 | 6520.0 |
| 2008-09-26 06:00:00 | ES | Futures | 1129.77 | 1130.48 | 1128.58 | 1129.29 | 4928.0 |
| 2008-09-26 06:30:00 | ES | Futures | 1129.06 | 1130.48 | 1125.51 | 1130.24 | 15677.0 |
| 2008-09-26 07:00:00 | ES | Futures | 1130.24 | 1130.71 | 1126.93 | 1128.58 | 12651.0 |
| 2008-09-26 07:30:00 | ES | Futures | 1128.58 | 1132.84 | 1127.64 | 1130.0 | 20143.0 |
| 2008-09-26 08:00:00 | ES | Futures | 1130.0 | 1131.19 | 1125.98 | 1126.69 | 20074.0 |
| 2008-09-26 08:30:00 | ES | Futures | 1126.45 | 1128.82 | 1121.48 | 1124.09 | 46077.0 |
| 2008-09-26 09:00:00 | ES | Futures | 1123.85 | 1132.84 | 1123.85 | 1129.29 | 54714.0 |
| 2008-09-26 09:30:00 | ES | Futures | 1129.29 | 1138.99 | 1126.22 | 1133.55 | 254028.0 |
| 2008-09-26 10:00:00 | ES | Futures | 1133.32 | 1138.28 | 1131.19 | 1134.03 | 150509.0 |
| 2008-09-26 10:30:00 | ES | Futures | 1133.79 | 1141.36 | 1132.37 | 1138.28 | 166313.0 |
| 2008-09-26 11:00:00 | ES | Futures | 1138.28 | 1140.18 | 1131.66 | 1136.39 | 158440.0 |
| 2008-09-26 11:30:00 | ES | Futures | 1136.39 | 1138.05 | 1130.24 | 1131.66 | 102045.0 |
| 2008-09-26 12:00:00 | ES | Futures | 1131.66 | 1133.79 | 1129.53 | 1132.84 | 83214.0 |
| 2008-09-26 12:30:00 | ES | Futures | 1132.61 | 1138.52 | 1132.61 | 1138.28 | 97088.0 |
| 2008-09-26 13:00:00 | ES | Futures | 1138.05 | 1144.44 | 1136.86 | 1142.31 | 142386.0 |
| 2008-09-26 13:30:00 | ES | Futures | 1142.31 | 1146.8 | 1140.65 | 1142.31 | 98411.0 |
| 2008-09-26 14:00:00 | ES | Futures | 1142.31 | 1145.62 | 1139.94 | 1140.65 | 69986.0 |
| 2008-09-26 14:30:00 | ES | Futures | 1140.41 | 1143.96 | 1138.76 | 1139.23 | 67597.0 |
| 2008-09-26 15:00:00 | ES | Futures | 1139.23 | 1149.88 | 1134.26 | 1146.8 | 175535.0 |
| 2008-09-26 15:30:00 | ES | Futures | 1146.8 | 1155.8 | 1145.38 | 1154.14 | 212143.0 |
| 2008-09-26 16:00:00 | ES | Futures | 1154.14 | 1154.38 | 1149.17 | 1149.88 | 87129.0 |
| 2008-09-26 00:00:00 | NQ | Futures | 1873.22 | 1873.5 | 1870.95 | 1873.22 | 47.0 |
| 2008-09-26 00:30:00 | NQ | Futures | 1873.78 | 1875.76 | 1869.82 | 1875.76 | 130.0 |
| 2008-09-26 01:00:00 | NQ | Futures | 1874.35 | 1875.2 | 1872.93 | 1874.07 | 67.0 |
| 2008-09-26 01:30:00 | NQ | Futures | 1875.48 | 1878.88 | 1875.48 | 1877.46 | 88.0 |
| 2008-09-26 02:00:00 | NQ | Futures | 1876.61 | 1880.01 | 1876.61 | 1879.16 | 90.0 |
| 2008-09-26 02:30:00 | NQ | Futures | 1878.31 | 1880.86 | 1876.9 | 1877.74 | 216.0 |
| 2008-09-26 03:00:00 | NQ | Futures | 1876.9 | 1878.31 | 1873.22 | 1876.05 | 435.0 |
| 2008-09-26 03:30:00 | NQ | Futures | 1875.76 | 1880.29 | 1875.76 | 1878.03 | 218.0 |
| 2008-09-26 04:00:00 | NQ | Futures | 1878.31 | 1880.29 | 1876.9 | 1879.44 | 179.0 |
| 2008-09-26 04:30:00 | NQ | Futures | 1878.59 | 1884.25 | 1878.31 | 1881.42 | 739.0 |
| 2008-09-26 05:00:00 | NQ | Futures | 1881.14 | 1884.25 | 1880.29 | 1881.99 | 471.0 |
| 2008-09-26 05:30:00 | NQ | Futures | 1882.56 | 1883.97 | 1880.01 | 1882.56 | 608.0 |
| 2008-09-26 06:00:00 | NQ | Futures | 1882.56 | 1882.56 | 1879.16 | 1879.73 | 320.0 |
| 2008-09-26 06:30:00 | NQ | Futures | 1879.44 | 1879.44 | 1873.22 | 1878.88 | 913.0 |
| 2008-09-26 07:00:00 | NQ | Futures | 1878.59 | 1878.88 | 1873.22 | 1876.05 | 613.0 |
| 2008-09-26 07:30:00 | NQ | Futures | 1875.76 | 1878.59 | 1872.65 | 1877.74 | 1421.0 |
| 2008-09-26 08:00:00 | NQ | Futures | 1877.18 | 1879.16 | 1861.9 | 1862.18 | 3717.0 |
> showing 50 of 1,838 rows — these rows as CSV