PREVIEW / futures_1hour / 2008-06-11
file: by_date/futures_1hour/2008/2008-06-11.parquet size: 41 KB rows: 1,169
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-06-11 00:00:00 | ES | Futures | 1264.81 | 1266.44 | 1264.57 | 1266.2 | 2207.0 |
| 2008-06-11 01:00:00 | ES | Futures | 1265.97 | 1266.44 | 1265.27 | 1266.2 | 1123.0 |
| 2008-06-11 02:00:00 | ES | Futures | 1266.2 | 1268.3 | 1265.51 | 1268.07 | 6250.0 |
| 2008-06-11 03:00:00 | ES | Futures | 1268.3 | 1269.93 | 1266.9 | 1267.14 | 11344.0 |
| 2008-06-11 04:00:00 | ES | Futures | 1267.37 | 1269.46 | 1265.27 | 1266.2 | 10172.0 |
| 2008-06-11 05:00:00 | ES | Futures | 1266.44 | 1267.14 | 1265.27 | 1265.74 | 6467.0 |
| 2008-06-11 06:00:00 | ES | Futures | 1265.97 | 1268.07 | 1265.51 | 1267.6 | 7994.0 |
| 2008-06-11 07:00:00 | ES | Futures | 1267.37 | 1268.53 | 1266.67 | 1268.07 | 14388.0 |
| 2008-06-11 08:00:00 | ES | Futures | 1268.07 | 1268.3 | 1264.57 | 1265.27 | 21676.0 |
| 2008-06-11 09:00:00 | ES | Futures | 1265.27 | 1265.51 | 1258.29 | 1258.29 | 209661.0 |
| 2008-06-11 10:00:00 | ES | Futures | 1258.29 | 1258.52 | 1248.04 | 1255.26 | 629655.0 |
| 2008-06-11 11:00:00 | ES | Futures | 1255.26 | 1255.73 | 1248.28 | 1253.16 | 319934.0 |
| 2008-06-11 12:00:00 | ES | Futures | 1253.16 | 1254.33 | 1247.11 | 1250.37 | 216432.0 |
| 2008-06-11 13:00:00 | ES | Futures | 1250.37 | 1252.93 | 1248.28 | 1251.07 | 182780.0 |
| 2008-06-11 14:00:00 | ES | Futures | 1251.07 | 1255.03 | 1248.51 | 1249.21 | 228412.0 |
| 2008-06-11 15:00:00 | ES | Futures | 1249.21 | 1252.7 | 1243.39 | 1243.62 | 346250.0 |
| 2008-06-11 16:00:00 | ES | Futures | 1243.85 | 1246.18 | 1243.39 | 1244.78 | 102048.0 |
| 2008-06-11 17:00:00 | ES | Futures | 1245.02 | 1245.48 | 1243.15 | 1243.39 | 3122.0 |
| 2008-06-11 18:00:00 | ES | Futures | 1243.39 | 1245.25 | 1242.45 | 1244.78 | 3273.0 |
| 2008-06-11 19:00:00 | ES | Futures | 1245.02 | 1246.18 | 1245.02 | 1246.18 | 1352.0 |
| 2008-06-11 20:00:00 | ES | Futures | 1245.95 | 1245.95 | 1243.62 | 1243.62 | 2277.0 |
| 2008-06-11 21:00:00 | ES | Futures | 1243.85 | 1245.71 | 1243.62 | 1245.48 | 1763.0 |
| 2008-06-11 22:00:00 | ES | Futures | 1245.48 | 1246.65 | 1245.25 | 1245.48 | 5372.0 |
| 2008-06-11 23:00:00 | ES | Futures | 1245.48 | 1246.18 | 1244.55 | 1246.18 | 1538.0 |
| 2008-06-11 00:00:00 | NQ | Futures | 2235.19 | 2238.59 | 2235.19 | 2237.74 | 440.0 |
| 2008-06-11 01:00:00 | NQ | Futures | 2237.74 | 2237.74 | 2237.17 | 2237.46 | 90.0 |
| 2008-06-11 02:00:00 | NQ | Futures | 2237.74 | 2241.7 | 2236.04 | 2241.42 | 455.0 |
| 2008-06-11 03:00:00 | NQ | Futures | 2241.13 | 2244.25 | 2238.59 | 2239.72 | 1355.0 |
| 2008-06-11 04:00:00 | NQ | Futures | 2239.44 | 2241.98 | 2236.04 | 2237.17 | 1125.0 |
| 2008-06-11 05:00:00 | NQ | Futures | 2238.31 | 2238.87 | 2234.63 | 2236.04 | 525.0 |
| 2008-06-11 06:00:00 | NQ | Futures | 2236.04 | 2239.72 | 2235.48 | 2239.15 | 516.0 |
| 2008-06-11 07:00:00 | NQ | Futures | 2238.87 | 2242.27 | 2238.02 | 2241.42 | 1425.0 |
| 2008-06-11 08:00:00 | NQ | Futures | 2241.42 | 2241.98 | 2232.93 | 2235.48 | 3664.0 |
| 2008-06-11 09:00:00 | NQ | Futures | 2235.48 | 2235.76 | 2215.96 | 2215.96 | 40374.0 |
| 2008-06-11 10:00:00 | NQ | Futures | 2215.68 | 2216.53 | 2193.34 | 2211.72 | 109546.0 |
| 2008-06-11 11:00:00 | NQ | Futures | 2211.72 | 2213.13 | 2195.03 | 2204.37 | 59398.0 |
| 2008-06-11 12:00:00 | NQ | Futures | 2204.37 | 2205.5 | 2188.25 | 2191.07 | 45497.0 |
| 2008-06-11 13:00:00 | NQ | Futures | 2190.79 | 2196.73 | 2188.53 | 2192.49 | 44035.0 |
| 2008-06-11 14:00:00 | NQ | Futures | 2191.92 | 2202.39 | 2188.25 | 2191.07 | 49267.0 |
| 2008-06-11 15:00:00 | NQ | Futures | 2191.07 | 2196.73 | 2176.93 | 2177.78 | 82132.0 |
| 2008-06-11 16:00:00 | NQ | Futures | 2177.78 | 2182.02 | 2175.8 | 2178.35 | 17955.0 |
| 2008-06-11 17:00:00 | NQ | Futures | 2177.78 | 2179.48 | 2175.52 | 2175.52 | 404.0 |
| 2008-06-11 18:00:00 | NQ | Futures | 2175.23 | 2179.19 | 2174.39 | 2179.19 | 175.0 |
| 2008-06-11 19:00:00 | NQ | Futures | 2179.19 | 2179.76 | 2178.35 | 2179.48 | 187.0 |
| 2008-06-11 20:00:00 | NQ | Futures | 2178.91 | 2179.48 | 2178.06 | 2178.35 | 146.0 |
| 2008-06-11 21:00:00 | NQ | Futures | 2178.63 | 2179.76 | 2178.63 | 2179.76 | 161.0 |
| 2008-06-11 22:00:00 | NQ | Futures | 2180.04 | 2181.74 | 2179.48 | 2179.48 | 223.0 |
| 2008-06-11 23:00:00 | NQ | Futures | 2179.48 | 2180.61 | 2178.06 | 2180.33 | 102.0 |
| 2008-06-11 00:00:00 | YM | Futures | 11171.0 | 11179.2 | 11171.0 | 11179.2 | 5.0 |
| 2008-06-11 01:00:00 | YM | Futures | 11179.2 | 11179.2 | 11179.2 | 11179.2 | 3.0 |
> showing 50 of 1,169 rows — these rows as CSV