PREVIEW / futures_daily / 2010-01-19
file: by_date/futures_daily/2010/2010-01-19.parquet size: 9 KB rows: 92
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-01-19 | ES | Futures | 1097.06 | 1111.84 | 1091.73 | 1110.63 | 1927993.0 |
| 2010-01-19 | NQ | Futures | 2105.73 | 2144.18 | 2100.92 | 2137.4 | 333010.0 |
| 2010-01-19 | YM | Futures | 9646.8 | 9761.9 | 9608.4 | 9746.4 | 118550.0 |
| 2010-01-19 | CL | Futures | 184.73 | 187.71 | 182.01 | 187.35 | 351108.0 |
| 2010-01-19 | GC | Futures | 1556.3 | 1570.1 | 1551.9 | 1569.1 | 188027.0 |
| 2010-01-19 | ZN | Futures | 94.554837 | 94.731151 | 94.252584 | 94.365929 | 848586.0 |
| 2010-01-19 | A6 | Futures | 0.74387 | 0.74964 | 0.74119 | 0.74663 | 97374.0 |
| 2010-01-19 | AD | Futures | 0.95863 | 0.96336 | 0.95389 | 0.95734 | 69101.0 |
| 2010-01-19 | B | Futures | 70.04 | 70.6 | 68.35 | 70.4 | 197333.0 |
| 2010-01-19 | B6 | Futures | 1.6894 | 1.709 | 1.6872 | 1.6987 | 167277.0 |
| 2010-01-19 | BFX | Futures | 2880.0 | 2885.9 | 2857.4 | 2878.7 | 76.0 |
| 2010-01-19 | BR | Futures | 0.22611 | 0.22611 | 0.22611 | 0.22611 | 10.0 |
| 2010-01-19 | BZ | Futures | 72.31 | 72.31 | 72.31 | 72.31 | 200.0 |
| 2010-01-19 | C | Futures | 2328.0 | 2354.0 | 2319.0 | 2352.0 | 5453.0 |
| 2010-01-19 | CB | Futures | 76.985 | 76.985 | 74.518 | 74.518 | 74.0 |
| 2010-01-19 | CC | Futures | 2945.0 | 2984.0 | 2923.0 | 2973.0 | 8455.0 |
| 2010-01-19 | CT | Futures | 58.86 | 59.22 | 58.32 | 58.41 | 10279.0 |
| 2010-01-19 | DC | Futures | 24.35 | 24.68 | 23.97 | 24.38 | 316.0 |
| 2010-01-19 | DX | Futures | 78.473 | 79.174 | 78.396 | 78.966 | 14046.0 |
| 2010-01-19 | E1 | Futures | 1.28326 | 1.28998 | 1.27363 | 1.27772 | 75768.0 |
| 2010-01-19 | E6 | Futures | 1.6986 | 1.70629 | 1.68688 | 1.69173 | 345534.0 |
| 2010-01-19 | E7 | Futures | 1.687 | 1.6944 | 1.675 | 1.68 | 4209.0 |
| 2010-01-19 | EBM | Futures | 213.35 | 214.2 | 212.08 | 212.93 | 5219.0 |
| 2010-01-19 | ED | Futures | 94.382 | 94.382 | 94.3725 | 94.3773 | 148760.0 |
| 2010-01-19 | ER | Futures | 97.326 | 97.326 | 97.316 | 97.321 | 121338.0 |
| 2010-01-19 | EW | Futures | 720.1 | 729.9 | 718.6 | 728.2 | 24997.0 |
| 2010-01-19 | FBTP | Futures | 63.37 | 63.42 | 63.24 | 63.31 | 3956.0 |
| 2010-01-19 | FCE | Futures | 2585.6 | 2626.6 | 2558.9 | 2612.0 | 117702.0 |
| 2010-01-19 | FDAX | Futures | 6450.4 | 6559.0 | 6392.5 | 6529.6 | 160023.0 |
| 2010-01-19 | FESX | Futures | 1764.0 | 1797.5 | 1748.5 | 1785.6 | 1276988.0 |
| 2010-01-19 | FEU3 | Futures | 97.884 | 97.889 | 97.879 | 97.884 | 1143.0 |
| 2010-01-19 | FGBL | Futures | 94.63 | 94.72 | 94.29 | 94.44 | 766388.0 |
| 2010-01-19 | FGBM | Futures | 100.35 | 100.38 | 100.08 | 100.19 | 481749.0 |
| 2010-01-19 | FGBS | Futures | 105.581 | 105.601 | 105.474 | 105.508 | 549805.0 |
| 2010-01-19 | FGBX | Futures | 88.19 | 88.35 | 87.63 | 87.76 | 2470.0 |
| 2010-01-19 | FTDX | Futures | 736.7 | 746.9 | 727.0 | 740.7 | 842.0 |
| 2010-01-19 | FTI | Futures | 274.28 | 278.3 | 271.96 | 276.8 | 33685.0 |
| 2010-01-19 | FTUK | Futures | 3637.9 | 3681.4 | 3607.4 | 3665.3 | 107500.0 |
| 2010-01-19 | G | Futures | 75.62 | 75.66 | 74.98 | 75.14 | 115868.0 |
| 2010-01-19 | GF | Futures | 266.81 | 269.241 | 266.743 | 269.241 | 1803.0 |
| 2010-01-19 | GSCI | Futures | 971.58 | 978.59 | 956.45 | 977.47 | 942.0 |
| 2010-01-19 | HE | Futures | 98.385 | 99.422 | 98.385 | 99.054 | 12058.0 |
| 2010-01-19 | HG | Futures | 4.6477 | 4.7732 | 4.6325 | 4.7553 | 26382.0 |
| 2010-01-19 | HO | Futures | 1.9157 | 1.9237 | 1.8723 | 1.9168 | 39032.0 |
| 2010-01-19 | HRC | Futures | 2729.2 | 2729.2 | 2729.2 | 2729.2 | 0.0 |
| 2010-01-19 | J1 | Futures | 0.0138453 | 0.0139384 | 0.0137912 | 0.0138176 | 132113.0 |
| 2010-01-19 | J7 | Futures | 0.013676 | 0.013761 | 0.013617 | 0.013645 | 91.0 |
| 2010-01-19 | JB | Futures | 117.57 | 117.69 | 117.52 | 117.59 | 1051.0 |
| 2010-01-19 | KC | Futures | 367.01 | 370.27 | 364.8 | 366.75 | 8313.0 |
| 2010-01-19 | KE | Futures | 2314.35 | 2340.36 | 2268.0 | 2283.83 | 10171.0 |
> showing 50 of 92 rows — these rows as CSV