PREVIEW / futures_daily / 2011-05-03
file: by_date/futures_daily/2011/2011-05-03.parquet size: 9 KB rows: 96
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-05-03 | ES | Futures | 1344.19 | 1344.93 | 1332.31 | 1338.49 | 1674060.0 |
| 2011-05-03 | NQ | Futures | 2736.46 | 2736.74 | 2703.72 | 2721.65 | 287245.0 |
| 2011-05-03 | YM | Futures | 12001.3 | 12024.9 | 11937.4 | 11986.3 | 103843.0 |
| 2011-05-03 | CL | Futures | 217.72 | 218.18 | 212.56 | 214.0 | 300333.0 |
| 2011-05-03 | GC | Futures | 2091.4 | 2099.8 | 2052.2 | 2084.9 | 206734.0 |
| 2011-05-03 | ZN | Futures | 102.172222 | 102.40925 | 102.145885 | 102.343409 | 831647.0 |
| 2011-05-03 | A6 | Futures | 0.93323 | 0.93443 | 0.92474 | 0.92492 | 115143.0 |
| 2011-05-03 | AD | Futures | 1.04621 | 1.05159 | 1.04243 | 1.04292 | 84092.0 |
| 2011-05-03 | B | Futures | 105.63 | 105.85 | 103.12 | 103.72 | 95598.0 |
| 2011-05-03 | B6 | Futures | 1.7285 | 1.73 | 1.7093 | 1.7098 | 132925.0 |
| 2011-05-03 | BFX | Futures | 3259.3 | 3279.1 | 3225.9 | 3279.1 | 71.0 |
| 2011-05-03 | BR | Futures | 0.27568 | 0.27608 | 0.27542 | 0.27588 | 92.0 |
| 2011-05-03 | BZ | Futures | 110.89 | 110.89 | 109.29 | 109.29 | 743.0 |
| 2011-05-03 | C | Futures | 2165.0 | 2184.0 | 2145.0 | 2177.0 | 3043.0 |
| 2011-05-03 | CB | Futures | 121.442 | 121.442 | 121.369 | 121.442 | 15.0 |
| 2011-05-03 | CC | Futures | 2598.0 | 2619.0 | 2556.0 | 2604.0 | 7875.0 |
| 2011-05-03 | CT | Futures | 152.87 | 157.24 | 151.89 | 155.9 | 7542.0 |
| 2011-05-03 | DC | Futures | 30.03 | 30.12 | 29.86 | 30.0 | 88.0 |
| 2011-05-03 | DX | Futures | 72.944 | 73.123 | 72.646 | 72.949 | 24543.0 |
| 2011-05-03 | E1 | Futures | 1.51418 | 1.52361 | 1.50973 | 1.52007 | 38536.0 |
| 2011-05-03 | E6 | Futures | 1.75412 | 1.76182 | 1.74571 | 1.75341 | 288611.0 |
| 2011-05-03 | E7 | Futures | 1.7409 | 1.7487 | 1.7327 | 1.7404 | 5323.0 |
| 2011-05-03 | EBM | Futures | 230.15 | 233.67 | 230.15 | 233.67 | 4542.0 |
| 2011-05-03 | ED | Futures | 94.9406 | 94.9454 | 94.9359 | 94.9406 | 87710.0 |
| 2011-05-03 | ER | Futures | 97.227 | 97.247 | 97.222 | 97.227 | 152593.0 |
| 2011-05-03 | EW | Futures | 1001.5 | 1002.6 | 986.0 | 992.0 | 27065.0 |
| 2011-05-03 | FBTP | Futures | 64.73 | 64.76 | 64.56 | 64.71 | 4406.0 |
| 2011-05-03 | FCE | Futures | 2754.9 | 2760.0 | 2733.8 | 2753.2 | 107461.0 |
| 2011-05-03 | FDAX | Futures | 8035.4 | 8057.3 | 7976.2 | 8030.1 | 120267.0 |
| 2011-05-03 | FESX | Futures | 1885.0 | 1891.4 | 1874.1 | 1885.0 | 1062298.0 |
| 2011-05-03 | FEU3 | Futures | 97.77 | 97.78 | 97.77 | 97.77 | 209.0 |
| 2011-05-03 | FGBL | Futures | 98.39 | 98.39 | 98.06 | 98.13 | 744572.0 |
| 2011-05-03 | FGBM | Futures | 103.13 | 103.13 | 102.81 | 102.89 | 463749.0 |
| 2011-05-03 | FGBS | Futures | 106.32 | 106.33 | 106.156 | 106.196 | 648489.0 |
| 2011-05-03 | FGBX | Futures | 94.93 | 94.93 | 94.25 | 94.36 | 4568.0 |
| 2011-05-03 | FTDX | Futures | 832.4 | 832.4 | 821.7 | 823.4 | 825.0 |
| 2011-05-03 | FTI | Futures | 294.36 | 295.97 | 293.5 | 294.9 | 27191.0 |
| 2011-05-03 | FTUK | Futures | 4235.1 | 4266.3 | 4194.2 | 4230.2 | 100433.0 |
| 2011-05-03 | FXXP | Futures | 187.7 | 187.9 | 186.7 | 187.0 | 3665.0 |
| 2011-05-03 | G | Futures | 82.88 | 83.17 | 82.76 | 83.13 | 110112.0 |
| 2011-05-03 | GF | Futures | 315.39 | 315.39 | 311.118 | 311.238 | 968.0 |
| 2011-05-03 | GSCI | Futures | 1168.45 | 1172.12 | 1154.7 | 1157.51 | 215.0 |
| 2011-05-03 | HE | Futures | 100.679 | 100.97 | 97.926 | 97.926 | 24527.0 |
| 2011-05-03 | HG | Futures | 5.5467 | 5.6689 | 5.5241 | 5.6503 | 36914.0 |
| 2011-05-03 | HO | Futures | 2.6922 | 2.6993 | 2.6328 | 2.6513 | 55052.0 |
| 2011-05-03 | HRC | Futures | 3000.1 | 3000.1 | 3000.1 | 3000.1 | 0.0 |
| 2011-05-03 | J1 | Futures | 0.0154626 | 0.0155719 | 0.0154576 | 0.0155292 | 74000.0 |
| 2011-05-03 | J7 | Futures | 0.015369 | 0.015477 | 0.015367 | 0.015434 | 398.0 |
| 2011-05-03 | JB | Futures | 122.26 | 122.45 | 122.2 | 122.29 | 210.0 |
| 2011-05-03 | KC | Futures | 731.86 | 740.74 | 728.99 | 734.14 | 9554.0 |
> showing 50 of 96 rows — these rows as CSV