PREVIEW / futures_daily / 2012-09-04
file: by_date/futures_daily/2012/2012-09-04.parquet size: 9 KB rows: 100
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-09-04 | ES | Futures | 1424.14 | 1427.43 | 1412.24 | 1423.88 | 1680397.0 |
| 2012-09-04 | NQ | Futures | 3182.75 | 3193.94 | 3148.03 | 3184.47 | 239905.0 |
| 2012-09-04 | YM | Futures | 12672.4 | 12729.7 | 12578.3 | 12660.8 | 134241.0 |
| 2012-09-04 | CL | Futures | 174.36 | 176.15 | 171.81 | 172.41 | 256147.0 |
| 2012-09-04 | GC | Futures | 2260.9 | 2271.9 | 2253.2 | 2264.4 | 179166.0 |
| 2012-09-04 | ZN | Futures | 117.489302 | 117.543777 | 117.148832 | 117.189688 | 119286.0 |
| 2012-09-04 | A6 | Futures | 0.92472 | 0.92499 | 0.91744 | 0.91852 | 168029.0 |
| 2012-09-04 | AD | Futures | 1.01584 | 1.01835 | 1.01464 | 1.01714 | 106147.0 |
| 2012-09-04 | B | Futures | 104.95 | 105.8 | 103.4 | 103.62 | 133611.0 |
| 2012-09-04 | B6 | Futures | 1.6594 | 1.663 | 1.6565 | 1.6597 | 112806.0 |
| 2012-09-04 | BFX | Futures | 2828.6 | 2828.6 | 2813.0 | 2815.5 | 91.0 |
| 2012-09-04 | BR | Futures | 0.23549 | 0.23549 | 0.23439 | 0.23473 | 362.0 |
| 2012-09-04 | BZ | Futures | 109.9 | 110.37 | 108.44 | 108.6 | 431.0 |
| 2012-09-04 | C | Futures | 1686.0 | 1695.0 | 1664.0 | 1680.0 | 2596.0 |
| 2012-09-04 | CB | Futures | 100.891 | 100.891 | 100.623 | 100.623 | 9.0 |
| 2012-09-04 | CC | Futures | 1953.0 | 1956.0 | 1909.0 | 1924.0 | 14795.0 |
| 2012-09-04 | CSC | Futures | 4.078 | 4.103 | 4.078 | 4.099 | 11.0 |
| 2012-09-04 | CT | Futures | 100.84 | 100.85 | 98.4 | 98.84 | 39.0 |
| 2012-09-04 | DC | Futures | 30.34 | 30.8 | 30.24 | 30.68 | 65.0 |
| 2012-09-04 | DX | Futures | 78.848 | 79.003 | 78.673 | 78.927 | 12608.0 |
| 2012-09-04 | E1 | Futures | 1.35262 | 1.35804 | 1.3499 | 1.35145 | 42336.0 |
| 2012-09-04 | E6 | Futures | 1.48406 | 1.48984 | 1.48111 | 1.48324 | 268497.0 |
| 2012-09-04 | E7 | Futures | 1.4754 | 1.4805 | 1.4719 | 1.474 | 4806.0 |
| 2012-09-04 | ED | Futures | 95.1967 | 95.2015 | 95.1943 | 95.1991 | 96949.0 |
| 2012-09-04 | ER | Futures | 97.866 | 97.871 | 97.857 | 97.866 | 66629.0 |
| 2012-09-04 | EW | Futures | 984.6 | 997.6 | 976.9 | 997.4 | 30827.0 |
| 2012-09-04 | FBTP | Futures | 66.84 | 67.53 | 66.56 | 67.32 | 38408.0 |
| 2012-09-04 | FBTS | Futures | 87.94 | 88.577 | 87.932 | 88.478 | 8483.0 |
| 2012-09-04 | FCE | Futures | 2566.5 | 2574.3 | 2524.0 | 2529.2 | 95101.0 |
| 2012-09-04 | FDAX | Futures | 7645.2 | 7663.2 | 7554.6 | 7578.6 | 114815.0 |
| 2012-09-04 | FESX | Futures | 1663.7 | 1669.1 | 1644.8 | 1649.5 | 874297.0 |
| 2012-09-04 | FEU3 | Futures | 98.448 | 98.448 | 98.448 | 98.448 | 40.0 |
| 2012-09-04 | FGBL | Futures | 118.58 | 118.68 | 118.13 | 118.53 | 1413126.0 |
| 2012-09-04 | FGBM | Futures | 116.47 | 116.57 | 116.31 | 116.5 | 889395.0 |
| 2012-09-04 | FGBS | Futures | 110.497 | 110.527 | 110.482 | 110.512 | 904901.0 |
| 2012-09-04 | FGBX | Futures | 127.82 | 127.95 | 126.56 | 127.6 | 60651.0 |
| 2012-09-04 | FOAT | Futures | 102.37 | 102.39 | 102.06 | 102.28 | 70099.0 |
| 2012-09-04 | FTDX | Futures | 741.7 | 743.1 | 735.6 | 735.6 | 53.0 |
| 2012-09-04 | FTI | Futures | 281.88 | 283.2 | 279.41 | 279.83 | 24334.0 |
| 2012-09-04 | FTUK | Futures | 4185.5 | 4191.7 | 4113.8 | 4123.2 | 91893.0 |
| 2012-09-04 | FVSA | Futures | 6827.39 | 6929.87 | 6673.68 | 6917.06 | 4250.0 |
| 2012-09-04 | FXXP | Futures | 192.1 | 192.1 | 190.0 | 190.4 | 3281.0 |
| 2012-09-04 | G | Futures | 99.66 | 100.07 | 99.37 | 99.97 | 156758.0 |
| 2012-09-04 | GF | Futures | 285.51 | 286.347 | 284.722 | 285.658 | 761.0 |
| 2012-09-04 | GSCI | Futures | 1089.85 | 1096.05 | 1079.46 | 1079.46 | 150.0 |
| 2012-09-04 | HE | Futures | 91.669 | 91.855 | 90.588 | 91.7 | 17891.0 |
| 2012-09-04 | HG | Futures | 4.4464 | 4.4978 | 4.4111 | 4.458 | 54897.0 |
| 2012-09-04 | HH | Futures | 38.259 | 38.259 | 38.259 | 38.259 | 293.0 |
| 2012-09-04 | HO | Futures | 2.5776 | 2.6023 | 2.5481 | 2.5498 | 17619.0 |
| 2012-09-04 | HRC | Futures | 2471.7 | 2471.7 | 2471.7 | 2471.7 | 0.0 |
> showing 50 of 100 rows — these rows as CSV