PREVIEW / futures_daily / 2021-11-22
file: by_date/futures_daily/2021/2021-11-22.parquet size: 10 KB rows: 121
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-11-22 | ES | Futures | 5288.12 | 5332.55 | 5258.03 | 5264.21 | 1685386.0 |
| 2021-11-22 | NQ | Futures | 19142.5 | 19335.37 | 18870.65 | 18890.83 | 770668.0 |
| 2021-11-22 | YM | Futures | 38725.3 | 39038.6 | 38657.8 | 38702.4 | 198406.0 |
| 2021-11-22 | CL | Futures | 56.97 | 58.03 | 56.23 | 57.73 | 465768.0 |
| 2021-11-22 | GC | Futures | 2156.3 | 2158.8 | 2102.8 | 2107.3 | 352857.0 |
| 2021-11-22 | ZN | Futures | 132.97101 | 132.97101 | 132.112927 | 132.20827 | 3135163.0 |
| 2021-11-22 | A6 | Futures | 0.74163 | 0.74562 | 0.74024 | 0.74081 | 85855.0 |
| 2021-11-22 | AD | Futures | 0.80283 | 0.80389 | 0.79897 | 0.79938 | 66032.0 |
| 2021-11-22 | ALI | Futures | 2987.3 | 3040.96 | 2987.3 | 3010.78 | 22.0 |
| 2021-11-22 | B | Futures | 53.72 | 54.74 | 53.03 | 54.48 | 350902.0 |
| 2021-11-22 | B6 | Futures | 1.3651 | 1.3654 | 1.3586 | 1.3588 | 76324.0 |
| 2021-11-22 | BFX | Futures | 4284.0 | 4296.8 | 4282.5 | 4282.5 | 3.0 |
| 2021-11-22 | BR | Futures | 0.1439 | 0.14569 | 0.1439 | 0.14463 | 8094.0 |
| 2021-11-22 | BTC | Futures | 77854.7 | 78572.6 | 73224.2 | 73527.2 | 11800.0 |
| 2021-11-22 | BZ | Futures | 52.52 | 53.47 | 51.76 | 53.21 | 39085.0 |
| 2021-11-22 | C | Futures | 1460.0 | 1474.0 | 1456.0 | 1472.0 | 2519.0 |
| 2021-11-22 | CB | Futures | 159.963 | 160.353 | 159.963 | 159.963 | 6.0 |
| 2021-11-22 | CC | Futures | 1631.0 | 1631.0 | 1614.0 | 1628.0 | 12276.0 |
| 2021-11-22 | CNH | Futures | 6.1288 | 6.1324 | 6.116 | 6.1269 | 378.0 |
| 2021-11-22 | CSC | Futures | 2.485 | 2.495 | 2.452 | 2.476 | 63.0 |
| 2021-11-22 | CT | Futures | 111.0 | 111.5 | 109.67 | 109.86 | 2846.0 |
| 2021-11-22 | DC | Futures | 23.73 | 24.04 | 23.57 | 23.75 | 631.0 |
| 2021-11-22 | DX | Futures | 92.83 | 93.298 | 92.796 | 93.283 | 21844.0 |
| 2021-11-22 | E1 | Futures | 1.20623 | 1.20925 | 1.2004 | 1.20063 | 25655.0 |
| 2021-11-22 | E6 | Futures | 1.19942 | 1.20001 | 1.19369 | 1.19379 | 198908.0 |
| 2021-11-22 | E7 | Futures | 1.1929 | 1.1934 | 1.187 | 1.1873 | 5758.0 |
| 2021-11-22 | EBM | Futures | 446.39 | 455.94 | 446.39 | 454.1 | 11251.0 |
| 2021-11-22 | ED | Futures | 96.5126 | 96.5126 | 96.4981 | 96.503 | 220803.0 |
| 2021-11-22 | ER | Futures | 98.499 | 98.504 | 98.499 | 98.499 | 17360.0 |
| 2021-11-22 | ESG | Futures | 445.18 | 448.2 | 442.23 | 442.36 | 418.0 |
| 2021-11-22 | EW | Futures | 3089.9 | 3123.0 | 3086.4 | 3091.8 | 15222.0 |
| 2021-11-22 | FBON | Futures | 149.96 | 150.24 | 149.47 | 149.64 | 395.0 |
| 2021-11-22 | FBTP | Futures | 139.17 | 139.48 | 138.12 | 138.41 | 103091.0 |
| 2021-11-22 | FBTS | Futures | 110.574 | 110.604 | 110.439 | 110.468 | 46081.0 |
| 2021-11-22 | FCE | Futures | 7198.1 | 7220.4 | 7159.1 | 7182.4 | 48382.0 |
| 2021-11-22 | FDAX | Futures | 17282.2 | 17314.2 | 17159.2 | 17238.3 | 62670.0 |
| 2021-11-22 | FDXM | Futures | 17319.5 | 17364.6 | 17209.1 | 17287.4 | 31432.0 |
| 2021-11-22 | FDXS | Futures | 17157.7 | 17202.3 | 17049.4 | 17126.9 | 17212.0 |
| 2021-11-22 | FESX | Futures | 4168.6 | 4183.4 | 4135.1 | 4157.6 | 574765.0 |
| 2021-11-22 | FGBL | Futures | 169.65 | 170.02 | 169.0 | 169.23 | 644228.0 |
| 2021-11-22 | FGBM | Futures | 135.28 | 135.4 | 134.99 | 135.09 | 309171.0 |
| 2021-11-22 | FGBS | Futures | 112.875 | 112.92 | 112.825 | 112.845 | 298656.0 |
| 2021-11-22 | FGBX | Futures | 233.08 | 234.01 | 230.7 | 231.44 | 66684.0 |
| 2021-11-22 | FMWO | Futures | 11469.0 | 11506.7 | 11377.0 | 11477.2 | 4047.0 |
| 2021-11-22 | FOAT | Futures | 157.2 | 157.35 | 156.38 | 156.64 | 165402.0 |
| 2021-11-22 | FTDX | Futures | 4100.2 | 4114.0 | 4051.9 | 4053.5 | 305.0 |
| 2021-11-22 | FTI | Futures | 784.38 | 787.34 | 773.74 | 777.7 | 18082.0 |
| 2021-11-22 | FTUK | Futures | 7132.7 | 7174.2 | 7109.5 | 7166.3 | 76930.0 |
| 2021-11-22 | FVSA | Futures | 63.8 | 66.01 | 62.85 | 63.16 | 16654.0 |
| 2021-11-22 | FXXP | Futures | 464.0 | 465.1 | 461.1 | 463.1 | 47942.0 |
> showing 50 of 121 rows — these rows as CSV