PREVIEW / futures_1hour / 2015-03-15
file: by_date/futures_1hour/2015/2015-03-15.parquet size: 14 KB rows: 267
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-15 18:00:00 | ES | Futures | 2158.63 | 2159.43 | 2154.94 | 2155.73 | 4104.0 |
| 2015-03-15 19:00:00 | ES | Futures | 2155.73 | 2156.26 | 2153.88 | 2154.14 | 3463.0 |
| 2015-03-15 20:00:00 | ES | Futures | 2154.14 | 2154.94 | 2152.3 | 2154.41 | 5678.0 |
| 2015-03-15 21:00:00 | ES | Futures | 2154.41 | 2157.31 | 2154.41 | 2156.26 | 5283.0 |
| 2015-03-15 22:00:00 | ES | Futures | 2156.26 | 2158.63 | 2156.26 | 2158.11 | 2522.0 |
| 2015-03-15 23:00:00 | ES | Futures | 2158.11 | 2160.22 | 2157.84 | 2159.96 | 2009.0 |
| 2015-03-15 18:00:00 | NQ | Futures | 5064.95 | 5067.6 | 5054.95 | 5055.25 | 743.0 |
| 2015-03-15 19:00:00 | NQ | Futures | 5056.42 | 5056.42 | 5052.31 | 5053.19 | 526.0 |
| 2015-03-15 20:00:00 | NQ | Futures | 5053.48 | 5055.54 | 5049.36 | 5054.36 | 967.0 |
| 2015-03-15 21:00:00 | NQ | Futures | 5054.66 | 5060.25 | 5054.07 | 5057.3 | 740.0 |
| 2015-03-15 22:00:00 | NQ | Futures | 5057.01 | 5062.01 | 5056.42 | 5061.72 | 365.0 |
| 2015-03-15 23:00:00 | NQ | Futures | 5062.01 | 5066.42 | 5061.42 | 5066.13 | 301.0 |
| 2015-03-15 18:00:00 | YM | Futures | 18513.2 | 18532.0 | 18491.1 | 18492.2 | 1258.0 |
| 2015-03-15 19:00:00 | YM | Futures | 18492.2 | 18498.5 | 18481.7 | 18482.7 | 395.0 |
| 2015-03-15 20:00:00 | YM | Futures | 18483.8 | 18492.2 | 18468.1 | 18489.0 | 747.0 |
| 2015-03-15 21:00:00 | YM | Futures | 18490.1 | 18511.1 | 18489.0 | 18503.7 | 820.0 |
| 2015-03-15 22:00:00 | YM | Futures | 18501.6 | 18519.5 | 18501.6 | 18517.4 | 442.0 |
| 2015-03-15 23:00:00 | YM | Futures | 18517.4 | 18528.9 | 18514.2 | 18528.9 | 441.0 |
| 2015-03-15 18:00:00 | CL | Futures | 74.33 | 74.6 | 72.38 | 72.76 | 2464.0 |
| 2015-03-15 19:00:00 | CL | Futures | 72.79 | 72.99 | 72.52 | 72.82 | 978.0 |
| 2015-03-15 20:00:00 | CL | Futures | 72.82 | 73.42 | 72.82 | 73.29 | 1715.0 |
| 2015-03-15 21:00:00 | CL | Futures | 73.32 | 73.83 | 73.31 | 73.78 | 947.0 |
| 2015-03-15 22:00:00 | CL | Futures | 73.78 | 73.99 | 73.75 | 73.8 | 984.0 |
| 2015-03-15 23:00:00 | CL | Futures | 73.83 | 73.84 | 73.75 | 73.77 | 358.0 |
| 2015-03-15 18:00:00 | GC | Futures | 1582.5 | 1583.0 | 1578.4 | 1578.6 | 1136.0 |
| 2015-03-15 19:00:00 | GC | Futures | 1578.8 | 1580.5 | 1578.4 | 1580.0 | 809.0 |
| 2015-03-15 20:00:00 | GC | Futures | 1579.9 | 1580.4 | 1577.3 | 1577.9 | 1316.0 |
| 2015-03-15 21:00:00 | GC | Futures | 1578.1 | 1584.1 | 1575.4 | 1583.3 | 4641.0 |
| 2015-03-15 22:00:00 | GC | Futures | 1583.4 | 1584.0 | 1581.5 | 1582.3 | 1737.0 |
| 2015-03-15 23:00:00 | GC | Futures | 1582.2 | 1583.8 | 1582.2 | 1582.3 | 1209.0 |
| 2015-03-15 18:00:00 | ZN | Futures | 121.453895 | 121.528562 | 121.424028 | 121.513629 | 2724.0 |
| 2015-03-15 19:00:00 | ZN | Futures | 121.513629 | 121.543495 | 121.483762 | 121.528562 | 1706.0 |
| 2015-03-15 20:00:00 | ZN | Futures | 121.528562 | 121.558429 | 121.528562 | 121.528562 | 2471.0 |
| 2015-03-15 21:00:00 | ZN | Futures | 121.528562 | 121.588296 | 121.513629 | 121.573362 | 4149.0 |
| 2015-03-15 22:00:00 | ZN | Futures | 121.588296 | 121.618163 | 121.558429 | 121.573362 | 3564.0 |
| 2015-03-15 23:00:00 | ZN | Futures | 121.573362 | 121.603229 | 121.558429 | 121.588296 | 1326.0 |
> showing 36 of 267 rows — these rows as CSV