PREVIEW / futures_daily / 2020-03-30
file: by_date/futures_daily/2020/2020-03-30.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-03-30 | ES | Futures | 2720.85 | 2900.93 | 2705.36 | 2889.31 | 1837692.0 |
| 2020-03-30 | NQ | Futures | 8478.78 | 9038.53 | 8443.53 | 9005.0 | 419576.0 |
| 2020-03-30 | YM | Futures | 22329.2 | 23730.2 | 22171.2 | 23653.4 | 198019.0 |
| 2020-03-30 | CL | Futures | 20.74 | 20.74 | 19.1 | 19.91 | 758711.0 |
| 2020-03-30 | GC | Futures | 2017.2 | 2029.6 | 1979.2 | 1992.7 | 157366.0 |
| 2020-03-30 | ZN | Futures | 137.238127 | 137.701195 | 136.69788 | 137.145513 | 1259056.0 |
| 2020-03-30 | A6 | Futures | 0.63254 | 0.63552 | 0.62812 | 0.63223 | 74493.0 |
| 2020-03-30 | AD | Futures | 0.72212 | 0.72374 | 0.71497 | 0.71629 | 55786.0 |
| 2020-03-30 | ALI | Futures | 1865.65 | 1867.78 | 1865.65 | 1867.78 | 2.0 |
| 2020-03-30 | B | Futures | 20.91 | 21.09 | 19.38 | 20.24 | 350645.0 |
| 2020-03-30 | B6 | Futures | 1.2655 | 1.2685 | 1.2522 | 1.2591 | 78776.0 |
| 2020-03-30 | BR | Futures | 0.15993 | 0.16001 | 0.15755 | 0.15771 | 259.0 |
| 2020-03-30 | BTC | Futures | 8574.8 | 9269.9 | 8276.9 | 9050.0 | 4341.0 |
| 2020-03-30 | BZ | Futures | 20.25 | 20.31 | 18.81 | 19.63 | 38246.0 |
| 2020-03-30 | C | Futures | 1653.0 | 1657.0 | 1632.0 | 1634.0 | 4830.0 |
| 2020-03-30 | CB | Futures | 163.758 | 165.068 | 160.607 | 162.893 | 78.0 |
| 2020-03-30 | CC | Futures | 1468.0 | 1507.0 | 1468.0 | 1483.0 | 15668.0 |
| 2020-03-30 | CNH | Futures | 7.0355 | 7.0494 | 7.026 | 7.0411 | 774.0 |
| 2020-03-30 | CSC | Futures | 2.782 | 2.782 | 2.648 | 2.659 | 91.0 |
| 2020-03-30 | CT | Futures | 49.15 | 49.23 | 46.98 | 48.81 | 18721.0 |
| 2020-03-30 | DC | Futures | 22.2 | 22.27 | 21.07 | 21.18 | 500.0 |
| 2020-03-30 | DX | Futures | 95.179 | 96.161 | 95.146 | 96.002 | 11212.0 |
| 2020-03-30 | E1 | Futures | 1.20162 | 1.20333 | 1.18966 | 1.19126 | 23515.0 |
| 2020-03-30 | E6 | Futures | 1.19998 | 1.20197 | 1.18724 | 1.18907 | 149226.0 |
| 2020-03-30 | E7 | Futures | 1.194 | 1.1956 | 1.1811 | 1.1829 | 7600.0 |
| 2020-03-30 | EBM | Futures | 218.93 | 221.17 | 218.93 | 219.77 | 15802.0 |
| 2020-03-30 | ED | Futures | 96.1067 | 96.1502 | 96.0826 | 96.1406 | 304857.0 |
| 2020-03-30 | ER | Futures | 98.318 | 98.328 | 98.313 | 98.318 | 41536.0 |
| 2020-03-30 | EW | Futures | 1465.7 | 1542.2 | 1464.6 | 1540.3 | 12388.0 |
| 2020-03-30 | FBON | Futures | 142.84 | 143.14 | 142.21 | 142.65 | 417.0 |
| 2020-03-30 | FBTP | Futures | 128.58 | 128.67 | 126.79 | 127.09 | 65374.0 |
| 2020-03-30 | FBTS | Futures | 107.884 | 107.884 | 107.403 | 107.451 | 33140.0 |
| 2020-03-30 | FCE | Futures | 4271.5 | 4284.1 | 4084.6 | 4240.5 | 54230.0 |
| 2020-03-30 | FDAX | Futures | 9995.3 | 10426.2 | 9965.1 | 10323.7 | 101626.0 |
| 2020-03-30 | FDIV | Futures | 108.56 | 110.18 | 108.56 | 110.18 | 1.0 |
| 2020-03-30 | FDXM | Futures | 10047.8 | 10476.1 | 10012.7 | 10373.0 | 102685.0 |
| 2020-03-30 | FESX | Futures | 2405.6 | 2514.8 | 2390.9 | 2491.0 | 1122536.0 |
| 2020-03-30 | FGBL | Futures | 168.1 | 168.97 | 167.79 | 168.75 | 427578.0 |
| 2020-03-30 | FGBM | Futures | 134.68 | 134.99 | 134.52 | 134.86 | 254582.0 |
| 2020-03-30 | FGBS | Futures | 112.905 | 112.966 | 112.865 | 112.936 | 167867.0 |
| 2020-03-30 | FGBX | Futures | 226.38 | 228.26 | 224.34 | 227.41 | 41619.0 |
| 2020-03-30 | FMWO | Futures | 6376.3 | 6504.5 | 6239.8 | 6439.8 | 5847.0 |
| 2020-03-30 | FOAT | Futures | 153.17 | 153.86 | 152.95 | 153.66 | 105459.0 |
| 2020-03-30 | FTDX | Futures | 2569.0 | 2615.5 | 2506.3 | 2595.3 | 32.0 |
| 2020-03-30 | FTI | Futures | 440.69 | 446.88 | 425.69 | 445.53 | 26847.0 |
| 2020-03-30 | FTUK | Futures | 5043.4 | 5256.5 | 5021.7 | 5238.2 | 121701.0 |
| 2020-03-30 | FVSA | Futures | 414.99 | 445.6 | 405.99 | 414.09 | 11676.0 |
| 2020-03-30 | FXXP | Futures | 286.5 | 289.5 | 276.3 | 287.7 | 52656.0 |
| 2020-03-30 | G | Futures | 125.21 | 125.78 | 125.03 | 125.21 | 121090.0 |
| 2020-03-30 | GF | Futures | 248.389 | 253.321 | 244.236 | 249.272 | 1858.0 |
> showing 50 of 119 rows — these rows as CSV