PREVIEW / futures_daily / 2012-02-01
file: by_date/futures_daily/2012/2012-02-01.parquet size: 9 KB rows: 99
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-02-01 | ES | Futures | 1312.41 | 1331.73 | 1308.4 | 1324.46 | 1904608.0 |
| 2012-02-01 | NQ | Futures | 2807.53 | 2852.42 | 2805.81 | 2844.7 | 206687.0 |
| 2012-02-01 | YM | Futures | 12164.8 | 12315.7 | 12136.8 | 12236.4 | 100929.0 |
| 2012-02-01 | CL | Futures | 183.86 | 185.94 | 181.49 | 182.42 | 293554.0 |
| 2012-02-01 | GC | Futures | 2329.8 | 2348.8 | 2323.9 | 2342.8 | 124538.0 |
| 2012-02-01 | ZN | Futures | 114.312973 | 114.312973 | 114.002414 | 114.056424 | 1018737.0 |
| 2012-02-01 | A6 | Futures | 0.94057 | 0.95098 | 0.93576 | 0.94697 | 137510.0 |
| 2012-02-01 | AD | Futures | 0.99991 | 1.00633 | 0.9978 | 1.00412 | 76822.0 |
| 2012-02-01 | B | Futures | 98.86 | 100.11 | 98.65 | 99.05 | 105833.0 |
| 2012-02-01 | B6 | Futures | 1.6477 | 1.66 | 1.6412 | 1.6547 | 107035.0 |
| 2012-02-01 | BFX | Futures | 2714.5 | 2719.2 | 2714.5 | 2719.2 | 2.0 |
| 2012-02-01 | BR | Futures | 0.26882 | 0.26882 | 0.26822 | 0.26829 | 134.0 |
| 2012-02-01 | BZ | Futures | 105.35 | 106.63 | 105.31 | 105.55 | 1206.0 |
| 2012-02-01 | C | Futures | 1538.0 | 1551.0 | 1470.0 | 1471.0 | 10039.0 |
| 2012-02-01 | CB | Futures | 83.964 | 83.964 | 83.426 | 83.426 | 16.0 |
| 2012-02-01 | CC | Futures | 1776.0 | 1805.0 | 1721.0 | 1725.0 | 14838.0 |
| 2012-02-01 | CSC | Futures | 3.854 | 3.854 | 3.83 | 3.83 | 54.0 |
| 2012-02-01 | CT | Futures | 120.5 | 121.34 | 120.04 | 120.28 | 12473.0 |
| 2012-02-01 | DC | Futures | 27.81 | 27.89 | 27.19 | 27.27 | 478.0 |
| 2012-02-01 | DX | Futures | 77.359 | 77.539 | 76.644 | 76.924 | 34783.0 |
| 2012-02-01 | E1 | Futures | 1.42762 | 1.44153 | 1.42013 | 1.43444 | 29186.0 |
| 2012-02-01 | E6 | Futures | 1.56501 | 1.58031 | 1.55712 | 1.57278 | 348285.0 |
| 2012-02-01 | E7 | Futures | 1.5503 | 1.566 | 1.5429 | 1.5584 | 6084.0 |
| 2012-02-01 | EBM | Futures | 286.64 | 290.24 | 283.69 | 284.02 | 11591.0 |
| 2012-02-01 | ED | Futures | 95.1011 | 95.1298 | 95.1011 | 95.1202 | 219223.0 |
| 2012-02-01 | ER | Futures | 97.459 | 97.503 | 97.449 | 97.484 | 119794.0 |
| 2012-02-01 | EW | Futures | 939.7 | 960.8 | 937.3 | 958.7 | 22405.0 |
| 2012-02-01 | FBTP | Futures | 63.07 | 64.48 | 62.84 | 64.36 | 18695.0 |
| 2012-02-01 | FBTS | Futures | 83.485 | 84.368 | 83.485 | 84.344 | 1921.0 |
| 2012-02-01 | FCE | Futures | 2360.2 | 2403.6 | 2354.5 | 2396.5 | 93469.0 |
| 2012-02-01 | FDAX | Futures | 7150.4 | 7328.2 | 7139.9 | 7301.2 | 166840.0 |
| 2012-02-01 | FESX | Futures | 1619.9 | 1658.7 | 1617.9 | 1651.3 | 1148504.0 |
| 2012-02-01 | FEU3 | Futures | 98.048 | 98.053 | 98.038 | 98.038 | 555.0 |
| 2012-02-01 | FGBL | Futures | 113.09 | 113.11 | 112.48 | 112.68 | 703181.0 |
| 2012-02-01 | FGBM | Futures | 113.68 | 113.73 | 113.44 | 113.49 | 419202.0 |
| 2012-02-01 | FGBS | Futures | 109.964 | 109.969 | 109.914 | 109.924 | 345067.0 |
| 2012-02-01 | FGBX | Futures | 117.92 | 117.99 | 117.01 | 117.53 | 8151.0 |
| 2012-02-01 | FTDX | Futures | 693.0 | 703.2 | 691.1 | 699.9 | 223.0 |
| 2012-02-01 | FTI | Futures | 266.24 | 271.89 | 266.24 | 271.14 | 39408.0 |
| 2012-02-01 | FTUK | Futures | 4087.8 | 4155.3 | 4070.5 | 4146.2 | 100782.0 |
| 2012-02-01 | FVSA | Futures | 10429.02 | 10429.02 | 10006.48 | 10025.69 | 1402.0 |
| 2012-02-01 | FXXP | Futures | 180.2 | 183.2 | 180.2 | 182.9 | 2204.0 |
| 2012-02-01 | G | Futures | 95.05 | 95.11 | 94.39 | 94.57 | 179990.0 |
| 2012-02-01 | GF | Futures | 329.771 | 331.256 | 328.075 | 330.513 | 3232.0 |
| 2012-02-01 | GSCI | Futures | 1040.35 | 1043.17 | 1031.75 | 1032.92 | 186.0 |
| 2012-02-01 | HE | Futures | 107.435 | 109.459 | 107.374 | 109.187 | 25727.0 |
| 2012-02-01 | HG | Futures | 5.0003 | 5.0755 | 4.9634 | 5.0676 | 47105.0 |
| 2012-02-01 | HO | Futures | 2.4744 | 2.4995 | 2.4562 | 2.4647 | 65774.0 |
| 2012-02-01 | HRC | Futures | 2837.4 | 2837.4 | 2837.4 | 2837.4 | 0.0 |
| 2012-02-01 | J1 | Futures | 0.0164691 | 0.0165243 | 0.016454 | 0.0164816 | 65221.0 |
> showing 50 of 99 rows — these rows as CSV