PREVIEW / futures_daily / 2018-12-28
file: by_date/futures_daily/2018/2018-12-28.parquet size: 10 KB rows: 116
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-28 | ES | Futures | 2697.47 | 2731.58 | 2677.17 | 2691.52 | 2011392.0 |
| 2018-12-28 | NQ | Futures | 7304.27 | 7412.52 | 7228.72 | 7286.03 | 644735.0 |
| 2018-12-28 | YM | Futures | 24384.2 | 24652.1 | 24214.4 | 24296.6 | 317883.0 |
| 2018-12-28 | CL | Futures | 47.66 | 48.48 | 46.59 | 47.54 | 564385.0 |
| 2018-12-28 | GC | Futures | 1610.3 | 1618.7 | 1608.4 | 1616.6 | 162727.0 |
| 2018-12-28 | ZN | Futures | 120.895716 | 121.315871 | 120.786787 | 121.129135 | 1312658.0 |
| 2018-12-28 | A6 | Futures | 0.72498 | 0.7292 | 0.72487 | 0.72673 | 62929.0 |
| 2018-12-28 | AD | Futures | 0.74456 | 0.74603 | 0.74238 | 0.7435 | 68600.0 |
| 2018-12-28 | B | Futures | 38.96 | 39.28 | 37.54 | 38.41 | 239069.0 |
| 2018-12-28 | B6 | Futures | 1.303 | 1.3097 | 1.3023 | 1.3081 | 57575.0 |
| 2018-12-28 | BR | Futures | 0.20408 | 0.20519 | 0.20408 | 0.20519 | 18.0 |
| 2018-12-28 | BTC | Futures | 5189.9 | 5825.9 | 5168.0 | 5657.7 | 4180.0 |
| 2018-12-28 | BZ | Futures | 38.43 | 38.92 | 37.23 | 38.09 | 31833.0 |
| 2018-12-28 | C | Futures | 1537.0 | 1545.0 | 1499.0 | 1545.0 | 10657.0 |
| 2018-12-28 | CB | Futures | 272.319 | 272.319 | 272.319 | 272.319 | 2.0 |
| 2018-12-28 | CC | Futures | 1632.0 | 1662.0 | 1614.0 | 1659.0 | 15364.0 |
| 2018-12-28 | CNH | Futures | 6.8916 | 6.9025 | 6.8804 | 6.8969 | 433.0 |
| 2018-12-28 | CSC | Futures | 2.793 | 2.831 | 2.793 | 2.821 | 123.0 |
| 2018-12-28 | CT | Futures | 78.49 | 79.38 | 78.49 | 78.64 | 11409.0 |
| 2018-12-28 | DC | Futures | 23.92 | 24.13 | 23.86 | 24.07 | 250.0 |
| 2018-12-28 | DX | Futures | 91.574 | 91.603 | 91.307 | 91.522 | 14168.0 |
| 2018-12-28 | E1 | Futures | 1.199 | 1.20958 | 1.19865 | 1.20135 | 29770.0 |
| 2018-12-28 | E6 | Futures | 1.27138 | 1.27591 | 1.27116 | 1.27237 | 141218.0 |
| 2018-12-28 | E7 | Futures | 1.2652 | 1.2696 | 1.265 | 1.2662 | 3321.0 |
| 2018-12-28 | EBM | Futures | 209.23 | 210.0 | 208.71 | 209.23 | 6074.0 |
| 2018-12-28 | ED | Futures | 94.9988 | 95.0135 | 94.9842 | 94.9988 | 150310.0 |
| 2018-12-28 | ER | Futures | 98.396 | 98.401 | 98.396 | 98.396 | 23232.0 |
| 2018-12-28 | EW | Futures | 1754.3 | 1776.0 | 1741.1 | 1752.5 | 20339.0 |
| 2018-12-28 | FBON | Futures | 129.97 | 130.05 | 129.62 | 129.83 | 785.0 |
| 2018-12-28 | FBTP | Futures | 111.74 | 112.15 | 111.46 | 111.82 | 53000.0 |
| 2018-12-28 | FBTS | Futures | 104.632 | 104.849 | 104.622 | 104.774 | 29205.0 |
| 2018-12-28 | FCE | Futures | 4115.2 | 4172.0 | 4102.3 | 4152.1 | 84052.0 |
| 2018-12-28 | FDAX | Futures | 11004.5 | 11150.6 | 10936.8 | 11098.6 | 83059.0 |
| 2018-12-28 | FDXM | Futures | 10963.1 | 11122.4 | 10910.6 | 11071.6 | 49298.0 |
| 2018-12-28 | FESX | Futures | 2529.5 | 2556.0 | 2511.6 | 2541.5 | 1042504.0 |
| 2018-12-28 | FEU3 | Futures | 98.996 | 99.006 | 98.996 | 98.996 | 464.0 |
| 2018-12-28 | FGBL | Futures | 155.59 | 155.7 | 155.38 | 155.49 | 335361.0 |
| 2018-12-28 | FGBM | Futures | 131.89 | 131.99 | 131.84 | 131.91 | 189327.0 |
| 2018-12-28 | FGBS | Futures | 112.744 | 112.764 | 112.723 | 112.734 | 247458.0 |
| 2018-12-28 | FGBX | Futures | 183.84 | 183.88 | 182.97 | 183.23 | 22099.0 |
| 2018-12-28 | FMWO | Futures | 6275.5 | 6351.3 | 6275.5 | 6286.0 | 7637.0 |
| 2018-12-28 | FOAT | Futures | 141.28 | 141.46 | 141.21 | 141.26 | 45452.0 |
| 2018-12-28 | FTDX | Futures | 2395.2 | 2446.9 | 2395.2 | 2429.5 | 174.0 |
| 2018-12-28 | FTI | Futures | 449.7 | 454.66 | 447.03 | 452.92 | 27152.0 |
| 2018-12-28 | FTUK | Futures | 6005.3 | 6098.2 | 5979.3 | 6072.2 | 124794.0 |
| 2018-12-28 | FVSA | Futures | 489.52 | 493.59 | 468.2 | 486.48 | 26450.0 |
| 2018-12-28 | FXXP | Futures | 290.0 | 294.6 | 289.1 | 293.4 | 82234.0 |
| 2018-12-28 | G | Futures | 116.66 | 117.07 | 116.48 | 116.9 | 97033.0 |
| 2018-12-28 | GF | Futures | 320.361 | 322.298 | 320.307 | 320.899 | 3016.0 |
| 2018-12-28 | GSCI | Futures | 426.88 | 428.59 | 425.45 | 428.13 | 27.0 |
> showing 50 of 116 rows — these rows as CSV