PREVIEW / futures_daily / 2018-12-10
file: by_date/futures_daily/2018/2018-12-10.parquet size: 9 KB rows: 107
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-12-10 | ES | Futures | 2846.84 | 2872.33 | 2801.29 | 2866.36 | 2564357.0 |
| 2018-12-10 | NQ | Futures | 7661.71 | 7799.07 | 7590.86 | 7781.35 | 778327.0 |
| 2018-12-10 | YM | Futures | 25728.0 | 25884.1 | 25230.1 | 25851.4 | 4044.0 |
| 2018-12-10 | CL | Futures | 55.05 | 55.87 | 53.46 | 53.96 | 733225.0 |
| 2018-12-10 | GC | Futures | 1582.1 | 1583.3 | 1571.1 | 1574.2 | 199740.0 |
| 2018-12-10 | ZN | Futures | 120.288825 | 120.444438 | 120.070967 | 120.164335 | 2156718.0 |
| 2018-12-10 | A6 | Futures | 0.74187 | 0.74569 | 0.74074 | 0.74156 | 14912.0 |
| 2018-12-10 | AD | Futures | 0.76137 | 0.76324 | 0.75635 | 0.75656 | 44428.0 |
| 2018-12-10 | B | Futures | 45.04 | 45.77 | 43.77 | 44.03 | 264954.0 |
| 2018-12-10 | B6 | Futures | 1.3119 | 1.3166 | 1.2909 | 1.296 | 82836.0 |
| 2018-12-10 | BTC | Futures | 5332.8 | 5462.5 | 5081.1 | 5149.7 | 1918.0 |
| 2018-12-10 | BZ | Futures | 44.54 | 45.16 | 43.17 | 43.47 | 34114.0 |
| 2018-12-10 | C | Futures | 1431.0 | 1440.0 | 1413.0 | 1434.0 | 11359.0 |
| 2018-12-10 | CB | Futures | 267.581 | 267.581 | 266.184 | 266.67 | 121.0 |
| 2018-12-10 | CC | Futures | 1529.0 | 1537.0 | 1505.0 | 1520.0 | 16480.0 |
| 2018-12-10 | CNH | Futures | 6.9213 | 6.9407 | 6.9135 | 6.9393 | 253.0 |
| 2018-12-10 | CSC | Futures | 2.829 | 2.829 | 2.81 | 2.81 | 47.0 |
| 2018-12-10 | CT | Futures | 87.53 | 87.8 | 86.44 | 87.01 | 11456.0 |
| 2018-12-10 | DC | Futures | 23.78 | 23.86 | 23.59 | 23.64 | 178.0 |
| 2018-12-10 | DX | Futures | 91.65 | 92.204 | 91.34 | 92.187 | 17805.0 |
| 2018-12-10 | E1 | Futures | 1.19888 | 1.20323 | 1.19865 | 1.1997 | 12463.0 |
| 2018-12-10 | E6 | Futures | 1.27077 | 1.27536 | 1.2653 | 1.26547 | 132921.0 |
| 2018-12-10 | E7 | Futures | 1.2646 | 1.2689 | 1.259 | 1.2593 | 3414.0 |
| 2018-12-10 | EBM | Futures | 209.23 | 210.25 | 208.71 | 209.74 | 15116.0 |
| 2018-12-10 | ED | Futures | 94.9256 | 94.9598 | 94.9109 | 94.9402 | 481596.0 |
| 2018-12-10 | ER | Futures | 98.391 | 98.396 | 98.386 | 98.396 | 82845.0 |
| 2018-12-10 | EW | Futures | 1872.0 | 1892.8 | 1872.0 | 1889.3 | 166.0 |
| 2018-12-10 | FBON | Futures | 129.09 | 129.18 | 128.89 | 129.17 | 383.0 |
| 2018-12-10 | FBTP | Futures | 108.05 | 108.54 | 107.56 | 108.32 | 52294.0 |
| 2018-12-10 | FBTS | Futures | 103.761 | 103.941 | 103.525 | 103.827 | 41598.0 |
| 2018-12-10 | FCE | Futures | 4265.9 | 4299.5 | 4227.9 | 4238.2 | 123947.0 |
| 2018-12-10 | FDAX | Futures | 11199.9 | 11311.9 | 11126.8 | 11145.2 | 130631.0 |
| 2018-12-10 | FDXM | Futures | 11176.9 | 11268.1 | 11089.9 | 11103.0 | 696.0 |
| 2018-12-10 | FESX | Futures | 2571.4 | 2594.5 | 2554.3 | 2557.7 | 92440.0 |
| 2018-12-10 | FGBL | Futures | 155.45 | 155.59 | 154.96 | 155.36 | 673797.0 |
| 2018-12-10 | FGBM | Futures | 131.81 | 131.86 | 131.53 | 131.65 | 521898.0 |
| 2018-12-10 | FGBS | Futures | 112.678 | 112.693 | 112.603 | 112.643 | 581080.0 |
| 2018-12-10 | FGBX | Futures | 183.9 | 184.69 | 183.05 | 184.59 | 61198.0 |
| 2018-12-10 | FMWO | Futures | 6500.1 | 6522.1 | 6408.6 | 6419.0 | 7320.0 |
| 2018-12-10 | FOAT | Futures | 141.64 | 141.64 | 141.1 | 141.5 | 168105.0 |
| 2018-12-10 | FTDX | Futures | 2475.2 | 2475.7 | 2460.3 | 2460.3 | 4.0 |
| 2018-12-10 | FTI | Futures | 467.67 | 469.77 | 462.05 | 463.24 | 179.0 |
| 2018-12-10 | FTUK | Futures | 6071.3 | 6141.5 | 6053.6 | 6070.9 | 8822.0 |
| 2018-12-10 | FVSA | Futures | 409.24 | 429.4 | 400.17 | 426.38 | 47489.0 |
| 2018-12-10 | FXXP | Futures | 299.5 | 299.8 | 295.7 | 295.7 | 4151.0 |
| 2018-12-10 | G | Futures | 117.11 | 117.99 | 116.99 | 117.77 | 290042.0 |
| 2018-12-10 | GF | Futures | 311.589 | 313.526 | 310.943 | 312.181 | 5066.0 |
| 2018-12-10 | GSCI | Futures | 468.66 | 468.66 | 465.01 | 465.01 | 2590.0 |
| 2018-12-10 | HE | Futures | 81.594 | 81.955 | 80.121 | 80.361 | 15895.0 |
| 2018-12-10 | HG | Futures | 3.1536 | 3.1744 | 3.1288 | 3.1346 | 56322.0 |
> showing 50 of 107 rows — these rows as CSV