PREVIEW / futures_daily / 2011-12-19
file: by_date/futures_daily/2011/2011-12-19.parquet size: 9 KB rows: 98
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-12-19 | ES | Futures | 1216.32 | 1224.1 | 1199.76 | 1203.28 | 1683745.0 |
| 2011-12-19 | NQ | Futures | 2555.94 | 2574.24 | 2520.77 | 2530.21 | 183913.0 |
| 2011-12-19 | YM | Futures | 11404.7 | 11466.6 | 11277.1 | 11317.7 | 94467.0 |
| 2011-12-19 | CL | Futures | 175.25 | 176.86 | 173.38 | 175.77 | 214737.0 |
| 2011-12-19 | GC | Futures | 2165.0 | 2175.8 | 2140.7 | 2155.8 | 121278.0 |
| 2011-12-19 | ZN | Futures | 113.354289 | 113.583833 | 113.178755 | 113.489315 | 483011.0 |
| 2011-12-19 | A6 | Futures | 0.87738 | 0.87898 | 0.87062 | 0.87382 | 80425.0 |
| 2011-12-19 | AD | Futures | 0.96398 | 0.9693 | 0.96177 | 0.96659 | 43273.0 |
| 2011-12-19 | B | Futures | 92.35 | 93.19 | 91.23 | 92.36 | 143546.0 |
| 2011-12-19 | B6 | Futures | 1.6216 | 1.6237 | 1.6152 | 1.621 | 61153.0 |
| 2011-12-19 | BFX | Futures | 2399.7 | 2421.3 | 2398.3 | 2403.3 | 167.0 |
| 2011-12-19 | BR | Futures | 0.24692 | 0.24692 | 0.24692 | 0.24692 | 740.0 |
| 2011-12-19 | BZ | Futures | 98.55 | 98.63 | 97.62 | 98.02 | 265.0 |
| 2011-12-19 | C | Futures | 1385.0 | 1406.0 | 1366.0 | 1369.0 | 5375.0 |
| 2011-12-19 | CC | Futures | 1620.0 | 1651.0 | 1601.0 | 1605.0 | 8665.0 |
| 2011-12-19 | CSC | Futures | 3.964 | 3.964 | 3.927 | 3.932 | 9.0 |
| 2011-12-19 | CT | Futures | 111.07 | 112.7 | 110.63 | 112.17 | 3770.0 |
| 2011-12-19 | DC | Futures | 28.73 | 28.9 | 28.65 | 28.85 | 119.0 |
| 2011-12-19 | DX | Futures | 78.673 | 78.907 | 78.527 | 78.651 | 16590.0 |
| 2011-12-19 | E1 | Futures | 1.40438 | 1.4074 | 1.39887 | 1.40504 | 15198.0 |
| 2011-12-19 | E6 | Futures | 1.55951 | 1.56047 | 1.55305 | 1.557 | 158626.0 |
| 2011-12-19 | E7 | Futures | 1.5451 | 1.5462 | 1.5391 | 1.5428 | 2156.0 |
| 2011-12-19 | EBM | Futures | 234.55 | 239.47 | 234.55 | 239.14 | 9269.0 |
| 2011-12-19 | ED | Futures | 94.8957 | 94.9196 | 94.8814 | 94.8862 | 172283.0 |
| 2011-12-19 | ER | Futures | 97.213 | 97.228 | 97.189 | 97.213 | 120589.0 |
| 2011-12-19 | EW | Futures | 859.3 | 866.6 | 841.4 | 842.5 | 27561.0 |
| 2011-12-19 | FBTP | Futures | 57.62 | 59.08 | 57.56 | 58.72 | 3596.0 |
| 2011-12-19 | FBTS | Futures | 79.945 | 80.515 | 79.945 | 80.186 | 401.0 |
| 2011-12-19 | FCE | Futures | 2101.7 | 2156.8 | 2096.7 | 2130.3 | 63796.0 |
| 2011-12-19 | FDAX | Futures | 6219.5 | 6389.6 | 6200.2 | 6265.9 | 125739.0 |
| 2011-12-19 | FESX | Futures | 1447.4 | 1489.5 | 1445.4 | 1466.8 | 687410.0 |
| 2011-12-19 | FEU3 | Futures | 97.757 | 97.766 | 97.757 | 97.766 | 50.0 |
| 2011-12-19 | FGBL | Futures | 112.2 | 112.24 | 111.74 | 111.99 | 235893.0 |
| 2011-12-19 | FGBM | Futures | 112.94 | 112.96 | 112.73 | 112.87 | 121324.0 |
| 2011-12-19 | FGBS | Futures | 109.805 | 109.805 | 109.735 | 109.79 | 121861.0 |
| 2011-12-19 | FGBX | Futures | 117.97 | 118.23 | 117.47 | 117.83 | 2694.0 |
| 2011-12-19 | FTDX | Futures | 611.7 | 616.8 | 608.4 | 610.8 | 80.0 |
| 2011-12-19 | FTI | Futures | 243.81 | 249.35 | 243.81 | 246.79 | 34809.0 |
| 2011-12-19 | FTUK | Futures | 3837.9 | 3876.5 | 3809.7 | 3840.8 | 82134.0 |
| 2011-12-19 | FVSA | Futures | 14055.82 | 14055.82 | 13597.26 | 13756.76 | 3642.0 |
| 2011-12-19 | FXXP | Futures | 163.9 | 166.1 | 163.8 | 164.3 | 617.0 |
| 2011-12-19 | G | Futures | 94.23 | 94.4 | 93.92 | 94.13 | 47437.0 |
| 2011-12-19 | GF | Futures | 307.817 | 312.556 | 307.44 | 311.641 | 1660.0 |
| 2011-12-19 | GSCI | Futures | 974.87 | 976.44 | 966.79 | 972.91 | 399.0 |
| 2011-12-19 | HE | Futures | 102.568 | 104.479 | 102.507 | 103.986 | 14852.0 |
| 2011-12-19 | HG | Futures | 4.412 | 4.4272 | 4.3032 | 4.3639 | 42099.0 |
| 2011-12-19 | HO | Futures | 2.2711 | 2.3001 | 2.2537 | 2.2577 | 16752.0 |
| 2011-12-19 | HRC | Futures | 2786.5 | 2786.5 | 2786.5 | 2786.5 | 0.0 |
| 2011-12-19 | J1 | Futures | 0.0161803 | 0.0161803 | 0.0159455 | 0.0161426 | 46961.0 |
| 2011-12-19 | J7 | Futures | 0.016107 | 0.016107 | 0.015928 | 0.016076 | 411.0 |
> showing 50 of 98 rows — these rows as CSV