PREVIEW / futures_1hour / 2008-04-01
file: by_date/futures_1hour/2008/2008-04-01.parquet size: 45 KB rows: 1,253
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-04-01 00:00:00 | ES | Futures | 1233.61 | 1233.84 | 1232.21 | 1232.91 | 1234.0 |
| 2008-04-01 01:00:00 | ES | Futures | 1232.91 | 1234.07 | 1229.18 | 1230.35 | 6596.0 |
| 2008-04-01 02:00:00 | ES | Futures | 1230.11 | 1230.81 | 1225.46 | 1226.39 | 10625.0 |
| 2008-04-01 03:00:00 | ES | Futures | 1226.15 | 1237.56 | 1225.69 | 1237.56 | 27056.0 |
| 2008-04-01 04:00:00 | ES | Futures | 1237.56 | 1239.19 | 1235.93 | 1238.5 | 25768.0 |
| 2008-04-01 05:00:00 | ES | Futures | 1238.26 | 1243.39 | 1237.56 | 1241.52 | 21282.0 |
| 2008-04-01 06:00:00 | ES | Futures | 1241.29 | 1242.69 | 1239.43 | 1241.76 | 17324.0 |
| 2008-04-01 07:00:00 | ES | Futures | 1241.76 | 1243.15 | 1239.89 | 1242.22 | 20425.0 |
| 2008-04-01 08:00:00 | ES | Futures | 1241.99 | 1247.58 | 1241.52 | 1245.95 | 59653.0 |
| 2008-04-01 09:00:00 | ES | Futures | 1245.95 | 1252.7 | 1245.95 | 1251.3 | 244573.0 |
| 2008-04-01 10:00:00 | ES | Futures | 1251.3 | 1261.31 | 1251.3 | 1260.62 | 422046.0 |
| 2008-04-01 11:00:00 | ES | Futures | 1260.85 | 1262.71 | 1258.52 | 1262.25 | 207187.0 |
| 2008-04-01 12:00:00 | ES | Futures | 1262.25 | 1267.14 | 1261.31 | 1264.11 | 249065.0 |
| 2008-04-01 13:00:00 | ES | Futures | 1264.11 | 1269.23 | 1263.41 | 1265.74 | 176856.0 |
| 2008-04-01 14:00:00 | ES | Futures | 1265.74 | 1274.35 | 1263.88 | 1270.16 | 300786.0 |
| 2008-04-01 15:00:00 | ES | Futures | 1270.4 | 1278.31 | 1268.3 | 1278.08 | 410334.0 |
| 2008-04-01 16:00:00 | ES | Futures | 1277.85 | 1278.08 | 1275.05 | 1276.45 | 103538.0 |
| 2008-04-01 17:00:00 | ES | Futures | 1276.45 | 1278.31 | 1275.98 | 1278.08 | 4097.0 |
| 2008-04-01 18:00:00 | ES | Futures | 1277.85 | 1278.08 | 1275.28 | 1276.45 | 3714.0 |
| 2008-04-01 19:00:00 | ES | Futures | 1276.22 | 1276.68 | 1274.59 | 1274.82 | 2084.0 |
| 2008-04-01 20:00:00 | ES | Futures | 1274.82 | 1276.45 | 1273.66 | 1275.98 | 2845.0 |
| 2008-04-01 21:00:00 | ES | Futures | 1276.22 | 1276.68 | 1275.28 | 1275.75 | 1964.0 |
| 2008-04-01 22:00:00 | ES | Futures | 1275.52 | 1276.22 | 1274.35 | 1274.82 | 1512.0 |
| 2008-04-01 23:00:00 | ES | Futures | 1274.82 | 1275.75 | 1274.35 | 1275.28 | 974.0 |
| 2008-04-01 00:00:00 | NQ | Futures | 2021.38 | 2021.94 | 2019.96 | 2020.53 | 111.0 |
| 2008-04-01 01:00:00 | NQ | Futures | 2021.94 | 2023.07 | 2014.31 | 2017.13 | 405.0 |
| 2008-04-01 02:00:00 | NQ | Futures | 2016.0 | 2019.68 | 2010.63 | 2011.19 | 393.0 |
| 2008-04-01 03:00:00 | NQ | Futures | 2011.48 | 2033.54 | 2010.91 | 2032.97 | 2354.0 |
| 2008-04-01 04:00:00 | NQ | Futures | 2033.82 | 2039.48 | 2030.99 | 2037.21 | 2586.0 |
| 2008-04-01 05:00:00 | NQ | Futures | 2037.78 | 2045.42 | 2036.93 | 2042.31 | 1643.0 |
| 2008-04-01 06:00:00 | NQ | Futures | 2042.59 | 2045.13 | 2038.91 | 2044.29 | 1292.0 |
| 2008-04-01 07:00:00 | NQ | Futures | 2044.29 | 2045.42 | 2040.04 | 2043.72 | 1806.0 |
| 2008-04-01 08:00:00 | NQ | Futures | 2043.44 | 2051.64 | 2042.02 | 2050.51 | 8255.0 |
| 2008-04-01 09:00:00 | NQ | Futures | 2050.22 | 2060.97 | 2049.66 | 2057.86 | 53428.0 |
| 2008-04-01 10:00:00 | NQ | Futures | 2057.86 | 2073.7 | 2057.58 | 2071.44 | 79468.0 |
| 2008-04-01 11:00:00 | NQ | Futures | 2071.44 | 2079.92 | 2071.15 | 2079.07 | 43576.0 |
| 2008-04-01 12:00:00 | NQ | Futures | 2079.07 | 2087.56 | 2078.51 | 2081.34 | 44033.0 |
| 2008-04-01 13:00:00 | NQ | Futures | 2081.34 | 2093.5 | 2080.49 | 2089.54 | 43871.0 |
| 2008-04-01 14:00:00 | NQ | Futures | 2089.54 | 2101.7 | 2086.99 | 2095.19 | 50436.0 |
| 2008-04-01 15:00:00 | NQ | Futures | 2094.91 | 2106.51 | 2092.93 | 2105.38 | 83879.0 |
| 2008-04-01 16:00:00 | NQ | Futures | 2105.38 | 2106.79 | 2100.29 | 2102.83 | 19053.0 |
| 2008-04-01 17:00:00 | NQ | Futures | 2102.27 | 2104.81 | 2102.27 | 2104.53 | 199.0 |
| 2008-04-01 18:00:00 | NQ | Futures | 2105.09 | 2105.09 | 2099.15 | 2100.57 | 736.0 |
| 2008-04-01 19:00:00 | NQ | Futures | 2100.57 | 2100.57 | 2097.74 | 2098.02 | 389.0 |
| 2008-04-01 20:00:00 | NQ | Futures | 2098.02 | 2100.85 | 2095.76 | 2100.0 | 236.0 |
| 2008-04-01 21:00:00 | NQ | Futures | 2100.29 | 2100.57 | 2098.31 | 2098.31 | 45.0 |
| 2008-04-01 22:00:00 | NQ | Futures | 2098.59 | 2099.44 | 2097.46 | 2097.46 | 122.0 |
| 2008-04-01 23:00:00 | NQ | Futures | 2097.46 | 2099.15 | 2096.89 | 2098.59 | 31.0 |
| 2008-04-01 00:00:00 | YM | Futures | 11145.5 | 11146.4 | 11134.6 | 11142.8 | 109.0 |
| 2008-04-01 01:00:00 | YM | Futures | 11143.7 | 11149.2 | 11113.7 | 11121.9 | 252.0 |
> showing 50 of 1,253 rows — these rows as CSV