PREVIEW / futures_daily / 2010-11-26
file: by_date/futures_daily/2010/2010-11-26.parquet size: 9 KB rows: 89
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-26 | ES | Futures | 1172.03 | 1176.68 | 1159.04 | 1159.78 | 963332.0 |
| 2010-11-26 | NQ | Futures | 2445.24 | 2452.89 | 2420.58 | 2433.33 | 112446.0 |
| 2010-11-26 | YM | Futures | 10376.8 | 10411.3 | 10262.4 | 10263.3 | 60610.0 |
| 2010-11-26 | CL | Futures | 172.92 | 173.58 | 169.98 | 172.0 | 174178.0 |
| 2010-11-26 | GC | Futures | 1867.6 | 1871.4 | 1837.7 | 1854.4 | 107801.0 |
| 2010-11-26 | ZN | Futures | 102.677235 | 103.103067 | 102.444963 | 102.896603 | 846973.0 |
| 2010-11-26 | A6 | Futures | 0.82275 | 0.82502 | 0.80521 | 0.80773 | 102794.0 |
| 2010-11-26 | AD | Futures | 0.97984 | 0.98301 | 0.96657 | 0.97152 | 81839.0 |
| 2010-11-26 | B | Futures | 73.03 | 73.09 | 72.08 | 72.79 | 36834.0 |
| 2010-11-26 | B6 | Futures | 1.6374 | 1.6394 | 1.6182 | 1.6202 | 99948.0 |
| 2010-11-26 | BFX | Futures | 2976.7 | 2986.8 | 2953.7 | 2978.0 | 122.0 |
| 2010-11-26 | BR | Futures | 0.24464 | 0.24464 | 0.24464 | 0.24464 | 116.0 |
| 2010-11-26 | BZ | Futures | 76.62 | 77.14 | 76.62 | 77.14 | 37.0 |
| 2010-11-26 | C | Futures | 2021.0 | 2047.0 | 2014.0 | 2041.0 | 1921.0 |
| 2010-11-26 | CC | Futures | 2258.0 | 2279.0 | 2243.0 | 2267.0 | 5166.0 |
| 2010-11-26 | CT | Futures | 99.04 | 99.04 | 95.69 | 95.83 | 9015.0 |
| 2010-11-26 | DX | Futures | 80.104 | 80.857 | 80.069 | 80.689 | 12673.0 |
| 2010-11-26 | E1 | Futures | 1.31831 | 1.32054 | 1.30584 | 1.30964 | 40751.0 |
| 2010-11-26 | E6 | Futures | 1.57759 | 1.58362 | 1.56138 | 1.56635 | 389971.0 |
| 2010-11-26 | E7 | Futures | 1.5631 | 1.5712 | 1.5496 | 1.5545 | 6443.0 |
| 2010-11-26 | ED | Futures | 94.7054 | 94.7102 | 94.6746 | 94.6864 | 334025.0 |
| 2010-11-26 | ER | Futures | 97.257 | 97.262 | 97.242 | 97.252 | 98769.0 |
| 2010-11-26 | EW | Futures | 847.0 | 850.1 | 838.8 | 840.8 | 7718.0 |
| 2010-11-26 | FBTP | Futures | 65.04 | 65.13 | 64.88 | 64.94 | 4694.0 |
| 2010-11-26 | FCE | Futures | 2497.6 | 2506.7 | 2466.8 | 2494.9 | 122781.0 |
| 2010-11-26 | FDAX | Futures | 7367.8 | 7394.6 | 7294.1 | 7375.3 | 151127.0 |
| 2010-11-26 | FESX | Futures | 1710.7 | 1718.8 | 1690.1 | 1709.4 | 1375762.0 |
| 2010-11-26 | FEU3 | Futures | 97.815 | 97.815 | 97.815 | 97.815 | 127.0 |
| 2010-11-26 | FGBL | Futures | 100.81 | 101.27 | 100.56 | 100.71 | 783939.0 |
| 2010-11-26 | FGBM | Futures | 105.48 | 105.8 | 105.43 | 105.51 | 519004.0 |
| 2010-11-26 | FGBS | Futures | 107.484 | 107.548 | 107.46 | 107.484 | 434748.0 |
| 2010-11-26 | FGBX | Futures | 101.99 | 102.84 | 101.59 | 101.75 | 2731.0 |
| 2010-11-26 | FTDX | Futures | 695.0 | 697.6 | 687.5 | 696.3 | 921.0 |
| 2010-11-26 | FTI | Futures | 271.38 | 272.23 | 267.76 | 270.82 | 33562.0 |
| 2010-11-26 | FTUK | Futures | 3921.4 | 3935.9 | 3867.5 | 3920.7 | 90361.0 |
| 2010-11-26 | FXXP | Futures | 172.4 | 172.4 | 172.4 | 172.4 | 250.0 |
| 2010-11-26 | G | Futures | 82.29 | 82.62 | 82.15 | 82.29 | 85650.0 |
| 2010-11-26 | GF | Futures | 294.631 | 296.873 | 294.444 | 295.815 | 1396.0 |
| 2010-11-26 | GSCI | Futures | 930.21 | 938.67 | 928.42 | 938.67 | 265.0 |
| 2010-11-26 | HE | Futures | 97.32 | 97.853 | 96.097 | 96.755 | 6291.0 |
| 2010-11-26 | HG | Futures | 5.0157 | 5.0643 | 4.9411 | 5.0144 | 16367.0 |
| 2010-11-26 | HO | Futures | 1.9615 | 1.9772 | 1.9434 | 1.9606 | 2690.0 |
| 2010-11-26 | HRC | Futures | 2391.9 | 2391.9 | 2391.9 | 2391.9 | 0.0 |
| 2010-11-26 | J1 | Futures | 0.0150356 | 0.0150632 | 0.0149225 | 0.0149527 | 112384.0 |
| 2010-11-26 | J7 | Futures | 0.014945 | 0.014956 | 0.01482 | 0.01485 | 149.0 |
| 2010-11-26 | JB | Futures | 120.11 | 120.2 | 119.59 | 119.63 | 3696.0 |
| 2010-11-26 | KC | Futures | 506.76 | 507.62 | 495.36 | 497.08 | 4941.0 |
| 2010-11-26 | KE | Futures | 2998.98 | 3021.4 | 2976.57 | 3002.04 | 8416.0 |
| 2010-11-26 | L | Futures | 98.096 | 98.096 | 98.056 | 98.086 | 37820.0 |
| 2010-11-26 | LBS | Futures | 698.3 | 699.9 | 691.3 | 693.6 | 315.0 |
> showing 50 of 89 rows — these rows as CSV