PREVIEW / futures_1hour / 2008-08-15
file: by_date/futures_1hour/2008/2008-08-15.parquet size: 36 KB rows: 996
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-08-15 00:00:00 | ES | Futures | 1206.0 | 1207.17 | 1205.07 | 1206.7 | 1626.0 |
| 2008-08-15 01:00:00 | ES | Futures | 1206.7 | 1208.56 | 1206.0 | 1207.4 | 2527.0 |
| 2008-08-15 02:00:00 | ES | Futures | 1207.4 | 1207.63 | 1203.91 | 1205.07 | 6370.0 |
| 2008-08-15 03:00:00 | ES | Futures | 1205.31 | 1206.7 | 1204.14 | 1206.47 | 6335.0 |
| 2008-08-15 04:00:00 | ES | Futures | 1206.24 | 1208.79 | 1206.24 | 1206.93 | 7600.0 |
| 2008-08-15 05:00:00 | ES | Futures | 1207.17 | 1209.95 | 1207.17 | 1207.4 | 8924.0 |
| 2008-08-15 06:00:00 | ES | Futures | 1207.17 | 1207.63 | 1205.54 | 1206.93 | 12190.0 |
| 2008-08-15 07:00:00 | ES | Futures | 1206.7 | 1208.1 | 1203.21 | 1203.91 | 25362.0 |
| 2008-08-15 08:00:00 | ES | Futures | 1203.91 | 1208.79 | 1203.21 | 1205.77 | 51854.0 |
| 2008-08-15 09:00:00 | ES | Futures | 1205.54 | 1210.88 | 1204.14 | 1207.63 | 255205.0 |
| 2008-08-15 10:00:00 | ES | Futures | 1207.63 | 1209.72 | 1199.73 | 1209.49 | 358742.0 |
| 2008-08-15 11:00:00 | ES | Futures | 1209.49 | 1210.19 | 1204.38 | 1205.54 | 195167.0 |
| 2008-08-15 12:00:00 | ES | Futures | 1205.31 | 1207.63 | 1202.98 | 1206.24 | 110223.0 |
| 2008-08-15 13:00:00 | ES | Futures | 1206.24 | 1207.17 | 1204.61 | 1205.31 | 81293.0 |
| 2008-08-15 14:00:00 | ES | Futures | 1205.31 | 1205.77 | 1202.98 | 1204.84 | 108214.0 |
| 2008-08-15 15:00:00 | ES | Futures | 1204.84 | 1207.86 | 1204.61 | 1207.17 | 143837.0 |
| 2008-08-15 16:00:00 | ES | Futures | 1207.17 | 1209.02 | 1206.7 | 1208.33 | 80246.0 |
| 2008-08-15 00:00:00 | NQ | Futures | 2217.12 | 2217.96 | 2215.99 | 2217.96 | 227.0 |
| 2008-08-15 01:00:00 | NQ | Futures | 2217.68 | 2219.65 | 2215.99 | 2217.96 | 482.0 |
| 2008-08-15 02:00:00 | NQ | Futures | 2217.4 | 2218.81 | 2212.9 | 2214.87 | 679.0 |
| 2008-08-15 03:00:00 | NQ | Futures | 2215.15 | 2216.84 | 2213.18 | 2215.71 | 818.0 |
| 2008-08-15 04:00:00 | NQ | Futures | 2215.99 | 2219.65 | 2215.71 | 2217.68 | 2028.0 |
| 2008-08-15 05:00:00 | NQ | Futures | 2217.68 | 2221.9 | 2217.68 | 2218.52 | 1523.0 |
| 2008-08-15 06:00:00 | NQ | Futures | 2218.24 | 2220.49 | 2215.99 | 2219.09 | 1970.0 |
| 2008-08-15 07:00:00 | NQ | Futures | 2218.81 | 2220.78 | 2212.06 | 2212.9 | 2611.0 |
| 2008-08-15 08:00:00 | NQ | Futures | 2213.18 | 2221.9 | 2212.34 | 2215.99 | 7256.0 |
| 2008-08-15 09:00:00 | NQ | Futures | 2215.43 | 2224.71 | 2210.93 | 2216.27 | 59573.0 |
| 2008-08-15 10:00:00 | NQ | Futures | 2215.99 | 2222.18 | 2198.83 | 2220.78 | 92830.0 |
| 2008-08-15 11:00:00 | NQ | Futures | 2220.78 | 2221.06 | 2206.43 | 2207.55 | 47648.0 |
| 2008-08-15 12:00:00 | NQ | Futures | 2207.84 | 2214.31 | 2205.59 | 2211.49 | 25160.0 |
| 2008-08-15 13:00:00 | NQ | Futures | 2211.49 | 2212.9 | 2203.62 | 2204.74 | 20704.0 |
| 2008-08-15 14:00:00 | NQ | Futures | 2204.74 | 2205.87 | 2196.87 | 2202.49 | 36998.0 |
| 2008-08-15 15:00:00 | NQ | Futures | 2202.49 | 2210.09 | 2201.65 | 2205.87 | 32685.0 |
| 2008-08-15 16:00:00 | NQ | Futures | 2205.87 | 2213.18 | 2204.74 | 2210.65 | 9896.0 |
| 2008-08-15 00:00:00 | YM | Futures | 10582.0 | 10588.4 | 10573.8 | 10588.4 | 119.0 |
| 2008-08-15 01:00:00 | YM | Futures | 10588.4 | 10598.4 | 10583.8 | 10596.6 | 224.0 |
| 2008-08-15 02:00:00 | YM | Futures | 10596.6 | 10597.5 | 10573.8 | 10582.0 | 481.0 |
| 2008-08-15 03:00:00 | YM | Futures | 10582.9 | 10593.8 | 10574.8 | 10590.2 | 546.0 |
| 2008-08-15 04:00:00 | YM | Futures | 10589.3 | 10610.2 | 10587.5 | 10592.9 | 867.0 |
| 2008-08-15 05:00:00 | YM | Futures | 10592.9 | 10617.5 | 10592.9 | 10596.6 | 778.0 |
| 2008-08-15 06:00:00 | YM | Futures | 10597.5 | 10602.0 | 10579.3 | 10598.4 | 1133.0 |
| 2008-08-15 07:00:00 | YM | Futures | 10598.4 | 10607.5 | 10565.7 | 10572.0 | 1733.0 |
| 2008-08-15 08:00:00 | YM | Futures | 10572.0 | 10609.3 | 10567.5 | 10584.7 | 3715.0 |
| 2008-08-15 09:00:00 | YM | Futures | 10583.8 | 10640.2 | 10568.4 | 10614.7 | 29066.0 |
| 2008-08-15 10:00:00 | YM | Futures | 10615.7 | 10632.0 | 10538.4 | 10627.5 | 50230.0 |
| 2008-08-15 11:00:00 | YM | Futures | 10626.6 | 10632.0 | 10573.8 | 10582.0 | 26124.0 |
| 2008-08-15 12:00:00 | YM | Futures | 10582.9 | 10602.0 | 10552.9 | 10587.5 | 18667.0 |
| 2008-08-15 13:00:00 | YM | Futures | 10588.4 | 10594.7 | 10566.6 | 10573.8 | 12157.0 |
| 2008-08-15 14:00:00 | YM | Futures | 10573.8 | 10579.3 | 10549.3 | 10575.7 | 18057.0 |
| 2008-08-15 15:00:00 | YM | Futures | 10575.7 | 10603.8 | 10572.0 | 10595.7 | 20920.0 |
> showing 50 of 996 rows — these rows as CSV