PREVIEW / futures_daily / 2012-06-11
file: by_date/futures_daily/2012/2012-06-11.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 |
|---|---|---|---|---|---|---|---|
| 2012-06-11 | ES | Futures | 1352.36 | 1359.41 | 1316.33 | 1317.09 | 1171558.0 |
| 2012-06-11 | NQ | Futures | 2963.98 | 2983.45 | 2879.77 | 2881.77 | 152735.0 |
| 2012-06-11 | YM | Futures | 12229.1 | 12335.8 | 11940.9 | 11942.9 | 180261.0 |
| 2012-06-11 | CL | Futures | 157.1 | 158.78 | 148.65 | 151.56 | 343211.0 |
| 2012-06-11 | GC | Futures | 2142.6 | 2151.3 | 2115.7 | 2134.6 | 116635.0 |
| 2012-06-11 | ZN | Futures | 115.950379 | 116.740268 | 115.541815 | 116.60408 | 1250804.0 |
| 2012-06-11 | A6 | Futures | 0.89046 | 0.89199 | 0.87913 | 0.88174 | 25402.0 |
| 2012-06-11 | AD | Futures | 0.97744 | 0.98085 | 0.96982 | 0.97082 | 12327.0 |
| 2012-06-11 | B | Futures | 90.66 | 92.53 | 87.35 | 88.74 | 177317.0 |
| 2012-06-11 | B6 | Futures | 1.6226 | 1.6276 | 1.6172 | 1.619 | 16041.0 |
| 2012-06-11 | BFX | Futures | 2563.8 | 2563.8 | 2511.3 | 2511.3 | 140.0 |
| 2012-06-11 | BR | Futures | 0.23243 | 0.23243 | 0.22923 | 0.22971 | 584.0 |
| 2012-06-11 | BZ | Futures | 97.81 | 97.81 | 93.68 | 94.35 | 3685.0 |
| 2012-06-11 | C | Futures | 1536.0 | 1549.0 | 1524.0 | 1526.0 | 6479.0 |
| 2012-06-11 | CC | Futures | 1650.0 | 1680.0 | 1632.0 | 1641.0 | 13343.0 |
| 2012-06-11 | CT | Futures | 90.83 | 92.66 | 89.63 | 91.86 | 24603.0 |
| 2012-06-11 | DC | Futures | 26.59 | 27.06 | 26.59 | 26.61 | 107.0 |
| 2012-06-11 | DX | Futures | 79.993 | 80.629 | 79.688 | 80.531 | 8172.0 |
| 2012-06-11 | E1 | Futures | 1.36359 | 1.36604 | 1.345 | 1.34693 | 11362.0 |
| 2012-06-11 | E6 | Futures | 1.49303 | 1.49574 | 1.47333 | 1.47557 | 75039.0 |
| 2012-06-11 | E7 | Futures | 1.4787 | 1.4862 | 1.4643 | 1.4664 | 685.0 |
| 2012-06-11 | ED | Futures | 95.0701 | 95.0796 | 95.0557 | 95.0605 | 204227.0 |
| 2012-06-11 | ER | Futures | 97.533 | 97.543 | 97.504 | 97.523 | 98657.0 |
| 2012-06-11 | EW | Futures | 937.5 | 955.5 | 914.7 | 914.9 | 53587.0 |
| 2012-06-11 | FBTP | Futures | 66.18 | 66.69 | 64.55 | 64.71 | 28452.0 |
| 2012-06-11 | FBTS | Futures | 84.914 | 85.03 | 83.946 | 84.021 | 3835.0 |
| 2012-06-11 | FCE | Futures | 2292.9 | 2306.2 | 2230.3 | 2242.8 | 202134.0 |
| 2012-06-11 | FDAX | Futures | 6968.7 | 6988.6 | 6741.0 | 6784.1 | 232377.0 |
| 2012-06-11 | FESX | Futures | 1478.4 | 1483.1 | 1427.7 | 1436.5 | 1248743.0 |
| 2012-06-11 | FEU3 | Futures | 98.108 | 98.108 | 98.103 | 98.103 | 1.0 |
| 2012-06-11 | FGBL | Futures | 117.84 | 119.01 | 117.68 | 118.85 | 847094.0 |
| 2012-06-11 | FGBM | Futures | 115.6 | 115.99 | 115.5 | 115.89 | 382137.0 |
| 2012-06-11 | FGBS | Futures | 110.283 | 110.308 | 110.263 | 110.288 | 297889.0 |
| 2012-06-11 | FGBX | Futures | 129.55 | 131.13 | 128.61 | 130.53 | 7769.0 |
| 2012-06-11 | FOAT | Futures | 99.21 | 99.21 | 98.42 | 98.82 | 9563.0 |
| 2012-06-11 | FTDX | Futures | 696.1 | 701.2 | 685.4 | 685.4 | 51.0 |
| 2012-06-11 | FTI | Futures | 252.97 | 252.97 | 246.59 | 247.74 | 10006.0 |
| 2012-06-11 | FTUK | Futures | 3960.5 | 4011.5 | 3901.5 | 3916.8 | 76151.0 |
| 2012-06-11 | FVSA | Futures | 9382.28 | 10132.86 | 9272.82 | 10039.04 | 1526.0 |
| 2012-06-11 | FXXP | Futures | 175.5 | 175.6 | 172.2 | 172.5 | 13808.0 |
| 2012-06-11 | G | Futures | 98.61 | 99.17 | 98.51 | 99.05 | 124874.0 |
| 2012-06-11 | GF | Futures | 314.542 | 316.565 | 313.851 | 316.269 | 2746.0 |
| 2012-06-11 | GSCI | Futures | 937.19 | 937.59 | 910.73 | 918.97 | 2086.0 |
| 2012-06-11 | HE | Futures | 97.846 | 98.661 | 97.714 | 98.609 | 21273.0 |
| 2012-06-11 | HG | Futures | 4.4428 | 4.4527 | 4.3309 | 4.378 | 66255.0 |
| 2012-06-11 | HO | Futures | 2.2175 | 2.2453 | 2.143 | 2.164 | 19121.0 |
| 2012-06-11 | HRC | Futures | 2490.3 | 2490.3 | 2490.3 | 2490.3 | 0.0 |
| 2012-06-11 | J1 | Futures | 0.0157789 | 0.0158103 | 0.0157376 | 0.0157902 | 19308.0 |
| 2012-06-11 | J7 | Futures | 0.015705 | 0.015752 | 0.015681 | 0.015728 | 80.0 |
| 2012-06-11 | JB | Futures | 126.1 | 126.14 | 125.82 | 125.85 | 1961.0 |
> showing 50 of 96 rows — these rows as CSV