PREVIEW / futures_1hour / 2015-12-14
file: by_date/futures_1hour/2015/2015-12-14.parquet size: 52 KB rows: 1,580
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 |
|---|---|---|---|---|---|---|---|
| 2015-12-14 00:00:00 | ES | Futures | 2158.81 | 2161.76 | 2157.2 | 2161.23 | 4792.0 |
| 2015-12-14 01:00:00 | ES | Futures | 2161.23 | 2162.3 | 2159.61 | 2161.23 | 3337.0 |
| 2015-12-14 02:00:00 | ES | Futures | 2161.5 | 2168.75 | 2161.23 | 2165.53 | 14322.0 |
| 2015-12-14 03:00:00 | ES | Futures | 2165.53 | 2170.63 | 2159.35 | 2160.15 | 32560.0 |
| 2015-12-14 04:00:00 | ES | Futures | 2160.15 | 2167.68 | 2160.15 | 2166.6 | 22956.0 |
| 2015-12-14 05:00:00 | ES | Futures | 2166.6 | 2166.87 | 2161.5 | 2165.26 | 16509.0 |
| 2015-12-14 06:00:00 | ES | Futures | 2165.26 | 2165.53 | 2144.84 | 2151.82 | 48832.0 |
| 2015-12-14 07:00:00 | ES | Futures | 2152.09 | 2154.51 | 2140.27 | 2148.33 | 43838.0 |
| 2015-12-14 08:00:00 | ES | Futures | 2148.06 | 2158.0 | 2143.49 | 2155.05 | 71059.0 |
| 2015-12-14 09:00:00 | ES | Futures | 2155.32 | 2161.76 | 2148.06 | 2148.87 | 254996.0 |
| 2015-12-14 10:00:00 | ES | Futures | 2149.13 | 2164.72 | 2141.07 | 2146.99 | 405095.0 |
| 2015-12-14 11:00:00 | ES | Futures | 2146.99 | 2147.79 | 2131.67 | 2143.49 | 264419.0 |
| 2015-12-14 12:00:00 | ES | Futures | 2143.49 | 2158.81 | 2141.34 | 2157.2 | 186724.0 |
| 2015-12-14 13:00:00 | ES | Futures | 2157.2 | 2160.15 | 2145.91 | 2151.28 | 125331.0 |
| 2015-12-14 14:00:00 | ES | Futures | 2151.28 | 2158.54 | 2146.72 | 2155.58 | 146898.0 |
| 2015-12-14 15:00:00 | ES | Futures | 2155.58 | 2164.99 | 2148.6 | 2164.72 | 248412.0 |
| 2015-12-14 16:00:00 | ES | Futures | 2164.45 | 2166.6 | 2159.61 | 2162.03 | 78441.0 |
| 2015-12-14 18:00:00 | ES | Futures | 2163.65 | 2170.09 | 2162.84 | 2167.94 | 11224.0 |
| 2015-12-14 19:00:00 | ES | Futures | 2168.21 | 2169.02 | 2163.38 | 2165.79 | 7061.0 |
| 2015-12-14 20:00:00 | ES | Futures | 2165.79 | 2166.6 | 2162.3 | 2163.91 | 4505.0 |
| 2015-12-14 21:00:00 | ES | Futures | 2163.91 | 2166.33 | 2162.57 | 2165.79 | 3531.0 |
| 2015-12-14 22:00:00 | ES | Futures | 2165.79 | 2166.6 | 2164.18 | 2165.26 | 3332.0 |
| 2015-12-14 23:00:00 | ES | Futures | 2165.26 | 2165.53 | 2163.91 | 2164.18 | 1927.0 |
| 2015-12-14 00:00:00 | NQ | Futures | 5398.51 | 5405.64 | 5393.76 | 5403.85 | 736.0 |
| 2015-12-14 01:00:00 | NQ | Futures | 5404.15 | 5408.9 | 5399.7 | 5406.53 | 613.0 |
| 2015-12-14 02:00:00 | NQ | Futures | 5406.82 | 5425.83 | 5406.82 | 5418.7 | 2916.0 |
| 2015-12-14 03:00:00 | NQ | Futures | 5418.7 | 5431.47 | 5404.45 | 5406.23 | 5870.0 |
| 2015-12-14 04:00:00 | NQ | Futures | 5406.82 | 5424.34 | 5406.82 | 5421.67 | 2206.0 |
| 2015-12-14 05:00:00 | NQ | Futures | 5421.67 | 5422.56 | 5408.9 | 5417.51 | 1609.0 |
| 2015-12-14 06:00:00 | NQ | Futures | 5417.22 | 5418.11 | 5370.6 | 5385.74 | 6532.0 |
| 2015-12-14 07:00:00 | NQ | Futures | 5386.04 | 5391.68 | 5356.34 | 5371.78 | 6843.0 |
| 2015-12-14 08:00:00 | NQ | Futures | 5371.49 | 5394.05 | 5359.61 | 5385.74 | 10041.0 |
| 2015-12-14 09:00:00 | NQ | Futures | 5386.33 | 5399.4 | 5366.74 | 5370.89 | 47538.0 |
| 2015-12-14 10:00:00 | NQ | Futures | 5371.78 | 5403.26 | 5345.36 | 5364.66 | 85203.0 |
| 2015-12-14 11:00:00 | NQ | Futures | 5364.36 | 5366.74 | 5310.62 | 5346.84 | 52834.0 |
| 2015-12-14 12:00:00 | NQ | Futures | 5347.44 | 5386.04 | 5340.31 | 5383.37 | 31608.0 |
| 2015-12-14 13:00:00 | NQ | Futures | 5383.07 | 5391.38 | 5365.55 | 5383.07 | 19207.0 |
| 2015-12-14 14:00:00 | NQ | Futures | 5383.07 | 5408.01 | 5371.49 | 5400.29 | 24849.0 |
| 2015-12-14 15:00:00 | NQ | Futures | 5400.29 | 5424.64 | 5380.69 | 5422.26 | 36167.0 |
| 2015-12-14 16:00:00 | NQ | Futures | 5422.26 | 5432.06 | 5415.14 | 5422.86 | 13157.0 |
| 2015-12-14 18:00:00 | NQ | Futures | 5422.86 | 5439.19 | 5422.56 | 5434.14 | 1530.0 |
| 2015-12-14 19:00:00 | NQ | Futures | 5433.84 | 5436.22 | 5423.45 | 5430.28 | 1669.0 |
| 2015-12-14 20:00:00 | NQ | Futures | 5429.69 | 5432.06 | 5421.67 | 5426.72 | 1188.0 |
| 2015-12-14 21:00:00 | NQ | Futures | 5427.31 | 5434.14 | 5424.04 | 5431.77 | 900.0 |
| 2015-12-14 22:00:00 | NQ | Futures | 5431.77 | 5432.66 | 5427.31 | 5429.69 | 642.0 |
| 2015-12-14 23:00:00 | NQ | Futures | 5430.28 | 5430.28 | 5424.94 | 5426.42 | 590.0 |
| 2015-12-14 00:00:00 | YM | Futures | 18335.6 | 18361.2 | 18327.1 | 18358.0 | 443.0 |
| 2015-12-14 01:00:00 | YM | Futures | 18358.0 | 18368.6 | 18346.3 | 18360.1 | 499.0 |
| 2015-12-14 02:00:00 | YM | Futures | 18361.2 | 18419.7 | 18361.2 | 18389.9 | 2072.0 |
| 2015-12-14 03:00:00 | YM | Futures | 18392.1 | 18432.5 | 18342.0 | 18348.4 | 4400.0 |
> showing 50 of 1,580 rows — these rows as CSV