PREVIEW / futures_daily / 2021-07-14
file: by_date/futures_daily/2021/2021-07-14.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-14 | ES | Futures | 4900.4 | 4928.5 | 4889.72 | 4909.67 | 1308582.0 |
| 2021-07-14 | NQ | Futures | 17155.04 | 17300.69 | 17122.16 | 17180.42 | 499191.0 |
| 2021-07-14 | YM | Futures | 37711.5 | 37892.6 | 37590.1 | 37751.7 | 127620.0 |
| 2021-07-14 | CL | Futures | 53.98 | 54.2 | 51.9 | 52.58 | 375426.0 |
| 2021-07-14 | GC | Futures | 2115.0 | 2141.7 | 2111.1 | 2134.6 | 229879.0 |
| 2021-07-14 | ZN | Futures | 134.579141 | 135.148454 | 134.547513 | 135.069383 | 1469059.0 |
| 2021-07-14 | A6 | Futures | 0.76382 | 0.76798 | 0.76228 | 0.76705 | 73325.0 |
| 2021-07-14 | AD | Futures | 0.81018 | 0.8159 | 0.80937 | 0.81043 | 79213.0 |
| 2021-07-14 | ALI | Futures | 2921.09 | 2932.86 | 2911.05 | 2919.66 | 1829.0 |
| 2021-07-14 | B | Futures | 50.36 | 50.65 | 48.72 | 49.36 | 376936.0 |
| 2021-07-14 | B6 | Futures | 1.4028 | 1.4107 | 1.4015 | 1.4066 | 87087.0 |
| 2021-07-14 | BFX | Futures | 4274.6 | 4275.9 | 4274.6 | 4275.9 | 12.0 |
| 2021-07-14 | BR | Futures | 0.15455 | 0.15687 | 0.15443 | 0.15667 | 308.0 |
| 2021-07-14 | BTC | Futures | 46349.7 | 47289.9 | 44896.6 | 46641.7 | 3546.0 |
| 2021-07-14 | BZ | Futures | 49.31 | 49.51 | 47.6 | 48.25 | 49772.0 |
| 2021-07-14 | C | Futures | 1448.0 | 1458.0 | 1437.0 | 1439.0 | 4913.0 |
| 2021-07-14 | CB | Futures | 142.812 | 143.012 | 142.009 | 142.009 | 64.0 |
| 2021-07-14 | CC | Futures | 1573.0 | 1591.0 | 1567.0 | 1575.0 | 11091.0 |
| 2021-07-14 | CNH | Futures | 6.2784 | 6.2797 | 6.2502 | 6.2566 | 417.0 |
| 2021-07-14 | CSC | Futures | 2.665 | 2.681 | 2.571 | 2.599 | 148.0 |
| 2021-07-14 | CT | Futures | 82.77 | 83.76 | 82.77 | 83.76 | 65.0 |
| 2021-07-14 | DC | Futures | 24.03 | 24.42 | 23.32 | 23.56 | 209.0 |
| 2021-07-14 | DX | Futures | 89.694 | 89.733 | 89.259 | 89.317 | 19380.0 |
| 2021-07-14 | E1 | Futures | 1.22459 | 1.23032 | 1.22269 | 1.22965 | 19849.0 |
| 2021-07-14 | E6 | Futures | 1.2543 | 1.26084 | 1.2536 | 1.25983 | 168261.0 |
| 2021-07-14 | E7 | Futures | 1.2482 | 1.2545 | 1.2473 | 1.2535 | 4693.0 |
| 2021-07-14 | EBM | Futures | 299.37 | 307.46 | 296.79 | 306.36 | 20642.0 |
| 2021-07-14 | ED | Futures | 96.5442 | 96.549 | 96.5393 | 96.5393 | 98317.0 |
| 2021-07-14 | ER | Futures | 98.465 | 98.465 | 98.46 | 98.46 | 20038.0 |
| 2021-07-14 | ESG | Futures | 406.84 | 407.97 | 405.47 | 406.58 | 225.0 |
| 2021-07-14 | EW | Futures | 2862.2 | 2895.0 | 2843.5 | 2849.5 | 9249.0 |
| 2021-07-14 | FBON | Futures | 149.35 | 149.53 | 149.09 | 149.41 | 467.0 |
| 2021-07-14 | FBTP | Futures | 139.67 | 139.98 | 139.54 | 139.82 | 83721.0 |
| 2021-07-14 | FBTS | Futures | 110.292 | 110.302 | 110.263 | 110.273 | 39330.0 |
| 2021-07-14 | FCE | Futures | 6522.3 | 6547.9 | 6509.8 | 6540.3 | 56245.0 |
| 2021-07-14 | FDAX | Futures | 16885.9 | 16922.3 | 16816.2 | 16900.9 | 58224.0 |
| 2021-07-14 | FDXM | Futures | 16788.2 | 16837.3 | 16732.8 | 16817.0 | 34318.0 |
| 2021-07-14 | FDXS | Futures | 16651.9 | 16730.3 | 16627.6 | 16710.2 | 6724.0 |
| 2021-07-14 | FESX | Futures | 3869.8 | 3882.1 | 3852.7 | 3878.8 | 564115.0 |
| 2021-07-14 | FGBL | Futures | 168.28 | 169.03 | 168.26 | 168.88 | 612530.0 |
| 2021-07-14 | FGBM | Futures | 134.93 | 135.09 | 134.89 | 135.07 | 260893.0 |
| 2021-07-14 | FGBS | Futures | 112.584 | 112.614 | 112.579 | 112.604 | 129387.0 |
| 2021-07-14 | FGBX | Futures | 220.2 | 222.83 | 219.88 | 222.25 | 67811.0 |
| 2021-07-14 | FMWO | Futures | 10776.3 | 10830.3 | 10762.2 | 10791.5 | 2820.0 |
| 2021-07-14 | FOAT | Futures | 156.04 | 156.59 | 155.96 | 156.47 | 128384.0 |
| 2021-07-14 | FTDX | Futures | 3735.8 | 3735.8 | 3700.9 | 3732.2 | 413.0 |
| 2021-07-14 | FTI | Futures | 707.93 | 712.28 | 705.49 | 710.07 | 17162.0 |
| 2021-07-14 | FTUK | Futures | 6942.5 | 6953.8 | 6893.2 | 6920.3 | 75884.0 |
| 2021-07-14 | FVSA | Futures | 82.82 | 84.09 | 80.28 | 83.03 | 17933.0 |
| 2021-07-14 | FXXP | Futures | 436.4 | 437.4 | 435.2 | 437.0 | 42524.0 |
> showing 50 of 122 rows — these rows as CSV