PREVIEW / futures_1hour / 2015-02-27
file: by_date/futures_1hour/2015/2015-02-27.parquet size: 43 KB rows: 1,293
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-27 00:00:00 | ES | Futures | 2218.37 | 2219.69 | 2217.84 | 2218.11 | 3620.0 |
| 2015-02-27 01:00:00 | ES | Futures | 2218.11 | 2218.11 | 2217.05 | 2217.84 | 1802.0 |
| 2015-02-27 02:00:00 | ES | Futures | 2218.11 | 2218.37 | 2216.79 | 2217.84 | 3767.0 |
| 2015-02-27 03:00:00 | ES | Futures | 2217.84 | 2219.69 | 2217.32 | 2217.32 | 11642.0 |
| 2015-02-27 04:00:00 | ES | Futures | 2217.58 | 2218.11 | 2216.0 | 2217.05 | 9699.0 |
| 2015-02-27 05:00:00 | ES | Futures | 2217.05 | 2218.11 | 2216.0 | 2216.79 | 8283.0 |
| 2015-02-27 06:00:00 | ES | Futures | 2216.79 | 2218.63 | 2216.79 | 2218.11 | 6145.0 |
| 2015-02-27 07:00:00 | ES | Futures | 2218.11 | 2218.63 | 2216.79 | 2218.11 | 8482.0 |
| 2015-02-27 08:00:00 | ES | Futures | 2218.11 | 2219.16 | 2216.79 | 2217.84 | 15475.0 |
| 2015-02-27 09:00:00 | ES | Futures | 2217.84 | 2220.48 | 2213.9 | 2216.26 | 150102.0 |
| 2015-02-27 10:00:00 | ES | Futures | 2216.26 | 2221.79 | 2216.0 | 2221.26 | 179011.0 |
| 2015-02-27 11:00:00 | ES | Futures | 2221.53 | 2221.53 | 2217.58 | 2219.95 | 112544.0 |
| 2015-02-27 12:00:00 | ES | Futures | 2219.95 | 2222.05 | 2218.9 | 2219.69 | 62752.0 |
| 2015-02-27 13:00:00 | ES | Futures | 2219.69 | 2220.21 | 2216.79 | 2218.63 | 84612.0 |
| 2015-02-27 14:00:00 | ES | Futures | 2218.9 | 2219.42 | 2213.37 | 2214.95 | 108380.0 |
| 2015-02-27 15:00:00 | ES | Futures | 2214.95 | 2216.53 | 2212.05 | 2212.58 | 293208.0 |
| 2015-02-27 16:00:00 | ES | Futures | 2212.32 | 2216.53 | 2211.27 | 2216.0 | 115932.0 |
| 2015-02-27 17:00:00 | ES | Futures | 2216.0 | 2216.26 | 2215.21 | 2215.21 | 1815.0 |
| 2015-02-27 00:00:00 | NQ | Futures | 5237.05 | 5239.99 | 5236.76 | 5237.35 | 391.0 |
| 2015-02-27 01:00:00 | NQ | Futures | 5236.76 | 5237.35 | 5235.58 | 5236.76 | 354.0 |
| 2015-02-27 02:00:00 | NQ | Futures | 5236.76 | 5237.35 | 5234.7 | 5235.88 | 566.0 |
| 2015-02-27 03:00:00 | NQ | Futures | 5235.88 | 5238.23 | 5233.82 | 5234.11 | 2080.0 |
| 2015-02-27 04:00:00 | NQ | Futures | 5234.11 | 5234.7 | 5229.42 | 5232.06 | 1635.0 |
| 2015-02-27 05:00:00 | NQ | Futures | 5232.35 | 5236.17 | 5231.47 | 5233.53 | 1352.0 |
| 2015-02-27 06:00:00 | NQ | Futures | 5233.53 | 5237.93 | 5233.53 | 5236.76 | 1026.0 |
| 2015-02-27 07:00:00 | NQ | Futures | 5237.35 | 5237.93 | 5234.41 | 5237.05 | 915.0 |
| 2015-02-27 08:00:00 | NQ | Futures | 5237.05 | 5238.23 | 5233.53 | 5234.7 | 2631.0 |
| 2015-02-27 09:00:00 | NQ | Futures | 5235.0 | 5242.63 | 5223.54 | 5235.58 | 30050.0 |
| 2015-02-27 10:00:00 | NQ | Futures | 5236.17 | 5242.04 | 5228.24 | 5240.58 | 27948.0 |
| 2015-02-27 11:00:00 | NQ | Futures | 5240.58 | 5240.87 | 5230.59 | 5235.58 | 14831.0 |
| 2015-02-27 12:00:00 | NQ | Futures | 5235.88 | 5238.23 | 5231.47 | 5231.77 | 9607.0 |
| 2015-02-27 13:00:00 | NQ | Futures | 5231.77 | 5233.82 | 5222.37 | 5228.24 | 12181.0 |
| 2015-02-27 14:00:00 | NQ | Futures | 5228.53 | 5230.3 | 5210.91 | 5216.79 | 20663.0 |
| 2015-02-27 15:00:00 | NQ | Futures | 5216.79 | 5222.07 | 5210.03 | 5217.96 | 36270.0 |
| 2015-02-27 16:00:00 | NQ | Futures | 5217.96 | 5225.3 | 5217.08 | 5223.54 | 7899.0 |
| 2015-02-27 17:00:00 | NQ | Futures | 5223.25 | 5224.42 | 5223.25 | 5223.25 | 116.0 |
| 2015-02-27 00:00:00 | YM | Futures | 18982.9 | 18996.5 | 18982.9 | 18984.0 | 704.0 |
| 2015-02-27 01:00:00 | YM | Futures | 18984.0 | 18984.0 | 18976.6 | 18980.8 | 183.0 |
| 2015-02-27 02:00:00 | YM | Futures | 18980.8 | 18990.2 | 18977.7 | 18986.0 | 552.0 |
| 2015-02-27 03:00:00 | YM | Futures | 18986.0 | 19000.7 | 18986.0 | 18989.2 | 2087.0 |
| 2015-02-27 04:00:00 | YM | Futures | 18989.2 | 18993.3 | 18975.6 | 18987.1 | 1562.0 |
| 2015-02-27 05:00:00 | YM | Futures | 18987.1 | 18993.3 | 18977.7 | 18984.0 | 1329.0 |
| 2015-02-27 06:00:00 | YM | Futures | 18984.0 | 18995.4 | 18982.9 | 18992.3 | 786.0 |
| 2015-02-27 07:00:00 | YM | Futures | 18993.3 | 18997.5 | 18982.9 | 18992.3 | 1071.0 |
| 2015-02-27 08:00:00 | YM | Futures | 18992.3 | 18997.5 | 18982.9 | 18988.1 | 2173.0 |
| 2015-02-27 09:00:00 | YM | Futures | 18988.1 | 18997.5 | 18946.4 | 18962.0 | 13076.0 |
| 2015-02-27 10:00:00 | YM | Futures | 18962.0 | 18993.3 | 18956.8 | 18989.2 | 12888.0 |
| 2015-02-27 11:00:00 | YM | Futures | 18988.1 | 18990.2 | 18956.8 | 18977.7 | 7624.0 |
| 2015-02-27 12:00:00 | YM | Futures | 18977.7 | 18988.1 | 18967.3 | 18972.5 | 3984.0 |
| 2015-02-27 13:00:00 | YM | Futures | 18972.5 | 18977.7 | 18955.8 | 18969.3 | 5719.0 |
> showing 50 of 1,293 rows — these rows as CSV