PREVIEW / futures_1hour / 2015-12-11
file: by_date/futures_1hour/2015/2015-12-11.parquet size: 44 KB rows: 1,272
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-11 00:00:00 | ES | Futures | 2196.54 | 2199.21 | 2196.27 | 2197.87 | 1938.0 |
| 2015-12-11 01:00:00 | ES | Futures | 2197.87 | 2198.68 | 2196.54 | 2198.14 | 1678.0 |
| 2015-12-11 02:00:00 | ES | Futures | 2198.14 | 2198.68 | 2195.2 | 2196.27 | 3337.0 |
| 2015-12-11 03:00:00 | ES | Futures | 2196.0 | 2199.75 | 2191.45 | 2191.45 | 14867.0 |
| 2015-12-11 04:00:00 | ES | Futures | 2191.45 | 2196.0 | 2189.04 | 2194.93 | 14095.0 |
| 2015-12-11 05:00:00 | ES | Futures | 2194.66 | 2195.2 | 2177.81 | 2180.21 | 31942.0 |
| 2015-12-11 06:00:00 | ES | Futures | 2180.21 | 2182.09 | 2175.4 | 2177.81 | 24275.0 |
| 2015-12-11 07:00:00 | ES | Futures | 2177.81 | 2181.28 | 2171.65 | 2173.26 | 26269.0 |
| 2015-12-11 08:00:00 | ES | Futures | 2172.99 | 2180.75 | 2172.72 | 2178.34 | 34634.0 |
| 2015-12-11 09:00:00 | ES | Futures | 2178.61 | 2178.61 | 2161.75 | 2164.69 | 154849.0 |
| 2015-12-11 10:00:00 | ES | Futures | 2164.96 | 2176.74 | 2162.82 | 2164.96 | 133395.0 |
| 2015-12-11 11:00:00 | ES | Futures | 2164.96 | 2170.58 | 2160.15 | 2162.55 | 104221.0 |
| 2015-12-11 12:00:00 | ES | Futures | 2162.82 | 2163.89 | 2153.72 | 2158.27 | 110519.0 |
| 2015-12-11 13:00:00 | ES | Futures | 2158.54 | 2163.36 | 2155.33 | 2159.34 | 70122.0 |
| 2015-12-11 14:00:00 | ES | Futures | 2159.34 | 2165.77 | 2158.54 | 2158.81 | 73895.0 |
| 2015-12-11 15:00:00 | ES | Futures | 2158.81 | 2161.22 | 2148.37 | 2152.12 | 142518.0 |
| 2015-12-11 16:00:00 | ES | Futures | 2151.85 | 2154.79 | 2145.96 | 2148.11 | 56769.0 |
| 2015-12-11 00:00:00 | NQ | Futures | 5515.33 | 5522.44 | 5515.33 | 5518.88 | 179.0 |
| 2015-12-11 01:00:00 | NQ | Futures | 5519.18 | 5520.96 | 5515.62 | 5518.88 | 197.0 |
| 2015-12-11 02:00:00 | NQ | Futures | 5518.88 | 5520.37 | 5511.47 | 5514.44 | 433.0 |
| 2015-12-11 03:00:00 | NQ | Futures | 5514.14 | 5522.74 | 5501.39 | 5502.28 | 2312.0 |
| 2015-12-11 04:00:00 | NQ | Futures | 5501.69 | 5509.99 | 5494.28 | 5507.32 | 2439.0 |
| 2015-12-11 05:00:00 | NQ | Futures | 5507.91 | 5509.1 | 5461.96 | 5469.37 | 4282.0 |
| 2015-12-11 06:00:00 | NQ | Futures | 5468.18 | 5471.74 | 5456.03 | 5465.22 | 3765.0 |
| 2015-12-11 07:00:00 | NQ | Futures | 5466.11 | 5475.6 | 5445.06 | 5450.39 | 4311.0 |
| 2015-12-11 08:00:00 | NQ | Futures | 5450.39 | 5472.04 | 5448.32 | 5466.11 | 5494.0 |
| 2015-12-11 09:00:00 | NQ | Futures | 5466.4 | 5466.4 | 5423.12 | 5431.42 | 27218.0 |
| 2015-12-11 10:00:00 | NQ | Futures | 5430.83 | 5455.14 | 5420.75 | 5425.19 | 21062.0 |
| 2015-12-11 11:00:00 | NQ | Futures | 5425.49 | 5434.38 | 5407.11 | 5409.48 | 17071.0 |
| 2015-12-11 12:00:00 | NQ | Futures | 5409.78 | 5413.33 | 5386.06 | 5399.4 | 14840.0 |
| 2015-12-11 13:00:00 | NQ | Futures | 5399.4 | 5414.22 | 5393.17 | 5408.29 | 8949.0 |
| 2015-12-11 14:00:00 | NQ | Futures | 5408.29 | 5422.23 | 5400.88 | 5401.18 | 9148.0 |
| 2015-12-11 15:00:00 | NQ | Futures | 5401.47 | 5408.59 | 5375.98 | 5380.13 | 20630.0 |
| 2015-12-11 16:00:00 | NQ | Futures | 5380.13 | 5389.32 | 5369.45 | 5378.94 | 5668.0 |
| 2015-12-11 00:00:00 | YM | Futures | 18640.1 | 18660.3 | 18635.8 | 18652.9 | 342.0 |
| 2015-12-11 01:00:00 | YM | Futures | 18652.9 | 18657.1 | 18639.0 | 18648.6 | 184.0 |
| 2015-12-11 02:00:00 | YM | Futures | 18649.7 | 18656.0 | 18627.3 | 18636.9 | 535.0 |
| 2015-12-11 03:00:00 | YM | Futures | 18636.9 | 18661.4 | 18586.9 | 18590.0 | 2855.0 |
| 2015-12-11 04:00:00 | YM | Futures | 18589.0 | 18618.8 | 18566.6 | 18609.2 | 1907.0 |
| 2015-12-11 05:00:00 | YM | Futures | 18608.1 | 18613.5 | 18467.6 | 18485.7 | 3438.0 |
| 2015-12-11 06:00:00 | YM | Futures | 18485.7 | 18497.4 | 18442.1 | 18459.1 | 4497.0 |
| 2015-12-11 07:00:00 | YM | Futures | 18461.2 | 18484.7 | 18396.3 | 18405.9 | 4388.0 |
| 2015-12-11 08:00:00 | YM | Futures | 18408.0 | 18462.3 | 18402.7 | 18441.0 | 4869.0 |
| 2015-12-11 09:00:00 | YM | Futures | 18441.0 | 18442.1 | 18310.1 | 18341.0 | 28634.0 |
| 2015-12-11 10:00:00 | YM | Futures | 18338.8 | 18455.9 | 18320.7 | 18364.4 | 24203.0 |
| 2015-12-11 11:00:00 | YM | Futures | 18364.4 | 18417.6 | 18327.1 | 18344.2 | 14995.0 |
| 2015-12-11 12:00:00 | YM | Futures | 18346.3 | 18356.9 | 18283.5 | 18330.3 | 16815.0 |
| 2015-12-11 13:00:00 | YM | Futures | 18330.3 | 18368.6 | 18302.6 | 18329.3 | 9496.0 |
| 2015-12-11 14:00:00 | YM | Futures | 18328.2 | 18378.2 | 18323.9 | 18330.3 | 10284.0 |
| 2015-12-11 15:00:00 | YM | Futures | 18332.4 | 18349.5 | 18251.5 | 18284.5 | 19353.0 |
> showing 50 of 1,272 rows — these rows as CSV