PREVIEW / futures_daily / 2018-10-03
file: by_date/futures_daily/2018/2018-10-03.parquet size: 10 KB rows: 113
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 |
|---|---|---|---|---|---|---|---|
| 2018-10-03 | ES | Futures | 3176.53 | 3193.61 | 3171.92 | 3179.24 | 1244514.0 |
| 2018-10-03 | NQ | Futures | 8892.93 | 8948.1 | 8875.8 | 8902.8 | 394538.0 |
| 2018-10-03 | YM | Futures | 28235.3 | 28396.4 | 28196.3 | 28297.4 | 166493.0 |
| 2018-10-03 | CL | Futures | 78.64 | 80.5 | 77.78 | 79.99 | 698817.0 |
| 2018-10-03 | GC | Futures | 1529.8 | 1536.5 | 1521.4 | 1524.6 | 255072.0 |
| 2018-10-03 | ZN | Futures | 118.281158 | 118.421228 | 117.456303 | 117.658626 | 2673326.0 |
| 2018-10-03 | A6 | Futures | 0.74023 | 0.74105 | 0.73117 | 0.73313 | 98217.0 |
| 2018-10-03 | AD | Futures | 0.78958 | 0.79074 | 0.78599 | 0.78857 | 63319.0 |
| 2018-10-03 | B | Futures | 62.3 | 63.73 | 61.73 | 63.4 | 345222.0 |
| 2018-10-03 | B6 | Futures | 1.3394 | 1.3439 | 1.3336 | 1.339 | 82151.0 |
| 2018-10-03 | BFX | Futures | 4343.8 | 4352.0 | 4343.8 | 4352.0 | 1.0 |
| 2018-10-03 | BR | Futures | 0.19489 | 0.19831 | 0.19431 | 0.19431 | 183.0 |
| 2018-10-03 | BTC | Futures | 9394.1 | 9408.5 | 9156.0 | 9271.5 | 1356.0 |
| 2018-10-03 | BZ | Futures | 61.78 | 63.24 | 61.27 | 62.93 | 31424.0 |
| 2018-10-03 | C | Futures | 1427.0 | 1431.0 | 1384.0 | 1387.0 | 7785.0 |
| 2018-10-03 | CB | Futures | 272.769 | 273.67 | 272.078 | 272.408 | 16.0 |
| 2018-10-03 | CC | Futures | 1460.0 | 1464.0 | 1407.0 | 1410.0 | 20658.0 |
| 2018-10-03 | CNH | Futures | 6.9453 | 6.9574 | 6.9402 | 6.9531 | 113.0 |
| 2018-10-03 | CSC | Futures | 3.226 | 3.234 | 3.208 | 3.208 | 141.0 |
| 2018-10-03 | CT | Futures | 85.64 | 86.27 | 85.4 | 85.82 | 10059.0 |
| 2018-10-03 | DC | Futures | 26.81 | 26.81 | 26.56 | 26.66 | 160.0 |
| 2018-10-03 | DX | Futures | 90.358 | 90.956 | 90.139 | 90.634 | 21506.0 |
| 2018-10-03 | E1 | Futures | 1.21227 | 1.21334 | 1.20208 | 1.2054 | 24656.0 |
| 2018-10-03 | E6 | Futures | 1.29151 | 1.29651 | 1.28211 | 1.28795 | 275313.0 |
| 2018-10-03 | E7 | Futures | 1.285 | 1.2901 | 1.2759 | 1.2816 | 5498.0 |
| 2018-10-03 | EBM | Futures | 210.79 | 211.31 | 208.46 | 209.24 | 28374.0 |
| 2018-10-03 | ED | Futures | 95.0671 | 95.0818 | 95.0573 | 95.0671 | 604027.0 |
| 2018-10-03 | ER | Futures | 98.372 | 98.377 | 98.372 | 98.377 | 36703.0 |
| 2018-10-03 | EW | Futures | 2105.0 | 2122.6 | 2103.2 | 2112.0 | 15366.0 |
| 2018-10-03 | FBON | Futures | 127.53 | 127.77 | 127.53 | 127.67 | 443.0 |
| 2018-10-03 | FBTP | Futures | 104.86 | 105.46 | 104.01 | 105.09 | 175510.0 |
| 2018-10-03 | FBTS | Futures | 101.422 | 101.947 | 101.197 | 101.787 | 162012.0 |
| 2018-10-03 | FCE | Futures | 4932.0 | 4965.4 | 4926.1 | 4946.9 | 64521.0 |
| 2018-10-03 | FESX | Futures | 2839.4 | 2867.1 | 2832.7 | 2857.0 | 677097.0 |
| 2018-10-03 | FGBL | Futures | 152.33 | 152.61 | 151.41 | 152.1 | 840412.0 |
| 2018-10-03 | FGBM | Futures | 130.62 | 130.74 | 130.18 | 130.48 | 624832.0 |
| 2018-10-03 | FGBS | Futures | 112.573 | 112.583 | 112.487 | 112.537 | 555389.0 |
| 2018-10-03 | FGBX | Futures | 176.14 | 176.64 | 174.53 | 175.82 | 56049.0 |
| 2018-10-03 | FMWO | Futures | 7293.8 | 7303.1 | 7282.2 | 7298.5 | 1628.0 |
| 2018-10-03 | FOAT | Futures | 139.85 | 140.03 | 139.52 | 139.66 | 157055.0 |
| 2018-10-03 | FTI | Futures | 510.04 | 514.87 | 510.04 | 512.92 | 18991.0 |
| 2018-10-03 | FTUK | Futures | 6657.6 | 6701.8 | 6650.0 | 6688.4 | 79850.0 |
| 2018-10-03 | FVSA | Futures | 263.98 | 265.7 | 255.35 | 257.94 | 22567.0 |
| 2018-10-03 | FXXP | Futures | 329.6 | 332.7 | 329.6 | 331.9 | 32530.0 |
| 2018-10-03 | G | Futures | 113.89 | 114.16 | 113.64 | 113.87 | 232819.0 |
| 2018-10-03 | GF | Futures | 330.348 | 330.348 | 328.216 | 328.424 | 1369.0 |
| 2018-10-03 | GSCI | Futures | 556.5 | 563.45 | 556.5 | 563.45 | 640.0 |
| 2018-10-03 | HE | Futures | 79.323 | 79.525 | 75.8 | 76.706 | 24309.0 |
| 2018-10-03 | HG | Futures | 3.2257 | 3.2712 | 3.2216 | 3.2648 | 81359.0 |
| 2018-10-03 | HH | Futures | 20.452 | 21.033 | 20.452 | 20.865 | 5707.0 |
> showing 50 of 113 rows — these rows as CSV