PREVIEW / futures_1hour / 2013-04-07
file: by_date/futures_1hour/2013/2013-04-07.parquet size: 14 KB rows: 268
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-04-07 18:00:00 | ES | Futures | 1592.39 | 1595.73 | 1592.13 | 1594.19 | 8751.0 |
| 2013-04-07 19:00:00 | ES | Futures | 1594.19 | 1595.22 | 1593.93 | 1594.96 | 3805.0 |
| 2013-04-07 20:00:00 | ES | Futures | 1594.96 | 1595.22 | 1592.39 | 1592.9 | 9957.0 |
| 2013-04-07 21:00:00 | ES | Futures | 1593.16 | 1593.67 | 1591.87 | 1592.39 | 7554.0 |
| 2013-04-07 22:00:00 | ES | Futures | 1592.64 | 1593.67 | 1592.13 | 1593.16 | 3394.0 |
| 2013-04-07 23:00:00 | ES | Futures | 1593.16 | 1594.7 | 1592.39 | 1594.45 | 3669.0 |
| 2013-04-07 18:00:00 | NQ | Futures | 3223.81 | 3228.47 | 3223.51 | 3225.26 | 809.0 |
| 2013-04-07 19:00:00 | NQ | Futures | 3225.85 | 3227.01 | 3224.68 | 3226.43 | 191.0 |
| 2013-04-07 20:00:00 | NQ | Futures | 3226.43 | 3227.6 | 3224.68 | 3225.56 | 1168.0 |
| 2013-04-07 21:00:00 | NQ | Futures | 3225.56 | 3226.43 | 3223.81 | 3224.97 | 434.0 |
| 2013-04-07 22:00:00 | NQ | Futures | 3225.26 | 3226.72 | 3224.39 | 3226.43 | 186.0 |
| 2013-04-07 23:00:00 | NQ | Futures | 3226.43 | 3228.18 | 3224.97 | 3228.18 | 302.0 |
| 2013-04-07 18:00:00 | YM | Futures | 14637.5 | 14657.7 | 14623.3 | 14649.6 | 634.0 |
| 2013-04-07 19:00:00 | YM | Futures | 14650.6 | 14658.7 | 14648.6 | 14657.7 | 367.0 |
| 2013-04-07 20:00:00 | YM | Futures | 14657.7 | 14657.7 | 14633.4 | 14637.5 | 1323.0 |
| 2013-04-07 21:00:00 | YM | Futures | 14637.5 | 14643.5 | 14628.4 | 14630.4 | 969.0 |
| 2013-04-07 22:00:00 | YM | Futures | 14630.4 | 14640.5 | 14627.4 | 14638.5 | 339.0 |
| 2013-04-07 23:00:00 | YM | Futures | 14637.5 | 14649.6 | 14633.4 | 14648.6 | 496.0 |
| 2013-04-07 18:00:00 | CL | Futures | 147.2 | 147.25 | 146.86 | 147.06 | 1098.0 |
| 2013-04-07 19:00:00 | CL | Futures | 147.05 | 147.17 | 146.73 | 146.95 | 1032.0 |
| 2013-04-07 20:00:00 | CL | Futures | 146.97 | 147.09 | 146.71 | 146.82 | 803.0 |
| 2013-04-07 21:00:00 | CL | Futures | 146.81 | 146.93 | 146.79 | 146.9 | 367.0 |
| 2013-04-07 22:00:00 | CL | Futures | 146.9 | 146.93 | 146.81 | 146.84 | 320.0 |
| 2013-04-07 23:00:00 | CL | Futures | 146.84 | 146.98 | 146.81 | 146.95 | 330.0 |
| 2013-04-07 18:00:00 | GC | Futures | 2171.2 | 2174.1 | 2170.6 | 2171.9 | 1595.0 |
| 2013-04-07 19:00:00 | GC | Futures | 2171.9 | 2172.1 | 2165.8 | 2165.8 | 1975.0 |
| 2013-04-07 20:00:00 | GC | Futures | 2166.0 | 2168.7 | 2164.0 | 2165.1 | 4530.0 |
| 2013-04-07 21:00:00 | GC | Futures | 2165.1 | 2166.5 | 2163.5 | 2165.4 | 2583.0 |
| 2013-04-07 22:00:00 | GC | Futures | 2165.3 | 2167.9 | 2164.7 | 2167.9 | 2081.0 |
| 2013-04-07 23:00:00 | GC | Futures | 2167.9 | 2169.4 | 2167.6 | 2167.9 | 1605.0 |
| 2013-04-07 18:00:00 | ZN | Futures | 119.582826 | 119.61091 | 119.554742 | 119.596868 | 6879.0 |
| 2013-04-07 19:00:00 | ZN | Futures | 119.596868 | 119.681121 | 119.582826 | 119.653037 | 9737.0 |
| 2013-04-07 20:00:00 | ZN | Futures | 119.653037 | 119.667079 | 119.624953 | 119.653037 | 7561.0 |
| 2013-04-07 21:00:00 | ZN | Futures | 119.653037 | 119.653037 | 119.61091 | 119.638995 | 6492.0 |
| 2013-04-07 22:00:00 | ZN | Futures | 119.638995 | 119.667079 | 119.624953 | 119.638995 | 3818.0 |
| 2013-04-07 23:00:00 | ZN | Futures | 119.638995 | 119.667079 | 119.596868 | 119.596868 | 4733.0 |
> showing 36 of 268 rows — these rows as CSV