PREVIEW / futures_daily / 2014-04-01
file: by_date/futures_daily/2014/2014-04-01.parquet size: 9 KB rows: 104
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 |
|---|---|---|---|---|---|---|---|
| 2014-04-01 | ES | Futures | 1929.08 | 1943.83 | 1926.75 | 1942.79 | 1213329.0 |
| 2014-04-01 | NQ | Futures | 4124.7 | 4204.7 | 4119.23 | 4201.82 | 265363.0 |
| 2014-04-01 | YM | Futures | 16444.1 | 16555.6 | 16426.1 | 16516.4 | 108897.0 |
| 2014-04-01 | CL | Futures | 181.19 | 181.26 | 177.17 | 177.99 | 237564.0 |
| 2014-04-01 | GC | Futures | 1692.6 | 1697.6 | 1683.1 | 1686.5 | 112918.0 |
| 2014-04-01 | ZN | Futures | 114.533586 | 114.548073 | 114.301795 | 114.37423 | 969829.0 |
| 2014-04-01 | A6 | Futures | 0.88578 | 0.88934 | 0.88213 | 0.88357 | 62705.0 |
| 2014-04-01 | AD | Futures | 0.91572 | 0.91907 | 0.9143 | 0.91725 | 38903.0 |
| 2014-04-01 | B | Futures | 110.92 | 111.23 | 108.47 | 109.02 | 143212.0 |
| 2014-04-01 | B6 | Futures | 1.7503 | 1.7516 | 1.7457 | 1.7468 | 60689.0 |
| 2014-04-01 | BFX | Futures | 3802.9 | 3813.8 | 3802.9 | 3810.8 | 14.0 |
| 2014-04-01 | BR | Futures | 0.22825 | 0.22978 | 0.22825 | 0.22904 | 150.0 |
| 2014-04-01 | BZ | Futures | 113.14 | 113.34 | 110.57 | 111.11 | 8972.0 |
| 2014-04-01 | C | Futures | 1959.0 | 1963.0 | 1943.0 | 1946.0 | 8714.0 |
| 2014-04-01 | CB | Futures | 94.558 | 95.065 | 94.532 | 95.065 | 35.0 |
| 2014-04-01 | CC | Futures | 2186.0 | 2201.0 | 2171.0 | 2185.0 | 21484.0 |
| 2014-04-01 | CNH | Futures | 7.1179 | 7.1233 | 7.1179 | 7.1233 | 1.0 |
| 2014-04-01 | CSC | Futures | 4.439 | 4.529 | 4.437 | 4.511 | 40.0 |
| 2014-04-01 | CT | Futures | 104.56 | 104.79 | 103.2 | 103.48 | 15478.0 |
| 2014-04-01 | DC | Futures | 35.34 | 36.05 | 35.08 | 35.86 | 237.0 |
| 2014-04-01 | DX | Futures | 76.244 | 76.273 | 76.121 | 76.239 | 10636.0 |
| 2014-04-01 | E1 | Futures | 1.45214 | 1.45676 | 1.45098 | 1.45342 | 20507.0 |
| 2014-04-01 | E6 | Futures | 1.62596 | 1.6308 | 1.62537 | 1.62797 | 115256.0 |
| 2014-04-01 | E7 | Futures | 1.615 | 1.6198 | 1.6145 | 1.6171 | 2373.0 |
| 2014-04-01 | EBM | Futures | 292.4 | 296.28 | 291.35 | 293.11 | 13632.0 |
| 2014-04-01 | ED | Futures | 95.4043 | 95.4043 | 95.3995 | 95.3995 | 63463.0 |
| 2014-04-01 | ER | Futures | 97.842 | 97.852 | 97.827 | 97.832 | 72723.0 |
| 2014-04-01 | EW | Futures | 1417.2 | 1432.9 | 1416.0 | 1432.4 | 17152.0 |
| 2014-04-01 | FBTP | Futures | 87.22 | 87.41 | 87.22 | 87.32 | 31241.0 |
| 2014-04-01 | FBTS | Futures | 97.284 | 97.32 | 97.258 | 97.302 | 9567.0 |
| 2014-04-01 | FCE | Futures | 3422.8 | 3452.0 | 3420.9 | 3439.9 | 81851.0 |
| 2014-04-01 | FDAX | Futures | 10610.8 | 10659.4 | 10594.8 | 10612.4 | 70772.0 |
| 2014-04-01 | FESX | Futures | 2229.1 | 2248.5 | 2228.4 | 2239.1 | 691180.0 |
| 2014-04-01 | FGBL | Futures | 123.75 | 123.76 | 123.5 | 123.58 | 516152.0 |
| 2014-04-01 | FGBM | Futures | 119.67 | 119.67 | 119.48 | 119.53 | 385716.0 |
| 2014-04-01 | FGBS | Futures | 110.533 | 110.533 | 110.473 | 110.483 | 231976.0 |
| 2014-04-01 | FGBX | Futures | 126.8 | 126.95 | 126.46 | 126.58 | 17703.0 |
| 2014-04-01 | FMWO | Futures | 5562.0 | 5562.0 | 5555.7 | 5558.2 | 119.0 |
| 2014-04-01 | FOAT | Futures | 112.55 | 112.77 | 112.46 | 112.52 | 55078.0 |
| 2014-04-01 | FTDX | Futures | 1170.0 | 1190.6 | 1170.0 | 1187.3 | 208.0 |
| 2014-04-01 | FTI | Futures | 345.43 | 346.97 | 344.24 | 346.16 | 19654.0 |
| 2014-04-01 | FTUK | Futures | 4997.1 | 5034.8 | 4991.4 | 5022.6 | 76866.0 |
| 2014-04-01 | FVSA | Futures | 1770.45 | 1780.48 | 1745.37 | 1760.42 | 7114.0 |
| 2014-04-01 | FXXP | Futures | 247.9 | 249.1 | 247.6 | 248.5 | 5739.0 |
| 2014-04-01 | G | Futures | 93.27 | 93.47 | 93.16 | 93.31 | 124398.0 |
| 2014-04-01 | GF | Futures | 284.318 | 284.759 | 281.557 | 282.477 | 1104.0 |
| 2014-04-01 | GSCI | Futures | 1071.91 | 1071.91 | 1055.62 | 1058.68 | 334.0 |
| 2014-04-01 | HE | Futures | 144.821 | 147.242 | 144.821 | 146.396 | 451.0 |
| 2014-04-01 | HG | Futures | 3.838 | 3.8564 | 3.8234 | 3.8456 | 31419.0 |
| 2014-04-01 | HH | Futures | 54.579 | 54.795 | 53.82 | 54.124 | 5386.0 |
> showing 50 of 104 rows — these rows as CSV