PREVIEW / futures_daily / 2010-11-02
file: by_date/futures_daily/2010/2010-11-02.parquet size: 9 KB rows: 91
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-02 | ES | Futures | 1159.29 | 1169.82 | 1157.33 | 1169.09 | 1573659.0 |
| 2010-11-02 | NQ | Futures | 2413.21 | 2442.12 | 2410.94 | 2438.15 | 227217.0 |
| 2010-11-02 | YM | Futures | 10319.2 | 10395.5 | 10304.3 | 10376.8 | 87127.0 |
| 2010-11-02 | CL | Futures | 170.87 | 174.15 | 170.77 | 172.97 | 281834.0 |
| 2010-11-02 | GC | Futures | 1837.2 | 1848.5 | 1835.3 | 1844.4 | 116112.0 |
| 2010-11-02 | ZN | Futures | 104.264429 | 104.561221 | 104.212813 | 104.496701 | 722049.0 |
| 2010-11-02 | A6 | Futures | 0.82452 | 0.83711 | 0.82385 | 0.83442 | 84736.0 |
| 2010-11-02 | AD | Futures | 0.97469 | 0.98182 | 0.97449 | 0.98093 | 67061.0 |
| 2010-11-02 | B | Futures | 72.34 | 73.23 | 72.12 | 72.83 | 114858.0 |
| 2010-11-02 | B6 | Futures | 1.6644 | 1.6688 | 1.6566 | 1.6629 | 85373.0 |
| 2010-11-02 | BFX | Futures | 3055.1 | 3083.0 | 3055.1 | 3072.2 | 254.0 |
| 2010-11-02 | BR | Futures | 0.2502 | 0.2502 | 0.2502 | 0.2502 | 8.0 |
| 2010-11-02 | BZ | Futures | 76.38 | 77.31 | 76.38 | 77.04 | 210.0 |
| 2010-11-02 | C | Futures | 2024.0 | 2043.0 | 2014.0 | 2041.0 | 4229.0 |
| 2010-11-02 | CB | Futures | 104.422 | 104.422 | 104.422 | 104.422 | 1.0 |
| 2010-11-02 | CC | Futures | 2287.0 | 2325.0 | 2287.0 | 2322.0 | 8654.0 |
| 2010-11-02 | CT | Futures | 110.04 | 113.64 | 109.57 | 113.64 | 6069.0 |
| 2010-11-02 | DC | Futures | 23.53 | 23.76 | 23.43 | 23.59 | 372.0 |
| 2010-11-02 | DX | Futures | 77.601 | 77.742 | 77.055 | 77.137 | 21288.0 |
| 2010-11-02 | E1 | Futures | 1.32422 | 1.34614 | 1.32212 | 1.34102 | 39449.0 |
| 2010-11-02 | E6 | Futures | 1.643 | 1.66216 | 1.64123 | 1.65944 | 332627.0 |
| 2010-11-02 | E7 | Futures | 1.6305 | 1.6495 | 1.6289 | 1.6468 | 4604.0 |
| 2010-11-02 | ED | Futures | 94.7363 | 94.7458 | 94.7316 | 94.7458 | 89816.0 |
| 2010-11-02 | ER | Futures | 97.188 | 97.193 | 97.178 | 97.178 | 117939.0 |
| 2010-11-02 | EW | Futures | 813.9 | 823.5 | 813.0 | 822.1 | 22579.0 |
| 2010-11-02 | FBTP | Futures | 67.1 | 67.12 | 66.91 | 66.96 | 5171.0 |
| 2010-11-02 | FCE | Futures | 2537.3 | 2568.9 | 2533.3 | 2559.6 | 110836.0 |
| 2010-11-02 | FDAX | Futures | 7109.1 | 7189.2 | 7102.1 | 7167.7 | 110579.0 |
| 2010-11-02 | FESX | Futures | 1761.9 | 1785.0 | 1757.5 | 1780.6 | 895671.0 |
| 2010-11-02 | FEU3 | Futures | 97.746 | 97.751 | 97.741 | 97.741 | 131.0 |
| 2010-11-02 | FGBL | Futures | 102.56 | 102.87 | 102.46 | 102.63 | 803273.0 |
| 2010-11-02 | FGBM | Futures | 105.73 | 105.86 | 105.65 | 105.73 | 400736.0 |
| 2010-11-02 | FGBS | Futures | 107.189 | 107.233 | 107.169 | 107.189 | 392573.0 |
| 2010-11-02 | FGBX | Futures | 106.45 | 107.68 | 106.16 | 107.12 | 4990.0 |
| 2010-11-02 | FTDX | Futures | 723.1 | 725.3 | 718.7 | 722.7 | 223.0 |
| 2010-11-02 | FTI | Futures | 271.01 | 273.82 | 270.53 | 273.41 | 30713.0 |
| 2010-11-02 | FTUK | Futures | 3918.7 | 3978.1 | 3916.9 | 3969.8 | 101775.0 |
| 2010-11-02 | G | Futures | 84.04 | 84.3 | 84.0 | 84.13 | 104223.0 |
| 2010-11-02 | GF | Futures | 278.215 | 280.985 | 278.089 | 280.859 | 934.0 |
| 2010-11-02 | GSCI | Futures | 951.22 | 951.3 | 946.19 | 949.41 | 425.0 |
| 2010-11-02 | HE | Futures | 89.686 | 90.058 | 88.333 | 89.584 | 18773.0 |
| 2010-11-02 | HG | Futures | 5.0518 | 5.1265 | 5.0318 | 5.1239 | 24340.0 |
| 2010-11-02 | HO | Futures | 1.9218 | 1.948 | 1.9191 | 1.9349 | 43840.0 |
| 2010-11-02 | HRC | Futures | 2504.7 | 2504.7 | 2504.7 | 2504.7 | 0.0 |
| 2010-11-02 | J1 | Futures | 0.0156058 | 0.0156159 | 0.0155179 | 0.0155769 | 78045.0 |
| 2010-11-02 | J7 | Futures | 0.015483 | 0.015505 | 0.015414 | 0.01547 | 309.0 |
| 2010-11-02 | JB | Futures | 121.84 | 121.94 | 121.65 | 121.88 | 1925.0 |
| 2010-11-02 | KC | Futures | 491.39 | 496.97 | 490.28 | 494.49 | 7540.0 |
| 2010-11-02 | KE | Futures | 3148.87 | 3187.46 | 3118.62 | 3122.79 | 8430.0 |
| 2010-11-02 | L | Futures | 98.165 | 98.175 | 98.155 | 98.165 | 12048.0 |
> showing 50 of 91 rows — these rows as CSV