PREVIEW / futures_daily / 2012-04-19
file: by_date/futures_daily/2012/2012-04-19.parquet size: 9 KB rows: 99
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-19 | ES | Futures | 1389.39 | 1400.73 | 1376.04 | 1383.09 | 2631716.0 |
| 2012-04-19 | NQ | Futures | 3091.44 | 3133.54 | 3060.79 | 3074.54 | 435456.0 |
| 2012-04-19 | YM | Futures | 12607.4 | 12697.8 | 12483.9 | 12547.1 | 171257.0 |
| 2012-04-19 | CL | Futures | 189.33 | 190.15 | 187.35 | 188.43 | 256064.0 |
| 2012-04-19 | GC | Futures | 2196.4 | 2212.3 | 2180.6 | 2194.2 | 161296.0 |
| 2012-04-19 | ZN | Futures | 114.03041 | 114.206403 | 113.867954 | 114.165789 | 1010824.0 |
| 2012-04-19 | A6 | Futures | 0.92582 | 0.92897 | 0.92195 | 0.9233 | 140893.0 |
| 2012-04-19 | AD | Futures | 1.01386 | 1.01698 | 1.00843 | 1.00913 | 101030.0 |
| 2012-04-19 | B | Futures | 106.86 | 107.76 | 106.43 | 106.72 | 204709.0 |
| 2012-04-19 | B6 | Futures | 1.6806 | 1.6869 | 1.6796 | 1.6847 | 123505.0 |
| 2012-04-19 | BFX | Futures | 2703.6 | 2708.0 | 2663.5 | 2668.3 | 167.0 |
| 2012-04-19 | BR | Futures | 0.25041 | 0.25154 | 0.25008 | 0.25077 | 1905.0 |
| 2012-04-19 | BZ | Futures | 113.52 | 113.98 | 112.6 | 112.88 | 1122.0 |
| 2012-04-19 | C | Futures | 1468.0 | 1473.0 | 1444.0 | 1448.0 | 5422.0 |
| 2012-04-19 | CB | Futures | 77.64 | 77.64 | 77.101 | 77.505 | 20.0 |
| 2012-04-19 | CC | Futures | 1701.0 | 1704.0 | 1659.0 | 1684.0 | 10202.0 |
| 2012-04-19 | CSC | Futures | 3.442 | 3.517 | 3.442 | 3.517 | 36.0 |
| 2012-04-19 | CT | Futures | 115.5 | 116.53 | 113.34 | 114.55 | 3284.0 |
| 2012-04-19 | DC | Futures | 23.79 | 24.41 | 23.59 | 24.28 | 306.0 |
| 2012-04-19 | DX | Futures | 77.245 | 77.492 | 77.041 | 77.227 | 19386.0 |
| 2012-04-19 | E1 | Futures | 1.43049 | 1.43547 | 1.42486 | 1.43115 | 43146.0 |
| 2012-04-19 | E6 | Futures | 1.56668 | 1.57217 | 1.56047 | 1.56811 | 303320.0 |
| 2012-04-19 | E7 | Futures | 1.5514 | 1.5571 | 1.5456 | 1.5531 | 4103.0 |
| 2012-04-19 | EBM | Futures | 290.75 | 292.43 | 290.41 | 292.1 | 10630.0 |
| 2012-04-19 | ED | Futures | 95.0645 | 95.0693 | 95.0597 | 95.0597 | 70288.0 |
| 2012-04-19 | ER | Futures | 97.523 | 97.528 | 97.508 | 97.513 | 79804.0 |
| 2012-04-19 | EW | Futures | 984.4 | 996.0 | 976.5 | 981.6 | 38643.0 |
| 2012-04-19 | FBTP | Futures | 66.34 | 66.62 | 65.64 | 65.84 | 15331.0 |
| 2012-04-19 | FBTS | Futures | 84.965 | 85.03 | 84.68 | 84.745 | 2790.0 |
| 2012-04-19 | FCE | Futures | 2305.6 | 2327.7 | 2229.4 | 2248.9 | 180275.0 |
| 2012-04-19 | FDAX | Futures | 7466.7 | 7534.7 | 7337.9 | 7389.3 | 191374.0 |
| 2012-04-19 | FESX | Futures | 1564.7 | 1583.3 | 1521.9 | 1534.3 | 2052157.0 |
| 2012-04-19 | FGBL | Futures | 115.05 | 115.44 | 114.84 | 115.3 | 817999.0 |
| 2012-04-19 | FGBM | Futures | 114.5 | 114.69 | 114.39 | 114.61 | 413519.0 |
| 2012-04-19 | FGBS | Futures | 110.108 | 110.138 | 110.069 | 110.113 | 330515.0 |
| 2012-04-19 | FGBX | Futures | 119.89 | 120.52 | 119.42 | 120.21 | 6695.0 |
| 2012-04-19 | FOAT | Futures | 94.5 | 94.56 | 93.72 | 93.97 | 14661.0 |
| 2012-04-19 | FTDX | Futures | 735.4 | 738.2 | 722.8 | 726.0 | 205.0 |
| 2012-04-19 | FTI | Futures | 265.29 | 267.76 | 259.86 | 261.69 | 21384.0 |
| 2012-04-19 | FTUK | Futures | 4163.7 | 4195.1 | 4130.1 | 4158.9 | 132021.0 |
| 2012-04-19 | FVSA | Futures | 9292.43 | 9507.38 | 9044.41 | 9507.38 | 2189.0 |
| 2012-04-19 | FXXP | Futures | 185.3 | 185.8 | 182.9 | 183.1 | 2528.0 |
| 2012-04-19 | G | Futures | 94.43 | 94.69 | 94.11 | 94.33 | 137058.0 |
| 2012-04-19 | GF | Futures | 318.02 | 318.072 | 315.26 | 316.77 | 3066.0 |
| 2012-04-19 | GSCI | Futures | 1068.15 | 1072.83 | 1064.97 | 1066.16 | 229.0 |
| 2012-04-19 | HE | Futures | 96.268 | 97.368 | 96.02 | 97.368 | 576.0 |
| 2012-04-19 | HG | Futures | 4.765 | 4.7951 | 4.7231 | 4.7617 | 16530.0 |
| 2012-04-19 | HO | Futures | 2.5686 | 2.5868 | 2.5612 | 2.5717 | 53872.0 |
| 2012-04-19 | HRC | Futures | 2668.7 | 2668.7 | 2668.7 | 2668.7 | 0.0 |
| 2012-04-19 | J1 | Futures | 0.0154354 | 0.0154567 | 0.0153476 | 0.0154015 | 80709.0 |
> showing 50 of 99 rows — these rows as CSV