PREVIEW / futures_1hour / 2011-10-16
file: by_date/futures_1hour/2011/2011-10-16.parquet size: 14 KB rows: 260
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 |
|---|---|---|---|---|---|---|---|
| 2011-10-16 18:00:00 | ES | Futures | 1221.94 | 1225.71 | 1221.94 | 1224.95 | 12929.0 |
| 2011-10-16 19:00:00 | ES | Futures | 1225.2 | 1226.71 | 1224.95 | 1225.2 | 6047.0 |
| 2011-10-16 20:00:00 | ES | Futures | 1225.45 | 1228.46 | 1225.2 | 1227.71 | 11449.0 |
| 2011-10-16 21:00:00 | ES | Futures | 1227.46 | 1230.72 | 1226.21 | 1229.47 | 15864.0 |
| 2011-10-16 22:00:00 | ES | Futures | 1229.47 | 1231.47 | 1229.22 | 1229.22 | 12059.0 |
| 2011-10-16 23:00:00 | ES | Futures | 1229.22 | 1230.47 | 1228.21 | 1229.47 | 5432.0 |
| 2011-10-16 18:00:00 | NQ | Futures | 2730.13 | 2736.47 | 2727.53 | 2733.87 | 951.0 |
| 2011-10-16 19:00:00 | NQ | Futures | 2733.87 | 2736.18 | 2732.72 | 2733.59 | 237.0 |
| 2011-10-16 20:00:00 | NQ | Futures | 2733.59 | 2737.91 | 2733.01 | 2736.47 | 620.0 |
| 2011-10-16 21:00:00 | NQ | Futures | 2736.76 | 2744.54 | 2734.74 | 2740.79 | 1833.0 |
| 2011-10-16 22:00:00 | NQ | Futures | 2741.08 | 2743.68 | 2740.22 | 2740.79 | 847.0 |
| 2011-10-16 23:00:00 | NQ | Futures | 2740.22 | 2742.81 | 2738.2 | 2740.51 | 527.0 |
| 2011-10-16 18:00:00 | YM | Futures | 11380.5 | 11414.0 | 11380.5 | 11405.1 | 312.0 |
| 2011-10-16 19:00:00 | YM | Futures | 11406.1 | 11418.9 | 11405.1 | 11408.1 | 384.0 |
| 2011-10-16 20:00:00 | YM | Futures | 11408.1 | 11433.7 | 11407.1 | 11425.8 | 548.0 |
| 2011-10-16 21:00:00 | YM | Futures | 11424.8 | 11461.3 | 11413.0 | 11442.6 | 817.0 |
| 2011-10-16 22:00:00 | YM | Futures | 11446.5 | 11456.3 | 11440.6 | 11445.5 | 681.0 |
| 2011-10-16 23:00:00 | YM | Futures | 11444.5 | 11455.4 | 11434.7 | 11441.6 | 565.0 |
| 2011-10-16 18:00:00 | CL | Futures | 147.73 | 148.25 | 147.56 | 147.88 | 453.0 |
| 2011-10-16 19:00:00 | CL | Futures | 147.91 | 148.03 | 147.76 | 147.83 | 100.0 |
| 2011-10-16 20:00:00 | CL | Futures | 147.78 | 147.96 | 147.52 | 147.66 | 208.0 |
| 2011-10-16 21:00:00 | CL | Futures | 147.64 | 147.69 | 147.17 | 147.66 | 488.0 |
| 2011-10-16 22:00:00 | CL | Futures | 147.66 | 147.74 | 147.32 | 147.46 | 367.0 |
| 2011-10-16 23:00:00 | CL | Futures | 147.39 | 147.56 | 147.1 | 147.15 | 213.0 |
| 2011-10-16 18:00:00 | GC | Futures | 2344.9 | 2347.5 | 2342.3 | 2343.2 | 833.0 |
| 2011-10-16 19:00:00 | GC | Futures | 2343.0 | 2344.0 | 2337.5 | 2343.3 | 836.0 |
| 2011-10-16 20:00:00 | GC | Futures | 2343.3 | 2343.6 | 2338.6 | 2342.3 | 1014.0 |
| 2011-10-16 21:00:00 | GC | Futures | 2342.1 | 2344.4 | 2336.2 | 2342.2 | 2555.0 |
| 2011-10-16 22:00:00 | GC | Futures | 2342.1 | 2344.9 | 2341.4 | 2342.5 | 1834.0 |
| 2011-10-16 23:00:00 | GC | Futures | 2342.2 | 2346.5 | 2339.6 | 2341.5 | 1998.0 |
| 2011-10-16 18:00:00 | ZN | Futures | 111.028761 | 111.082974 | 110.974548 | 111.042314 | 3078.0 |
| 2011-10-16 19:00:00 | ZN | Futures | 111.055868 | 111.055868 | 110.947441 | 111.015208 | 4017.0 |
| 2011-10-16 20:00:00 | ZN | Futures | 111.001654 | 111.015208 | 110.839014 | 110.879674 | 8740.0 |
| 2011-10-16 21:00:00 | ZN | Futures | 110.866121 | 110.906781 | 110.839014 | 110.852568 | 5953.0 |
| 2011-10-16 22:00:00 | ZN | Futures | 110.866121 | 110.906781 | 110.811908 | 110.893228 | 4461.0 |
| 2011-10-16 23:00:00 | ZN | Futures | 110.893228 | 110.906781 | 110.839014 | 110.879674 | 2972.0 |
> showing 36 of 260 rows — these rows as CSV