PREVIEW / futures_daily / 2012-01-17
file: by_date/futures_daily/2012/2012-01-17.parquet size: 9 KB rows: 98
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2012-01-17 | ES | Futures | 1289.83 | 1307.15 | 1285.82 | 1293.85 | 1837834.0 |
| 2012-01-17 | NQ | Futures | 2707.18 | 2745.78 | 2700.6 | 2732.91 | 190236.0 |
| 2012-01-17 | YM | Futures | 11943.4 | 12102.0 | 11921.1 | 12011.1 | 100802.0 |
| 2012-01-17 | CL | Futures | 185.12 | 189.13 | 184.63 | 188.52 | 187135.0 |
| 2012-01-17 | GC | Futures | 2208.6 | 2252.1 | 2203.3 | 2235.3 | 193658.0 |
| 2012-01-17 | ZN | Futures | 113.691854 | 113.82688 | 113.354289 | 113.718859 | 840636.0 |
| 2012-01-17 | A6 | Futures | 0.90969 | 0.92357 | 0.90604 | 0.91663 | 157104.0 |
| 2012-01-17 | AD | Futures | 0.97893 | 0.99128 | 0.97743 | 0.98666 | 89377.0 |
| 2012-01-17 | B | Futures | 99.3 | 100.49 | 98.53 | 99.4 | 181172.0 |
| 2012-01-17 | B6 | Futures | 1.5979 | 1.6094 | 1.5966 | 1.6013 | 90528.0 |
| 2012-01-17 | BFX | Futures | 2573.7 | 2592.8 | 2573.7 | 2587.3 | 436.0 |
| 2012-01-17 | BR | Futures | 0.25979 | 0.2618 | 0.25921 | 0.26075 | 394.0 |
| 2012-01-17 | BZ | Futures | 105.46 | 106.58 | 104.61 | 105.48 | 858.0 |
| 2012-01-17 | C | Futures | 1533.0 | 1536.0 | 1499.0 | 1533.0 | 5045.0 |
| 2012-01-17 | CB | Futures | 89.212 | 89.212 | 88.27 | 88.404 | 67.0 |
| 2012-01-17 | CC | Futures | 1757.0 | 1773.0 | 1729.0 | 1760.0 | 10111.0 |
| 2012-01-17 | CSC | Futures | 3.981 | 3.983 | 3.981 | 3.983 | 13.0 |
| 2012-01-17 | CT | Futures | 123.57 | 128.11 | 123.22 | 126.46 | 18701.0 |
| 2012-01-17 | DC | Futures | 29.17 | 29.18 | 28.9 | 29.0 | 384.0 |
| 2012-01-17 | DX | Futures | 79.491 | 79.5 | 78.848 | 79.256 | 20211.0 |
| 2012-01-17 | E1 | Futures | 1.37564 | 1.3906 | 1.37262 | 1.38246 | 39132.0 |
| 2012-01-17 | E6 | Futures | 1.5111 | 1.53238 | 1.50943 | 1.5209 | 373270.0 |
| 2012-01-17 | E7 | Futures | 1.4976 | 1.5181 | 1.4957 | 1.507 | 6026.0 |
| 2012-01-17 | EBM | Futures | 262.07 | 263.05 | 259.78 | 262.07 | 10440.0 |
| 2012-01-17 | ED | Futures | 95.0725 | 95.0963 | 95.0581 | 95.0772 | 288296.0 |
| 2012-01-17 | ER | Futures | 97.415 | 97.42 | 97.381 | 97.381 | 120605.0 |
| 2012-01-17 | EW | Futures | 911.5 | 924.7 | 907.3 | 913.8 | 18036.0 |
| 2012-01-17 | FBTP | Futures | 59.95 | 60.5 | 59.88 | 60.21 | 9110.0 |
| 2012-01-17 | FBTS | Futures | 81.743 | 82.121 | 81.735 | 81.888 | 754.0 |
| 2012-01-17 | FCE | Futures | 2307.5 | 2344.9 | 2307.5 | 2327.8 | 111873.0 |
| 2012-01-17 | FDAX | Futures | 6932.9 | 7011.3 | 6921.3 | 6987.5 | 152302.0 |
| 2012-01-17 | FESX | Futures | 1589.8 | 1609.9 | 1585.8 | 1596.5 | 1138871.0 |
| 2012-01-17 | FEU3 | Futures | 97.949 | 97.949 | 97.935 | 97.935 | 210.0 |
| 2012-01-17 | FGBL | Futures | 113.07 | 113.2 | 112.68 | 113.04 | 630859.0 |
| 2012-01-17 | FGBM | Futures | 113.58 | 113.65 | 113.36 | 113.49 | 324923.0 |
| 2012-01-17 | FGBS | Futures | 109.934 | 109.949 | 109.889 | 109.899 | 295874.0 |
| 2012-01-17 | FGBX | Futures | 119.38 | 119.57 | 118.44 | 118.83 | 4923.0 |
| 2012-01-17 | FTDX | Futures | 677.2 | 680.4 | 674.4 | 679.0 | 382.0 |
| 2012-01-17 | FTI | Futures | 262.85 | 265.66 | 261.43 | 263.27 | 17048.0 |
| 2012-01-17 | FTUK | Futures | 4055.7 | 4100.1 | 4053.2 | 4075.9 | 95856.0 |
| 2012-01-17 | FVSA | Futures | 11523.78 | 11523.78 | 11331.72 | 11427.75 | 1955.0 |
| 2012-01-17 | FXXP | Futures | 178.0 | 179.2 | 177.7 | 178.4 | 1481.0 |
| 2012-01-17 | G | Futures | 94.97 | 95.25 | 94.65 | 95.1 | 133858.0 |
| 2012-01-17 | GF | Futures | 324.363 | 325.477 | 323.144 | 323.144 | 2712.0 |
| 2012-01-17 | GSCI | Futures | 1032.38 | 1034.1 | 1027.84 | 1034.1 | 703.0 |
| 2012-01-17 | HE | Futures | 105.774 | 106.328 | 105.373 | 105.743 | 16855.0 |
| 2012-01-17 | HG | Futures | 4.7932 | 4.9581 | 4.7405 | 4.9192 | 64232.0 |
| 2012-01-17 | HO | Futures | 2.4505 | 2.4983 | 2.4392 | 2.4549 | 46771.0 |
| 2012-01-17 | HRC | Futures | 2876.8 | 2876.8 | 2876.8 | 2876.8 | 0.0 |
| 2012-01-17 | J1 | Futures | 0.0163398 | 0.0164176 | 0.0163322 | 0.0163548 | 86445.0 |
> showing 50 of 98 rows — these rows as CSV