PREVIEW / futures_1hour / 2013-02-03
file: by_date/futures_1hour/2013/2013-02-03.parquet size: 14 KB rows: 279
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-02-03 18:00:00 | ES | Futures | 1547.76 | 1547.76 | 1545.96 | 1546.47 | 4045.0 |
| 2013-02-03 19:00:00 | ES | Futures | 1546.47 | 1547.5 | 1546.47 | 1546.99 | 2381.0 |
| 2013-02-03 20:00:00 | ES | Futures | 1546.99 | 1548.27 | 1545.96 | 1547.24 | 6272.0 |
| 2013-02-03 21:00:00 | ES | Futures | 1547.24 | 1547.5 | 1545.96 | 1546.47 | 4158.0 |
| 2013-02-03 22:00:00 | ES | Futures | 1546.22 | 1546.47 | 1545.7 | 1546.22 | 3777.0 |
| 2013-02-03 23:00:00 | ES | Futures | 1545.96 | 1546.47 | 1545.7 | 1545.7 | 2554.0 |
| 2013-02-03 18:00:00 | NQ | Futures | 3212.53 | 3212.53 | 3204.67 | 3205.54 | 912.0 |
| 2013-02-03 19:00:00 | NQ | Futures | 3205.25 | 3208.16 | 3205.25 | 3207.58 | 376.0 |
| 2013-02-03 20:00:00 | NQ | Futures | 3207.87 | 3209.33 | 3205.54 | 3207.29 | 678.0 |
| 2013-02-03 21:00:00 | NQ | Futures | 3207.29 | 3208.16 | 3204.96 | 3205.25 | 530.0 |
| 2013-02-03 22:00:00 | NQ | Futures | 3205.54 | 3206.13 | 3204.67 | 3204.96 | 241.0 |
| 2013-02-03 23:00:00 | NQ | Futures | 3205.54 | 3206.71 | 3204.96 | 3205.25 | 263.0 |
| 2013-02-03 18:00:00 | YM | Futures | 14025.0 | 14025.0 | 14014.9 | 14016.9 | 299.0 |
| 2013-02-03 19:00:00 | YM | Futures | 14018.0 | 14024.0 | 14018.0 | 14020.0 | 334.0 |
| 2013-02-03 20:00:00 | YM | Futures | 14021.0 | 14032.0 | 14015.9 | 14025.0 | 821.0 |
| 2013-02-03 21:00:00 | YM | Futures | 14025.0 | 14029.0 | 14016.9 | 14020.0 | 500.0 |
| 2013-02-03 22:00:00 | YM | Futures | 14019.0 | 14022.0 | 14015.9 | 14020.0 | 221.0 |
| 2013-02-03 23:00:00 | YM | Futures | 14019.0 | 14021.0 | 14014.9 | 14016.9 | 307.0 |
| 2013-02-03 18:00:00 | CL | Futures | 156.17 | 156.23 | 155.9 | 155.98 | 547.0 |
| 2013-02-03 19:00:00 | CL | Futures | 155.96 | 155.98 | 155.79 | 155.88 | 660.0 |
| 2013-02-03 20:00:00 | CL | Futures | 155.88 | 155.98 | 155.79 | 155.85 | 630.0 |
| 2013-02-03 21:00:00 | CL | Futures | 155.85 | 156.04 | 155.85 | 155.93 | 513.0 |
| 2013-02-03 22:00:00 | CL | Futures | 155.93 | 156.03 | 155.88 | 155.95 | 261.0 |
| 2013-02-03 23:00:00 | CL | Futures | 155.96 | 155.98 | 155.72 | 155.75 | 458.0 |
| 2013-02-03 18:00:00 | GC | Futures | 2295.3 | 2296.3 | 2290.4 | 2293.7 | 1815.0 |
| 2013-02-03 19:00:00 | GC | Futures | 2293.7 | 2293.8 | 2290.8 | 2291.9 | 1754.0 |
| 2013-02-03 20:00:00 | GC | Futures | 2292.0 | 2295.6 | 2290.9 | 2295.0 | 2168.0 |
| 2013-02-03 21:00:00 | GC | Futures | 2295.0 | 2302.2 | 2295.0 | 2299.9 | 3145.0 |
| 2013-02-03 22:00:00 | GC | Futures | 2299.7 | 2300.3 | 2298.8 | 2299.3 | 912.0 |
| 2013-02-03 23:00:00 | GC | Futures | 2299.3 | 2300.1 | 2297.8 | 2298.8 | 1356.0 |
| 2013-02-03 18:00:00 | ZN | Futures | 116.613214 | 116.627123 | 116.418488 | 116.501942 | 29863.0 |
| 2013-02-03 19:00:00 | ZN | Futures | 116.501942 | 116.52976 | 116.501942 | 116.515851 | 10262.0 |
| 2013-02-03 20:00:00 | ZN | Futures | 116.515851 | 116.515851 | 116.446306 | 116.446306 | 15787.0 |
| 2013-02-03 21:00:00 | ZN | Futures | 116.460215 | 116.515851 | 116.418488 | 116.501942 | 9171.0 |
| 2013-02-03 22:00:00 | ZN | Futures | 116.515851 | 116.515851 | 116.446306 | 116.460215 | 6440.0 |
| 2013-02-03 23:00:00 | ZN | Futures | 116.474124 | 116.501942 | 116.460215 | 116.488033 | 2903.0 |
> showing 36 of 279 rows — these rows as CSV