PREVIEW / futures_daily / 2021-07-09
file: by_date/futures_daily/2021/2021-07-09.parquet size: 10 KB rows: 123
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-09 | ES | Futures | 4845.04 | 4905.46 | 4825.93 | 4900.96 | 1311506.0 |
| 2021-07-09 | NQ | Futures | 16971.02 | 17111.49 | 16890.84 | 17086.68 | 424770.0 |
| 2021-07-09 | YM | Futures | 37181.3 | 37717.0 | 37018.7 | 37681.2 | 156203.0 |
| 2021-07-09 | CL | Futures | 52.55 | 53.63 | 52.16 | 53.48 | 422154.0 |
| 2021-07-09 | GC | Futures | 2109.1 | 2120.5 | 2101.4 | 2117.7 | 185581.0 |
| 2021-07-09 | ZN | Futures | 135.417296 | 135.43311 | 134.990311 | 135.037754 | 1208316.0 |
| 2021-07-09 | A6 | Futures | 0.76228 | 0.76875 | 0.76008 | 0.76839 | 67820.0 |
| 2021-07-09 | AD | Futures | 0.80906 | 0.81474 | 0.80744 | 0.81403 | 75447.0 |
| 2021-07-09 | ALI | Futures | 2853.09 | 2906.46 | 2850.51 | 2895.84 | 299.0 |
| 2021-07-09 | B | Futures | 49.11 | 50.05 | 48.73 | 49.88 | 248179.0 |
| 2021-07-09 | B6 | Futures | 1.3997 | 1.4126 | 1.3968 | 1.4105 | 110924.0 |
| 2021-07-09 | BFX | Futures | 4243.4 | 4274.6 | 4235.8 | 4274.6 | 4.0 |
| 2021-07-09 | BR | Futures | 0.15166 | 0.15206 | 0.15062 | 0.15098 | 95.0 |
| 2021-07-09 | BTC | Futures | 46556.3 | 48066.4 | 46007.8 | 47660.3 | 2662.0 |
| 2021-07-09 | BZ | Futures | 47.99 | 48.91 | 47.64 | 48.76 | 31967.0 |
| 2021-07-09 | C | Futures | 1413.0 | 1425.0 | 1405.0 | 1418.0 | 3008.0 |
| 2021-07-09 | CB | Futures | 138.078 | 138.8 | 138.078 | 138.8 | 24.0 |
| 2021-07-09 | CC | Futures | 1500.0 | 1546.0 | 1498.0 | 1539.0 | 19981.0 |
| 2021-07-09 | CNH | Futures | 6.2914 | 6.298 | 6.2772 | 6.2809 | 465.0 |
| 2021-07-09 | CSC | Futures | 2.57 | 2.645 | 2.554 | 2.573 | 74.0 |
| 2021-07-09 | CT | Futures | 80.45 | 81.38 | 80.45 | 81.38 | 11.0 |
| 2021-07-09 | DC | Futures | 23.01 | 23.75 | 22.93 | 23.1 | 307.0 |
| 2021-07-09 | DX | Futures | 89.293 | 89.453 | 89.008 | 89.038 | 14474.0 |
| 2021-07-09 | E1 | Futures | 1.22965 | 1.23122 | 1.22594 | 1.23055 | 21529.0 |
| 2021-07-09 | E6 | Futures | 1.26153 | 1.26536 | 1.2594 | 1.26493 | 134943.0 |
| 2021-07-09 | E7 | Futures | 1.2552 | 1.259 | 1.2531 | 1.2586 | 3464.0 |
| 2021-07-09 | EBM | Futures | 292.01 | 293.48 | 289.44 | 290.17 | 10958.0 |
| 2021-07-09 | ED | Futures | 96.5393 | 96.5442 | 96.5345 | 96.5393 | 79672.0 |
| 2021-07-09 | ER | Futures | 98.46 | 98.465 | 98.46 | 98.46 | 17548.0 |
| 2021-07-09 | ESG | Futures | 402.78 | 405.64 | 402.78 | 405.34 | 134.0 |
| 2021-07-09 | EW | Futures | 2839.1 | 2904.4 | 2821.2 | 2901.5 | 13230.0 |
| 2021-07-09 | FBON | Futures | 149.13 | 149.23 | 148.77 | 148.83 | 448.0 |
| 2021-07-09 | FBTP | Futures | 139.15 | 139.44 | 139.03 | 139.14 | 86756.0 |
| 2021-07-09 | FBTS | Futures | 110.205 | 110.244 | 110.205 | 110.214 | 35459.0 |
| 2021-07-09 | FCE | Futures | 6390.0 | 6514.5 | 6390.0 | 6503.5 | 76029.0 |
| 2021-07-09 | FDAX | Futures | 16510.9 | 16800.2 | 16435.9 | 16773.4 | 80754.0 |
| 2021-07-09 | FDIV | Futures | 185.64 | 187.4 | 185.64 | 187.4 | 40.0 |
| 2021-07-09 | FDXM | Futures | 16421.5 | 16716.8 | 16355.5 | 16690.2 | 56342.0 |
| 2021-07-09 | FDXS | Futures | 16325.7 | 16611.7 | 16260.0 | 16584.1 | 7158.0 |
| 2021-07-09 | FESX | Futures | 3778.7 | 3851.7 | 3756.5 | 3841.3 | 802620.0 |
| 2021-07-09 | FGBL | Futures | 168.71 | 168.86 | 168.43 | 168.46 | 552900.0 |
| 2021-07-09 | FGBM | Futures | 135.03 | 135.07 | 134.92 | 134.95 | 277257.0 |
| 2021-07-09 | FGBS | Futures | 112.619 | 112.624 | 112.594 | 112.594 | 185302.0 |
| 2021-07-09 | FGBX | Futures | 222.3 | 222.6 | 220.93 | 220.99 | 67531.0 |
| 2021-07-09 | FMWO | Futures | 10614.1 | 10791.5 | 10614.1 | 10763.3 | 2809.0 |
| 2021-07-09 | FOAT | Futures | 156.22 | 156.37 | 155.98 | 156.01 | 128713.0 |
| 2021-07-09 | FTDX | Futures | 3705.0 | 3708.1 | 3675.8 | 3686.0 | 78.0 |
| 2021-07-09 | FTI | Futures | 689.86 | 697.62 | 689.14 | 697.02 | 21940.0 |
| 2021-07-09 | FTUK | Futures | 6845.5 | 6947.9 | 6831.2 | 6936.1 | 98898.0 |
| 2021-07-09 | FVSA | Futures | 90.31 | 92.38 | 82.06 | 83.66 | 37096.0 |
> showing 50 of 123 rows — these rows as CSV