PREVIEW / futures_daily / 2012-05-02
file: by_date/futures_daily/2012/2012-05-02.parquet size: 9 KB rows: 100
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-02 | ES | Futures | 1411.31 | 1415.59 | 1399.97 | 1408.28 | 1682321.0 |
| 2012-05-02 | NQ | Futures | 3114.07 | 3130.11 | 3096.31 | 3124.95 | 221305.0 |
| 2012-05-02 | YM | Futures | 12855.3 | 12887.4 | 12773.7 | 12840.8 | 109262.0 |
| 2012-05-02 | CL | Futures | 194.41 | 194.54 | 192.45 | 193.01 | 256649.0 |
| 2012-05-02 | GC | Futures | 2223.1 | 2224.3 | 2200.4 | 2211.1 | 129795.0 |
| 2012-05-02 | ZN | Futures | 114.423011 | 114.720847 | 114.247017 | 114.531315 | 988532.0 |
| 2012-05-02 | A6 | Futures | 0.92537 | 0.92717 | 0.92078 | 0.92465 | 123467.0 |
| 2012-05-02 | AD | Futures | 1.0196 | 1.0204 | 1.01467 | 1.01879 | 67108.0 |
| 2012-05-02 | B | Futures | 107.85 | 107.99 | 106.1 | 106.61 | 121105.0 |
| 2012-05-02 | B6 | Futures | 1.7021 | 1.704 | 1.6958 | 1.6996 | 102241.0 |
| 2012-05-02 | BFX | Futures | 2718.5 | 2718.5 | 2690.9 | 2690.9 | 21.0 |
| 2012-05-02 | BR | Futures | 0.24803 | 0.24841 | 0.24584 | 0.24665 | 139.0 |
| 2012-05-02 | BZ | Futures | 114.5 | 114.64 | 113.08 | 113.61 | 3222.0 |
| 2012-05-02 | C | Futures | 1522.0 | 1541.0 | 1517.0 | 1540.0 | 3730.0 |
| 2012-05-02 | CB | Futures | 72.93 | 72.93 | 72.204 | 72.204 | 2.0 |
| 2012-05-02 | CC | Futures | 1753.0 | 1775.0 | 1744.0 | 1766.0 | 12754.0 |
| 2012-05-02 | CSC | Futures | 3.51 | 3.52 | 3.43 | 3.432 | 21.0 |
| 2012-05-02 | CT | Futures | 109.5 | 110.03 | 108.69 | 109.5 | 8406.0 |
| 2012-05-02 | DC | Futures | 24.22 | 24.58 | 23.81 | 23.94 | 348.0 |
| 2012-05-02 | DX | Futures | 76.445 | 76.93 | 76.445 | 76.737 | 19298.0 |
| 2012-05-02 | E1 | Futures | 1.4428 | 1.44359 | 1.4301 | 1.43442 | 49001.0 |
| 2012-05-02 | E6 | Futures | 1.58053 | 1.58113 | 1.56668 | 1.57146 | 258790.0 |
| 2012-05-02 | E7 | Futures | 1.5658 | 1.5658 | 1.5518 | 1.5564 | 3090.0 |
| 2012-05-02 | EBM | Futures | 289.74 | 293.78 | 289.4 | 293.44 | 6481.0 |
| 2012-05-02 | ED | Futures | 95.0693 | 95.074 | 95.0645 | 95.0693 | 87592.0 |
| 2012-05-02 | ER | Futures | 97.592 | 97.607 | 97.577 | 97.602 | 137678.0 |
| 2012-05-02 | EW | Futures | 1002.1 | 1008.3 | 995.2 | 1005.5 | 22598.0 |
| 2012-05-02 | FBTP | Futures | 66.41 | 66.68 | 66.08 | 66.21 | 14106.0 |
| 2012-05-02 | FBTS | Futures | 85.363 | 85.388 | 85.127 | 85.192 | 1049.0 |
| 2012-05-02 | FCE | Futures | 2303.8 | 2325.1 | 2280.7 | 2295.1 | 136387.0 |
| 2012-05-02 | FDAX | Futures | 7550.2 | 7611.0 | 7371.7 | 7417.5 | 156506.0 |
| 2012-05-02 | FESX | Futures | 1574.3 | 1586.8 | 1537.8 | 1547.4 | 1284812.0 |
| 2012-05-02 | FEU3 | Futures | 98.162 | 98.177 | 98.162 | 98.177 | 602.0 |
| 2012-05-02 | FGBL | Futures | 115.51 | 116.3 | 115.38 | 116.21 | 732371.0 |
| 2012-05-02 | FGBM | Futures | 114.79 | 115.21 | 114.78 | 115.12 | 412836.0 |
| 2012-05-02 | FGBS | Futures | 110.183 | 110.248 | 110.183 | 110.218 | 329405.0 |
| 2012-05-02 | FGBX | Futures | 120.04 | 120.93 | 119.59 | 120.8 | 6407.0 |
| 2012-05-02 | FOAT | Futures | 95.09 | 95.22 | 94.87 | 95.13 | 11299.0 |
| 2012-05-02 | FTDX | Futures | 755.5 | 761.6 | 739.6 | 743.8 | 132.0 |
| 2012-05-02 | FTI | Futures | 267.68 | 269.06 | 262.81 | 264.12 | 40711.0 |
| 2012-05-02 | FTUK | Futures | 4208.9 | 4221.7 | 4158.9 | 4171.0 | 117103.0 |
| 2012-05-02 | FVSA | Futures | 8746.79 | 9160.15 | 8664.11 | 9011.34 | 1248.0 |
| 2012-05-02 | FXXP | Futures | 186.9 | 187.0 | 183.8 | 184.6 | 2873.0 |
| 2012-05-02 | G | Futures | 94.71 | 95.51 | 94.67 | 95.39 | 125880.0 |
| 2012-05-02 | GF | Futures | 312.812 | 313.802 | 311.614 | 312.396 | 1950.0 |
| 2012-05-02 | GSCI | Futures | 1087.6 | 1088.31 | 1076.48 | 1077.67 | 82.0 |
| 2012-05-02 | HE | Futures | 91.793 | 92.139 | 89.792 | 90.086 | 23052.0 |
| 2012-05-02 | HG | Futures | 5.0269 | 5.0282 | 4.9326 | 4.9595 | 47772.0 |
| 2012-05-02 | HO | Futures | 2.6149 | 2.6182 | 2.5748 | 2.5833 | 73120.0 |
| 2012-05-02 | HRC | Futures | 2590.2 | 2590.2 | 2590.2 | 2590.2 | 0.0 |
> showing 50 of 100 rows — these rows as CSV