PREVIEW / futures_daily / 2013-10-21
file: by_date/futures_daily/2013/2013-10-21.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-10-21 | ES | Futures | 1785.32 | 1789.94 | 1781.98 | 1785.57 | 1138916.0 |
| 2013-10-21 | NQ | Futures | 3841.54 | 3861.63 | 3838.95 | 3852.16 | 175096.0 |
| 2013-10-21 | YM | Futures | 15250.3 | 15290.1 | 15220.4 | 15245.3 | 86511.0 |
| 2013-10-21 | CL | Futures | 179.78 | 180.12 | 176.88 | 177.36 | 301917.0 |
| 2013-10-21 | GC | Futures | 1740.5 | 1750.9 | 1735.2 | 1740.2 | 74390.0 |
| 2013-10-21 | ZN | Futures | 115.008507 | 115.079316 | 114.781917 | 114.88105 | 597937.0 |
| 2013-10-21 | A6 | Futures | 0.90974 | 0.91087 | 0.90738 | 0.9088 | 56263.0 |
| 2013-10-21 | AD | Futures | 0.98046 | 0.98066 | 0.97915 | 0.97986 | 22942.0 |
| 2013-10-21 | B | Futures | 109.6 | 109.83 | 108.85 | 109.28 | 190114.0 |
| 2013-10-21 | B6 | Futures | 1.6966 | 1.6978 | 1.6926 | 1.694 | 53523.0 |
| 2013-10-21 | BFX | Futures | 3460.6 | 3462.8 | 3460.4 | 3462.8 | 7.0 |
| 2013-10-21 | BR | Futures | 0.23189 | 0.23232 | 0.2311 | 0.23194 | 109.0 |
| 2013-10-21 | BZ | Futures | 110.32 | 110.47 | 109.52 | 109.94 | 5329.0 |
| 2013-10-21 | C | Futures | 1852.0 | 1859.0 | 1836.0 | 1854.0 | 5151.0 |
| 2013-10-21 | CB | Futures | 70.018 | 70.018 | 69.059 | 69.311 | 9.0 |
| 2013-10-21 | CC | Futures | 2023.0 | 2038.0 | 2006.0 | 2035.0 | 9310.0 |
| 2013-10-21 | CSC | Futures | 3.367 | 3.367 | 3.354 | 3.354 | 2.0 |
| 2013-10-21 | CT | Futures | 97.5 | 97.84 | 97.13 | 97.44 | 8715.0 |
| 2013-10-21 | DC | Futures | 25.76 | 25.82 | 25.54 | 25.56 | 221.0 |
| 2013-10-21 | DX | Futures | 75.966 | 76.105 | 75.919 | 75.986 | 11058.0 |
| 2013-10-21 | E1 | Futures | 1.42593 | 1.4276 | 1.42143 | 1.42516 | 18026.0 |
| 2013-10-21 | E6 | Futures | 1.6151 | 1.61569 | 1.61121 | 1.61439 | 100967.0 |
| 2013-10-21 | E7 | Futures | 1.6046 | 1.6053 | 1.6008 | 1.604 | 1478.0 |
| 2013-10-21 | ED | Futures | 95.3494 | 95.3638 | 95.3494 | 95.3542 | 100065.0 |
| 2013-10-21 | ER | Futures | 97.847 | 97.857 | 97.847 | 97.852 | 52356.0 |
| 2013-10-21 | EW | Futures | 1313.4 | 1316.3 | 1309.8 | 1312.1 | 13992.0 |
| 2013-10-21 | FBTP | Futures | 80.7 | 80.75 | 80.39 | 80.52 | 21580.0 |
| 2013-10-21 | FBTS | Futures | 94.63 | 94.673 | 94.56 | 94.595 | 5201.0 |
| 2013-10-21 | FCE | Futures | 3320.7 | 3328.0 | 3303.6 | 3310.6 | 76720.0 |
| 2013-10-21 | FDAX | Futures | 9845.0 | 9862.2 | 9805.1 | 9842.3 | 68402.0 |
| 2013-10-21 | FESX | Futures | 2123.8 | 2128.0 | 2111.9 | 2118.9 | 604717.0 |
| 2013-10-21 | FEU3 | Futures | 98.468 | 98.473 | 98.468 | 98.473 | 50.0 |
| 2013-10-21 | FGBL | Futures | 119.27 | 119.31 | 119.06 | 119.13 | 378302.0 |
| 2013-10-21 | FGBM | Futures | 117.65 | 117.66 | 117.54 | 117.6 | 275819.0 |
| 2013-10-21 | FGBS | Futures | 110.418 | 110.423 | 110.398 | 110.408 | 149371.0 |
| 2013-10-21 | FGBX | Futures | 119.19 | 119.61 | 119.01 | 119.42 | 15510.0 |
| 2013-10-21 | FMWO | Futures | 5256.0 | 5256.0 | 5256.0 | 5256.0 | 0.0 |
| 2013-10-21 | FOAT | Futures | 107.0 | 107.0 | 106.77 | 106.86 | 24558.0 |
| 2013-10-21 | FTDX | Futures | 1043.1 | 1053.5 | 1043.1 | 1053.0 | 166.0 |
| 2013-10-21 | FTI | Futures | 332.28 | 334.83 | 332.28 | 334.35 | 21523.0 |
| 2013-10-21 | FTUK | Futures | 4957.5 | 5008.9 | 4940.7 | 4968.4 | 61930.0 |
| 2013-10-21 | FVSA | Futures | 2136.2 | 2166.63 | 2130.11 | 2142.29 | 7723.0 |
| 2013-10-21 | FXXP | Futures | 232.5 | 233.0 | 231.8 | 232.7 | 7314.0 |
| 2013-10-21 | G | Futures | 92.39 | 92.52 | 92.26 | 92.3 | 84333.0 |
| 2013-10-21 | GF | Futures | 268.737 | 269.544 | 267.971 | 268.414 | 1527.0 |
| 2013-10-21 | GSCI | Futures | 1067.72 | 1067.72 | 1057.79 | 1059.38 | 68.0 |
| 2013-10-21 | HE | Futures | 111.319 | 111.319 | 110.497 | 110.718 | 11345.0 |
| 2013-10-21 | HG | Futures | 4.1715 | 4.193 | 4.1557 | 4.1829 | 26924.0 |
| 2013-10-21 | HH | Futures | 40.096 | 40.096 | 39.029 | 39.157 | 1963.0 |
| 2013-10-21 | HO | Futures | 2.4292 | 2.4355 | 2.4063 | 2.4086 | 30050.0 |
> showing 50 of 103 rows — these rows as CSV