PREVIEW / futures_daily / 2011-03-07
file: by_date/futures_daily/2011/2011-03-07.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-07 | ES | Futures | 1299.55 | 1306.44 | 1282.33 | 1288.48 | 2702700.0 |
| 2011-03-07 | NQ | Futures | 2679.6 | 2695.5 | 2618.3 | 2639.01 | 402341.0 |
| 2011-03-07 | YM | Futures | 11384.6 | 11448.3 | 11256.4 | 11304.1 | 138821.0 |
| 2011-03-07 | CL | Futures | 203.33 | 207.8 | 202.55 | 204.87 | 404435.0 |
| 2011-03-07 | GC | Futures | 1947.5 | 1962.0 | 1938.4 | 1946.8 | 170662.0 |
| 2011-03-07 | ZN | Futures | 99.711631 | 100.049593 | 99.490657 | 99.854615 | 41556.0 |
| 2011-03-07 | A6 | Futures | 0.8597 | 0.86284 | 0.85496 | 0.85682 | 104958.0 |
| 2011-03-07 | AD | Futures | 1.02033 | 1.02301 | 1.01835 | 1.02004 | 79580.0 |
| 2011-03-07 | B | Futures | 98.29 | 100.44 | 97.23 | 97.71 | 145629.0 |
| 2011-03-07 | B6 | Futures | 1.6885 | 1.695 | 1.6785 | 1.6804 | 118994.0 |
| 2011-03-07 | BFX | Futures | 3106.1 | 3122.9 | 3096.8 | 3096.8 | 157.0 |
| 2011-03-07 | BR | Futures | 0.26162 | 0.26162 | 0.26162 | 0.26162 | 1.0 |
| 2011-03-07 | BZ | Futures | 104.89 | 105.49 | 102.93 | 102.93 | 2100.0 |
| 2011-03-07 | C | Futures | 2564.0 | 2586.0 | 2511.0 | 2568.0 | 9847.0 |
| 2011-03-07 | CB | Futures | 121.882 | 122.615 | 121.882 | 122.175 | 13.0 |
| 2011-03-07 | CC | Futures | 2939.0 | 2973.0 | 2903.0 | 2943.0 | 4666.0 |
| 2011-03-07 | CSC | Futures | 4.348 | 4.348 | 4.348 | 4.348 | 5.0 |
| 2011-03-07 | CT | Futures | 191.14 | 196.46 | 190.58 | 191.49 | 12720.0 |
| 2011-03-07 | DC | Futures | 29.4 | 29.74 | 29.19 | 29.24 | 256.0 |
| 2011-03-07 | DX | Futures | 76.213 | 76.432 | 76.008 | 76.376 | 23971.0 |
| 2011-03-07 | E1 | Futures | 1.41664 | 1.41913 | 1.4131 | 1.41533 | 45816.0 |
| 2011-03-07 | E6 | Futures | 1.65508 | 1.6604 | 1.65082 | 1.65224 | 235370.0 |
| 2011-03-07 | E7 | Futures | 1.6435 | 1.649 | 1.6384 | 1.6399 | 3674.0 |
| 2011-03-07 | EBM | Futures | 229.68 | 230.85 | 224.04 | 225.22 | 7343.0 |
| 2011-03-07 | ED | Futures | 94.867 | 94.8694 | 94.8646 | 94.8646 | 80329.0 |
| 2011-03-07 | ER | Futures | 97.198 | 97.207 | 97.193 | 97.203 | 74410.0 |
| 2011-03-07 | EW | Futures | 954.1 | 960.0 | 934.0 | 939.7 | 27653.0 |
| 2011-03-07 | FBTP | Futures | 63.32 | 63.41 | 63.24 | 63.38 | 10456.0 |
| 2011-03-07 | FCE | Futures | 2657.1 | 2692.0 | 2635.5 | 2651.8 | 156855.0 |
| 2011-03-07 | FDAX | Futures | 7652.3 | 7789.4 | 7629.3 | 7672.7 | 187400.0 |
| 2011-03-07 | FESX | Futures | 1820.3 | 1849.5 | 1808.5 | 1821.6 | 1621429.0 |
| 2011-03-07 | FEU3 | Futures | 97.761 | 97.765 | 97.761 | 97.761 | 761.0 |
| 2011-03-07 | FGBL | Futures | 97.53 | 97.56 | 97.07 | 97.33 | 1023426.0 |
| 2011-03-07 | FGBM | Futures | 102.78 | 102.8 | 102.5 | 102.65 | 751328.0 |
| 2011-03-07 | FGBS | Futures | 106.241 | 106.261 | 106.166 | 106.206 | 901820.0 |
| 2011-03-07 | FGBX | Futures | 94.27 | 94.29 | 93.53 | 94.03 | 12483.0 |
| 2011-03-07 | FTDX | Futures | 777.1 | 795.1 | 777.1 | 787.2 | 1244.0 |
| 2011-03-07 | FTI | Futures | 296.2 | 299.72 | 295.23 | 296.44 | 43321.0 |
| 2011-03-07 | FTUK | Futures | 4148.5 | 4188.8 | 4111.3 | 4144.7 | 103414.0 |
| 2011-03-07 | FXXP | Futures | 181.8 | 184.0 | 181.8 | 182.2 | 3844.0 |
| 2011-03-07 | G | Futures | 80.78 | 80.9 | 80.52 | 80.8 | 87793.0 |
| 2011-03-07 | GF | Futures | 320.058 | 321.045 | 319.996 | 320.181 | 1092.0 |
| 2011-03-07 | GSCI | Futures | 1130.4 | 1146.9 | 1125.37 | 1128.04 | 2930.0 |
| 2011-03-07 | HE | Futures | 103.234 | 103.234 | 100.667 | 100.813 | 29592.0 |
| 2011-03-07 | HG | Futures | 5.978 | 6.0159 | 5.7329 | 5.7635 | 40830.0 |
| 2011-03-07 | HO | Futures | 2.5759 | 2.6154 | 2.5476 | 2.5619 | 20068.0 |
| 2011-03-07 | HRC | Futures | 3081.2 | 3081.2 | 3081.2 | 3081.2 | 0.0 |
| 2011-03-07 | J1 | Futures | 0.0152729 | 0.0153269 | 0.0152415 | 0.0152591 | 115721.0 |
| 2011-03-07 | J7 | Futures | 0.015152 | 0.015213 | 0.015136 | 0.015151 | 358.0 |
| 2011-03-07 | JB | Futures | 120.51 | 120.9 | 120.43 | 120.71 | 8416.0 |
> showing 50 of 94 rows — these rows as CSV