PREVIEW / futures_daily / 2012-10-09
file: by_date/futures_daily/2012/2012-10-09.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-10-09 | ES | Futures | 1475.53 | 1480.37 | 1460.77 | 1461.54 | 1956139.0 |
| 2012-10-09 | NQ | Futures | 3197.26 | 3206.47 | 3141.17 | 3145.77 | 333498.0 |
| 2012-10-09 | YM | Futures | 13184.6 | 13226.6 | 13087.9 | 13096.7 | 137525.0 |
| 2012-10-09 | CL | Futures | 161.75 | 167.69 | 161.15 | 166.75 | 378040.0 |
| 2012-10-09 | GC | Futures | 2373.6 | 2378.7 | 2352.5 | 2356.5 | 140493.0 |
| 2012-10-09 | ZN | Futures | 117.09597 | 117.205842 | 116.848758 | 116.944896 | 738769.0 |
| 2012-10-09 | A6 | Futures | 0.9209 | 0.9259 | 0.91944 | 0.92272 | 129237.0 |
| 2012-10-09 | AD | Futures | 1.02567 | 1.02838 | 1.02175 | 1.02526 | 74729.0 |
| 2012-10-09 | B | Futures | 102.13 | 104.14 | 101.77 | 103.93 | 218001.0 |
| 2012-10-09 | B6 | Futures | 1.673 | 1.6753 | 1.6681 | 1.6713 | 122563.0 |
| 2012-10-09 | BFX | Futures | 2890.9 | 2890.9 | 2850.5 | 2859.2 | 37.0 |
| 2012-10-09 | BR | Futures | 0.23777 | 0.23777 | 0.23663 | 0.23702 | 67.0 |
| 2012-10-09 | BZ | Futures | 105.96 | 107.99 | 105.96 | 107.85 | 676.0 |
| 2012-10-09 | C | Futures | 1567.0 | 1600.0 | 1559.0 | 1583.0 | 6780.0 |
| 2012-10-09 | CC | Futures | 1805.0 | 1850.0 | 1801.0 | 1823.0 | 10819.0 |
| 2012-10-09 | CSC | Futures | 4.225 | 4.229 | 4.215 | 4.215 | 12.0 |
| 2012-10-09 | CT | Futures | 92.39 | 93.59 | 92.15 | 92.7 | 11548.0 |
| 2012-10-09 | DC | Futures | 31.47 | 31.66 | 31.37 | 31.44 | 123.0 |
| 2012-10-09 | DX | Futures | 77.15 | 77.678 | 77.072 | 77.556 | 24274.0 |
| 2012-10-09 | E1 | Futures | 1.38097 | 1.38213 | 1.36823 | 1.37029 | 37962.0 |
| 2012-10-09 | E6 | Futures | 1.52826 | 1.53086 | 1.51484 | 1.51814 | 308267.0 |
| 2012-10-09 | E7 | Futures | 1.5188 | 1.5216 | 1.5057 | 1.5091 | 5339.0 |
| 2012-10-09 | ED | Futures | 95.211 | 95.2301 | 95.211 | 95.2205 | 94486.0 |
| 2012-10-09 | ER | Futures | 97.866 | 97.881 | 97.866 | 97.876 | 72320.0 |
| 2012-10-09 | EW | Futures | 1009.3 | 1013.0 | 998.0 | 1000.1 | 25069.0 |
| 2012-10-09 | FBTP | Futures | 71.42 | 71.5 | 71.22 | 71.29 | 13980.0 |
| 2012-10-09 | FBTS | Futures | 89.307 | 89.474 | 89.307 | 89.324 | 1845.0 |
| 2012-10-09 | FCE | Futures | 2563.2 | 2564.0 | 2521.7 | 2529.2 | 94932.0 |
| 2012-10-09 | FDAX | Futures | 8028.2 | 8029.3 | 7911.0 | 7918.6 | 124341.0 |
| 2012-10-09 | FESX | Futures | 1703.5 | 1704.2 | 1670.9 | 1675.6 | 1046261.0 |
| 2012-10-09 | FGBL | Futures | 118.08 | 118.32 | 117.88 | 118.16 | 655914.0 |
| 2012-10-09 | FGBM | Futures | 116.13 | 116.27 | 116.06 | 116.17 | 366251.0 |
| 2012-10-09 | FGBS | Futures | 110.333 | 110.358 | 110.313 | 110.338 | 209661.0 |
| 2012-10-09 | FGBX | Futures | 124.56 | 125.09 | 124.22 | 124.89 | 3290.0 |
| 2012-10-09 | FOAT | Futures | 103.08 | 103.58 | 103.08 | 103.49 | 26420.0 |
| 2012-10-09 | FTDX | Futures | 771.2 | 773.1 | 767.4 | 770.2 | 101.0 |
| 2012-10-09 | FTI | Futures | 282.04 | 282.33 | 278.96 | 279.48 | 26301.0 |
| 2012-10-09 | FTUK | Futures | 4262.5 | 4269.5 | 4218.6 | 4226.3 | 82644.0 |
| 2012-10-09 | FVSA | Futures | 5376.86 | 5657.92 | 5340.2 | 5621.26 | 3049.0 |
| 2012-10-09 | FXXP | Futures | 195.6 | 195.8 | 194.2 | 194.2 | 1641.0 |
| 2012-10-09 | G | Futures | 99.32 | 99.5 | 99.13 | 99.41 | 149612.0 |
| 2012-10-09 | GF | Futures | 281.943 | 282.527 | 281.018 | 281.699 | 1410.0 |
| 2012-10-09 | GSCI | Futures | 1068.08 | 1080.17 | 1068.0 | 1076.95 | 2065.0 |
| 2012-10-09 | HE | Futures | 95.741 | 96.3 | 94.933 | 95.461 | 20757.0 |
| 2012-10-09 | HG | Futures | 4.7876 | 4.8229 | 4.7638 | 4.778 | 47280.0 |
| 2012-10-09 | HH | Futures | 44.208 | 44.208 | 44.208 | 44.208 | 2127.0 |
| 2012-10-09 | HO | Futures | 2.5429 | 2.5882 | 2.5374 | 2.578 | 39879.0 |
| 2012-10-09 | HRC | Futures | 2430.8 | 2430.8 | 2430.8 | 2430.8 | 25.0 |
| 2012-10-09 | J1 | Futures | 0.0159933 | 0.0160308 | 0.015972 | 0.016017 | 63658.0 |
| 2012-10-09 | J7 | Futures | 0.015932 | 0.015962 | 0.015904 | 0.015949 | 290.0 |
> showing 50 of 97 rows — these rows as CSV