PREVIEW / futures_daily / 2021-07-16
file: by_date/futures_daily/2021/2021-07-16.parquet size: 10 KB rows: 124
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-16 | ES | Futures | 4887.19 | 4909.95 | 4849.53 | 4854.31 | 1636065.0 |
| 2021-07-16 | NQ | Futures | 17049.76 | 17154.75 | 16908.44 | 16925.17 | 539012.0 |
| 2021-07-16 | YM | Futures | 37775.5 | 37924.1 | 37435.0 | 37478.4 | 162512.0 |
| 2021-07-16 | CL | Futures | 51.54 | 52.14 | 50.78 | 51.79 | 359206.0 |
| 2021-07-16 | GC | Futures | 2141.2 | 2143.6 | 2116.4 | 2122.9 | 184655.0 |
| 2021-07-16 | ZN | Futures | 135.401482 | 135.464738 | 135.069383 | 135.401482 | 1061127.0 |
| 2021-07-16 | A6 | Futures | 0.76146 | 0.76346 | 0.75828 | 0.75911 | 70894.0 |
| 2021-07-16 | AD | Futures | 0.80506 | 0.80708 | 0.80328 | 0.80419 | 73401.0 |
| 2021-07-16 | ALI | Futures | 2906.46 | 2906.46 | 2868.76 | 2868.76 | 218.0 |
| 2021-07-16 | B | Futures | 48.32 | 48.92 | 47.76 | 48.59 | 292660.0 |
| 2021-07-16 | B6 | Futures | 1.4038 | 1.4077 | 1.3973 | 1.3982 | 96734.0 |
| 2021-07-16 | BFX | Futures | 4247.3 | 4247.3 | 4221.3 | 4243.7 | 3.0 |
| 2021-07-16 | BR | Futures | 0.15575 | 0.15687 | 0.15535 | 0.15575 | 503.0 |
| 2021-07-16 | BTC | Futures | 45160.1 | 45879.6 | 44105.9 | 45480.7 | 4090.0 |
| 2021-07-16 | BZ | Futures | 47.28 | 47.8 | 46.69 | 47.49 | 33536.0 |
| 2021-07-16 | C | Futures | 1417.0 | 1424.0 | 1393.0 | 1402.0 | 6526.0 |
| 2021-07-16 | CB | Futures | 139.522 | 140.003 | 139.522 | 140.003 | 3.0 |
| 2021-07-16 | CC | Futures | 1558.0 | 1568.0 | 1511.0 | 1521.0 | 18751.0 |
| 2021-07-16 | CNH | Futures | 6.2586 | 6.2779 | 6.2586 | 6.2699 | 382.0 |
| 2021-07-16 | CSC | Futures | 2.498 | 2.512 | 2.485 | 2.498 | 68.0 |
| 2021-07-16 | CT | Futures | 82.91 | 83.88 | 82.91 | 83.88 | 7.0 |
| 2021-07-16 | DC | Futures | 22.64 | 22.67 | 22.5 | 22.58 | 144.0 |
| 2021-07-16 | DX | Futures | 89.491 | 89.661 | 89.438 | 89.59 | 15019.0 |
| 2021-07-16 | E1 | Futures | 1.22549 | 1.22594 | 1.22201 | 1.2228 | 15509.0 |
| 2021-07-16 | E6 | Futures | 1.25775 | 1.25892 | 1.25568 | 1.25749 | 122693.0 |
| 2021-07-16 | E7 | Futures | 1.2516 | 1.2527 | 1.2494 | 1.2512 | 2813.0 |
| 2021-07-16 | EBM | Futures | 308.93 | 316.29 | 308.93 | 315.18 | 20552.0 |
| 2021-07-16 | ED | Futures | 96.5393 | 96.5442 | 96.5393 | 96.5442 | 55901.0 |
| 2021-07-16 | ER | Futures | 98.46 | 98.465 | 98.46 | 98.465 | 21215.0 |
| 2021-07-16 | ESG | Futures | 405.08 | 406.64 | 401.69 | 402.04 | 255.0 |
| 2021-07-16 | EW | Futures | 2836.4 | 2863.6 | 2800.6 | 2805.1 | 10056.0 |
| 2021-07-16 | FBON | Futures | 149.59 | 149.87 | 149.49 | 149.81 | 368.0 |
| 2021-07-16 | FBTP | Futures | 139.83 | 140.08 | 139.59 | 140.01 | 80686.0 |
| 2021-07-16 | FBTS | Futures | 110.273 | 110.322 | 110.244 | 110.302 | 36113.0 |
| 2021-07-16 | FCE | Futures | 6477.4 | 6510.3 | 6400.0 | 6442.0 | 75481.0 |
| 2021-07-16 | FDAX | Futures | 16716.6 | 16804.4 | 16562.3 | 16619.1 | 83625.0 |
| 2021-07-16 | FDIV | Futures | 187.7 | 187.7 | 186.03 | 186.13 | 30.0 |
| 2021-07-16 | FDXM | Futures | 16634.7 | 16721.1 | 16480.2 | 16536.7 | 52976.0 |
| 2021-07-16 | FDXS | Futures | 16531.2 | 16613.8 | 16375.5 | 16431.6 | 9331.0 |
| 2021-07-16 | FESX | Futures | 3833.3 | 3851.7 | 3794.9 | 3812.4 | 831665.0 |
| 2021-07-16 | FGBL | Futures | 169.39 | 169.56 | 169.18 | 169.4 | 451477.0 |
| 2021-07-16 | FGBM | Futures | 135.16 | 135.21 | 135.09 | 135.16 | 235851.0 |
| 2021-07-16 | FGBS | Futures | 112.619 | 112.629 | 112.604 | 112.619 | 134963.0 |
| 2021-07-16 | FGBX | Futures | 224.56 | 225.12 | 223.64 | 224.5 | 56883.0 |
| 2021-07-16 | FMWO | Futures | 10738.7 | 10758.6 | 10640.0 | 10692.8 | 991.0 |
| 2021-07-16 | FOAT | Futures | 156.92 | 157.04 | 156.7 | 156.92 | 111787.0 |
| 2021-07-16 | FTDX | Futures | 3694.3 | 3715.8 | 3694.3 | 3700.4 | 53.0 |
| 2021-07-16 | FTI | Futures | 704.72 | 706.06 | 698.07 | 701.88 | 26837.0 |
| 2021-07-16 | FTUK | Futures | 6836.6 | 6884.9 | 6798.7 | 6824.3 | 116483.0 |
| 2021-07-16 | FVSA | Futures | 84.09 | 86.2 | 81.76 | 84.51 | 29426.0 |
> showing 50 of 124 rows — these rows as CSV