PREVIEW / futures_daily / 2013-03-07
file: by_date/futures_daily/2013/2013-03-07.parquet size: 9 KB rows: 103
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 |
|---|---|---|---|---|---|---|---|
| 2013-03-07 | ES | Futures | 1575.47 | 1581.35 | 1573.16 | 1578.53 | 1673556.0 |
| 2013-03-07 | NQ | Futures | 3218.67 | 3234.82 | 3216.36 | 3228.76 | 194930.0 |
| 2013-03-07 | YM | Futures | 13999.0 | 14061.7 | 13983.3 | 14038.2 | 104517.0 |
| 2013-03-07 | CL | Futures | 158.36 | 160.66 | 158.01 | 160.36 | 234921.0 |
| 2013-03-07 | GC | Futures | 2105.1 | 2106.6 | 2092.1 | 2093.6 | 141571.0 |
| 2013-03-07 | ZN | Futures | 116.803942 | 116.872853 | 116.34913 | 116.376694 | 87376.0 |
| 2013-03-07 | A6 | Futures | 0.93532 | 0.94099 | 0.9345 | 0.9398 | 82319.0 |
| 2013-03-07 | AD | Futures | 0.97111 | 0.97462 | 0.97041 | 0.97432 | 63500.0 |
| 2013-03-07 | B | Futures | 104.95 | 105.35 | 104.45 | 105.17 | 177974.0 |
| 2013-03-07 | B6 | Futures | 1.5663 | 1.5761 | 1.564 | 1.5692 | 157489.0 |
| 2013-03-07 | BR | Futures | 0.24992 | 0.25032 | 0.24975 | 0.24975 | 40.0 |
| 2013-03-07 | BZ | Futures | 107.38 | 107.84 | 106.98 | 107.7 | 5779.0 |
| 2013-03-07 | C | Futures | 1463.0 | 1487.0 | 1463.0 | 1486.0 | 13242.0 |
| 2013-03-07 | CB | Futures | 83.275 | 83.546 | 83.275 | 83.324 | 9.0 |
| 2013-03-07 | CC | Futures | 1545.0 | 1568.0 | 1539.0 | 1560.0 | 9288.0 |
| 2013-03-07 | CSC | Futures | 3.663 | 3.663 | 3.643 | 3.645 | 13.0 |
| 2013-03-07 | CT | Futures | 107.32 | 107.34 | 106.06 | 106.41 | 10641.0 |
| 2013-03-07 | DC | Futures | 27.83 | 27.92 | 27.55 | 27.58 | 147.0 |
| 2013-03-07 | DX | Futures | 79.677 | 79.682 | 79.079 | 79.202 | 35170.0 |
| 2013-03-07 | E1 | Futures | 1.35742 | 1.3681 | 1.35664 | 1.36566 | 50380.0 |
| 2013-03-07 | E6 | Futures | 1.53028 | 1.54726 | 1.53016 | 1.54596 | 387020.0 |
| 2013-03-07 | E7 | Futures | 1.5201 | 1.5368 | 1.5199 | 1.5354 | 6900.0 |
| 2013-03-07 | EBM | Futures | 271.56 | 271.86 | 268.36 | 269.23 | 18781.0 |
| 2013-03-07 | ED | Futures | 95.2509 | 95.2533 | 95.2486 | 95.2486 | 104138.0 |
| 2013-03-07 | ER | Futures | 97.822 | 97.827 | 97.798 | 97.803 | 120832.0 |
| 2013-03-07 | EW | Futures | 1137.7 | 1145.1 | 1136.4 | 1144.3 | 34097.0 |
| 2013-03-07 | FBTP | Futures | 74.71 | 75.3 | 74.71 | 75.15 | 29798.0 |
| 2013-03-07 | FBTS | Futures | 91.166 | 91.38 | 91.166 | 91.303 | 7305.0 |
| 2013-03-07 | FCE | Futures | 2839.9 | 2858.3 | 2835.0 | 2848.9 | 138924.0 |
| 2013-03-07 | FDAX | Futures | 8668.0 | 8691.5 | 8638.5 | 8663.1 | 137406.0 |
| 2013-03-07 | FESX | Futures | 1828.8 | 1841.8 | 1826.8 | 1830.9 | 1096085.0 |
| 2013-03-07 | FEU3 | Futures | 98.433 | 98.433 | 98.409 | 98.409 | 50.0 |
| 2013-03-07 | FGBL | Futures | 120.09 | 120.23 | 119.55 | 119.71 | 938042.0 |
| 2013-03-07 | FGBM | Futures | 117.51 | 117.56 | 117.09 | 117.18 | 683431.0 |
| 2013-03-07 | FGBS | Futures | 110.462 | 110.467 | 110.323 | 110.352 | 583803.0 |
| 2013-03-07 | FGBX | Futures | 125.87 | 126.34 | 125.11 | 125.54 | 14523.0 |
| 2013-03-07 | FMWO | Futures | 4577.6 | 4577.6 | 4577.6 | 4577.6 | 0.0 |
| 2013-03-07 | FOAT | Futures | 106.0 | 106.22 | 105.82 | 105.93 | 60640.0 |
| 2013-03-07 | FTDX | Futures | 873.4 | 875.3 | 865.3 | 874.3 | 92.0 |
| 2013-03-07 | FTI | Futures | 299.51 | 300.37 | 298.61 | 298.95 | 33520.0 |
| 2013-03-07 | FTUK | Futures | 4728.2 | 4744.4 | 4722.3 | 4733.3 | 161165.0 |
| 2013-03-07 | FVSA | Futures | 3538.72 | 3611.31 | 3429.84 | 3429.84 | 5655.0 |
| 2013-03-07 | FXXP | Futures | 211.9 | 212.9 | 210.9 | 211.4 | 12627.0 |
| 2013-03-07 | G | Futures | 97.99 | 98.11 | 97.3 | 97.46 | 179682.0 |
| 2013-03-07 | GF | Futures | 263.05 | 264.358 | 261.602 | 262.443 | 1913.0 |
| 2013-03-07 | GSCI | Futures | 1032.17 | 1039.89 | 1032.17 | 1038.44 | 1826.0 |
| 2013-03-07 | HE | Futures | 89.032 | 92.056 | 89.032 | 91.636 | 37452.0 |
| 2013-03-07 | HG | Futures | 4.4717 | 4.5093 | 4.4557 | 4.4914 | 40815.0 |
| 2013-03-07 | HH | Futures | 39.926 | 41.197 | 39.926 | 41.026 | 968.0 |
| 2013-03-07 | HO | Futures | 2.4351 | 2.4494 | 2.4279 | 2.4486 | 27402.0 |
> showing 50 of 103 rows — these rows as CSV