PREVIEW / futures_daily / 2011-04-13
file: by_date/futures_daily/2011/2011-04-13.parquet size: 9 KB rows: 93
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-04-13 | ES | Futures | 1295.18 | 1305.58 | 1291.96 | 1295.68 | 1919662.0 |
| 2011-04-13 | NQ | Futures | 2610.61 | 2641.65 | 2609.76 | 2629.12 | 287483.0 |
| 2011-04-13 | YM | Futures | 11462.6 | 11551.9 | 11440.1 | 11469.2 | 112586.0 |
| 2011-04-13 | CL | Futures | 205.47 | 208.39 | 204.23 | 207.57 | 268856.0 |
| 2011-04-13 | GC | Futures | 1968.0 | 1981.1 | 1965.3 | 1970.2 | 121237.0 |
| 2011-04-13 | ZN | Futures | 100.368176 | 100.644708 | 100.078475 | 100.618372 | 1122371.0 |
| 2011-04-13 | A6 | Futures | 0.88855 | 0.89696 | 0.88752 | 0.89344 | 90413.0 |
| 2011-04-13 | AD | Futures | 1.03317 | 1.03735 | 1.02968 | 1.03287 | 78315.0 |
| 2011-04-13 | B | Futures | 102.2 | 104.1 | 101.58 | 103.77 | 265649.0 |
| 2011-04-13 | B6 | Futures | 1.6879 | 1.6932 | 1.6855 | 1.6893 | 91241.0 |
| 2011-04-13 | BFX | Futures | 3110.8 | 3155.9 | 3110.8 | 3148.4 | 491.0 |
| 2011-04-13 | BR | Futures | 0.27469 | 0.2763 | 0.27392 | 0.27392 | 40.0 |
| 2011-04-13 | BZ | Futures | 107.94 | 109.69 | 107.59 | 109.4 | 1959.0 |
| 2011-04-13 | C | Futures | 2147.0 | 2172.0 | 2137.0 | 2151.0 | 2214.0 |
| 2011-04-13 | CC | Futures | 2449.0 | 2464.0 | 2427.0 | 2444.0 | 12689.0 |
| 2011-04-13 | CSC | Futures | 4.585 | 4.585 | 4.574 | 4.574 | 6.0 |
| 2011-04-13 | CT | Futures | 180.5 | 184.86 | 175.89 | 176.47 | 15750.0 |
| 2011-04-13 | DC | Futures | 30.22 | 30.5 | 30.12 | 30.22 | 155.0 |
| 2011-04-13 | DX | Futures | 74.69 | 74.964 | 74.576 | 74.815 | 22238.0 |
| 2011-04-13 | E1 | Futures | 1.46089 | 1.46704 | 1.45644 | 1.46168 | 38938.0 |
| 2011-04-13 | E6 | Futures | 1.71266 | 1.71752 | 1.70472 | 1.70804 | 269514.0 |
| 2011-04-13 | E7 | Futures | 1.7 | 1.7046 | 1.6922 | 1.6953 | 5078.0 |
| 2011-04-13 | EBM | Futures | 225.69 | 228.97 | 223.81 | 225.69 | 6071.0 |
| 2011-04-13 | ED | Futures | 94.9311 | 94.9454 | 94.9311 | 94.9359 | 180390.0 |
| 2011-04-13 | ER | Futures | 97.242 | 97.247 | 97.217 | 97.242 | 148821.0 |
| 2011-04-13 | EW | Futures | 961.9 | 971.5 | 960.9 | 965.8 | 28887.0 |
| 2011-04-13 | FBTP | Futures | 64.71 | 64.83 | 64.54 | 64.6 | 10471.0 |
| 2011-04-13 | FCE | Futures | 2671.5 | 2697.3 | 2661.9 | 2680.3 | 152363.0 |
| 2011-04-13 | FDAX | Futures | 7637.1 | 7712.4 | 7628.1 | 7690.0 | 134371.0 |
| 2011-04-13 | FESX | Futures | 1837.6 | 1852.9 | 1829.9 | 1841.4 | 1140980.0 |
| 2011-04-13 | FEU3 | Futures | 97.78 | 97.785 | 97.775 | 97.785 | 72.0 |
| 2011-04-13 | FGBL | Futures | 96.3 | 96.66 | 96.18 | 96.39 | 866969.0 |
| 2011-04-13 | FGBM | Futures | 102.22 | 102.46 | 102.07 | 102.25 | 546503.0 |
| 2011-04-13 | FGBS | Futures | 106.122 | 106.186 | 106.028 | 106.112 | 617231.0 |
| 2011-04-13 | FGBX | Futures | 91.26 | 91.78 | 90.93 | 91.35 | 6771.0 |
| 2011-04-13 | FTDX | Futures | 816.7 | 827.0 | 809.2 | 823.4 | 853.0 |
| 2011-04-13 | FTI | Futures | 294.4 | 297.57 | 293.62 | 295.23 | 52635.0 |
| 2011-04-13 | FTUK | Futures | 4150.8 | 4205.7 | 4150.8 | 4177.0 | 102817.0 |
| 2011-04-13 | FXXP | Futures | 182.5 | 184.1 | 182.3 | 183.5 | 1866.0 |
| 2011-04-13 | G | Futures | 81.12 | 81.29 | 80.91 | 81.14 | 125673.0 |
| 2011-04-13 | GF | Futures | 319.12 | 321.106 | 318.218 | 320.143 | 2557.0 |
| 2011-04-13 | GSCI | Futures | 1147.59 | 1153.92 | 1137.05 | 1146.66 | 2216.0 |
| 2011-04-13 | HE | Futures | 106.734 | 109.523 | 106.734 | 109.443 | 1786.0 |
| 2011-04-13 | HG | Futures | 5.8381 | 5.8701 | 5.6982 | 5.7202 | 51316.0 |
| 2011-04-13 | HO | Futures | 2.654 | 2.6836 | 2.6355 | 2.6723 | 32049.0 |
| 2011-04-13 | HRC | Futures | 3017.7 | 3017.7 | 3017.7 | 3017.7 | 0.0 |
| 2011-04-13 | J1 | Futures | 0.0150342 | 0.0150506 | 0.0149136 | 0.0149903 | 118878.0 |
| 2011-04-13 | J7 | Futures | 0.014921 | 0.014956 | 0.014825 | 0.014898 | 907.0 |
| 2011-04-13 | JB | Futures | 120.83 | 120.87 | 120.7 | 120.82 | 61.0 |
| 2011-04-13 | KC | Futures | 662.28 | 683.6 | 660.09 | 680.33 | 16995.0 |
> showing 50 of 93 rows — these rows as CSV