PREVIEW / futures_1hour / 2015-03-11
file: by_date/futures_1hour/2015/2015-03-11.parquet size: 48 KB rows: 1,457
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-03-11 00:00:00 | ES | Futures | 2156.53 | 2156.79 | 2155.74 | 2156.79 | 2162.0 |
| 2015-03-11 01:00:00 | ES | Futures | 2156.79 | 2157.06 | 2154.69 | 2154.95 | 2721.0 |
| 2015-03-11 02:00:00 | ES | Futures | 2154.69 | 2155.21 | 2153.11 | 2154.16 | 3385.0 |
| 2015-03-11 03:00:00 | ES | Futures | 2154.16 | 2155.74 | 2152.85 | 2153.37 | 12820.0 |
| 2015-03-11 04:00:00 | ES | Futures | 2153.37 | 2158.37 | 2151.0 | 2157.85 | 41858.0 |
| 2015-03-11 05:00:00 | ES | Futures | 2157.85 | 2159.69 | 2156.53 | 2158.63 | 19660.0 |
| 2015-03-11 06:00:00 | ES | Futures | 2158.63 | 2160.21 | 2157.58 | 2159.16 | 19914.0 |
| 2015-03-11 07:00:00 | ES | Futures | 2159.16 | 2159.69 | 2154.42 | 2155.74 | 26554.0 |
| 2015-03-11 08:00:00 | ES | Futures | 2156.0 | 2158.9 | 2155.48 | 2156.53 | 27409.0 |
| 2015-03-11 09:00:00 | ES | Futures | 2156.53 | 2157.06 | 2152.06 | 2154.95 | 211635.0 |
| 2015-03-11 10:00:00 | ES | Futures | 2154.69 | 2157.32 | 2146.79 | 2149.69 | 269012.0 |
| 2015-03-11 11:00:00 | ES | Futures | 2149.69 | 2155.48 | 2148.9 | 2153.9 | 157790.0 |
| 2015-03-11 12:00:00 | ES | Futures | 2153.9 | 2156.0 | 2150.74 | 2154.16 | 115376.0 |
| 2015-03-11 13:00:00 | ES | Futures | 2153.9 | 2155.74 | 2146.79 | 2149.95 | 123437.0 |
| 2015-03-11 14:00:00 | ES | Futures | 2149.95 | 2154.69 | 2149.16 | 2154.16 | 115959.0 |
| 2015-03-11 15:00:00 | ES | Futures | 2154.16 | 2154.16 | 2145.48 | 2147.06 | 205170.0 |
| 2015-03-11 16:00:00 | ES | Futures | 2146.79 | 2150.48 | 2145.48 | 2149.42 | 80628.0 |
| 2015-03-11 17:00:00 | ES | Futures | 2149.69 | 2150.21 | 2148.63 | 2148.63 | 2288.0 |
| 2015-03-11 18:00:00 | ES | Futures | 2149.42 | 2150.21 | 2146.0 | 2147.58 | 6312.0 |
| 2015-03-11 19:00:00 | ES | Futures | 2147.85 | 2148.11 | 2146.53 | 2147.06 | 1925.0 |
| 2015-03-11 20:00:00 | ES | Futures | 2147.32 | 2147.58 | 2145.48 | 2147.06 | 5463.0 |
| 2015-03-11 21:00:00 | ES | Futures | 2147.06 | 2149.42 | 2147.06 | 2149.16 | 3494.0 |
| 2015-03-11 22:00:00 | ES | Futures | 2149.16 | 2150.21 | 2148.9 | 2149.95 | 3004.0 |
| 2015-03-11 23:00:00 | ES | Futures | 2149.95 | 2151.79 | 2149.42 | 2151.53 | 5580.0 |
| 2015-03-11 00:00:00 | NQ | Futures | 5100.78 | 5103.13 | 5099.9 | 5101.07 | 552.0 |
| 2015-03-11 01:00:00 | NQ | Futures | 5101.37 | 5101.95 | 5097.26 | 5098.14 | 431.0 |
| 2015-03-11 02:00:00 | NQ | Futures | 5097.55 | 5097.84 | 5094.03 | 5096.37 | 601.0 |
| 2015-03-11 03:00:00 | NQ | Futures | 5096.08 | 5100.19 | 5092.85 | 5093.73 | 1624.0 |
| 2015-03-11 04:00:00 | NQ | Futures | 5093.73 | 5103.72 | 5091.09 | 5103.72 | 5216.0 |
| 2015-03-11 05:00:00 | NQ | Futures | 5103.72 | 5106.65 | 5100.19 | 5104.89 | 2512.0 |
| 2015-03-11 06:00:00 | NQ | Futures | 5105.19 | 5107.24 | 5102.54 | 5104.89 | 2827.0 |
| 2015-03-11 07:00:00 | NQ | Futures | 5104.89 | 5106.07 | 5096.67 | 5099.02 | 3325.0 |
| 2015-03-11 08:00:00 | NQ | Futures | 5099.31 | 5105.19 | 5098.14 | 5099.61 | 4212.0 |
| 2015-03-11 09:00:00 | NQ | Futures | 5099.31 | 5100.49 | 5078.75 | 5094.32 | 40270.0 |
| 2015-03-11 10:00:00 | NQ | Futures | 5094.03 | 5101.95 | 5070.24 | 5076.99 | 43693.0 |
| 2015-03-11 11:00:00 | NQ | Futures | 5076.7 | 5094.61 | 5075.52 | 5090.21 | 29193.0 |
| 2015-03-11 12:00:00 | NQ | Futures | 5090.5 | 5093.44 | 5078.46 | 5084.33 | 21387.0 |
| 2015-03-11 13:00:00 | NQ | Futures | 5084.04 | 5085.51 | 5063.78 | 5070.53 | 21724.0 |
| 2015-03-11 14:00:00 | NQ | Futures | 5070.24 | 5082.57 | 5068.47 | 5078.75 | 23479.0 |
| 2015-03-11 15:00:00 | NQ | Futures | 5078.46 | 5079.05 | 5056.73 | 5057.9 | 32529.0 |
| 2015-03-11 16:00:00 | NQ | Futures | 5057.9 | 5068.18 | 5056.43 | 5065.54 | 7328.0 |
| 2015-03-11 17:00:00 | NQ | Futures | 5065.54 | 5067.01 | 5064.95 | 5065.24 | 252.0 |
| 2015-03-11 18:00:00 | NQ | Futures | 5066.12 | 5069.36 | 5058.49 | 5062.6 | 970.0 |
| 2015-03-11 19:00:00 | NQ | Futures | 5062.89 | 5063.48 | 5060.54 | 5062.6 | 209.0 |
| 2015-03-11 20:00:00 | NQ | Futures | 5062.31 | 5063.78 | 5058.78 | 5062.89 | 679.0 |
| 2015-03-11 21:00:00 | NQ | Futures | 5063.19 | 5068.47 | 5063.19 | 5067.89 | 405.0 |
| 2015-03-11 22:00:00 | NQ | Futures | 5068.18 | 5070.82 | 5066.71 | 5068.77 | 522.0 |
| 2015-03-11 23:00:00 | NQ | Futures | 5068.77 | 5072.29 | 5067.89 | 5071.7 | 662.0 |
| 2015-03-11 00:00:00 | YM | Futures | 18493.2 | 18498.5 | 18493.2 | 18497.4 | 39.0 |
| 2015-03-11 01:00:00 | YM | Futures | 18499.5 | 18500.6 | 18482.7 | 18488.0 | 30.0 |
> showing 50 of 1,457 rows — these rows as CSV