PREVIEW / futures_daily / 2012-04-16
file: by_date/futures_daily/2012/2012-04-16.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-04-16 | ES | Futures | 1376.54 | 1385.86 | 1371.0 | 1374.52 | 1959799.0 |
| 2012-04-16 | NQ | Futures | 3087.43 | 3104.9 | 3043.61 | 3051.91 | 396998.0 |
| 2012-04-16 | YM | Futures | 12438.1 | 12569.4 | 12397.3 | 12496.5 | 150551.0 |
| 2012-04-16 | CL | Futures | 189.36 | 190.48 | 187.62 | 189.62 | 137539.0 |
| 2012-04-16 | GC | Futures | 2217.3 | 2218.5 | 2195.0 | 2205.3 | 114468.0 |
| 2012-04-16 | ZN | Futures | 114.003334 | 114.287631 | 113.908568 | 114.0981 | 1023518.0 |
| 2012-04-16 | A6 | Futures | 0.92618 | 0.92744 | 0.92114 | 0.92564 | 118872.0 |
| 2012-04-16 | AD | Futures | 1.00511 | 1.00742 | 1.00149 | 1.00531 | 87537.0 |
| 2012-04-16 | B | Futures | 109.43 | 109.43 | 106.9 | 107.34 | 232823.0 |
| 2012-04-16 | B6 | Futures | 1.6645 | 1.6695 | 1.6597 | 1.6686 | 108097.0 |
| 2012-04-16 | BFX | Futures | 2685.5 | 2685.5 | 2668.3 | 2670.1 | 2.0 |
| 2012-04-16 | BR | Futures | 0.25719 | 0.25807 | 0.25592 | 0.25719 | 223.0 |
| 2012-04-16 | BZ | Futures | 114.82 | 114.84 | 113.11 | 113.53 | 832.0 |
| 2012-04-16 | C | Futures | 1448.0 | 1472.0 | 1433.0 | 1466.0 | 1995.0 |
| 2012-04-16 | CB | Futures | 78.716 | 79.12 | 78.716 | 79.12 | 4.0 |
| 2012-04-16 | CC | Futures | 1645.0 | 1690.0 | 1630.0 | 1678.0 | 11617.0 |
| 2012-04-16 | CSC | Futures | 3.543 | 3.543 | 3.513 | 3.513 | 59.0 |
| 2012-04-16 | CT | Futures | 115.14 | 115.3 | 110.23 | 110.23 | 19216.0 |
| 2012-04-16 | DC | Futures | 24.78 | 24.96 | 24.38 | 24.55 | 162.0 |
| 2012-04-16 | DX | Futures | 77.593 | 77.845 | 77.191 | 77.251 | 25314.0 |
| 2012-04-16 | E1 | Futures | 1.42421 | 1.4339 | 1.41622 | 1.43233 | 55565.0 |
| 2012-04-16 | E6 | Futures | 1.56083 | 1.57026 | 1.55188 | 1.56847 | 303925.0 |
| 2012-04-16 | E7 | Futures | 1.5456 | 1.5551 | 1.537 | 1.5534 | 4453.0 |
| 2012-04-16 | EBM | Futures | 280.31 | 282.66 | 280.31 | 281.99 | 8776.0 |
| 2012-04-16 | ED | Futures | 95.0597 | 95.0645 | 95.0454 | 95.0645 | 126021.0 |
| 2012-04-16 | ER | Futures | 97.503 | 97.503 | 97.474 | 97.489 | 76978.0 |
| 2012-04-16 | EW | Futures | 970.5 | 981.3 | 967.0 | 973.8 | 22108.0 |
| 2012-04-16 | FBTP | Futures | 66.23 | 66.26 | 65.39 | 65.82 | 11032.0 |
| 2012-04-16 | FBTS | Futures | 84.631 | 84.956 | 84.338 | 84.655 | 2639.0 |
| 2012-04-16 | FCE | Futures | 2266.2 | 2300.2 | 2251.8 | 2270.6 | 61058.0 |
| 2012-04-16 | FDAX | Futures | 7268.8 | 7388.2 | 7225.2 | 7354.5 | 154839.0 |
| 2012-04-16 | FESX | Futures | 1536.4 | 1564.7 | 1525.3 | 1549.5 | 1315403.0 |
| 2012-04-16 | FGBL | Futures | 115.12 | 115.25 | 114.87 | 115.12 | 621473.0 |
| 2012-04-16 | FGBM | Futures | 114.56 | 114.62 | 114.39 | 114.51 | 330541.0 |
| 2012-04-16 | FGBS | Futures | 110.108 | 110.138 | 110.054 | 110.074 | 284555.0 |
| 2012-04-16 | FGBX | Futures | 120.0 | 120.17 | 119.39 | 119.96 | 5401.0 |
| 2012-04-16 | FOAT | Futures | 95.04 | 95.04 | 94.4 | 94.5 | 2581.0 |
| 2012-04-16 | FTDX | Futures | 722.8 | 727.4 | 719.5 | 727.4 | 210.0 |
| 2012-04-16 | FTI | Futures | 259.6 | 263.68 | 258.82 | 260.82 | 3191.0 |
| 2012-04-16 | FTUK | Futures | 4078.7 | 4129.0 | 4067.7 | 4110.8 | 103172.0 |
| 2012-04-16 | FVSA | Futures | 9639.65 | 9887.67 | 9540.44 | 9838.07 | 8590.0 |
| 2012-04-16 | FXXP | Futures | 180.1 | 182.7 | 180.0 | 181.6 | 3316.0 |
| 2012-04-16 | G | Futures | 95.46 | 95.56 | 95.12 | 95.34 | 79103.0 |
| 2012-04-16 | GF | Futures | 316.197 | 317.759 | 315.155 | 316.457 | 3019.0 |
| 2012-04-16 | GSCI | Futures | 1080.13 | 1081.41 | 1069.89 | 1072.83 | 569.0 |
| 2012-04-16 | HE | Futures | 99.047 | 99.047 | 96.653 | 97.451 | 439.0 |
| 2012-04-16 | HG | Futures | 4.7551 | 4.7715 | 4.6791 | 4.7565 | 64103.0 |
| 2012-04-16 | HO | Futures | 2.6126 | 2.6126 | 2.5634 | 2.5665 | 40538.0 |
| 2012-04-16 | HRC | Futures | 2680.3 | 2680.3 | 2680.3 | 2680.3 | 0.0 |
| 2012-04-16 | J1 | Futures | 0.0154981 | 0.015626 | 0.0154893 | 0.0155858 | 90131.0 |
> showing 50 of 99 rows — these rows as CSV