PREVIEW / futures_daily / 2012-05-15
file: by_date/futures_daily/2012/2012-05-15.parquet size: 9 KB rows: 98
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 |
|---|---|---|---|---|---|---|---|
| 2012-05-15 | ES | Futures | 1344.8 | 1357.39 | 1335.73 | 1338.5 | 2402932.0 |
| 2012-05-15 | NQ | Futures | 2963.98 | 2997.49 | 2949.66 | 2953.95 | 324953.0 |
| 2012-05-15 | YM | Futures | 12313.7 | 12408.0 | 12227.1 | 12258.2 | 190657.0 |
| 2012-05-15 | CL | Futures | 172.91 | 175.63 | 171.17 | 172.91 | 118662.0 |
| 2012-05-15 | GC | Futures | 2081.7 | 2091.3 | 2060.3 | 2081.5 | 159325.0 |
| 2012-05-15 | ZN | Futures | 115.695581 | 115.763271 | 115.411284 | 115.560201 | 1277242.0 |
| 2012-05-15 | A6 | Futures | 0.89298 | 0.89793 | 0.88947 | 0.89199 | 152804.0 |
| 2012-05-15 | AD | Futures | 1.00209 | 1.00632 | 0.99786 | 1.00078 | 96357.0 |
| 2012-05-15 | B | Futures | 100.13 | 101.28 | 99.72 | 100.78 | 275914.0 |
| 2012-05-15 | B6 | Futures | 1.6893 | 1.691 | 1.6779 | 1.6793 | 112088.0 |
| 2012-05-15 | BFX | Futures | 2604.9 | 2604.9 | 2541.0 | 2553.2 | 423.0 |
| 2012-05-15 | BR | Futures | 0.23811 | 0.23863 | 0.23694 | 0.23804 | 421.0 |
| 2012-05-15 | BZ | Futures | 107.21 | 107.89 | 106.79 | 107.4 | 1841.0 |
| 2012-05-15 | C | Futures | 1495.0 | 1517.0 | 1493.0 | 1508.0 | 5174.0 |
| 2012-05-15 | CB | Futures | 75.352 | 75.352 | 74.814 | 75.352 | 8.0 |
| 2012-05-15 | CC | Futures | 1689.0 | 1720.0 | 1684.0 | 1710.0 | 8801.0 |
| 2012-05-15 | CSC | Futures | 3.398 | 3.439 | 3.398 | 3.428 | 74.0 |
| 2012-05-15 | CT | Futures | 96.3 | 98.66 | 96.03 | 96.84 | 14203.0 |
| 2012-05-15 | DC | Futures | 24.18 | 24.53 | 24.09 | 24.4 | 357.0 |
| 2012-05-15 | DX | Futures | 78.31 | 78.916 | 78.121 | 78.848 | 47765.0 |
| 2012-05-15 | E1 | Futures | 1.39881 | 1.40313 | 1.38729 | 1.38873 | 51119.0 |
| 2012-05-15 | E6 | Futures | 1.53135 | 1.53648 | 1.51881 | 1.52036 | 358548.0 |
| 2012-05-15 | E7 | Futures | 1.5165 | 1.5216 | 1.5044 | 1.5058 | 3525.0 |
| 2012-05-15 | ED | Futures | 95.0358 | 95.0525 | 95.0358 | 95.0406 | 210702.0 |
| 2012-05-15 | ER | Futures | 97.489 | 97.513 | 97.484 | 97.503 | 95314.0 |
| 2012-05-15 | EW | Futures | 960.0 | 971.1 | 955.1 | 957.7 | 35003.0 |
| 2012-05-15 | FBTP | Futures | 65.59 | 65.83 | 64.75 | 64.85 | 28435.0 |
| 2012-05-15 | FBTS | Futures | 84.94 | 84.94 | 84.485 | 84.566 | 4850.0 |
| 2012-05-15 | FCE | Futures | 2235.1 | 2261.2 | 2203.0 | 2217.7 | 170341.0 |
| 2012-05-15 | FDAX | Futures | 7144.5 | 7199.8 | 7023.4 | 7068.8 | 201277.0 |
| 2012-05-15 | FESX | Futures | 1504.6 | 1521.2 | 1477.7 | 1485.3 | 1605475.0 |
| 2012-05-15 | FGBL | Futures | 117.58 | 117.69 | 117.17 | 117.62 | 879015.0 |
| 2012-05-15 | FGBM | Futures | 115.55 | 115.62 | 115.38 | 115.56 | 482970.0 |
| 2012-05-15 | FGBS | Futures | 110.248 | 110.258 | 110.228 | 110.253 | 247863.0 |
| 2012-05-15 | FGBX | Futures | 125.09 | 125.46 | 124.51 | 125.27 | 7429.0 |
| 2012-05-15 | FOAT | Futures | 96.17 | 96.2 | 95.56 | 95.64 | 10539.0 |
| 2012-05-15 | FTDX | Futures | 729.3 | 729.3 | 713.4 | 719.9 | 146.0 |
| 2012-05-15 | FTI | Futures | 257.78 | 260.77 | 254.97 | 256.44 | 33520.0 |
| 2012-05-15 | FTUK | Futures | 3962.7 | 4003.2 | 3924.8 | 3947.4 | 136657.0 |
| 2012-05-15 | FVSA | Futures | 9710.66 | 9992.13 | 9554.29 | 9976.49 | 3075.0 |
| 2012-05-15 | FXXP | Futures | 179.1 | 179.8 | 176.4 | 177.1 | 4596.0 |
| 2012-05-15 | G | Futures | 96.77 | 97.02 | 96.59 | 96.94 | 158404.0 |
| 2012-05-15 | GF | Futures | 310.101 | 311.433 | 309.46 | 311.187 | 1963.0 |
| 2012-05-15 | GSCI | Futures | 1014.17 | 1014.17 | 1003.06 | 1009.41 | 642.0 |
| 2012-05-15 | HE | Futures | 91.579 | 92.726 | 91.259 | 92.166 | 25697.0 |
| 2012-05-15 | HG | Futures | 4.6 | 4.6602 | 4.5653 | 4.6065 | 63015.0 |
| 2012-05-15 | HO | Futures | 2.3959 | 2.4196 | 2.3946 | 2.4111 | 57809.0 |
| 2012-05-15 | HRC | Futures | 2629.4 | 2629.4 | 2629.4 | 2629.4 | 0.0 |
| 2012-05-15 | J1 | Futures | 0.0157075 | 0.015715 | 0.0156122 | 0.0156222 | 92417.0 |
| 2012-05-15 | J7 | Futures | 0.015627 | 0.01564 | 0.01554 | 0.015549 | 368.0 |
> showing 50 of 98 rows — these rows as CSV