PREVIEW / futures_daily / 2013-10-23
file: by_date/futures_daily/2013/2013-10-23.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-10-23 | ES | Futures | 1797.13 | 1797.13 | 1781.72 | 1789.17 | 1520034.0 |
| 2013-10-23 | NQ | Futures | 3854.46 | 3855.89 | 3815.69 | 3836.08 | 244371.0 |
| 2013-10-23 | YM | Futures | 15327.9 | 15327.9 | 15226.4 | 15274.2 | 135650.0 |
| 2013-10-23 | CL | Futures | 174.58 | 174.89 | 171.1 | 172.34 | 356194.0 |
| 2013-10-23 | GC | Futures | 1772.3 | 1775.1 | 1757.0 | 1764.3 | 99059.0 |
| 2013-10-23 | ZN | Futures | 115.532496 | 115.829895 | 115.532496 | 115.702438 | 870293.0 |
| 2013-10-23 | A6 | Futures | 0.91352 | 0.91853 | 0.90417 | 0.9053 | 99359.0 |
| 2013-10-23 | AD | Futures | 0.98077 | 0.98137 | 0.97056 | 0.97096 | 91189.0 |
| 2013-10-23 | B | Futures | 109.63 | 109.7 | 107.0 | 107.45 | 324607.0 |
| 2013-10-23 | B6 | Futures | 1.7031 | 1.7057 | 1.6914 | 1.6967 | 87941.0 |
| 2013-10-23 | BFX | Futures | 3454.0 | 3454.0 | 3451.4 | 3451.4 | 1.0 |
| 2013-10-23 | BR | Futures | 0.23191 | 0.23191 | 0.23041 | 0.23084 | 783.0 |
| 2013-10-23 | BZ | Futures | 110.2 | 110.24 | 107.62 | 108.09 | 10576.0 |
| 2013-10-23 | C | Futures | 1872.0 | 1874.0 | 1839.0 | 1840.0 | 8869.0 |
| 2013-10-23 | CB | Futures | 68.819 | 69.994 | 68.819 | 69.79 | 8.0 |
| 2013-10-23 | CC | Futures | 2059.0 | 2069.0 | 2019.0 | 2023.0 | 15077.0 |
| 2013-10-23 | CNH | Futures | 7.0201 | 7.0253 | 7.0201 | 7.0253 | 1.0 |
| 2013-10-23 | CSC | Futures | 3.398 | 3.412 | 3.377 | 3.385 | 13.0 |
| 2013-10-23 | CT | Futures | 96.78 | 97.18 | 94.46 | 94.66 | 26682.0 |
| 2013-10-23 | DC | Futures | 25.7 | 26.02 | 25.69 | 25.79 | 404.0 |
| 2013-10-23 | DX | Futures | 75.566 | 75.69 | 75.452 | 75.584 | 13442.0 |
| 2013-10-23 | E1 | Futures | 1.4366 | 1.44263 | 1.4339 | 1.44135 | 28805.0 |
| 2013-10-23 | E6 | Futures | 1.62631 | 1.62797 | 1.62183 | 1.62631 | 168143.0 |
| 2013-10-23 | E7 | Futures | 1.6157 | 1.6175 | 1.6115 | 1.6158 | 3471.0 |
| 2013-10-23 | ED | Futures | 95.359 | 95.3638 | 95.3542 | 95.359 | 94618.0 |
| 2013-10-23 | ER | Futures | 97.857 | 97.862 | 97.852 | 97.857 | 61322.0 |
| 2013-10-23 | EW | Futures | 1318.9 | 1318.9 | 1304.8 | 1312.5 | 16536.0 |
| 2013-10-23 | FBTP | Futures | 81.0 | 81.21 | 80.93 | 81.0 | 33792.0 |
| 2013-10-23 | FBTS | Futures | 94.785 | 94.828 | 94.742 | 94.776 | 6478.0 |
| 2013-10-23 | FCE | Futures | 3309.8 | 3311.3 | 3290.0 | 3299.3 | 88998.0 |
| 2013-10-23 | FDAX | Futures | 9894.4 | 9915.5 | 9873.9 | 9890.5 | 80848.0 |
| 2013-10-23 | FESX | Futures | 2121.0 | 2121.7 | 2105.6 | 2108.4 | 890694.0 |
| 2013-10-23 | FEU3 | Futures | 98.478 | 98.483 | 98.478 | 98.478 | 21.0 |
| 2013-10-23 | FGBL | Futures | 119.8 | 119.99 | 119.68 | 119.94 | 618493.0 |
| 2013-10-23 | FGBM | Futures | 117.93 | 118.01 | 117.84 | 117.97 | 436497.0 |
| 2013-10-23 | FGBS | Futures | 110.478 | 110.478 | 110.433 | 110.463 | 261630.0 |
| 2013-10-23 | FGBX | Futures | 120.66 | 120.84 | 120.23 | 120.66 | 28894.0 |
| 2013-10-23 | FMWO | Futures | 5257.3 | 5257.3 | 5257.3 | 5257.3 | 0.0 |
| 2013-10-23 | FOAT | Futures | 107.67 | 107.81 | 107.54 | 107.78 | 44155.0 |
| 2013-10-23 | FTDX | Futures | 1056.8 | 1058.2 | 1051.6 | 1053.9 | 746.0 |
| 2013-10-23 | FTI | Futures | 334.7 | 335.04 | 333.7 | 334.74 | 20853.0 |
| 2013-10-23 | FTUK | Futures | 4995.8 | 5001.8 | 4973.7 | 4980.1 | 76891.0 |
| 2013-10-23 | FVSA | Futures | 2154.46 | 2197.06 | 2142.29 | 2166.63 | 3556.0 |
| 2013-10-23 | FXXP | Futures | 232.6 | 232.9 | 232.0 | 232.2 | 9195.0 |
| 2013-10-23 | G | Futures | 93.12 | 93.44 | 93.01 | 93.36 | 151035.0 |
| 2013-10-23 | GF | Futures | 271.116 | 272.205 | 269.947 | 270.39 | 1749.0 |
| 2013-10-23 | GSCI | Futures | 1047.79 | 1047.79 | 1039.45 | 1041.45 | 160.0 |
| 2013-10-23 | HE | Futures | 112.174 | 112.3 | 111.193 | 111.573 | 11154.0 |
| 2013-10-23 | HG | Futures | 4.2209 | 4.2221 | 4.1278 | 4.1373 | 63574.0 |
| 2013-10-23 | HH | Futures | 38.538 | 38.815 | 38.527 | 38.634 | 4223.0 |
> showing 50 of 104 rows — these rows as CSV