PREVIEW / futures_daily / 2012-04-03
file: by_date/futures_daily/2012/2012-04-03.parquet size: 9 KB rows: 97
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 |
|---|---|---|---|---|---|---|---|
| 2012-04-03 | ES | Futures | 1422.9 | 1425.16 | 1410.3 | 1419.62 | 1673086.0 |
| 2012-04-03 | NQ | Futures | 3181.66 | 3198.28 | 3165.62 | 3183.96 | 252462.0 |
| 2012-04-03 | YM | Futures | 12824.2 | 12836.9 | 12703.6 | 12770.7 | 110393.0 |
| 2012-04-03 | CL | Futures | 193.63 | 193.89 | 190.96 | 191.73 | 245541.0 |
| 2012-04-03 | GC | Futures | 2243.9 | 2249.4 | 2192.6 | 2235.1 | 156003.0 |
| 2012-04-03 | ZN | Futures | 112.432928 | 112.69015 | 111.607111 | 111.701877 | 1347783.0 |
| 2012-04-03 | A6 | Futures | 0.92843 | 0.93383 | 0.9188 | 0.91925 | 147092.0 |
| 2012-04-03 | AD | Futures | 1.01366 | 1.01587 | 1.01165 | 1.01245 | 87277.0 |
| 2012-04-03 | B | Futures | 112.69 | 113.38 | 111.98 | 112.49 | 162894.0 |
| 2012-04-03 | B6 | Futures | 1.6804 | 1.6835 | 1.6672 | 1.6676 | 107606.0 |
| 2012-04-03 | BFX | Futures | 2874.7 | 2877.2 | 2849.8 | 2849.8 | 28.0 |
| 2012-04-03 | BR | Futures | 0.25747 | 0.25831 | 0.25733 | 0.25733 | 42.0 |
| 2012-04-03 | BZ | Futures | 119.58 | 119.58 | 118.99 | 118.99 | 796.0 |
| 2012-04-03 | C | Futures | 1442.0 | 1451.0 | 1414.0 | 1420.0 | 4312.0 |
| 2012-04-03 | CB | Futures | 78.447 | 78.851 | 78.447 | 78.582 | 8.0 |
| 2012-04-03 | CC | Futures | 1657.0 | 1665.0 | 1627.0 | 1631.0 | 16012.0 |
| 2012-04-03 | CSC | Futures | 3.737 | 3.737 | 3.685 | 3.708 | 11.0 |
| 2012-04-03 | CT | Futures | 116.63 | 117.39 | 115.65 | 115.94 | 12710.0 |
| 2012-04-03 | DC | Futures | 26.3 | 26.5 | 25.94 | 25.94 | 295.0 |
| 2012-04-03 | DX | Futures | 76.445 | 77.177 | 76.343 | 77.163 | 28232.0 |
| 2012-04-03 | E1 | Futures | 1.44935 | 1.4555 | 1.43783 | 1.43809 | 46796.0 |
| 2012-04-03 | E6 | Futures | 1.59056 | 1.59652 | 1.5779 | 1.57814 | 301290.0 |
| 2012-04-03 | E7 | Futures | 1.5749 | 1.5812 | 1.5628 | 1.563 | 4026.0 |
| 2012-04-03 | EBM | Futures | 285.36 | 286.03 | 284.01 | 285.02 | 5376.0 |
| 2012-04-03 | ED | Futures | 95.074 | 95.0788 | 95.0454 | 95.0549 | 160940.0 |
| 2012-04-03 | ER | Futures | 97.523 | 97.528 | 97.499 | 97.508 | 114377.0 |
| 2012-04-03 | EW | Futures | 1007.3 | 1012.7 | 1001.6 | 1011.0 | 27142.0 |
| 2012-04-03 | FBTP | Futures | 68.23 | 68.3 | 67.76 | 68.01 | 6570.0 |
| 2012-04-03 | FBTS | Futures | 85.583 | 85.64 | 85.445 | 85.559 | 2216.0 |
| 2012-04-03 | FCE | Futures | 2461.5 | 2462.9 | 2394.1 | 2412.9 | 101874.0 |
| 2012-04-03 | FDAX | Futures | 7836.5 | 7843.1 | 7669.0 | 7735.3 | 139910.0 |
| 2012-04-03 | FESX | Futures | 1682.7 | 1685.5 | 1634.4 | 1651.0 | 1045929.0 |
| 2012-04-03 | FGBL | Futures | 113.37 | 113.57 | 112.83 | 113.39 | 585970.0 |
| 2012-04-03 | FGBM | Futures | 113.74 | 113.84 | 113.49 | 113.75 | 344032.0 |
| 2012-04-03 | FGBS | Futures | 109.939 | 109.969 | 109.904 | 109.944 | 318218.0 |
| 2012-04-03 | FGBX | Futures | 117.92 | 118.1 | 116.87 | 117.64 | 6173.0 |
| 2012-04-03 | FTDX | Futures | 748.5 | 752.2 | 742.4 | 747.1 | 124.0 |
| 2012-04-03 | FTI | Futures | 275.56 | 275.56 | 269.56 | 271.16 | 32924.0 |
| 2012-04-03 | FTUK | Futures | 4262.9 | 4267.3 | 4202.4 | 4223.9 | 100286.0 |
| 2012-04-03 | FVSA | Futures | 7515.03 | 7699.14 | 7414.61 | 7682.41 | 5033.0 |
| 2012-04-03 | FXXP | Futures | 190.1 | 190.8 | 187.4 | 188.5 | 3587.0 |
| 2012-04-03 | G | Futures | 93.47 | 94.1 | 93.42 | 93.93 | 141885.0 |
| 2012-04-03 | GF | Futures | 313.82 | 315.076 | 311.779 | 312.407 | 2078.0 |
| 2012-04-03 | GSCI | Futures | 1107.29 | 1110.22 | 1099.61 | 1102.54 | 327.0 |
| 2012-04-03 | HE | Futures | 102.678 | 102.678 | 102.046 | 102.596 | 219.0 |
| 2012-04-03 | HG | Futures | 5.1275 | 5.1891 | 5.0881 | 5.138 | 45671.0 |
| 2012-04-03 | HO | Futures | 2.6773 | 2.6853 | 2.6519 | 2.6594 | 25904.0 |
| 2012-04-03 | HRC | Futures | 2699.8 | 2699.8 | 2699.8 | 2699.8 | 0.0 |
| 2012-04-03 | J1 | Futures | 0.0152837 | 0.0153877 | 0.0151181 | 0.0151194 | 104196.0 |
| 2012-04-03 | J7 | Futures | 0.015205 | 0.01531 | 0.015047 | 0.015048 | 903.0 |
> showing 50 of 97 rows — these rows as CSV