PREVIEW / futures_1hour / 2015-12-18
file: by_date/futures_1hour/2015/2015-12-18.parquet size: 45 KB rows: 1,314
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-18 00:00:00 | ES | Futures | 2169.83 | 2171.17 | 2166.33 | 2169.29 | 11343.0 |
| 2015-12-18 01:00:00 | ES | Futures | 2169.56 | 2172.78 | 2167.68 | 2170.63 | 6446.0 |
| 2015-12-18 02:00:00 | ES | Futures | 2170.9 | 2173.32 | 2165.79 | 2166.06 | 14878.0 |
| 2015-12-18 03:00:00 | ES | Futures | 2166.06 | 2173.32 | 2162.57 | 2167.41 | 37068.0 |
| 2015-12-18 04:00:00 | ES | Futures | 2167.14 | 2171.71 | 2165.26 | 2170.63 | 19266.0 |
| 2015-12-18 05:00:00 | ES | Futures | 2170.36 | 2176.01 | 2167.68 | 2175.2 | 16836.0 |
| 2015-12-18 06:00:00 | ES | Futures | 2174.93 | 2174.93 | 2166.06 | 2167.14 | 18308.0 |
| 2015-12-18 07:00:00 | ES | Futures | 2166.87 | 2169.29 | 2162.57 | 2165.26 | 34590.0 |
| 2015-12-18 08:00:00 | ES | Futures | 2165.26 | 2173.59 | 2164.99 | 2173.05 | 43197.0 |
| 2015-12-18 09:00:00 | ES | Futures | 2172.78 | 2181.65 | 2167.14 | 2170.63 | 308437.0 |
| 2015-12-18 10:00:00 | ES | Futures | 2170.63 | 2172.24 | 2157.46 | 2165.26 | 334531.0 |
| 2015-12-18 11:00:00 | ES | Futures | 2165.26 | 2169.02 | 2159.08 | 2160.69 | 174667.0 |
| 2015-12-18 12:00:00 | ES | Futures | 2160.42 | 2163.38 | 2152.36 | 2154.24 | 160208.0 |
| 2015-12-18 13:00:00 | ES | Futures | 2154.51 | 2160.15 | 2153.17 | 2158.0 | 130436.0 |
| 2015-12-18 14:00:00 | ES | Futures | 2158.27 | 2165.26 | 2155.58 | 2156.12 | 173730.0 |
| 2015-12-18 15:00:00 | ES | Futures | 2156.39 | 2159.35 | 2142.95 | 2143.22 | 335926.0 |
| 2015-12-18 16:00:00 | ES | Futures | 2143.22 | 2149.13 | 2140.0 | 2144.03 | 153122.0 |
| 2015-12-18 00:00:00 | NQ | Futures | 5417.81 | 5420.48 | 5408.01 | 5415.14 | 1132.0 |
| 2015-12-18 01:00:00 | NQ | Futures | 5415.73 | 5423.15 | 5411.87 | 5419.29 | 674.0 |
| 2015-12-18 02:00:00 | NQ | Futures | 5419.29 | 5427.31 | 5408.31 | 5409.5 | 1998.0 |
| 2015-12-18 03:00:00 | NQ | Futures | 5409.79 | 5426.42 | 5400.88 | 5410.39 | 5672.0 |
| 2015-12-18 04:00:00 | NQ | Futures | 5410.09 | 5420.48 | 5402.07 | 5415.14 | 3807.0 |
| 2015-12-18 05:00:00 | NQ | Futures | 5414.84 | 5432.06 | 5407.71 | 5430.58 | 3153.0 |
| 2015-12-18 06:00:00 | NQ | Futures | 5430.28 | 5430.28 | 5411.28 | 5414.54 | 2777.0 |
| 2015-12-18 07:00:00 | NQ | Futures | 5414.54 | 5421.67 | 5407.42 | 5414.54 | 6591.0 |
| 2015-12-18 08:00:00 | NQ | Futures | 5413.95 | 5433.84 | 5413.06 | 5432.36 | 8145.0 |
| 2015-12-18 09:00:00 | NQ | Futures | 5432.66 | 5449.58 | 5416.32 | 5434.73 | 64584.0 |
| 2015-12-18 10:00:00 | NQ | Futures | 5435.03 | 5436.81 | 5390.19 | 5412.46 | 57838.0 |
| 2015-12-18 11:00:00 | NQ | Futures | 5412.17 | 5427.9 | 5399.99 | 5404.45 | 28220.0 |
| 2015-12-18 12:00:00 | NQ | Futures | 5404.15 | 5410.98 | 5372.97 | 5374.16 | 26911.0 |
| 2015-12-18 13:00:00 | NQ | Futures | 5373.86 | 5394.95 | 5373.57 | 5390.19 | 20769.0 |
| 2015-12-18 14:00:00 | NQ | Futures | 5390.49 | 5404.15 | 5377.43 | 5378.61 | 26826.0 |
| 2015-12-18 15:00:00 | NQ | Futures | 5378.91 | 5387.82 | 5349.52 | 5350.11 | 46175.0 |
| 2015-12-18 16:00:00 | NQ | Futures | 5350.11 | 5364.96 | 5347.44 | 5356.64 | 16712.0 |
| 2015-12-18 00:00:00 | YM | Futures | 18426.1 | 18436.8 | 18398.4 | 18414.4 | 2952.0 |
| 2015-12-18 01:00:00 | YM | Futures | 18415.5 | 18436.8 | 18404.8 | 18419.7 | 1463.0 |
| 2015-12-18 02:00:00 | YM | Futures | 18418.7 | 18443.2 | 18377.2 | 18379.3 | 2906.0 |
| 2015-12-18 03:00:00 | YM | Futures | 18378.2 | 18437.8 | 18349.5 | 18396.3 | 6531.0 |
| 2015-12-18 04:00:00 | YM | Futures | 18396.3 | 18435.7 | 18382.5 | 18420.8 | 3457.0 |
| 2015-12-18 05:00:00 | YM | Futures | 18418.7 | 18458.1 | 18397.4 | 18451.7 | 2546.0 |
| 2015-12-18 06:00:00 | YM | Futures | 18449.5 | 18449.5 | 18379.3 | 18386.7 | 2153.0 |
| 2015-12-18 07:00:00 | YM | Futures | 18386.7 | 18399.5 | 18353.7 | 18379.3 | 4235.0 |
| 2015-12-18 08:00:00 | YM | Futures | 18378.2 | 18446.3 | 18377.2 | 18418.7 | 5640.0 |
| 2015-12-18 09:00:00 | YM | Futures | 18419.7 | 18491.1 | 18359.1 | 18387.8 | 34364.0 |
| 2015-12-18 10:00:00 | YM | Futures | 18388.9 | 18401.6 | 18271.8 | 18321.8 | 37290.0 |
| 2015-12-18 11:00:00 | YM | Futures | 18320.7 | 18346.3 | 18269.6 | 18279.2 | 17147.0 |
| 2015-12-18 12:00:00 | YM | Futures | 18279.2 | 18302.6 | 18206.8 | 18226.0 | 16985.0 |
| 2015-12-18 13:00:00 | YM | Futures | 18226.0 | 18270.7 | 18206.8 | 18249.4 | 12883.0 |
| 2015-12-18 14:00:00 | YM | Futures | 18251.5 | 18298.4 | 18213.2 | 18220.7 | 16276.0 |
| 2015-12-18 15:00:00 | YM | Futures | 18221.7 | 18250.5 | 18125.9 | 18128.1 | 29151.0 |
> showing 50 of 1,314 rows — these rows as CSV