PREVIEW / futures_daily / 2015-10-07
file: by_date/futures_daily/2015/2015-10-07.parquet size: 9 KB rows: 107
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 |
|---|---|---|---|---|---|---|---|
| 2015-10-07 | ES | Futures | 2086.02 | 2118.2 | 2085.49 | 2113.94 | 1937061.0 |
| 2015-10-07 | NQ | Futures | 4998.37 | 5067.06 | 4990.18 | 5055.37 | 329985.0 |
| 2015-10-07 | YM | Futures | 17144.0 | 17403.0 | 17128.5 | 17348.3 | 201370.0 |
| 2015-10-07 | CL | Futures | 78.7 | 79.84 | 76.61 | 76.79 | 547488.0 |
| 2015-10-07 | GC | Futures | 1480.0 | 1489.2 | 1473.3 | 1482.8 | 113149.0 |
| 2015-10-07 | ZN | Futures | 123.63167 | 123.69154 | 123.197612 | 123.39219 | 987294.0 |
| 2015-10-07 | A6 | Futures | 0.71393 | 0.72103 | 0.71253 | 0.71833 | 84690.0 |
| 2015-10-07 | AD | Futures | 0.78582 | 0.7893 | 0.78326 | 0.78397 | 65563.0 |
| 2015-10-07 | ALI | Futures | 2108.41 | 2108.41 | 2108.41 | 2108.41 | 0.0 |
| 2015-10-07 | B | Futures | 47.17 | 47.96 | 46.28 | 46.34 | 323992.0 |
| 2015-10-07 | B6 | Futures | 1.6037 | 1.6148 | 1.6026 | 1.6127 | 82309.0 |
| 2015-10-07 | BFX | Futures | 4168.1 | 4168.1 | 4148.1 | 4148.1 | 1.0 |
| 2015-10-07 | BR | Futures | 0.15737 | 0.1594 | 0.15577 | 0.15592 | 1271.0 |
| 2015-10-07 | BZ | Futures | 46.84 | 47.69 | 46.02 | 46.08 | 30444.0 |
| 2015-10-07 | C | Futures | 2256.0 | 2285.0 | 2240.0 | 2246.0 | 10899.0 |
| 2015-10-07 | CB | Futures | 185.21 | 185.653 | 185.21 | 185.333 | 6.0 |
| 2015-10-07 | CC | Futures | 2264.0 | 2306.0 | 2238.0 | 2258.0 | 22221.0 |
| 2015-10-07 | CNH | Futures | 7.0987 | 7.0987 | 7.0881 | 7.0952 | 110.0 |
| 2015-10-07 | CSC | Futures | 4.325 | 4.327 | 4.312 | 4.312 | 27.0 |
| 2015-10-07 | CT | Futures | 74.38 | 74.95 | 74.11 | 74.44 | 12113.0 |
| 2015-10-07 | DC | Futures | 34.99 | 35.12 | 34.74 | 34.83 | 118.0 |
| 2015-10-07 | DX | Futures | 89.392 | 89.593 | 89.247 | 89.392 | 21727.0 |
| 2015-10-07 | E1 | Futures | 1.31461 | 1.31766 | 1.3051 | 1.30738 | 17267.0 |
| 2015-10-07 | E6 | Futures | 1.32138 | 1.32325 | 1.31458 | 1.31939 | 184219.0 |
| 2015-10-07 | E7 | Futures | 1.3146 | 1.3158 | 1.3074 | 1.3121 | 3924.0 |
| 2015-10-07 | EBM | Futures | 263.8 | 265.99 | 259.78 | 260.51 | 33036.0 |
| 2015-10-07 | ED | Futures | 95.7448 | 95.7448 | 95.7256 | 95.7304 | 165965.0 |
| 2015-10-07 | ER | Futures | 98.146 | 98.146 | 98.141 | 98.146 | 17078.0 |
| 2015-10-07 | EW | Futures | 1472.8 | 1500.2 | 1471.8 | 1498.9 | 21115.0 |
| 2015-10-07 | FBTP | Futures | 102.78 | 102.89 | 102.57 | 102.7 | 94287.0 |
| 2015-10-07 | FBTS | Futures | 100.302 | 100.409 | 100.302 | 100.391 | 11211.0 |
| 2015-10-07 | FCE | Futures | 3875.3 | 3936.5 | 3872.4 | 3883.6 | 97936.0 |
| 2015-10-07 | FDAX | Futures | 10901.9 | 11116.7 | 10891.4 | 10955.3 | 130939.0 |
| 2015-10-07 | FESX | Futures | 2407.3 | 2446.3 | 2403.5 | 2405.8 | 1268510.0 |
| 2015-10-07 | FEU3 | Futures | 98.789 | 98.794 | 98.789 | 98.794 | 1.0 |
| 2015-10-07 | FGBL | Futures | 138.91 | 139.09 | 138.58 | 138.96 | 615487.0 |
| 2015-10-07 | FGBM | Futures | 125.23 | 125.27 | 125.15 | 125.22 | 374363.0 |
| 2015-10-07 | FGBS | Futures | 111.278 | 111.293 | 111.268 | 111.278 | 175930.0 |
| 2015-10-07 | FGBX | Futures | 157.69 | 158.35 | 156.63 | 157.98 | 24939.0 |
| 2015-10-07 | FMWO | Futures | 5513.6 | 5518.6 | 5481.5 | 5482.7 | 787.0 |
| 2015-10-07 | FOAT | Futures | 127.11 | 127.3 | 126.84 | 127.19 | 74887.0 |
| 2015-10-07 | FTDX | Futures | 1705.5 | 1706.4 | 1676.1 | 1676.1 | 242.0 |
| 2015-10-07 | FTI | Futures | 383.2 | 387.71 | 381.37 | 382.5 | 38725.0 |
| 2015-10-07 | FTUK | Futures | 5036.0 | 5119.7 | 5032.0 | 5060.6 | 108819.0 |
| 2015-10-07 | FVSA | Futures | 2357.95 | 2399.56 | 2302.47 | 2394.94 | 15286.0 |
| 2015-10-07 | FXXP | Futures | 281.0 | 283.8 | 279.7 | 279.9 | 32654.0 |
| 2015-10-07 | G | Futures | 104.91 | 104.96 | 104.58 | 104.81 | 156616.0 |
| 2015-10-07 | GF | Futures | 324.658 | 331.583 | 324.436 | 328.387 | 2212.0 |
| 2015-10-07 | GSCI | Futures | 618.21 | 618.78 | 607.19 | 607.19 | 1688.0 |
| 2015-10-07 | HE | Futures | 100.656 | 100.918 | 98.114 | 98.675 | 18436.0 |
> showing 50 of 107 rows — these rows as CSV