PREVIEW / futures_daily / 2021-07-12
file: by_date/futures_daily/2021/2021-07-12.parquet size: 10 KB rows: 122
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 |
|---|---|---|---|---|---|---|---|
| 2021-07-12 | ES | Futures | 4903.21 | 4922.6 | 4880.45 | 4919.51 | 1055739.0 |
| 2021-07-12 | NQ | Futures | 17102.26 | 17176.67 | 17057.26 | 17154.46 | 362608.0 |
| 2021-07-12 | YM | Futures | 37696.4 | 37847.1 | 37461.1 | 37815.6 | 135590.0 |
| 2021-07-12 | CL | Futures | 53.61 | 53.75 | 52.48 | 53.15 | 397931.0 |
| 2021-07-12 | GC | Futures | 2115.3 | 2118.2 | 2094.8 | 2112.2 | 201416.0 |
| 2021-07-12 | ZN | Futures | 135.006126 | 135.259153 | 134.879612 | 135.02194 | 1349716.0 |
| 2021-07-12 | A6 | Futures | 0.76823 | 0.76895 | 0.76403 | 0.76675 | 61396.0 |
| 2021-07-12 | AD | Futures | 0.81433 | 0.81459 | 0.81018 | 0.81327 | 50280.0 |
| 2021-07-12 | ALI | Futures | 2882.93 | 2899.29 | 2872.89 | 2883.79 | 864.0 |
| 2021-07-12 | B | Futures | 50.04 | 50.07 | 49.01 | 49.62 | 262298.0 |
| 2021-07-12 | B6 | Futures | 1.4114 | 1.4127 | 1.4053 | 1.4088 | 73115.0 |
| 2021-07-12 | BR | Futures | 0.15166 | 0.1539 | 0.15054 | 0.1535 | 193.0 |
| 2021-07-12 | BTC | Futures | 49049.3 | 49619.2 | 46442.3 | 46670.2 | 3826.0 |
| 2021-07-12 | BZ | Futures | 48.82 | 48.95 | 47.91 | 48.51 | 32255.0 |
| 2021-07-12 | C | Futures | 1418.0 | 1453.0 | 1416.0 | 1453.0 | 14831.0 |
| 2021-07-12 | CB | Futures | 139.602 | 139.602 | 139.382 | 139.382 | 7.0 |
| 2021-07-12 | CC | Futures | 1546.0 | 1599.0 | 1535.0 | 1594.0 | 34841.0 |
| 2021-07-12 | CNH | Futures | 6.2809 | 6.2809 | 6.2726 | 6.2727 | 216.0 |
| 2021-07-12 | CSC | Futures | 2.578 | 2.602 | 2.576 | 2.602 | 16.0 |
| 2021-07-12 | CT | Futures | 81.48 | 81.82 | 81.38 | 81.82 | 8.0 |
| 2021-07-12 | DC | Futures | 23.1 | 23.57 | 23.1 | 23.52 | 99.0 |
| 2021-07-12 | DX | Futures | 89.061 | 89.332 | 88.998 | 89.173 | 10539.0 |
| 2021-07-12 | E1 | Futures | 1.23055 | 1.23178 | 1.2265 | 1.22875 | 16063.0 |
| 2021-07-12 | E6 | Futures | 1.26493 | 1.26525 | 1.26057 | 1.26291 | 117933.0 |
| 2021-07-12 | E7 | Futures | 1.2587 | 1.2589 | 1.2543 | 1.2566 | 3264.0 |
| 2021-07-12 | EBM | Futures | 290.54 | 294.95 | 289.44 | 292.75 | 15406.0 |
| 2021-07-12 | ED | Futures | 96.5393 | 96.5442 | 96.5345 | 96.5393 | 160315.0 |
| 2021-07-12 | ER | Futures | 98.465 | 98.465 | 98.46 | 98.46 | 19887.0 |
| 2021-07-12 | ESG | Futures | 404.15 | 407.16 | 404.15 | 407.08 | 134.0 |
| 2021-07-12 | EW | Futures | 2902.1 | 2913.4 | 2876.5 | 2909.8 | 7812.0 |
| 2021-07-12 | FBON | Futures | 148.97 | 149.35 | 148.93 | 149.1 | 228.0 |
| 2021-07-12 | FBTP | Futures | 139.23 | 139.68 | 139.17 | 139.49 | 94548.0 |
| 2021-07-12 | FBTS | Futures | 110.234 | 110.273 | 110.224 | 110.244 | 45988.0 |
| 2021-07-12 | FCE | Futures | 6503.5 | 6549.7 | 6460.9 | 6539.3 | 52128.0 |
| 2021-07-12 | FDAX | Futures | 16780.9 | 16916.9 | 16728.4 | 16913.7 | 72822.0 |
| 2021-07-12 | FDIV | Futures | 186.76 | 188.87 | 186.76 | 188.87 | 95.0 |
| 2021-07-12 | FDXM | Futures | 16697.6 | 16834.1 | 16645.4 | 16829.8 | 44923.0 |
| 2021-07-12 | FDXS | Futures | 16605.3 | 16726.1 | 16538.6 | 16722.9 | 6358.0 |
| 2021-07-12 | FESX | Futures | 3846.1 | 3879.2 | 3824.7 | 3876.4 | 670207.0 |
| 2021-07-12 | FGBL | Futures | 168.47 | 168.86 | 168.47 | 168.6 | 456598.0 |
| 2021-07-12 | FGBM | Futures | 134.94 | 135.05 | 134.94 | 134.98 | 254021.0 |
| 2021-07-12 | FGBS | Futures | 112.594 | 112.609 | 112.594 | 112.599 | 134108.0 |
| 2021-07-12 | FGBX | Futures | 221.08 | 222.4 | 221.08 | 221.31 | 59045.0 |
| 2021-07-12 | FMWO | Futures | 10772.7 | 10826.8 | 10744.5 | 10815.0 | 1895.0 |
| 2021-07-12 | FOAT | Futures | 156.04 | 156.39 | 156.03 | 156.14 | 101244.0 |
| 2021-07-12 | FTDX | Futures | 3694.8 | 3753.3 | 3694.8 | 3718.4 | 194.0 |
| 2021-07-12 | FTI | Futures | 697.02 | 707.69 | 695.95 | 703.69 | 2556.0 |
| 2021-07-12 | FTUK | Futures | 6942.5 | 6956.7 | 6887.8 | 6955.3 | 68578.0 |
| 2021-07-12 | FVSA | Futures | 83.66 | 84.3 | 81.55 | 81.76 | 15441.0 |
| 2021-07-12 | FXXP | Futures | 434.1 | 437.5 | 432.5 | 437.4 | 42638.0 |
> showing 50 of 122 rows — these rows as CSV