PREVIEW / futures_1hour / 2015-09-25
file: by_date/futures_1hour/2015/2015-09-25.parquet size: 45 KB rows: 1,298
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-09-25 00:00:00 | ES | Futures | 2056.33 | 2059.8 | 2055.79 | 2059.0 | 5013.0 |
| 2015-09-25 01:00:00 | ES | Futures | 2058.73 | 2062.75 | 2058.2 | 2062.48 | 8155.0 |
| 2015-09-25 02:00:00 | ES | Futures | 2062.21 | 2067.3 | 2061.68 | 2067.03 | 20466.0 |
| 2015-09-25 03:00:00 | ES | Futures | 2066.76 | 2072.11 | 2062.75 | 2067.56 | 41029.0 |
| 2015-09-25 04:00:00 | ES | Futures | 2067.83 | 2088.17 | 2067.3 | 2084.15 | 65375.0 |
| 2015-09-25 05:00:00 | ES | Futures | 2084.42 | 2086.83 | 2082.01 | 2083.35 | 40820.0 |
| 2015-09-25 06:00:00 | ES | Futures | 2083.35 | 2083.89 | 2077.73 | 2078.54 | 30352.0 |
| 2015-09-25 07:00:00 | ES | Futures | 2078.27 | 2084.96 | 2075.06 | 2083.08 | 50399.0 |
| 2015-09-25 08:00:00 | ES | Futures | 2083.08 | 2083.62 | 2075.59 | 2077.73 | 58609.0 |
| 2015-09-25 09:00:00 | ES | Futures | 2077.47 | 2078.8 | 2067.56 | 2072.65 | 281399.0 |
| 2015-09-25 10:00:00 | ES | Futures | 2072.38 | 2075.86 | 2066.49 | 2075.59 | 244221.0 |
| 2015-09-25 11:00:00 | ES | Futures | 2075.32 | 2075.86 | 2069.44 | 2072.92 | 133000.0 |
| 2015-09-25 12:00:00 | ES | Futures | 2073.18 | 2074.79 | 2067.56 | 2073.72 | 106845.0 |
| 2015-09-25 13:00:00 | ES | Futures | 2073.99 | 2079.07 | 2072.11 | 2073.45 | 137020.0 |
| 2015-09-25 14:00:00 | ES | Futures | 2073.45 | 2076.39 | 2049.9 | 2057.66 | 323568.0 |
| 2015-09-25 15:00:00 | ES | Futures | 2057.93 | 2060.61 | 2044.55 | 2055.79 | 392147.0 |
| 2015-09-25 16:00:00 | ES | Futures | 2055.52 | 2057.66 | 2049.1 | 2049.9 | 65357.0 |
| 2015-09-25 00:00:00 | NQ | Futures | 5041.83 | 5051.61 | 5040.05 | 5049.84 | 1328.0 |
| 2015-09-25 01:00:00 | NQ | Futures | 5048.95 | 5059.92 | 5048.65 | 5058.73 | 1864.0 |
| 2015-09-25 02:00:00 | NQ | Futures | 5059.03 | 5068.22 | 5055.17 | 5067.03 | 2777.0 |
| 2015-09-25 03:00:00 | NQ | Futures | 5066.74 | 5081.26 | 5056.65 | 5070.0 | 6905.0 |
| 2015-09-25 04:00:00 | NQ | Futures | 5069.7 | 5118.32 | 5068.22 | 5111.21 | 9775.0 |
| 2015-09-25 05:00:00 | NQ | Futures | 5111.51 | 5114.47 | 5099.05 | 5100.83 | 6324.0 |
| 2015-09-25 06:00:00 | NQ | Futures | 5100.54 | 5101.42 | 5088.08 | 5089.86 | 5097.0 |
| 2015-09-25 07:00:00 | NQ | Futures | 5090.16 | 5105.87 | 5083.04 | 5103.2 | 6399.0 |
| 2015-09-25 08:00:00 | NQ | Futures | 5102.91 | 5105.28 | 5090.16 | 5095.2 | 9299.0 |
| 2015-09-25 09:00:00 | NQ | Futures | 5094.9 | 5097.87 | 5070.89 | 5082.45 | 44533.0 |
| 2015-09-25 10:00:00 | NQ | Futures | 5082.15 | 5088.68 | 5056.95 | 5083.34 | 41306.0 |
| 2015-09-25 11:00:00 | NQ | Futures | 5083.34 | 5087.19 | 5061.4 | 5069.11 | 19693.0 |
| 2015-09-25 12:00:00 | NQ | Futures | 5069.11 | 5069.11 | 5048.65 | 5066.74 | 19994.0 |
| 2015-09-25 13:00:00 | NQ | Futures | 5067.03 | 5080.08 | 5054.58 | 5057.25 | 21452.0 |
| 2015-09-25 14:00:00 | NQ | Futures | 5057.25 | 5064.96 | 4985.2 | 5007.14 | 52943.0 |
| 2015-09-25 15:00:00 | NQ | Futures | 5007.14 | 5010.4 | 4963.85 | 4995.58 | 72563.0 |
| 2015-09-25 16:00:00 | NQ | Futures | 4995.58 | 5001.8 | 4985.79 | 4986.39 | 8479.0 |
| 2015-09-25 00:00:00 | YM | Futures | 17097.4 | 17128.1 | 17092.1 | 17124.9 | 976.0 |
| 2015-09-25 01:00:00 | YM | Futures | 17121.8 | 17149.3 | 17119.7 | 17147.2 | 1313.0 |
| 2015-09-25 02:00:00 | YM | Futures | 17148.3 | 17180.0 | 17137.7 | 17173.7 | 3892.0 |
| 2015-09-25 03:00:00 | YM | Futures | 17171.6 | 17215.0 | 17144.0 | 17182.1 | 6308.0 |
| 2015-09-25 04:00:00 | YM | Futures | 17182.1 | 17342.1 | 17175.8 | 17317.7 | 12958.0 |
| 2015-09-25 05:00:00 | YM | Futures | 17318.8 | 17342.1 | 17295.5 | 17314.6 | 7334.0 |
| 2015-09-25 06:00:00 | YM | Futures | 17315.6 | 17318.8 | 17278.5 | 17284.9 | 5659.0 |
| 2015-09-25 07:00:00 | YM | Futures | 17286.0 | 17325.1 | 17261.6 | 17314.6 | 7237.0 |
| 2015-09-25 08:00:00 | YM | Futures | 17316.7 | 17324.1 | 17264.8 | 17280.7 | 7986.0 |
| 2015-09-25 09:00:00 | YM | Futures | 17279.6 | 17288.1 | 17205.5 | 17237.2 | 30575.0 |
| 2015-09-25 10:00:00 | YM | Futures | 17238.3 | 17275.4 | 17198.0 | 17274.3 | 25415.0 |
| 2015-09-25 11:00:00 | YM | Futures | 17273.2 | 17275.4 | 17230.9 | 17263.7 | 12683.0 |
| 2015-09-25 12:00:00 | YM | Futures | 17263.7 | 17283.8 | 17221.3 | 17275.4 | 9206.0 |
| 2015-09-25 13:00:00 | YM | Futures | 17276.4 | 17334.7 | 17275.4 | 17289.1 | 15076.0 |
| 2015-09-25 14:00:00 | YM | Futures | 17288.1 | 17309.3 | 17109.1 | 17167.3 | 32118.0 |
| 2015-09-25 15:00:00 | YM | Futures | 17166.3 | 17197.0 | 17079.4 | 17172.6 | 37502.0 |
> showing 50 of 1,298 rows — these rows as CSV