PREVIEW / futures_1hour / 2012-12-09
file: by_date/futures_1hour/2012/2012-12-09.parquet size: 13 KB rows: 263
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-09 18:00:00 | ES | Futures | 1446.95 | 1449.25 | 1446.95 | 1447.97 | 7891.0 |
| 2012-12-09 19:00:00 | ES | Futures | 1447.71 | 1449.76 | 1447.71 | 1449.25 | 3673.0 |
| 2012-12-09 20:00:00 | ES | Futures | 1449.25 | 1450.01 | 1447.97 | 1448.99 | 4445.0 |
| 2012-12-09 21:00:00 | ES | Futures | 1448.99 | 1449.76 | 1446.95 | 1448.73 | 6804.0 |
| 2012-12-09 22:00:00 | ES | Futures | 1448.73 | 1448.99 | 1446.95 | 1446.95 | 3002.0 |
| 2012-12-09 23:00:00 | ES | Futures | 1447.2 | 1447.71 | 1446.95 | 1447.46 | 1618.0 |
| 2012-12-09 18:00:00 | NQ | Futures | 3065.0 | 3068.78 | 3063.26 | 3067.61 | 386.0 |
| 2012-12-09 19:00:00 | NQ | Futures | 3067.91 | 3071.39 | 3067.91 | 3069.94 | 537.0 |
| 2012-12-09 20:00:00 | NQ | Futures | 3069.94 | 3071.1 | 3067.61 | 3069.65 | 522.0 |
| 2012-12-09 21:00:00 | NQ | Futures | 3069.94 | 3072.26 | 3065.87 | 3070.23 | 1399.0 |
| 2012-12-09 22:00:00 | NQ | Futures | 3070.52 | 3070.81 | 3066.45 | 3067.03 | 365.0 |
| 2012-12-09 23:00:00 | NQ | Futures | 3067.03 | 3067.91 | 3063.55 | 3063.84 | 486.0 |
| 2012-12-09 18:00:00 | YM | Futures | 13153.8 | 13169.8 | 13149.8 | 13155.8 | 556.0 |
| 2012-12-09 19:00:00 | YM | Futures | 13156.8 | 13168.8 | 13153.8 | 13167.8 | 543.0 |
| 2012-12-09 20:00:00 | YM | Futures | 13167.8 | 13174.8 | 13157.8 | 13167.8 | 1061.0 |
| 2012-12-09 21:00:00 | YM | Futures | 13167.8 | 13172.8 | 13151.8 | 13167.8 | 1491.0 |
| 2012-12-09 22:00:00 | YM | Futures | 13166.8 | 13168.8 | 13152.8 | 13153.8 | 453.0 |
| 2012-12-09 23:00:00 | YM | Futures | 13154.8 | 13155.8 | 13148.8 | 13152.8 | 340.0 |
| 2012-12-09 18:00:00 | CL | Futures | 138.9 | 139.17 | 138.77 | 139.11 | 774.0 |
| 2012-12-09 19:00:00 | CL | Futures | 139.12 | 139.25 | 139.09 | 139.24 | 894.0 |
| 2012-12-09 20:00:00 | CL | Futures | 139.22 | 139.35 | 139.17 | 139.32 | 1052.0 |
| 2012-12-09 21:00:00 | CL | Futures | 139.32 | 139.37 | 138.98 | 139.25 | 1068.0 |
| 2012-12-09 22:00:00 | CL | Futures | 139.25 | 139.32 | 139.19 | 139.19 | 194.0 |
| 2012-12-09 23:00:00 | CL | Futures | 139.19 | 139.25 | 139.14 | 139.24 | 379.0 |
| 2012-12-09 18:00:00 | GC | Futures | 2348.8 | 2350.3 | 2345.9 | 2347.9 | 1251.0 |
| 2012-12-09 19:00:00 | GC | Futures | 2348.1 | 2351.5 | 2347.0 | 2351.5 | 2403.0 |
| 2012-12-09 20:00:00 | GC | Futures | 2351.5 | 2354.3 | 2350.8 | 2352.8 | 3167.0 |
| 2012-12-09 21:00:00 | GC | Futures | 2352.9 | 2353.0 | 2350.6 | 2351.8 | 1354.0 |
| 2012-12-09 22:00:00 | GC | Futures | 2351.8 | 2352.6 | 2350.8 | 2350.8 | 937.0 |
| 2012-12-09 23:00:00 | GC | Futures | 2351.0 | 2352.3 | 2350.7 | 2351.5 | 815.0 |
| 2012-12-09 18:00:00 | ZN | Futures | 118.922112 | 118.963839 | 118.908203 | 118.94993 | 3615.0 |
| 2012-12-09 19:00:00 | ZN | Futures | 118.94993 | 118.991657 | 118.936021 | 118.991657 | 6545.0 |
| 2012-12-09 20:00:00 | ZN | Futures | 118.977748 | 119.005566 | 118.977748 | 118.991657 | 2648.0 |
| 2012-12-09 21:00:00 | ZN | Futures | 118.977748 | 119.019475 | 118.963839 | 118.977748 | 12654.0 |
| 2012-12-09 22:00:00 | ZN | Futures | 118.963839 | 118.991657 | 118.963839 | 118.977748 | 2138.0 |
| 2012-12-09 23:00:00 | ZN | Futures | 118.991657 | 119.005566 | 118.977748 | 119.005566 | 2295.0 |
> showing 36 of 263 rows — these rows as CSV