PREVIEW / futures_daily / 2009-04-21
file: by_date/futures_daily/2009/2009-04-21.parquet size: 8 KB rows: 86
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-04-21 | ES | Futures | 792.5 | 808.94 | 784.4 | 807.98 | 2691106.0 |
| 2009-04-21 | NQ | Futures | 1475.17 | 1494.27 | 1460.28 | 1492.02 | 321736.0 |
| 2009-04-21 | YM | Futures | 6997.4 | 7115.8 | 6930.1 | 7106.8 | 189939.0 |
| 2009-04-21 | CL | Futures | 129.93 | 132.76 | 125.84 | 130.76 | 287925.0 |
| 2009-04-21 | GC | Futures | 1227.5 | 1241.2 | 1217.8 | 1222.2 | 73221.0 |
| 2009-04-21 | ZN | Futures | 95.580301 | 95.908005 | 95.009854 | 95.082677 | 689667.0 |
| 2009-04-21 | A6 | Futures | 0.55507 | 0.56663 | 0.55387 | 0.56408 | 54429.0 |
| 2009-04-21 | AD | Futures | 0.79562 | 0.79927 | 0.78371 | 0.79592 | 60218.0 |
| 2009-04-21 | B | Futures | 48.23 | 48.97 | 46.73 | 48.19 | 103800.0 |
| 2009-04-21 | B6 | Futures | 1.5127 | 1.5312 | 1.5051 | 1.5259 | 77873.0 |
| 2009-04-21 | BFX | Futures | 1990.8 | 2066.3 | 1990.8 | 2052.8 | 278.0 |
| 2009-04-21 | BZ | Futures | 50.81 | 51.6 | 49.42 | 50.87 | 147.0 |
| 2009-04-21 | C | Futures | 1801.0 | 1841.0 | 1798.0 | 1834.0 | 1753.0 |
| 2009-04-21 | CB | Futures | 75.683 | 75.683 | 75.533 | 75.683 | 6.0 |
| 2009-04-21 | CC | Futures | 2100.0 | 2153.0 | 2100.0 | 2143.0 | 4756.0 |
| 2009-04-21 | CT | Futures | 45.04 | 47.61 | 44.42 | 47.01 | 4432.0 |
| 2009-04-21 | DC | Futures | 27.62 | 28.0 | 27.07 | 27.86 | 315.0 |
| 2009-04-21 | DX | Futures | 89.625 | 89.754 | 89.089 | 89.476 | 3940.0 |
| 2009-04-21 | E1 | Futures | 1.13526 | 1.1403 | 1.13235 | 1.13513 | 31704.0 |
| 2009-04-21 | E6 | Futures | 1.53143 | 1.53984 | 1.52799 | 1.53214 | 127929.0 |
| 2009-04-21 | E7 | Futures | 1.5137 | 1.5217 | 1.5106 | 1.5144 | 1969.0 |
| 2009-04-21 | EBM | Futures | 214.01 | 218.66 | 213.24 | 218.27 | 8529.0 |
| 2009-04-21 | ED | Futures | 93.233 | 93.2472 | 93.1859 | 93.1953 | 214793.0 |
| 2009-04-21 | ER | Futures | 96.64 | 96.65 | 96.62 | 96.635 | 106533.0 |
| 2009-04-21 | EW | Futures | 505.1 | 517.3 | 497.8 | 515.7 | 31121.0 |
| 2009-04-21 | FCE | Futures | 1853.0 | 1879.9 | 1806.0 | 1854.9 | 160127.0 |
| 2009-04-21 | FDAX | Futures | 4915.2 | 4964.2 | 4791.0 | 4913.0 | 203587.0 |
| 2009-04-21 | FESX | Futures | 1307.5 | 1319.5 | 1266.7 | 1301.5 | 1600130.0 |
| 2009-04-21 | FEU3 | Futures | 97.214 | 97.214 | 97.204 | 97.214 | 727.0 |
| 2009-04-21 | FGBL | Futures | 92.81 | 93.19 | 92.57 | 92.97 | 879581.0 |
| 2009-04-21 | FGBM | Futures | 97.83 | 97.99 | 97.6 | 97.83 | 432728.0 |
| 2009-04-21 | FGBS | Futures | 103.647 | 103.699 | 103.546 | 103.627 | 446049.0 |
| 2009-04-21 | FGBX | Futures | 83.28 | 83.95 | 82.91 | 83.63 | 1261.0 |
| 2009-04-21 | FTDX | Futures | 491.0 | 499.1 | 473.0 | 492.8 | 1000.0 |
| 2009-04-21 | FTI | Futures | 190.99 | 193.09 | 186.33 | 191.77 | 46459.0 |
| 2009-04-21 | FTUK | Futures | 2629.1 | 2659.1 | 2560.2 | 2623.1 | 136938.0 |
| 2009-04-21 | G | Futures | 78.27 | 78.51 | 77.49 | 77.71 | 102516.0 |
| 2009-04-21 | GF | Futures | 275.328 | 279.167 | 275.118 | 277.212 | 773.0 |
| 2009-04-21 | GSCI | Futures | 755.23 | 768.31 | 743.22 | 761.29 | 489.0 |
| 2009-04-21 | HE | Futures | 117.006 | 117.831 | 116.552 | 117.295 | 580.0 |
| 2009-04-21 | HG | Futures | 2.944 | 2.9573 | 2.8202 | 2.9264 | 13158.0 |
| 2009-04-21 | HO | Futures | 1.4762 | 1.509 | 1.4372 | 1.4901 | 34623.0 |
| 2009-04-21 | HRC | Futures | 2595.1 | 2595.1 | 2595.1 | 2595.1 | 0.0 |
| 2009-04-21 | J1 | Futures | 0.0128723 | 0.0129076 | 0.0127488 | 0.0127753 | 95438.0 |
| 2009-04-21 | J7 | Futures | 0.012704 | 0.01272 | 0.012578 | 0.012602 | 133.0 |
| 2009-04-21 | JB | Futures | 114.61 | 114.87 | 114.54 | 114.79 | 1193.0 |
| 2009-04-21 | KC | Futures | 314.63 | 317.26 | 312.41 | 316.85 | 13090.0 |
| 2009-04-21 | KE | Futures | 2754.66 | 2805.19 | 2752.19 | 2776.84 | 6036.0 |
| 2009-04-21 | L | Futures | 96.934 | 96.934 | 96.875 | 96.895 | 41371.0 |
| 2009-04-21 | LBS | Futures | 904.3 | 904.3 | 883.0 | 885.6 | 88.0 |
> showing 50 of 86 rows — these rows as CSV