PREVIEW / futures_1hour / 2008-09-24
file: by_date/futures_1hour/2008/2008-09-24.parquet size: 44 KB rows: 1,234
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-24 00:00:00 | ES | Futures | 1138.28 | 1138.52 | 1135.92 | 1136.63 | 3673.0 |
| 2008-09-24 01:00:00 | ES | Futures | 1136.63 | 1138.05 | 1136.39 | 1137.57 | 3061.0 |
| 2008-09-24 02:00:00 | ES | Futures | 1137.81 | 1139.7 | 1134.74 | 1139.23 | 11828.0 |
| 2008-09-24 03:00:00 | ES | Futures | 1139.47 | 1140.65 | 1135.68 | 1137.81 | 21135.0 |
| 2008-09-24 04:00:00 | ES | Futures | 1137.57 | 1139.7 | 1136.63 | 1138.76 | 16183.0 |
| 2008-09-24 05:00:00 | ES | Futures | 1138.76 | 1141.36 | 1135.21 | 1135.44 | 17893.0 |
| 2008-09-24 06:00:00 | ES | Futures | 1135.44 | 1136.39 | 1131.19 | 1133.32 | 23334.0 |
| 2008-09-24 07:00:00 | ES | Futures | 1133.32 | 1136.39 | 1125.98 | 1132.61 | 45281.0 |
| 2008-09-24 08:00:00 | ES | Futures | 1132.61 | 1137.57 | 1129.77 | 1133.79 | 62150.0 |
| 2008-09-24 09:00:00 | ES | Futures | 1133.79 | 1134.74 | 1121.01 | 1126.22 | 302720.0 |
| 2008-09-24 10:00:00 | ES | Futures | 1126.22 | 1131.19 | 1119.12 | 1130.95 | 391535.0 |
| 2008-09-24 11:00:00 | ES | Futures | 1130.71 | 1131.19 | 1120.06 | 1125.98 | 286894.0 |
| 2008-09-24 12:00:00 | ES | Futures | 1125.74 | 1128.35 | 1121.01 | 1124.09 | 161501.0 |
| 2008-09-24 13:00:00 | ES | Futures | 1124.32 | 1134.97 | 1123.14 | 1128.35 | 250584.0 |
| 2008-09-24 14:00:00 | ES | Futures | 1128.11 | 1134.03 | 1123.85 | 1126.69 | 231422.0 |
| 2008-09-24 15:00:00 | ES | Futures | 1126.69 | 1129.53 | 1117.22 | 1127.4 | 392450.0 |
| 2008-09-24 16:00:00 | ES | Futures | 1127.4 | 1129.77 | 1126.45 | 1129.53 | 84032.0 |
| 2008-09-24 17:00:00 | ES | Futures | 1129.29 | 1129.29 | 1124.8 | 1125.03 | 3947.0 |
| 2008-09-24 18:00:00 | ES | Futures | 1125.27 | 1128.11 | 1125.27 | 1127.4 | 4497.0 |
| 2008-09-24 19:00:00 | ES | Futures | 1127.4 | 1129.06 | 1125.03 | 1125.03 | 3666.0 |
| 2008-09-24 20:00:00 | ES | Futures | 1125.03 | 1129.06 | 1124.56 | 1127.4 | 4802.0 |
| 2008-09-24 21:00:00 | ES | Futures | 1127.4 | 1134.97 | 1122.67 | 1132.13 | 18916.0 |
| 2008-09-24 22:00:00 | ES | Futures | 1132.13 | 1134.26 | 1131.42 | 1132.13 | 5527.0 |
| 2008-09-24 23:00:00 | ES | Futures | 1132.13 | 1132.13 | 1128.35 | 1129.77 | 4235.0 |
| 2008-09-24 00:00:00 | NQ | Futures | 1895.57 | 1896.14 | 1892.18 | 1894.72 | 664.0 |
| 2008-09-24 01:00:00 | NQ | Futures | 1893.87 | 1895.01 | 1893.59 | 1894.72 | 204.0 |
| 2008-09-24 02:00:00 | NQ | Futures | 1895.57 | 1898.4 | 1890.76 | 1897.84 | 485.0 |
| 2008-09-24 03:00:00 | NQ | Futures | 1897.84 | 1899.25 | 1891.33 | 1893.02 | 1106.0 |
| 2008-09-24 04:00:00 | NQ | Futures | 1893.59 | 1897.55 | 1891.89 | 1897.27 | 323.0 |
| 2008-09-24 05:00:00 | NQ | Futures | 1896.42 | 1898.68 | 1889.06 | 1889.35 | 555.0 |
| 2008-09-24 06:00:00 | NQ | Futures | 1889.06 | 1890.76 | 1882.27 | 1885.95 | 904.0 |
| 2008-09-24 07:00:00 | NQ | Futures | 1886.23 | 1889.06 | 1873.5 | 1884.54 | 2860.0 |
| 2008-09-24 08:00:00 | NQ | Futures | 1884.54 | 1894.44 | 1880.57 | 1890.2 | 6101.0 |
| 2008-09-24 09:00:00 | NQ | Futures | 1890.2 | 1890.48 | 1869.54 | 1881.14 | 43391.0 |
| 2008-09-24 10:00:00 | NQ | Futures | 1880.57 | 1895.57 | 1868.12 | 1894.44 | 62065.0 |
| 2008-09-24 11:00:00 | NQ | Futures | 1893.87 | 1895.01 | 1875.2 | 1885.67 | 45608.0 |
| 2008-09-24 12:00:00 | NQ | Futures | 1885.67 | 1890.48 | 1877.46 | 1882.56 | 26637.0 |
| 2008-09-24 13:00:00 | NQ | Futures | 1882.84 | 1903.78 | 1880.29 | 1892.74 | 46636.0 |
| 2008-09-24 14:00:00 | NQ | Futures | 1893.02 | 1903.78 | 1886.23 | 1889.63 | 38418.0 |
| 2008-09-24 15:00:00 | NQ | Futures | 1889.35 | 1896.99 | 1868.69 | 1889.63 | 57044.0 |
| 2008-09-24 16:00:00 | NQ | Futures | 1889.91 | 1895.57 | 1888.5 | 1895.29 | 12614.0 |
| 2008-09-24 17:00:00 | NQ | Futures | 1893.87 | 1893.87 | 1887.93 | 1889.06 | 431.0 |
| 2008-09-24 18:00:00 | NQ | Futures | 1888.5 | 1891.33 | 1888.21 | 1889.63 | 562.0 |
| 2008-09-24 19:00:00 | NQ | Futures | 1890.2 | 1892.74 | 1885.95 | 1885.95 | 371.0 |
| 2008-09-24 20:00:00 | NQ | Futures | 1886.52 | 1892.74 | 1885.1 | 1890.48 | 265.0 |
| 2008-09-24 21:00:00 | NQ | Futures | 1890.48 | 1900.38 | 1884.25 | 1896.7 | 1076.0 |
| 2008-09-24 22:00:00 | NQ | Futures | 1896.7 | 1900.95 | 1895.29 | 1895.29 | 188.0 |
| 2008-09-24 23:00:00 | NQ | Futures | 1896.14 | 1896.7 | 1890.2 | 1890.2 | 128.0 |
| 2008-09-24 00:00:00 | YM | Futures | 9986.5 | 9987.4 | 9970.1 | 9975.6 | 150.0 |
| 2008-09-24 01:00:00 | YM | Futures | 9978.3 | 9986.5 | 9974.7 | 9981.1 | 169.0 |
> showing 50 of 1,234 rows — these rows as CSV