PREVIEW / futures_daily / 2018-12-13
file: by_date/futures_daily/2018/2018-12-13.parquet size: 10 KB rows: 114
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-12-13 | ES | Futures | 2877.21 | 2896.73 | 2860.13 | 2869.07 | 2043406.0 |
| 2018-12-13 | NQ | Futures | 7862.37 | 7943.09 | 7808.94 | 7842.62 | 626806.0 |
| 2018-12-13 | YM | Futures | 25931.5 | 26126.7 | 25841.9 | 25934.7 | 32589.0 |
| 2018-12-13 | CL | Futures | 54.17 | 56.36 | 53.27 | 55.63 | 733627.0 |
| 2018-12-13 | GC | Futures | 1575.9 | 1577.1 | 1567.9 | 1571.7 | 158850.0 |
| 2018-12-13 | ZN | Futures | 119.713057 | 119.86867 | 119.650812 | 119.74418 | 1384310.0 |
| 2018-12-13 | A6 | Futures | 0.74424 | 0.74733 | 0.74362 | 0.74527 | 68409.0 |
| 2018-12-13 | AD | Futures | 0.75959 | 0.76061 | 0.75797 | 0.75959 | 73705.0 |
| 2018-12-13 | B | Futures | 44.27 | 45.54 | 43.56 | 45.12 | 252397.0 |
| 2018-12-13 | B6 | Futures | 1.304 | 1.3088 | 1.301 | 1.3061 | 79536.0 |
| 2018-12-13 | BR | Futures | 0.2044 | 0.2044 | 0.2044 | 0.2044 | 1.0 |
| 2018-12-13 | BTC | Futures | 5180.3 | 5218.4 | 4867.5 | 4905.6 | 3796.0 |
| 2018-12-13 | BZ | Futures | 43.71 | 44.95 | 43.01 | 44.54 | 29600.0 |
| 2018-12-13 | C | Futures | 1410.0 | 1471.0 | 1410.0 | 1466.0 | 9389.0 |
| 2018-12-13 | CB | Futures | 266.67 | 267.277 | 264.756 | 266.609 | 39.0 |
| 2018-12-13 | CC | Futures | 1494.0 | 1554.0 | 1487.0 | 1550.0 | 17342.0 |
| 2018-12-13 | CNH | Futures | 6.8931 | 6.9083 | 6.8791 | 6.9008 | 359.0 |
| 2018-12-13 | CSC | Futures | 2.86 | 2.87 | 2.847 | 2.855 | 64.0 |
| 2018-12-13 | CT | Futures | 87.08 | 87.11 | 86.0 | 86.5 | 13158.0 |
| 2018-12-13 | DC | Futures | 24.08 | 24.24 | 24.0 | 24.2 | 211.0 |
| 2018-12-13 | DX | Futures | 92.084 | 92.294 | 91.884 | 92.071 | 22378.0 |
| 2018-12-13 | E1 | Futures | 1.19406 | 1.19712 | 1.19206 | 1.19441 | 38627.0 |
| 2018-12-13 | E6 | Futures | 1.2668 | 1.26939 | 1.26221 | 1.26608 | 230044.0 |
| 2018-12-13 | E7 | Futures | 1.2608 | 1.2629 | 1.2562 | 1.26 | 2774.0 |
| 2018-12-13 | EBM | Futures | 212.83 | 213.85 | 212.31 | 213.34 | 34123.0 |
| 2018-12-13 | ED | Futures | 94.9158 | 94.9256 | 94.9109 | 94.9109 | 193639.0 |
| 2018-12-13 | ER | Futures | 98.391 | 98.391 | 98.381 | 98.386 | 105365.0 |
| 2018-12-13 | EW | Futures | 1901.6 | 1907.8 | 1869.7 | 1875.3 | 14324.0 |
| 2018-12-13 | FBON | Futures | 129.31 | 129.77 | 129.31 | 129.52 | 633.0 |
| 2018-12-13 | FBTP | Futures | 109.7 | 110.35 | 109.35 | 109.66 | 108679.0 |
| 2018-12-13 | FBTS | Futures | 104.471 | 104.518 | 104.234 | 104.282 | 81810.0 |
| 2018-12-13 | FCE | Futures | 4359.4 | 4368.7 | 4325.6 | 4339.0 | 27189.0 |
| 2018-12-13 | FDAX | Futures | 11498.0 | 11551.1 | 11443.3 | 11474.8 | 109053.0 |
| 2018-12-13 | FDIV | Futures | 133.11 | 133.16 | 133.11 | 133.16 | 95.0 |
| 2018-12-13 | FDXM | Futures | 11450.5 | 11506.1 | 11407.5 | 11431.6 | 347.0 |
| 2018-12-13 | FESX | Futures | 2638.9 | 2657.7 | 2633.8 | 2642.3 | 738801.0 |
| 2018-12-13 | FEU3 | Futures | 98.981 | 98.986 | 98.981 | 98.986 | 150.0 |
| 2018-12-13 | FGBL | Futures | 154.76 | 155.11 | 154.51 | 154.86 | 806986.0 |
| 2018-12-13 | FGBM | Futures | 131.44 | 131.64 | 131.3 | 131.57 | 531125.0 |
| 2018-12-13 | FGBS | Futures | 112.628 | 112.663 | 112.562 | 112.653 | 412766.0 |
| 2018-12-13 | FGBX | Futures | 183.45 | 184.22 | 182.05 | 182.66 | 74018.0 |
| 2018-12-13 | FMWO | Futures | 6617.2 | 6617.2 | 6554.6 | 6572.0 | 4152.0 |
| 2018-12-13 | FOAT | Futures | 140.94 | 141.37 | 140.8 | 141.08 | 165733.0 |
| 2018-12-13 | FTDX | Futures | 2533.9 | 2533.9 | 2524.9 | 2524.9 | 1.0 |
| 2018-12-13 | FTI | Futures | 478.05 | 478.05 | 473.51 | 475.47 | 4374.0 |
| 2018-12-13 | FTUK | Futures | 6213.9 | 6232.1 | 6177.0 | 6204.3 | 85926.0 |
| 2018-12-13 | FVSA | Futures | 398.12 | 400.15 | 389.99 | 399.13 | 23396.0 |
| 2018-12-13 | FXXP | Futures | 306.1 | 306.6 | 304.2 | 304.9 | 33332.0 |
| 2018-12-13 | G | Futures | 116.79 | 117.27 | 116.59 | 116.93 | 238506.0 |
| 2018-12-13 | GF | Futures | 317.832 | 320.038 | 317.832 | 318.531 | 5598.0 |
> showing 50 of 114 rows — these rows as CSV