PREVIEW / futures_daily / 2019-03-26
file: by_date/futures_daily/2019/2019-03-26.parquet size: 10 KB rows: 115
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-26 | ES | Futures | 3033.67 | 3062.3 | 3030.97 | 3049.33 | 1461068.0 |
| 2019-03-26 | NQ | Futures | 8483.68 | 8581.04 | 8457.76 | 8499.53 | 557412.0 |
| 2019-03-26 | YM | Futures | 27018.0 | 27256.6 | 26981.1 | 27102.5 | 199333.0 |
| 2019-03-26 | CL | Futures | 60.71 | 62.0 | 60.62 | 61.55 | 685988.0 |
| 2019-03-26 | GC | Futures | 1653.2 | 1654.5 | 1641.0 | 1644.6 | 122601.0 |
| 2019-03-26 | ZN | Futures | 123.803039 | 123.834118 | 123.383473 | 123.725341 | 1960900.0 |
| 2019-03-26 | A6 | Futures | 0.73425 | 0.73786 | 0.73384 | 0.73745 | 74852.0 |
| 2019-03-26 | AD | Futures | 0.75564 | 0.75767 | 0.75539 | 0.75711 | 58666.0 |
| 2019-03-26 | B | Futures | 48.71 | 49.36 | 48.69 | 49.11 | 258666.0 |
| 2019-03-26 | B6 | Futures | 1.3571 | 1.3641 | 1.3534 | 1.3598 | 104632.0 |
| 2019-03-26 | BR | Futures | 0.20641 | 0.20689 | 0.20589 | 0.20597 | 19.0 |
| 2019-03-26 | BTC | Futures | 5995.0 | 6041.4 | 5979.6 | 6033.6 | 564.0 |
| 2019-03-26 | BZ | Futures | 48.6 | 49.21 | 48.57 | 48.98 | 31128.0 |
| 2019-03-26 | C | Futures | 1493.0 | 1511.0 | 1485.0 | 1501.0 | 7146.0 |
| 2019-03-26 | CB | Futures | 281.654 | 281.654 | 281.115 | 281.504 | 72.0 |
| 2019-03-26 | CC | Futures | 1500.0 | 1531.0 | 1491.0 | 1510.0 | 25417.0 |
| 2019-03-26 | CNH | Futures | 6.727 | 6.733 | 6.7187 | 6.7317 | 250.0 |
| 2019-03-26 | CSC | Futures | 2.843 | 2.852 | 2.831 | 2.843 | 141.0 |
| 2019-03-26 | CT | Futures | 82.42 | 82.79 | 82.19 | 82.69 | 14679.0 |
| 2019-03-26 | DC | Futures | 23.96 | 24.03 | 23.83 | 23.89 | 287.0 |
| 2019-03-26 | DX | Futures | 92.008 | 92.339 | 91.96 | 92.233 | 10859.0 |
| 2019-03-26 | E1 | Futures | 1.18558 | 1.18581 | 1.18173 | 1.18371 | 25105.0 |
| 2019-03-26 | E6 | Futures | 1.25039 | 1.25187 | 1.24485 | 1.24655 | 162936.0 |
| 2019-03-26 | E7 | Futures | 1.2442 | 1.2456 | 1.2387 | 1.2404 | 4583.0 |
| 2019-03-26 | EBM | Futures | 201.1 | 202.16 | 198.45 | 198.98 | 23041.0 |
| 2019-03-26 | ED | Futures | 95.1746 | 95.1795 | 95.1502 | 95.1697 | 434669.0 |
| 2019-03-26 | ER | Futures | 98.401 | 98.406 | 98.401 | 98.401 | 40934.0 |
| 2019-03-26 | EW | Futures | 1980.5 | 2005.3 | 1978.6 | 1996.2 | 11817.0 |
| 2019-03-26 | FBON | Futures | 134.85 | 135.07 | 134.69 | 135.01 | 374.0 |
| 2019-03-26 | FBTP | Futures | 114.62 | 114.95 | 114.46 | 114.89 | 71882.0 |
| 2019-03-26 | FBTS | Futures | 105.655 | 105.827 | 105.579 | 105.789 | 59902.0 |
| 2019-03-26 | FCE | Futures | 4691.5 | 4729.3 | 4676.7 | 4721.3 | 67044.0 |
| 2019-03-26 | FDAX | Futures | 11986.9 | 12068.0 | 11912.2 | 12043.8 | 109246.0 |
| 2019-03-26 | FDIV | Futures | 139.41 | 139.6 | 139.41 | 139.6 | 55.0 |
| 2019-03-26 | FDXM | Futures | 11878.3 | 11962.9 | 11809.5 | 11939.4 | 51141.0 |
| 2019-03-26 | FESX | Futures | 2815.1 | 2836.0 | 2807.2 | 2830.8 | 892722.0 |
| 2019-03-26 | FGBL | Futures | 160.01 | 160.05 | 159.68 | 159.81 | 601133.0 |
| 2019-03-26 | FGBM | Futures | 132.84 | 132.86 | 132.74 | 132.77 | 405260.0 |
| 2019-03-26 | FGBS | Futures | 112.734 | 112.734 | 112.703 | 112.713 | 241962.0 |
| 2019-03-26 | FGBX | Futures | 195.67 | 196.25 | 194.59 | 195.57 | 44528.0 |
| 2019-03-26 | FMWO | Futures | 7039.1 | 7072.6 | 7020.6 | 7047.2 | 3712.0 |
| 2019-03-26 | FOAT | Futures | 146.64 | 146.79 | 146.5 | 146.68 | 117327.0 |
| 2019-03-26 | FTDX | Futures | 2595.6 | 2693.8 | 2590.2 | 2683.0 | 386.0 |
| 2019-03-26 | FTI | Futures | 507.84 | 511.08 | 505.59 | 509.57 | 20509.0 |
| 2019-03-26 | FTUK | Futures | 6532.1 | 6552.3 | 6504.2 | 6536.7 | 76354.0 |
| 2019-03-26 | FVSA | Futures | 269.64 | 271.27 | 255.79 | 256.6 | 27717.0 |
| 2019-03-26 | FXXP | Futures | 329.2 | 331.7 | 328.3 | 331.1 | 48122.0 |
| 2019-03-26 | G | Futures | 119.32 | 119.4 | 119.05 | 119.2 | 210381.0 |
| 2019-03-26 | GF | Futures | 313.193 | 313.888 | 311.856 | 312.712 | 2818.0 |
| 2019-03-26 | GSCI | Futures | 495.37 | 496.0 | 494.35 | 494.47 | 21.0 |
> showing 50 of 115 rows — these rows as CSV