PREVIEW / futures_1hour / 2008-02-12
file: by_date/futures_1hour/2008/2008-02-12.parquet size: 31 KB rows: 858
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-02-12 00:00:00 | ES | Futures | 1248.09 | 1249.02 | 1247.85 | 1248.78 | 1519.0 |
| 2008-02-12 01:00:00 | ES | Futures | 1248.78 | 1248.78 | 1246.92 | 1248.32 | 1712.0 |
| 2008-02-12 02:00:00 | ES | Futures | 1248.32 | 1249.72 | 1248.09 | 1249.48 | 5186.0 |
| 2008-02-12 03:00:00 | ES | Futures | 1249.25 | 1250.42 | 1244.12 | 1244.82 | 21699.0 |
| 2008-02-12 04:00:00 | ES | Futures | 1244.82 | 1246.45 | 1242.96 | 1244.35 | 12633.0 |
| 2008-02-12 05:00:00 | ES | Futures | 1244.35 | 1248.09 | 1243.66 | 1248.09 | 11618.0 |
| 2008-02-12 06:00:00 | ES | Futures | 1248.09 | 1254.15 | 1247.85 | 1252.75 | 27829.0 |
| 2008-02-12 07:00:00 | ES | Futures | 1252.51 | 1255.08 | 1249.95 | 1250.18 | 32148.0 |
| 2008-02-12 08:00:00 | ES | Futures | 1250.18 | 1260.68 | 1248.55 | 1257.88 | 149221.0 |
| 2008-02-12 09:00:00 | ES | Futures | 1257.64 | 1261.14 | 1254.85 | 1260.44 | 213570.0 |
| 2008-02-12 10:00:00 | ES | Futures | 1260.21 | 1270.93 | 1260.21 | 1270.23 | 407898.0 |
| 2008-02-12 11:00:00 | ES | Futures | 1270.23 | 1271.63 | 1266.04 | 1266.5 | 240812.0 |
| 2008-02-12 12:00:00 | ES | Futures | 1266.5 | 1268.14 | 1259.51 | 1263.71 | 220503.0 |
| 2008-02-12 13:00:00 | ES | Futures | 1263.71 | 1268.14 | 1263.47 | 1267.67 | 132532.0 |
| 2008-02-12 14:00:00 | ES | Futures | 1267.67 | 1267.9 | 1259.98 | 1266.5 | 199509.0 |
| 2008-02-12 15:00:00 | ES | Futures | 1266.5 | 1266.5 | 1249.48 | 1258.58 | 466935.0 |
| 2008-02-12 16:00:00 | ES | Futures | 1258.58 | 1260.91 | 1257.88 | 1259.74 | 86807.0 |
| 2008-02-12 17:00:00 | ES | Futures | 1259.74 | 1259.98 | 1258.81 | 1258.81 | 1975.0 |
| 2008-02-12 18:00:00 | ES | Futures | 1258.81 | 1259.04 | 1257.41 | 1257.64 | 3791.0 |
| 2008-02-12 19:00:00 | ES | Futures | 1257.88 | 1257.88 | 1255.08 | 1255.78 | 5125.0 |
| 2008-02-12 20:00:00 | ES | Futures | 1255.78 | 1257.18 | 1254.85 | 1256.71 | 3421.0 |
| 2008-02-12 21:00:00 | ES | Futures | 1256.71 | 1256.71 | 1255.31 | 1255.78 | 1012.0 |
| 2008-02-12 22:00:00 | ES | Futures | 1255.55 | 1258.11 | 1252.98 | 1254.61 | 4961.0 |
| 2008-02-12 23:00:00 | ES | Futures | 1254.38 | 1256.94 | 1253.91 | 1254.85 | 2453.0 |
| 2008-02-12 00:00:00 | NQ | Futures | 2039.42 | 2040.84 | 2039.13 | 2039.42 | 134.0 |
| 2008-02-12 01:00:00 | NQ | Futures | 2039.7 | 2040.27 | 2037.15 | 2039.98 | 80.0 |
| 2008-02-12 02:00:00 | NQ | Futures | 2038.85 | 2041.4 | 2038.85 | 2040.27 | 229.0 |
| 2008-02-12 03:00:00 | NQ | Futures | 2041.4 | 2041.4 | 2032.89 | 2033.17 | 985.0 |
| 2008-02-12 04:00:00 | NQ | Futures | 2032.89 | 2036.01 | 2031.47 | 2033.46 | 679.0 |
| 2008-02-12 05:00:00 | NQ | Futures | 2033.17 | 2039.13 | 2033.17 | 2039.13 | 670.0 |
| 2008-02-12 06:00:00 | NQ | Futures | 2038.85 | 2047.08 | 2038.57 | 2046.51 | 1431.0 |
| 2008-02-12 07:00:00 | NQ | Futures | 2046.51 | 2050.2 | 2045.09 | 2045.66 | 1856.0 |
| 2008-02-12 08:00:00 | NQ | Futures | 2045.38 | 2061.56 | 2042.54 | 2055.6 | 13593.0 |
| 2008-02-12 09:00:00 | NQ | Futures | 2055.88 | 2056.16 | 2047.65 | 2050.2 | 51099.0 |
| 2008-02-12 10:00:00 | NQ | Futures | 2050.2 | 2062.69 | 2049.35 | 2062.12 | 71855.0 |
| 2008-02-12 11:00:00 | NQ | Futures | 2062.41 | 2062.41 | 2055.03 | 2055.31 | 39663.0 |
| 2008-02-12 12:00:00 | NQ | Futures | 2055.31 | 2057.87 | 2041.4 | 2048.22 | 47831.0 |
| 2008-02-12 13:00:00 | NQ | Futures | 2048.22 | 2052.47 | 2045.09 | 2050.77 | 28143.0 |
| 2008-02-12 14:00:00 | NQ | Futures | 2050.77 | 2050.77 | 2038.28 | 2046.51 | 36676.0 |
| 2008-02-12 15:00:00 | NQ | Futures | 2046.23 | 2046.8 | 2012.74 | 2026.64 | 100715.0 |
| 2008-02-12 16:00:00 | NQ | Futures | 2027.21 | 2035.44 | 2025.22 | 2033.74 | 14227.0 |
| 2008-02-12 17:00:00 | NQ | Futures | 2033.46 | 2034.59 | 2032.89 | 2034.31 | 536.0 |
| 2008-02-12 18:00:00 | NQ | Futures | 2034.02 | 2034.02 | 2031.47 | 2032.89 | 405.0 |
| 2008-02-12 19:00:00 | NQ | Futures | 2032.6 | 2032.89 | 2029.77 | 2029.77 | 409.0 |
| 2008-02-12 20:00:00 | NQ | Futures | 2029.48 | 2031.47 | 2028.63 | 2030.05 | 365.0 |
| 2008-02-12 21:00:00 | NQ | Futures | 2029.48 | 2030.62 | 2029.2 | 2030.05 | 108.0 |
| 2008-02-12 22:00:00 | NQ | Futures | 2030.05 | 2033.74 | 2027.78 | 2029.2 | 397.0 |
| 2008-02-12 23:00:00 | NQ | Futures | 2030.33 | 2032.89 | 2028.91 | 2030.05 | 204.0 |
| 2008-02-12 00:00:00 | YM | Futures | 11115.5 | 11121.8 | 11111.8 | 11114.6 | 46.0 |
| 2008-02-12 01:00:00 | YM | Futures | 11115.5 | 11115.5 | 11103.7 | 11113.7 | 51.0 |
> showing 50 of 858 rows — these rows as CSV