PREVIEW / futures_daily / 2012-06-13
file: by_date/futures_daily/2012/2012-06-13.parquet size: 9 KB rows: 99
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-06-13 | ES | Futures | 1336.48 | 1338.0 | 1320.36 | 1325.65 | 511475.0 |
| 2012-06-13 | NQ | Futures | 2920.73 | 2930.47 | 2886.64 | 2896.38 | 78437.0 |
| 2012-06-13 | YM | Futures | 12137.9 | 12157.3 | 12011.7 | 12058.3 | 151760.0 |
| 2012-06-13 | CL | Futures | 152.7 | 153.72 | 150.35 | 151.22 | 107219.0 |
| 2012-06-13 | GC | Futures | 2153.7 | 2173.6 | 2148.2 | 2164.8 | 128377.0 |
| 2012-06-13 | ZN | Futures | 116.127423 | 116.617699 | 115.841428 | 116.549605 | 1365742.0 |
| 2012-06-13 | A6 | Futures | 0.8875 | 0.89199 | 0.88516 | 0.88884 | 59878.0 |
| 2012-06-13 | AD | Futures | 0.97513 | 0.97704 | 0.97132 | 0.97303 | 52613.0 |
| 2012-06-13 | B | Futures | 88.13 | 89.03 | 87.5 | 87.82 | 241109.0 |
| 2012-06-13 | B6 | Futures | 1.6267 | 1.6296 | 1.6195 | 1.6221 | 60231.0 |
| 2012-06-13 | BFX | Futures | 2536.2 | 2536.2 | 2503.2 | 2507.9 | 123.0 |
| 2012-06-13 | BR | Futures | 0.22804 | 0.22804 | 0.22739 | 0.22739 | 91.0 |
| 2012-06-13 | BZ | Futures | 93.65 | 94.55 | 93.09 | 93.37 | 1607.0 |
| 2012-06-13 | C | Futures | 1564.0 | 1569.0 | 1547.0 | 1567.0 | 5470.0 |
| 2012-06-13 | CB | Futures | 82.349 | 83.426 | 82.349 | 83.426 | 14.0 |
| 2012-06-13 | CC | Futures | 1681.0 | 1707.0 | 1671.0 | 1702.0 | 13121.0 |
| 2012-06-13 | CSC | Futures | 3.697 | 3.697 | 3.697 | 3.697 | 6.0 |
| 2012-06-13 | CT | Futures | 92.55 | 93.4 | 90.83 | 91.86 | 17797.0 |
| 2012-06-13 | DC | Futures | 27.17 | 27.18 | 26.69 | 26.88 | 150.0 |
| 2012-06-13 | DX | Futures | 80.454 | 80.605 | 79.94 | 80.083 | 25040.0 |
| 2012-06-13 | E1 | Futures | 1.3481 | 1.3592 | 1.34448 | 1.35662 | 25500.0 |
| 2012-06-13 | E6 | Futures | 1.47675 | 1.48878 | 1.47262 | 1.48618 | 166434.0 |
| 2012-06-13 | E7 | Futures | 1.4671 | 1.4795 | 1.4637 | 1.4769 | 1916.0 |
| 2012-06-13 | ED | Futures | 95.0557 | 95.0701 | 95.0557 | 95.0605 | 158290.0 |
| 2012-06-13 | ER | Futures | 97.504 | 97.528 | 97.479 | 97.484 | 160396.0 |
| 2012-06-13 | EW | Futures | 927.8 | 930.0 | 909.6 | 913.2 | 40689.0 |
| 2012-06-13 | FBTP | Futures | 64.09 | 64.49 | 63.61 | 63.84 | 16158.0 |
| 2012-06-13 | FBTS | Futures | 83.31 | 83.64 | 83.02 | 83.169 | 2575.0 |
| 2012-06-13 | FCE | Futures | 2258.0 | 2267.6 | 2221.7 | 2236.5 | 204720.0 |
| 2012-06-13 | FDAX | Futures | 6831.6 | 6878.6 | 6734.4 | 6779.1 | 243056.0 |
| 2012-06-13 | FESX | Futures | 1443.2 | 1456.1 | 1431.1 | 1437.2 | 1446916.0 |
| 2012-06-13 | FEU3 | Futures | 98.098 | 98.103 | 98.063 | 98.063 | 260.0 |
| 2012-06-13 | FGBL | Futures | 117.43 | 117.57 | 116.83 | 117.05 | 1121295.0 |
| 2012-06-13 | FGBM | Futures | 115.21 | 115.26 | 114.85 | 115.0 | 567876.0 |
| 2012-06-13 | FGBS | Futures | 110.188 | 110.203 | 110.103 | 110.113 | 479514.0 |
| 2012-06-13 | FGBX | Futures | 126.56 | 126.56 | 124.14 | 124.91 | 17086.0 |
| 2012-06-13 | FOAT | Futures | 97.55 | 97.83 | 97.28 | 97.64 | 18542.0 |
| 2012-06-13 | FTDX | Futures | 686.8 | 688.6 | 680.3 | 682.6 | 794.0 |
| 2012-06-13 | FTI | Futures | 249.36 | 249.7 | 246.17 | 247.95 | 26831.0 |
| 2012-06-13 | FTUK | Futures | 3960.5 | 3979.1 | 3925.6 | 3956.5 | 150014.0 |
| 2012-06-13 | FVSA | Futures | 9948.6 | 10280.22 | 9918.45 | 10144.55 | 3838.0 |
| 2012-06-13 | FXXP | Futures | 174.1 | 174.1 | 171.9 | 172.5 | 22156.0 |
| 2012-06-13 | G | Futures | 98.3 | 98.55 | 97.95 | 98.17 | 158239.0 |
| 2012-06-13 | GF | Futures | 318.242 | 318.637 | 312.519 | 312.519 | 3703.0 |
| 2012-06-13 | GSCI | Futures | 918.97 | 923.89 | 911.29 | 914.22 | 1657.0 |
| 2012-06-13 | HE | Futures | 97.609 | 99.372 | 97.082 | 98.898 | 23742.0 |
| 2012-06-13 | HG | Futures | 4.3813 | 4.4127 | 4.3322 | 4.3734 | 63721.0 |
| 2012-06-13 | HO | Futures | 2.1514 | 2.1748 | 2.1389 | 2.144 | 23365.0 |
| 2012-06-13 | HRC | Futures | 2470.4 | 2470.4 | 2470.4 | 2470.4 | 111.0 |
| 2012-06-13 | J1 | Futures | 0.0157626 | 0.0158241 | 0.0157338 | 0.0158165 | 50606.0 |
> showing 50 of 99 rows — these rows as CSV