PREVIEW / futures_daily / 2012-05-22
file: by_date/futures_daily/2012/2012-05-22.parquet size: 9 KB rows: 97
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-22 | ES | Futures | 1325.4 | 1336.74 | 1317.59 | 1324.89 | 2449269.0 |
| 2012-05-22 | NQ | Futures | 2915.57 | 2934.76 | 2889.79 | 2904.69 | 293161.0 |
| 2012-05-22 | YM | Futures | 12145.4 | 12207.7 | 12081.2 | 12133.8 | 155360.0 |
| 2012-05-22 | CL | Futures | 170.2 | 170.99 | 167.14 | 168.33 | 226226.0 |
| 2012-05-22 | GC | Futures | 2129.5 | 2131.4 | 2086.7 | 2107.6 | 175858.0 |
| 2012-05-22 | ZN | Futures | 115.736195 | 115.736195 | 115.343594 | 115.506049 | 1218294.0 |
| 2012-05-22 | A6 | Futures | 0.8892 | 0.89145 | 0.87823 | 0.88309 | 154364.0 |
| 2012-05-22 | AD | Futures | 0.9881 | 0.99032 | 0.98237 | 0.98549 | 92831.0 |
| 2012-05-22 | B | Futures | 98.79 | 98.89 | 97.47 | 98.03 | 180212.0 |
| 2012-05-22 | B6 | Futures | 1.6608 | 1.6633 | 1.6519 | 1.6555 | 106372.0 |
| 2012-05-22 | BFX | Futures | 2560.0 | 2600.9 | 2560.0 | 2600.9 | 39.0 |
| 2012-05-22 | BR | Futures | 0.23262 | 0.23303 | 0.22852 | 0.23117 | 415.0 |
| 2012-05-22 | BZ | Futures | 104.34 | 105.3 | 103.91 | 104.47 | 1151.0 |
| 2012-05-22 | C | Futures | 1526.0 | 1551.0 | 1495.0 | 1510.0 | 9338.0 |
| 2012-05-22 | CC | Futures | 1686.0 | 1700.0 | 1631.0 | 1643.0 | 15963.0 |
| 2012-05-22 | CSC | Futures | 3.57 | 3.57 | 3.556 | 3.561 | 16.0 |
| 2012-05-22 | CT | Futures | 95.24 | 95.43 | 91.16 | 91.16 | 14054.0 |
| 2012-05-22 | DC | Futures | 25.32 | 25.48 | 25.02 | 25.28 | 308.0 |
| 2012-05-22 | DX | Futures | 78.591 | 79.391 | 78.572 | 79.108 | 33085.0 |
| 2012-05-22 | E1 | Futures | 1.39698 | 1.39763 | 1.38022 | 1.3869 | 55477.0 |
| 2012-05-22 | E6 | Futures | 1.52932 | 1.53027 | 1.51117 | 1.51845 | 290187.0 |
| 2012-05-22 | E7 | Futures | 1.5145 | 1.5155 | 1.4968 | 1.5039 | 3337.0 |
| 2012-05-22 | ED | Futures | 95.0621 | 95.0645 | 95.0549 | 95.0597 | 114766.0 |
| 2012-05-22 | ER | Futures | 97.513 | 97.528 | 97.513 | 97.523 | 71045.0 |
| 2012-05-22 | EW | Futures | 934.5 | 945.0 | 931.4 | 935.6 | 27644.0 |
| 2012-05-22 | FBTP | Futures | 65.54 | 66.45 | 65.42 | 66.4 | 20376.0 |
| 2012-05-22 | FBTS | Futures | 84.371 | 84.753 | 84.322 | 84.729 | 3444.0 |
| 2012-05-22 | FCE | Futures | 2227.0 | 2262.7 | 2216.3 | 2254.2 | 120680.0 |
| 2012-05-22 | FDAX | Futures | 7046.7 | 7127.4 | 7020.1 | 7116.3 | 158788.0 |
| 2012-05-22 | FESX | Futures | 1487.4 | 1510.2 | 1478.4 | 1504.6 | 1348540.0 |
| 2012-05-22 | FGBL | Futures | 117.54 | 117.71 | 117.28 | 117.33 | 700822.0 |
| 2012-05-22 | FGBM | Futures | 115.51 | 115.58 | 115.38 | 115.45 | 464270.0 |
| 2012-05-22 | FGBS | Futures | 110.258 | 110.278 | 110.223 | 110.253 | 382145.0 |
| 2012-05-22 | FGBX | Futures | 126.02 | 126.6 | 125.46 | 125.65 | 3317.0 |
| 2012-05-22 | FOAT | Futures | 96.13 | 96.61 | 96.13 | 96.56 | 20305.0 |
| 2012-05-22 | FTDX | Futures | 708.7 | 714.3 | 707.8 | 713.4 | 95.0 |
| 2012-05-22 | FTI | Futures | 253.23 | 257.05 | 252.1 | 256.31 | 40672.0 |
| 2012-05-22 | FTUK | Futures | 3889.0 | 3935.0 | 3875.5 | 3930.2 | 114526.0 |
| 2012-05-22 | FVSA | Futures | 10211.05 | 10226.68 | 9804.48 | 9882.67 | 4877.0 |
| 2012-05-22 | FXXP | Futures | 175.2 | 177.3 | 174.6 | 176.8 | 3451.0 |
| 2012-05-22 | G | Futures | 97.02 | 97.31 | 96.84 | 97.05 | 128535.0 |
| 2012-05-22 | GF | Futures | 314.098 | 317.058 | 313.752 | 316.022 | 3308.0 |
| 2012-05-22 | GSCI | Futures | 1006.0 | 1006.23 | 993.86 | 996.71 | 313.0 |
| 2012-05-22 | HE | Futures | 92.299 | 92.619 | 90.726 | 91.553 | 18789.0 |
| 2012-05-22 | HG | Futures | 4.6216 | 4.6275 | 4.5208 | 4.5666 | 52616.0 |
| 2012-05-22 | HO | Futures | 2.3668 | 2.3696 | 2.3458 | 2.3545 | 10720.0 |
| 2012-05-22 | HRC | Futures | 2609.8 | 2609.8 | 2609.8 | 2609.8 | 0.0 |
| 2012-05-22 | J1 | Futures | 0.015814 | 0.0158203 | 0.0156435 | 0.0156523 | 92315.0 |
| 2012-05-22 | J7 | Futures | 0.015742 | 0.015742 | 0.015571 | 0.015579 | 337.0 |
| 2012-05-22 | JB | Futures | 125.64 | 125.71 | 125.53 | 125.66 | 3861.0 |
> showing 50 of 97 rows — these rows as CSV