PREVIEW / futures_daily / 2015-10-08
file: by_date/futures_daily/2015/2015-10-08.parquet size: 9 KB rows: 106
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-10-08 | ES | Futures | 2114.47 | 2136.81 | 2096.65 | 2134.42 | 1803978.0 |
| 2015-10-08 | NQ | Futures | 5055.66 | 5084.01 | 4986.67 | 5079.92 | 317019.0 |
| 2015-10-08 | YM | Futures | 17344.2 | 17522.7 | 17210.0 | 17505.1 | 188228.0 |
| 2015-10-08 | CL | Futures | 77.27 | 80.42 | 76.71 | 79.39 | 509760.0 |
| 2015-10-08 | GC | Futures | 1478.1 | 1485.7 | 1466.3 | 1477.2 | 121187.0 |
| 2015-10-08 | ZN | Futures | 123.302385 | 123.63167 | 122.958132 | 123.062905 | 1181806.0 |
| 2015-10-08 | A6 | Futures | 0.71813 | 0.72913 | 0.71423 | 0.72353 | 90400.0 |
| 2015-10-08 | AD | Futures | 0.78387 | 0.78889 | 0.78316 | 0.78725 | 52770.0 |
| 2015-10-08 | ALI | Futures | 2099.38 | 2099.38 | 2099.38 | 2099.38 | 0.0 |
| 2015-10-08 | B | Futures | 47.07 | 48.2 | 46.33 | 47.78 | 256717.0 |
| 2015-10-08 | B6 | Futures | 1.6125 | 1.6184 | 1.6067 | 1.6164 | 89661.0 |
| 2015-10-08 | BFX | Futures | 4133.6 | 4147.5 | 4131.8 | 4143.3 | 18.0 |
| 2015-10-08 | BR | Futures | 0.15497 | 0.15927 | 0.15497 | 0.15866 | 1812.0 |
| 2015-10-08 | BZ | Futures | 46.41 | 47.99 | 46.09 | 47.52 | 24663.0 |
| 2015-10-08 | C | Futures | 2240.0 | 2243.0 | 2219.0 | 2231.0 | 9955.0 |
| 2015-10-08 | CB | Futures | 185.899 | 185.899 | 185.899 | 185.899 | 1.0 |
| 2015-10-08 | CC | Futures | 2246.0 | 2256.0 | 2225.0 | 2244.0 | 18459.0 |
| 2015-10-08 | CNH | Futures | 7.1042 | 7.1081 | 7.0919 | 7.0919 | 3.0 |
| 2015-10-08 | CSC | Futures | 4.337 | 4.35 | 4.307 | 4.35 | 42.0 |
| 2015-10-08 | CT | Futures | 74.7 | 74.92 | 73.7 | 74.04 | 12111.0 |
| 2015-10-08 | DC | Futures | 35.03 | 35.32 | 34.83 | 35.28 | 124.0 |
| 2015-10-08 | DX | Futures | 89.472 | 89.523 | 88.892 | 89.23 | 28538.0 |
| 2015-10-08 | E1 | Futures | 1.30535 | 1.32095 | 1.30522 | 1.31525 | 17183.0 |
| 2015-10-08 | E6 | Futures | 1.31786 | 1.32817 | 1.31728 | 1.32185 | 221962.0 |
| 2015-10-08 | E7 | Futures | 1.3102 | 1.3208 | 1.3102 | 1.3146 | 5385.0 |
| 2015-10-08 | EBM | Futures | 260.51 | 263.07 | 260.15 | 261.61 | 18655.0 |
| 2015-10-08 | ED | Futures | 95.7304 | 95.74 | 95.7159 | 95.7352 | 271049.0 |
| 2015-10-08 | ER | Futures | 98.141 | 98.146 | 98.141 | 98.141 | 15974.0 |
| 2015-10-08 | EW | Futures | 1499.8 | 1517.3 | 1488.2 | 1515.5 | 21546.0 |
| 2015-10-08 | FBTP | Futures | 102.83 | 103.16 | 102.77 | 102.88 | 78581.0 |
| 2015-10-08 | FBTS | Futures | 100.4 | 100.418 | 100.373 | 100.382 | 11802.0 |
| 2015-10-08 | FCE | Futures | 3886.5 | 3934.9 | 3864.9 | 3892.8 | 84402.0 |
| 2015-10-08 | FDAX | Futures | 10946.5 | 11129.3 | 10911.8 | 11014.8 | 91985.0 |
| 2015-10-08 | FESX | Futures | 2408.0 | 2439.5 | 2395.3 | 2413.3 | 998056.0 |
| 2015-10-08 | FGBL | Futures | 139.21 | 139.49 | 138.81 | 139.1 | 524385.0 |
| 2015-10-08 | FGBM | Futures | 125.26 | 125.37 | 125.18 | 125.24 | 316139.0 |
| 2015-10-08 | FGBS | Futures | 111.283 | 111.298 | 111.273 | 111.283 | 166443.0 |
| 2015-10-08 | FGBX | Futures | 158.71 | 159.65 | 157.69 | 158.49 | 27084.0 |
| 2015-10-08 | FMWO | Futures | 5514.9 | 5521.0 | 5514.9 | 5521.0 | 116.0 |
| 2015-10-08 | FOAT | Futures | 127.37 | 127.69 | 127.3 | 127.36 | 78367.0 |
| 2015-10-08 | FTDX | Futures | 1685.6 | 1687.5 | 1676.1 | 1683.7 | 56.0 |
| 2015-10-08 | FTI | Futures | 382.67 | 387.19 | 380.85 | 383.98 | 34107.0 |
| 2015-10-08 | FTUK | Futures | 5096.4 | 5149.4 | 5044.9 | 5106.4 | 91912.0 |
| 2015-10-08 | FVSA | Futures | 2367.2 | 2408.81 | 2233.12 | 2344.08 | 7102.0 |
| 2015-10-08 | FXXP | Futures | 280.9 | 283.6 | 279.0 | 281.4 | 39738.0 |
| 2015-10-08 | G | Futures | 105.02 | 105.25 | 104.85 | 104.95 | 132962.0 |
| 2015-10-08 | GF | Futures | 327.854 | 336.377 | 326.611 | 333.58 | 1882.0 |
| 2015-10-08 | GSCI | Futures | 607.85 | 617.48 | 607.85 | 616.01 | 1758.0 |
| 2015-10-08 | HE | Futures | 99.161 | 99.609 | 97.515 | 98.936 | 11399.0 |
| 2015-10-08 | HG | Futures | 2.9631 | 2.97 | 2.9017 | 2.933 | 45058.0 |
> showing 50 of 106 rows — these rows as CSV