PREVIEW / futures_1hour / 2008-02-13
file: by_date/futures_1hour/2008/2008-02-13.parquet size: 31 KB rows: 849
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-13 00:00:00 | ES | Futures | 1254.85 | 1256.25 | 1253.91 | 1254.38 | 1591.0 |
| 2008-02-13 01:00:00 | ES | Futures | 1254.38 | 1255.31 | 1253.45 | 1254.85 | 1959.0 |
| 2008-02-13 02:00:00 | ES | Futures | 1254.85 | 1256.48 | 1253.45 | 1256.01 | 5205.0 |
| 2008-02-13 03:00:00 | ES | Futures | 1256.25 | 1258.34 | 1254.15 | 1255.78 | 11840.0 |
| 2008-02-13 04:00:00 | ES | Futures | 1255.78 | 1263.01 | 1254.61 | 1262.07 | 21374.0 |
| 2008-02-13 05:00:00 | ES | Futures | 1262.31 | 1263.24 | 1260.44 | 1262.77 | 12144.0 |
| 2008-02-13 06:00:00 | ES | Futures | 1263.01 | 1263.01 | 1259.51 | 1259.51 | 11657.0 |
| 2008-02-13 07:00:00 | ES | Futures | 1259.51 | 1264.17 | 1259.28 | 1263.47 | 19317.0 |
| 2008-02-13 08:00:00 | ES | Futures | 1263.47 | 1271.17 | 1260.91 | 1267.2 | 104648.0 |
| 2008-02-13 09:00:00 | ES | Futures | 1267.2 | 1272.8 | 1264.87 | 1265.8 | 227258.0 |
| 2008-02-13 10:00:00 | ES | Futures | 1265.8 | 1270.23 | 1260.21 | 1263.71 | 334314.0 |
| 2008-02-13 11:00:00 | ES | Futures | 1263.47 | 1268.6 | 1262.77 | 1265.8 | 180156.0 |
| 2008-02-13 12:00:00 | ES | Futures | 1265.8 | 1270.23 | 1265.34 | 1268.14 | 106242.0 |
| 2008-02-13 13:00:00 | ES | Futures | 1268.37 | 1274.66 | 1266.97 | 1272.33 | 214935.0 |
| 2008-02-13 14:00:00 | ES | Futures | 1272.33 | 1273.97 | 1268.6 | 1273.03 | 154865.0 |
| 2008-02-13 15:00:00 | ES | Futures | 1272.8 | 1278.16 | 1271.4 | 1274.43 | 297542.0 |
| 2008-02-13 16:00:00 | ES | Futures | 1274.2 | 1275.83 | 1271.4 | 1273.03 | 99464.0 |
| 2008-02-13 17:00:00 | ES | Futures | 1273.03 | 1273.5 | 1272.33 | 1272.8 | 1902.0 |
| 2008-02-13 18:00:00 | ES | Futures | 1273.03 | 1273.97 | 1272.1 | 1273.5 | 2627.0 |
| 2008-02-13 19:00:00 | ES | Futures | 1273.73 | 1274.66 | 1273.27 | 1273.73 | 2386.0 |
| 2008-02-13 20:00:00 | ES | Futures | 1273.73 | 1273.97 | 1272.33 | 1273.73 | 1907.0 |
| 2008-02-13 21:00:00 | ES | Futures | 1273.73 | 1273.97 | 1272.1 | 1272.57 | 1473.0 |
| 2008-02-13 22:00:00 | ES | Futures | 1272.33 | 1273.5 | 1272.1 | 1273.27 | 1353.0 |
| 2008-02-13 23:00:00 | ES | Futures | 1273.27 | 1274.43 | 1273.27 | 1273.97 | 2086.0 |
| 2008-02-13 00:00:00 | NQ | Futures | 2028.91 | 2032.89 | 2028.91 | 2029.2 | 193.0 |
| 2008-02-13 01:00:00 | NQ | Futures | 2030.33 | 2030.33 | 2027.5 | 2028.91 | 399.0 |
| 2008-02-13 02:00:00 | NQ | Futures | 2028.06 | 2030.33 | 2025.51 | 2028.91 | 406.0 |
| 2008-02-13 03:00:00 | NQ | Futures | 2028.91 | 2031.19 | 2026.08 | 2027.78 | 711.0 |
| 2008-02-13 04:00:00 | NQ | Futures | 2028.35 | 2039.7 | 2027.5 | 2038.28 | 781.0 |
| 2008-02-13 05:00:00 | NQ | Futures | 2038.28 | 2043.11 | 2036.29 | 2042.82 | 773.0 |
| 2008-02-13 06:00:00 | NQ | Futures | 2041.97 | 2042.82 | 2034.31 | 2034.59 | 701.0 |
| 2008-02-13 07:00:00 | NQ | Futures | 2034.31 | 2042.26 | 2033.74 | 2041.4 | 1298.0 |
| 2008-02-13 08:00:00 | NQ | Futures | 2041.12 | 2054.74 | 2037.43 | 2050.49 | 11360.0 |
| 2008-02-13 09:00:00 | NQ | Futures | 2049.92 | 2059.85 | 2044.81 | 2050.49 | 60404.0 |
| 2008-02-13 10:00:00 | NQ | Futures | 2050.49 | 2057.58 | 2042.26 | 2048.22 | 60754.0 |
| 2008-02-13 11:00:00 | NQ | Futures | 2047.93 | 2055.6 | 2046.23 | 2051.62 | 39975.0 |
| 2008-02-13 12:00:00 | NQ | Futures | 2051.91 | 2057.87 | 2050.77 | 2054.74 | 26531.0 |
| 2008-02-13 13:00:00 | NQ | Futures | 2054.74 | 2076.6 | 2051.05 | 2069.22 | 70248.0 |
| 2008-02-13 14:00:00 | NQ | Futures | 2069.5 | 2072.63 | 2063.83 | 2070.92 | 38096.0 |
| 2008-02-13 15:00:00 | NQ | Futures | 2070.92 | 2075.18 | 2067.8 | 2071.77 | 59356.0 |
| 2008-02-13 16:00:00 | NQ | Futures | 2071.49 | 2073.76 | 2064.96 | 2072.34 | 17758.0 |
| 2008-02-13 17:00:00 | NQ | Futures | 2072.34 | 2073.76 | 2070.92 | 2071.77 | 383.0 |
| 2008-02-13 18:00:00 | NQ | Futures | 2072.63 | 2074.61 | 2072.34 | 2074.61 | 251.0 |
| 2008-02-13 19:00:00 | NQ | Futures | 2074.05 | 2074.9 | 2073.19 | 2074.33 | 186.0 |
| 2008-02-13 20:00:00 | NQ | Futures | 2073.76 | 2073.76 | 2070.92 | 2073.19 | 62.0 |
| 2008-02-13 21:00:00 | NQ | Futures | 2072.34 | 2072.91 | 2072.06 | 2072.06 | 46.0 |
| 2008-02-13 22:00:00 | NQ | Futures | 2072.34 | 2073.76 | 2070.92 | 2073.76 | 67.0 |
| 2008-02-13 23:00:00 | NQ | Futures | 2074.05 | 2075.46 | 2074.05 | 2075.46 | 135.0 |
| 2008-02-13 00:00:00 | YM | Futures | 11221.8 | 11228.1 | 11211.8 | 11215.4 | 72.0 |
| 2008-02-13 01:00:00 | YM | Futures | 11214.5 | 11219.0 | 11208.1 | 11215.4 | 123.0 |
> showing 50 of 849 rows — these rows as CSV