PREVIEW / futures_daily / 2011-05-12
file: by_date/futures_daily/2011/2011-05-12.parquet size: 9 KB rows: 94
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-05-12 | ES | Futures | 1325.87 | 1335.28 | 1315.48 | 1334.04 | 2254909.0 |
| 2011-05-12 | NQ | Futures | 2726.21 | 2743.86 | 2698.02 | 2741.3 | 288507.0 |
| 2011-05-12 | YM | Futures | 11843.4 | 11928.0 | 11756.0 | 11913.9 | 134107.0 |
| 2011-05-12 | CL | Futures | 189.99 | 193.65 | 183.55 | 190.72 | 522503.0 |
| 2011-05-12 | GC | Futures | 2029.2 | 2043.4 | 1999.9 | 2039.5 | 207428.0 |
| 2011-05-12 | ZN | Futures | 103.159838 | 103.383698 | 102.830633 | 102.962315 | 1350916.0 |
| 2011-05-12 | A6 | Futures | 0.91445 | 0.91531 | 0.9027 | 0.91034 | 160354.0 |
| 2011-05-12 | AD | Futures | 1.03546 | 1.03635 | 1.0262 | 1.03297 | 112038.0 |
| 2011-05-12 | B | Futures | 95.56 | 96.67 | 93.0 | 95.33 | 225657.0 |
| 2011-05-12 | B6 | Futures | 1.6981 | 1.7012 | 1.686 | 1.6911 | 154745.0 |
| 2011-05-12 | BFX | Futures | 3201.5 | 3213.0 | 3201.5 | 3207.9 | 14.0 |
| 2011-05-12 | BR | Futures | 0.26908 | 0.2704 | 0.26908 | 0.27014 | 625.0 |
| 2011-05-12 | BZ | Futures | 99.49 | 100.86 | 98.29 | 100.45 | 1169.0 |
| 2011-05-12 | C | Futures | 2078.0 | 2091.0 | 2019.0 | 2038.0 | 26463.0 |
| 2011-05-12 | CB | Futures | 116.162 | 116.162 | 116.162 | 116.162 | 12.0 |
| 2011-05-12 | CC | Futures | 2469.0 | 2475.0 | 2383.0 | 2418.0 | 7541.0 |
| 2011-05-12 | CSC | Futures | 4.258 | 4.314 | 4.212 | 4.304 | 3.0 |
| 2011-05-12 | CT | Futures | 150.06 | 150.37 | 142.82 | 142.82 | 8057.0 |
| 2011-05-12 | DC | Futures | 28.74 | 29.33 | 28.57 | 29.27 | 257.0 |
| 2011-05-12 | DX | Futures | 75.118 | 75.457 | 74.83 | 75.041 | 39052.0 |
| 2011-05-12 | E1 | Futures | 1.47713 | 1.4838 | 1.47045 | 1.47975 | 37710.0 |
| 2011-05-12 | E6 | Futures | 1.6808 | 1.68992 | 1.67191 | 1.68423 | 369384.0 |
| 2011-05-12 | E7 | Futures | 1.6686 | 1.6773 | 1.6592 | 1.6717 | 6790.0 |
| 2011-05-12 | ED | Futures | 94.9597 | 94.9644 | 94.9549 | 94.9597 | 132714.0 |
| 2011-05-12 | ER | Futures | 97.286 | 97.296 | 97.277 | 97.286 | 164273.0 |
| 2011-05-12 | EW | Futures | 991.3 | 1000.1 | 980.1 | 997.5 | 26740.0 |
| 2011-05-12 | FBTP | Futures | 64.99 | 65.32 | 64.99 | 65.31 | 5774.0 |
| 2011-05-12 | FCE | Futures | 2744.0 | 2760.6 | 2719.3 | 2741.6 | 66779.0 |
| 2011-05-12 | FDAX | Futures | 7959.6 | 8013.5 | 7865.7 | 7958.0 | 163730.0 |
| 2011-05-12 | FESX | Futures | 1849.7 | 1860.6 | 1831.2 | 1847.8 | 1499550.0 |
| 2011-05-12 | FEU3 | Futures | 97.83 | 97.84 | 97.83 | 97.83 | 75.0 |
| 2011-05-12 | FGBL | Futures | 99.39 | 99.61 | 99.14 | 99.46 | 1043058.0 |
| 2011-05-12 | FGBM | Futures | 103.87 | 104.08 | 103.74 | 103.98 | 661894.0 |
| 2011-05-12 | FGBS | Futures | 106.543 | 106.622 | 106.498 | 106.573 | 753180.0 |
| 2011-05-12 | FGBX | Futures | 96.23 | 96.68 | 95.73 | 96.3 | 4290.0 |
| 2011-05-12 | FTDX | Futures | 821.7 | 828.8 | 818.5 | 822.6 | 1226.0 |
| 2011-05-12 | FTI | Futures | 293.29 | 294.52 | 291.4 | 293.16 | 342.0 |
| 2011-05-12 | FTUK | Futures | 4151.1 | 4174.2 | 4103.9 | 4148.0 | 108241.0 |
| 2011-05-12 | FXXP | Futures | 186.3 | 187.5 | 186.2 | 187.1 | 2592.0 |
| 2011-05-12 | G | Futures | 83.35 | 83.74 | 83.32 | 83.64 | 181669.0 |
| 2011-05-12 | GF | Futures | 309.676 | 312.058 | 305.958 | 311.245 | 3206.0 |
| 2011-05-12 | GSCI | Futures | 1068.42 | 1077.27 | 1042.44 | 1067.56 | 2747.0 |
| 2011-05-12 | HE | Futures | 99.143 | 100.123 | 98.799 | 99.752 | 24508.0 |
| 2011-05-12 | HG | Futures | 5.1973 | 5.3056 | 5.1196 | 5.275 | 47791.0 |
| 2011-05-12 | HO | Futures | 2.4155 | 2.452 | 2.3664 | 2.4211 | 64838.0 |
| 2011-05-12 | HRC | Futures | 3077.0 | 3077.0 | 3077.0 | 3077.0 | 0.0 |
| 2011-05-12 | J1 | Futures | 0.0154865 | 0.0155732 | 0.0154463 | 0.015528 | 112211.0 |
| 2011-05-12 | J7 | Futures | 0.015407 | 0.015475 | 0.015354 | 0.015433 | 463.0 |
| 2011-05-12 | JB | Futures | 122.52 | 122.65 | 122.49 | 122.61 | 46.0 |
| 2011-05-12 | KC | Futures | 656.21 | 663.76 | 649.61 | 659.33 | 12378.0 |
> showing 50 of 94 rows — these rows as CSV