PREVIEW / futures_daily / 2014-05-22
file: by_date/futures_daily/2014/2014-05-22.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-05-22 | ES | Futures | 1949.0 | 1959.6 | 1947.96 | 1955.72 | 1026615.0 |
| 2014-05-22 | NQ | Futures | 4180.24 | 4212.76 | 4179.95 | 4199.23 | 217632.0 |
| 2014-05-22 | YM | Futures | 16557.6 | 16627.9 | 16534.5 | 16595.8 | 98768.0 |
| 2014-05-22 | CL | Futures | 188.9 | 189.57 | 188.35 | 188.7 | 159181.0 |
| 2014-05-22 | GC | Futures | 1702.3 | 1718.3 | 1699.8 | 1706.3 | 128235.0 |
| 2014-05-22 | ZN | Futures | 116.634189 | 116.706624 | 116.416886 | 116.474833 | 1095637.0 |
| 2014-05-22 | A6 | Futures | 0.88684 | 0.88962 | 0.88396 | 0.88415 | 66761.0 |
| 2014-05-22 | AD | Futures | 0.9284 | 0.93093 | 0.92698 | 0.93002 | 40848.0 |
| 2014-05-22 | ALI | Futures | 2704.62 | 2704.62 | 2704.62 | 2704.62 | 4.0 |
| 2014-05-22 | B | Futures | 114.38 | 114.95 | 114.05 | 114.24 | 200094.0 |
| 2014-05-22 | B6 | Futures | 1.7757 | 1.7778 | 1.7709 | 1.7722 | 64365.0 |
| 2014-05-22 | BR | Futures | 0.23795 | 0.23871 | 0.23687 | 0.23687 | 559.0 |
| 2014-05-22 | BZ | Futures | 116.62 | 117.23 | 116.33 | 116.52 | 6092.0 |
| 2014-05-22 | C | Futures | 1933.0 | 1959.0 | 1932.0 | 1954.0 | 8209.0 |
| 2014-05-22 | CB | Futures | 107.123 | 109.275 | 107.123 | 108.856 | 36.0 |
| 2014-05-22 | CC | Futures | 2199.0 | 2220.0 | 2197.0 | 2213.0 | 16562.0 |
| 2014-05-22 | CNH | Futures | 7.15 | 7.15 | 7.1471 | 7.1471 | 1.0 |
| 2014-05-22 | CSC | Futures | 4.321 | 4.491 | 4.312 | 4.491 | 31.0 |
| 2014-05-22 | CT | Futures | 100.54 | 102.08 | 98.82 | 98.84 | 22656.0 |
| 2014-05-22 | DC | Futures | 35.15 | 36.34 | 34.96 | 36.34 | 603.0 |
| 2014-05-22 | DX | Futures | 76.13 | 76.32 | 76.121 | 76.292 | 10915.0 |
| 2014-05-22 | E1 | Futures | 1.43699 | 1.43828 | 1.43379 | 1.43443 | 19883.0 |
| 2014-05-22 | E6 | Futures | 1.61557 | 1.61581 | 1.61073 | 1.61144 | 137816.0 |
| 2014-05-22 | E7 | Futures | 1.6049 | 1.6049 | 1.6001 | 1.6007 | 1715.0 |
| 2014-05-22 | ED | Futures | 95.4138 | 95.4162 | 95.4138 | 95.4162 | 45827.0 |
| 2014-05-22 | ER | Futures | 97.867 | 97.881 | 97.867 | 97.871 | 68398.0 |
| 2014-05-22 | EW | Futures | 1394.1 | 1407.4 | 1392.7 | 1401.6 | 12763.0 |
| 2014-05-22 | FBTP | Futures | 88.16 | 88.54 | 87.81 | 87.89 | 94752.0 |
| 2014-05-22 | FBTS | Futures | 97.267 | 97.328 | 97.126 | 97.144 | 16966.0 |
| 2014-05-22 | FCE | Futures | 3561.7 | 3561.7 | 3532.9 | 3554.9 | 76511.0 |
| 2014-05-22 | FDAX | Futures | 10761.5 | 10761.5 | 10703.0 | 10747.7 | 71082.0 |
| 2014-05-22 | FESX | Futures | 2288.7 | 2291.6 | 2272.2 | 2284.4 | 635082.0 |
| 2014-05-22 | FEU3 | Futures | 98.492 | 98.492 | 98.492 | 98.492 | 23.0 |
| 2014-05-22 | FGBL | Futures | 125.77 | 126.2 | 125.71 | 126.08 | 513947.0 |
| 2014-05-22 | FGBM | Futures | 120.63 | 120.82 | 120.6 | 120.79 | 350755.0 |
| 2014-05-22 | FGBS | Futures | 110.698 | 110.738 | 110.693 | 110.738 | 288470.0 |
| 2014-05-22 | FGBX | Futures | 130.44 | 131.44 | 130.34 | 131.18 | 26650.0 |
| 2014-05-22 | FMWO | Futures | 5621.3 | 5631.4 | 5620.0 | 5631.4 | 40.0 |
| 2014-05-22 | FOAT | Futures | 115.13 | 115.61 | 115.09 | 115.44 | 44649.0 |
| 2014-05-22 | FTDX | Futures | 1169.5 | 1173.7 | 1168.6 | 1173.7 | 61.0 |
| 2014-05-22 | FTI | Futures | 348.34 | 349.81 | 347.69 | 348.56 | 20522.0 |
| 2014-05-22 | FTUK | Futures | 5192.7 | 5212.5 | 5183.2 | 5196.5 | 67394.0 |
| 2014-05-22 | FVSA | Futures | 1625.04 | 1625.04 | 1587.68 | 1592.35 | 4307.0 |
| 2014-05-22 | FXXP | Futures | 256.5 | 256.5 | 254.4 | 255.6 | 3436.0 |
| 2014-05-22 | G | Futures | 94.39 | 94.56 | 94.31 | 94.35 | 128597.0 |
| 2014-05-22 | GF | Futures | 302.075 | 302.304 | 298.243 | 299.431 | 2820.0 |
| 2014-05-22 | GSCI | Futures | 1092.84 | 1094.16 | 1087.29 | 1088.12 | 82.0 |
| 2014-05-22 | HE | Futures | 133.306 | 133.753 | 130.795 | 131.242 | 14655.0 |
| 2014-05-22 | HG | Futures | 3.9969 | 4.0314 | 3.9867 | 4.0148 | 41970.0 |
| 2014-05-22 | HH | Futures | 55.269 | 55.345 | 55.193 | 55.256 | 5808.0 |
> showing 50 of 104 rows — these rows as CSV