PREVIEW / futures_daily / 2011-12-21
file: by_date/futures_daily/2011/2011-12-21.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-21 | ES | Futures | 1240.41 | 1253.45 | 1227.36 | 1240.66 | 1986543.0 |
| 2011-12-21 | NQ | Futures | 2595.39 | 2620.27 | 2536.21 | 2560.51 | 248778.0 |
| 2011-12-21 | YM | Futures | 11631.0 | 11757.7 | 11535.3 | 11628.1 | 115838.0 |
| 2011-12-21 | CL | Futures | 182.24 | 185.49 | 180.91 | 184.41 | 219505.0 |
| 2011-12-21 | GC | Futures | 2183.5 | 2219.3 | 2170.6 | 2178.6 | 125152.0 |
| 2011-12-21 | ZN | Futures | 112.881698 | 113.111242 | 112.598144 | 112.706164 | 762998.0 |
| 2011-12-21 | A6 | Futures | 0.88708 | 0.90052 | 0.88566 | 0.88797 | 107039.0 |
| 2011-12-21 | AD | Futures | 0.97231 | 0.98124 | 0.9717 | 0.97472 | 67167.0 |
| 2011-12-21 | B | Futures | 95.49 | 96.4 | 94.61 | 95.99 | 140015.0 |
| 2011-12-21 | B6 | Futures | 1.6356 | 1.6476 | 1.6342 | 1.6366 | 80483.0 |
| 2011-12-21 | BFX | Futures | 2472.8 | 2472.8 | 2418.9 | 2419.2 | 26.0 |
| 2011-12-21 | BR | Futures | 0.25012 | 0.25012 | 0.24879 | 0.24879 | 63.0 |
| 2011-12-21 | BZ | Futures | 100.7 | 102.18 | 100.7 | 101.87 | 432.0 |
| 2011-12-21 | C | Futures | 1451.0 | 1464.0 | 1421.0 | 1463.0 | 8105.0 |
| 2011-12-21 | CB | Futures | 89.212 | 89.75 | 89.212 | 89.75 | 28.0 |
| 2011-12-21 | CC | Futures | 1699.0 | 1742.0 | 1685.0 | 1740.0 | 10300.0 |
| 2011-12-21 | CSC | Futures | 3.978 | 3.978 | 3.973 | 3.973 | 1.0 |
| 2011-12-21 | CT | Futures | 111.97 | 112.54 | 111.1 | 111.85 | 5140.0 |
| 2011-12-21 | DC | Futures | 28.86 | 28.93 | 28.75 | 28.86 | 55.0 |
| 2011-12-21 | DX | Futures | 77.967 | 78.298 | 77.427 | 78.206 | 24116.0 |
| 2011-12-21 | E1 | Futures | 1.41173 | 1.42276 | 1.40031 | 1.40504 | 35754.0 |
| 2011-12-21 | E6 | Futures | 1.56489 | 1.58067 | 1.55843 | 1.5607 | 235154.0 |
| 2011-12-21 | E7 | Futures | 1.5505 | 1.5662 | 1.5443 | 1.5464 | 3901.0 |
| 2011-12-21 | EBM | Futures | 241.11 | 242.42 | 239.47 | 241.43 | 10124.0 |
| 2011-12-21 | ED | Futures | 94.8957 | 94.9196 | 94.8862 | 94.8957 | 152472.0 |
| 2011-12-21 | ER | Futures | 97.238 | 97.282 | 97.189 | 97.199 | 165334.0 |
| 2011-12-21 | EW | Futures | 871.6 | 883.7 | 860.5 | 874.8 | 26422.0 |
| 2011-12-21 | FBTP | Futures | 59.79 | 60.52 | 58.35 | 58.99 | 8154.0 |
| 2011-12-21 | FBTS | Futures | 80.74 | 81.093 | 79.752 | 80.09 | 2969.0 |
| 2011-12-21 | FCE | Futures | 2200.5 | 2236.7 | 2162.5 | 2170.8 | 75561.0 |
| 2011-12-21 | FDAX | Futures | 6505.5 | 6599.4 | 6375.2 | 6404.5 | 152533.0 |
| 2011-12-21 | FESX | Futures | 1516.9 | 1543.0 | 1487.5 | 1494.9 | 900305.0 |
| 2011-12-21 | FGBL | Futures | 111.28 | 111.74 | 110.62 | 111.54 | 401964.0 |
| 2011-12-21 | FGBM | Futures | 112.59 | 112.79 | 112.26 | 112.63 | 202926.0 |
| 2011-12-21 | FGBS | Futures | 109.795 | 109.795 | 109.655 | 109.73 | 245176.0 |
| 2011-12-21 | FGBX | Futures | 116.47 | 117.01 | 114.83 | 116.44 | 7997.0 |
| 2011-12-21 | FTDX | Futures | 629.8 | 634.5 | 616.3 | 617.7 | 90.0 |
| 2011-12-21 | FTI | Futures | 254.63 | 257.65 | 251.61 | 252.54 | 39235.0 |
| 2011-12-21 | FTUK | Futures | 3901.0 | 3925.5 | 3843.3 | 3854.8 | 100909.0 |
| 2011-12-21 | FVSA | Futures | 12720.02 | 12899.46 | 12440.9 | 12859.58 | 5126.0 |
| 2011-12-21 | FXXP | Futures | 169.5 | 170.2 | 166.9 | 167.3 | 1350.0 |
| 2011-12-21 | G | Futures | 94.06 | 94.61 | 93.8 | 94.41 | 63673.0 |
| 2011-12-21 | GF | Futures | 310.833 | 313.579 | 309.325 | 310.995 | 1255.0 |
| 2011-12-21 | GSCI | Futures | 993.14 | 1008.43 | 993.14 | 1006.71 | 139.0 |
| 2011-12-21 | HE | Futures | 103.524 | 103.616 | 102.661 | 102.661 | 12170.0 |
| 2011-12-21 | HG | Futures | 4.4582 | 4.5334 | 4.4173 | 4.4773 | 29624.0 |
| 2011-12-21 | HO | Futures | 2.3229 | 2.3645 | 2.3145 | 2.3598 | 21233.0 |
| 2011-12-21 | HRC | Futures | 2806.2 | 2806.2 | 2806.2 | 2806.2 | 0.0 |
| 2011-12-21 | J1 | Futures | 0.0161602 | 0.0162016 | 0.0160999 | 0.0161112 | 56791.0 |
| 2011-12-21 | J7 | Futures | 0.016092 | 0.016132 | 0.016036 | 0.016045 | 313.0 |
> showing 50 of 98 rows — these rows as CSV