PREVIEW / futures_1hour / 2008-06-16
file: by_date/futures_1hour/2008/2008-06-16.parquet size: 41 KB rows: 1,198
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-16 00:00:00 | ES | Futures | 1264.11 | 1265.5 | 1263.64 | 1265.5 | 1165.0 |
| 2008-06-16 01:00:00 | ES | Futures | 1265.27 | 1266.2 | 1264.57 | 1265.73 | 1615.0 |
| 2008-06-16 02:00:00 | ES | Futures | 1265.73 | 1266.2 | 1265.04 | 1265.97 | 2050.0 |
| 2008-06-16 03:00:00 | ES | Futures | 1265.97 | 1268.06 | 1264.34 | 1264.8 | 10123.0 |
| 2008-06-16 04:00:00 | ES | Futures | 1264.8 | 1266.43 | 1264.34 | 1266.43 | 6181.0 |
| 2008-06-16 05:00:00 | ES | Futures | 1265.97 | 1267.83 | 1265.04 | 1267.83 | 7471.0 |
| 2008-06-16 06:00:00 | ES | Futures | 1267.83 | 1268.29 | 1266.66 | 1266.66 | 7946.0 |
| 2008-06-16 07:00:00 | ES | Futures | 1266.66 | 1266.66 | 1262.25 | 1262.48 | 18996.0 |
| 2008-06-16 08:00:00 | ES | Futures | 1262.71 | 1266.66 | 1258.53 | 1259.92 | 64184.0 |
| 2008-06-16 09:00:00 | ES | Futures | 1259.92 | 1262.02 | 1256.44 | 1260.62 | 200560.0 |
| 2008-06-16 10:00:00 | ES | Futures | 1260.85 | 1267.59 | 1258.99 | 1267.13 | 219828.0 |
| 2008-06-16 11:00:00 | ES | Futures | 1267.36 | 1267.59 | 1262.71 | 1264.57 | 134885.0 |
| 2008-06-16 12:00:00 | ES | Futures | 1264.57 | 1266.9 | 1261.78 | 1265.04 | 99776.0 |
| 2008-06-16 13:00:00 | ES | Futures | 1265.27 | 1271.31 | 1262.02 | 1269.22 | 218739.0 |
| 2008-06-16 14:00:00 | ES | Futures | 1269.45 | 1270.61 | 1266.66 | 1269.92 | 120932.0 |
| 2008-06-16 15:00:00 | ES | Futures | 1269.92 | 1270.61 | 1265.27 | 1266.43 | 198629.0 |
| 2008-06-16 16:00:00 | ES | Futures | 1266.43 | 1266.9 | 1262.71 | 1263.64 | 67003.0 |
| 2008-06-16 17:00:00 | ES | Futures | 1263.64 | 1263.87 | 1263.18 | 1263.87 | 2217.0 |
| 2008-06-16 18:00:00 | ES | Futures | 1263.64 | 1264.57 | 1262.95 | 1264.34 | 1097.0 |
| 2008-06-16 19:00:00 | ES | Futures | 1264.34 | 1264.8 | 1263.41 | 1264.57 | 562.0 |
| 2008-06-16 20:00:00 | ES | Futures | 1264.8 | 1265.04 | 1264.57 | 1265.04 | 979.0 |
| 2008-06-16 21:00:00 | ES | Futures | 1265.04 | 1265.5 | 1263.64 | 1265.04 | 1267.0 |
| 2008-06-16 22:00:00 | ES | Futures | 1265.04 | 1265.04 | 1264.11 | 1264.57 | 835.0 |
| 2008-06-16 23:00:00 | ES | Futures | 1264.34 | 1264.8 | 1262.95 | 1263.87 | 1512.0 |
| 2008-06-16 00:00:00 | NQ | Futures | 2215.43 | 2217.68 | 2214.31 | 2217.4 | 265.0 |
| 2008-06-16 01:00:00 | NQ | Futures | 2217.4 | 2219.93 | 2217.12 | 2218.81 | 316.0 |
| 2008-06-16 02:00:00 | NQ | Futures | 2218.81 | 2220.21 | 2218.24 | 2220.21 | 180.0 |
| 2008-06-16 03:00:00 | NQ | Futures | 2219.65 | 2222.18 | 2216.56 | 2216.84 | 758.0 |
| 2008-06-16 04:00:00 | NQ | Futures | 2216.84 | 2219.93 | 2216.56 | 2219.65 | 287.0 |
| 2008-06-16 05:00:00 | NQ | Futures | 2219.37 | 2223.59 | 2217.68 | 2223.59 | 1437.0 |
| 2008-06-16 06:00:00 | NQ | Futures | 2223.59 | 2224.43 | 2222.46 | 2222.74 | 587.0 |
| 2008-06-16 07:00:00 | NQ | Futures | 2222.46 | 2222.74 | 2214.87 | 2215.71 | 1529.0 |
| 2008-06-16 08:00:00 | NQ | Futures | 2215.99 | 2221.06 | 2210.65 | 2211.77 | 7839.0 |
| 2008-06-16 09:00:00 | NQ | Futures | 2212.06 | 2221.06 | 2208.12 | 2215.99 | 45302.0 |
| 2008-06-16 10:00:00 | NQ | Futures | 2215.99 | 2239.34 | 2213.18 | 2236.25 | 61462.0 |
| 2008-06-16 11:00:00 | NQ | Futures | 2236.53 | 2242.15 | 2230.34 | 2234.0 | 40500.0 |
| 2008-06-16 12:00:00 | NQ | Futures | 2234.28 | 2236.53 | 2226.68 | 2232.87 | 21300.0 |
| 2008-06-16 13:00:00 | NQ | Futures | 2233.15 | 2253.12 | 2228.37 | 2249.19 | 54280.0 |
| 2008-06-16 14:00:00 | NQ | Futures | 2248.9 | 2250.31 | 2240.47 | 2248.62 | 29441.0 |
| 2008-06-16 15:00:00 | NQ | Futures | 2248.62 | 2249.19 | 2239.62 | 2243.0 | 49638.0 |
| 2008-06-16 16:00:00 | NQ | Futures | 2243.28 | 2244.97 | 2234.28 | 2236.25 | 12383.0 |
| 2008-06-16 17:00:00 | NQ | Futures | 2236.25 | 2237.93 | 2235.96 | 2237.93 | 92.0 |
| 2008-06-16 18:00:00 | NQ | Futures | 2236.81 | 2239.06 | 2236.53 | 2238.78 | 92.0 |
| 2008-06-16 19:00:00 | NQ | Futures | 2238.21 | 2239.34 | 2236.81 | 2239.06 | 59.0 |
| 2008-06-16 20:00:00 | NQ | Futures | 2239.06 | 2239.34 | 2238.78 | 2239.06 | 43.0 |
| 2008-06-16 21:00:00 | NQ | Futures | 2238.78 | 2239.9 | 2237.93 | 2239.62 | 51.0 |
| 2008-06-16 22:00:00 | NQ | Futures | 2239.06 | 2239.06 | 2238.21 | 2238.21 | 8.0 |
| 2008-06-16 23:00:00 | NQ | Futures | 2238.21 | 2238.5 | 2235.68 | 2235.68 | 55.0 |
| 2008-06-16 00:00:00 | YM | Futures | 11180.1 | 11191.9 | 11179.2 | 11188.2 | 52.0 |
| 2008-06-16 01:00:00 | YM | Futures | 11192.8 | 11196.4 | 11188.2 | 11194.6 | 79.0 |
> showing 50 of 1,198 rows — these rows as CSV