PREVIEW / futures_daily / 2013-09-16
file: by_date/futures_daily/2013/2013-09-16.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-09-16 | ES | Futures | 1739.09 | 1750.14 | 1733.96 | 1737.3 | 2030544.0 |
| 2013-09-16 | NQ | Futures | 3675.86 | 3690.5 | 3625.04 | 3630.49 | 300932.0 |
| 2013-09-16 | YM | Futures | 15293.1 | 15433.4 | 15293.1 | 15353.8 | 145496.0 |
| 2013-09-16 | CL | Futures | 189.72 | 189.95 | 186.9 | 188.0 | 162033.0 |
| 2013-09-16 | GC | Futures | 1763.6 | 1766.9 | 1722.9 | 1742.8 | 158187.0 |
| 2013-09-16 | ZN | Futures | 112.572666 | 113.096655 | 112.331914 | 112.360238 | 1385764.0 |
| 2013-09-16 | A6 | Futures | 0.87725 | 0.88131 | 0.87357 | 0.87395 | 78846.0 |
| 2013-09-16 | AD | Futures | 0.97682 | 0.98056 | 0.97612 | 0.97682 | 52623.0 |
| 2013-09-16 | B | Futures | 110.12 | 110.36 | 107.63 | 108.95 | 249444.0 |
| 2013-09-16 | B6 | Futures | 1.6714 | 1.6746 | 1.6672 | 1.6676 | 91068.0 |
| 2013-09-16 | BFX | Futures | 3394.4 | 3394.4 | 3388.2 | 3388.2 | 10.0 |
| 2013-09-16 | BR | Futures | 0.22115 | 0.22222 | 0.21917 | 0.21942 | 120.0 |
| 2013-09-16 | BZ | Futures | 110.47 | 111.19 | 108.44 | 109.78 | 8102.0 |
| 2013-09-16 | C | Futures | 1806.0 | 1847.0 | 1805.0 | 1840.0 | 9674.0 |
| 2013-09-16 | CB | Futures | 72.416 | 72.416 | 71.361 | 72.128 | 26.0 |
| 2013-09-16 | CC | Futures | 1939.0 | 1969.0 | 1935.0 | 1965.0 | 13514.0 |
| 2013-09-16 | CNH | Futures | 7.0653 | 7.0661 | 7.0651 | 7.0661 | 1.0 |
| 2013-09-16 | CSC | Futures | 3.251 | 3.257 | 3.213 | 3.224 | 28.0 |
| 2013-09-16 | CT | Futures | 100.99 | 101.23 | 100.99 | 101.23 | 10.0 |
| 2013-09-16 | DC | Futures | 24.83 | 24.92 | 24.47 | 24.64 | 133.0 |
| 2013-09-16 | DX | Futures | 77.486 | 77.615 | 77.305 | 77.603 | 20870.0 |
| 2013-09-16 | E1 | Futures | 1.39085 | 1.39226 | 1.38609 | 1.38622 | 24644.0 |
| 2013-09-16 | E6 | Futures | 1.57757 | 1.58029 | 1.57356 | 1.57392 | 164112.0 |
| 2013-09-16 | E7 | Futures | 1.5666 | 1.5702 | 1.5635 | 1.5638 | 2709.0 |
| 2013-09-16 | ED | Futures | 95.3208 | 95.3303 | 95.316 | 95.3208 | 147072.0 |
| 2013-09-16 | ER | Futures | 97.847 | 97.867 | 97.842 | 97.842 | 83952.0 |
| 2013-09-16 | EW | Futures | 1258.2 | 1268.8 | 1254.6 | 1256.0 | 42814.0 |
| 2013-09-16 | FBTP | Futures | 77.24 | 77.6 | 76.93 | 77.48 | 24482.0 |
| 2013-09-16 | FBTS | Futures | 93.16 | 93.272 | 93.048 | 93.229 | 4544.0 |
| 2013-09-16 | FCE | Futures | 3207.7 | 3212.3 | 3190.7 | 3200.7 | 65142.0 |
| 2013-09-16 | FDAX | Futures | 9562.1 | 9578.2 | 9519.9 | 9558.7 | 105011.0 |
| 2013-09-16 | FESX | Futures | 2032.7 | 2032.7 | 2013.7 | 2020.7 | 646773.0 |
| 2013-09-16 | FEU3 | Futures | 98.473 | 98.473 | 98.463 | 98.463 | 521.0 |
| 2013-09-16 | FGBL | Futures | 117.92 | 118.07 | 117.62 | 117.93 | 553547.0 |
| 2013-09-16 | FGBM | Futures | 116.83 | 116.97 | 116.66 | 116.79 | 337419.0 |
| 2013-09-16 | FGBS | Futures | 110.343 | 110.363 | 110.288 | 110.313 | 229235.0 |
| 2013-09-16 | FGBX | Futures | 119.5 | 119.96 | 118.88 | 119.46 | 19397.0 |
| 2013-09-16 | FMWO | Futures | 5092.8 | 5099.1 | 5092.8 | 5099.1 | 488.0 |
| 2013-09-16 | FOAT | Futures | 105.3 | 105.42 | 105.02 | 105.34 | 29415.0 |
| 2013-09-16 | FTDX | Futures | 1006.8 | 1013.9 | 1006.8 | 1013.9 | 14.0 |
| 2013-09-16 | FTI | Futures | 329.2 | 330.02 | 328.55 | 329.16 | 4758.0 |
| 2013-09-16 | FTUK | Futures | 4958.3 | 4982.7 | 4938.0 | 4947.4 | 74476.0 |
| 2013-09-16 | FVSA | Futures | 2549.62 | 2601.78 | 2536.58 | 2588.74 | 9116.0 |
| 2013-09-16 | FXXP | Futures | 228.7 | 228.7 | 227.7 | 228.0 | 73144.0 |
| 2013-09-16 | G | Futures | 91.12 | 91.35 | 90.97 | 91.19 | 104735.0 |
| 2013-09-16 | GF | Futures | 260.061 | 260.673 | 259.409 | 260.021 | 1502.0 |
| 2013-09-16 | GSCI | Futures | 1076.46 | 1082.23 | 1075.03 | 1077.88 | 223.0 |
| 2013-09-16 | HE | Futures | 110.448 | 111.567 | 110.176 | 111.446 | 23089.0 |
| 2013-09-16 | HG | Futures | 4.0981 | 4.155 | 4.0493 | 4.0797 | 42832.0 |
| 2013-09-16 | HH | Futures | 39.3 | 40.412 | 39.246 | 40.358 | 3856.0 |
> showing 50 of 103 rows — these rows as CSV