PREVIEW / futures_1hour / 2013-08-11
file: by_date/futures_1hour/2013/2013-08-11.parquet size: 14 KB rows: 256
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-08-11 18:00:00 | ES | Futures | 1742.26 | 1742.77 | 1739.67 | 1740.19 | 8079.0 |
| 2013-08-11 19:00:00 | ES | Futures | 1740.19 | 1741.48 | 1739.93 | 1740.7 | 3273.0 |
| 2013-08-11 20:00:00 | ES | Futures | 1740.45 | 1741.74 | 1740.19 | 1740.96 | 5897.0 |
| 2013-08-11 21:00:00 | ES | Futures | 1740.96 | 1741.74 | 1739.93 | 1741.74 | 5583.0 |
| 2013-08-11 22:00:00 | ES | Futures | 1741.74 | 1742.77 | 1741.48 | 1742.26 | 6048.0 |
| 2013-08-11 23:00:00 | ES | Futures | 1742.51 | 1742.77 | 1741.74 | 1742.26 | 2781.0 |
| 2013-08-11 18:00:00 | NQ | Futures | 3639.51 | 3640.38 | 3634.25 | 3634.25 | 1223.0 |
| 2013-08-11 19:00:00 | NQ | Futures | 3634.54 | 3637.46 | 3634.54 | 3636.0 | 441.0 |
| 2013-08-11 20:00:00 | NQ | Futures | 3636.29 | 3639.51 | 3635.41 | 3638.04 | 1454.0 |
| 2013-08-11 21:00:00 | NQ | Futures | 3638.34 | 3640.09 | 3636.0 | 3640.09 | 924.0 |
| 2013-08-11 22:00:00 | NQ | Futures | 3640.09 | 3641.84 | 3639.51 | 3641.55 | 938.0 |
| 2013-08-11 23:00:00 | NQ | Futures | 3641.26 | 3641.55 | 3639.51 | 3640.67 | 454.0 |
| 2013-08-11 18:00:00 | YM | Futures | 15614.1 | 15614.1 | 15589.7 | 15589.7 | 758.0 |
| 2013-08-11 19:00:00 | YM | Futures | 15589.7 | 15600.9 | 15589.7 | 15592.7 | 320.0 |
| 2013-08-11 20:00:00 | YM | Futures | 15592.7 | 15601.9 | 15590.7 | 15593.8 | 1084.0 |
| 2013-08-11 21:00:00 | YM | Futures | 15594.8 | 15603.9 | 15588.7 | 15603.9 | 943.0 |
| 2013-08-11 22:00:00 | YM | Futures | 15603.9 | 15613.1 | 15601.9 | 15611.0 | 919.0 |
| 2013-08-11 23:00:00 | YM | Futures | 15611.0 | 15611.0 | 15601.9 | 15604.9 | 639.0 |
| 2013-08-11 18:00:00 | CL | Futures | 166.37 | 166.68 | 166.32 | 166.57 | 1208.0 |
| 2013-08-11 19:00:00 | CL | Futures | 166.57 | 166.57 | 166.23 | 166.35 | 752.0 |
| 2013-08-11 20:00:00 | CL | Futures | 166.37 | 166.37 | 166.26 | 166.29 | 633.0 |
| 2013-08-11 21:00:00 | CL | Futures | 166.29 | 166.54 | 166.09 | 166.43 | 1023.0 |
| 2013-08-11 22:00:00 | CL | Futures | 166.46 | 166.83 | 166.42 | 166.75 | 1411.0 |
| 2013-08-11 23:00:00 | CL | Futures | 166.76 | 167.25 | 166.7 | 167.08 | 1690.0 |
| 2013-08-11 18:00:00 | GC | Futures | 1800.5 | 1827.2 | 1800.5 | 1821.2 | 7266.0 |
| 2013-08-11 19:00:00 | GC | Futures | 1821.2 | 1822.6 | 1818.5 | 1820.9 | 2369.0 |
| 2013-08-11 20:00:00 | GC | Futures | 1821.1 | 1822.8 | 1817.2 | 1817.5 | 2264.0 |
| 2013-08-11 21:00:00 | GC | Futures | 1817.6 | 1827.2 | 1815.0 | 1823.8 | 7556.0 |
| 2013-08-11 22:00:00 | GC | Futures | 1823.9 | 1825.7 | 1818.6 | 1823.0 | 3165.0 |
| 2013-08-11 23:00:00 | GC | Futures | 1823.1 | 1823.7 | 1820.0 | 1820.7 | 1230.0 |
| 2013-08-11 18:00:00 | ZN | Futures | 114.835277 | 114.906032 | 114.821126 | 114.87773 | 3407.0 |
| 2013-08-11 19:00:00 | ZN | Futures | 114.87773 | 114.920183 | 114.849428 | 114.891881 | 3804.0 |
| 2013-08-11 20:00:00 | ZN | Futures | 114.906032 | 114.920183 | 114.863579 | 114.891881 | 4821.0 |
| 2013-08-11 21:00:00 | ZN | Futures | 114.87773 | 114.891881 | 114.863579 | 114.87773 | 3653.0 |
| 2013-08-11 22:00:00 | ZN | Futures | 114.863579 | 114.87773 | 114.821126 | 114.821126 | 5171.0 |
| 2013-08-11 23:00:00 | ZN | Futures | 114.835277 | 114.849428 | 114.806975 | 114.821126 | 2054.0 |
> showing 36 of 256 rows — these rows as CSV