PREVIEW / futures_daily / 2012-06-14
file: by_date/futures_daily/2012/2012-06-14.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-06-14 | ES | Futures | 1325.65 | 1344.64 | 1321.85 | 1343.12 | 2808502.0 |
| 2012-06-14 | NQ | Futures | 2896.38 | 2918.47 | 2879.74 | 2909.58 | 338260.0 |
| 2012-06-14 | YM | Futures | 12061.2 | 12254.3 | 12036.0 | 12230.0 | 172935.0 |
| 2012-06-14 | CL | Futures | 150.97 | 154.5 | 150.58 | 153.59 | 120117.0 |
| 2012-06-14 | GC | Futures | 2164.3 | 2177.6 | 2152.8 | 2165.1 | 153140.0 |
| 2012-06-14 | ZN | Futures | 116.549605 | 116.644937 | 116.113804 | 116.372561 | 1216684.0 |
| 2012-06-14 | A6 | Futures | 0.88678 | 0.89487 | 0.8848 | 0.88938 | 68867.0 |
| 2012-06-14 | AD | Futures | 0.97223 | 0.97844 | 0.97213 | 0.97503 | 48277.0 |
| 2012-06-14 | B | Futures | 87.54 | 88.88 | 87.09 | 88.23 | 246048.0 |
| 2012-06-14 | B6 | Futures | 1.6201 | 1.6262 | 1.6164 | 1.6226 | 65518.0 |
| 2012-06-14 | BFX | Futures | 2515.4 | 2518.0 | 2515.4 | 2518.0 | 14.0 |
| 2012-06-14 | BR | Futures | 0.22703 | 0.22868 | 0.22703 | 0.22868 | 56.0 |
| 2012-06-14 | BZ | Futures | 93.27 | 94.43 | 92.66 | 93.8 | 2047.0 |
| 2012-06-14 | C | Futures | 1566.0 | 1587.0 | 1555.0 | 1579.0 | 8314.0 |
| 2012-06-14 | CB | Futures | 82.618 | 82.874 | 82.618 | 82.874 | 4.0 |
| 2012-06-14 | CC | Futures | 1702.0 | 1710.0 | 1667.0 | 1705.0 | 14951.0 |
| 2012-06-14 | CSC | Futures | 3.665 | 3.671 | 3.636 | 3.636 | 7.0 |
| 2012-06-14 | CT | Futures | 91.93 | 95.53 | 91.33 | 95.53 | 19888.0 |
| 2012-06-14 | DC | Futures | 26.88 | 26.91 | 26.36 | 26.53 | 79.0 |
| 2012-06-14 | DX | Futures | 80.158 | 80.318 | 79.702 | 79.926 | 28530.0 |
| 2012-06-14 | E1 | Futures | 1.35442 | 1.36178 | 1.35158 | 1.35765 | 29070.0 |
| 2012-06-14 | E6 | Futures | 1.48347 | 1.49208 | 1.48076 | 1.4876 | 165852.0 |
| 2012-06-14 | E7 | Futures | 1.4747 | 1.4827 | 1.4717 | 1.4784 | 4190.0 |
| 2012-06-14 | ED | Futures | 95.0605 | 95.0701 | 95.0462 | 95.0605 | 294177.0 |
| 2012-06-14 | ER | Futures | 97.489 | 97.533 | 97.464 | 97.523 | 189034.0 |
| 2012-06-14 | EW | Futures | 913.6 | 923.2 | 910.0 | 921.6 | 36641.0 |
| 2012-06-14 | FBTP | Futures | 63.73 | 64.34 | 63.18 | 64.03 | 28037.0 |
| 2012-06-14 | FBTS | Futures | 82.946 | 83.31 | 82.698 | 83.202 | 5684.0 |
| 2012-06-14 | FCE | Futures | 2242.4 | 2249.8 | 2209.1 | 2238.7 | 107788.0 |
| 2012-06-14 | FDAX | Futures | 6796.3 | 6820.0 | 6717.8 | 6784.1 | 227749.0 |
| 2012-06-14 | FESX | Futures | 1440.5 | 1452.0 | 1425.7 | 1444.6 | 1353227.0 |
| 2012-06-14 | FEU3 | Futures | 98.053 | 98.103 | 98.053 | 98.103 | 1.0 |
| 2012-06-14 | FGBL | Futures | 117.28 | 117.64 | 116.9 | 117.15 | 965635.0 |
| 2012-06-14 | FGBM | Futures | 115.08 | 115.41 | 114.97 | 115.22 | 483919.0 |
| 2012-06-14 | FGBS | Futures | 110.123 | 110.243 | 110.123 | 110.213 | 380562.0 |
| 2012-06-14 | FGBX | Futures | 124.68 | 126.09 | 123.59 | 125.04 | 18533.0 |
| 2012-06-14 | FOAT | Futures | 97.84 | 98.22 | 97.46 | 97.96 | 14474.0 |
| 2012-06-14 | FTDX | Futures | 677.9 | 678.4 | 666.8 | 671.9 | 1961.0 |
| 2012-06-14 | FTI | Futures | 247.95 | 249.57 | 245.62 | 248.29 | 15350.0 |
| 2012-06-14 | FTUK | Futures | 3945.9 | 3965.2 | 3916.5 | 3954.3 | 91532.0 |
| 2012-06-14 | FVSA | Futures | 10265.14 | 10340.51 | 10099.33 | 10099.33 | 4747.0 |
| 2012-06-14 | FXXP | Futures | 172.2 | 172.2 | 170.9 | 172.1 | 5700.0 |
| 2012-06-14 | G | Futures | 98.46 | 98.91 | 98.0 | 98.45 | 186465.0 |
| 2012-06-14 | GF | Futures | 312.963 | 313.999 | 308.275 | 308.275 | 4670.0 |
| 2012-06-14 | GSCI | Futures | 915.33 | 925.39 | 912.48 | 920.56 | 323.0 |
| 2012-06-14 | HE | Futures | 99.24 | 100.161 | 99.109 | 99.504 | 20334.0 |
| 2012-06-14 | HG | Futures | 4.3544 | 4.4186 | 4.3459 | 4.3931 | 52119.0 |
| 2012-06-14 | HO | Futures | 2.1503 | 2.1676 | 2.1323 | 2.1577 | 16100.0 |
| 2012-06-14 | HRC | Futures | 2470.4 | 2470.4 | 2470.4 | 2470.4 | 0.0 |
| 2012-06-14 | J1 | Futures | 0.0157952 | 0.0158516 | 0.0157877 | 0.0158278 | 44498.0 |
> showing 50 of 99 rows — these rows as CSV