PREVIEW / futures_1hour / 2011-04-24
file: by_date/futures_1hour/2011/2011-04-24.parquet size: 14 KB rows: 270
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-04-24 18:00:00 | ES | Futures | 1322.15 | 1324.13 | 1321.4 | 1323.64 | 6291.0 |
| 2011-04-24 19:00:00 | ES | Futures | 1323.64 | 1324.63 | 1323.64 | 1324.63 | 3320.0 |
| 2011-04-24 20:00:00 | ES | Futures | 1324.88 | 1326.12 | 1324.63 | 1324.63 | 6948.0 |
| 2011-04-24 21:00:00 | ES | Futures | 1324.88 | 1325.38 | 1323.89 | 1323.89 | 6872.0 |
| 2011-04-24 22:00:00 | ES | Futures | 1323.89 | 1325.38 | 1323.64 | 1324.63 | 2306.0 |
| 2011-04-24 23:00:00 | ES | Futures | 1324.63 | 1324.88 | 1323.89 | 1324.13 | 1221.0 |
| 2011-04-24 18:00:00 | NQ | Futures | 2727.19 | 2730.35 | 2725.76 | 2730.07 | 811.0 |
| 2011-04-24 19:00:00 | NQ | Futures | 2729.78 | 2734.09 | 2729.78 | 2732.36 | 268.0 |
| 2011-04-24 20:00:00 | NQ | Futures | 2732.65 | 2734.66 | 2732.65 | 2732.65 | 318.0 |
| 2011-04-24 21:00:00 | NQ | Futures | 2732.65 | 2733.51 | 2731.79 | 2731.79 | 732.0 |
| 2011-04-24 22:00:00 | NQ | Futures | 2731.79 | 2733.8 | 2730.93 | 2733.51 | 243.0 |
| 2011-04-24 23:00:00 | NQ | Futures | 2732.94 | 2733.51 | 2731.21 | 2731.21 | 93.0 |
| 2011-04-24 18:00:00 | YM | Futures | 11974.4 | 11984.9 | 11966.6 | 11984.0 | 106.0 |
| 2011-04-24 19:00:00 | YM | Futures | 11984.0 | 11989.8 | 11980.1 | 11989.8 | 64.0 |
| 2011-04-24 20:00:00 | YM | Futures | 11990.7 | 11998.4 | 11984.0 | 11984.9 | 427.0 |
| 2011-04-24 21:00:00 | YM | Futures | 11984.0 | 11987.8 | 11975.3 | 11977.2 | 191.0 |
| 2011-04-24 22:00:00 | YM | Futures | 11975.3 | 11987.8 | 11975.3 | 11984.9 | 171.0 |
| 2011-04-24 23:00:00 | YM | Futures | 11984.0 | 11987.8 | 11979.2 | 11983.0 | 104.0 |
| 2011-04-24 18:00:00 | CL | Futures | 194.68 | 194.9 | 193.67 | 194.87 | 1126.0 |
| 2011-04-24 19:00:00 | CL | Futures | 194.87 | 195.47 | 194.87 | 195.47 | 1526.0 |
| 2011-04-24 20:00:00 | CL | Futures | 195.47 | 195.94 | 195.35 | 195.58 | 1729.0 |
| 2011-04-24 21:00:00 | CL | Futures | 195.56 | 195.8 | 195.2 | 195.73 | 1269.0 |
| 2011-04-24 22:00:00 | CL | Futures | 195.75 | 195.89 | 195.35 | 195.47 | 953.0 |
| 2011-04-24 23:00:00 | CL | Futures | 195.47 | 195.47 | 195.04 | 195.2 | 542.0 |
| 2011-04-24 18:00:00 | GC | Futures | 2108.6 | 2112.2 | 2107.2 | 2111.1 | 2749.0 |
| 2011-04-24 19:00:00 | GC | Futures | 2111.1 | 2113.9 | 2110.9 | 2111.6 | 1656.0 |
| 2011-04-24 20:00:00 | GC | Futures | 2112.1 | 2113.6 | 2110.4 | 2110.4 | 1418.0 |
| 2011-04-24 21:00:00 | GC | Futures | 2110.5 | 2112.8 | 2109.5 | 2110.1 | 2055.0 |
| 2011-04-24 22:00:00 | GC | Futures | 2110.1 | 2111.8 | 2109.4 | 2111.6 | 1179.0 |
| 2011-04-24 23:00:00 | GC | Futures | 2111.8 | 2113.7 | 2110.4 | 2113.5 | 1315.0 |
| 2011-04-24 18:00:00 | ZN | Futures | 102.182269 | 102.222178 | 102.155662 | 102.168965 | 2596.0 |
| 2011-04-24 19:00:00 | ZN | Futures | 102.168965 | 102.208875 | 102.115752 | 102.142359 | 2508.0 |
| 2011-04-24 20:00:00 | ZN | Futures | 102.142359 | 102.168965 | 102.129056 | 102.155662 | 1721.0 |
| 2011-04-24 21:00:00 | ZN | Futures | 102.155662 | 102.195572 | 102.142359 | 102.168965 | 3402.0 |
| 2011-04-24 22:00:00 | ZN | Futures | 102.168965 | 102.195572 | 102.155662 | 102.182269 | 650.0 |
| 2011-04-24 23:00:00 | ZN | Futures | 102.182269 | 102.195572 | 102.155662 | 102.168965 | 619.0 |
> showing 36 of 270 rows — these rows as CSV