PREVIEW / futures_daily / 2012-08-13
file: by_date/futures_daily/2012/2012-08-13.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-08-13 | ES | Futures | 1418.31 | 1421.86 | 1411.99 | 1420.34 | 1202738.0 |
| 2012-08-13 | NQ | Futures | 3121.92 | 3133.11 | 3105.56 | 3131.1 | 148106.0 |
| 2012-08-13 | YM | Futures | 12767.5 | 12789.8 | 12683.1 | 12745.2 | 89320.0 |
| 2012-08-13 | CL | Futures | 169.24 | 170.86 | 167.07 | 168.3 | 280268.0 |
| 2012-08-13 | GC | Futures | 2169.2 | 2173.9 | 2149.2 | 2153.0 | 96667.0 |
| 2012-08-13 | ZN | Futures | 116.508749 | 116.672174 | 116.358942 | 116.467893 | 529257.0 |
| 2012-08-13 | A6 | Futures | 0.94648 | 0.94774 | 0.94082 | 0.94235 | 94022.0 |
| 2012-08-13 | AD | Futures | 1.01093 | 1.01143 | 1.00782 | 1.00952 | 67680.0 |
| 2012-08-13 | B | Futures | 101.18 | 102.73 | 100.92 | 101.43 | 167084.0 |
| 2012-08-13 | B6 | Futures | 1.6383 | 1.6425 | 1.6361 | 1.6394 | 77406.0 |
| 2012-08-13 | BFX | Futures | 2802.0 | 2802.0 | 2795.8 | 2798.8 | 28.0 |
| 2012-08-13 | BR | Futures | 0.23597 | 0.23597 | 0.23451 | 0.23551 | 78.0 |
| 2012-08-13 | BZ | Futures | 107.64 | 108.02 | 106.4 | 106.9 | 4113.0 |
| 2012-08-13 | C | Futures | 1669.0 | 1702.0 | 1643.0 | 1652.0 | 3334.0 |
| 2012-08-13 | CB | Futures | 96.074 | 96.074 | 96.074 | 96.074 | 2.0 |
| 2012-08-13 | CC | Futures | 1847.0 | 1886.0 | 1793.0 | 1809.0 | 21698.0 |
| 2012-08-13 | CSC | Futures | 4.084 | 4.084 | 4.058 | 4.062 | 12.0 |
| 2012-08-13 | CT | Futures | 96.29 | 96.29 | 93.75 | 93.92 | 60.0 |
| 2012-08-13 | DC | Futures | 30.46 | 30.46 | 29.72 | 29.79 | 307.0 |
| 2012-08-13 | DX | Futures | 80.212 | 80.333 | 79.867 | 80.062 | 13095.0 |
| 2012-08-13 | E1 | Futures | 1.32189 | 1.33105 | 1.31905 | 1.32653 | 29414.0 |
| 2012-08-13 | E6 | Futures | 1.44997 | 1.46012 | 1.44679 | 1.4554 | 185556.0 |
| 2012-08-13 | E7 | Futures | 1.4411 | 1.451 | 1.438 | 1.4464 | 3004.0 |
| 2012-08-13 | ED | Futures | 95.1752 | 95.1847 | 95.1752 | 95.18 | 94941.0 |
| 2012-08-13 | ER | Futures | 97.827 | 97.832 | 97.817 | 97.822 | 52744.0 |
| 2012-08-13 | EW | Futures | 972.6 | 974.2 | 963.3 | 972.2 | 15483.0 |
| 2012-08-13 | FBTP | Futures | 65.97 | 66.29 | 65.75 | 65.98 | 6496.0 |
| 2012-08-13 | FBTS | Futures | 86.295 | 86.336 | 86.138 | 86.162 | 1567.0 |
| 2012-08-13 | FCE | Futures | 2556.4 | 2567.6 | 2535.6 | 2547.9 | 21946.0 |
| 2012-08-13 | FDAX | Futures | 7577.0 | 7619.5 | 7513.6 | 7548.6 | 106651.0 |
| 2012-08-13 | FESX | Futures | 1637.3 | 1649.5 | 1623.8 | 1633.3 | 697803.0 |
| 2012-08-13 | FGBL | Futures | 118.39 | 118.59 | 117.79 | 118.26 | 435989.0 |
| 2012-08-13 | FGBM | Futures | 116.51 | 116.58 | 116.18 | 116.36 | 245262.0 |
| 2012-08-13 | FGBS | Futures | 110.562 | 110.577 | 110.492 | 110.517 | 180992.0 |
| 2012-08-13 | FGBX | Futures | 126.55 | 126.88 | 125.36 | 126.21 | 2867.0 |
| 2012-08-13 | FOAT | Futures | 102.96 | 102.96 | 102.58 | 102.79 | 10621.0 |
| 2012-08-13 | FTDX | Futures | 725.4 | 725.9 | 719.3 | 721.2 | 132.0 |
| 2012-08-13 | FTI | Futures | 284.39 | 284.39 | 280.69 | 281.92 | 16013.0 |
| 2012-08-13 | FTUK | Futures | 4251.3 | 4251.3 | 4219.0 | 4229.9 | 63581.0 |
| 2012-08-13 | FVSA | Futures | 6609.63 | 6660.87 | 6455.92 | 6596.83 | 879.0 |
| 2012-08-13 | FXXP | Futures | 193.0 | 193.3 | 192.0 | 192.5 | 1638.0 |
| 2012-08-13 | G | Futures | 100.25 | 100.46 | 99.74 | 100.0 | 80850.0 |
| 2012-08-13 | GF | Futures | 277.236 | 281.176 | 277.187 | 281.077 | 2150.0 |
| 2012-08-13 | GSCI | Futures | 1060.95 | 1062.64 | 1050.08 | 1054.51 | 1734.0 |
| 2012-08-13 | HE | Futures | 93.708 | 95.902 | 93.677 | 95.222 | 16853.0 |
| 2012-08-13 | HG | Futures | 4.3802 | 4.3827 | 4.3054 | 4.3203 | 45848.0 |
| 2012-08-13 | HO | Futures | 2.4757 | 2.4996 | 2.4641 | 2.4678 | 53939.0 |
| 2012-08-13 | HRC | Futures | 2533.1 | 2533.1 | 2533.1 | 2533.1 | 0.0 |
| 2012-08-13 | J1 | Futures | 0.0160083 | 0.0160383 | 0.0159932 | 0.015997 | 50812.0 |
| 2012-08-13 | J7 | Futures | 0.015945 | 0.015974 | 0.015933 | 0.015934 | 206.0 |
> showing 50 of 97 rows — these rows as CSV