PREVIEW / futures_1hour / 2008-02-14
file: by_date/futures_1hour/2008/2008-02-14.parquet size: 31 KB rows: 856
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-14 00:00:00 | ES | Futures | 1273.97 | 1275.83 | 1273.5 | 1275.36 | 3620.0 |
| 2008-02-14 01:00:00 | ES | Futures | 1275.6 | 1277.7 | 1274.2 | 1277.0 | 4603.0 |
| 2008-02-14 02:00:00 | ES | Futures | 1277.0 | 1279.09 | 1276.3 | 1277.7 | 7559.0 |
| 2008-02-14 03:00:00 | ES | Futures | 1277.7 | 1277.93 | 1275.83 | 1277.0 | 13442.0 |
| 2008-02-14 04:00:00 | ES | Futures | 1277.0 | 1277.93 | 1272.8 | 1273.27 | 15682.0 |
| 2008-02-14 05:00:00 | ES | Futures | 1273.03 | 1275.36 | 1271.87 | 1274.43 | 16125.0 |
| 2008-02-14 06:00:00 | ES | Futures | 1274.66 | 1275.83 | 1273.27 | 1274.9 | 10815.0 |
| 2008-02-14 07:00:00 | ES | Futures | 1274.9 | 1276.53 | 1273.27 | 1273.73 | 14783.0 |
| 2008-02-14 08:00:00 | ES | Futures | 1273.5 | 1277.7 | 1272.1 | 1275.36 | 48333.0 |
| 2008-02-14 09:00:00 | ES | Futures | 1275.6 | 1277.7 | 1270.0 | 1272.33 | 204575.0 |
| 2008-02-14 10:00:00 | ES | Futures | 1272.57 | 1276.3 | 1269.54 | 1270.0 | 262948.0 |
| 2008-02-14 11:00:00 | ES | Futures | 1270.0 | 1270.93 | 1263.01 | 1265.8 | 287756.0 |
| 2008-02-14 12:00:00 | ES | Futures | 1266.04 | 1269.07 | 1262.77 | 1263.24 | 160649.0 |
| 2008-02-14 13:00:00 | ES | Futures | 1263.47 | 1264.87 | 1260.68 | 1263.94 | 167219.0 |
| 2008-02-14 14:00:00 | ES | Futures | 1263.94 | 1266.27 | 1256.48 | 1261.61 | 238858.0 |
| 2008-02-14 15:00:00 | ES | Futures | 1261.84 | 1266.97 | 1257.41 | 1258.58 | 340240.0 |
| 2008-02-14 16:00:00 | ES | Futures | 1258.34 | 1261.61 | 1258.11 | 1259.04 | 83491.0 |
| 2008-02-14 17:00:00 | ES | Futures | 1259.04 | 1260.68 | 1258.81 | 1259.04 | 3277.0 |
| 2008-02-14 18:00:00 | ES | Futures | 1259.51 | 1259.98 | 1257.18 | 1257.88 | 4302.0 |
| 2008-02-14 19:00:00 | ES | Futures | 1257.88 | 1259.28 | 1257.18 | 1257.64 | 2764.0 |
| 2008-02-14 20:00:00 | ES | Futures | 1257.64 | 1258.34 | 1257.18 | 1257.18 | 1710.0 |
| 2008-02-14 21:00:00 | ES | Futures | 1257.41 | 1257.88 | 1256.01 | 1257.64 | 1946.0 |
| 2008-02-14 22:00:00 | ES | Futures | 1257.64 | 1258.11 | 1256.01 | 1256.25 | 1168.0 |
| 2008-02-14 23:00:00 | ES | Futures | 1256.48 | 1258.11 | 1256.01 | 1257.41 | 1142.0 |
| 2008-02-14 00:00:00 | NQ | Futures | 2074.33 | 2076.03 | 2072.06 | 2075.46 | 201.0 |
| 2008-02-14 01:00:00 | NQ | Futures | 2075.46 | 2077.17 | 2074.9 | 2077.17 | 310.0 |
| 2008-02-14 02:00:00 | NQ | Futures | 2077.45 | 2078.3 | 2075.46 | 2077.17 | 699.0 |
| 2008-02-14 03:00:00 | NQ | Futures | 2077.74 | 2077.74 | 2074.9 | 2076.6 | 403.0 |
| 2008-02-14 04:00:00 | NQ | Futures | 2076.03 | 2077.74 | 2071.49 | 2072.34 | 908.0 |
| 2008-02-14 05:00:00 | NQ | Futures | 2072.63 | 2076.03 | 2070.36 | 2074.9 | 555.0 |
| 2008-02-14 06:00:00 | NQ | Futures | 2074.33 | 2077.17 | 2073.48 | 2076.6 | 988.0 |
| 2008-02-14 07:00:00 | NQ | Futures | 2076.6 | 2077.74 | 2071.21 | 2074.05 | 1879.0 |
| 2008-02-14 08:00:00 | NQ | Futures | 2074.05 | 2079.15 | 2072.63 | 2075.75 | 6678.0 |
| 2008-02-14 09:00:00 | NQ | Futures | 2076.03 | 2078.3 | 2054.46 | 2063.83 | 72196.0 |
| 2008-02-14 10:00:00 | NQ | Futures | 2063.83 | 2068.94 | 2055.88 | 2056.45 | 53056.0 |
| 2008-02-14 11:00:00 | NQ | Futures | 2056.16 | 2059.0 | 2043.67 | 2048.5 | 71856.0 |
| 2008-02-14 12:00:00 | NQ | Futures | 2048.78 | 2053.61 | 2042.54 | 2043.11 | 38632.0 |
| 2008-02-14 13:00:00 | NQ | Futures | 2043.11 | 2046.23 | 2037.71 | 2044.81 | 40700.0 |
| 2008-02-14 14:00:00 | NQ | Futures | 2044.81 | 2047.08 | 2030.05 | 2035.16 | 51351.0 |
| 2008-02-14 15:00:00 | NQ | Futures | 2034.88 | 2045.09 | 2030.62 | 2034.02 | 67272.0 |
| 2008-02-14 16:00:00 | NQ | Futures | 2033.74 | 2040.55 | 2031.75 | 2032.32 | 13303.0 |
| 2008-02-14 17:00:00 | NQ | Futures | 2033.46 | 2034.31 | 2031.75 | 2031.75 | 216.0 |
| 2008-02-14 18:00:00 | NQ | Futures | 2032.32 | 2033.74 | 2028.06 | 2030.62 | 318.0 |
| 2008-02-14 19:00:00 | NQ | Futures | 2030.62 | 2032.89 | 2027.5 | 2028.35 | 397.0 |
| 2008-02-14 20:00:00 | NQ | Futures | 2028.35 | 2030.33 | 2028.35 | 2028.91 | 119.0 |
| 2008-02-14 21:00:00 | NQ | Futures | 2028.91 | 2029.48 | 2027.21 | 2028.91 | 133.0 |
| 2008-02-14 22:00:00 | NQ | Futures | 2029.48 | 2029.48 | 2027.5 | 2027.5 | 61.0 |
| 2008-02-14 23:00:00 | NQ | Futures | 2028.63 | 2030.9 | 2028.35 | 2030.9 | 165.0 |
| 2008-02-14 00:00:00 | YM | Futures | 11394.4 | 11406.2 | 11390.7 | 11401.7 | 202.0 |
| 2008-02-14 01:00:00 | YM | Futures | 11401.7 | 11420.7 | 11399.8 | 11418.9 | 225.0 |
> showing 50 of 856 rows — these rows as CSV