PREVIEW / futures_1hour / 2014-11-23
file: by_date/futures_1hour/2014/2014-11-23.parquet size: 13 KB rows: 262
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 |
|---|---|---|---|---|---|---|---|
| 2014-11-23 18:00:00 | ES | Futures | 2160.97 | 2163.06 | 2160.18 | 2160.71 | 7510.0 |
| 2014-11-23 19:00:00 | ES | Futures | 2160.71 | 2161.23 | 2159.92 | 2160.18 | 3173.0 |
| 2014-11-23 20:00:00 | ES | Futures | 2160.18 | 2160.71 | 2159.4 | 2159.66 | 2976.0 |
| 2014-11-23 21:00:00 | ES | Futures | 2159.66 | 2161.75 | 2159.66 | 2160.97 | 2173.0 |
| 2014-11-23 22:00:00 | ES | Futures | 2160.97 | 2162.02 | 2160.18 | 2161.49 | 2557.0 |
| 2014-11-23 23:00:00 | ES | Futures | 2161.49 | 2161.49 | 2160.44 | 2160.71 | 777.0 |
| 2014-11-23 18:00:00 | NQ | Futures | 4980.8 | 4986.08 | 4980.22 | 4981.39 | 847.0 |
| 2014-11-23 19:00:00 | NQ | Futures | 4981.68 | 4983.15 | 4980.22 | 4980.8 | 427.0 |
| 2014-11-23 20:00:00 | NQ | Futures | 4980.8 | 4981.98 | 4978.75 | 4979.34 | 665.0 |
| 2014-11-23 21:00:00 | NQ | Futures | 4979.63 | 4984.03 | 4979.34 | 4982.56 | 377.0 |
| 2014-11-23 22:00:00 | NQ | Futures | 4982.27 | 4984.03 | 4979.93 | 4983.44 | 538.0 |
| 2014-11-23 23:00:00 | NQ | Futures | 4983.15 | 4983.15 | 4981.1 | 4981.1 | 150.0 |
| 2014-11-23 18:00:00 | YM | Futures | 18487.0 | 18507.8 | 18480.8 | 18492.2 | 875.0 |
| 2014-11-23 19:00:00 | YM | Futures | 18493.2 | 18495.3 | 18489.1 | 18490.1 | 291.0 |
| 2014-11-23 20:00:00 | YM | Futures | 18490.1 | 18492.2 | 18483.9 | 18485.9 | 423.0 |
| 2014-11-23 21:00:00 | YM | Futures | 18487.0 | 18498.4 | 18487.0 | 18495.3 | 335.0 |
| 2014-11-23 22:00:00 | YM | Futures | 18495.3 | 18500.5 | 18489.1 | 18494.3 | 409.0 |
| 2014-11-23 23:00:00 | YM | Futures | 18493.2 | 18493.2 | 18488.0 | 18488.0 | 94.0 |
| 2014-11-23 18:00:00 | CL | Futures | 129.06 | 129.45 | 128.74 | 128.96 | 1026.0 |
| 2014-11-23 19:00:00 | CL | Futures | 128.98 | 128.98 | 128.61 | 128.76 | 828.0 |
| 2014-11-23 20:00:00 | CL | Futures | 128.79 | 128.93 | 128.73 | 128.74 | 755.0 |
| 2014-11-23 21:00:00 | CL | Futures | 128.74 | 129.08 | 128.73 | 129.05 | 581.0 |
| 2014-11-23 22:00:00 | CL | Futures | 129.05 | 129.4 | 129.0 | 129.28 | 1238.0 |
| 2014-11-23 23:00:00 | CL | Futures | 129.28 | 129.52 | 129.23 | 129.3 | 899.0 |
| 2014-11-23 18:00:00 | GC | Futures | 1642.6 | 1647.9 | 1641.8 | 1644.4 | 2440.0 |
| 2014-11-23 19:00:00 | GC | Futures | 1644.1 | 1646.4 | 1644.0 | 1645.2 | 1296.0 |
| 2014-11-23 20:00:00 | GC | Futures | 1645.2 | 1645.8 | 1640.7 | 1644.2 | 3701.0 |
| 2014-11-23 21:00:00 | GC | Futures | 1644.4 | 1645.3 | 1642.9 | 1642.9 | 1195.0 |
| 2014-11-23 22:00:00 | GC | Futures | 1643.0 | 1644.4 | 1641.4 | 1643.1 | 1754.0 |
| 2014-11-23 23:00:00 | GC | Futures | 1643.3 | 1643.6 | 1641.5 | 1642.1 | 804.0 |
| 2014-11-23 18:00:00 | ZN | Futures | 119.887464 | 119.917037 | 119.843105 | 119.917037 | 3627.0 |
| 2014-11-23 19:00:00 | ZN | Futures | 119.90225 | 119.961396 | 119.90225 | 119.946609 | 4881.0 |
| 2014-11-23 20:00:00 | ZN | Futures | 119.961396 | 119.961396 | 119.931823 | 119.946609 | 2505.0 |
| 2014-11-23 21:00:00 | ZN | Futures | 119.946609 | 119.961396 | 119.931823 | 119.946609 | 1240.0 |
| 2014-11-23 22:00:00 | ZN | Futures | 119.946609 | 119.961396 | 119.931823 | 119.961396 | 969.0 |
| 2014-11-23 23:00:00 | ZN | Futures | 119.961396 | 119.961396 | 119.946609 | 119.946609 | 601.0 |
> showing 36 of 262 rows — these rows as CSV