PREVIEW / futures_daily / 2015-09-24
file: by_date/futures_daily/2015/2015-09-24.parquet size: 9 KB rows: 107
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 |
|---|---|---|---|---|---|---|---|
| 2015-09-24 | ES | Futures | 2054.9 | 2059.69 | 2018.2 | 2041.07 | 2218286.0 |
| 2015-09-24 | NQ | Futures | 4990.77 | 5002.75 | 4893.43 | 4964.46 | 355070.0 |
| 2015-09-24 | YM | Futures | 16726.1 | 16759.2 | 16415.6 | 16610.6 | 243203.0 |
| 2015-09-24 | CL | Futures | 71.67 | 72.57 | 70.21 | 72.13 | 371976.0 |
| 2015-09-24 | GC | Futures | 1458.7 | 1492.8 | 1458.1 | 1489.4 | 219683.0 |
| 2015-09-24 | ZN | Futures | 122.524074 | 123.062905 | 122.434269 | 122.73362 | 1269777.0 |
| 2015-09-24 | A6 | Futures | 0.69753 | 0.70143 | 0.69103 | 0.70063 | 92292.0 |
| 2015-09-24 | AD | Futures | 0.7683 | 0.77035 | 0.76308 | 0.76861 | 63690.0 |
| 2015-09-24 | ALI | Futures | 2146.46 | 2146.46 | 2146.46 | 2146.46 | 0.0 |
| 2015-09-24 | B | Futures | 43.39 | 43.93 | 42.96 | 43.66 | 198036.0 |
| 2015-09-24 | B6 | Futures | 1.6052 | 1.6095 | 1.6001 | 1.6037 | 81272.0 |
| 2015-09-24 | BFX | Futures | 3989.1 | 3989.1 | 3959.5 | 3974.6 | 10.0 |
| 2015-09-24 | BR | Futures | 0.14653 | 0.15146 | 0.14185 | 0.1477 | 1604.0 |
| 2015-09-24 | BZ | Futures | 43.46 | 43.93 | 42.96 | 43.65 | 21355.0 |
| 2015-09-24 | C | Futures | 2402.0 | 2403.0 | 2374.0 | 2386.0 | 8885.0 |
| 2015-09-24 | CB | Futures | 199.037 | 203.367 | 197.807 | 197.807 | 9.0 |
| 2015-09-24 | CC | Futures | 2430.0 | 2430.0 | 2399.0 | 2415.0 | 21311.0 |
| 2015-09-24 | CNH | Futures | 7.203 | 7.2042 | 7.1893 | 7.1893 | 38.0 |
| 2015-09-24 | CSC | Futures | 4.299 | 4.409 | 4.299 | 4.337 | 89.0 |
| 2015-09-24 | CT | Futures | 71.83 | 72.94 | 71.62 | 72.35 | 15019.0 |
| 2015-09-24 | DC | Futures | 34.61 | 35.5 | 34.61 | 35.12 | 161.0 |
| 2015-09-24 | DX | Futures | 90.122 | 90.22 | 89.388 | 89.924 | 49554.0 |
| 2015-09-24 | E1 | Futures | 1.29939 | 1.31575 | 1.29723 | 1.30269 | 17483.0 |
| 2015-09-24 | E6 | Futures | 1.31212 | 1.32501 | 1.30955 | 1.31599 | 244478.0 |
| 2015-09-24 | E7 | Futures | 1.3046 | 1.3177 | 1.3024 | 1.3087 | 5065.0 |
| 2015-09-24 | EBM | Futures | 255.03 | 255.76 | 251.74 | 252.47 | 28210.0 |
| 2015-09-24 | ED | Futures | 95.7111 | 95.7256 | 95.7063 | 95.7159 | 192790.0 |
| 2015-09-24 | ER | Futures | 98.136 | 98.136 | 98.126 | 98.136 | 37025.0 |
| 2015-09-24 | EW | Futures | 1466.7 | 1470.5 | 1444.5 | 1456.4 | 18259.0 |
| 2015-09-24 | FBTP | Futures | 102.4 | 102.62 | 102.13 | 102.41 | 76398.0 |
| 2015-09-24 | FBTS | Futures | 100.293 | 100.32 | 100.266 | 100.284 | 13479.0 |
| 2015-09-24 | FCE | Futures | 3682.9 | 3702.9 | 3580.0 | 3612.5 | 151119.0 |
| 2015-09-24 | FDAX | Futures | 10563.8 | 10692.1 | 10309.9 | 10369.9 | 149595.0 |
| 2015-09-24 | FESX | Futures | 2297.1 | 2315.8 | 2236.4 | 2250.6 | 1719707.0 |
| 2015-09-24 | FEU3 | Futures | 98.779 | 98.784 | 98.779 | 98.784 | 1014.0 |
| 2015-09-24 | FGBL | Futures | 138.86 | 139.21 | 138.59 | 138.98 | 697699.0 |
| 2015-09-24 | FGBM | Futures | 125.22 | 125.27 | 125.1 | 125.22 | 537294.0 |
| 2015-09-24 | FGBS | Futures | 111.303 | 111.308 | 111.273 | 111.293 | 288998.0 |
| 2015-09-24 | FGBX | Futures | 158.94 | 160.42 | 158.2 | 159.53 | 30980.0 |
| 2015-09-24 | FMWO | Futures | 5296.0 | 5296.0 | 5229.3 | 5234.2 | 275.0 |
| 2015-09-24 | FOAT | Futures | 127.12 | 127.33 | 126.78 | 127.06 | 80812.0 |
| 2015-09-24 | FTDX | Futures | 1626.8 | 1634.3 | 1593.6 | 1596.9 | 265.0 |
| 2015-09-24 | FTI | Futures | 362.96 | 365.35 | 352.97 | 355.75 | 51173.0 |
| 2015-09-24 | FTUK | Futures | 4807.3 | 4842.7 | 4753.4 | 4761.9 | 117106.0 |
| 2015-09-24 | FVSA | Futures | 2496.66 | 2681.59 | 2450.42 | 2649.23 | 16012.0 |
| 2015-09-24 | FXXP | Futures | 268.0 | 270.3 | 262.5 | 263.4 | 37849.0 |
| 2015-09-24 | G | Futures | 105.02 | 105.65 | 104.88 | 105.56 | 200203.0 |
| 2015-09-24 | GF | Futures | 321.373 | 327.854 | 314.449 | 319.775 | 7566.0 |
| 2015-09-24 | GSCI | Futures | 581.0 | 586.14 | 578.23 | 585.9 | 1031.0 |
| 2015-09-24 | HE | Futures | 95.945 | 98.562 | 95.122 | 98.45 | 17907.0 |
> showing 50 of 107 rows — these rows as CSV