PREVIEW / futures_daily / 2018-10-30
file: by_date/futures_daily/2018/2018-10-30.parquet size: 10 KB rows: 113
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-10-30 | ES | Futures | 2862.03 | 2917.61 | 2855.79 | 2912.18 | 2503396.0 |
| 2018-10-30 | NQ | Futures | 7804.58 | 7955.58 | 7736.92 | 7916.09 | 832546.0 |
| 2018-10-30 | YM | Futures | 25660.6 | 26220.8 | 25620.5 | 26177.6 | 345523.0 |
| 2018-10-30 | CL | Futures | 69.49 | 70.09 | 68.08 | 68.97 | 680441.0 |
| 2018-10-30 | GC | Futures | 1561.3 | 1562.1 | 1548.0 | 1553.0 | 224637.0 |
| 2018-10-30 | ZN | Futures | 118.483481 | 118.514608 | 118.187778 | 118.312285 | 1990798.0 |
| 2018-10-30 | A6 | Futures | 0.72695 | 0.73323 | 0.72654 | 0.73128 | 110115.0 |
| 2018-10-30 | AD | Futures | 0.77062 | 0.77244 | 0.76971 | 0.77067 | 56658.0 |
| 2018-10-30 | B | Futures | 56.87 | 57.2 | 55.63 | 56.14 | 330020.0 |
| 2018-10-30 | B6 | Futures | 1.319 | 1.3204 | 1.3084 | 1.309 | 98052.0 |
| 2018-10-30 | BR | Futures | 0.20532 | 0.20662 | 0.20342 | 0.20506 | 5516.0 |
| 2018-10-30 | BTC | Futures | 9040.0 | 9105.1 | 9018.3 | 9040.0 | 1992.0 |
| 2018-10-30 | BZ | Futures | 56.45 | 56.8 | 55.24 | 55.75 | 38361.0 |
| 2018-10-30 | C | Futures | 1551.0 | 1579.0 | 1546.0 | 1577.0 | 8694.0 |
| 2018-10-30 | CC | Futures | 1536.0 | 1556.0 | 1515.0 | 1547.0 | 16979.0 |
| 2018-10-30 | CNH | Futures | 7.0218 | 7.0261 | 7.0134 | 7.0218 | 349.0 |
| 2018-10-30 | CSC | Futures | 3.046 | 3.046 | 3.034 | 3.04 | 43.0 |
| 2018-10-30 | CT | Futures | 86.55 | 86.99 | 85.92 | 86.32 | 10681.0 |
| 2018-10-30 | DC | Futures | 25.11 | 25.14 | 25.04 | 25.11 | 372.0 |
| 2018-10-30 | DX | Futures | 91.616 | 91.963 | 91.574 | 91.95 | 16488.0 |
| 2018-10-30 | E1 | Futures | 1.18857 | 1.18916 | 1.18383 | 1.18406 | 20406.0 |
| 2018-10-30 | E6 | Futures | 1.26905 | 1.27094 | 1.26555 | 1.26577 | 189601.0 |
| 2018-10-30 | E7 | Futures | 1.2627 | 1.2647 | 1.2594 | 1.2596 | 3678.0 |
| 2018-10-30 | EBM | Futures | 208.2 | 208.72 | 206.38 | 206.64 | 24429.0 |
| 2018-10-30 | ED | Futures | 94.9987 | 95.0036 | 94.9792 | 94.9987 | 296280.0 |
| 2018-10-30 | ER | Futures | 98.381 | 98.381 | 98.377 | 98.381 | 40896.0 |
| 2018-10-30 | EW | Futures | 1879.2 | 1917.7 | 1877.1 | 1913.1 | 26658.0 |
| 2018-10-30 | FBON | Futures | 127.78 | 127.78 | 127.35 | 127.47 | 515.0 |
| 2018-10-30 | FBTP | Futures | 105.8 | 105.8 | 104.04 | 104.36 | 114587.0 |
| 2018-10-30 | FBTS | Futures | 102.696 | 102.696 | 102.003 | 102.162 | 75585.0 |
| 2018-10-30 | FCE | Futures | 4472.7 | 4493.3 | 4410.0 | 4455.2 | 102730.0 |
| 2018-10-30 | FDAX | Futures | 11920.2 | 12015.9 | 11778.2 | 11881.3 | 150709.0 |
| 2018-10-30 | FDXM | Futures | 11711.7 | 11806.7 | 11574.2 | 11675.5 | 78903.0 |
| 2018-10-30 | FESX | Futures | 2642.8 | 2657.1 | 2614.2 | 2640.3 | 1317889.0 |
| 2018-10-30 | FEU3 | Futures | 99.001 | 99.006 | 99.001 | 99.006 | 35.0 |
| 2018-10-30 | FGBL | Futures | 153.46 | 153.66 | 153.09 | 153.54 | 753883.0 |
| 2018-10-30 | FGBM | Futures | 131.16 | 131.25 | 131.04 | 131.21 | 518105.0 |
| 2018-10-30 | FGBS | Futures | 112.703 | 112.729 | 112.688 | 112.724 | 308791.0 |
| 2018-10-30 | FGBX | Futures | 178.06 | 178.82 | 177.27 | 178.48 | 67986.0 |
| 2018-10-30 | FMWO | Futures | 6610.2 | 6656.5 | 6573.1 | 6613.7 | 5293.0 |
| 2018-10-30 | FOAT | Futures | 140.58 | 140.67 | 140.31 | 140.62 | 116876.0 |
| 2018-10-30 | FTDX | Futures | 2521.9 | 2546.9 | 2491.5 | 2525.8 | 590.0 |
| 2018-10-30 | FTI | Futures | 473.11 | 478.52 | 469.8 | 474.84 | 34084.0 |
| 2018-10-30 | FTUK | Futures | 6224.6 | 6310.4 | 6216.5 | 6274.6 | 124418.0 |
| 2018-10-30 | FVSA | Futures | 377.68 | 398.61 | 376.73 | 385.29 | 36781.0 |
| 2018-10-30 | FXXP | Futures | 307.1 | 309.3 | 304.6 | 307.6 | 69522.0 |
| 2018-10-30 | G | Futures | 115.47 | 115.57 | 115.26 | 115.5 | 225771.0 |
| 2018-10-30 | GF | Futures | 320.21 | 320.261 | 316.155 | 316.415 | 2916.0 |
| 2018-10-30 | GSCI | Futures | 525.54 | 527.83 | 525.54 | 525.71 | 133.0 |
| 2018-10-30 | HE | Futures | 79.894 | 80.364 | 78.787 | 79.189 | 25114.0 |
> showing 50 of 113 rows — these rows as CSV