PREVIEW / futures_daily / 2012-11-12
file: by_date/futures_daily/2012/2012-11-12.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-11-12 | ES | Futures | 1399.71 | 1406.32 | 1396.91 | 1402.76 | 1138665.0 |
| 2012-11-12 | NQ | Futures | 2970.3 | 2988.43 | 2959.37 | 2969.73 | 193646.0 |
| 2012-11-12 | YM | Futures | 12463.9 | 12514.7 | 12432.7 | 12479.6 | 75110.0 |
| 2012-11-12 | CL | Futures | 155.34 | 155.97 | 153.68 | 154.22 | 280690.0 |
| 2012-11-12 | GC | Futures | 2312.2 | 2320.5 | 2303.4 | 2311.0 | 107182.0 |
| 2012-11-12 | ZN | Futures | 117.700265 | 117.755201 | 117.549191 | 117.686531 | 213509.0 |
| 2012-11-12 | A6 | Futures | 0.94198 | 0.94616 | 0.94116 | 0.94516 | 73744.0 |
| 2012-11-12 | AD | Futures | 1.00238 | 1.00449 | 1.00228 | 1.00328 | 39759.0 |
| 2012-11-12 | B | Futures | 100.38 | 100.99 | 99.3 | 99.87 | 172199.0 |
| 2012-11-12 | B6 | Futures | 1.6609 | 1.662 | 1.6566 | 1.6578 | 58987.0 |
| 2012-11-12 | BR | Futures | 0.2368 | 0.23682 | 0.2357 | 0.23597 | 49.0 |
| 2012-11-12 | BZ | Futures | 103.1 | 104.1 | 102.42 | 102.98 | 559.0 |
| 2012-11-12 | C | Futures | 1553.0 | 1569.0 | 1547.0 | 1566.0 | 3695.0 |
| 2012-11-12 | CB | Futures | 92.595 | 92.595 | 92.595 | 92.595 | 11.0 |
| 2012-11-12 | CC | Futures | 1780.0 | 1796.0 | 1756.0 | 1792.0 | 21902.0 |
| 2012-11-12 | CT | Futures | 90.06 | 92.51 | 89.81 | 91.46 | 27224.0 |
| 2012-11-12 | DC | Futures | 29.67 | 29.75 | 29.28 | 29.31 | 569.0 |
| 2012-11-12 | DX | Futures | 78.559 | 78.622 | 78.443 | 78.56 | 10513.0 |
| 2012-11-12 | E1 | Futures | 1.35806 | 1.36012 | 1.35613 | 1.35845 | 15342.0 |
| 2012-11-12 | E6 | Futures | 1.49777 | 1.50059 | 1.49565 | 1.49753 | 147452.0 |
| 2012-11-12 | E7 | Futures | 1.4886 | 1.4915 | 1.4868 | 1.4886 | 1942.0 |
| 2012-11-12 | ED | Futures | 95.2396 | 95.2396 | 95.2349 | 95.2396 | 16374.0 |
| 2012-11-12 | ER | Futures | 97.886 | 97.896 | 97.886 | 97.891 | 36087.0 |
| 2012-11-12 | EW | Futures | 986.2 | 990.5 | 983.6 | 986.9 | 9668.0 |
| 2012-11-12 | FBTP | Futures | 72.27 | 72.45 | 72.0 | 72.07 | 13396.0 |
| 2012-11-12 | FBTS | Futures | 89.826 | 89.86 | 89.709 | 89.717 | 1356.0 |
| 2012-11-12 | FCE | Futures | 2573.8 | 2580.2 | 2561.0 | 2567.0 | 39812.0 |
| 2012-11-12 | FDAX | Futures | 7852.4 | 7890.7 | 7819.5 | 7856.7 | 80434.0 |
| 2012-11-12 | FESX | Futures | 1687.2 | 1690.6 | 1676.3 | 1683.1 | 616979.0 |
| 2012-11-12 | FGBL | Futures | 119.68 | 119.74 | 119.54 | 119.66 | 317740.0 |
| 2012-11-12 | FGBM | Futures | 117.09 | 117.11 | 117.02 | 117.06 | 236770.0 |
| 2012-11-12 | FGBS | Futures | 110.522 | 110.537 | 110.507 | 110.527 | 144478.0 |
| 2012-11-12 | FGBX | Futures | 127.71 | 127.73 | 127.09 | 127.39 | 7815.0 |
| 2012-11-12 | FOAT | Futures | 104.64 | 104.86 | 104.58 | 104.85 | 11438.0 |
| 2012-11-12 | FTDX | Futures | 759.4 | 759.4 | 753.3 | 758.9 | 63.0 |
| 2012-11-12 | FTI | Futures | 284.32 | 285.27 | 283.81 | 284.41 | 11764.0 |
| 2012-11-12 | FTUK | Futures | 4200.3 | 4227.8 | 4199.2 | 4213.5 | 54357.0 |
| 2012-11-12 | FVSA | Futures | 5082.29 | 5093.79 | 4944.31 | 4955.81 | 3698.0 |
| 2012-11-12 | FXXP | Futures | 194.5 | 195.1 | 194.0 | 194.3 | 1433.0 |
| 2012-11-12 | G | Futures | 99.5 | 99.74 | 99.47 | 99.57 | 76123.0 |
| 2012-11-12 | GF | Futures | 276.899 | 277.753 | 276.092 | 276.946 | 1421.0 |
| 2012-11-12 | GSCI | Futures | 1026.17 | 1032.06 | 1022.78 | 1024.72 | 2145.0 |
| 2012-11-12 | HE | Futures | 100.433 | 100.527 | 99.656 | 99.843 | 19664.0 |
| 2012-11-12 | HG | Futures | 4.431 | 4.4663 | 4.4072 | 4.4567 | 49286.0 |
| 2012-11-12 | HH | Futures | 41.537 | 41.537 | 41.537 | 41.537 | 500.0 |
| 2012-11-12 | HO | Futures | 2.4386 | 2.4542 | 2.4211 | 2.4309 | 44079.0 |
| 2012-11-12 | HRC | Futures | 2458.3 | 2458.3 | 2458.3 | 2458.3 | 0.0 |
| 2012-11-12 | J1 | Futures | 0.0157629 | 0.0157829 | 0.0157416 | 0.0157641 | 44200.0 |
| 2012-11-12 | J7 | Futures | 0.015697 | 0.015717 | 0.015676 | 0.015697 | 350.0 |
| 2012-11-12 | JB | Futures | 127.31 | 127.35 | 127.22 | 127.26 | 2187.0 |
> showing 50 of 97 rows — these rows as CSV