PREVIEW / futures_daily / 2011-03-14
file: by_date/futures_daily/2011/2011-03-14.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-14 | ES | Futures | 1285.53 | 1287.76 | 1268.2 | 1277.61 | 2788791.0 |
| 2011-03-14 | NQ | Futures | 2617.16 | 2620.29 | 2586.41 | 2607.48 | 420634.0 |
| 2011-03-14 | YM | Futures | 11267.1 | 11276.5 | 11126.0 | 11212.5 | 142257.0 |
| 2011-03-14 | CL | Futures | 196.55 | 198.87 | 192.93 | 197.61 | 121915.0 |
| 2011-03-14 | GC | Futures | 1929.7 | 1945.4 | 1924.7 | 1933.8 | 107163.0 |
| 2011-03-14 | ZN | Futures | 100.973914 | 101.487474 | 100.750054 | 101.289951 | 1185572.0 |
| 2011-03-14 | A6 | Futures | 0.85768 | 0.85905 | 0.85185 | 0.85494 | 85301.0 |
| 2011-03-14 | AD | Futures | 1.02092 | 1.02341 | 1.01773 | 1.01962 | 58607.0 |
| 2011-03-14 | B | Futures | 96.27 | 96.96 | 94.32 | 96.45 | 147266.0 |
| 2011-03-14 | B6 | Futures | 1.6694 | 1.6813 | 1.6632 | 1.6785 | 121332.0 |
| 2011-03-14 | BFX | Futures | 3050.6 | 3070.4 | 3047.8 | 3047.8 | 178.0 |
| 2011-03-14 | BR | Futures | 0.2598 | 0.2609 | 0.25953 | 0.25953 | 105.0 |
| 2011-03-14 | BZ | Futures | 100.98 | 101.87 | 100.17 | 101.6 | 1432.0 |
| 2011-03-14 | C | Futures | 2469.0 | 2505.0 | 2406.0 | 2412.0 | 7804.0 |
| 2011-03-14 | CB | Futures | 120.269 | 121.149 | 120.269 | 121.149 | 4.0 |
| 2011-03-14 | CC | Futures | 2754.0 | 2811.0 | 2692.0 | 2724.0 | 8168.0 |
| 2011-03-14 | CSC | Futures | 4.314 | 4.314 | 4.091 | 4.116 | 19.0 |
| 2011-03-14 | CT | Futures | 183.26 | 184.95 | 177.0 | 177.0 | 6636.0 |
| 2011-03-14 | DC | Futures | 28.26 | 28.62 | 27.01 | 27.6 | 800.0 |
| 2011-03-14 | DX | Futures | 76.427 | 76.656 | 76.088 | 76.253 | 22136.0 |
| 2011-03-14 | E1 | Futures | 1.41126 | 1.41991 | 1.40642 | 1.41834 | 39628.0 |
| 2011-03-14 | E6 | Futures | 1.65213 | 1.6564 | 1.64479 | 1.65509 | 273759.0 |
| 2011-03-14 | E7 | Futures | 1.6377 | 1.6441 | 1.6327 | 1.6428 | 3760.0 |
| 2011-03-14 | EBM | Futures | 205.25 | 208.07 | 201.5 | 203.61 | 14164.0 |
| 2011-03-14 | ED | Futures | 94.874 | 94.8835 | 94.8692 | 94.8692 | 212281.0 |
| 2011-03-14 | ER | Futures | 97.267 | 97.306 | 97.252 | 97.286 | 248442.0 |
| 2011-03-14 | EW | Futures | 942.5 | 945.9 | 933.2 | 941.4 | 42240.0 |
| 2011-03-14 | FBTP | Futures | 63.52 | 64.26 | 63.52 | 64.02 | 9525.0 |
| 2011-03-14 | FCE | Futures | 2610.6 | 2623.3 | 2577.7 | 2583.7 | 19576.0 |
| 2011-03-14 | FDAX | Futures | 7426.4 | 7441.4 | 7333.2 | 7362.1 | 288524.0 |
| 2011-03-14 | FESX | Futures | 1785.0 | 1806.2 | 1772.2 | 1779.3 | 576076.0 |
| 2011-03-14 | FEU3 | Futures | 97.82 | 97.84 | 97.82 | 97.83 | 552.0 |
| 2011-03-14 | FGBL | Futures | 97.93 | 98.04 | 97.38 | 97.77 | 967422.0 |
| 2011-03-14 | FGBM | Futures | 103.19 | 103.35 | 102.89 | 103.16 | 609894.0 |
| 2011-03-14 | FGBS | Futures | 106.444 | 106.528 | 106.34 | 106.469 | 693646.0 |
| 2011-03-14 | FGBX | Futures | 95.51 | 95.7 | 94.43 | 94.98 | 4120.0 |
| 2011-03-14 | FTDX | Futures | 770.3 | 785.9 | 768.1 | 778.8 | 226.0 |
| 2011-03-14 | FTI | Futures | 293.75 | 293.75 | 288.41 | 289.15 | 14155.0 |
| 2011-03-14 | FTUK | Futures | 4050.0 | 4054.6 | 4003.1 | 4011.5 | 141170.0 |
| 2011-03-14 | FXXP | Futures | 179.0 | 180.6 | 178.6 | 178.9 | 11239.0 |
| 2011-03-14 | G | Futures | 81.5 | 81.84 | 81.24 | 81.81 | 114384.0 |
| 2011-03-14 | GF | Futures | 325.738 | 325.738 | 322.35 | 323.439 | 1849.0 |
| 2011-03-14 | GSCI | Futures | 1096.86 | 1096.86 | 1082.77 | 1094.75 | 837.0 |
| 2011-03-14 | HE | Futures | 102.505 | 102.564 | 99.413 | 100.288 | 21122.0 |
| 2011-03-14 | HG | Futures | 5.631 | 5.631 | 5.5144 | 5.5764 | 34797.0 |
| 2011-03-14 | HO | Futures | 2.5368 | 2.5696 | 2.5059 | 2.5573 | 27748.0 |
| 2011-03-14 | HRC | Futures | 3098.9 | 3098.9 | 3098.9 | 3098.9 | 0.0 |
| 2011-03-14 | J1 | Futures | 0.0153772 | 0.0156335 | 0.0152466 | 0.0153998 | 176207.0 |
| 2011-03-14 | J7 | Futures | 0.015296 | 0.015529 | 0.015157 | 0.015306 | 1045.0 |
| 2011-03-14 | JB | Futures | 121.78 | 121.78 | 121.78 | 121.78 | 3908.0 |
> showing 50 of 94 rows — these rows as CSV