PREVIEW / futures_daily / 2021-11-01
file: by_date/futures_daily/2021/2021-11-01.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-11-01 | ES | Futures | 5183.5 | 5196.44 | 5159.32 | 5180.97 | 1071118.0 |
| 2021-11-01 | NQ | Futures | 18318.0 | 18352.02 | 18183.37 | 18328.38 | 411507.0 |
| 2021-11-01 | YM | Futures | 38947.2 | 39050.6 | 38824.3 | 38951.6 | 136286.0 |
| 2021-11-01 | CL | Futures | 61.77 | 62.89 | 61.31 | 62.28 | 412309.0 |
| 2021-11-01 | GC | Futures | 2082.8 | 2097.1 | 2076.9 | 2095.1 | 143332.0 |
| 2021-11-01 | ZN | Futures | 132.859777 | 133.018681 | 132.60553 | 132.875667 | 1479047.0 |
| 2021-11-01 | A6 | Futures | 0.77074 | 0.77269 | 0.76756 | 0.77089 | 70197.0 |
| 2021-11-01 | AD | Futures | 0.81978 | 0.82191 | 0.81841 | 0.8207 | 60266.0 |
| 2021-11-01 | ALI | Futures | 3037.54 | 3061.17 | 3037.54 | 3045.05 | 1195.0 |
| 2021-11-01 | B | Futures | 57.17 | 58.19 | 56.76 | 57.91 | 302904.0 |
| 2021-11-01 | B6 | Futures | 1.3894 | 1.3899 | 1.3848 | 1.3864 | 80730.0 |
| 2021-11-01 | BR | Futures | 0.14374 | 0.1441 | 0.14199 | 0.1424 | 4644.0 |
| 2021-11-01 | BTC | Futures | 81668.4 | 82794.7 | 78645.1 | 81167.8 | 4979.0 |
| 2021-11-01 | BZ | Futures | 55.9 | 56.82 | 55.43 | 56.55 | 36245.0 |
| 2021-11-01 | C | Futures | 1459.0 | 1469.0 | 1449.0 | 1459.0 | 7255.0 |
| 2021-11-01 | CB | Futures | 150.546 | 151.295 | 150.546 | 151.295 | 31.0 |
| 2021-11-01 | CC | Futures | 1636.0 | 1648.0 | 1612.0 | 1646.0 | 17143.0 |
| 2021-11-01 | CNH | Futures | 6.1564 | 6.1573 | 6.1415 | 6.1432 | 362.0 |
| 2021-11-01 | CSC | Futures | 2.532 | 2.56 | 2.494 | 2.515 | 56.0 |
| 2021-11-01 | CT | Futures | 107.46 | 111.86 | 107.4 | 111.85 | 38039.0 |
| 2021-11-01 | DC | Futures | 23.84 | 24.42 | 23.73 | 24.01 | 231.0 |
| 2021-11-01 | DX | Futures | 90.941 | 91.124 | 90.68 | 90.708 | 21639.0 |
| 2021-11-01 | E1 | Futures | 1.2237 | 1.23389 | 1.22258 | 1.23333 | 27846.0 |
| 2021-11-01 | E6 | Futures | 1.22944 | 1.23443 | 1.22774 | 1.23417 | 141079.0 |
| 2021-11-01 | E7 | Futures | 1.2228 | 1.2276 | 1.2211 | 1.2274 | 2739.0 |
| 2021-11-01 | EBM | Futures | 417.0 | 430.96 | 416.63 | 428.02 | 28051.0 |
| 2021-11-01 | ED | Futures | 96.5199 | 96.5296 | 96.5005 | 96.5102 | 207268.0 |
| 2021-11-01 | ER | Futures | 98.475 | 98.48 | 98.47 | 98.48 | 31176.0 |
| 2021-11-01 | ESG | Futures | 433.38 | 433.75 | 430.52 | 432.28 | 297.0 |
| 2021-11-01 | EW | Futures | 3008.4 | 3066.3 | 3004.1 | 3064.5 | 14041.0 |
| 2021-11-01 | FBON | Futures | 146.89 | 147.04 | 146.08 | 146.54 | 1483.0 |
| 2021-11-01 | FBTP | Futures | 135.54 | 135.57 | 134.01 | 134.69 | 191128.0 |
| 2021-11-01 | FBTS | Futures | 109.75 | 109.808 | 109.604 | 109.73 | 93786.0 |
| 2021-11-01 | FCE | Futures | 6936.6 | 6986.1 | 6934.6 | 6969.0 | 44922.0 |
| 2021-11-01 | FDAX | Futures | 16818.3 | 16928.4 | 16798.0 | 16896.3 | 57068.0 |
| 2021-11-01 | FDIV | Futures | 185.34 | 185.34 | 184.9 | 185.34 | 65.0 |
| 2021-11-01 | FDXM | Futures | 16864.0 | 16978.7 | 16847.9 | 16944.4 | 39885.0 |
| 2021-11-01 | FDXS | Futures | 16702.1 | 16820.0 | 16690.4 | 16787.1 | 17022.0 |
| 2021-11-01 | FESX | Futures | 4082.4 | 4102.5 | 4072.3 | 4094.4 | 568662.0 |
| 2021-11-01 | FGBL | Futures | 165.7 | 166.07 | 165.21 | 165.67 | 740860.0 |
| 2021-11-01 | FGBM | Futures | 133.54 | 133.78 | 133.43 | 133.63 | 500806.0 |
| 2021-11-01 | FGBS | Futures | 112.398 | 112.483 | 112.393 | 112.438 | 322070.0 |
| 2021-11-01 | FGBX | Futures | 225.83 | 226.54 | 223.93 | 224.53 | 95435.0 |
| 2021-11-01 | FMWO | Futures | 11319.2 | 11347.5 | 11285.0 | 11327.4 | 4045.0 |
| 2021-11-01 | FOAT | Futures | 153.12 | 153.48 | 152.6 | 153.06 | 180266.0 |
| 2021-11-01 | FTDX | Futures | 3940.6 | 3969.8 | 3940.6 | 3967.8 | 32.0 |
| 2021-11-01 | FTI | Futures | 776.8 | 778.81 | 770.78 | 774.14 | 13479.0 |
| 2021-11-01 | FTUK | Futures | 7163.3 | 7198.4 | 7142.6 | 7187.5 | 80046.0 |
| 2021-11-01 | FVSA | Futures | 66.0 | 67.21 | 64.8 | 65.83 | 14198.0 |
| 2021-11-01 | FXXP | Futures | 454.4 | 456.2 | 453.9 | 456.0 | 62495.0 |
> showing 50 of 122 rows — these rows as CSV