PREVIEW / futures_daily / 2012-09-26
file: by_date/futures_daily/2012/2012-09-26.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-09-26 | ES | Futures | 1462.3 | 1465.35 | 1449.32 | 1452.38 | 1793271.0 |
| 2012-09-26 | NQ | Futures | 3226.6 | 3230.05 | 3178.28 | 3192.08 | 253321.0 |
| 2012-09-26 | YM | Futures | 13089.9 | 13110.4 | 13018.6 | 13031.3 | 121899.0 |
| 2012-09-26 | CL | Futures | 163.91 | 164.85 | 160.54 | 162.4 | 272057.0 |
| 2012-09-26 | GC | Futures | 2353.4 | 2361.1 | 2320.9 | 2341.3 | 196374.0 |
| 2012-09-26 | ZN | Futures | 117.09597 | 117.494255 | 117.0273 | 117.466787 | 863167.0 |
| 2012-09-26 | A6 | Futures | 0.93726 | 0.93735 | 0.93199 | 0.93444 | 116618.0 |
| 2012-09-26 | AD | Futures | 1.02195 | 1.02235 | 1.01603 | 1.01744 | 84272.0 |
| 2012-09-26 | B | Futures | 99.96 | 100.3 | 98.69 | 100.1 | 137986.0 |
| 2012-09-26 | B6 | Futures | 1.6908 | 1.6924 | 1.6849 | 1.6868 | 102244.0 |
| 2012-09-26 | BR | Futures | 0.2367 | 0.2367 | 0.2367 | 0.2367 | 440.0 |
| 2012-09-26 | BZ | Futures | 103.71 | 103.87 | 103.71 | 103.87 | 4901.0 |
| 2012-09-26 | C | Futures | 1617.0 | 1643.0 | 1608.0 | 1619.0 | 10751.0 |
| 2012-09-26 | CC | Futures | 1873.0 | 1891.0 | 1855.0 | 1862.0 | 7801.0 |
| 2012-09-26 | CSC | Futures | 4.126 | 4.126 | 4.078 | 4.078 | 6.0 |
| 2012-09-26 | CT | Futures | 93.34 | 93.77 | 91.59 | 91.65 | 19519.0 |
| 2012-09-26 | DC | Futures | 31.02 | 31.14 | 30.57 | 30.7 | 99.0 |
| 2012-09-26 | DX | Futures | 77.223 | 77.566 | 77.169 | 77.439 | 17196.0 |
| 2012-09-26 | E1 | Futures | 1.3748 | 1.3757 | 1.36849 | 1.37119 | 30710.0 |
| 2012-09-26 | E6 | Futures | 1.52073 | 1.52191 | 1.51272 | 1.51566 | 242644.0 |
| 2012-09-26 | E7 | Futures | 1.5113 | 1.5128 | 1.5038 | 1.5066 | 3908.0 |
| 2012-09-26 | ED | Futures | 95.211 | 95.211 | 95.1775 | 95.1919 | 254266.0 |
| 2012-09-26 | ER | Futures | 97.871 | 97.876 | 97.847 | 97.857 | 177613.0 |
| 2012-09-26 | EW | Futures | 1006.9 | 1008.9 | 993.6 | 996.7 | 19341.0 |
| 2012-09-26 | FBTP | Futures | 70.67 | 70.67 | 70.11 | 70.3 | 25159.0 |
| 2012-09-26 | FBTS | Futures | 88.989 | 89.039 | 88.813 | 88.897 | 2759.0 |
| 2012-09-26 | FCE | Futures | 2599.9 | 2605.9 | 2554.6 | 2555.8 | 119227.0 |
| 2012-09-26 | FDAX | Futures | 8071.5 | 8080.8 | 7952.1 | 7991.5 | 136246.0 |
| 2012-09-26 | FESX | Futures | 1725.3 | 1729.4 | 1694.0 | 1701.5 | 1297680.0 |
| 2012-09-26 | FGBL | Futures | 117.58 | 118.45 | 117.52 | 118.37 | 884298.0 |
| 2012-09-26 | FGBM | Futures | 115.92 | 116.28 | 115.89 | 116.24 | 461610.0 |
| 2012-09-26 | FGBS | Futures | 110.298 | 110.358 | 110.278 | 110.348 | 387258.0 |
| 2012-09-26 | FGBX | Futures | 123.67 | 125.81 | 123.6 | 125.66 | 7261.0 |
| 2012-09-26 | FOAT | Futures | 102.37 | 102.91 | 102.28 | 102.82 | 19462.0 |
| 2012-09-26 | FTDX | Futures | 758.9 | 758.9 | 753.8 | 756.6 | 39.0 |
| 2012-09-26 | FTI | Futures | 283.23 | 283.36 | 279.82 | 279.99 | 31280.0 |
| 2012-09-26 | FTUK | Futures | 4236.6 | 4243.5 | 4188.6 | 4205.8 | 86299.0 |
| 2012-09-26 | FVSA | Futures | 5450.18 | 5804.57 | 5450.18 | 5706.8 | 7814.0 |
| 2012-09-26 | FXXP | Futures | 196.9 | 196.9 | 194.5 | 195.1 | 1313.0 |
| 2012-09-26 | G | Futures | 98.99 | 99.82 | 98.98 | 99.79 | 158904.0 |
| 2012-09-26 | GF | Futures | 282.867 | 285.544 | 280.823 | 284.425 | 2875.0 |
| 2012-09-26 | GSCI | Futures | 1047.93 | 1053.17 | 1043.41 | 1053.17 | 274.0 |
| 2012-09-26 | HE | Futures | 92.851 | 93.255 | 91.857 | 92.447 | 20689.0 |
| 2012-09-26 | HG | Futures | 4.7947 | 4.8274 | 4.7298 | 4.7677 | 48044.0 |
| 2012-09-26 | HH | Futures | 40.434 | 40.995 | 40.37 | 40.995 | 217.0 |
| 2012-09-26 | HO | Futures | 2.4947 | 2.5028 | 2.4691 | 2.5005 | 42503.0 |
| 2012-09-26 | HRC | Futures | 2443.1 | 2443.1 | 2443.1 | 2443.1 | 50.0 |
| 2012-09-26 | J1 | Futures | 0.0161022 | 0.0161485 | 0.0160821 | 0.0161197 | 64610.0 |
| 2012-09-26 | J7 | Futures | 0.016034 | 0.01608 | 0.016015 | 0.016051 | 430.0 |
| 2012-09-26 | JB | Futures | 126.78 | 126.89 | 126.7 | 126.87 | 2568.0 |
> showing 50 of 97 rows — these rows as CSV