PREVIEW / futures_daily / 2013-03-06
file: by_date/futures_daily/2013/2013-03-06.parquet size: 9 KB rows: 101
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-06 | ES | Futures | 1574.7 | 1580.58 | 1572.65 | 1574.7 | 2091010.0 |
| 2013-03-06 | NQ | Futures | 3230.49 | 3240.3 | 3216.08 | 3216.08 | 224481.0 |
| 2013-03-06 | YM | Futures | 13970.5 | 14031.3 | 13957.8 | 13988.2 | 130149.0 |
| 2013-03-06 | CL | Futures | 159.08 | 159.68 | 156.84 | 158.38 | 244168.0 |
| 2013-03-06 | GC | Futures | 2093.3 | 2105.8 | 2082.0 | 2093.3 | 169868.0 |
| 2013-03-06 | ZN | Futures | 117.024457 | 117.038239 | 116.707467 | 116.776377 | 60634.0 |
| 2013-03-06 | A6 | Futures | 0.93742 | 0.94191 | 0.9355 | 0.93651 | 96881.0 |
| 2013-03-06 | AD | Futures | 0.97562 | 0.97753 | 0.9697 | 0.97201 | 100814.0 |
| 2013-03-06 | B | Futures | 105.71 | 106.06 | 104.45 | 104.94 | 147612.0 |
| 2013-03-06 | B6 | Futures | 1.5805 | 1.5836 | 1.5689 | 1.5717 | 109670.0 |
| 2013-03-06 | BFX | Futures | 3114.5 | 3114.5 | 3105.8 | 3105.8 | 30.0 |
| 2013-03-06 | BR | Futures | 0.24948 | 0.24965 | 0.24856 | 0.24911 | 85.0 |
| 2013-03-06 | BZ | Futures | 108.51 | 108.6 | 106.96 | 107.46 | 7702.0 |
| 2013-03-06 | C | Futures | 1463.0 | 1472.0 | 1454.0 | 1465.0 | 10915.0 |
| 2013-03-06 | CC | Futures | 1554.0 | 1558.0 | 1542.0 | 1545.0 | 9801.0 |
| 2013-03-06 | CSC | Futures | 3.641 | 3.669 | 3.641 | 3.663 | 4.0 |
| 2013-03-06 | CT | Futures | 107.03 | 107.76 | 106.55 | 107.32 | 12194.0 |
| 2013-03-06 | DC | Futures | 27.65 | 27.86 | 27.49 | 27.78 | 163.0 |
| 2013-03-06 | DX | Futures | 79.103 | 79.701 | 79.06 | 79.573 | 26043.0 |
| 2013-03-06 | E1 | Futures | 1.36784 | 1.36913 | 1.35639 | 1.35858 | 28203.0 |
| 2013-03-06 | E6 | Futures | 1.53853 | 1.54172 | 1.5291 | 1.53276 | 220283.0 |
| 2013-03-06 | E7 | Futures | 1.5284 | 1.5312 | 1.5185 | 1.5223 | 3912.0 |
| 2013-03-06 | EBM | Futures | 274.48 | 274.48 | 270.4 | 270.98 | 16855.0 |
| 2013-03-06 | ED | Futures | 95.2486 | 95.2509 | 95.2462 | 95.2486 | 52782.0 |
| 2013-03-06 | ER | Futures | 97.817 | 97.827 | 97.813 | 97.827 | 58476.0 |
| 2013-03-06 | EW | Futures | 1137.0 | 1143.3 | 1136.1 | 1137.6 | 26522.0 |
| 2013-03-06 | FBTP | Futures | 74.32 | 75.23 | 74.32 | 74.82 | 60183.0 |
| 2013-03-06 | FBTS | Futures | 90.96 | 91.294 | 90.96 | 91.174 | 10008.0 |
| 2013-03-06 | FCE | Futures | 2836.5 | 2862.1 | 2829.4 | 2833.2 | 102030.0 |
| 2013-03-06 | FDAX | Futures | 8577.9 | 8712.8 | 8574.6 | 8649.5 | 149441.0 |
| 2013-03-06 | FESX | Futures | 1822.0 | 1843.1 | 1821.3 | 1825.4 | 1244339.0 |
| 2013-03-06 | FGBL | Futures | 120.1 | 120.16 | 119.86 | 120.06 | 973874.0 |
| 2013-03-06 | FGBM | Futures | 117.43 | 117.52 | 117.36 | 117.48 | 763180.0 |
| 2013-03-06 | FGBS | Futures | 110.412 | 110.467 | 110.402 | 110.457 | 591977.0 |
| 2013-03-06 | FGBX | Futures | 126.32 | 126.32 | 125.56 | 125.98 | 19744.0 |
| 2013-03-06 | FOAT | Futures | 105.91 | 106.0 | 105.76 | 105.96 | 58781.0 |
| 2013-03-06 | FTDX | Futures | 875.3 | 880.0 | 871.5 | 871.5 | 323.0 |
| 2013-03-06 | FTI | Futures | 297.19 | 300.07 | 296.93 | 298.65 | 28284.0 |
| 2013-03-06 | FTUK | Futures | 4716.8 | 4746.2 | 4712.4 | 4713.5 | 112585.0 |
| 2013-03-06 | FVSA | Futures | 3556.87 | 3602.24 | 3466.13 | 3584.09 | 5905.0 |
| 2013-03-06 | FXXP | Futures | 212.2 | 212.8 | 211.2 | 211.4 | 3761.0 |
| 2013-03-06 | G | Futures | 97.97 | 98.06 | 97.75 | 97.99 | 124857.0 |
| 2013-03-06 | GF | Futures | 264.825 | 264.918 | 260.621 | 263.284 | 2855.0 |
| 2013-03-06 | GSCI | Futures | 1038.2 | 1038.68 | 1029.19 | 1032.81 | 492.0 |
| 2013-03-06 | HE | Futures | 88.276 | 89.424 | 87.687 | 88.78 | 24862.0 |
| 2013-03-06 | HG | Futures | 4.4927 | 4.5182 | 4.4487 | 4.4563 | 48070.0 |
| 2013-03-06 | HH | Futures | 40.59 | 40.59 | 39.651 | 39.743 | 588.0 |
| 2013-03-06 | HO | Futures | 2.4516 | 2.4516 | 2.425 | 2.4387 | 27323.0 |
| 2013-03-06 | HRC | Futures | 2225.0 | 2225.0 | 2225.0 | 2225.0 | 0.0 |
| 2013-03-06 | J1 | Futures | 0.0134227 | 0.0134765 | 0.0133136 | 0.0133224 | 136809.0 |
> showing 50 of 101 rows — these rows as CSV