PREVIEW / futures_daily / 2011-09-07
file: by_date/futures_daily/2011/2011-09-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 |
|---|---|---|---|---|---|---|---|
| 2011-09-07 | ES | Futures | 1156.5 | 1191.51 | 1155.76 | 1190.77 | 2595150.0 |
| 2011-09-07 | NQ | Futures | 2465.98 | 2533.17 | 2465.13 | 2530.32 | 252548.0 |
| 2011-09-07 | YM | Futures | 10518.6 | 10795.6 | 10514.8 | 10791.8 | 103903.0 |
| 2011-09-07 | CL | Futures | 164.77 | 172.35 | 164.1 | 170.18 | 313728.0 |
| 2011-09-07 | GC | Futures | 2532.9 | 2542.6 | 2421.9 | 2454.0 | 316257.0 |
| 2011-09-07 | ZN | Futures | 111.668633 | 111.681938 | 111.269484 | 111.455754 | 22216.0 |
| 2011-09-07 | A6 | Futures | 0.91117 | 0.92622 | 0.91039 | 0.92483 | 85061.0 |
| 2011-09-07 | AD | Futures | 1.00754 | 1.01483 | 1.00634 | 1.01213 | 78184.0 |
| 2011-09-07 | B | Futures | 96.43 | 99.09 | 95.9 | 98.51 | 116510.0 |
| 2011-09-07 | B6 | Futures | 1.6584 | 1.6684 | 1.6555 | 1.6619 | 104857.0 |
| 2011-09-07 | BFX | Futures | 2586.0 | 2612.1 | 2580.0 | 2612.1 | 4.0 |
| 2011-09-07 | BR | Futures | 0.26732 | 0.26863 | 0.2665 | 0.26863 | 59.0 |
| 2011-09-07 | BZ | Futures | 99.49 | 102.04 | 99.49 | 102.04 | 1158.0 |
| 2011-09-07 | C | Futures | 2034.0 | 2044.0 | 2002.0 | 2002.0 | 2489.0 |
| 2011-09-07 | CB | Futures | 98.628 | 98.628 | 98.628 | 98.628 | 6.0 |
| 2011-09-07 | CC | Futures | 2344.0 | 2352.0 | 2301.0 | 2316.0 | 11389.0 |
| 2011-09-07 | CSC | Futures | 4.434 | 4.434 | 4.412 | 4.412 | 16.0 |
| 2011-09-07 | CT | Futures | 138.62 | 143.06 | 138.62 | 143.06 | 42.0 |
| 2011-09-07 | DC | Futures | 30.55 | 30.58 | 30.18 | 30.18 | 84.0 |
| 2011-09-07 | DX | Futures | 75.207 | 75.232 | 74.593 | 74.837 | 32055.0 |
| 2011-09-07 | E1 | Futures | 1.51737 | 1.53202 | 1.51698 | 1.52482 | 26913.0 |
| 2011-09-07 | E6 | Futures | 1.66276 | 1.68046 | 1.66169 | 1.67333 | 286012.0 |
| 2011-09-07 | E7 | Futures | 1.6505 | 1.6681 | 1.6498 | 1.6611 | 4400.0 |
| 2011-09-07 | ED | Futures | 94.9311 | 94.9406 | 94.9239 | 94.9358 | 137839.0 |
| 2011-09-07 | ER | Futures | 97.554 | 97.554 | 97.529 | 97.534 | 146322.0 |
| 2011-09-07 | EW | Futures | 818.1 | 851.0 | 818.1 | 849.5 | 34341.0 |
| 2011-09-07 | FBTP | Futures | 62.49 | 63.85 | 62.49 | 63.79 | 14698.0 |
| 2011-09-07 | FBTS | Futures | 81.566 | 82.313 | 81.566 | 82.208 | 4349.0 |
| 2011-09-07 | FCE | Futures | 2125.3 | 2171.6 | 2116.5 | 2156.2 | 109277.0 |
| 2011-09-07 | FDAX | Futures | 5679.7 | 5827.6 | 5638.5 | 5770.5 | 187025.0 |
| 2011-09-07 | FESX | Futures | 1364.3 | 1390.6 | 1355.9 | 1378.4 | 1667858.0 |
| 2011-09-07 | FEU3 | Futures | 98.079 | 98.079 | 98.069 | 98.074 | 7.0 |
| 2011-09-07 | FGBL | Futures | 110.32 | 110.54 | 109.95 | 110.16 | 942473.0 |
| 2011-09-07 | FGBM | Futures | 110.67 | 110.85 | 110.5 | 110.66 | 665866.0 |
| 2011-09-07 | FGBS | Futures | 109.178 | 109.203 | 109.079 | 109.113 | 786432.0 |
| 2011-09-07 | FGBX | Futures | 109.14 | 109.52 | 108.22 | 108.95 | 11840.0 |
| 2011-09-07 | FTDX | Futures | 625.6 | 643.0 | 625.6 | 638.1 | 234.0 |
| 2011-09-07 | FTI | Futures | 228.05 | 230.83 | 225.89 | 229.56 | 38417.0 |
| 2011-09-07 | FTUK | Futures | 3670.8 | 3781.2 | 3670.8 | 3755.1 | 122233.0 |
| 2011-09-07 | FVSA | Futures | 16668.55 | 16668.55 | 15872.96 | 15911.77 | 1666.0 |
| 2011-09-07 | FXXP | Futures | 153.4 | 155.2 | 152.5 | 154.9 | 4955.0 |
| 2011-09-07 | G | Futures | 91.27 | 91.7 | 91.12 | 91.34 | 141003.0 |
| 2011-09-07 | GF | Futures | 306.47 | 307.271 | 306.012 | 306.642 | 1208.0 |
| 2011-09-07 | GSCI | Futures | 1038.87 | 1054.61 | 1037.69 | 1049.99 | 255.0 |
| 2011-09-07 | HE | Futures | 102.107 | 104.214 | 101.802 | 103.634 | 21355.0 |
| 2011-09-07 | HG | Futures | 5.3745 | 5.4903 | 5.3732 | 5.4678 | 26923.0 |
| 2011-09-07 | HO | Futures | 2.4402 | 2.4937 | 2.4321 | 2.4858 | 15583.0 |
| 2011-09-07 | HRC | Futures | 2910.3 | 2910.3 | 2910.3 | 2910.3 | 0.0 |
| 2011-09-07 | J1 | Futures | 0.0162054 | 0.0163122 | 0.0161727 | 0.0162557 | 94329.0 |
| 2011-09-07 | J7 | Futures | 0.016091 | 0.016202 | 0.016068 | 0.016147 | 487.0 |
> showing 50 of 97 rows — these rows as CSV