PREVIEW / futures_daily / 2013-06-28
file: by_date/futures_daily/2013/2013-06-28.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 |
|---|---|---|---|---|---|---|---|
| 2013-06-28 | ES | Futures | 1654.38 | 1662.88 | 1642.02 | 1647.17 | 2143749.0 |
| 2013-06-28 | NQ | Futures | 3353.42 | 3380.02 | 3336.35 | 3356.02 | 239222.0 |
| 2013-06-28 | YM | Futures | 14804.9 | 14869.3 | 14670.1 | 14692.9 | 179853.0 |
| 2013-06-28 | CL | Futures | 168.63 | 170.39 | 167.79 | 168.2 | 247607.0 |
| 2013-06-28 | GC | Futures | 1592.4 | 1639.2 | 1565.7 | 1624.5 | 309347.0 |
| 2013-06-28 | ZN | Futures | 113.826261 | 114.02278 | 113.180558 | 113.699928 | 1436070.0 |
| 2013-06-28 | A6 | Futures | 0.86592 | 0.86629 | 0.85025 | 0.85447 | 146589.0 |
| 2013-06-28 | AD | Futures | 0.95948 | 0.9619 | 0.95263 | 0.95757 | 87387.0 |
| 2013-06-28 | B | Futures | 99.62 | 100.21 | 98.66 | 98.93 | 129877.0 |
| 2013-06-28 | B6 | Futures | 1.5992 | 1.6011 | 1.5892 | 1.5941 | 113592.0 |
| 2013-06-28 | BFX | Futures | 3068.9 | 3068.9 | 3034.1 | 3043.7 | 76.0 |
| 2013-06-28 | BR | Futures | 0.22108 | 0.22113 | 0.21898 | 0.21957 | 161.0 |
| 2013-06-28 | BZ | Futures | 100.58 | 100.86 | 99.53 | 99.6 | 11426.0 |
| 2013-06-28 | C | Futures | 1539.0 | 1551.0 | 1526.0 | 1545.0 | 4821.0 |
| 2013-06-28 | CB | Futures | 73.312 | 73.91 | 73.312 | 73.791 | 32.0 |
| 2013-06-28 | CC | Futures | 1605.0 | 1625.0 | 1591.0 | 1617.0 | 13118.0 |
| 2013-06-28 | CNH | Futures | 7.1627 | 7.1627 | 7.1452 | 7.146 | 10.0 |
| 2013-06-28 | CSC | Futures | 3.456 | 3.461 | 3.456 | 3.457 | 17.0 |
| 2013-06-28 | CT | Futures | 102.54 | 102.79 | 101.5 | 101.95 | 17.0 |
| 2013-06-28 | DC | Futures | 26.27 | 26.44 | 26.15 | 26.33 | 243.0 |
| 2013-06-28 | DX | Futures | 79.547 | 79.891 | 79.299 | 79.682 | 35525.0 |
| 2013-06-28 | E1 | Futures | 1.36051 | 1.36656 | 1.35756 | 1.36296 | 29001.0 |
| 2013-06-28 | E6 | Futures | 1.53922 | 1.54689 | 1.53356 | 1.53686 | 266624.0 |
| 2013-06-28 | E7 | Futures | 1.5289 | 1.5368 | 1.5236 | 1.5268 | 3347.0 |
| 2013-06-28 | ED | Futures | 95.2678 | 95.2773 | 95.2534 | 95.263 | 107572.0 |
| 2013-06-28 | ER | Futures | 97.808 | 97.817 | 97.788 | 97.798 | 97647.0 |
| 2013-06-28 | EW | Futures | 1181.6 | 1188.2 | 1172.2 | 1179.6 | 32303.0 |
| 2013-06-28 | FBTP | Futures | 76.52 | 77.1 | 76.09 | 76.5 | 43092.0 |
| 2013-06-28 | FBTS | Futures | 92.266 | 92.481 | 92.12 | 92.223 | 6065.0 |
| 2013-06-28 | FCE | Futures | 2918.7 | 2928.4 | 2885.3 | 2898.1 | 111703.0 |
| 2013-06-28 | FDAX | Futures | 8883.3 | 8929.4 | 8776.2 | 8842.3 | 113209.0 |
| 2013-06-28 | FESX | Futures | 1837.6 | 1848.1 | 1814.5 | 1822.9 | 1026915.0 |
| 2013-06-28 | FEU3 | Futures | 98.409 | 98.409 | 98.399 | 98.409 | 210.0 |
| 2013-06-28 | FGBL | Futures | 118.61 | 118.77 | 118.04 | 118.5 | 690702.0 |
| 2013-06-28 | FGBM | Futures | 116.55 | 116.67 | 116.29 | 116.56 | 495747.0 |
| 2013-06-28 | FGBS | Futures | 110.208 | 110.248 | 110.138 | 110.198 | 356451.0 |
| 2013-06-28 | FGBX | Futures | 123.02 | 123.38 | 122.56 | 123.21 | 10219.0 |
| 2013-06-28 | FMWO | Futures | 4709.0 | 4709.0 | 4709.0 | 4709.0 | 340.0 |
| 2013-06-28 | FOAT | Futures | 105.65 | 105.94 | 105.07 | 105.5 | 45391.0 |
| 2013-06-28 | FTDX | Futures | 903.2 | 903.2 | 886.7 | 890.0 | 87.0 |
| 2013-06-28 | FTI | Futures | 300.3 | 302.35 | 299.34 | 300.47 | 26968.0 |
| 2013-06-28 | FTUK | Futures | 4630.9 | 4665.8 | 4616.3 | 4621.5 | 106026.0 |
| 2013-06-28 | FVSA | Futures | 3291.87 | 3447.21 | 3269.67 | 3343.65 | 2305.0 |
| 2013-06-28 | FXXP | Futures | 210.4 | 211.1 | 208.4 | 209.1 | 6110.0 |
| 2013-06-28 | G | Futures | 94.68 | 94.89 | 93.88 | 94.31 | 176900.0 |
| 2013-06-28 | GF | Futures | 252.186 | 254.039 | 250.122 | 251.807 | 4616.0 |
| 2013-06-28 | GSCI | Futures | 1015.16 | 1016.14 | 1003.64 | 1003.64 | 184.0 |
| 2013-06-28 | HE | Futures | 101.575 | 101.949 | 100.38 | 100.878 | 7763.0 |
| 2013-06-28 | HG | Futures | 3.8776 | 3.9194 | 3.8262 | 3.8795 | 57409.0 |
| 2013-06-28 | HH | Futures | 39.688 | 40.178 | 39.298 | 39.71 | 2914.0 |
> showing 50 of 104 rows — these rows as CSV