PREVIEW / futures_1hour / 2008-06-13
file: by_date/futures_1hour/2008/2008-06-13.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-06-13 00:00:00 | ES | Futures | 1248.51 | 1249.67 | 1248.51 | 1249.67 | 608.0 |
| 2008-06-13 01:00:00 | ES | Futures | 1249.67 | 1249.9 | 1247.34 | 1249.44 | 969.0 |
| 2008-06-13 02:00:00 | ES | Futures | 1249.44 | 1253.16 | 1247.81 | 1252.47 | 5607.0 |
| 2008-06-13 03:00:00 | ES | Futures | 1252.47 | 1252.7 | 1247.58 | 1248.04 | 5462.0 |
| 2008-06-13 04:00:00 | ES | Futures | 1248.04 | 1248.04 | 1245.48 | 1246.18 | 8404.0 |
| 2008-06-13 05:00:00 | ES | Futures | 1246.41 | 1248.28 | 1245.25 | 1247.34 | 5873.0 |
| 2008-06-13 06:00:00 | ES | Futures | 1247.34 | 1251.77 | 1247.34 | 1251.07 | 10276.0 |
| 2008-06-13 07:00:00 | ES | Futures | 1250.84 | 1251.3 | 1247.58 | 1249.9 | 6058.0 |
| 2008-06-13 08:00:00 | ES | Futures | 1249.9 | 1257.82 | 1247.11 | 1255.49 | 53391.0 |
| 2008-06-13 09:00:00 | ES | Futures | 1255.49 | 1257.36 | 1249.67 | 1255.73 | 76752.0 |
| 2008-06-13 10:00:00 | ES | Futures | 1255.49 | 1266.2 | 1254.79 | 1260.62 | 123203.0 |
| 2008-06-13 11:00:00 | ES | Futures | 1260.85 | 1264.11 | 1260.38 | 1260.85 | 37628.0 |
| 2008-06-13 12:00:00 | ES | Futures | 1260.62 | 1262.25 | 1256.66 | 1257.12 | 27266.0 |
| 2008-06-13 13:00:00 | ES | Futures | 1257.12 | 1258.29 | 1252.23 | 1254.79 | 40555.0 |
| 2008-06-13 14:00:00 | ES | Futures | 1254.79 | 1260.15 | 1252.7 | 1260.15 | 31586.0 |
| 2008-06-13 15:00:00 | ES | Futures | 1260.15 | 1267.14 | 1256.66 | 1266.67 | 59254.0 |
| 2008-06-13 16:00:00 | ES | Futures | 1266.9 | 1268.07 | 1262.25 | 1263.41 | 27280.0 |
| 2008-06-13 00:00:00 | NQ | Futures | 2181.46 | 2183.44 | 2181.17 | 2182.02 | 36.0 |
| 2008-06-13 01:00:00 | NQ | Futures | 2184.29 | 2184.85 | 2180.04 | 2183.72 | 29.0 |
| 2008-06-13 02:00:00 | NQ | Futures | 2184.0 | 2188.53 | 2179.76 | 2187.68 | 172.0 |
| 2008-06-13 03:00:00 | NQ | Futures | 2187.96 | 2189.09 | 2180.61 | 2181.46 | 369.0 |
| 2008-06-13 04:00:00 | NQ | Futures | 2180.04 | 2180.04 | 2174.1 | 2175.52 | 204.0 |
| 2008-06-13 05:00:00 | NQ | Futures | 2175.52 | 2178.06 | 2171.56 | 2173.82 | 217.0 |
| 2008-06-13 06:00:00 | NQ | Futures | 2175.23 | 2182.31 | 2174.95 | 2180.89 | 163.0 |
| 2008-06-13 07:00:00 | NQ | Futures | 2180.89 | 2180.89 | 2173.82 | 2180.04 | 197.0 |
| 2008-06-13 08:00:00 | NQ | Futures | 2180.04 | 2200.97 | 2178.91 | 2197.3 | 4098.0 |
| 2008-06-13 09:00:00 | NQ | Futures | 2197.86 | 2200.69 | 2181.74 | 2199.84 | 18575.0 |
| 2008-06-13 10:00:00 | NQ | Futures | 2199.56 | 2229.26 | 2197.86 | 2216.53 | 26595.0 |
| 2008-06-13 11:00:00 | NQ | Futures | 2216.81 | 2223.32 | 2216.25 | 2218.79 | 7240.0 |
| 2008-06-13 12:00:00 | NQ | Futures | 2218.22 | 2221.9 | 2208.04 | 2212.57 | 6276.0 |
| 2008-06-13 13:00:00 | NQ | Futures | 2212.0 | 2213.98 | 2198.14 | 2202.39 | 8079.0 |
| 2008-06-13 14:00:00 | NQ | Futures | 2202.39 | 2215.11 | 2197.58 | 2214.27 | 7178.0 |
| 2008-06-13 15:00:00 | NQ | Futures | 2213.7 | 2225.58 | 2203.23 | 2225.01 | 13735.0 |
| 2008-06-13 16:00:00 | NQ | Futures | 2225.01 | 2225.86 | 2221.62 | 2221.62 | 5390.0 |
| 2008-06-13 00:00:00 | YM | Futures | 11040.1 | 11047.4 | 11040.1 | 11045.5 | 31.0 |
| 2008-06-13 01:00:00 | YM | Futures | 11045.5 | 11051.0 | 11036.5 | 11046.5 | 57.0 |
| 2008-06-13 02:00:00 | YM | Futures | 11039.2 | 11077.4 | 11036.5 | 11076.4 | 84.0 |
| 2008-06-13 03:00:00 | YM | Futures | 11072.8 | 11075.5 | 11035.6 | 11039.2 | 421.0 |
| 2008-06-13 04:00:00 | YM | Futures | 11038.3 | 11038.3 | 11015.6 | 11025.6 | 671.0 |
| 2008-06-13 05:00:00 | YM | Futures | 11024.6 | 11035.6 | 11011.9 | 11026.5 | 323.0 |
| 2008-06-13 06:00:00 | YM | Futures | 11029.2 | 11071.9 | 11028.3 | 11065.5 | 871.0 |
| 2008-06-13 07:00:00 | YM | Futures | 11063.7 | 11065.5 | 11041.9 | 11062.8 | 366.0 |
| 2008-06-13 08:00:00 | YM | Futures | 11061.0 | 11116.4 | 11037.4 | 11099.2 | 3916.0 |
| 2008-06-13 09:00:00 | YM | Futures | 11100.1 | 11118.3 | 11058.3 | 11108.3 | 20340.0 |
| 2008-06-13 10:00:00 | YM | Futures | 11109.2 | 11191.0 | 11102.8 | 11136.4 | 33374.0 |
| 2008-06-13 11:00:00 | YM | Futures | 11136.4 | 11169.2 | 11132.8 | 11138.3 | 13438.0 |
| 2008-06-13 12:00:00 | YM | Futures | 11138.3 | 11151.0 | 11105.5 | 11110.1 | 9056.0 |
| 2008-06-13 13:00:00 | YM | Futures | 11111.0 | 11121.9 | 11072.8 | 11092.8 | 14238.0 |
| 2008-06-13 14:00:00 | YM | Futures | 11092.8 | 11137.3 | 11076.4 | 11136.4 | 16398.0 |
| 2008-06-13 15:00:00 | YM | Futures | 11136.4 | 11191.0 | 11108.3 | 11188.2 | 19941.0 |
> showing 50 of 996 rows — these rows as CSV