PREVIEW / futures_1hour / 2015-10-22
file: by_date/futures_1hour/2015/2015-10-22.parquet size: 52 KB rows: 1,574
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-10-22 00:00:00 | ES | Futures | 2155.6 | 2156.94 | 2153.99 | 2155.33 | 3823.0 |
| 2015-10-22 01:00:00 | ES | Futures | 2155.33 | 2156.13 | 2154.26 | 2155.6 | 3291.0 |
| 2015-10-22 02:00:00 | ES | Futures | 2155.86 | 2157.47 | 2154.26 | 2156.4 | 8606.0 |
| 2015-10-22 03:00:00 | ES | Futures | 2156.4 | 2158.54 | 2155.06 | 2155.33 | 19750.0 |
| 2015-10-22 04:00:00 | ES | Futures | 2155.33 | 2157.47 | 2153.99 | 2155.33 | 10864.0 |
| 2015-10-22 05:00:00 | ES | Futures | 2155.33 | 2157.74 | 2155.33 | 2156.94 | 7254.0 |
| 2015-10-22 06:00:00 | ES | Futures | 2156.94 | 2159.08 | 2156.94 | 2157.2 | 11296.0 |
| 2015-10-22 07:00:00 | ES | Futures | 2157.47 | 2158.54 | 2156.4 | 2157.2 | 21771.0 |
| 2015-10-22 08:00:00 | ES | Futures | 2157.2 | 2165.77 | 2156.13 | 2162.55 | 97306.0 |
| 2015-10-22 09:00:00 | ES | Futures | 2163.09 | 2175.67 | 2159.61 | 2175.67 | 349620.0 |
| 2015-10-22 10:00:00 | ES | Futures | 2175.67 | 2182.36 | 2174.33 | 2182.09 | 349642.0 |
| 2015-10-22 11:00:00 | ES | Futures | 2182.09 | 2186.1 | 2179.68 | 2183.96 | 208435.0 |
| 2015-10-22 12:00:00 | ES | Futures | 2183.96 | 2192.79 | 2182.62 | 2190.92 | 196171.0 |
| 2015-10-22 13:00:00 | ES | Futures | 2190.92 | 2192.26 | 2184.5 | 2184.76 | 145082.0 |
| 2015-10-22 14:00:00 | ES | Futures | 2184.76 | 2189.58 | 2177.54 | 2189.31 | 237654.0 |
| 2015-10-22 15:00:00 | ES | Futures | 2189.04 | 2191.99 | 2184.76 | 2189.58 | 242891.0 |
| 2015-10-22 16:00:00 | ES | Futures | 2189.58 | 2200.55 | 2188.24 | 2200.28 | 150266.0 |
| 2015-10-22 18:00:00 | ES | Futures | 2198.68 | 2206.7 | 2197.61 | 2204.3 | 18912.0 |
| 2015-10-22 19:00:00 | ES | Futures | 2204.3 | 2204.56 | 2202.96 | 2203.76 | 5876.0 |
| 2015-10-22 20:00:00 | ES | Futures | 2204.03 | 2204.03 | 2201.89 | 2203.49 | 8080.0 |
| 2015-10-22 21:00:00 | ES | Futures | 2203.76 | 2203.76 | 2201.35 | 2201.62 | 6864.0 |
| 2015-10-22 22:00:00 | ES | Futures | 2201.62 | 2202.96 | 2201.62 | 2201.89 | 4805.0 |
| 2015-10-22 23:00:00 | ES | Futures | 2201.89 | 2202.96 | 2200.55 | 2201.89 | 4129.0 |
| 2015-10-22 00:00:00 | NQ | Futures | 5233.36 | 5236.03 | 5228.92 | 5233.07 | 690.0 |
| 2015-10-22 01:00:00 | NQ | Futures | 5232.77 | 5234.25 | 5229.81 | 5233.36 | 445.0 |
| 2015-10-22 02:00:00 | NQ | Futures | 5233.07 | 5238.7 | 5230.1 | 5235.44 | 1142.0 |
| 2015-10-22 03:00:00 | NQ | Futures | 5235.73 | 5240.78 | 5231.58 | 5232.47 | 2684.0 |
| 2015-10-22 04:00:00 | NQ | Futures | 5232.47 | 5237.51 | 5230.1 | 5233.66 | 1155.0 |
| 2015-10-22 05:00:00 | NQ | Futures | 5233.66 | 5238.7 | 5232.77 | 5236.92 | 929.0 |
| 2015-10-22 06:00:00 | NQ | Futures | 5237.51 | 5242.55 | 5236.92 | 5239.0 | 1363.0 |
| 2015-10-22 07:00:00 | NQ | Futures | 5239.29 | 5244.04 | 5237.22 | 5240.78 | 2984.0 |
| 2015-10-22 08:00:00 | NQ | Futures | 5240.78 | 5262.72 | 5239.89 | 5256.19 | 13589.0 |
| 2015-10-22 09:00:00 | NQ | Futures | 5256.49 | 5295.92 | 5250.56 | 5291.18 | 61135.0 |
| 2015-10-22 10:00:00 | NQ | Futures | 5291.77 | 5311.93 | 5285.25 | 5310.75 | 55692.0 |
| 2015-10-22 11:00:00 | NQ | Futures | 5310.75 | 5318.75 | 5297.7 | 5309.26 | 36111.0 |
| 2015-10-22 12:00:00 | NQ | Futures | 5309.26 | 5332.69 | 5305.11 | 5326.76 | 30958.0 |
| 2015-10-22 13:00:00 | NQ | Futures | 5327.05 | 5331.21 | 5311.93 | 5312.53 | 20861.0 |
| 2015-10-22 14:00:00 | NQ | Futures | 5312.23 | 5325.87 | 5297.7 | 5323.2 | 36495.0 |
| 2015-10-22 15:00:00 | NQ | Futures | 5322.9 | 5331.8 | 5314.6 | 5327.94 | 37045.0 |
| 2015-10-22 16:00:00 | NQ | Futures | 5327.94 | 5414.52 | 5322.9 | 5414.22 | 35626.0 |
| 2015-10-22 18:00:00 | NQ | Futures | 5410.66 | 5438.83 | 5410.37 | 5430.53 | 5296.0 |
| 2015-10-22 19:00:00 | NQ | Futures | 5430.53 | 5431.42 | 5425.79 | 5427.56 | 1071.0 |
| 2015-10-22 20:00:00 | NQ | Futures | 5428.16 | 5430.53 | 5423.71 | 5429.94 | 1281.0 |
| 2015-10-22 21:00:00 | NQ | Futures | 5429.34 | 5430.53 | 5420.75 | 5421.04 | 1756.0 |
| 2015-10-22 22:00:00 | NQ | Futures | 5420.75 | 5423.41 | 5419.26 | 5420.75 | 1365.0 |
| 2015-10-22 23:00:00 | NQ | Futures | 5420.75 | 5424.01 | 5417.48 | 5421.63 | 714.0 |
| 2015-10-22 00:00:00 | YM | Futures | 18097.3 | 18107.9 | 18087.8 | 18100.5 | 774.0 |
| 2015-10-22 01:00:00 | YM | Futures | 18100.5 | 18103.7 | 18089.9 | 18099.5 | 429.0 |
| 2015-10-22 02:00:00 | YM | Futures | 18101.6 | 18118.5 | 18094.2 | 18107.9 | 894.0 |
| 2015-10-22 03:00:00 | YM | Futures | 18109.0 | 18129.1 | 18097.3 | 18101.6 | 2115.0 |
> showing 50 of 1,574 rows — these rows as CSV