PREVIEW / futures_daily / 2012-08-16
file: by_date/futures_daily/2012/2012-08-16.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-08-16 | ES | Futures | 1421.35 | 1433.51 | 1419.58 | 1430.97 | 1495429.0 |
| 2012-08-16 | NQ | Futures | 3144.87 | 3183.89 | 3142.86 | 3171.84 | 208209.0 |
| 2012-08-16 | YM | Futures | 12745.2 | 12850.9 | 12728.7 | 12830.6 | 96188.0 |
| 2012-08-16 | CL | Futures | 171.07 | 173.75 | 170.44 | 173.47 | 99281.0 |
| 2012-08-16 | GC | Futures | 2144.0 | 2165.6 | 2140.2 | 2161.9 | 107456.0 |
| 2012-08-16 | ZN | Futures | 115.473721 | 115.664384 | 115.187726 | 115.364771 | 1083471.0 |
| 2012-08-16 | A6 | Futures | 0.94172 | 0.94396 | 0.93929 | 0.94343 | 94483.0 |
| 2012-08-16 | AD | Futures | 1.01273 | 1.01614 | 1.01203 | 1.01604 | 72790.0 |
| 2012-08-16 | B | Futures | 103.83 | 104.77 | 103.19 | 104.65 | 213343.0 |
| 2012-08-16 | B6 | Futures | 1.6388 | 1.6454 | 1.634 | 1.6448 | 111999.0 |
| 2012-08-16 | BFX | Futures | 2815.1 | 2838.4 | 2815.1 | 2838.4 | 59.0 |
| 2012-08-16 | BR | Futures | 0.23568 | 0.23592 | 0.2352 | 0.23592 | 69.0 |
| 2012-08-16 | BZ | Futures | 109.47 | 110.39 | 108.79 | 110.29 | 3561.0 |
| 2012-08-16 | C | Futures | 1664.0 | 1669.0 | 1635.0 | 1637.0 | 2040.0 |
| 2012-08-16 | CB | Futures | 97.42 | 97.42 | 97.42 | 97.42 | 5.0 |
| 2012-08-16 | CC | Futures | 1837.0 | 1845.0 | 1805.0 | 1810.0 | 22207.0 |
| 2012-08-16 | CSC | Futures | 4.149 | 4.231 | 4.149 | 4.225 | 13.0 |
| 2012-08-16 | CT | Futures | 95.77 | 95.98 | 95.1 | 95.33 | 20.0 |
| 2012-08-16 | DC | Futures | 30.5 | 31.36 | 30.42 | 31.17 | 653.0 |
| 2012-08-16 | DX | Futures | 80.284 | 80.522 | 79.954 | 79.995 | 19855.0 |
| 2012-08-16 | E1 | Futures | 1.32137 | 1.33092 | 1.31814 | 1.32963 | 41482.0 |
| 2012-08-16 | E6 | Futures | 1.45009 | 1.46 | 1.44596 | 1.4587 | 221999.0 |
| 2012-08-16 | E7 | Futures | 1.4406 | 1.451 | 1.4371 | 1.4496 | 3992.0 |
| 2012-08-16 | ED | Futures | 95.1728 | 95.1728 | 95.1656 | 95.1704 | 132369.0 |
| 2012-08-16 | ER | Futures | 97.822 | 97.827 | 97.817 | 97.817 | 45028.0 |
| 2012-08-16 | EW | Futures | 976.4 | 986.8 | 974.0 | 984.4 | 17491.0 |
| 2012-08-16 | FBTP | Futures | 66.52 | 66.72 | 66.08 | 66.54 | 8777.0 |
| 2012-08-16 | FBTS | Futures | 86.501 | 86.741 | 86.32 | 86.7 | 1656.0 |
| 2012-08-16 | FCE | Futures | 2578.4 | 2601.9 | 2557.5 | 2587.3 | 109115.0 |
| 2012-08-16 | FDAX | Futures | 7625.0 | 7662.1 | 7564.4 | 7634.3 | 88130.0 |
| 2012-08-16 | FESX | Futures | 1650.9 | 1667.8 | 1636.0 | 1659.0 | 857554.0 |
| 2012-08-16 | FGBL | Futures | 116.5 | 117.2 | 116.28 | 117.11 | 628227.0 |
| 2012-08-16 | FGBM | Futures | 115.57 | 115.94 | 115.52 | 115.88 | 337668.0 |
| 2012-08-16 | FGBS | Futures | 110.437 | 110.497 | 110.427 | 110.487 | 280656.0 |
| 2012-08-16 | FGBX | Futures | 122.32 | 124.4 | 122.17 | 124.08 | 7262.0 |
| 2012-08-16 | FOAT | Futures | 102.29 | 102.5 | 102.15 | 102.42 | 17157.0 |
| 2012-08-16 | FTDX | Futures | 730.5 | 732.8 | 726.3 | 731.9 | 89.0 |
| 2012-08-16 | FTI | Futures | 284.73 | 284.94 | 282.3 | 283.79 | 28084.0 |
| 2012-08-16 | FTUK | Futures | 4248.4 | 4260.1 | 4222.6 | 4240.1 | 65590.0 |
| 2012-08-16 | FVSA | Futures | 6673.68 | 6801.78 | 6660.87 | 6660.87 | 4125.0 |
| 2012-08-16 | FXXP | Futures | 193.7 | 194.8 | 193.4 | 194.3 | 4545.0 |
| 2012-08-16 | G | Futures | 98.92 | 99.25 | 98.86 | 99.0 | 135371.0 |
| 2012-08-16 | GF | Futures | 285.313 | 285.658 | 281.324 | 281.471 | 2728.0 |
| 2012-08-16 | GSCI | Futures | 1070.61 | 1076.57 | 1065.62 | 1074.63 | 243.0 |
| 2012-08-16 | HE | Futures | 93.616 | 94.141 | 93.059 | 93.461 | 11613.0 |
| 2012-08-16 | HG | Futures | 4.3177 | 4.3634 | 4.3048 | 4.3576 | 42877.0 |
| 2012-08-16 | HO | Futures | 2.5248 | 2.557 | 2.5133 | 2.5533 | 52285.0 |
| 2012-08-16 | HRC | Futures | 2548.9 | 2548.9 | 2548.9 | 2548.9 | 0.0 |
| 2012-08-16 | J1 | Futures | 0.0158654 | 0.0158754 | 0.015784 | 0.0158128 | 101185.0 |
| 2012-08-16 | J7 | Futures | 0.015803 | 0.015806 | 0.015722 | 0.015751 | 417.0 |
> showing 50 of 98 rows — these rows as CSV