PREVIEW / futures_daily / 2019-04-12
file: by_date/futures_daily/2019/2019-04-12.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-04-12 | ES | Futures | 3123.87 | 3148.44 | 3122.52 | 3146.01 | 1227893.0 |
| 2019-04-12 | NQ | Futures | 8776.34 | 8831.65 | 8769.43 | 8816.96 | 346210.0 |
| 2019-04-12 | YM | Futures | 27606.0 | 27910.0 | 27593.3 | 27875.1 | 173271.0 |
| 2019-04-12 | CL | Futures | 65.42 | 66.38 | 65.37 | 65.6 | 625588.0 |
| 2019-04-12 | GC | Futures | 1612.8 | 1616.9 | 1609.5 | 1612.0 | 192493.0 |
| 2019-04-12 | ZN | Futures | 122.932828 | 122.994986 | 122.357867 | 122.420025 | 1629932.0 |
| 2019-04-12 | A6 | Futures | 0.73559 | 0.7425 | 0.73446 | 0.74044 | 117873.0 |
| 2019-04-12 | AD | Futures | 0.75686 | 0.7606 | 0.7564 | 0.75933 | 65549.0 |
| 2019-04-12 | B | Futures | 51.68 | 52.35 | 51.64 | 52.12 | 237220.0 |
| 2019-04-12 | B6 | Futures | 1.3415 | 1.3496 | 1.3411 | 1.3438 | 87114.0 |
| 2019-04-12 | BR | Futures | 0.20625 | 0.20677 | 0.20557 | 0.20557 | 8.0 |
| 2019-04-12 | BTC | Futures | 7771.9 | 7918.7 | 7571.0 | 7826.0 | 7931.0 |
| 2019-04-12 | BZ | Futures | 51.52 | 52.2 | 51.5 | 51.97 | 32729.0 |
| 2019-04-12 | C | Futures | 1606.0 | 1636.0 | 1602.0 | 1633.0 | 5468.0 |
| 2019-04-12 | CB | Futures | 275.403 | 275.732 | 275.194 | 275.732 | 22.0 |
| 2019-04-12 | CC | Futures | 1601.0 | 1627.0 | 1600.0 | 1621.0 | 22491.0 |
| 2019-04-12 | CNH | Futures | 6.7393 | 6.7407 | 6.7155 | 6.7178 | 356.0 |
| 2019-04-12 | CSC | Futures | 2.87 | 2.891 | 2.87 | 2.88 | 58.0 |
| 2019-04-12 | CT | Futures | 81.73 | 83.5 | 81.62 | 82.93 | 21717.0 |
| 2019-04-12 | DC | Futures | 24.17 | 24.31 | 24.14 | 24.25 | 171.0 |
| 2019-04-12 | DX | Futures | 92.784 | 92.799 | 92.368 | 92.591 | 16005.0 |
| 2019-04-12 | E1 | Futures | 1.17041 | 1.17438 | 1.16994 | 1.17064 | 22588.0 |
| 2019-04-12 | E6 | Futures | 1.24194 | 1.24957 | 1.24194 | 1.24644 | 212879.0 |
| 2019-04-12 | E7 | Futures | 1.2359 | 1.2433 | 1.2359 | 1.2402 | 4263.0 |
| 2019-04-12 | EBM | Futures | 200.31 | 200.84 | 199.78 | 200.31 | 14421.0 |
| 2019-04-12 | ED | Futures | 95.1404 | 95.1453 | 95.1257 | 95.1355 | 213934.0 |
| 2019-04-12 | ER | Futures | 98.416 | 98.421 | 98.411 | 98.411 | 106146.0 |
| 2019-04-12 | EW | Futures | 2070.9 | 2093.5 | 2070.9 | 2089.8 | 10637.0 |
| 2019-04-12 | FBON | Futures | 136.06 | 136.29 | 135.47 | 135.56 | 341.0 |
| 2019-04-12 | FBTP | Futures | 116.01 | 116.26 | 115.71 | 115.8 | 80828.0 |
| 2019-04-12 | FBTS | Futures | 105.941 | 106.046 | 105.893 | 105.931 | 55556.0 |
| 2019-04-12 | FCE | Futures | 4884.4 | 4905.6 | 4870.0 | 4894.3 | 25419.0 |
| 2019-04-12 | FDAX | Futures | 12577.4 | 12693.8 | 12543.2 | 12658.0 | 98849.0 |
| 2019-04-12 | FDIV | Futures | 148.46 | 148.46 | 148.23 | 148.23 | 11.0 |
| 2019-04-12 | FDXM | Futures | 12485.7 | 12582.7 | 12434.5 | 12548.3 | 40037.0 |
| 2019-04-12 | FESX | Futures | 2940.9 | 2955.8 | 2928.7 | 2949.7 | 986347.0 |
| 2019-04-12 | FGBL | Futures | 159.87 | 160.01 | 158.82 | 158.88 | 951475.0 |
| 2019-04-12 | FGBM | Futures | 133.03 | 133.07 | 132.67 | 132.69 | 530935.0 |
| 2019-04-12 | FGBS | Futures | 112.749 | 112.759 | 112.708 | 112.708 | 298263.0 |
| 2019-04-12 | FGBX | Futures | 193.81 | 194.33 | 190.64 | 190.85 | 52550.0 |
| 2019-04-12 | FMWO | Futures | 7209.2 | 7263.5 | 7209.2 | 7246.2 | 3397.0 |
| 2019-04-12 | FOAT | Futures | 147.04 | 147.23 | 146.11 | 146.14 | 145960.0 |
| 2019-04-12 | FTDX | Futures | 2702.7 | 2725.9 | 2699.7 | 2722.9 | 60.0 |
| 2019-04-12 | FTI | Futures | 525.42 | 526.74 | 524.18 | 526.24 | 7210.0 |
| 2019-04-12 | FTUK | Futures | 6765.5 | 6785.2 | 6747.6 | 6759.1 | 70557.0 |
| 2019-04-12 | FVSA | Futures | 215.06 | 217.15 | 204.58 | 208.77 | 27643.0 |
| 2019-04-12 | FXXP | Futures | 341.2 | 342.1 | 340.1 | 341.6 | 54876.0 |
| 2019-04-12 | G | Futures | 117.79 | 118.0 | 116.98 | 117.02 | 203281.0 |
| 2019-04-12 | GF | Futures | 311.615 | 313.957 | 310.938 | 313.332 | 4196.0 |
| 2019-04-12 | GSCI | Futures | 510.2 | 512.12 | 510.15 | 510.54 | 603.0 |
> showing 50 of 116 rows — these rows as CSV