PREVIEW / futures_1hour / 2013-01-06
file: by_date/futures_1hour/2013/2013-01-06.parquet size: 14 KB rows: 275
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-01-06 18:00:00 | ES | Futures | 1498.75 | 1499.26 | 1496.7 | 1497.47 | 7157.0 |
| 2013-01-06 19:00:00 | ES | Futures | 1497.47 | 1497.47 | 1496.18 | 1496.95 | 5636.0 |
| 2013-01-06 20:00:00 | ES | Futures | 1496.7 | 1497.72 | 1496.18 | 1496.44 | 4773.0 |
| 2013-01-06 21:00:00 | ES | Futures | 1496.44 | 1497.21 | 1495.67 | 1495.93 | 3066.0 |
| 2013-01-06 22:00:00 | ES | Futures | 1495.67 | 1496.44 | 1494.39 | 1494.64 | 5732.0 |
| 2013-01-06 23:00:00 | ES | Futures | 1494.39 | 1495.41 | 1494.13 | 1494.39 | 3946.0 |
| 2013-01-06 18:00:00 | NQ | Futures | 3162.47 | 3163.92 | 3160.14 | 3162.47 | 504.0 |
| 2013-01-06 19:00:00 | NQ | Futures | 3162.17 | 3162.17 | 3159.55 | 3161.01 | 589.0 |
| 2013-01-06 20:00:00 | NQ | Futures | 3160.72 | 3162.76 | 3158.68 | 3159.85 | 456.0 |
| 2013-01-06 21:00:00 | NQ | Futures | 3159.85 | 3161.59 | 3158.68 | 3158.97 | 208.0 |
| 2013-01-06 22:00:00 | NQ | Futures | 3158.97 | 3159.85 | 3156.64 | 3156.94 | 614.0 |
| 2013-01-06 23:00:00 | NQ | Futures | 3156.94 | 3158.97 | 3155.19 | 3155.77 | 355.0 |
| 2013-01-06 18:00:00 | YM | Futures | 13441.5 | 13446.5 | 13429.4 | 13434.5 | 482.0 |
| 2013-01-06 19:00:00 | YM | Futures | 13434.5 | 13434.5 | 13425.4 | 13430.4 | 740.0 |
| 2013-01-06 20:00:00 | YM | Futures | 13430.4 | 13436.5 | 13423.4 | 13427.4 | 461.0 |
| 2013-01-06 21:00:00 | YM | Futures | 13425.4 | 13433.5 | 13422.4 | 13422.4 | 274.0 |
| 2013-01-06 22:00:00 | YM | Futures | 13422.4 | 13426.4 | 13409.3 | 13410.3 | 596.0 |
| 2013-01-06 23:00:00 | YM | Futures | 13410.3 | 13417.4 | 13407.3 | 13408.3 | 464.0 |
| 2013-01-06 18:00:00 | CL | Futures | 149.64 | 149.71 | 149.26 | 149.39 | 975.0 |
| 2013-01-06 19:00:00 | CL | Futures | 149.42 | 149.42 | 149.11 | 149.23 | 781.0 |
| 2013-01-06 20:00:00 | CL | Futures | 149.21 | 149.47 | 149.19 | 149.24 | 790.0 |
| 2013-01-06 21:00:00 | CL | Futures | 149.27 | 149.5 | 149.26 | 149.37 | 649.0 |
| 2013-01-06 22:00:00 | CL | Futures | 149.37 | 149.43 | 149.18 | 149.19 | 606.0 |
| 2013-01-06 23:00:00 | CL | Futures | 149.19 | 149.26 | 149.03 | 149.06 | 761.0 |
| 2013-01-06 18:00:00 | GC | Futures | 2281.1 | 2285.6 | 2280.6 | 2282.1 | 2596.0 |
| 2013-01-06 19:00:00 | GC | Futures | 2282.2 | 2286.4 | 2280.9 | 2281.3 | 2725.0 |
| 2013-01-06 20:00:00 | GC | Futures | 2281.4 | 2287.6 | 2281.4 | 2285.4 | 4914.0 |
| 2013-01-06 21:00:00 | GC | Futures | 2285.3 | 2290.4 | 2285.0 | 2288.4 | 2191.0 |
| 2013-01-06 22:00:00 | GC | Futures | 2288.3 | 2289.5 | 2286.2 | 2286.7 | 2087.0 |
| 2013-01-06 23:00:00 | GC | Futures | 2286.5 | 2287.5 | 2282.8 | 2283.5 | 2077.0 |
| 2013-01-06 18:00:00 | ZN | Futures | 117.10003 | 117.169575 | 117.072212 | 117.155666 | 7912.0 |
| 2013-01-06 19:00:00 | ZN | Futures | 117.169575 | 117.225211 | 117.155666 | 117.211302 | 8594.0 |
| 2013-01-06 20:00:00 | ZN | Futures | 117.211302 | 117.23912 | 117.183484 | 117.225211 | 6427.0 |
| 2013-01-06 21:00:00 | ZN | Futures | 117.23912 | 117.266938 | 117.197393 | 117.211302 | 6792.0 |
| 2013-01-06 22:00:00 | ZN | Futures | 117.211302 | 117.23912 | 117.169575 | 117.225211 | 7172.0 |
| 2013-01-06 23:00:00 | ZN | Futures | 117.225211 | 117.280847 | 117.225211 | 117.280847 | 6254.0 |
> showing 36 of 275 rows — these rows as CSV