PREVIEW / futures_daily / 2013-01-04
file: by_date/futures_daily/2013/2013-01-04.parquet size: 9 KB rows: 100
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-01-04 | ES | Futures | 1487.73 | 1496.94 | 1484.91 | 1491.56 | 1514786.0 |
| 2013-01-04 | NQ | Futures | 3144.85 | 3155.81 | 3127.26 | 3129.28 | 212859.0 |
| 2013-01-04 | YM | Futures | 13063.5 | 13117.4 | 13038.0 | 13087.0 | 100235.0 |
| 2013-01-04 | CL | Futures | 164.81 | 165.43 | 162.43 | 165.22 | 210747.0 |
| 2013-01-04 | GC | Futures | 2217.2 | 2218.2 | 2166.8 | 2197.4 | 252725.0 |
| 2013-01-04 | ZN | Futures | 115.977011 | 116.114833 | 115.660021 | 116.004576 | 1549140.0 |
| 2013-01-04 | A6 | Futures | 0.95225 | 0.95472 | 0.94621 | 0.95344 | 110556.0 |
| 2013-01-04 | AD | Futures | 1.01292 | 1.01653 | 1.00891 | 1.01442 | 83533.0 |
| 2013-01-04 | B | Futures | 103.86 | 103.86 | 102.37 | 103.27 | 132624.0 |
| 2013-01-04 | B6 | Futures | 1.6788 | 1.6819 | 1.6662 | 1.6782 | 126759.0 |
| 2013-01-04 | BFX | Futures | 3031.7 | 3038.9 | 3026.8 | 3038.2 | 115.0 |
| 2013-01-04 | BR | Futures | 0.23907 | 0.23944 | 0.23765 | 0.23917 | 730.0 |
| 2013-01-04 | BZ | Futures | 105.69 | 105.91 | 104.71 | 105.57 | 903.0 |
| 2013-01-04 | C | Futures | 1529.0 | 1537.0 | 1519.0 | 1524.0 | 6087.0 |
| 2013-01-04 | CC | Futures | 1702.0 | 1702.0 | 1667.0 | 1675.0 | 17112.0 |
| 2013-01-04 | CSC | Futures | 3.899 | 3.899 | 3.894 | 3.894 | 146.0 |
| 2013-01-04 | CT | Futures | 95.21 | 95.42 | 92.78 | 94.45 | 22704.0 |
| 2013-01-04 | DC | Futures | 29.32 | 29.35 | 29.05 | 29.1 | 122.0 |
| 2013-01-04 | DX | Futures | 77.898 | 78.115 | 77.656 | 77.743 | 40388.0 |
| 2013-01-04 | E1 | Futures | 1.38831 | 1.39591 | 1.38509 | 1.39307 | 34815.0 |
| 2013-01-04 | E6 | Futures | 1.53912 | 1.54502 | 1.53382 | 1.54266 | 263072.0 |
| 2013-01-04 | E7 | Futures | 1.5281 | 1.5345 | 1.5233 | 1.5321 | 4375.0 |
| 2013-01-04 | EBM | Futures | 275.34 | 276.45 | 270.33 | 270.89 | 12681.0 |
| 2013-01-04 | ED | Futures | 95.2342 | 95.239 | 95.2199 | 95.2342 | 165366.0 |
| 2013-01-04 | ER | Futures | 97.817 | 97.827 | 97.793 | 97.808 | 165213.0 |
| 2013-01-04 | EW | Futures | 1067.3 | 1075.3 | 1065.2 | 1070.5 | 15671.0 |
| 2013-01-04 | FBTP | Futures | 76.76 | 76.91 | 76.54 | 76.68 | 15688.0 |
| 2013-01-04 | FBTS | Futures | 91.315 | 91.467 | 91.298 | 91.349 | 5804.0 |
| 2013-01-04 | FCE | Futures | 2793.7 | 2815.1 | 2782.4 | 2807.6 | 82592.0 |
| 2013-01-04 | FDAX | Futures | 8461.6 | 8510.7 | 8442.5 | 8485.6 | 82768.0 |
| 2013-01-04 | FESX | Futures | 1832.2 | 1848.6 | 1828.1 | 1838.4 | 640423.0 |
| 2013-01-04 | FEU3 | Futures | 98.413 | 98.413 | 98.413 | 98.413 | 1.0 |
| 2013-01-04 | FGBL | Futures | 118.34 | 118.55 | 117.8 | 117.99 | 899521.0 |
| 2013-01-04 | FGBM | Futures | 116.62 | 116.76 | 116.32 | 116.43 | 512517.0 |
| 2013-01-04 | FGBS | Futures | 110.348 | 110.372 | 110.293 | 110.323 | 480948.0 |
| 2013-01-04 | FGBX | Futures | 124.16 | 124.25 | 122.56 | 123.2 | 10601.0 |
| 2013-01-04 | FOAT | Futures | 105.1 | 105.36 | 104.85 | 105.01 | 31569.0 |
| 2013-01-04 | FTDX | Futures | 806.1 | 810.9 | 806.1 | 810.4 | 203.0 |
| 2013-01-04 | FTI | Futures | 300.85 | 303.17 | 300.42 | 302.18 | 22112.0 |
| 2013-01-04 | FTUK | Futures | 4414.8 | 4459.3 | 4406.0 | 4440.6 | 80043.0 |
| 2013-01-04 | FVSA | Futures | 3705.67 | 3736.13 | 3553.39 | 3553.39 | 7340.0 |
| 2013-01-04 | FXXP | Futures | 206.0 | 206.7 | 205.4 | 206.5 | 1549.0 |
| 2013-01-04 | G | Futures | 96.54 | 96.62 | 96.17 | 96.28 | 188884.0 |
| 2013-01-04 | GF | Futures | 288.948 | 291.462 | 288.901 | 290.656 | 1548.0 |
| 2013-01-04 | GSCI | Futures | 1038.4 | 1044.6 | 1038.0 | 1044.28 | 381.0 |
| 2013-01-04 | HE | Futures | 99.499 | 100.072 | 98.724 | 98.953 | 19257.0 |
| 2013-01-04 | HG | Futures | 4.743 | 4.7604 | 4.7141 | 4.743 | 45816.0 |
| 2013-01-04 | HH | Futures | 38.144 | 38.696 | 38.144 | 38.59 | 297.0 |
| 2013-01-04 | HO | Futures | 2.4259 | 2.4279 | 2.3958 | 2.4195 | 43613.0 |
| 2013-01-04 | HRC | Futures | 2428.1 | 2428.1 | 2428.1 | 2428.1 | 50.0 |
> showing 50 of 100 rows — these rows as CSV