PREVIEW / futures_daily / 2012-05-17
file: by_date/futures_daily/2012/2012-05-17.parquet size: 9 KB rows: 99
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-17 | ES | Futures | 1333.21 | 1341.02 | 1310.53 | 1311.29 | 2906203.0 |
| 2012-05-17 | NQ | Futures | 2932.76 | 2945.65 | 2869.74 | 2869.74 | 348697.0 |
| 2012-05-17 | YM | Futures | 12229.1 | 12296.2 | 12067.6 | 12071.5 | 193045.0 |
| 2012-05-17 | CL | Futures | 170.62 | 172.71 | 169.47 | 170.33 | 141656.0 |
| 2012-05-17 | GC | Futures | 2056.8 | 2111.9 | 2056.5 | 2105.3 | 211541.0 |
| 2012-05-17 | ZN | Futures | 115.600815 | 115.939265 | 115.37067 | 115.898651 | 1361755.0 |
| 2012-05-17 | A6 | Futures | 0.88902 | 0.8937 | 0.8865 | 0.89055 | 158554.0 |
| 2012-05-17 | AD | Futures | 0.99303 | 0.99505 | 0.98599 | 0.98821 | 123034.0 |
| 2012-05-17 | B | Futures | 98.95 | 99.6 | 96.38 | 97.2 | 293237.0 |
| 2012-05-17 | B6 | Futures | 1.6699 | 1.6721 | 1.6533 | 1.6598 | 156473.0 |
| 2012-05-17 | BFX | Futures | 2545.2 | 2545.2 | 2524.9 | 2527.3 | 16.0 |
| 2012-05-17 | BR | Futures | 0.2382 | 0.23897 | 0.23618 | 0.23854 | 132.0 |
| 2012-05-17 | BZ | Futures | 105.62 | 106.11 | 103.07 | 103.58 | 1732.0 |
| 2012-05-17 | C | Futures | 1529.0 | 1549.0 | 1524.0 | 1527.0 | 4413.0 |
| 2012-05-17 | CB | Futures | 75.352 | 75.352 | 75.083 | 75.083 | 4.0 |
| 2012-05-17 | CC | Futures | 1720.0 | 1726.0 | 1674.0 | 1677.0 | 12932.0 |
| 2012-05-17 | CSC | Futures | 3.467 | 3.575 | 3.467 | 3.554 | 15.0 |
| 2012-05-17 | CT | Futures | 94.32 | 95.7 | 93.29 | 93.77 | 11245.0 |
| 2012-05-17 | DC | Futures | 24.94 | 25.42 | 24.86 | 25.22 | 339.0 |
| 2012-05-17 | DX | Futures | 78.984 | 79.284 | 78.867 | 79.003 | 47980.0 |
| 2012-05-17 | E1 | Futures | 1.3869 | 1.39017 | 1.38127 | 1.3865 | 51677.0 |
| 2012-05-17 | E6 | Futures | 1.5181 | 1.52227 | 1.51225 | 1.51786 | 320573.0 |
| 2012-05-17 | E7 | Futures | 1.5037 | 1.5076 | 1.4976 | 1.5033 | 3260.0 |
| 2012-05-17 | ED | Futures | 95.0478 | 95.0502 | 95.0406 | 95.0478 | 130898.0 |
| 2012-05-17 | ER | Futures | 97.518 | 97.533 | 97.489 | 97.508 | 94023.0 |
| 2012-05-17 | EW | Futures | 950.0 | 955.5 | 923.4 | 923.8 | 34176.0 |
| 2012-05-17 | FBTP | Futures | 65.28 | 65.31 | 64.61 | 65.09 | 16133.0 |
| 2012-05-17 | FBTS | Futures | 84.566 | 84.566 | 83.996 | 84.305 | 3767.0 |
| 2012-05-17 | FCE | Futures | 2223.6 | 2234.0 | 2182.7 | 2197.8 | 162686.0 |
| 2012-05-17 | FDAX | Futures | 7075.4 | 7100.8 | 6921.2 | 6984.8 | 165282.0 |
| 2012-05-17 | FESX | Futures | 1486.7 | 1494.3 | 1454.9 | 1468.7 | 1515612.0 |
| 2012-05-17 | FGBL | Futures | 117.4 | 118.1 | 117.34 | 117.8 | 681884.0 |
| 2012-05-17 | FGBM | Futures | 115.39 | 115.79 | 115.36 | 115.66 | 429786.0 |
| 2012-05-17 | FGBS | Futures | 110.223 | 110.328 | 110.218 | 110.283 | 280912.0 |
| 2012-05-17 | FGBX | Futures | 125.01 | 126.82 | 124.66 | 126.09 | 6009.0 |
| 2012-05-17 | FOAT | Futures | 95.76 | 95.98 | 95.55 | 95.93 | 7981.0 |
| 2012-05-17 | FTDX | Futures | 711.5 | 713.4 | 705.9 | 706.8 | 174.0 |
| 2012-05-17 | FTI | Futures | 255.36 | 256.05 | 249.81 | 251.28 | 18793.0 |
| 2012-05-17 | FTUK | Futures | 3926.2 | 3943.7 | 3850.7 | 3888.6 | 143307.0 |
| 2012-05-17 | FVSA | Futures | 10242.32 | 10867.81 | 10211.05 | 10648.89 | 6976.0 |
| 2012-05-17 | FXXP | Futures | 176.6 | 176.6 | 173.7 | 174.5 | 3299.0 |
| 2012-05-17 | G | Futures | 97.0 | 97.52 | 97.0 | 97.2 | 131036.0 |
| 2012-05-17 | GF | Futures | 312.469 | 315.726 | 312.469 | 315.627 | 2796.0 |
| 2012-05-17 | GSCI | Futures | 1006.79 | 1007.74 | 997.58 | 1000.28 | 55.0 |
| 2012-05-17 | HE | Futures | 92.139 | 93.713 | 92.006 | 93.259 | 23123.0 |
| 2012-05-17 | HG | Futures | 4.5548 | 4.6118 | 4.5221 | 4.5561 | 59368.0 |
| 2012-05-17 | HO | Futures | 2.3716 | 2.3882 | 2.3341 | 2.342 | 58274.0 |
| 2012-05-17 | HRC | Futures | 2598.0 | 2598.0 | 2598.0 | 2598.0 | 0.0 |
| 2012-05-17 | J1 | Futures | 0.0156147 | 0.0158504 | 0.0156009 | 0.0158228 | 137709.0 |
| 2012-05-17 | J7 | Futures | 0.01553 | 0.015774 | 0.015527 | 0.015748 | 732.0 |
> showing 50 of 99 rows — these rows as CSV