PREVIEW / futures_daily / 2018-05-15
file: by_date/futures_daily/2018/2018-05-15.parquet size: 10 KB rows: 112
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 |
|---|---|---|---|---|---|---|---|
| 2018-05-15 | ES | Futures | 2967.16 | 2970.15 | 2936.71 | 2945.95 | 1519108.0 |
| 2018-05-15 | NQ | Futures | 8156.75 | 8165.82 | 8022.44 | 8064.87 | 432917.0 |
| 2018-05-15 | YM | Futures | 26196.0 | 26224.4 | 25916.8 | 25976.9 | 204096.0 |
| 2018-05-15 | CL | Futures | 71.68 | 72.42 | 70.94 | 71.83 | 349961.0 |
| 2018-05-15 | GC | Futures | 1676.5 | 1678.4 | 1644.6 | 1647.3 | 485197.0 |
| 2018-05-15 | ZN | Futures | 118.268447 | 118.330481 | 117.632595 | 117.725647 | 2462266.0 |
| 2018-05-15 | A6 | Futures | 0.77386 | 0.77509 | 0.76594 | 0.7682 | 129314.0 |
| 2018-05-15 | AD | Futures | 0.79092 | 0.79132 | 0.78318 | 0.78677 | 92265.0 |
| 2018-05-15 | B | Futures | 57.47 | 58.24 | 57.09 | 57.48 | 390915.0 |
| 2018-05-15 | B6 | Futures | 1.4062 | 1.4075 | 1.395 | 1.4009 | 112064.0 |
| 2018-05-15 | BR | Futures | 0.21039 | 0.21043 | 0.20609 | 0.20814 | 4263.0 |
| 2018-05-15 | BTC | Futures | 12266.4 | 12427.9 | 11845.1 | 12013.6 | 4222.0 |
| 2018-05-15 | BZ | Futures | 56.96 | 57.63 | 56.5 | 56.89 | 41100.0 |
| 2018-05-15 | C | Futures | 1750.0 | 1765.0 | 1699.0 | 1701.0 | 21677.0 |
| 2018-05-15 | CB | Futures | 298.975 | 299.933 | 298.975 | 299.933 | 15.0 |
| 2018-05-15 | CC | Futures | 2028.0 | 2030.0 | 1941.0 | 1950.0 | 21802.0 |
| 2018-05-15 | CNH | Futures | 6.439 | 6.4693 | 6.439 | 6.4678 | 40.0 |
| 2018-05-15 | CSC | Futures | 3.58 | 3.58 | 3.572 | 3.574 | 28.0 |
| 2018-05-15 | CT | Futures | 95.61 | 95.93 | 94.76 | 95.21 | 15675.0 |
| 2018-05-15 | DC | Futures | 28.75 | 28.89 | 28.75 | 28.86 | 218.0 |
| 2018-05-15 | DX | Futures | 87.268 | 88.037 | 87.221 | 87.799 | 29914.0 |
| 2018-05-15 | E1 | Futures | 1.20731 | 1.2096 | 1.20261 | 1.2049 | 26215.0 |
| 2018-05-15 | E6 | Futures | 1.347 | 1.34801 | 1.33472 | 1.33782 | 331653.0 |
| 2018-05-15 | E7 | Futures | 1.3396 | 1.3408 | 1.3276 | 1.3307 | 5010.0 |
| 2018-05-15 | EBM | Futures | 178.9 | 179.16 | 177.85 | 178.11 | 11449.0 |
| 2018-05-15 | ED | Futures | 95.0205 | 95.0375 | 95.0157 | 95.0205 | 452897.0 |
| 2018-05-15 | ER | Futures | 98.332 | 98.337 | 98.332 | 98.332 | 107655.0 |
| 2018-05-15 | EW | Futures | 2051.0 | 2052.0 | 2035.6 | 2045.2 | 14463.0 |
| 2018-05-15 | FBON | Futures | 129.06 | 129.24 | 128.63 | 128.82 | 156.0 |
| 2018-05-15 | FBTP | Futures | 114.39 | 114.77 | 114.06 | 114.24 | 94750.0 |
| 2018-05-15 | FBTS | Futures | 104.13 | 104.195 | 104.038 | 104.065 | 67964.0 |
| 2018-05-15 | FCE | Futures | 4913.0 | 4944.0 | 4906.7 | 4935.0 | 186076.0 |
| 2018-05-15 | FDAX | Futures | 13458.8 | 13524.8 | 13422.9 | 13487.4 | 78988.0 |
| 2018-05-15 | FDXM | Futures | 13334.3 | 13400.2 | 13304.4 | 13367.3 | 29968.0 |
| 2018-05-15 | FESX | Futures | 2932.2 | 2945.5 | 2928.9 | 2939.7 | 836669.0 |
| 2018-05-15 | FEU3 | Futures | 99.011 | 99.021 | 99.011 | 99.021 | 99.0 |
| 2018-05-15 | FGBL | Futures | 148.81 | 148.84 | 148.32 | 148.46 | 832065.0 |
| 2018-05-15 | FGBM | Futures | 129.33 | 129.37 | 129.2 | 129.24 | 464678.0 |
| 2018-05-15 | FGBS | Futures | 112.472 | 112.477 | 112.447 | 112.457 | 409188.0 |
| 2018-05-15 | FGBX | Futures | 168.15 | 168.2 | 166.87 | 167.22 | 58230.0 |
| 2018-05-15 | FMWO | Futures | 7076.4 | 7088.1 | 7025.0 | 7047.2 | 451.0 |
| 2018-05-15 | FOAT | Futures | 138.03 | 138.09 | 137.66 | 137.73 | 127592.0 |
| 2018-05-15 | FTDX | Futures | 2746.3 | 2753.7 | 2727.5 | 2740.9 | 158.0 |
| 2018-05-15 | FTI | Futures | 517.6 | 521.11 | 517.18 | 519.91 | 25020.0 |
| 2018-05-15 | FTUK | Futures | 6797.7 | 6828.6 | 6769.9 | 6811.8 | 119605.0 |
| 2018-05-15 | FVSA | Futures | 300.72 | 307.16 | 296.42 | 299.64 | 30822.0 |
| 2018-05-15 | FXXP | Futures | 336.1 | 338.2 | 336.1 | 337.5 | 38776.0 |
| 2018-05-15 | G | Futures | 113.17 | 113.45 | 112.93 | 113.02 | 323867.0 |
| 2018-05-15 | GF | Futures | 290.538 | 290.745 | 285.462 | 286.809 | 7639.0 |
| 2018-05-15 | GSCI | Futures | 548.58 | 548.58 | 543.2 | 546.73 | 651.0 |
> showing 50 of 112 rows — these rows as CSV