PREVIEW / futures_daily / 2019-03-25
file: by_date/futures_daily/2019/2019-03-25.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-25 | ES | Futures | 3038.53 | 3044.47 | 3013.15 | 3032.05 | 1801326.0 |
| 2019-03-25 | NQ | Futures | 8494.34 | 8515.37 | 8399.57 | 8474.75 | 596897.0 |
| 2019-03-25 | YM | Futures | 26993.8 | 27071.9 | 26786.9 | 26998.0 | 248236.0 |
| 2019-03-25 | CL | Futures | 60.56 | 60.94 | 59.73 | 60.4 | 705399.0 |
| 2019-03-25 | GC | Futures | 1641.6 | 1655.6 | 1638.2 | 1653.2 | 251981.0 |
| 2019-03-25 | ZN | Futures | 123.383473 | 123.989512 | 123.196999 | 123.647644 | 2186358.0 |
| 2019-03-25 | A6 | Futures | 0.73106 | 0.73477 | 0.72951 | 0.73374 | 72534.0 |
| 2019-03-25 | AD | Futures | 0.75463 | 0.75615 | 0.75352 | 0.75539 | 60521.0 |
| 2019-03-25 | B | Futures | 48.62 | 49.0 | 48.11 | 48.66 | 234244.0 |
| 2019-03-25 | B6 | Futures | 1.3594 | 1.3627 | 1.3537 | 1.3559 | 109139.0 |
| 2019-03-25 | BR | Futures | 0.20288 | 0.20641 | 0.20208 | 0.20641 | 952.0 |
| 2019-03-25 | BTC | Futures | 6118.6 | 6134.1 | 5940.9 | 6010.5 | 425.0 |
| 2019-03-25 | BZ | Futures | 48.23 | 48.86 | 47.99 | 48.53 | 28186.0 |
| 2019-03-25 | C | Futures | 1450.0 | 1499.0 | 1440.0 | 1492.0 | 10734.0 |
| 2019-03-25 | CB | Futures | 279.8 | 281.115 | 279.8 | 281.115 | 7.0 |
| 2019-03-25 | CC | Futures | 1457.0 | 1514.0 | 1448.0 | 1496.0 | 32452.0 |
| 2019-03-25 | CNH | Futures | 6.7342 | 6.7408 | 6.7241 | 6.727 | 312.0 |
| 2019-03-25 | CSC | Futures | 2.852 | 2.856 | 2.831 | 2.836 | 77.0 |
| 2019-03-25 | CT | Futures | 81.43 | 82.57 | 80.87 | 82.52 | 18749.0 |
| 2019-03-25 | DC | Futures | 23.79 | 24.06 | 23.79 | 23.85 | 303.0 |
| 2019-03-25 | DX | Futures | 92.157 | 92.2 | 91.917 | 92.083 | 11685.0 |
| 2019-03-25 | E1 | Futures | 1.18406 | 1.18686 | 1.1822 | 1.18488 | 21015.0 |
| 2019-03-25 | E6 | Futures | 1.24814 | 1.25248 | 1.2477 | 1.25028 | 147476.0 |
| 2019-03-25 | E7 | Futures | 1.2423 | 1.2463 | 1.2416 | 1.2441 | 4298.0 |
| 2019-03-25 | EBM | Futures | 200.31 | 200.84 | 199.25 | 200.57 | 13989.0 |
| 2019-03-25 | ED | Futures | 95.1404 | 95.1892 | 95.1355 | 95.1746 | 602432.0 |
| 2019-03-25 | ER | Futures | 98.406 | 98.406 | 98.401 | 98.406 | 25541.0 |
| 2019-03-25 | EW | Futures | 1974.9 | 1987.0 | 1958.8 | 1976.5 | 17903.0 |
| 2019-03-25 | FBON | Futures | 135.07 | 135.18 | 134.85 | 134.93 | 318.0 |
| 2019-03-25 | FBTP | Futures | 114.93 | 115.07 | 114.43 | 114.68 | 67944.0 |
| 2019-03-25 | FBTS | Futures | 105.741 | 105.77 | 105.56 | 105.674 | 49504.0 |
| 2019-03-25 | FCE | Futures | 4666.9 | 4694.6 | 4655.4 | 4679.9 | 82656.0 |
| 2019-03-25 | FDAX | Futures | 11932.7 | 12010.1 | 11879.0 | 11969.5 | 113320.0 |
| 2019-03-25 | FDIV | Futures | 139.78 | 139.78 | 139.64 | 139.64 | 20.0 |
| 2019-03-25 | FDXM | Futures | 11817.8 | 11905.5 | 11777.1 | 11865.8 | 59273.0 |
| 2019-03-25 | FESX | Futures | 2812.5 | 2824.7 | 2797.6 | 2815.1 | 983114.0 |
| 2019-03-25 | FGBL | Futures | 159.81 | 160.18 | 159.58 | 159.89 | 623210.0 |
| 2019-03-25 | FGBM | Futures | 132.8 | 132.89 | 132.74 | 132.82 | 446773.0 |
| 2019-03-25 | FGBS | Futures | 112.724 | 112.734 | 112.708 | 112.718 | 280999.0 |
| 2019-03-25 | FGBX | Futures | 194.92 | 196.39 | 193.75 | 195.29 | 44933.0 |
| 2019-03-25 | FMWO | Futures | 6969.7 | 7019.4 | 6969.7 | 7010.2 | 1996.0 |
| 2019-03-25 | FOAT | Futures | 146.78 | 146.94 | 146.53 | 146.71 | 124962.0 |
| 2019-03-25 | FTDX | Futures | 2577.8 | 2601.0 | 2577.8 | 2591.2 | 218.0 |
| 2019-03-25 | FTI | Futures | 505.08 | 507.66 | 503.3 | 505.62 | 26616.0 |
| 2019-03-25 | FTUK | Futures | 6494.5 | 6539.9 | 6482.1 | 6518.4 | 90928.0 |
| 2019-03-25 | FVSA | Futures | 276.97 | 280.23 | 266.38 | 272.08 | 38639.0 |
| 2019-03-25 | FXXP | Futures | 327.4 | 329.5 | 327.2 | 328.7 | 51252.0 |
| 2019-03-25 | G | Futures | 119.04 | 119.65 | 118.78 | 119.43 | 210151.0 |
| 2019-03-25 | GF | Futures | 316.08 | 318.272 | 312.231 | 312.658 | 3354.0 |
| 2019-03-25 | GSCI | Futures | 491.41 | 492.32 | 491.41 | 492.32 | 6.0 |
> showing 50 of 115 rows — these rows as CSV