PREVIEW / futures_daily / 2009-12-24
file: by_date/futures_daily/2009/2009-12-24.parquet size: 8 KB rows: 79
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-24 | ES | Futures | 1081.06 | 1088.09 | 1080.58 | 1087.61 | 248984.0 |
| 2009-12-24 | NQ | Futures | 2094.42 | 2114.49 | 2093.29 | 2112.8 | 66098.0 |
| 2009-12-24 | YM | Futures | 9499.7 | 9565.5 | 9497.0 | 9560.0 | 20864.0 |
| 2009-12-24 | CL | Futures | 181.63 | 185.57 | 180.68 | 185.09 | 102484.0 |
| 2009-12-24 | GC | Futures | 1498.4 | 1523.6 | 1498.0 | 1520.7 | 56912.0 |
| 2009-12-24 | ZN | Futures | 93.559921 | 93.698453 | 93.219886 | 93.270261 | 117262.0 |
| 2009-12-24 | A6 | Futures | 0.70836 | 0.71421 | 0.7082 | 0.71267 | 14711.0 |
| 2009-12-24 | AD | Futures | 0.94145 | 0.9452 | 0.93947 | 0.94066 | 22714.0 |
| 2009-12-24 | B | Futures | 69.38 | 70.27 | 68.63 | 70.1 | 56937.0 |
| 2009-12-24 | B6 | Futures | 1.6567 | 1.6635 | 1.6534 | 1.6554 | 23530.0 |
| 2009-12-24 | BFX | Futures | 2822.0 | 2826.3 | 2810.9 | 2818.5 | 14.0 |
| 2009-12-24 | BR | Futures | 0.22498 | 0.22498 | 0.22498 | 0.22498 | 3.0 |
| 2009-12-24 | C | Futures | 2265.0 | 2278.0 | 2265.0 | 2274.0 | 752.0 |
| 2009-12-24 | CB | Futures | 71.828 | 71.828 | 71.828 | 71.828 | 1.0 |
| 2009-12-24 | CC | Futures | 2815.0 | 2820.0 | 2808.0 | 2810.0 | 1276.0 |
| 2009-12-24 | CT | Futures | 60.25 | 60.35 | 59.86 | 60.04 | 1603.0 |
| 2009-12-24 | DC | Futures | 24.25 | 24.28 | 23.95 | 24.26 | 211.0 |
| 2009-12-24 | DX | Futures | 79.55 | 79.586 | 79.169 | 79.5 | 4974.0 |
| 2009-12-24 | E1 | Futures | 1.26928 | 1.27825 | 1.26902 | 1.26968 | 15245.0 |
| 2009-12-24 | E6 | Futures | 1.69647 | 1.70665 | 1.69611 | 1.69919 | 57193.0 |
| 2009-12-24 | E7 | Futures | 1.6847 | 1.6948 | 1.6847 | 1.6874 | 1061.0 |
| 2009-12-24 | EBM | Futures | 223.08 | 223.51 | 221.81 | 222.66 | 580.0 |
| 2009-12-24 | ED | Futures | 94.311 | 94.3157 | 94.2921 | 94.3015 | 41198.0 |
| 2009-12-24 | ER | Futures | 97.233 | 97.237 | 97.223 | 97.228 | 25284.0 |
| 2009-12-24 | EW | Futures | 712.6 | 717.9 | 712.5 | 717.2 | 5679.0 |
| 2009-12-24 | FCE | Futures | 2564.8 | 2566.2 | 2556.4 | 2556.7 | 8030.0 |
| 2009-12-24 | FTI | Futures | 272.91 | 272.91 | 271.81 | 272.18 | 2112.0 |
| 2009-12-24 | FTUK | Futures | 3571.9 | 3592.3 | 3569.2 | 3585.6 | 10174.0 |
| 2009-12-24 | G | Futures | 75.07 | 75.22 | 75.02 | 75.2 | 42143.0 |
| 2009-12-24 | GF | Futures | 258.628 | 259.035 | 256.662 | 256.662 | 454.0 |
| 2009-12-24 | GSCI | Futures | 969.53 | 977.3 | 969.53 | 975.41 | 146.0 |
| 2009-12-24 | HE | Futures | 87.914 | 88.215 | 85.305 | 85.372 | 7469.0 |
| 2009-12-24 | HG | Futures | 4.418 | 4.558 | 4.4035 | 4.5421 | 12916.0 |
| 2009-12-24 | HO | Futures | 1.909 | 1.9298 | 1.8954 | 1.926 | 4755.0 |
| 2009-12-24 | HRC | Futures | 2561.7 | 2561.7 | 2561.7 | 2561.7 | 0.0 |
| 2009-12-24 | J1 | Futures | 0.0137434 | 0.0138151 | 0.0137182 | 0.0137358 | 27479.0 |
| 2009-12-24 | J7 | Futures | 0.013597 | 0.013646 | 0.013546 | 0.013564 | 283.0 |
| 2009-12-24 | JB | Futures | 118.2 | 118.21 | 118.0 | 118.15 | 1294.0 |
| 2009-12-24 | KC | Futures | 372.87 | 373.65 | 362.07 | 362.59 | 4750.0 |
| 2009-12-24 | KE | Futures | 2365.23 | 2374.28 | 2330.18 | 2358.45 | 3150.0 |
| 2009-12-24 | L | Futures | 97.779 | 97.789 | 97.76 | 97.779 | 8925.0 |
| 2009-12-24 | LBS | Futures | 785.0 | 787.6 | 778.4 | 779.0 | 152.0 |
| 2009-12-24 | LE | Futures | 139.735 | 139.817 | 138.671 | 138.671 | 6015.0 |
| 2009-12-24 | MFS | Futures | 1265.9 | 1267.9 | 1263.4 | 1265.7 | 370.0 |
| 2009-12-24 | MME | Futures | 824.8 | 826.2 | 820.7 | 823.4 | 280.0 |
| 2009-12-24 | MP | Futures | 0.04097 | 0.04121 | 0.04097 | 0.04113 | 3303.0 |
| 2009-12-24 | N6 | Futures | 0.55835 | 0.56106 | 0.55724 | 0.55939 | 2416.0 |
| 2009-12-24 | NG | Futures | 190.245 | 192.914 | 182.301 | 183.701 | 44504.0 |
| 2009-12-24 | NIY | Futures | 8517.5 | 8545.9 | 8509.4 | 8525.6 | 1442.0 |
| 2009-12-24 | NKD | Futures | 9965.0 | 10050.4 | 9965.0 | 10031.4 | 1265.0 |
> showing 50 of 79 rows — these rows as CSV