PREVIEW / futures_daily / 2011-03-22
file: by_date/futures_daily/2011/2011-03-22.parquet size: 9 KB rows: 94
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 |
|---|---|---|---|---|---|---|---|
| 2011-03-22 | ES | Futures | 1279.59 | 1283.55 | 1274.64 | 1275.38 | 1441789.0 |
| 2011-03-22 | NQ | Futures | 2569.61 | 2578.72 | 2561.64 | 2570.75 | 214276.0 |
| 2011-03-22 | YM | Futures | 11248.3 | 11276.5 | 11217.2 | 11239.8 | 81663.0 |
| 2011-03-22 | CL | Futures | 198.68 | 203.44 | 197.44 | 202.99 | 303365.0 |
| 2011-03-22 | GC | Futures | 1937.0 | 1943.8 | 1926.4 | 1937.4 | 124759.0 |
| 2011-03-22 | ZN | Futures | 101.250446 | 101.342624 | 100.960746 | 101.171437 | 1023294.0 |
| 2011-03-22 | A6 | Futures | 0.85408 | 0.85982 | 0.85202 | 0.85888 | 79571.0 |
| 2011-03-22 | AD | Futures | 1.01564 | 1.01962 | 1.01225 | 1.01494 | 67342.0 |
| 2011-03-22 | B | Futures | 97.52 | 98.46 | 96.82 | 98.13 | 144910.0 |
| 2011-03-22 | B6 | Futures | 1.6916 | 1.7022 | 1.691 | 1.7001 | 91779.0 |
| 2011-03-22 | BFX | Futures | 3046.1 | 3046.1 | 3000.4 | 3014.9 | 171.0 |
| 2011-03-22 | BR | Futures | 0.26037 | 0.26046 | 0.26037 | 0.26046 | 36.0 |
| 2011-03-22 | BZ | Futures | 102.36 | 103.65 | 102.03 | 103.37 | 650.0 |
| 2011-03-22 | C | Futures | 2262.0 | 2310.0 | 2248.0 | 2307.0 | 6558.0 |
| 2011-03-22 | CB | Futures | 115.869 | 116.749 | 115.869 | 115.869 | 7.0 |
| 2011-03-22 | CC | Futures | 2532.0 | 2624.0 | 2532.0 | 2623.0 | 7188.0 |
| 2011-03-22 | CSC | Futures | 4.276 | 4.276 | 4.271 | 4.271 | 30.0 |
| 2011-03-22 | CT | Futures | 179.29 | 184.17 | 176.55 | 184.17 | 6999.0 |
| 2011-03-22 | DC | Futures | 28.39 | 28.39 | 27.98 | 28.27 | 226.0 |
| 2011-03-22 | DX | Futures | 75.327 | 75.427 | 75.128 | 75.295 | 21577.0 |
| 2011-03-22 | E1 | Futures | 1.44845 | 1.45369 | 1.44662 | 1.45094 | 30900.0 |
| 2011-03-22 | E6 | Futures | 1.68163 | 1.68542 | 1.67712 | 1.6802 | 218874.0 |
| 2011-03-22 | E7 | Futures | 1.669 | 1.6729 | 1.6646 | 1.6677 | 4692.0 |
| 2011-03-22 | EBM | Futures | 210.19 | 211.6 | 207.13 | 211.36 | 8610.0 |
| 2011-03-22 | ED | Futures | 94.855 | 94.8597 | 94.8454 | 94.8502 | 150689.0 |
| 2011-03-22 | ER | Futures | 97.247 | 97.262 | 97.237 | 97.252 | 180176.0 |
| 2011-03-22 | EW | Futures | 952.8 | 956.2 | 945.9 | 947.5 | 16836.0 |
| 2011-03-22 | FBTP | Futures | 64.39 | 64.39 | 64.0 | 64.08 | 5385.0 |
| 2011-03-22 | FCE | Futures | 2601.0 | 2615.0 | 2580.7 | 2592.7 | 129311.0 |
| 2011-03-22 | FDAX | Futures | 7305.0 | 7312.0 | 7245.8 | 7269.3 | 131016.0 |
| 2011-03-22 | FESX | Futures | 1787.0 | 1798.5 | 1772.2 | 1780.5 | 1191861.0 |
| 2011-03-22 | FEU3 | Futures | 97.79 | 97.8 | 97.79 | 97.795 | 511.0 |
| 2011-03-22 | FGBL | Futures | 97.76 | 97.81 | 97.45 | 97.64 | 881685.0 |
| 2011-03-22 | FGBM | Futures | 103.04 | 103.09 | 102.83 | 103.0 | 572603.0 |
| 2011-03-22 | FGBS | Futures | 106.3 | 106.404 | 106.251 | 106.355 | 674110.0 |
| 2011-03-22 | FGBX | Futures | 94.01 | 94.41 | 93.86 | 94.18 | 3864.0 |
| 2011-03-22 | FTDX | Futures | 804.2 | 805.6 | 790.0 | 793.1 | 370.0 |
| 2011-03-22 | FTI | Futures | 289.6 | 290.37 | 288.17 | 289.11 | 29758.0 |
| 2011-03-22 | FTUK | Futures | 4007.3 | 4037.1 | 3986.3 | 4011.5 | 83336.0 |
| 2011-03-22 | FXXP | Futures | 178.5 | 179.6 | 177.8 | 178.8 | 4128.0 |
| 2011-03-22 | G | Futures | 82.04 | 82.06 | 81.49 | 81.74 | 152345.0 |
| 2011-03-22 | GF | Futures | 317.51 | 318.539 | 315.03 | 317.994 | 771.0 |
| 2011-03-22 | GSCI | Futures | 1102.34 | 1119.95 | 1100.77 | 1119.4 | 127.0 |
| 2011-03-22 | HE | Futures | 105.883 | 106.282 | 105.193 | 106.282 | 438.0 |
| 2011-03-22 | HG | Futures | 5.7229 | 5.7535 | 5.6889 | 5.7449 | 20969.0 |
| 2011-03-22 | HO | Futures | 2.5643 | 2.5909 | 2.5484 | 2.5814 | 16958.0 |
| 2011-03-22 | HRC | Futures | 3098.9 | 3098.9 | 3098.9 | 3098.9 | 0.0 |
| 2011-03-22 | J1 | Futures | 0.0155066 | 0.0155481 | 0.0154652 | 0.0155317 | 80997.0 |
| 2011-03-22 | J7 | Futures | 0.015395 | 0.015452 | 0.015373 | 0.015437 | 406.0 |
| 2011-03-22 | JB | Futures | 121.28 | 121.28 | 121.28 | 121.28 | 1593.0 |
> showing 50 of 94 rows — these rows as CSV