PREVIEW / futures_daily / 2012-07-16
file: by_date/futures_daily/2012/2012-07-16.parquet size: 9 KB rows: 97
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-07-16 | ES | Futures | 1368.44 | 1369.7 | 1360.08 | 1364.64 | 1547166.0 |
| 2012-07-16 | NQ | Futures | 2958.07 | 2966.39 | 2939.71 | 2951.47 | 158595.0 |
| 2012-07-16 | YM | Futures | 12334.8 | 12338.7 | 12247.5 | 12270.8 | 90015.0 |
| 2012-07-16 | CL | Futures | 158.84 | 161.29 | 157.56 | 161.19 | 112131.0 |
| 2012-07-16 | GC | Futures | 2127.5 | 2131.7 | 2108.4 | 2127.6 | 101745.0 |
| 2012-07-16 | ZN | Futures | 117.312258 | 117.679965 | 117.271401 | 117.502921 | 608981.0 |
| 2012-07-16 | A6 | Futures | 0.91582 | 0.91726 | 0.91195 | 0.91663 | 94097.0 |
| 2012-07-16 | AD | Futures | 0.98706 | 0.98807 | 0.98416 | 0.98676 | 71813.0 |
| 2012-07-16 | B | Futures | 91.25 | 93.04 | 90.75 | 92.86 | 220818.0 |
| 2012-07-16 | B6 | Futures | 1.6278 | 1.6359 | 1.6215 | 1.633 | 102516.0 |
| 2012-07-16 | BR | Futures | 0.2321 | 0.23274 | 0.23191 | 0.23265 | 96.0 |
| 2012-07-16 | BZ | Futures | 97.77 | 99.65 | 97.17 | 99.49 | 1691.0 |
| 2012-07-16 | C | Futures | 1560.0 | 1565.0 | 1526.0 | 1529.0 | 5474.0 |
| 2012-07-16 | CB | Futures | 87.059 | 87.059 | 86.924 | 86.924 | 3.0 |
| 2012-07-16 | CC | Futures | 1671.0 | 1685.0 | 1640.0 | 1655.0 | 11372.0 |
| 2012-07-16 | CSC | Futures | 4.045 | 4.105 | 4.045 | 4.095 | 14.0 |
| 2012-07-16 | CT | Futures | 94.49 | 95.24 | 94.08 | 95.24 | 59.0 |
| 2012-07-16 | DC | Futures | 29.93 | 30.63 | 29.93 | 30.5 | 460.0 |
| 2012-07-16 | DX | Futures | 80.949 | 81.308 | 80.687 | 80.773 | 15625.0 |
| 2012-07-16 | E1 | Futures | 1.31918 | 1.32305 | 1.31091 | 1.32163 | 32426.0 |
| 2012-07-16 | E6 | Futures | 1.44572 | 1.45103 | 1.43723 | 1.44926 | 211953.0 |
| 2012-07-16 | E7 | Futures | 1.437 | 1.442 | 1.4283 | 1.4403 | 2738.0 |
| 2012-07-16 | ED | Futures | 95.1847 | 95.1943 | 95.1752 | 95.18 | 249990.0 |
| 2012-07-16 | ER | Futures | 97.744 | 97.759 | 97.734 | 97.734 | 109088.0 |
| 2012-07-16 | EW | Futures | 953.2 | 953.2 | 941.6 | 947.2 | 16187.0 |
| 2012-07-16 | FBTP | Futures | 64.78 | 65.08 | 64.36 | 64.58 | 12280.0 |
| 2012-07-16 | FBTS | Futures | 84.856 | 84.98 | 84.476 | 84.583 | 2611.0 |
| 2012-07-16 | FCE | Futures | 2365.9 | 2369.2 | 2350.6 | 2365.1 | 41142.0 |
| 2012-07-16 | FDAX | Futures | 7156.6 | 7182.3 | 7108.0 | 7179.6 | 87014.0 |
| 2012-07-16 | FESX | Futures | 1523.0 | 1526.4 | 1509.5 | 1523.0 | 642998.0 |
| 2012-07-16 | FEU3 | Futures | 98.33 | 98.33 | 98.315 | 98.315 | 20.0 |
| 2012-07-16 | FGBL | Futures | 119.67 | 120.01 | 119.49 | 119.8 | 417811.0 |
| 2012-07-16 | FGBM | Futures | 116.75 | 116.89 | 116.7 | 116.83 | 249297.0 |
| 2012-07-16 | FGBS | Futures | 110.527 | 110.542 | 110.507 | 110.537 | 205302.0 |
| 2012-07-16 | FGBX | Futures | 128.82 | 129.08 | 128.12 | 128.57 | 6705.0 |
| 2012-07-16 | FOAT | Futures | 101.63 | 102.3 | 101.61 | 102.24 | 10671.0 |
| 2012-07-16 | FTDX | Futures | 699.3 | 702.1 | 699.3 | 702.1 | 51.0 |
| 2012-07-16 | FTI | Futures | 266.58 | 267.86 | 266.03 | 267.48 | 7831.0 |
| 2012-07-16 | FTUK | Futures | 4102.5 | 4103.2 | 4073.3 | 4093.4 | 54198.0 |
| 2012-07-16 | FVSA | Futures | 7399.47 | 7399.47 | 6997.62 | 7094.62 | 4868.0 |
| 2012-07-16 | FXXP | Futures | 182.8 | 183.7 | 180.5 | 183.6 | 4182.0 |
| 2012-07-16 | G | Futures | 100.13 | 100.61 | 100.13 | 100.36 | 79639.0 |
| 2012-07-16 | GF | Futures | 269.642 | 269.642 | 268.409 | 268.409 | 1865.0 |
| 2012-07-16 | GSCI | Futures | 991.86 | 1004.75 | 991.86 | 1003.56 | 410.0 |
| 2012-07-16 | HE | Futures | 96.823 | 97.064 | 95.861 | 96.663 | 19707.0 |
| 2012-07-16 | HG | Futures | 4.5141 | 4.5193 | 4.4645 | 4.4897 | 30959.0 |
| 2012-07-16 | HO | Futures | 2.28 | 2.3175 | 2.2708 | 2.3121 | 33108.0 |
| 2012-07-16 | HRC | Futures | 2429.9 | 2450.1 | 2429.9 | 2450.1 | 5.0 |
| 2012-07-16 | J1 | Futures | 0.0158253 | 0.0159393 | 0.0158241 | 0.0159118 | 50764.0 |
| 2012-07-16 | J7 | Futures | 0.015769 | 0.015877 | 0.015766 | 0.015849 | 287.0 |
> showing 50 of 97 rows — these rows as CSV