PREVIEW / futures_daily / 2012-01-30
file: by_date/futures_daily/2012/2012-01-30.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-30 | ES | Futures | 1318.69 | 1319.19 | 1300.62 | 1313.67 | 1710571.0 |
| 2012-01-30 | NQ | Futures | 2813.25 | 2819.54 | 2778.08 | 2815.53 | 182360.0 |
| 2012-01-30 | YM | Futures | 12209.3 | 12222.9 | 12065.2 | 12187.1 | 99401.0 |
| 2012-01-30 | CL | Futures | 186.89 | 186.98 | 183.96 | 184.61 | 215829.0 |
| 2012-01-30 | GC | Futures | 2329.5 | 2333.8 | 2301.7 | 2322.6 | 133373.0 |
| 2012-01-30 | ZN | Futures | 113.82688 | 114.258963 | 113.813377 | 114.096932 | 903283.0 |
| 2012-01-30 | A6 | Futures | 0.94128 | 0.94306 | 0.93167 | 0.9379 | 115434.0 |
| 2012-01-30 | AD | Futures | 1.00101 | 1.00131 | 0.99559 | 0.99971 | 64343.0 |
| 2012-01-30 | B | Futures | 98.85 | 99.29 | 97.94 | 98.39 | 68575.0 |
| 2012-01-30 | B6 | Futures | 1.6435 | 1.6436 | 1.6357 | 1.6404 | 68072.0 |
| 2012-01-30 | BFX | Futures | 2677.9 | 2682.9 | 2638.8 | 2641.2 | 31.0 |
| 2012-01-30 | BR | Futures | 0.26531 | 0.26531 | 0.26531 | 0.26531 | 1133.0 |
| 2012-01-30 | BZ | Futures | 105.5 | 105.74 | 104.43 | 104.85 | 315.0 |
| 2012-01-30 | C | Futures | 1556.0 | 1562.0 | 1515.0 | 1518.0 | 6648.0 |
| 2012-01-30 | CB | Futures | 83.964 | 84.502 | 83.856 | 84.098 | 4.0 |
| 2012-01-30 | CC | Futures | 1829.0 | 1829.0 | 1763.0 | 1768.0 | 12502.0 |
| 2012-01-30 | CSC | Futures | 3.903 | 3.903 | 3.883 | 3.891 | 29.0 |
| 2012-01-30 | CT | Futures | 123.17 | 124.03 | 121.21 | 121.26 | 13422.0 |
| 2012-01-30 | DC | Futures | 28.02 | 28.06 | 27.79 | 28.02 | 509.0 |
| 2012-01-30 | DX | Futures | 76.853 | 77.447 | 76.853 | 77.186 | 22345.0 |
| 2012-01-30 | E1 | Futures | 1.4389 | 1.43943 | 1.4263 | 1.43037 | 26474.0 |
| 2012-01-30 | E6 | Futures | 1.57995 | 1.58067 | 1.56321 | 1.56895 | 218465.0 |
| 2012-01-30 | E7 | Futures | 1.5652 | 1.566 | 1.5492 | 1.5546 | 4299.0 |
| 2012-01-30 | EBM | Futures | 273.54 | 274.52 | 272.23 | 273.87 | 8168.0 |
| 2012-01-30 | ED | Futures | 95.082 | 95.0868 | 95.0581 | 95.0772 | 184504.0 |
| 2012-01-30 | ER | Futures | 97.4 | 97.42 | 97.39 | 97.41 | 67899.0 |
| 2012-01-30 | EW | Futures | 947.4 | 948.0 | 932.5 | 941.8 | 20859.0 |
| 2012-01-30 | FBTP | Futures | 63.03 | 63.04 | 61.77 | 62.38 | 20149.0 |
| 2012-01-30 | FBTS | Futures | 83.172 | 83.172 | 82.546 | 82.915 | 1632.0 |
| 2012-01-30 | FCE | Futures | 2350.2 | 2350.5 | 2320.6 | 2323.1 | 86043.0 |
| 2012-01-30 | FDAX | Futures | 7169.2 | 7174.2 | 7085.3 | 7123.9 | 126553.0 |
| 2012-01-30 | FESX | Futures | 1620.6 | 1621.9 | 1602.5 | 1609.2 | 865884.0 |
| 2012-01-30 | FGBL | Futures | 112.69 | 113.11 | 112.58 | 113.03 | 503534.0 |
| 2012-01-30 | FGBM | Futures | 113.47 | 113.63 | 113.37 | 113.56 | 293691.0 |
| 2012-01-30 | FGBS | Futures | 109.919 | 109.949 | 109.899 | 109.934 | 232966.0 |
| 2012-01-30 | FGBX | Futures | 116.97 | 118.01 | 116.31 | 117.68 | 4828.0 |
| 2012-01-30 | FTDX | Futures | 687.4 | 690.7 | 683.2 | 684.1 | 139.0 |
| 2012-01-30 | FTI | Futures | 265.03 | 265.11 | 262.27 | 263.48 | 38193.0 |
| 2012-01-30 | FTUK | Futures | 4101.5 | 4101.5 | 4046.3 | 4057.2 | 90863.0 |
| 2012-01-30 | FVSA | Futures | 10409.81 | 10947.59 | 10409.81 | 10678.7 | 1911.0 |
| 2012-01-30 | FXXP | Futures | 178.7 | 179.2 | 177.6 | 178.1 | 830.0 |
| 2012-01-30 | G | Futures | 94.58 | 95.08 | 94.49 | 94.95 | 116521.0 |
| 2012-01-30 | GF | Futures | 327.756 | 328.34 | 325.583 | 327.332 | 2418.0 |
| 2012-01-30 | GSCI | Futures | 1038.79 | 1039.73 | 1031.51 | 1035.35 | 65.0 |
| 2012-01-30 | HE | Futures | 105.078 | 105.894 | 104.595 | 105.32 | 10245.0 |
| 2012-01-30 | HG | Futures | 5.1362 | 5.1362 | 5.0082 | 5.0471 | 45591.0 |
| 2012-01-30 | HO | Futures | 2.4942 | 2.4946 | 2.4511 | 2.4584 | 70026.0 |
| 2012-01-30 | HRC | Futures | 2857.1 | 2857.1 | 2857.1 | 2857.1 | 0.0 |
| 2012-01-30 | J1 | Futures | 0.0163674 | 0.0164854 | 0.0163611 | 0.0164666 | 80872.0 |
| 2012-01-30 | J7 | Futures | 0.0163 | 0.016416 | 0.016296 | 0.016398 | 390.0 |
> showing 50 of 98 rows — these rows as CSV