PREVIEW / futures_daily / 2019-03-13
file: by_date/futures_daily/2019/2019-03-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 |
|---|---|---|---|---|---|---|---|
| 2019-03-13 | ES | Futures | 3023.08 | 3054.48 | 3013.07 | 3047.17 | 583009.0 |
| 2019-03-13 | NQ | Futures | 8346.53 | 8446.39 | 8317.01 | 8414.26 | 127111.0 |
| 2019-03-13 | YM | Futures | 27033.9 | 27247.1 | 26911.4 | 27200.6 | 203484.0 |
| 2019-03-13 | CL | Futures | 59.01 | 60.45 | 58.93 | 60.22 | 610616.0 |
| 2019-03-13 | GC | Futures | 1627.2 | 1639.5 | 1625.7 | 1636.6 | 214238.0 |
| 2019-03-13 | ZN | Futures | 122.202472 | 122.233551 | 122.015998 | 122.186933 | 1098251.0 |
| 2019-03-13 | A6 | Futures | 0.73096 | 0.73271 | 0.72766 | 0.73178 | 86293.0 |
| 2019-03-13 | AD | Futures | 0.75868 | 0.76237 | 0.75782 | 0.76161 | 68993.0 |
| 2019-03-13 | B | Futures | 48.53 | 49.15 | 48.38 | 49.0 | 243201.0 |
| 2019-03-13 | B6 | Futures | 1.3456 | 1.3768 | 1.3444 | 1.3605 | 81662.0 |
| 2019-03-13 | BR | Futures | 0.20877 | 0.20889 | 0.20877 | 0.20889 | 3102.0 |
| 2019-03-13 | BTC | Futures | 5926.5 | 5949.5 | 5872.6 | 5911.1 | 2105.0 |
| 2019-03-13 | BZ | Futures | 48.12 | 48.75 | 48.0 | 48.61 | 36739.0 |
| 2019-03-13 | C | Futures | 1497.0 | 1507.0 | 1481.0 | 1492.0 | 14964.0 |
| 2019-03-13 | CB | Futures | 278.514 | 278.514 | 278.125 | 278.125 | 5.0 |
| 2019-03-13 | CC | Futures | 1494.0 | 1513.0 | 1484.0 | 1496.0 | 16152.0 |
| 2019-03-13 | CNH | Futures | 6.7165 | 6.7285 | 6.7092 | 6.7158 | 382.0 |
| 2019-03-13 | CSC | Futures | 2.787 | 2.805 | 2.787 | 2.792 | 10.0 |
| 2019-03-13 | CT | Futures | 79.56 | 80.67 | 79.33 | 80.39 | 22677.0 |
| 2019-03-13 | DC | Futures | 23.82 | 23.88 | 23.74 | 23.76 | 57.0 |
| 2019-03-13 | DX | Futures | 92.459 | 92.459 | 91.836 | 92.0 | 21020.0 |
| 2019-03-13 | E1 | Futures | 1.16831 | 1.17414 | 1.16738 | 1.17344 | 32867.0 |
| 2019-03-13 | E6 | Futures | 1.24886 | 1.2544 | 1.24759 | 1.25341 | 224283.0 |
| 2019-03-13 | E7 | Futures | 1.2428 | 1.2481 | 1.2414 | 1.2472 | 4874.0 |
| 2019-03-13 | EBM | Futures | 194.48 | 197.4 | 193.96 | 196.34 | 29200.0 |
| 2019-03-13 | ED | Futures | 95.1062 | 95.1111 | 95.0965 | 95.1062 | 249809.0 |
| 2019-03-13 | ER | Futures | 98.406 | 98.406 | 98.401 | 98.401 | 31065.0 |
| 2019-03-13 | EW | Futures | 2007.6 | 2025.2 | 2000.5 | 2016.2 | 16510.0 |
| 2019-03-13 | FBON | Futures | 133.99 | 133.99 | 133.63 | 133.74 | 487.0 |
| 2019-03-13 | FBTP | Futures | 114.23 | 114.28 | 113.75 | 113.94 | 76284.0 |
| 2019-03-13 | FBTS | Futures | 105.731 | 105.75 | 105.636 | 105.703 | 54823.0 |
| 2019-03-13 | FCE | Futures | 4671.0 | 4722.2 | 4662.5 | 4712.0 | 112397.0 |
| 2019-03-13 | FDAX | Futures | 12104.8 | 12202.0 | 12055.9 | 12165.7 | 121561.0 |
| 2019-03-13 | FDXM | Futures | 12029.7 | 12135.0 | 11990.0 | 12100.1 | 1960.0 |
| 2019-03-13 | FESX | Futures | 2804.6 | 2839.5 | 2798.5 | 2830.8 | 1398613.0 |
| 2019-03-13 | FGBL | Futures | 158.82 | 158.94 | 158.46 | 158.74 | 459155.0 |
| 2019-03-13 | FGBM | Futures | 132.6 | 132.61 | 132.47 | 132.54 | 282067.0 |
| 2019-03-13 | FGBS | Futures | 112.698 | 112.703 | 112.678 | 112.688 | 226548.0 |
| 2019-03-13 | FGBX | Futures | 190.2 | 190.28 | 189.05 | 189.6 | 37606.0 |
| 2019-03-13 | FMWO | Futures | 6999.2 | 7066.8 | 6992.2 | 7051.7 | 10977.0 |
| 2019-03-13 | FOAT | Futures | 145.22 | 145.41 | 145.17 | 145.32 | 112255.0 |
| 2019-03-13 | FTDX | Futures | 2603.0 | 2617.8 | 2602.5 | 2617.8 | 1049.0 |
| 2019-03-13 | FTI | Futures | 499.08 | 505.27 | 498.51 | 503.78 | 20883.0 |
| 2019-03-13 | FTUK | Futures | 6489.0 | 6509.2 | 6455.1 | 6477.6 | 184519.0 |
| 2019-03-13 | FVSA | Futures | 251.71 | 252.53 | 244.38 | 247.64 | 17790.0 |
| 2019-03-13 | FXXP | Futures | 326.1 | 330.2 | 326.1 | 329.1 | 105528.0 |
| 2019-03-13 | G | Futures | 117.42 | 117.42 | 117.06 | 117.09 | 135012.0 |
| 2019-03-13 | GF | Futures | 308.809 | 311.322 | 307.954 | 308.221 | 6371.0 |
| 2019-03-13 | GSCI | Futures | 485.86 | 488.92 | 485.86 | 488.81 | 2655.0 |
| 2019-03-13 | HE | Futures | 72.498 | 74.731 | 71.423 | 71.791 | 41440.0 |
> showing 50 of 114 rows — these rows as CSV