PREVIEW / futures_1hour / 2015-05-24
file: by_date/futures_1hour/2015/2015-05-24.parquet size: 13 KB rows: 228
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 |
|---|---|---|---|---|---|---|---|
| 2015-05-24 18:00:00 | ES | Futures | 2244.47 | 2245.27 | 2243.42 | 2245.27 | 1269.0 |
| 2015-05-24 19:00:00 | ES | Futures | 2245.27 | 2246.32 | 2244.47 | 2244.74 | 907.0 |
| 2015-05-24 20:00:00 | ES | Futures | 2245.0 | 2245.79 | 2243.68 | 2245.27 | 1645.0 |
| 2015-05-24 21:00:00 | ES | Futures | 2245.53 | 2245.79 | 2243.94 | 2245.79 | 1380.0 |
| 2015-05-24 22:00:00 | ES | Futures | 2245.79 | 2246.59 | 2245.27 | 2245.79 | 899.0 |
| 2015-05-24 23:00:00 | ES | Futures | 2246.06 | 2247.11 | 2245.27 | 2245.27 | 1412.0 |
| 2015-05-24 18:00:00 | NQ | Futures | 5325.49 | 5330.78 | 5324.02 | 5328.14 | 300.0 |
| 2015-05-24 19:00:00 | NQ | Futures | 5327.84 | 5328.43 | 5325.49 | 5326.08 | 201.0 |
| 2015-05-24 20:00:00 | NQ | Futures | 5326.37 | 5326.96 | 5321.67 | 5326.67 | 440.0 |
| 2015-05-24 21:00:00 | NQ | Futures | 5326.08 | 5326.67 | 5323.14 | 5326.67 | 222.0 |
| 2015-05-24 22:00:00 | NQ | Futures | 5326.67 | 5328.14 | 5325.2 | 5326.08 | 158.0 |
| 2015-05-24 23:00:00 | NQ | Futures | 5326.67 | 5328.43 | 5324.61 | 5324.61 | 294.0 |
| 2015-05-24 18:00:00 | YM | Futures | 19117.2 | 19123.5 | 19102.5 | 19119.3 | 146.0 |
| 2015-05-24 19:00:00 | YM | Futures | 19120.3 | 19127.7 | 19116.1 | 19118.2 | 118.0 |
| 2015-05-24 20:00:00 | YM | Futures | 19117.2 | 19124.5 | 19108.8 | 19123.5 | 289.0 |
| 2015-05-24 21:00:00 | YM | Futures | 19121.4 | 19126.6 | 19098.3 | 19121.4 | 1397.0 |
| 2015-05-24 22:00:00 | YM | Futures | 19121.4 | 19125.6 | 19119.3 | 19124.5 | 140.0 |
| 2015-05-24 23:00:00 | YM | Futures | 19125.6 | 19140.3 | 19119.3 | 19120.3 | 1385.0 |
| 2015-05-24 18:00:00 | CL | Futures | 90.04 | 90.06 | 89.62 | 89.86 | 539.0 |
| 2015-05-24 19:00:00 | CL | Futures | 89.86 | 89.94 | 89.73 | 89.83 | 332.0 |
| 2015-05-24 20:00:00 | CL | Futures | 89.85 | 89.89 | 89.59 | 89.62 | 1148.0 |
| 2015-05-24 21:00:00 | CL | Futures | 89.64 | 89.82 | 89.62 | 89.79 | 996.0 |
| 2015-05-24 22:00:00 | CL | Futures | 89.79 | 89.82 | 89.67 | 89.74 | 1423.0 |
| 2015-05-24 23:00:00 | CL | Futures | 89.74 | 89.79 | 89.62 | 89.71 | 445.0 |
| 2015-05-24 18:00:00 | GC | Futures | 1646.0 | 1646.0 | 1643.3 | 1644.2 | 644.0 |
| 2015-05-24 19:00:00 | GC | Futures | 1644.2 | 1644.5 | 1642.9 | 1643.7 | 502.0 |
| 2015-05-24 20:00:00 | GC | Futures | 1643.7 | 1644.4 | 1642.0 | 1642.6 | 1088.0 |
| 2015-05-24 21:00:00 | GC | Futures | 1642.6 | 1645.0 | 1642.5 | 1644.1 | 1627.0 |
| 2015-05-24 22:00:00 | GC | Futures | 1644.1 | 1645.2 | 1643.8 | 1645.2 | 739.0 |
| 2015-05-24 23:00:00 | GC | Futures | 1645.0 | 1645.3 | 1644.2 | 1644.4 | 608.0 |
| 2015-05-24 18:00:00 | ZN | Futures | 121.886965 | 121.886965 | 121.767497 | 121.782431 | 2914.0 |
| 2015-05-24 19:00:00 | ZN | Futures | 121.782431 | 121.797364 | 121.752564 | 121.752564 | 1487.0 |
| 2015-05-24 20:00:00 | ZN | Futures | 121.752564 | 121.767497 | 121.707764 | 121.737631 | 3433.0 |
| 2015-05-24 21:00:00 | ZN | Futures | 121.737631 | 121.767497 | 121.737631 | 121.752564 | 1824.0 |
| 2015-05-24 22:00:00 | ZN | Futures | 121.752564 | 121.797364 | 121.752564 | 121.782431 | 1585.0 |
| 2015-05-24 23:00:00 | ZN | Futures | 121.767497 | 121.797364 | 121.767497 | 121.782431 | 1478.0 |
> showing 36 of 228 rows — these rows as CSV