PREVIEW / futures_daily / 2020-04-03
file: by_date/futures_daily/2020/2020-04-03.parquet size: 10 KB rows: 118
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 |
|---|---|---|---|---|---|---|---|
| 2020-04-03 | ES | Futures | 2781.43 | 2798.86 | 2709.78 | 2747.13 | 1763886.0 |
| 2020-04-03 | NQ | Futures | 8739.31 | 8782.02 | 8510.6 | 8624.38 | 351874.0 |
| 2020-04-03 | YM | Futures | 22698.4 | 22783.7 | 22130.7 | 22362.2 | 169298.0 |
| 2020-04-03 | CL | Futures | 24.59 | 28.87 | 23.31 | 28.09 | 1007577.0 |
| 2020-04-03 | GC | Futures | 1983.2 | 2004.4 | 1969.9 | 1995.8 | 139612.0 |
| 2020-04-03 | ZN | Futures | 137.33074 | 137.654888 | 137.207255 | 137.454225 | 924986.0 |
| 2020-04-03 | A6 | Futures | 0.62299 | 0.62432 | 0.61467 | 0.61662 | 63923.0 |
| 2020-04-03 | AD | Futures | 0.71766 | 0.71958 | 0.71305 | 0.71649 | 60064.0 |
| 2020-04-03 | ALI | Futures | 1824.39 | 1824.39 | 1810.74 | 1810.74 | 89.0 |
| 2020-04-03 | B | Futures | 22.9 | 26.81 | 21.64 | 26.13 | 541275.0 |
| 2020-04-03 | B6 | Futures | 1.2595 | 1.2599 | 1.2397 | 1.2467 | 71865.0 |
| 2020-04-03 | BR | Futures | 0.15374 | 0.1548 | 0.15304 | 0.15374 | 43.0 |
| 2020-04-03 | BTC | Futures | 9773.5 | 10071.3 | 9397.6 | 9645.8 | 3943.0 |
| 2020-04-03 | BZ | Futures | 22.26 | 26.01 | 21.01 | 25.35 | 55373.0 |
| 2020-04-03 | C | Futures | 1632.0 | 1688.0 | 1625.0 | 1676.0 | 5810.0 |
| 2020-04-03 | CB | Futures | 161.722 | 161.722 | 156.703 | 156.982 | 57.0 |
| 2020-04-03 | CC | Futures | 1486.0 | 1506.0 | 1469.0 | 1483.0 | 12944.0 |
| 2020-04-03 | CNH | Futures | 7.0373 | 7.0485 | 7.0307 | 7.0438 | 351.0 |
| 2020-04-03 | CSC | Futures | 2.69 | 2.69 | 2.613 | 2.622 | 122.0 |
| 2020-04-03 | CT | Futures | 48.11 | 49.24 | 47.82 | 49.08 | 13730.0 |
| 2020-04-03 | DC | Futures | 21.47 | 21.71 | 20.77 | 20.88 | 571.0 |
| 2020-04-03 | DX | Futures | 96.992 | 97.631 | 96.93 | 97.352 | 10324.0 |
| 2020-04-03 | E1 | Futures | 1.17189 | 1.17349 | 1.16574 | 1.16984 | 21594.0 |
| 2020-04-03 | E6 | Futures | 1.1694 | 1.16972 | 1.16026 | 1.1644 | 134612.0 |
| 2020-04-03 | E7 | Futures | 1.1633 | 1.1636 | 1.1543 | 1.1583 | 5694.0 |
| 2020-04-03 | EBM | Futures | 215.29 | 216.69 | 213.61 | 213.89 | 17664.0 |
| 2020-04-03 | ED | Futures | 96.2131 | 96.2179 | 96.1648 | 96.1841 | 303784.0 |
| 2020-04-03 | ER | Futures | 98.293 | 98.298 | 98.279 | 98.284 | 104773.0 |
| 2020-04-03 | EW | Futures | 1447.2 | 1458.9 | 1395.1 | 1409.7 | 8507.0 |
| 2020-04-03 | FBON | Futures | 140.67 | 141.05 | 140.33 | 140.37 | 129.0 |
| 2020-04-03 | FBTP | Futures | 126.88 | 127.25 | 126.01 | 126.26 | 61465.0 |
| 2020-04-03 | FBTS | Futures | 107.326 | 107.393 | 107.008 | 107.133 | 43946.0 |
| 2020-04-03 | FCE | Futures | 4076.8 | 4088.0 | 3980.9 | 4021.6 | 46562.0 |
| 2020-04-03 | FDAX | Futures | 10106.3 | 10158.7 | 9959.3 | 10054.0 | 88350.0 |
| 2020-04-03 | FDXM | Futures | 10151.9 | 10207.2 | 10006.3 | 10102.0 | 70043.0 |
| 2020-04-03 | FESX | Futures | 2436.8 | 2446.0 | 2390.9 | 2416.6 | 1001704.0 |
| 2020-04-03 | FGBL | Futures | 167.15 | 167.62 | 167.0 | 167.25 | 391983.0 |
| 2020-04-03 | FGBM | Futures | 134.19 | 134.51 | 134.16 | 134.34 | 269216.0 |
| 2020-04-03 | FGBS | Futures | 112.744 | 112.855 | 112.729 | 112.805 | 153050.0 |
| 2020-04-03 | FGBX | Futures | 225.15 | 227.46 | 225.1 | 226.44 | 30408.0 |
| 2020-04-03 | FMWO | Futures | 6170.4 | 6253.9 | 6103.3 | 6158.6 | 2535.0 |
| 2020-04-03 | FOAT | Futures | 151.78 | 152.06 | 151.18 | 151.29 | 95653.0 |
| 2020-04-03 | FTDX | Futures | 2584.2 | 2599.8 | 2582.1 | 2583.7 | 58.0 |
| 2020-04-03 | FTI | Futures | 444.53 | 446.55 | 436.1 | 441.04 | 23259.0 |
| 2020-04-03 | FTUK | Futures | 5150.0 | 5166.0 | 5040.1 | 5088.2 | 99389.0 |
| 2020-04-03 | FVSA | Futures | 412.74 | 415.44 | 387.53 | 405.09 | 12657.0 |
| 2020-04-03 | FXXP | Futures | 285.1 | 286.8 | 281.0 | 283.9 | 44760.0 |
| 2020-04-03 | G | Futures | 125.13 | 125.42 | 125.08 | 125.24 | 105399.0 |
| 2020-04-03 | GF | Futures | 228.663 | 240.81 | 221.24 | 224.77 | 1150.0 |
| 2020-04-03 | GSCI | Futures | 293.12 | 293.12 | 293.12 | 293.12 | 3.0 |
> showing 50 of 118 rows — these rows as CSV