PREVIEW / futures_daily / 2019-03-11
file: by_date/futures_daily/2019/2019-03-11.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 |
|---|---|---|---|---|---|---|---|
| 2019-03-11 | ES | Futures | 2972.47 | 3017.94 | 2963.0 | 3014.15 | 1300372.0 |
| 2019-03-11 | NQ | Futures | 8130.03 | 8308.91 | 8101.38 | 8295.01 | 203726.0 |
| 2019-03-11 | YM | Futures | 26891.4 | 27157.4 | 26653.9 | 27117.3 | 197751.0 |
| 2019-03-11 | CL | Futures | 57.96 | 58.93 | 57.85 | 58.7 | 597156.0 |
| 2019-03-11 | GC | Futures | 1622.7 | 1624.0 | 1613.2 | 1613.9 | 196857.0 |
| 2019-03-11 | ZN | Futures | 122.015998 | 122.109235 | 121.860604 | 121.96938 | 1023534.0 |
| 2019-03-11 | A6 | Futures | 0.72611 | 0.73054 | 0.72539 | 0.72889 | 25630.0 |
| 2019-03-11 | AD | Futures | 0.75494 | 0.75661 | 0.75393 | 0.75564 | 15103.0 |
| 2019-03-11 | B | Futures | 47.7 | 48.42 | 47.6 | 48.29 | 247806.0 |
| 2019-03-11 | B6 | Futures | 1.3368 | 1.3556 | 1.3343 | 1.3537 | 53666.0 |
| 2019-03-11 | BFX | Futures | 4178.0 | 4183.9 | 4175.7 | 4183.9 | 15.0 |
| 2019-03-11 | BR | Futures | 0.20681 | 0.20729 | 0.20681 | 0.20729 | 764.0 |
| 2019-03-11 | BTC | Futures | 5972.6 | 6018.7 | 5857.3 | 5895.7 | 3539.0 |
| 2019-03-11 | BZ | Futures | 47.3 | 48.05 | 47.24 | 47.91 | 37538.0 |
| 2019-03-11 | C | Futures | 1491.0 | 1497.0 | 1476.0 | 1482.0 | 12381.0 |
| 2019-03-11 | CB | Futures | 277.527 | 277.527 | 277.527 | 277.527 | 1.0 |
| 2019-03-11 | CC | Futures | 1484.0 | 1500.0 | 1479.0 | 1486.0 | 14402.0 |
| 2019-03-11 | CNH | Futures | 6.7433 | 6.7449 | 6.7396 | 6.7405 | 298.0 |
| 2019-03-11 | CSC | Futures | 2.784 | 2.784 | 2.771 | 2.771 | 33.0 |
| 2019-03-11 | CT | Futures | 77.89 | 78.4 | 77.55 | 77.71 | 11344.0 |
| 2019-03-11 | DC | Futures | 23.56 | 23.65 | 23.56 | 23.6 | 20.0 |
| 2019-03-11 | DX | Futures | 92.765 | 92.876 | 92.593 | 92.649 | 8943.0 |
| 2019-03-11 | E1 | Futures | 1.16796 | 1.16913 | 1.16364 | 1.16446 | 11444.0 |
| 2019-03-11 | E6 | Futures | 1.24304 | 1.24573 | 1.24178 | 1.2437 | 102401.0 |
| 2019-03-11 | E7 | Futures | 1.237 | 1.2397 | 1.2357 | 1.2375 | 672.0 |
| 2019-03-11 | EBM | Futures | 194.22 | 194.22 | 191.57 | 191.84 | 20920.0 |
| 2019-03-11 | ED | Futures | 95.1062 | 95.1062 | 95.0867 | 95.0965 | 205371.0 |
| 2019-03-11 | ER | Futures | 98.406 | 98.406 | 98.401 | 98.401 | 27575.0 |
| 2019-03-11 | EW | Futures | 1980.3 | 2006.2 | 1975.1 | 2005.3 | 43278.0 |
| 2019-03-11 | FBON | Futures | 134.16 | 134.27 | 133.81 | 134.21 | 513.0 |
| 2019-03-11 | FBTP | Futures | 114.61 | 114.68 | 113.95 | 114.05 | 56882.0 |
| 2019-03-11 | FBTS | Futures | 105.931 | 105.969 | 105.712 | 105.731 | 45566.0 |
| 2019-03-11 | FCE | Futures | 4695.0 | 4712.0 | 4665.1 | 4697.2 | 195822.0 |
| 2019-03-11 | FDAX | Futures | 12077.5 | 12187.3 | 12041.7 | 12126.9 | 122091.0 |
| 2019-03-11 | FDIV | Futures | 141.64 | 142.01 | 141.64 | 142.01 | 20.0 |
| 2019-03-11 | FDXM | Futures | 12019.2 | 12118.3 | 11975.4 | 12059.4 | 1115.0 |
| 2019-03-11 | FESX | Futures | 2809.8 | 2824.7 | 2796.7 | 2814.2 | 1202244.0 |
| 2019-03-11 | FGBL | Futures | 158.87 | 158.88 | 158.59 | 158.79 | 509843.0 |
| 2019-03-11 | FGBM | Futures | 132.53 | 132.59 | 132.46 | 132.56 | 332610.0 |
| 2019-03-11 | FGBS | Futures | 112.673 | 112.688 | 112.658 | 112.678 | 239646.0 |
| 2019-03-11 | FGBX | Futures | 190.75 | 190.75 | 189.5 | 189.95 | 45355.0 |
| 2019-03-11 | FMWO | Futures | 6914.1 | 6986.4 | 6910.7 | 6966.6 | 16356.0 |
| 2019-03-11 | FOAT | Futures | 145.27 | 145.43 | 145.19 | 145.34 | 137221.0 |
| 2019-03-11 | FTDX | Futures | 2610.9 | 2629.7 | 2610.9 | 2627.7 | 532.0 |
| 2019-03-11 | FTI | Futures | 498.19 | 501.56 | 496.78 | 500.01 | 19903.0 |
| 2019-03-11 | FTUK | Futures | 6478.0 | 6507.8 | 6441.8 | 6459.2 | 260496.0 |
| 2019-03-11 | FVSA | Futures | 256.9 | 262.14 | 247.29 | 252.53 | 35063.0 |
| 2019-03-11 | FXXP | Futures | 326.0 | 327.8 | 324.9 | 327.2 | 202718.0 |
| 2019-03-11 | G | Futures | 117.18 | 117.55 | 117.15 | 117.46 | 187424.0 |
| 2019-03-11 | GF | Futures | 314.744 | 314.85 | 310.52 | 312.177 | 7307.0 |
> showing 50 of 116 rows — these rows as CSV