PREVIEW / futures_daily / 2019-04-15
file: by_date/futures_daily/2019/2019-04-15.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-04-15 | ES | Futures | 3145.47 | 3148.17 | 3133.05 | 3142.77 | 955662.0 |
| 2019-04-15 | NQ | Futures | 8818.97 | 8824.74 | 8755.32 | 8811.77 | 322483.0 |
| 2019-04-15 | YM | Futures | 27873.0 | 27946.9 | 27779.1 | 27838.2 | 135953.0 |
| 2019-04-15 | CL | Futures | 65.6 | 65.67 | 64.89 | 65.26 | 230459.0 |
| 2019-04-15 | GC | Futures | 1610.5 | 1612.0 | 1599.7 | 1607.2 | 232989.0 |
| 2019-04-15 | ZN | Futures | 122.373406 | 122.528801 | 122.295709 | 122.482183 | 1013260.0 |
| 2019-04-15 | A6 | Futures | 0.74106 | 0.74137 | 0.73951 | 0.74044 | 73586.0 |
| 2019-04-15 | AD | Futures | 0.75959 | 0.76141 | 0.75605 | 0.75681 | 81052.0 |
| 2019-04-15 | B | Futures | 52.12 | 52.15 | 51.55 | 51.85 | 219152.0 |
| 2019-04-15 | B6 | Futures | 1.3438 | 1.3482 | 1.3436 | 1.3459 | 58877.0 |
| 2019-04-15 | BR | Futures | 0.20609 | 0.20625 | 0.20609 | 0.20625 | 16.0 |
| 2019-04-15 | BTC | Futures | 7895.5 | 8034.5 | 7640.5 | 7741.0 | 10075.0 |
| 2019-04-15 | BZ | Futures | 52.02 | 52.05 | 51.41 | 51.7 | 28582.0 |
| 2019-04-15 | C | Futures | 1633.0 | 1634.0 | 1606.0 | 1615.0 | 6000.0 |
| 2019-04-15 | CB | Futures | 275.852 | 275.972 | 275.732 | 275.732 | 11.0 |
| 2019-04-15 | CC | Futures | 1616.0 | 1630.0 | 1602.0 | 1613.0 | 21180.0 |
| 2019-04-15 | CNH | Futures | 6.7178 | 6.7233 | 6.7137 | 6.7169 | 456.0 |
| 2019-04-15 | CSC | Futures | 2.878 | 2.885 | 2.85 | 2.859 | 111.0 |
| 2019-04-15 | CT | Futures | 82.96 | 83.27 | 80.37 | 81.21 | 14478.0 |
| 2019-04-15 | DC | Futures | 24.25 | 24.34 | 24.06 | 24.11 | 256.0 |
| 2019-04-15 | DX | Futures | 92.574 | 92.574 | 92.406 | 92.551 | 9890.0 |
| 2019-04-15 | E1 | Futures | 1.17134 | 1.17274 | 1.16831 | 1.16878 | 19786.0 |
| 2019-04-15 | E6 | Futures | 1.24715 | 1.24913 | 1.24655 | 1.24715 | 135313.0 |
| 2019-04-15 | E7 | Futures | 1.2409 | 1.2429 | 1.2404 | 1.2409 | 2780.0 |
| 2019-04-15 | EBM | Futures | 200.31 | 200.57 | 199.78 | 200.04 | 14200.0 |
| 2019-04-15 | ED | Futures | 95.1355 | 95.1355 | 95.1257 | 95.1306 | 228987.0 |
| 2019-04-15 | ER | Futures | 98.416 | 98.421 | 98.411 | 98.416 | 46372.0 |
| 2019-04-15 | EW | Futures | 2090.4 | 2094.6 | 2081.6 | 2086.3 | 8669.0 |
| 2019-04-15 | FBON | Futures | 135.62 | 135.72 | 135.13 | 135.28 | 548.0 |
| 2019-04-15 | FBTP | Futures | 115.55 | 116.09 | 115.37 | 115.51 | 56862.0 |
| 2019-04-15 | FBTS | Futures | 105.884 | 106.036 | 105.855 | 105.903 | 35008.0 |
| 2019-04-15 | FCE | Futures | 4903.8 | 4912.8 | 4893.4 | 4903.8 | 202551.0 |
| 2019-04-15 | FDAX | Futures | 12665.3 | 12696.4 | 12638.0 | 12680.6 | 72982.0 |
| 2019-04-15 | FDIV | Futures | 148.41 | 148.41 | 148.41 | 148.41 | 1.0 |
| 2019-04-15 | FDXM | Futures | 12563.9 | 12586.9 | 12527.4 | 12570.7 | 28103.0 |
| 2019-04-15 | FESX | Futures | 2954.9 | 2958.4 | 2946.2 | 2952.3 | 799816.0 |
| 2019-04-15 | FGBL | Futures | 158.85 | 159.02 | 158.6 | 158.92 | 651958.0 |
| 2019-04-15 | FGBM | Futures | 132.69 | 132.74 | 132.61 | 132.72 | 351005.0 |
| 2019-04-15 | FGBS | Futures | 112.713 | 112.724 | 112.693 | 112.713 | 208425.0 |
| 2019-04-15 | FGBX | Futures | 190.77 | 191.14 | 189.48 | 190.46 | 40552.0 |
| 2019-04-15 | FMWO | Futures | 7261.2 | 7264.7 | 7240.4 | 7250.8 | 2623.0 |
| 2019-04-15 | FOAT | Futures | 146.22 | 146.36 | 145.72 | 145.94 | 144453.0 |
| 2019-04-15 | FTDX | Futures | 2733.8 | 2753.1 | 2733.8 | 2750.1 | 255.0 |
| 2019-04-15 | FTI | Futures | 526.79 | 528.4 | 525.89 | 527.1 | 36474.0 |
| 2019-04-15 | FTUK | Futures | 6779.7 | 6779.7 | 6752.2 | 6767.4 | 65610.0 |
| 2019-04-15 | FVSA | Futures | 205.98 | 207.38 | 199.0 | 201.79 | 48408.0 |
| 2019-04-15 | FXXP | Futures | 342.0 | 342.9 | 341.7 | 342.4 | 39989.0 |
| 2019-04-15 | G | Futures | 117.08 | 117.11 | 116.76 | 116.98 | 189286.0 |
| 2019-04-15 | GF | Futures | 313.645 | 314.685 | 311.667 | 314.425 | 4732.0 |
| 2019-04-15 | GSCI | Futures | 508.45 | 508.45 | 507.38 | 507.66 | 27.0 |
> showing 50 of 115 rows — these rows as CSV