PREVIEW / futures_daily / 2015-09-11
file: by_date/futures_daily/2015/2015-09-11.parquet size: 9 KB rows: 102
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-11 | ES | Futures | 2066.11 | 2079.89 | 2053.13 | 2077.51 | 1045267.0 |
| 2015-09-11 | NQ | Futures | 5014.2 | 5055.36 | 4973.05 | 5049.81 | 127471.0 |
| 2015-09-11 | YM | Futures | 16724.1 | 16872.7 | 16625.0 | 16856.1 | 113804.0 |
| 2015-09-11 | CL | Futures | 74.55 | 74.83 | 72.03 | 72.79 | 395838.0 |
| 2015-09-11 | GC | Futures | 1433.1 | 1435.3 | 1417.0 | 1424.2 | 119503.0 |
| 2015-09-11 | ZN | Futures | 121.760731 | 122.224724 | 121.700861 | 122.164854 | 742290.0 |
| 2015-09-11 | A6 | Futures | 0.70423 | 0.70613 | 0.70033 | 0.70503 | 68178.0 |
| 2015-09-11 | AD | Futures | 0.77322 | 0.77486 | 0.76923 | 0.7722 | 80584.0 |
| 2015-09-11 | ALI | Futures | 2208.34 | 2208.34 | 2208.34 | 2208.34 | 0.0 |
| 2015-09-11 | B | Futures | 44.95 | 45.26 | 43.6 | 44.45 | 248660.0 |
| 2015-09-11 | B6 | Futures | 1.6256 | 1.6276 | 1.6211 | 1.6238 | 74251.0 |
| 2015-09-11 | BR | Futures | 0.15493 | 0.15632 | 0.15392 | 0.15426 | 141.0 |
| 2015-09-11 | BZ | Futures | 44.99 | 45.24 | 43.61 | 44.44 | 23283.0 |
| 2015-09-11 | C | Futures | 2338.0 | 2355.0 | 2318.0 | 2331.0 | 11845.0 |
| 2015-09-11 | CB | Futures | 192.886 | 192.886 | 192.886 | 192.886 | 2.0 |
| 2015-09-11 | CC | Futures | 2400.0 | 2413.0 | 2368.0 | 2386.0 | 13164.0 |
| 2015-09-11 | CNH | Futures | 7.1631 | 7.2013 | 7.162 | 7.1948 | 102.0 |
| 2015-09-11 | CSC | Futures | 4.44 | 4.44 | 4.409 | 4.417 | 27.0 |
| 2015-09-11 | CT | Futures | 77.51 | 79.58 | 76.34 | 78.43 | 19.0 |
| 2015-09-11 | DC | Futures | 35.23 | 35.39 | 35.01 | 35.12 | 84.0 |
| 2015-09-11 | DX | Futures | 89.49 | 89.663 | 89.121 | 89.204 | 49296.0 |
| 2015-09-11 | E1 | Futures | 1.307 | 1.31448 | 1.29901 | 1.31322 | 22933.0 |
| 2015-09-11 | E6 | Futures | 1.32314 | 1.33169 | 1.32044 | 1.32993 | 240385.0 |
| 2015-09-11 | E7 | Futures | 1.3156 | 1.3242 | 1.313 | 1.3226 | 3965.0 |
| 2015-09-11 | EBM | Futures | 246.63 | 248.09 | 243.71 | 245.17 | 23860.0 |
| 2015-09-11 | ED | Futures | 95.6487 | 95.6631 | 95.6487 | 95.6583 | 198711.0 |
| 2015-09-11 | ER | Futures | 98.122 | 98.131 | 98.117 | 98.126 | 125588.0 |
| 2015-09-11 | EW | Futures | 1474.5 | 1488.2 | 1466.1 | 1487.8 | 33413.0 |
| 2015-09-11 | FBTP | Futures | 101.29 | 101.52 | 101.16 | 101.47 | 68970.0 |
| 2015-09-11 | FBTS | Futures | 100.213 | 100.231 | 100.177 | 100.195 | 14256.0 |
| 2015-09-11 | FCE | Futures | 3871.9 | 3874.0 | 3804.9 | 3808.7 | 86546.0 |
| 2015-09-11 | FDAX | Futures | 11331.5 | 11332.0 | 11139.7 | 11208.2 | 94227.0 |
| 2015-09-11 | FESX | Futures | 2414.8 | 2418.5 | 2375.1 | 2384.8 | 764354.0 |
| 2015-09-11 | FEU3 | Futures | 98.769 | 98.774 | 98.769 | 98.774 | 1655.0 |
| 2015-09-11 | FGBL | Futures | 137.75 | 138.2 | 137.66 | 138.15 | 415944.0 |
| 2015-09-11 | FGBM | Futures | 124.94 | 125.05 | 124.9 | 125.02 | 268627.0 |
| 2015-09-11 | FGBS | Futures | 111.233 | 111.253 | 111.223 | 111.248 | 164523.0 |
| 2015-09-11 | FGBX | Futures | 155.55 | 155.92 | 155.15 | 155.8 | 21608.0 |
| 2015-09-11 | FMWO | Futures | 5375.7 | 5375.7 | 5358.5 | 5369.5 | 1381.0 |
| 2015-09-11 | FOAT | Futures | 125.87 | 126.24 | 125.76 | 126.2 | 67282.0 |
| 2015-09-11 | FTDX | Futures | 1637.2 | 1637.2 | 1625.3 | 1629.6 | 874.0 |
| 2015-09-11 | FTI | Futures | 379.98 | 380.16 | 373.34 | 373.34 | 1586.0 |
| 2015-09-11 | FTUK | Futures | 4938.0 | 4941.2 | 4890.1 | 4899.8 | 33450.0 |
| 2015-09-11 | FVSA | Futures | 2505.87 | 2655.29 | 2505.87 | 2616.87 | 7345.0 |
| 2015-09-11 | FXXP | Futures | 276.9 | 277.1 | 275.8 | 276.2 | 33681.0 |
| 2015-09-11 | G | Futures | 104.4 | 104.78 | 104.25 | 104.74 | 125543.0 |
| 2015-09-11 | GF | Futures | 351.957 | 352.001 | 344.677 | 346.408 | 5453.0 |
| 2015-09-11 | GSCI | Futures | 592.59 | 595.12 | 590.3 | 594.79 | 2477.0 |
| 2015-09-11 | HE | Futures | 93.738 | 93.84 | 91.755 | 92.063 | 21899.0 |
| 2015-09-11 | HG | Futures | 3.0676 | 3.0851 | 3.0307 | 3.0713 | 45335.0 |
> showing 50 of 102 rows — these rows as CSV