PREVIEW / futures_daily / 2011-05-13
file: by_date/futures_daily/2011/2011-05-13.parquet size: 9 KB rows: 92
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-13 | ES | Futures | 1333.79 | 1338.99 | 1317.21 | 1320.67 | 2235430.0 |
| 2011-05-13 | NQ | Futures | 2742.44 | 2749.56 | 2698.02 | 2699.16 | 300837.0 |
| 2011-05-13 | YM | Futures | 11914.9 | 11952.5 | 11758.8 | 11804.9 | 126384.0 |
| 2011-05-13 | CL | Futures | 190.42 | 194.06 | 187.1 | 192.03 | 367717.0 |
| 2011-05-13 | GC | Futures | 2039.1 | 2052.5 | 2005.9 | 2021.6 | 184884.0 |
| 2011-05-13 | ZN | Futures | 102.975483 | 103.633894 | 102.870137 | 103.238848 | 1456846.0 |
| 2011-05-13 | A6 | Futures | 0.91154 | 0.91574 | 0.89867 | 0.90416 | 142976.0 |
| 2011-05-13 | AD | Futures | 1.03356 | 1.03595 | 1.02102 | 1.02769 | 119273.0 |
| 2011-05-13 | B | Futures | 95.44 | 96.95 | 94.29 | 96.14 | 187849.0 |
| 2011-05-13 | B6 | Futures | 1.6917 | 1.6936 | 1.6766 | 1.6797 | 128750.0 |
| 2011-05-13 | BR | Futures | 0.26943 | 0.26943 | 0.26666 | 0.26853 | 2610.0 |
| 2011-05-13 | BZ | Futures | 100.9 | 101.3 | 100.0 | 101.3 | 333.0 |
| 2011-05-13 | C | Futures | 2044.0 | 2060.0 | 2026.0 | 2035.0 | 3749.0 |
| 2011-05-13 | CB | Futures | 115.869 | 116.162 | 115.869 | 116.162 | 20.0 |
| 2011-05-13 | CC | Futures | 2423.0 | 2441.0 | 2380.0 | 2390.0 | 7541.0 |
| 2011-05-13 | CT | Futures | 141.54 | 146.97 | 140.61 | 143.66 | 8057.0 |
| 2011-05-13 | DC | Futures | 29.17 | 29.46 | 29.05 | 29.21 | 131.0 |
| 2011-05-13 | DX | Futures | 75.039 | 75.76 | 74.571 | 75.559 | 45751.0 |
| 2011-05-13 | E1 | Futures | 1.48066 | 1.48865 | 1.46351 | 1.46796 | 41755.0 |
| 2011-05-13 | E6 | Futures | 1.68565 | 1.69738 | 1.66492 | 1.67014 | 390026.0 |
| 2011-05-13 | E7 | Futures | 1.6731 | 1.6847 | 1.6527 | 1.6577 | 7064.0 |
| 2011-05-13 | ED | Futures | 94.9597 | 94.9644 | 94.9549 | 94.9597 | 144221.0 |
| 2011-05-13 | ER | Futures | 97.281 | 97.286 | 97.262 | 97.281 | 103692.0 |
| 2011-05-13 | EW | Futures | 997.5 | 1002.4 | 984.3 | 984.6 | 23824.0 |
| 2011-05-13 | FBTP | Futures | 65.17 | 65.34 | 65.03 | 65.18 | 9490.0 |
| 2011-05-13 | FCE | Futures | 2760.0 | 2768.6 | 2721.8 | 2738.8 | 1784.0 |
| 2011-05-13 | FDAX | Futures | 8008.2 | 8029.6 | 7855.5 | 7913.2 | 157570.0 |
| 2011-05-13 | FESX | Futures | 1858.1 | 1867.7 | 1821.6 | 1837.6 | 1362828.0 |
| 2011-05-13 | FEU3 | Futures | 97.815 | 97.825 | 97.815 | 97.825 | 285.0 |
| 2011-05-13 | FGBL | Futures | 99.21 | 99.72 | 99.08 | 99.56 | 955846.0 |
| 2011-05-13 | FGBM | Futures | 103.8 | 104.08 | 103.68 | 103.98 | 592457.0 |
| 2011-05-13 | FGBS | Futures | 106.508 | 106.588 | 106.444 | 106.538 | 601471.0 |
| 2011-05-13 | FGBX | Futures | 95.82 | 96.85 | 95.64 | 96.61 | 3478.0 |
| 2011-05-13 | FTDX | Futures | 829.7 | 831.9 | 825.7 | 829.7 | 1019.0 |
| 2011-05-13 | FTI | Futures | 293.9 | 294.11 | 289.43 | 291.28 | 286.0 |
| 2011-05-13 | FTUK | Futures | 4160.6 | 4188.9 | 4108.1 | 4133.3 | 105345.0 |
| 2011-05-13 | FXXP | Futures | 188.2 | 188.8 | 186.5 | 186.7 | 1662.0 |
| 2011-05-13 | G | Futures | 83.46 | 83.77 | 83.37 | 83.67 | 83608.0 |
| 2011-05-13 | GF | Futures | 310.606 | 312.407 | 307.701 | 307.817 | 2276.0 |
| 2011-05-13 | GSCI | Futures | 1073.9 | 1080.16 | 1055.59 | 1070.46 | 907.0 |
| 2011-05-13 | HE | Futures | 100.149 | 100.414 | 99.329 | 100.123 | 20510.0 |
| 2011-05-13 | HG | Futures | 5.2764 | 5.3767 | 5.2485 | 5.2923 | 42049.0 |
| 2011-05-13 | HO | Futures | 2.4197 | 2.4594 | 2.3995 | 2.4447 | 43335.0 |
| 2011-05-13 | HRC | Futures | 3077.0 | 3077.0 | 3077.0 | 3077.0 | 0.0 |
| 2011-05-13 | J1 | Futures | 0.0155154 | 0.0156398 | 0.015494 | 0.0155418 | 116693.0 |
| 2011-05-13 | J7 | Futures | 0.01542 | 0.015543 | 0.0154 | 0.015447 | 562.0 |
| 2011-05-13 | JB | Futures | 122.52 | 122.66 | 122.48 | 122.58 | 2.0 |
| 2011-05-13 | KC | Futures | 663.76 | 666.64 | 644.22 | 646.02 | 12378.0 |
| 2011-05-13 | KE | Futures | 3464.85 | 3516.19 | 3403.63 | 3434.24 | 16375.0 |
| 2011-05-13 | L | Futures | 98.433 | 98.443 | 98.423 | 98.433 | 26523.0 |
> showing 50 of 92 rows — these rows as CSV