PREVIEW / futures_daily / 2021-04-27
file: by_date/futures_daily/2021/2021-04-27.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-04-27 | ES | Futures | 4692.29 | 4704.63 | 4675.74 | 4689.48 | 992029.0 |
| 2021-04-27 | NQ | Futures | 16176.41 | 16205.54 | 16046.94 | 16093.66 | 412801.0 |
| 2021-04-27 | YM | Futures | 36679.3 | 36770.2 | 36544.0 | 36672.8 | 105771.0 |
| 2021-04-27 | CL | Futures | 44.12 | 45.07 | 44.08 | 44.81 | 361536.0 |
| 2021-04-27 | GC | Futures | 2088.1 | 2093.7 | 2079.6 | 2085.4 | 147945.0 |
| 2021-04-27 | ZN | Futures | 133.034059 | 133.065468 | 132.625738 | 132.704261 | 1418589.0 |
| 2021-04-27 | A6 | Futures | 0.80023 | 0.80038 | 0.79602 | 0.79643 | 71247.0 |
| 2021-04-27 | AD | Futures | 0.81744 | 0.81789 | 0.81592 | 0.81673 | 55277.0 |
| 2021-04-27 | ALI | Futures | 2742.94 | 2759.5 | 2741.51 | 2757.79 | 196.0 |
| 2021-04-27 | B | Futures | 42.71 | 43.31 | 42.57 | 43.08 | 299460.0 |
| 2021-04-27 | B6 | Futures | 1.4111 | 1.4141 | 1.4074 | 1.4119 | 60451.0 |
| 2021-04-27 | BFX | Futures | 4082.5 | 4082.5 | 4067.1 | 4080.9 | 4.0 |
| 2021-04-27 | BR | Futures | 0.14574 | 0.14625 | 0.14443 | 0.14443 | 10550.0 |
| 2021-04-27 | BTC | Futures | 74077.0 | 76776.9 | 73448.7 | 75920.7 | 2610.0 |
| 2021-04-27 | BZ | Futures | 41.53 | 42.27 | 41.53 | 42.04 | 37539.0 |
| 2021-04-27 | C | Futures | 1488.0 | 1488.0 | 1474.0 | 1484.0 | 1386.0 |
| 2021-04-27 | CB | Futures | 150.48 | 151.512 | 150.48 | 151.512 | 9.0 |
| 2021-04-27 | CC | Futures | 1656.0 | 1662.0 | 1629.0 | 1651.0 | 15298.0 |
| 2021-04-27 | CNH | Futures | 6.2924 | 6.3025 | 6.2924 | 6.2982 | 421.0 |
| 2021-04-27 | CSC | Futures | 2.978 | 2.987 | 2.949 | 2.955 | 72.0 |
| 2021-04-27 | CT | Futures | 83.17 | 85.47 | 82.72 | 85.24 | 15772.0 |
| 2021-04-27 | DC | Futures | 27.49 | 27.66 | 27.37 | 27.55 | 174.0 |
| 2021-04-27 | DX | Futures | 87.794 | 87.982 | 87.731 | 87.835 | 12890.0 |
| 2021-04-27 | E1 | Futures | 1.23252 | 1.2351 | 1.22858 | 1.23252 | 16549.0 |
| 2021-04-27 | E6 | Futures | 1.28949 | 1.28986 | 1.28603 | 1.28922 | 126390.0 |
| 2021-04-27 | E7 | Futures | 1.2827 | 1.2834 | 1.2795 | 1.2827 | 3207.0 |
| 2021-04-27 | EBM | Futures | 318.34 | 322.81 | 313.87 | 315.78 | 10646.0 |
| 2021-04-27 | ED | Futures | 96.4932 | 96.498 | 96.4883 | 96.4932 | 106082.0 |
| 2021-04-27 | ER | Futures | 98.46 | 98.46 | 98.45 | 98.455 | 53631.0 |
| 2021-04-27 | ESG | Futures | 388.32 | 388.52 | 386.9 | 388.12 | 380.0 |
| 2021-04-27 | EW | Futures | 2946.4 | 2959.0 | 2936.4 | 2951.8 | 7099.0 |
| 2021-04-27 | FBON | Futures | 147.84 | 147.94 | 147.68 | 147.74 | 386.0 |
| 2021-04-27 | FBTP | Futures | 137.55 | 137.7 | 137.28 | 137.42 | 147582.0 |
| 2021-04-27 | FBTS | Futures | 109.981 | 110.01 | 109.952 | 109.971 | 88073.0 |
| 2021-04-27 | FCE | Futures | 6149.8 | 6151.3 | 6122.1 | 6141.9 | 35145.0 |
| 2021-04-27 | FDAX | Futures | 16318.1 | 16340.5 | 16204.0 | 16270.1 | 41376.0 |
| 2021-04-27 | FDIV | Futures | 183.73 | 183.73 | 183.28 | 183.53 | 77.0 |
| 2021-04-27 | FDXM | Futures | 16271.6 | 16320.6 | 16183.2 | 16250.3 | 44086.0 |
| 2021-04-27 | FDXS | Futures | 16195.5 | 16231.5 | 16101.2 | 16163.7 | 1097.0 |
| 2021-04-27 | FESX | Futures | 3751.6 | 3762.0 | 3738.4 | 3743.1 | 638573.0 |
| 2021-04-27 | FGBL | Futures | 166.95 | 167.1 | 166.71 | 166.96 | 564463.0 |
| 2021-04-27 | FGBM | Futures | 134.62 | 134.67 | 134.56 | 134.62 | 344736.0 |
| 2021-04-27 | FGBS | Futures | 112.634 | 112.644 | 112.624 | 112.634 | 158434.0 |
| 2021-04-27 | FGBX | Futures | 217.32 | 217.91 | 216.75 | 217.38 | 64062.0 |
| 2021-04-27 | FMWO | Futures | 10390.9 | 10392.1 | 10356.9 | 10368.6 | 1180.0 |
| 2021-04-27 | FOAT | Futures | 155.27 | 155.4 | 155.03 | 155.24 | 157598.0 |
| 2021-04-27 | FTDX | Futures | 3643.1 | 3651.9 | 3634.9 | 3637.5 | 106.0 |
| 2021-04-27 | FTI | Futures | 674.82 | 674.96 | 669.04 | 671.5 | 14628.0 |
| 2021-04-27 | FTUK | Futures | 6755.4 | 6764.2 | 6714.5 | 6717.9 | 68522.0 |
| 2021-04-27 | FVSA | Futures | 99.57 | 102.73 | 98.78 | 101.68 | 12415.0 |
> showing 50 of 122 rows — these rows as CSV