PREVIEW / futures_daily / 2020-07-10
file: by_date/futures_daily/2020/2020-07-10.parquet size: 10 KB rows: 119
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 |
|---|---|---|---|---|---|---|---|
| 2020-07-10 | ES | Futures | 3536.88 | 3580.77 | 3502.26 | 3577.68 | 1408591.0 |
| 2020-07-10 | NQ | Futures | 12450.18 | 12590.04 | 12332.37 | 12578.14 | 527570.0 |
| 2020-07-10 | YM | Futures | 27423.5 | 27867.2 | 27106.3 | 27839.3 | 229586.0 |
| 2020-07-10 | CL | Futures | 28.69 | 29.56 | 27.94 | 29.4 | 393149.0 |
| 2020-07-10 | GC | Futures | 2171.2 | 2181.5 | 2156.9 | 2163.4 | 223832.0 |
| 2020-07-10 | ZN | Futures | 138.125099 | 138.450281 | 137.861856 | 137.97025 | 1029496.0 |
| 2020-07-10 | A6 | Futures | 0.71627 | 0.7172 | 0.71236 | 0.71483 | 80347.0 |
| 2020-07-10 | AD | Futures | 0.74759 | 0.74789 | 0.74469 | 0.74708 | 63118.0 |
| 2020-07-10 | ALI | Futures | 2007.87 | 2038.71 | 2007.27 | 2036.9 | 118.0 |
| 2020-07-10 | B | Futures | 27.6 | 28.29 | 26.92 | 28.17 | 214048.0 |
| 2020-07-10 | B6 | Futures | 1.2801 | 1.2864 | 1.2765 | 1.2828 | 83392.0 |
| 2020-07-10 | BR | Futures | 0.14809 | 0.14865 | 0.14809 | 0.14861 | 3.0 |
| 2020-07-10 | BTC | Futures | 12774.3 | 12788.1 | 12595.3 | 12774.3 | 2296.0 |
| 2020-07-10 | BZ | Futures | 27.01 | 27.65 | 26.32 | 27.54 | 24083.0 |
| 2020-07-10 | C | Futures | 1419.0 | 1444.0 | 1417.0 | 1433.0 | 11811.0 |
| 2020-07-10 | CB | Futures | 193.382 | 193.382 | 190.44 | 190.573 | 25.0 |
| 2020-07-10 | CC | Futures | 1410.0 | 1429.0 | 1404.0 | 1417.0 | 11334.0 |
| 2020-07-10 | CNH | Futures | 6.9149 | 6.9338 | 6.9149 | 6.9283 | 285.0 |
| 2020-07-10 | CSC | Futures | 4.141 | 4.324 | 4.127 | 4.223 | 209.0 |
| 2020-07-10 | CT | Futures | 65.68 | 65.68 | 65.15 | 65.44 | 15.0 |
| 2020-07-10 | DC | Futures | 34.13 | 35.59 | 33.97 | 34.59 | 825.0 |
| 2020-07-10 | DX | Futures | 93.449 | 93.657 | 93.111 | 93.323 | 16727.0 |
| 2020-07-10 | E1 | Futures | 1.21013 | 1.2124 | 1.20638 | 1.20854 | 21895.0 |
| 2020-07-10 | E6 | Futures | 1.2123 | 1.21691 | 1.20929 | 1.21417 | 152872.0 |
| 2020-07-10 | E7 | Futures | 1.2065 | 1.2109 | 1.2033 | 1.2081 | 5255.0 |
| 2020-07-10 | EBM | Futures | 224.54 | 227.24 | 223.05 | 223.94 | 26687.0 |
| 2020-07-10 | ED | Futures | 96.4185 | 96.4282 | 96.4137 | 96.4185 | 193723.0 |
| 2020-07-10 | ER | Futures | 98.372 | 98.377 | 98.367 | 98.372 | 56203.0 |
| 2020-07-10 | ESG | Futures | 286.04 | 289.52 | 285.32 | 289.52 | 385.0 |
| 2020-07-10 | EW | Futures | 1856.9 | 1886.5 | 1831.0 | 1881.4 | 10725.0 |
| 2020-07-10 | FBON | Futures | 145.91 | 145.91 | 145.54 | 145.62 | 375.0 |
| 2020-07-10 | FBTP | Futures | 130.52 | 130.64 | 130.04 | 130.37 | 68792.0 |
| 2020-07-10 | FBTS | Futures | 108.454 | 108.493 | 108.367 | 108.463 | 43738.0 |
| 2020-07-10 | FCE | Futures | 4796.3 | 4894.8 | 4774.7 | 4864.4 | 60261.0 |
| 2020-07-10 | FDAX | Futures | 13358.4 | 13498.7 | 13157.1 | 13405.2 | 82168.0 |
| 2020-07-10 | FDIV | Futures | 141.9 | 144.41 | 141.9 | 144.41 | 300.0 |
| 2020-07-10 | FDXM | Futures | 13307.1 | 13448.9 | 13109.1 | 13356.8 | 44021.0 |
| 2020-07-10 | FESX | Futures | 3021.3 | 3055.5 | 2976.1 | 3033.3 | 761471.0 |
| 2020-07-10 | FGBL | Futures | 168.55 | 169.04 | 168.49 | 168.76 | 477388.0 |
| 2020-07-10 | FGBM | Futures | 134.75 | 134.94 | 134.75 | 134.88 | 307452.0 |
| 2020-07-10 | FGBS | Futures | 112.744 | 112.8 | 112.744 | 112.785 | 241280.0 |
| 2020-07-10 | FGBX | Futures | 228.11 | 230.52 | 227.49 | 228.81 | 45704.0 |
| 2020-07-10 | FMWO | Futures | 7797.9 | 7944.9 | 7788.4 | 7886.8 | 2884.0 |
| 2020-07-10 | FOAT | Futures | 155.94 | 155.98 | 155.69 | 155.83 | 117323.0 |
| 2020-07-10 | FTDX | Futures | 3102.2 | 3135.9 | 3100.2 | 3110.9 | 121.0 |
| 2020-07-10 | FTI | Futures | 526.1 | 533.62 | 524.79 | 530.8 | 877.0 |
| 2020-07-10 | FTUK | Futures | 5710.5 | 5766.7 | 5634.0 | 5730.8 | 86497.0 |
| 2020-07-10 | FVSA | Futures | 269.09 | 273.13 | 247.56 | 255.64 | 11174.0 |
| 2020-07-10 | FXXP | Futures | 333.1 | 339.4 | 331.9 | 337.3 | 51398.0 |
| 2020-07-10 | G | Futures | 127.5 | 127.72 | 127.34 | 127.47 | 155041.0 |
> showing 50 of 119 rows — these rows as CSV