PREVIEW / futures_daily / 2012-02-08
file: by_date/futures_daily/2012/2012-02-08.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-02-08 | ES | Futures | 1349.04 | 1353.06 | 1343.02 | 1351.8 | 1540962.0 |
| 2012-02-08 | NQ | Futures | 2891.87 | 2913.31 | 2883.01 | 2910.17 | 198952.0 |
| 2012-02-08 | YM | Futures | 12402.7 | 12446.3 | 12355.3 | 12420.1 | 78245.0 |
| 2012-02-08 | CL | Futures | 184.59 | 187.06 | 183.34 | 184.48 | 364737.0 |
| 2012-02-08 | GC | Futures | 2340.4 | 2349.9 | 2311.3 | 2318.4 | 151075.0 |
| 2012-02-08 | ZN | Futures | 113.286776 | 113.394797 | 113.09774 | 113.286776 | 967225.0 |
| 2012-02-08 | A6 | Futures | 0.95703 | 0.96068 | 0.95392 | 0.95632 | 99292.0 |
| 2012-02-08 | AD | Futures | 1.00864 | 1.00934 | 1.00382 | 1.00683 | 68789.0 |
| 2012-02-08 | B | Futures | 103.08 | 104.56 | 102.79 | 103.87 | 165820.0 |
| 2012-02-08 | B6 | Futures | 1.662 | 1.6646 | 1.6508 | 1.6529 | 86986.0 |
| 2012-02-08 | BFX | Futures | 2744.7 | 2755.4 | 2739.8 | 2740.3 | 4.0 |
| 2012-02-08 | BR | Futures | 0.27023 | 0.27147 | 0.27023 | 0.27117 | 162.0 |
| 2012-02-08 | BZ | Futures | 110.02 | 110.86 | 109.57 | 110.7 | 1157.0 |
| 2012-02-08 | C | Futures | 1509.0 | 1509.0 | 1489.0 | 1498.0 | 3645.0 |
| 2012-02-08 | CB | Futures | 79.658 | 79.658 | 79.389 | 79.658 | 21.0 |
| 2012-02-08 | CC | Futures | 1752.0 | 1762.0 | 1720.0 | 1733.0 | 14526.0 |
| 2012-02-08 | CSC | Futures | 3.752 | 3.752 | 3.695 | 3.708 | 38.0 |
| 2012-02-08 | CT | Futures | 122.06 | 123.37 | 120.45 | 120.58 | 13903.0 |
| 2012-02-08 | DC | Futures | 26.2 | 26.2 | 25.66 | 25.94 | 434.0 |
| 2012-02-08 | DX | Futures | 76.546 | 76.751 | 76.415 | 76.633 | 25570.0 |
| 2012-02-08 | E1 | Futures | 1.44127 | 1.44205 | 1.43523 | 1.43851 | 28525.0 |
| 2012-02-08 | E6 | Futures | 1.58497 | 1.58855 | 1.58043 | 1.58413 | 276607.0 |
| 2012-02-08 | E7 | Futures | 1.5708 | 1.5742 | 1.566 | 1.5697 | 4960.0 |
| 2012-02-08 | EBM | Futures | 290.24 | 292.21 | 282.71 | 283.04 | 13238.0 |
| 2012-02-08 | ED | Futures | 95.1059 | 95.1202 | 95.1011 | 95.1059 | 157981.0 |
| 2012-02-08 | ER | Futures | 97.464 | 97.464 | 97.43 | 97.454 | 72170.0 |
| 2012-02-08 | EW | Futures | 977.9 | 983.3 | 971.9 | 980.4 | 15979.0 |
| 2012-02-08 | FBTP | Futures | 64.89 | 65.34 | 64.57 | 64.83 | 12964.0 |
| 2012-02-08 | FBTS | Futures | 84.569 | 84.689 | 84.344 | 84.561 | 1274.0 |
| 2012-02-08 | FCE | Futures | 2435.6 | 2448.8 | 2426.7 | 2429.6 | 70175.0 |
| 2012-02-08 | FDAX | Futures | 7495.5 | 7548.0 | 7439.8 | 7453.0 | 127644.0 |
| 2012-02-08 | FESX | Futures | 1686.1 | 1698.1 | 1678.1 | 1680.1 | 933030.0 |
| 2012-02-08 | FEU3 | Futures | 98.024 | 98.024 | 98.009 | 98.009 | 54.0 |
| 2012-02-08 | FGBL | Futures | 111.5 | 111.64 | 111.27 | 111.55 | 623174.0 |
| 2012-02-08 | FGBM | Futures | 112.86 | 112.96 | 112.73 | 112.91 | 430250.0 |
| 2012-02-08 | FGBS | Futures | 109.825 | 109.84 | 109.785 | 109.8 | 428728.0 |
| 2012-02-08 | FGBX | Futures | 115.2 | 115.42 | 114.77 | 115.18 | 6909.0 |
| 2012-02-08 | FTDX | Futures | 710.6 | 721.8 | 710.6 | 717.1 | 186.0 |
| 2012-02-08 | FTI | Futures | 272.31 | 273.61 | 271.31 | 271.39 | 28296.0 |
| 2012-02-08 | FTUK | Futures | 4219.1 | 4235.7 | 4202.9 | 4204.0 | 73174.0 |
| 2012-02-08 | FVSA | Futures | 9718.39 | 9987.28 | 9718.39 | 9987.28 | 760.0 |
| 2012-02-08 | FXXP | Futures | 186.8 | 187.0 | 185.3 | 185.5 | 3206.0 |
| 2012-02-08 | G | Futures | 93.06 | 93.49 | 93.01 | 93.4 | 128570.0 |
| 2012-02-08 | GF | Futures | 329.082 | 330.248 | 327.756 | 329.294 | 3275.0 |
| 2012-02-08 | GSCI | Futures | 1059.75 | 1060.3 | 1049.43 | 1056.31 | 1602.0 |
| 2012-02-08 | HE | Futures | 107.616 | 107.978 | 107.163 | 107.495 | 11368.0 |
| 2012-02-08 | HG | Futures | 5.1039 | 5.1902 | 5.0827 | 5.1566 | 53534.0 |
| 2012-02-08 | HO | Futures | 2.5779 | 2.5924 | 2.5617 | 2.5812 | 72249.0 |
| 2012-02-08 | HRC | Futures | 2837.4 | 2837.4 | 2837.4 | 2837.4 | 0.0 |
| 2012-02-08 | J1 | Futures | 0.0163598 | 0.0163737 | 0.0162719 | 0.0163084 | 75828.0 |
> showing 50 of 99 rows — these rows as CSV