PREVIEW / futures_daily / 2012-08-07
file: by_date/futures_daily/2012/2012-08-07.parquet size: 9 KB rows: 97
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-08-07 | ES | Futures | 1407.68 | 1421.1 | 1405.15 | 1414.77 | 1459898.0 |
| 2012-08-07 | NQ | Futures | 3084.9 | 3125.36 | 3083.18 | 3110.44 | 187004.0 |
| 2012-08-07 | YM | Futures | 12675.3 | 12767.5 | 12658.8 | 12727.7 | 75638.0 |
| 2012-08-07 | CL | Futures | 167.07 | 171.37 | 166.58 | 170.01 | 260012.0 |
| 2012-08-07 | GC | Futures | 2155.6 | 2164.7 | 2150.9 | 2153.3 | 86450.0 |
| 2012-08-07 | ZN | Futures | 116.821981 | 116.903694 | 116.304467 | 116.427036 | 877622.0 |
| 2012-08-07 | A6 | Futures | 0.94657 | 0.9499 | 0.94486 | 0.94558 | 89960.0 |
| 2012-08-07 | AD | Futures | 1.0013 | 1.00551 | 1.0005 | 1.00521 | 67345.0 |
| 2012-08-07 | B | Futures | 97.98 | 100.71 | 97.86 | 100.2 | 146618.0 |
| 2012-08-07 | B6 | Futures | 1.6303 | 1.6392 | 1.6264 | 1.6344 | 88612.0 |
| 2012-08-07 | BFX | Futures | 2781.8 | 2819.0 | 2781.8 | 2813.3 | 20.0 |
| 2012-08-07 | BR | Futures | 0.23444 | 0.2348 | 0.23415 | 0.23439 | 32.0 |
| 2012-08-07 | BZ | Futures | 104.44 | 106.1 | 104.38 | 105.6 | 2528.0 |
| 2012-08-07 | C | Futures | 1683.0 | 1703.0 | 1678.0 | 1702.0 | 4688.0 |
| 2012-08-07 | CB | Futures | 93.935 | 94.19 | 93.921 | 93.921 | 2.0 |
| 2012-08-07 | CC | Futures | 1817.0 | 1853.0 | 1817.0 | 1848.0 | 19318.0 |
| 2012-08-07 | CSC | Futures | 4.073 | 4.123 | 4.069 | 4.121 | 33.0 |
| 2012-08-07 | CT | Futures | 98.02 | 99.55 | 97.99 | 98.74 | 66.0 |
| 2012-08-07 | DC | Futures | 30.39 | 30.69 | 30.26 | 30.49 | 224.0 |
| 2012-08-07 | DX | Futures | 79.911 | 80.003 | 79.654 | 79.833 | 16553.0 |
| 2012-08-07 | E1 | Futures | 1.33377 | 1.3379 | 1.33144 | 1.33519 | 35524.0 |
| 2012-08-07 | E6 | Futures | 1.46295 | 1.46837 | 1.46047 | 1.46472 | 172830.0 |
| 2012-08-07 | E7 | Futures | 1.4539 | 1.4592 | 1.4516 | 1.4556 | 2723.0 |
| 2012-08-07 | ED | Futures | 95.1895 | 95.1991 | 95.1847 | 95.1895 | 115748.0 |
| 2012-08-07 | ER | Futures | 97.813 | 97.817 | 97.793 | 97.803 | 88338.0 |
| 2012-08-07 | EW | Futures | 960.7 | 975.1 | 958.7 | 969.2 | 20700.0 |
| 2012-08-07 | FBTP | Futures | 65.49 | 66.14 | 65.01 | 65.63 | 19023.0 |
| 2012-08-07 | FBTS | Futures | 87.246 | 87.246 | 86.071 | 86.46 | 5233.0 |
| 2012-08-07 | FCE | Futures | 2531.1 | 2581.4 | 2527.0 | 2570.9 | 113586.0 |
| 2012-08-07 | FDAX | Futures | 7544.2 | 7631.5 | 7529.5 | 7603.7 | 117132.0 |
| 2012-08-07 | FESX | Futures | 1620.4 | 1658.3 | 1617.0 | 1648.2 | 1355663.0 |
| 2012-08-07 | FGBL | Futures | 118.18 | 118.41 | 117.43 | 117.56 | 632298.0 |
| 2012-08-07 | FGBM | Futures | 116.22 | 116.32 | 115.89 | 115.96 | 357916.0 |
| 2012-08-07 | FGBS | Futures | 110.522 | 110.542 | 110.467 | 110.472 | 210531.0 |
| 2012-08-07 | FGBX | Futures | 126.24 | 127.0 | 124.68 | 125.04 | 5890.0 |
| 2012-08-07 | FOAT | Futures | 102.51 | 102.84 | 102.21 | 102.3 | 13545.0 |
| 2012-08-07 | FTDX | Futures | 738.9 | 743.1 | 736.6 | 742.1 | 204.0 |
| 2012-08-07 | FTI | Futures | 279.92 | 284.22 | 279.32 | 283.75 | 32322.0 |
| 2012-08-07 | FTUK | Futures | 4197.1 | 4231.0 | 4180.0 | 4218.2 | 88794.0 |
| 2012-08-07 | FVSA | Futures | 6568.06 | 6720.49 | 6471.07 | 6554.21 | 1262.0 |
| 2012-08-07 | FXXP | Futures | 190.5 | 192.8 | 190.2 | 192.2 | 4291.0 |
| 2012-08-07 | G | Futures | 100.63 | 100.63 | 99.67 | 99.83 | 141293.0 |
| 2012-08-07 | GF | Futures | 274.132 | 275.514 | 272.948 | 273.639 | 787.0 |
| 2012-08-07 | GSCI | Futures | 1037.62 | 1051.15 | 1037.62 | 1048.2 | 1424.0 |
| 2012-08-07 | HE | Futures | 93.523 | 94.141 | 92.565 | 92.596 | 17863.0 |
| 2012-08-07 | HG | Futures | 4.3518 | 4.4433 | 4.3415 | 4.4323 | 55622.0 |
| 2012-08-07 | HO | Futures | 2.3998 | 2.4598 | 2.3975 | 2.4512 | 52218.0 |
| 2012-08-07 | HRC | Futures | 2529.1 | 2529.1 | 2529.1 | 2529.1 | 0.0 |
| 2012-08-07 | J1 | Futures | 0.0160208 | 0.0160409 | 0.0159205 | 0.0159444 | 71756.0 |
| 2012-08-07 | J7 | Futures | 0.01596 | 0.015977 | 0.015861 | 0.015882 | 246.0 |
> showing 50 of 97 rows — these rows as CSV