PREVIEW / futures_1hour / 2015-09-11
file: by_date/futures_1hour/2015/2015-09-11.parquet size: 42 KB rows: 1,220
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-11 00:00:00 | ES | Futures | 2083.93 | 2084.72 | 2082.33 | 2083.39 | 1268.0 |
| 2015-09-11 01:00:00 | ES | Futures | 2083.66 | 2084.46 | 2079.67 | 2081.26 | 1902.0 |
| 2015-09-11 02:00:00 | ES | Futures | 2081.26 | 2083.39 | 2078.6 | 2081.26 | 4652.0 |
| 2015-09-11 03:00:00 | ES | Futures | 2081.0 | 2081.53 | 2067.42 | 2075.94 | 17705.0 |
| 2015-09-11 04:00:00 | ES | Futures | 2075.94 | 2076.74 | 2063.42 | 2065.02 | 11864.0 |
| 2015-09-11 05:00:00 | ES | Futures | 2065.02 | 2073.01 | 2063.16 | 2072.74 | 10040.0 |
| 2015-09-11 06:00:00 | ES | Futures | 2072.74 | 2073.81 | 2065.82 | 2066.09 | 7563.0 |
| 2015-09-11 07:00:00 | ES | Futures | 2066.35 | 2071.94 | 2064.22 | 2070.61 | 8989.0 |
| 2015-09-11 08:00:00 | ES | Futures | 2070.61 | 2074.07 | 2065.29 | 2066.35 | 20295.0 |
| 2015-09-11 09:00:00 | ES | Futures | 2066.62 | 2073.81 | 2065.02 | 2065.55 | 60057.0 |
| 2015-09-11 10:00:00 | ES | Futures | 2065.55 | 2071.41 | 2063.42 | 2066.35 | 59715.0 |
| 2015-09-11 11:00:00 | ES | Futures | 2066.35 | 2077.0 | 2065.29 | 2075.67 | 57908.0 |
| 2015-09-11 12:00:00 | ES | Futures | 2075.41 | 2082.59 | 2075.14 | 2080.73 | 40368.0 |
| 2015-09-11 13:00:00 | ES | Futures | 2081.0 | 2081.26 | 2071.68 | 2075.14 | 29056.0 |
| 2015-09-11 14:00:00 | ES | Futures | 2075.14 | 2082.06 | 2072.21 | 2079.67 | 35329.0 |
| 2015-09-11 15:00:00 | ES | Futures | 2079.93 | 2087.39 | 2079.4 | 2087.39 | 68201.0 |
| 2015-09-11 16:00:00 | ES | Futures | 2087.12 | 2090.05 | 2086.32 | 2088.72 | 29758.0 |
| 2015-09-11 17:00:00 | ES | Futures | 2088.72 | 2090.05 | 2087.92 | 2089.52 | 783.0 |
| 2015-09-11 00:00:00 | NQ | Futures | 5100.0 | 5105.33 | 5096.75 | 5098.82 | 269.0 |
| 2015-09-11 01:00:00 | NQ | Futures | 5098.52 | 5100.89 | 5088.17 | 5093.2 | 276.0 |
| 2015-09-11 02:00:00 | NQ | Futures | 5089.94 | 5097.04 | 5084.03 | 5087.58 | 653.0 |
| 2015-09-11 03:00:00 | NQ | Futures | 5089.35 | 5089.35 | 5052.67 | 5072.49 | 2880.0 |
| 2015-09-11 04:00:00 | NQ | Futures | 5074.56 | 5076.93 | 5040.25 | 5044.1 | 2423.0 |
| 2015-09-11 05:00:00 | NQ | Futures | 5044.69 | 5065.99 | 5039.66 | 5065.1 | 1201.0 |
| 2015-09-11 06:00:00 | NQ | Futures | 5065.99 | 5068.06 | 5048.53 | 5050.01 | 1212.0 |
| 2015-09-11 07:00:00 | NQ | Futures | 5049.42 | 5067.46 | 5046.46 | 5062.73 | 1281.0 |
| 2015-09-11 08:00:00 | NQ | Futures | 5063.03 | 5071.01 | 5049.13 | 5051.79 | 2554.0 |
| 2015-09-11 09:00:00 | NQ | Futures | 5051.49 | 5074.56 | 5049.42 | 5052.38 | 13380.0 |
| 2015-09-11 10:00:00 | NQ | Futures | 5052.08 | 5070.13 | 5047.35 | 5055.63 | 11976.0 |
| 2015-09-11 11:00:00 | NQ | Futures | 5055.63 | 5080.18 | 5049.72 | 5076.93 | 10842.0 |
| 2015-09-11 12:00:00 | NQ | Futures | 5077.23 | 5100.3 | 5075.75 | 5094.97 | 9401.0 |
| 2015-09-11 13:00:00 | NQ | Futures | 5095.56 | 5097.04 | 5073.08 | 5082.55 | 5896.0 |
| 2015-09-11 14:00:00 | NQ | Futures | 5081.66 | 5103.55 | 5073.68 | 5097.63 | 5958.0 |
| 2015-09-11 15:00:00 | NQ | Futures | 5097.63 | 5112.72 | 5096.45 | 5112.72 | 9682.0 |
| 2015-09-11 16:00:00 | NQ | Futures | 5112.13 | 5122.19 | 5110.35 | 5120.41 | 2750.0 |
| 2015-09-11 17:00:00 | NQ | Futures | 5121.59 | 5123.07 | 5118.93 | 5122.19 | 120.0 |
| 2015-09-11 00:00:00 | YM | Futures | 17228.8 | 17238.3 | 17221.3 | 17225.6 | 272.0 |
| 2015-09-11 01:00:00 | YM | Futures | 17230.9 | 17233.0 | 17193.8 | 17211.8 | 477.0 |
| 2015-09-11 02:00:00 | YM | Futures | 17213.9 | 17223.5 | 17186.4 | 17203.3 | 799.0 |
| 2015-09-11 03:00:00 | YM | Futures | 17205.5 | 17207.6 | 17098.5 | 17161.0 | 3157.0 |
| 2015-09-11 04:00:00 | YM | Futures | 17163.1 | 17169.4 | 17069.9 | 17079.4 | 2399.0 |
| 2015-09-11 05:00:00 | YM | Futures | 17081.5 | 17145.1 | 17067.8 | 17143.0 | 1536.0 |
| 2015-09-11 06:00:00 | YM | Futures | 17146.1 | 17153.5 | 17085.8 | 17090.0 | 1478.0 |
| 2015-09-11 07:00:00 | YM | Futures | 17090.0 | 17136.6 | 17076.2 | 17126.0 | 1726.0 |
| 2015-09-11 08:00:00 | YM | Futures | 17126.0 | 17146.1 | 17081.5 | 17088.9 | 3530.0 |
| 2015-09-11 09:00:00 | YM | Futures | 17093.2 | 17162.0 | 17085.8 | 17108.0 | 15190.0 |
| 2015-09-11 10:00:00 | YM | Futures | 17102.7 | 17156.7 | 17088.9 | 17122.8 | 12702.0 |
| 2015-09-11 11:00:00 | YM | Futures | 17123.9 | 17217.1 | 17114.4 | 17205.5 | 14174.0 |
| 2015-09-11 12:00:00 | YM | Futures | 17207.6 | 17267.9 | 17202.3 | 17253.1 | 7899.0 |
| 2015-09-11 13:00:00 | YM | Futures | 17254.2 | 17256.3 | 17173.7 | 17200.2 | 6236.0 |
> showing 50 of 1,220 rows — these rows as CSV