PREVIEW / futures_daily / 2010-10-22
file: by_date/futures_daily/2010/2010-10-22.parquet size: 9 KB rows: 90
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-10-22 | ES | Futures | 1151.93 | 1158.06 | 1149.97 | 1157.33 | 1204824.0 |
| 2010-10-22 | NQ | Futures | 2359.06 | 2386.28 | 2355.09 | 2385.71 | 206996.0 |
| 2010-10-22 | YM | Futures | 10314.5 | 10349.9 | 10291.2 | 10319.2 | 72759.0 |
| 2010-10-22 | CL | Futures | 166.44 | 169.2 | 165.78 | 168.42 | 256382.0 |
| 2010-10-22 | GC | Futures | 1802.1 | 1806.2 | 1788.2 | 1801.2 | 147225.0 |
| 2010-10-22 | ZN | Futures | 104.496701 | 104.638645 | 104.303141 | 104.406373 | 812150.0 |
| 2010-10-22 | A6 | Futures | 0.81663 | 0.82217 | 0.81394 | 0.81755 | 72209.0 |
| 2010-10-22 | AD | Futures | 0.96429 | 0.96795 | 0.96042 | 0.9633 | 54190.0 |
| 2010-10-22 | B | Futures | 70.42 | 71.45 | 70.23 | 71.2 | 136059.0 |
| 2010-10-22 | B6 | Futures | 1.6303 | 1.6346 | 1.624 | 1.6259 | 72851.0 |
| 2010-10-22 | BFX | Futures | 3068.8 | 3075.9 | 3066.5 | 3073.4 | 17.0 |
| 2010-10-22 | BR | Futures | 0.25114 | 0.25131 | 0.24845 | 0.24854 | 126.0 |
| 2010-10-22 | BZ | Futures | 74.8 | 75.93 | 74.8 | 75.71 | 199.0 |
| 2010-10-22 | C | Futures | 2080.0 | 2111.0 | 2078.0 | 2101.0 | 3978.0 |
| 2010-10-22 | CC | Futures | 2332.0 | 2383.0 | 2328.0 | 2356.0 | 4792.0 |
| 2010-10-22 | CT | Futures | 98.14 | 101.33 | 97.55 | 101.33 | 10695.0 |
| 2010-10-22 | DC | Futures | 24.51 | 24.77 | 24.41 | 24.71 | 213.0 |
| 2010-10-22 | DX | Futures | 77.988 | 78.213 | 76.092 | 77.932 | 15171.0 |
| 2010-10-22 | E1 | Futures | 1.35756 | 1.35953 | 1.33945 | 1.34273 | 47703.0 |
| 2010-10-22 | E6 | Futures | 1.64643 | 1.65199 | 1.63827 | 1.64655 | 268569.0 |
| 2010-10-22 | E7 | Futures | 1.6335 | 1.6393 | 1.6258 | 1.634 | 5403.0 |
| 2010-10-22 | ED | Futures | 94.7221 | 94.7316 | 94.7221 | 94.7268 | 99866.0 |
| 2010-10-22 | ER | Futures | 97.139 | 97.168 | 97.139 | 97.154 | 105040.0 |
| 2010-10-22 | EW | Futures | 802.0 | 809.7 | 801.1 | 809.2 | 16032.0 |
| 2010-10-22 | FBTP | Futures | 67.41 | 67.53 | 67.24 | 67.52 | 3126.0 |
| 2010-10-22 | FCE | Futures | 2560.9 | 2574.5 | 2552.3 | 2560.9 | 87672.0 |
| 2010-10-22 | FDAX | Futures | 7113.9 | 7134.4 | 7094.0 | 7113.9 | 95191.0 |
| 2010-10-22 | FESX | Futures | 1789.3 | 1797.5 | 1781.9 | 1786.8 | 821819.0 |
| 2010-10-22 | FEU3 | Futures | 97.716 | 97.721 | 97.716 | 97.716 | 202.0 |
| 2010-10-22 | FGBL | Futures | 102.41 | 102.67 | 102.33 | 102.52 | 757026.0 |
| 2010-10-22 | FGBM | Futures | 105.73 | 105.79 | 105.65 | 105.71 | 435156.0 |
| 2010-10-22 | FGBS | Futures | 107.179 | 107.204 | 107.149 | 107.174 | 454357.0 |
| 2010-10-22 | FGBX | Futures | 105.2 | 106.21 | 105.16 | 105.88 | 3220.0 |
| 2010-10-22 | FTDX | Futures | 700.3 | 715.7 | 700.3 | 712.6 | 425.0 |
| 2010-10-22 | FTI | Futures | 272.45 | 273.78 | 271.85 | 272.29 | 18757.0 |
| 2010-10-22 | FTUK | Futures | 3952.9 | 3966.0 | 3942.2 | 3951.2 | 64976.0 |
| 2010-10-22 | G | Futures | 84.7 | 84.84 | 84.57 | 84.62 | 80795.0 |
| 2010-10-22 | GF | Futures | 281.614 | 283.628 | 281.614 | 283.377 | 1666.0 |
| 2010-10-22 | GSCI | Futures | 927.94 | 929.1 | 919.85 | 928.44 | 39.0 |
| 2010-10-22 | HE | Futures | 94.185 | 95.978 | 93.509 | 95.606 | 18027.0 |
| 2010-10-22 | HG | Futures | 5.0278 | 5.0985 | 5.0071 | 5.0678 | 31830.0 |
| 2010-10-22 | HO | Futures | 1.8897 | 1.9233 | 1.8792 | 1.9143 | 37637.0 |
| 2010-10-22 | HRC | Futures | 2504.7 | 2504.7 | 2504.7 | 2504.7 | 0.0 |
| 2010-10-22 | J1 | Futures | 0.0154551 | 0.0155167 | 0.0154149 | 0.0154413 | 74886.0 |
| 2010-10-22 | J7 | Futures | 0.015354 | 0.015408 | 0.015312 | 0.015335 | 235.0 |
| 2010-10-22 | JB | Futures | 122.36 | 122.37 | 122.14 | 122.21 | 2763.0 |
| 2010-10-22 | KC | Futures | 497.84 | 500.2 | 486.06 | 493.13 | 10802.0 |
| 2010-10-22 | KE | Futures | 2990.33 | 3022.66 | 2974.68 | 2999.71 | 9473.0 |
| 2010-10-22 | L | Futures | 98.155 | 98.165 | 98.155 | 98.155 | 13374.0 |
| 2010-10-22 | LBS | Futures | 702.5 | 714.2 | 701.1 | 704.0 | 571.0 |
> showing 50 of 90 rows — these rows as CSV