PREVIEW / futures_daily / 2010-02-02
file: by_date/futures_daily/2010/2010-02-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-02-02 | ES | Futures | 1052.71 | 1067.73 | 1048.83 | 1063.57 | 2104398.0 |
| 2010-02-02 | NQ | Futures | 1986.4 | 2011.0 | 1976.79 | 2000.82 | 331528.0 |
| 2010-02-02 | YM | Futures | 9259.5 | 9377.3 | 9228.5 | 9339.0 | 137521.0 |
| 2010-02-02 | CL | Futures | 177.01 | 182.84 | 175.73 | 182.42 | 366269.0 |
| 2010-02-02 | GC | Futures | 1519.3 | 1536.5 | 1508.6 | 1533.9 | 154491.0 |
| 2010-02-02 | ZN | Futures | 94.995623 | 95.146749 | 94.831902 | 95.121562 | 611935.0 |
| 2010-02-02 | A6 | Futures | 0.72201 | 0.72225 | 0.71055 | 0.71648 | 112015.0 |
| 2010-02-02 | AD | Futures | 0.93049 | 0.93434 | 0.92763 | 0.93177 | 72882.0 |
| 2010-02-02 | B | Futures | 66.64 | 68.86 | 66.05 | 68.76 | 92048.0 |
| 2010-02-02 | B6 | Futures | 1.6576 | 1.661 | 1.6513 | 1.6587 | 98193.0 |
| 2010-02-02 | BFX | Futures | 2864.8 | 2876.9 | 2852.4 | 2876.9 | 175.0 |
| 2010-02-02 | BR | Futures | 0.21841 | 0.21998 | 0.21823 | 0.21998 | 574.0 |
| 2010-02-02 | C | Futures | 2259.0 | 2262.0 | 2188.0 | 2245.0 | 15672.0 |
| 2010-02-02 | CB | Futures | 70.323 | 70.446 | 69.583 | 69.829 | 56.0 |
| 2010-02-02 | CC | Futures | 2708.0 | 2708.0 | 2610.0 | 2689.0 | 10302.0 |
| 2010-02-02 | CT | Futures | 55.64 | 56.63 | 55.59 | 56.47 | 9830.0 |
| 2010-02-02 | DC | Futures | 21.97 | 22.28 | 21.88 | 22.18 | 303.0 |
| 2010-02-02 | DX | Futures | 80.756 | 80.928 | 80.476 | 80.522 | 15457.0 |
| 2010-02-02 | E1 | Futures | 1.24871 | 1.25122 | 1.24331 | 1.25016 | 39142.0 |
| 2010-02-02 | E6 | Futures | 1.64935 | 1.65432 | 1.64367 | 1.65302 | 265894.0 |
| 2010-02-02 | E7 | Futures | 1.6379 | 1.6428 | 1.6324 | 1.6415 | 2624.0 |
| 2010-02-02 | EBM | Futures | 212.93 | 214.2 | 212.5 | 213.35 | 4359.0 |
| 2010-02-02 | ED | Futures | 94.3725 | 94.3773 | 94.3678 | 94.3725 | 105336.0 |
| 2010-02-02 | ER | Futures | 97.296 | 97.306 | 97.291 | 97.301 | 98450.0 |
| 2010-02-02 | EW | Futures | 690.4 | 702.7 | 688.2 | 699.6 | 28749.0 |
| 2010-02-02 | FBTP | Futures | 63.47 | 63.5 | 63.36 | 63.41 | 7426.0 |
| 2010-02-02 | FCE | Futures | 2443.3 | 2494.8 | 2433.2 | 2482.7 | 132380.0 |
| 2010-02-02 | FDAX | Futures | 6163.1 | 6267.4 | 6145.0 | 6245.5 | 158193.0 |
| 2010-02-02 | FESX | Futures | 1668.2 | 1704.2 | 1662.3 | 1695.2 | 1312626.0 |
| 2010-02-02 | FEU3 | Futures | 97.86 | 97.869 | 97.86 | 97.865 | 787.0 |
| 2010-02-02 | FGBL | Futures | 95.21 | 95.29 | 94.98 | 95.2 | 904157.0 |
| 2010-02-02 | FGBM | Futures | 100.81 | 100.86 | 100.68 | 100.79 | 395929.0 |
| 2010-02-02 | FGBS | Futures | 105.693 | 105.703 | 105.64 | 105.683 | 415328.0 |
| 2010-02-02 | FGBX | Futures | 89.73 | 89.78 | 89.35 | 89.69 | 2471.0 |
| 2010-02-02 | FTDX | Futures | 718.6 | 732.3 | 716.8 | 727.9 | 1225.0 |
| 2010-02-02 | FTI | Futures | 267.66 | 271.72 | 266.8 | 270.38 | 37393.0 |
| 2010-02-02 | FTUK | Futures | 3482.8 | 3528.7 | 3458.0 | 3507.9 | 110516.0 |
| 2010-02-02 | G | Futures | 75.87 | 76.1 | 75.86 | 75.97 | 66576.0 |
| 2010-02-02 | GF | Futures | 264.177 | 265.865 | 262.624 | 262.624 | 3190.0 |
| 2010-02-02 | GSCI | Futures | 924.12 | 950.0 | 924.12 | 947.48 | 645.0 |
| 2010-02-02 | HE | Futures | 88.516 | 90.156 | 88.115 | 89.453 | 15078.0 |
| 2010-02-02 | HG | Futures | 4.289 | 4.3104 | 4.2117 | 4.2621 | 32704.0 |
| 2010-02-02 | HO | Futures | 1.8334 | 1.8968 | 1.8174 | 1.8914 | 52681.0 |
| 2010-02-02 | HRC | Futures | 2801.1 | 2801.1 | 2801.1 | 2801.1 | 0.0 |
| 2010-02-02 | J1 | Futures | 0.013878 | 0.0139435 | 0.013844 | 0.0139284 | 100942.0 |
| 2010-02-02 | J7 | Futures | 0.013683 | 0.013768 | 0.013673 | 0.013754 | 45.0 |
| 2010-02-02 | JB | Futures | 117.7 | 117.73 | 117.39 | 117.49 | 2147.0 |
| 2010-02-02 | KC | Futures | 345.8 | 353.09 | 344.11 | 351.53 | 15030.0 |
| 2010-02-02 | KE | Futures | 2197.9 | 2274.78 | 2197.9 | 2256.69 | 6547.0 |
| 2010-02-02 | KRW | Futures | 0.0008465 | 0.0008465 | 0.0008423 | 0.0008423 | 10.0 |
> showing 50 of 91 rows — these rows as CSV