PREVIEW / futures_1hour / 2013-04-28
file: by_date/futures_1hour/2013/2013-04-28.parquet size: 14 KB rows: 258
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 |
|---|---|---|---|---|---|---|---|
| 2013-04-28 18:00:00 | ES | Futures | 1624.07 | 1624.84 | 1623.3 | 1624.07 | 3994.0 |
| 2013-04-28 19:00:00 | ES | Futures | 1624.07 | 1624.07 | 1622.52 | 1623.3 | 2208.0 |
| 2013-04-28 20:00:00 | ES | Futures | 1623.3 | 1623.3 | 1621.49 | 1623.3 | 5596.0 |
| 2013-04-28 21:00:00 | ES | Futures | 1623.3 | 1624.33 | 1623.04 | 1623.81 | 3347.0 |
| 2013-04-28 22:00:00 | ES | Futures | 1623.81 | 1625.61 | 1623.3 | 1623.55 | 5195.0 |
| 2013-04-28 23:00:00 | ES | Futures | 1623.3 | 1623.81 | 1623.04 | 1623.81 | 1527.0 |
| 2013-04-28 18:00:00 | NQ | Futures | 3306.06 | 3306.93 | 3302.56 | 3304.01 | 592.0 |
| 2013-04-28 19:00:00 | NQ | Futures | 3304.01 | 3304.01 | 3301.39 | 3302.56 | 199.0 |
| 2013-04-28 20:00:00 | NQ | Futures | 3302.26 | 3302.56 | 3298.76 | 3301.97 | 493.0 |
| 2013-04-28 21:00:00 | NQ | Futures | 3302.56 | 3304.31 | 3302.26 | 3304.01 | 261.0 |
| 2013-04-28 22:00:00 | NQ | Futures | 3304.01 | 3307.52 | 3303.43 | 3303.43 | 504.0 |
| 2013-04-28 23:00:00 | NQ | Futures | 3303.43 | 3305.18 | 3302.85 | 3304.89 | 211.0 |
| 2013-04-28 18:00:00 | YM | Futures | 14808.3 | 14813.4 | 14801.2 | 14806.3 | 344.0 |
| 2013-04-28 19:00:00 | YM | Futures | 14805.3 | 14808.3 | 14799.2 | 14802.3 | 361.0 |
| 2013-04-28 20:00:00 | YM | Futures | 14802.3 | 14804.3 | 14791.1 | 14804.3 | 658.0 |
| 2013-04-28 21:00:00 | YM | Futures | 14805.3 | 14812.4 | 14804.3 | 14809.3 | 468.0 |
| 2013-04-28 22:00:00 | YM | Futures | 14811.4 | 14822.5 | 14806.3 | 14806.3 | 653.0 |
| 2013-04-28 23:00:00 | YM | Futures | 14806.3 | 14810.3 | 14804.3 | 14808.3 | 246.0 |
| 2013-04-28 18:00:00 | CL | Futures | 145.57 | 145.9 | 145.4 | 145.48 | 812.0 |
| 2013-04-28 19:00:00 | CL | Futures | 145.49 | 145.79 | 145.43 | 145.48 | 440.0 |
| 2013-04-28 20:00:00 | CL | Futures | 145.49 | 145.53 | 145.29 | 145.49 | 589.0 |
| 2013-04-28 21:00:00 | CL | Futures | 145.51 | 145.6 | 145.15 | 145.4 | 873.0 |
| 2013-04-28 22:00:00 | CL | Futures | 145.4 | 145.68 | 145.38 | 145.53 | 929.0 |
| 2013-04-28 23:00:00 | CL | Futures | 145.54 | 145.56 | 145.29 | 145.46 | 483.0 |
| 2013-04-28 18:00:00 | GC | Futures | 2013.8 | 2015.4 | 2008.7 | 2010.9 | 1544.0 |
| 2013-04-28 19:00:00 | GC | Futures | 2011.4 | 2013.1 | 2007.5 | 2011.6 | 959.0 |
| 2013-04-28 20:00:00 | GC | Futures | 2011.6 | 2013.9 | 2008.1 | 2013.6 | 2475.0 |
| 2013-04-28 21:00:00 | GC | Futures | 2013.6 | 2018.6 | 2012.7 | 2016.5 | 2472.0 |
| 2013-04-28 22:00:00 | GC | Futures | 2016.4 | 2022.0 | 2016.0 | 2017.8 | 3699.0 |
| 2013-04-28 23:00:00 | GC | Futures | 2017.6 | 2018.4 | 2013.2 | 2016.0 | 1021.0 |
| 2013-04-28 18:00:00 | ZN | Futures | 119.863669 | 119.947922 | 119.863669 | 119.93388 | 2906.0 |
| 2013-04-28 19:00:00 | ZN | Futures | 119.93388 | 119.961964 | 119.93388 | 119.947922 | 1554.0 |
| 2013-04-28 20:00:00 | ZN | Futures | 119.947922 | 119.976006 | 119.93388 | 119.961964 | 3128.0 |
| 2013-04-28 21:00:00 | ZN | Futures | 119.961964 | 119.976006 | 119.93388 | 119.976006 | 4089.0 |
| 2013-04-28 22:00:00 | ZN | Futures | 119.976006 | 120.00409 | 119.961964 | 119.990048 | 5424.0 |
| 2013-04-28 23:00:00 | ZN | Futures | 119.990048 | 120.00409 | 119.976006 | 120.00409 | 1141.0 |
> showing 36 of 258 rows — these rows as CSV