PREVIEW / futures_daily / 2011-03-24
file: by_date/futures_daily/2011/2011-03-24.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-03-24 | ES | Futures | 1279.09 | 1293.7 | 1276.37 | 1292.21 | 1833298.0 |
| 2011-03-24 | NQ | Futures | 2579.58 | 2634.81 | 2576.44 | 2629.12 | 289374.0 |
| 2011-03-24 | YM | Futures | 11302.8 | 11402.5 | 11284.9 | 11391.2 | 107690.0 |
| 2011-03-24 | CL | Futures | 204.05 | 206.32 | 202.58 | 204.21 | 258015.0 |
| 2011-03-24 | GC | Futures | 1951.5 | 1965.9 | 1932.1 | 1947.3 | 187085.0 |
| 2011-03-24 | ZN | Futures | 101.07926 | 101.303119 | 100.618372 | 100.710549 | 1069769.0 |
| 2011-03-24 | A6 | Futures | 0.86068 | 0.86883 | 0.85888 | 0.86831 | 109581.0 |
| 2011-03-24 | AD | Futures | 1.01305 | 1.02152 | 1.01166 | 1.01793 | 90503.0 |
| 2011-03-24 | B | Futures | 97.86 | 98.32 | 97.12 | 98.15 | 157450.0 |
| 2011-03-24 | B6 | Futures | 1.6856 | 1.6884 | 1.67 | 1.6717 | 138862.0 |
| 2011-03-24 | BFX | Futures | 3034.4 | 3080.8 | 3034.4 | 3061.0 | 24.0 |
| 2011-03-24 | BR | Futures | 0.26143 | 0.26222 | 0.26136 | 0.26162 | 100.0 |
| 2011-03-24 | BZ | Futures | 103.28 | 103.53 | 102.34 | 103.39 | 1117.0 |
| 2011-03-24 | C | Futures | 2290.0 | 2301.0 | 2257.0 | 2290.0 | 4896.0 |
| 2011-03-24 | CB | Futures | 116.895 | 117.35 | 116.895 | 117.335 | 3.0 |
| 2011-03-24 | CC | Futures | 2601.0 | 2604.0 | 2553.0 | 2574.0 | 5497.0 |
| 2011-03-24 | CSC | Futures | 4.276 | 4.338 | 4.276 | 4.338 | 2.0 |
| 2011-03-24 | CT | Futures | 180.89 | 186.78 | 176.04 | 186.73 | 14421.0 |
| 2011-03-24 | DC | Futures | 28.27 | 29.07 | 28.27 | 28.93 | 163.0 |
| 2011-03-24 | DX | Futures | 75.73 | 75.924 | 75.322 | 75.509 | 32268.0 |
| 2011-03-24 | E1 | Futures | 1.44269 | 1.45107 | 1.43588 | 1.44413 | 36704.0 |
| 2011-03-24 | E6 | Futures | 1.66729 | 1.68222 | 1.66244 | 1.67772 | 291925.0 |
| 2011-03-24 | E7 | Futures | 1.6552 | 1.6698 | 1.6501 | 1.6652 | 6788.0 |
| 2011-03-24 | EBM | Futures | 210.66 | 216.06 | 208.54 | 215.82 | 6858.0 |
| 2011-03-24 | ED | Futures | 94.8454 | 94.855 | 94.8407 | 94.8502 | 140145.0 |
| 2011-03-24 | ER | Futures | 97.272 | 97.286 | 97.257 | 97.267 | 92175.0 |
| 2011-03-24 | EW | Futures | 944.7 | 957.3 | 942.0 | 955.0 | 24427.0 |
| 2011-03-24 | FBTP | Futures | 64.41 | 64.41 | 63.98 | 64.12 | 5471.0 |
| 2011-03-24 | FCE | Futures | 2606.0 | 2651.6 | 2585.7 | 2642.6 | 146895.0 |
| 2011-03-24 | FDAX | Futures | 7284.8 | 7453.5 | 7267.1 | 7431.0 | 160568.0 |
| 2011-03-24 | FESX | Futures | 1784.4 | 1822.2 | 1774.1 | 1816.4 | 1463208.0 |
| 2011-03-24 | FEU3 | Futures | 97.81 | 97.81 | 97.805 | 97.81 | 82.0 |
| 2011-03-24 | FGBL | Futures | 98.0 | 98.21 | 97.63 | 97.78 | 860755.0 |
| 2011-03-24 | FGBM | Futures | 103.3 | 103.46 | 103.06 | 103.14 | 549842.0 |
| 2011-03-24 | FGBS | Futures | 106.489 | 106.548 | 106.404 | 106.434 | 633908.0 |
| 2011-03-24 | FGBX | Futures | 94.67 | 95.29 | 93.79 | 94.08 | 2641.0 |
| 2011-03-24 | FTDX | Futures | 791.3 | 810.0 | 791.3 | 804.2 | 338.0 |
| 2011-03-24 | FTI | Futures | 292.04 | 295.42 | 290.86 | 294.81 | 42447.0 |
| 2011-03-24 | FTUK | Futures | 4027.6 | 4102.5 | 4012.6 | 4091.3 | 97989.0 |
| 2011-03-24 | FXXP | Futures | 179.6 | 181.7 | 179.4 | 181.6 | 1214.0 |
| 2011-03-24 | G | Futures | 82.13 | 82.22 | 81.83 | 81.87 | 100525.0 |
| 2011-03-24 | GF | Futures | 318.902 | 321.866 | 318.902 | 320.959 | 651.0 |
| 2011-03-24 | GSCI | Futures | 1120.66 | 1127.23 | 1117.99 | 1127.23 | 113.0 |
| 2011-03-24 | HE | Futures | 105.352 | 105.883 | 104.874 | 105.83 | 284.0 |
| 2011-03-24 | HG | Futures | 5.8941 | 5.9333 | 5.8501 | 5.8934 | 28688.0 |
| 2011-03-24 | HO | Futures | 2.562 | 2.5777 | 2.5338 | 2.5704 | 32749.0 |
| 2011-03-24 | HRC | Futures | 3106.0 | 3106.0 | 3106.0 | 3106.0 | 0.0 |
| 2011-03-24 | J1 | Futures | 0.0155292 | 0.0155657 | 0.0155054 | 0.015528 | 79607.0 |
| 2011-03-24 | J7 | Futures | 0.015435 | 0.015468 | 0.015413 | 0.015433 | 578.0 |
| 2011-03-24 | JB | Futures | 121.81 | 121.81 | 121.81 | 121.81 | 805.0 |
> showing 50 of 93 rows — these rows as CSV