PREVIEW / futures_daily / 2021-06-18
file: by_date/futures_daily/2021/2021-06-18.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-06-18 | ES | Futures | 4739.09 | 4743.59 | 4654.51 | 4668.84 | 1951342.0 |
| 2021-06-18 | NQ | Futures | 16359.28 | 16387.84 | 16163.16 | 16192.0 | 575363.0 |
| 2021-06-18 | YM | Futures | 36552.4 | 36601.2 | 35859.5 | 35950.6 | 226091.0 |
| 2021-06-18 | CL | Futures | 50.79 | 51.52 | 50.12 | 51.14 | 420105.0 |
| 2021-06-18 | GC | Futures | 2074.8 | 2102.9 | 2060.0 | 2069.1 | 264605.0 |
| 2021-06-18 | ZN | Futures | 133.646101 | 134.025643 | 133.250746 | 133.914943 | 2209845.0 |
| 2021-06-18 | A6 | Futures | 0.7749 | 0.77562 | 0.76716 | 0.76926 | 129659.0 |
| 2021-06-18 | AD | Futures | 0.82057 | 0.82168 | 0.81236 | 0.81596 | 101743.0 |
| 2021-06-18 | ALI | Futures | 2767.87 | 2777.33 | 2745.48 | 2760.98 | 378.0 |
| 2021-06-18 | B | Futures | 47.73 | 48.23 | 47.2 | 48.06 | 231547.0 |
| 2021-06-18 | B6 | Futures | 1.4139 | 1.416 | 1.4004 | 1.4032 | 134433.0 |
| 2021-06-18 | BFX | Futures | 4249.6 | 4249.6 | 4226.6 | 4226.6 | 2.0 |
| 2021-06-18 | BR | Futures | 0.15823 | 0.15907 | 0.15663 | 0.15663 | 1140.0 |
| 2021-06-18 | BTC | Futures | 54614.7 | 55310.2 | 50855.0 | 51123.0 | 5719.0 |
| 2021-06-18 | BZ | Futures | 46.65 | 47.08 | 46.08 | 46.93 | 26417.0 |
| 2021-06-18 | C | Futures | 1454.0 | 1464.0 | 1449.0 | 1453.0 | 1889.0 |
| 2021-06-18 | CC | Futures | 1565.0 | 1577.0 | 1550.0 | 1556.0 | 14351.0 |
| 2021-06-18 | CNH | Futures | 6.2629 | 6.269 | 6.2498 | 6.2653 | 411.0 |
| 2021-06-18 | CSC | Futures | 2.558 | 2.558 | 2.551 | 2.552 | 52.0 |
| 2021-06-18 | CT | Futures | 78.45 | 79.44 | 78.43 | 78.71 | 3969.0 |
| 2021-06-18 | DC | Futures | 23.49 | 23.53 | 23.41 | 23.41 | 110.0 |
| 2021-06-18 | DX | Futures | 88.791 | 89.308 | 88.737 | 89.128 | 26122.0 |
| 2021-06-18 | E1 | Futures | 1.22628 | 1.2274 | 1.21819 | 1.221 | 29430.0 |
| 2021-06-18 | E6 | Futures | 1.2685 | 1.27057 | 1.26227 | 1.26493 | 226244.0 |
| 2021-06-18 | E7 | Futures | 1.2622 | 1.2642 | 1.2559 | 1.2586 | 7886.0 |
| 2021-06-18 | EBM | Futures | 301.57 | 307.46 | 301.21 | 306.36 | 14221.0 |
| 2021-06-18 | ED | Futures | 96.5393 | 96.5393 | 96.52 | 96.5248 | 415484.0 |
| 2021-06-18 | ER | Futures | 98.46 | 98.465 | 98.455 | 98.455 | 52122.0 |
| 2021-06-18 | ESG | Futures | 390.94 | 390.94 | 385.24 | 385.35 | 371.0 |
| 2021-06-18 | EW | Futures | 2854.5 | 2855.0 | 2787.7 | 2797.2 | 14836.0 |
| 2021-06-18 | FBON | Futures | 148.09 | 148.09 | 147.5 | 147.7 | 1429.0 |
| 2021-06-18 | FBTP | Futures | 138.44 | 138.5 | 137.55 | 137.82 | 183811.0 |
| 2021-06-18 | FBTS | Futures | 110.244 | 110.244 | 110.078 | 110.107 | 110401.0 |
| 2021-06-18 | FCE | Futures | 6629.1 | 6650.0 | 6521.0 | 6530.4 | 88363.0 |
| 2021-06-18 | FDAX | Futures | 16844.1 | 16844.1 | 16500.2 | 16512.0 | 88809.0 |
| 2021-06-18 | FDIV | Futures | 188.48 | 188.48 | 186.91 | 186.91 | 50.0 |
| 2021-06-18 | FDXM | Futures | 16740.3 | 16756.2 | 16418.4 | 16430.1 | 71676.0 |
| 2021-06-18 | FDXS | Futures | 16648.8 | 16648.8 | 16315.1 | 16325.7 | 4493.0 |
| 2021-06-18 | FESX | Futures | 3931.4 | 3935.2 | 3847.0 | 3850.8 | 1229660.0 |
| 2021-06-18 | FGBL | Futures | 167.07 | 167.47 | 166.96 | 167.2 | 828917.0 |
| 2021-06-18 | FGBM | Futures | 134.68 | 134.7 | 134.56 | 134.62 | 437368.0 |
| 2021-06-18 | FGBS | Futures | 112.584 | 112.599 | 112.569 | 112.584 | 252298.0 |
| 2021-06-18 | FGBX | Futures | 217.62 | 219.95 | 217.3 | 218.83 | 111823.0 |
| 2021-06-18 | FMWO | Futures | 10558.9 | 10558.9 | 10394.4 | 10407.3 | 6316.0 |
| 2021-06-18 | FOAT | Futures | 154.72 | 154.84 | 154.42 | 154.62 | 232682.0 |
| 2021-06-18 | FTDX | Futures | 3601.9 | 3613.7 | 3573.7 | 3573.7 | 155.0 |
| 2021-06-18 | FTI | Futures | 699.0 | 700.09 | 682.76 | 684.68 | 40368.0 |
| 2021-06-18 | FTUK | Futures | 6976.4 | 6976.4 | 6822.3 | 6828.2 | 138106.0 |
| 2021-06-18 | FVSA | Futures | 86.64 | 96.5 | 84.35 | 91.92 | 47663.0 |
| 2021-06-18 | FXXP | Futures | 435.1 | 435.2 | 427.5 | 427.8 | 117517.0 |
> showing 50 of 122 rows — these rows as CSV