PREVIEW / futures_daily / 2012-06-25
file: by_date/futures_daily/2012/2012-06-25.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 |
|---|---|---|---|---|---|---|---|
| 2012-06-25 | ES | Futures | 1342.36 | 1343.37 | 1319.07 | 1323.12 | 1843892.0 |
| 2012-06-25 | NQ | Futures | 2954.06 | 2958.07 | 2893.51 | 2899.82 | 186964.0 |
| 2012-06-25 | YM | Futures | 12191.2 | 12191.2 | 12017.6 | 12060.2 | 120328.0 |
| 2012-06-25 | CL | Futures | 146.26 | 147.14 | 142.3 | 144.46 | 249004.0 |
| 2012-06-25 | GC | Futures | 2102.2 | 2124.2 | 2094.6 | 2123.4 | 114462.0 |
| 2012-06-25 | ZN | Futures | 115.93676 | 116.440655 | 115.923141 | 116.413417 | 657217.0 |
| 2012-06-25 | A6 | Futures | 0.89703 | 0.89712 | 0.88965 | 0.89145 | 121424.0 |
| 2012-06-25 | AD | Futures | 0.97553 | 0.97614 | 0.96992 | 0.97213 | 80343.0 |
| 2012-06-25 | B | Futures | 82.61 | 82.65 | 80.81 | 82.04 | 119183.0 |
| 2012-06-25 | B6 | Futures | 1.629 | 1.6292 | 1.6235 | 1.6261 | 63080.0 |
| 2012-06-25 | BFX | Futures | 2534.9 | 2534.9 | 2524.1 | 2525.0 | 29.0 |
| 2012-06-25 | BR | Futures | 0.22775 | 0.22799 | 0.22775 | 0.22799 | 428.0 |
| 2012-06-25 | BZ | Futures | 87.83 | 87.91 | 87.83 | 87.91 | 2498.0 |
| 2012-06-25 | C | Futures | 1501.0 | 1503.0 | 1485.0 | 1487.0 | 3881.0 |
| 2012-06-25 | CB | Futures | 84.906 | 85.04 | 84.906 | 84.906 | 3.0 |
| 2012-06-25 | CC | Futures | 1588.0 | 1596.0 | 1571.0 | 1584.0 | 8376.0 |
| 2012-06-25 | CSC | Futures | 3.756 | 3.793 | 3.754 | 3.786 | 27.0 |
| 2012-06-25 | CT | Futures | 90.74 | 93.04 | 90.67 | 92.88 | 102.0 |
| 2012-06-25 | DC | Futures | 27.33 | 27.8 | 27.33 | 27.75 | 178.0 |
| 2012-06-25 | DX | Futures | 80.066 | 80.391 | 80.037 | 80.233 | 18705.0 |
| 2012-06-25 | E1 | Futures | 1.35249 | 1.35275 | 1.34371 | 1.34642 | 29663.0 |
| 2012-06-25 | E6 | Futures | 1.48206 | 1.48265 | 1.47227 | 1.47521 | 214261.0 |
| 2012-06-25 | E7 | Futures | 1.473 | 1.4733 | 1.4632 | 1.466 | 2184.0 |
| 2012-06-25 | ED | Futures | 95.1369 | 95.1608 | 95.1369 | 95.1465 | 286027.0 |
| 2012-06-25 | ER | Futures | 97.626 | 97.646 | 97.616 | 97.631 | 93525.0 |
| 2012-06-25 | EW | Futures | 922.5 | 922.5 | 903.5 | 907.6 | 25511.0 |
| 2012-06-25 | FBTP | Futures | 65.81 | 65.89 | 64.84 | 64.95 | 18156.0 |
| 2012-06-25 | FBTS | Futures | 84.666 | 84.724 | 83.64 | 83.74 | 6063.0 |
| 2012-06-25 | FCE | Futures | 2287.6 | 2289.1 | 2223.9 | 2235.8 | 118714.0 |
| 2012-06-25 | FDAX | Futures | 6838.4 | 6845.5 | 6682.2 | 6714.5 | 128806.0 |
| 2012-06-25 | FESX | Futures | 1473.0 | 1475.0 | 1431.7 | 1438.5 | 1176494.0 |
| 2012-06-25 | FEU3 | Futures | 98.211 | 98.216 | 98.211 | 98.211 | 26.0 |
| 2012-06-25 | FGBL | Futures | 116.45 | 117.5 | 116.42 | 117.41 | 652927.0 |
| 2012-06-25 | FGBM | Futures | 114.85 | 115.45 | 114.83 | 115.39 | 364837.0 |
| 2012-06-25 | FGBS | Futures | 110.118 | 110.263 | 110.098 | 110.233 | 348987.0 |
| 2012-06-25 | FGBX | Futures | 124.7 | 126.7 | 124.7 | 126.49 | 7410.0 |
| 2012-06-25 | FOAT | Futures | 98.56 | 98.92 | 98.45 | 98.71 | 13800.0 |
| 2012-06-25 | FTDX | Futures | 681.2 | 681.2 | 670.9 | 672.3 | 202.0 |
| 2012-06-25 | FTI | Futures | 253.4 | 253.86 | 249.15 | 250.51 | 35880.0 |
| 2012-06-25 | FTUK | Futures | 3988.9 | 3990.7 | 3924.5 | 3937.6 | 86603.0 |
| 2012-06-25 | FVSA | Futures | 8591.97 | 8983.88 | 8591.97 | 8863.29 | 6867.0 |
| 2012-06-25 | FXXP | Futures | 175.2 | 175.3 | 172.8 | 173.4 | 1501.0 |
| 2012-06-25 | G | Futures | 98.83 | 99.03 | 98.76 | 98.91 | 101974.0 |
| 2012-06-25 | GF | Futures | 299.0 | 299.641 | 295.644 | 295.644 | 3870.0 |
| 2012-06-25 | GSCI | Futures | 893.15 | 901.62 | 890.53 | 897.98 | 208.0 |
| 2012-06-25 | HE | Futures | 100.109 | 100.635 | 97.793 | 98.267 | 10944.0 |
| 2012-06-25 | HG | Futures | 4.2784 | 4.3125 | 4.2359 | 4.2842 | 27781.0 |
| 2012-06-25 | HO | Futures | 2.0915 | 2.0954 | 2.0568 | 2.0766 | 23398.0 |
| 2012-06-25 | HRC | Futures | 2429.9 | 2429.9 | 2429.9 | 2429.9 | 0.0 |
| 2012-06-25 | J1 | Futures | 0.0155859 | 0.0157927 | 0.0155596 | 0.0157451 | 80380.0 |
> showing 50 of 98 rows — these rows as CSV