PREVIEW / futures_daily / 2010-11-29
file: by_date/futures_daily/2010/2010-11-29.parquet size: 9 KB rows: 93
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-29 | ES | Futures | 1164.92 | 1170.07 | 1148.99 | 1162.96 | 2491942.0 |
| 2010-11-29 | NQ | Futures | 2437.87 | 2449.49 | 2401.3 | 2432.77 | 294225.0 |
| 2010-11-29 | YM | Futures | 10286.6 | 10342.4 | 10157.2 | 10271.7 | 138527.0 |
| 2010-11-29 | CL | Futures | 172.28 | 176.39 | 171.65 | 176.04 | 335800.0 |
| 2010-11-29 | GC | Futures | 1855.4 | 1863.1 | 1841.1 | 1858.8 | 184840.0 |
| 2010-11-29 | ZN | Futures | 102.819179 | 103.206299 | 102.651427 | 103.128875 | 1230867.0 |
| 2010-11-29 | A6 | Futures | 0.8105 | 0.81268 | 0.80144 | 0.80672 | 110502.0 |
| 2010-11-29 | AD | Futures | 0.97202 | 0.9741 | 0.96548 | 0.97162 | 77459.0 |
| 2010-11-29 | B | Futures | 72.87 | 74.4 | 72.77 | 74.27 | 66913.0 |
| 2010-11-29 | B6 | Futures | 1.6199 | 1.6241 | 1.6118 | 1.6158 | 89254.0 |
| 2010-11-29 | BFX | Futures | 2992.3 | 3007.9 | 2899.4 | 2925.0 | 603.0 |
| 2010-11-29 | BR | Futures | 0.24485 | 0.24638 | 0.24442 | 0.24638 | 361.0 |
| 2010-11-29 | BZ | Futures | 78.51 | 78.71 | 78.46 | 78.71 | 285.0 |
| 2010-11-29 | C | Futures | 2052.0 | 2059.0 | 2023.0 | 2023.0 | 1270.0 |
| 2010-11-29 | CB | Futures | 92.402 | 92.402 | 91.962 | 91.962 | 6.0 |
| 2010-11-29 | CC | Futures | 2297.0 | 2309.0 | 2232.0 | 2236.0 | 6367.0 |
| 2010-11-29 | CSC | Futures | 3.397 | 3.397 | 3.365 | 3.39 | 6.0 |
| 2010-11-29 | CT | Futures | 96.25 | 99.26 | 96.13 | 99.26 | 8746.0 |
| 2010-11-29 | DC | Futures | 22.95 | 23.05 | 22.93 | 22.96 | 66.0 |
| 2010-11-29 | DX | Futures | 80.531 | 81.474 | 80.405 | 81.16 | 38172.0 |
| 2010-11-29 | E1 | Futures | 1.30951 | 1.31463 | 1.30715 | 1.31253 | 37680.0 |
| 2010-11-29 | E6 | Futures | 1.57002 | 1.57345 | 1.54518 | 1.55145 | 430369.0 |
| 2010-11-29 | E7 | Futures | 1.558 | 1.5616 | 1.5336 | 1.5397 | 6505.0 |
| 2010-11-29 | ED | Futures | 94.6936 | 94.7316 | 94.6912 | 94.7078 | 288446.0 |
| 2010-11-29 | ER | Futures | 97.257 | 97.271 | 97.252 | 97.257 | 95144.0 |
| 2010-11-29 | EW | Futures | 846.5 | 847.0 | 831.2 | 842.3 | 27402.0 |
| 2010-11-29 | FBTP | Futures | 64.89 | 64.96 | 63.74 | 64.02 | 10669.0 |
| 2010-11-29 | FCE | Futures | 2499.0 | 2527.1 | 2424.6 | 2435.3 | 201811.0 |
| 2010-11-29 | FDAX | Futures | 7380.1 | 7432.8 | 7192.4 | 7228.5 | 233240.0 |
| 2010-11-29 | FESX | Futures | 1708.2 | 1731.3 | 1657.0 | 1670.1 | 1989512.0 |
| 2010-11-29 | FEU3 | Futures | 97.825 | 97.825 | 97.82 | 97.82 | 6.0 |
| 2010-11-29 | FGBL | Futures | 100.61 | 100.79 | 100.18 | 100.48 | 897160.0 |
| 2010-11-29 | FGBM | Futures | 105.46 | 105.65 | 105.24 | 105.45 | 515521.0 |
| 2010-11-29 | FGBS | Futures | 107.499 | 107.548 | 107.41 | 107.519 | 507882.0 |
| 2010-11-29 | FGBX | Futures | 101.44 | 101.99 | 100.68 | 101.46 | 3584.0 |
| 2010-11-29 | FTDX | Futures | 697.2 | 705.1 | 682.2 | 683.5 | 1739.0 |
| 2010-11-29 | FTI | Futures | 270.86 | 273.19 | 264.46 | 265.43 | 50599.0 |
| 2010-11-29 | FTUK | Futures | 3918.3 | 3955.6 | 3823.6 | 3848.9 | 153225.0 |
| 2010-11-29 | FXXP | Futures | 170.5 | 170.5 | 170.1 | 170.1 | 1.0 |
| 2010-11-29 | G | Futures | 82.07 | 82.56 | 82.02 | 82.32 | 84511.0 |
| 2010-11-29 | GF | Futures | 296.375 | 296.873 | 294.507 | 294.943 | 1648.0 |
| 2010-11-29 | GSCI | Futures | 943.23 | 950.4 | 936.23 | 947.63 | 201.0 |
| 2010-11-29 | HE | Futures | 96.693 | 96.693 | 95.156 | 95.595 | 14384.0 |
| 2010-11-29 | HG | Futures | 5.0104 | 5.077 | 4.9464 | 5.021 | 33155.0 |
| 2010-11-29 | HO | Futures | 1.9624 | 2.0055 | 1.9624 | 2.0011 | 7789.0 |
| 2010-11-29 | HRC | Futures | 2391.9 | 2391.9 | 2391.9 | 2391.9 | 0.0 |
| 2010-11-29 | J1 | Futures | 0.0149414 | 0.0149878 | 0.0148836 | 0.0149137 | 85826.0 |
| 2010-11-29 | J7 | Futures | 0.014845 | 0.014884 | 0.014783 | 0.014811 | 403.0 |
| 2010-11-29 | JB | Futures | 119.65 | 120.05 | 119.57 | 119.85 | 3980.0 |
| 2010-11-29 | KC | Futures | 495.36 | 499.9 | 488.0 | 496.95 | 8017.0 |
> showing 50 of 93 rows — these rows as CSV