PREVIEW / futures_daily / 2012-10-15
file: by_date/futures_daily/2012/2012-10-15.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-10-15 | ES | Futures | 1448.82 | 1462.05 | 1441.69 | 1461.03 | 1525436.0 |
| 2012-10-15 | NQ | Futures | 3121.61 | 3148.36 | 3112.4 | 3142.61 | 217875.0 |
| 2012-10-15 | YM | Futures | 12943.4 | 13054.7 | 12897.5 | 13044.9 | 107657.0 |
| 2012-10-15 | CL | Futures | 165.79 | 166.93 | 162.69 | 166.39 | 144320.0 |
| 2012-10-15 | GC | Futures | 2343.4 | 2343.8 | 2309.4 | 2319.9 | 172769.0 |
| 2012-10-15 | ZN | Futures | 117.178374 | 117.260778 | 116.972364 | 117.178374 | 622721.0 |
| 2012-10-15 | A6 | Futures | 0.92681 | 0.92753 | 0.92235 | 0.92608 | 93952.0 |
| 2012-10-15 | AD | Futures | 1.02416 | 1.02597 | 1.02145 | 1.02406 | 75818.0 |
| 2012-10-15 | B | Futures | 103.86 | 104.92 | 103.06 | 104.84 | 246185.0 |
| 2012-10-15 | B6 | Futures | 1.6787 | 1.6791 | 1.6728 | 1.6785 | 81589.0 |
| 2012-10-15 | BFX | Futures | 2845.0 | 2849.5 | 2845.0 | 2847.3 | 50.0 |
| 2012-10-15 | BR | Futures | 0.23668 | 0.2374 | 0.23638 | 0.23721 | 253.0 |
| 2012-10-15 | BZ | Futures | 107.53 | 108.8 | 106.98 | 108.79 | 1021.0 |
| 2012-10-15 | C | Futures | 1531.0 | 1544.0 | 1530.0 | 1535.0 | 4292.0 |
| 2012-10-15 | CC | Futures | 1779.0 | 1784.0 | 1766.0 | 1775.0 | 6398.0 |
| 2012-10-15 | CSC | Futures | 4.252 | 4.252 | 4.236 | 4.236 | 13.0 |
| 2012-10-15 | CT | Futures | 92.17 | 93.43 | 91.74 | 93.35 | 12067.0 |
| 2012-10-15 | DC | Futures | 31.87 | 31.9 | 31.47 | 31.49 | 109.0 |
| 2012-10-15 | DX | Futures | 77.315 | 77.533 | 77.179 | 77.301 | 14000.0 |
| 2012-10-15 | E1 | Futures | 1.38084 | 1.38278 | 1.3748 | 1.37956 | 22092.0 |
| 2012-10-15 | E6 | Futures | 1.5265 | 1.52932 | 1.51884 | 1.52485 | 194490.0 |
| 2012-10-15 | E7 | Futures | 1.5174 | 1.5202 | 1.5099 | 1.5157 | 3323.0 |
| 2012-10-15 | ED | Futures | 95.2444 | 95.254 | 95.2349 | 95.2444 | 126647.0 |
| 2012-10-15 | ER | Futures | 97.866 | 97.866 | 97.857 | 97.862 | 58423.0 |
| 2012-10-15 | EW | Futures | 992.8 | 1001.7 | 988.1 | 1000.9 | 20537.0 |
| 2012-10-15 | FBTP | Futures | 72.01 | 72.27 | 71.91 | 72.0 | 11020.0 |
| 2012-10-15 | FBTS | Futures | 89.65 | 89.751 | 89.608 | 89.642 | 2157.0 |
| 2012-10-15 | FCE | Futures | 2543.4 | 2584.7 | 2541.1 | 2570.4 | 29192.0 |
| 2012-10-15 | FDAX | Futures | 7926.3 | 8004.1 | 7912.1 | 7959.2 | 114249.0 |
| 2012-10-15 | FESX | Futures | 1674.3 | 1698.8 | 1670.9 | 1687.9 | 855051.0 |
| 2012-10-15 | FGBL | Futures | 118.47 | 118.54 | 118.17 | 118.3 | 475656.0 |
| 2012-10-15 | FGBM | Futures | 116.35 | 116.37 | 116.22 | 116.28 | 292040.0 |
| 2012-10-15 | FGBS | Futures | 110.338 | 110.343 | 110.313 | 110.328 | 120175.0 |
| 2012-10-15 | FGBX | Futures | 125.74 | 125.97 | 124.9 | 125.09 | 3966.0 |
| 2012-10-15 | FOAT | Futures | 104.11 | 104.4 | 104.05 | 104.25 | 18199.0 |
| 2012-10-15 | FTDX | Futures | 768.4 | 774.5 | 762.7 | 768.4 | 44.0 |
| 2012-10-15 | FTI | Futures | 280.98 | 283.17 | 280.98 | 281.75 | 14921.0 |
| 2012-10-15 | FTUK | Futures | 4218.3 | 4250.8 | 4202.2 | 4229.6 | 70927.0 |
| 2012-10-15 | FVSA | Futures | 5308.17 | 5443.7 | 5308.17 | 5375.93 | 10396.0 |
| 2012-10-15 | FXXP | Futures | 194.0 | 195.8 | 193.9 | 194.9 | 1921.0 |
| 2012-10-15 | G | Futures | 99.36 | 99.41 | 99.11 | 99.22 | 89478.0 |
| 2012-10-15 | GF | Futures | 278.051 | 279.539 | 277.859 | 279.491 | 1611.0 |
| 2012-10-15 | GSCI | Futures | 1073.31 | 1074.04 | 1061.26 | 1072.91 | 114.0 |
| 2012-10-15 | HE | Futures | 97.015 | 98.009 | 97.015 | 97.637 | 14257.0 |
| 2012-10-15 | HG | Futures | 4.7587 | 4.7683 | 4.6854 | 4.7568 | 48603.0 |
| 2012-10-15 | HH | Futures | 44.451 | 44.451 | 44.451 | 44.451 | 1506.0 |
| 2012-10-15 | HO | Futures | 2.593 | 2.602 | 2.5635 | 2.588 | 45995.0 |
| 2012-10-15 | HRC | Futures | 2430.8 | 2430.8 | 2430.8 | 2430.8 | 0.0 |
| 2012-10-15 | J1 | Futures | 0.0159707 | 0.0159933 | 0.0158831 | 0.0159194 | 81771.0 |
| 2012-10-15 | J7 | Futures | 0.015901 | 0.015923 | 0.015817 | 0.015852 | 664.0 |
> showing 50 of 98 rows — these rows as CSV