PREVIEW / futures_daily / 2019-03-22
file: by_date/futures_daily/2019/2019-03-22.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-22 | ES | Futures | 3088.76 | 3094.43 | 3030.16 | 3036.1 | 2254842.0 |
| 2019-03-22 | NQ | Futures | 8672.36 | 8693.1 | 8472.16 | 8490.31 | 694561.0 |
| 2019-03-22 | YM | Futures | 27425.5 | 27482.5 | 26947.3 | 26990.6 | 291875.0 |
| 2019-03-22 | CL | Futures | 61.48 | 61.68 | 59.84 | 60.62 | 738840.0 |
| 2019-03-22 | GC | Futures | 1636.6 | 1643.4 | 1633.1 | 1640.4 | 271383.0 |
| 2019-03-22 | ZN | Futures | 122.684196 | 123.585486 | 122.653117 | 123.352394 | 2521931.0 |
| 2019-03-22 | A6 | Futures | 0.73446 | 0.73477 | 0.73044 | 0.73116 | 99324.0 |
| 2019-03-22 | AD | Futures | 0.75812 | 0.75883 | 0.75418 | 0.75524 | 74378.0 |
| 2019-03-22 | B | Futures | 49.15 | 49.31 | 48.02 | 48.62 | 284522.0 |
| 2019-03-22 | B6 | Futures | 1.3493 | 1.3602 | 1.3457 | 1.3586 | 130582.0 |
| 2019-03-22 | BR | Futures | 0.20617 | 0.20617 | 0.20488 | 0.20488 | 3680.0 |
| 2019-03-22 | BTC | Futures | 6103.2 | 6141.7 | 6080.2 | 6118.6 | 1704.0 |
| 2019-03-22 | BZ | Futures | 48.72 | 48.91 | 47.64 | 48.23 | 45565.0 |
| 2019-03-22 | C | Futures | 1440.0 | 1456.0 | 1433.0 | 1448.0 | 10993.0 |
| 2019-03-22 | CB | Futures | 280.158 | 280.158 | 279.321 | 279.56 | 49.0 |
| 2019-03-22 | CC | Futures | 1438.0 | 1470.0 | 1436.0 | 1457.0 | 22388.0 |
| 2019-03-22 | CNH | Futures | 6.7183 | 6.735 | 6.7113 | 6.7342 | 483.0 |
| 2019-03-22 | CSC | Futures | 2.866 | 2.873 | 2.817 | 2.822 | 73.0 |
| 2019-03-22 | CT | Futures | 81.75 | 82.37 | 80.74 | 81.3 | 18916.0 |
| 2019-03-22 | DC | Futures | 24.06 | 24.2 | 23.77 | 23.86 | 332.0 |
| 2019-03-22 | DX | Futures | 91.864 | 92.296 | 91.725 | 92.162 | 20724.0 |
| 2019-03-22 | E1 | Futures | 1.18616 | 1.1864 | 1.17986 | 1.1829 | 29862.0 |
| 2019-03-22 | E6 | Futures | 1.25753 | 1.25917 | 1.24611 | 1.24842 | 267149.0 |
| 2019-03-22 | E7 | Futures | 1.2508 | 1.2528 | 1.24 | 1.2422 | 8398.0 |
| 2019-03-22 | EBM | Futures | 200.31 | 201.89 | 200.04 | 200.57 | 15058.0 |
| 2019-03-22 | ED | Futures | 95.116 | 95.1648 | 95.116 | 95.1404 | 566014.0 |
| 2019-03-22 | ER | Futures | 98.406 | 98.406 | 98.401 | 98.406 | 36075.0 |
| 2019-03-22 | EW | Futures | 2030.2 | 2034.5 | 1971.1 | 1971.8 | 21758.0 |
| 2019-03-22 | FBON | Futures | 134.79 | 135.4 | 134.76 | 135.28 | 644.0 |
| 2019-03-22 | FBTP | Futures | 115.07 | 115.2 | 114.28 | 115.02 | 112308.0 |
| 2019-03-22 | FBTS | Futures | 105.903 | 105.95 | 105.579 | 105.798 | 64555.0 |
| 2019-03-22 | FCE | Futures | 4797.1 | 4809.1 | 4675.4 | 4687.9 | 116524.0 |
| 2019-03-22 | FDAX | Futures | 12215.3 | 12252.7 | 11920.6 | 11974.3 | 154064.0 |
| 2019-03-22 | FDIV | Futures | 141.64 | 141.64 | 140.25 | 140.34 | 22.0 |
| 2019-03-22 | FDXM | Futures | 12111.0 | 12145.5 | 11815.7 | 11870.5 | 89849.0 |
| 2019-03-22 | FESX | Futures | 2884.1 | 2886.7 | 2809.0 | 2815.1 | 1545858.0 |
| 2019-03-22 | FGBL | Futures | 158.91 | 160.08 | 158.88 | 159.96 | 1010742.0 |
| 2019-03-22 | FGBM | Futures | 132.56 | 132.89 | 132.54 | 132.86 | 600093.0 |
| 2019-03-22 | FGBS | Futures | 112.703 | 112.739 | 112.678 | 112.734 | 456051.0 |
| 2019-03-22 | FGBX | Futures | 191.26 | 195.67 | 191.22 | 195.25 | 72214.0 |
| 2019-03-22 | FMWO | Futures | 7151.3 | 7151.3 | 7013.6 | 7024.0 | 6532.0 |
| 2019-03-22 | FOAT | Futures | 146.05 | 147.02 | 145.98 | 146.9 | 191508.0 |
| 2019-03-22 | FTDX | Futures | 2660.3 | 2670.6 | 2608.4 | 2612.9 | 603.0 |
| 2019-03-22 | FTI | Futures | 515.96 | 516.47 | 506.39 | 508.18 | 36841.0 |
| 2019-03-22 | FTUK | Futures | 6678.9 | 6678.9 | 6519.3 | 6539.0 | 113366.0 |
| 2019-03-22 | FVSA | Futures | 250.09 | 276.97 | 244.38 | 275.34 | 53210.0 |
| 2019-03-22 | FXXP | Futures | 334.6 | 335.2 | 328.6 | 329.6 | 74863.0 |
| 2019-03-22 | G | Futures | 118.34 | 119.26 | 118.3 | 119.17 | 283468.0 |
| 2019-03-22 | GF | Futures | 319.716 | 322.496 | 316.241 | 318.219 | 2540.0 |
| 2019-03-22 | GSCI | Futures | 489.71 | 491.24 | 488.81 | 491.18 | 72.0 |
> showing 50 of 116 rows — these rows as CSV