PREVIEW / futures_daily / 2014-04-03
file: by_date/futures_daily/2014/2014-04-03.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-03 | ES | Futures | 1947.96 | 1952.88 | 1940.46 | 1948.22 | 1239722.0 |
| 2014-04-03 | NQ | Futures | 4211.03 | 4223.4 | 4154.34 | 4179.37 | 272222.0 |
| 2014-04-03 | YM | Futures | 16557.6 | 16598.8 | 16518.4 | 16568.6 | 116779.0 |
| 2014-04-03 | CL | Futures | 177.19 | 179.33 | 176.8 | 178.97 | 195430.0 |
| 2014-04-03 | GC | Futures | 1700.2 | 1705.2 | 1689.0 | 1692.6 | 98672.0 |
| 2014-04-03 | ZN | Futures | 113.939622 | 114.127952 | 113.881675 | 114.012057 | 1106944.0 |
| 2014-04-03 | A6 | Futures | 0.88424 | 0.88444 | 0.88002 | 0.88213 | 61238.0 |
| 2014-04-03 | AD | Futures | 0.91735 | 0.91968 | 0.91633 | 0.91714 | 36520.0 |
| 2014-04-03 | B | Futures | 108.01 | 109.72 | 107.83 | 109.56 | 189494.0 |
| 2014-04-03 | B6 | Futures | 1.7463 | 1.7503 | 1.7405 | 1.7425 | 95016.0 |
| 2014-04-03 | BFX | Futures | 3800.5 | 3807.6 | 3796.9 | 3807.6 | 76.0 |
| 2014-04-03 | BR | Futures | 0.22759 | 0.22765 | 0.22696 | 0.22733 | 284.0 |
| 2014-04-03 | BZ | Futures | 110.09 | 111.81 | 109.9 | 111.67 | 8573.0 |
| 2014-04-03 | C | Futures | 1944.0 | 1949.0 | 1933.0 | 1939.0 | 3849.0 |
| 2014-04-03 | CB | Futures | 94.811 | 94.811 | 94.431 | 94.608 | 13.0 |
| 2014-04-03 | CC | Futures | 2170.0 | 2175.0 | 2158.0 | 2166.0 | 17480.0 |
| 2014-04-03 | CNH | Futures | 7.1333 | 7.1365 | 7.1325 | 7.1325 | 140.0 |
| 2014-04-03 | CSC | Futures | 4.567 | 4.6 | 4.564 | 4.6 | 27.0 |
| 2014-04-03 | CT | Futures | 102.85 | 103.1 | 101.84 | 102.26 | 13127.0 |
| 2014-04-03 | DC | Futures | 36.05 | 36.59 | 36.05 | 36.5 | 235.0 |
| 2014-04-03 | DX | Futures | 76.363 | 76.653 | 76.23 | 76.61 | 40190.0 |
| 2014-04-03 | E1 | Futures | 1.44829 | 1.45214 | 1.43828 | 1.44059 | 50160.0 |
| 2014-04-03 | E6 | Futures | 1.62513 | 1.63009 | 1.61687 | 1.61876 | 284230.0 |
| 2014-04-03 | E7 | Futures | 1.6141 | 1.6191 | 1.6061 | 1.608 | 5397.0 |
| 2014-04-03 | EBM | Futures | 291.35 | 292.4 | 290.64 | 291.35 | 11017.0 |
| 2014-04-03 | ED | Futures | 95.3995 | 95.4043 | 95.3995 | 95.3995 | 59763.0 |
| 2014-04-03 | ER | Futures | 97.837 | 97.847 | 97.813 | 97.822 | 175488.0 |
| 2014-04-03 | EW | Futures | 1435.9 | 1438.9 | 1424.7 | 1431.5 | 10212.0 |
| 2014-04-03 | FBTP | Futures | 87.19 | 87.7 | 86.94 | 87.51 | 78044.0 |
| 2014-04-03 | FBTS | Futures | 97.276 | 97.469 | 97.223 | 97.408 | 16739.0 |
| 2014-04-03 | FCE | Futures | 3444.6 | 3475.7 | 3432.6 | 3459.0 | 111346.0 |
| 2014-04-03 | FDAX | Futures | 10663.8 | 10725.1 | 10613.0 | 10651.1 | 93559.0 |
| 2014-04-03 | FESX | Futures | 2244.9 | 2267.1 | 2238.4 | 2256.4 | 895915.0 |
| 2014-04-03 | FGBL | Futures | 123.26 | 123.39 | 122.96 | 123.33 | 821091.0 |
| 2014-04-03 | FGBM | Futures | 119.41 | 119.49 | 119.22 | 119.46 | 571329.0 |
| 2014-04-03 | FGBS | Futures | 110.478 | 110.478 | 110.408 | 110.463 | 461944.0 |
| 2014-04-03 | FGBX | Futures | 125.97 | 125.97 | 125.44 | 125.73 | 20168.0 |
| 2014-04-03 | FMWO | Futures | 5570.8 | 5570.8 | 5570.8 | 5570.8 | 0.0 |
| 2014-04-03 | FOAT | Futures | 112.24 | 112.55 | 111.99 | 112.45 | 108163.0 |
| 2014-04-03 | FTDX | Futures | 1195.3 | 1198.1 | 1191.6 | 1194.4 | 215.0 |
| 2014-04-03 | FTI | Futures | 346.71 | 347.35 | 345.22 | 346.16 | 24695.0 |
| 2014-04-03 | FTUK | Futures | 5044.8 | 5053.9 | 5019.2 | 5022.3 | 78789.0 |
| 2014-04-03 | FVSA | Futures | 1745.37 | 1755.4 | 1700.23 | 1735.34 | 10929.0 |
| 2014-04-03 | FXXP | Futures | 249.3 | 250.4 | 248.5 | 249.4 | 10243.0 |
| 2014-04-03 | G | Futures | 92.98 | 93.35 | 92.98 | 93.22 | 113134.0 |
| 2014-04-03 | GF | Futures | 284.158 | 286.8 | 283.878 | 286.279 | 1493.0 |
| 2014-04-03 | GSCI | Futures | 1053.72 | 1062.9 | 1052.73 | 1062.81 | 523.0 |
| 2014-04-03 | HE | Futures | 144.18 | 144.18 | 143.188 | 144.063 | 932.0 |
| 2014-04-03 | HG | Futures | 3.8494 | 3.8513 | 3.812 | 3.8361 | 43149.0 |
| 2014-04-03 | HH | Futures | 55.832 | 56.706 | 55.314 | 56.579 | 2103.0 |
> showing 50 of 104 rows — these rows as CSV