PREVIEW / futures_1hour / 2015-02-16
file: by_date/futures_1hour/2015/2015-02-16.parquet size: 36 KB rows: 1,082
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-02-16 00:00:00 | ES | Futures | 2200.74 | 2201.53 | 2200.48 | 2201.0 | 969.0 |
| 2015-02-16 01:00:00 | ES | Futures | 2201.27 | 2201.27 | 2200.21 | 2200.48 | 1017.0 |
| 2015-02-16 02:00:00 | ES | Futures | 2200.21 | 2200.48 | 2197.84 | 2199.42 | 4225.0 |
| 2015-02-16 03:00:00 | ES | Futures | 2199.42 | 2200.48 | 2197.58 | 2199.42 | 7151.0 |
| 2015-02-16 04:00:00 | ES | Futures | 2199.42 | 2200.74 | 2199.16 | 2200.48 | 3872.0 |
| 2015-02-16 05:00:00 | ES | Futures | 2200.48 | 2200.48 | 2199.16 | 2199.69 | 2835.0 |
| 2015-02-16 06:00:00 | ES | Futures | 2199.69 | 2201.0 | 2199.16 | 2200.48 | 2535.0 |
| 2015-02-16 07:00:00 | ES | Futures | 2200.21 | 2201.53 | 2199.95 | 2201.0 | 2497.0 |
| 2015-02-16 08:00:00 | ES | Futures | 2201.0 | 2201.79 | 2199.42 | 2199.95 | 7822.0 |
| 2015-02-16 09:00:00 | ES | Futures | 2200.21 | 2201.0 | 2198.9 | 2200.74 | 5327.0 |
| 2015-02-16 10:00:00 | ES | Futures | 2200.48 | 2202.32 | 2199.42 | 2202.05 | 7270.0 |
| 2015-02-16 11:00:00 | ES | Futures | 2202.32 | 2203.9 | 2196.79 | 2197.58 | 19096.0 |
| 2015-02-16 12:00:00 | ES | Futures | 2197.58 | 2198.63 | 2193.11 | 2196.53 | 24153.0 |
| 2015-02-16 18:00:00 | ES | Futures | 2192.84 | 2194.95 | 2191.0 | 2193.9 | 9462.0 |
| 2015-02-16 19:00:00 | ES | Futures | 2193.63 | 2194.16 | 2192.05 | 2193.11 | 4271.0 |
| 2015-02-16 20:00:00 | ES | Futures | 2193.11 | 2193.9 | 2192.05 | 2193.9 | 3149.0 |
| 2015-02-16 21:00:00 | ES | Futures | 2193.63 | 2194.95 | 2193.37 | 2193.9 | 1740.0 |
| 2015-02-16 22:00:00 | ES | Futures | 2193.63 | 2195.74 | 2193.37 | 2195.21 | 1845.0 |
| 2015-02-16 23:00:00 | ES | Futures | 2195.48 | 2196.0 | 2194.69 | 2195.48 | 1623.0 |
| 2015-02-16 00:00:00 | NQ | Futures | 5142.48 | 5145.13 | 5142.48 | 5143.07 | 224.0 |
| 2015-02-16 01:00:00 | NQ | Futures | 5143.07 | 5143.95 | 5140.13 | 5140.72 | 170.0 |
| 2015-02-16 02:00:00 | NQ | Futures | 5140.72 | 5141.6 | 5136.9 | 5138.96 | 647.0 |
| 2015-02-16 03:00:00 | NQ | Futures | 5139.25 | 5143.66 | 5137.49 | 5138.96 | 1347.0 |
| 2015-02-16 04:00:00 | NQ | Futures | 5138.96 | 5142.78 | 5137.78 | 5142.48 | 575.0 |
| 2015-02-16 05:00:00 | NQ | Futures | 5142.19 | 5143.66 | 5140.72 | 5141.31 | 577.0 |
| 2015-02-16 06:00:00 | NQ | Futures | 5141.6 | 5144.83 | 5141.02 | 5143.36 | 502.0 |
| 2015-02-16 07:00:00 | NQ | Futures | 5143.07 | 5145.71 | 5142.48 | 5144.83 | 366.0 |
| 2015-02-16 08:00:00 | NQ | Futures | 5145.13 | 5147.48 | 5143.07 | 5145.71 | 1718.0 |
| 2015-02-16 09:00:00 | NQ | Futures | 5146.6 | 5147.77 | 5143.66 | 5146.89 | 1458.0 |
| 2015-02-16 10:00:00 | NQ | Futures | 5146.89 | 5152.76 | 5144.54 | 5152.47 | 2188.0 |
| 2015-02-16 11:00:00 | NQ | Futures | 5152.47 | 5155.41 | 5139.55 | 5142.48 | 3712.0 |
| 2015-02-16 12:00:00 | NQ | Futures | 5142.48 | 5143.07 | 5132.79 | 5138.96 | 4529.0 |
| 2015-02-16 18:00:00 | NQ | Futures | 5133.67 | 5137.49 | 5127.21 | 5135.14 | 1812.0 |
| 2015-02-16 19:00:00 | NQ | Futures | 5135.14 | 5135.44 | 5131.03 | 5132.79 | 694.0 |
| 2015-02-16 20:00:00 | NQ | Futures | 5133.09 | 5134.85 | 5130.74 | 5134.85 | 496.0 |
| 2015-02-16 21:00:00 | NQ | Futures | 5134.55 | 5138.08 | 5134.26 | 5135.14 | 414.0 |
| 2015-02-16 22:00:00 | NQ | Futures | 5135.14 | 5139.84 | 5134.55 | 5138.08 | 479.0 |
| 2015-02-16 23:00:00 | NQ | Futures | 5138.37 | 5139.55 | 5136.61 | 5137.49 | 207.0 |
| 2015-02-16 00:00:00 | YM | Futures | 18764.7 | 18771.0 | 18763.7 | 18765.8 | 223.0 |
| 2015-02-16 01:00:00 | YM | Futures | 18765.8 | 18767.9 | 18759.5 | 18761.6 | 344.0 |
| 2015-02-16 02:00:00 | YM | Futures | 18762.7 | 18762.7 | 18744.9 | 18751.2 | 919.0 |
| 2015-02-16 03:00:00 | YM | Futures | 18751.2 | 18762.7 | 18737.6 | 18753.3 | 2446.0 |
| 2015-02-16 04:00:00 | YM | Futures | 18753.3 | 18761.6 | 18750.1 | 18761.6 | 1045.0 |
| 2015-02-16 05:00:00 | YM | Futures | 18761.6 | 18761.6 | 18751.2 | 18753.3 | 595.0 |
| 2015-02-16 06:00:00 | YM | Futures | 18753.3 | 18763.7 | 18750.1 | 18759.5 | 537.0 |
| 2015-02-16 07:00:00 | YM | Futures | 18758.5 | 18766.8 | 18756.4 | 18761.6 | 494.0 |
| 2015-02-16 08:00:00 | YM | Futures | 18762.7 | 18772.0 | 18756.4 | 18759.5 | 1877.0 |
| 2015-02-16 09:00:00 | YM | Futures | 18759.5 | 18764.7 | 18753.3 | 18761.6 | 1136.0 |
| 2015-02-16 10:00:00 | YM | Futures | 18761.6 | 18779.4 | 18750.1 | 18777.3 | 1428.0 |
| 2015-02-16 11:00:00 | YM | Futures | 18776.2 | 18790.8 | 18731.3 | 18737.6 | 3421.0 |
> showing 50 of 1,082 rows — these rows as CSV