PREVIEW / futures_daily / 2012-04-30
file: by_date/futures_daily/2012/2012-04-30.parquet size: 9 KB rows: 98
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 |
|---|---|---|---|---|---|---|---|
| 2012-04-30 | ES | Futures | 1411.05 | 1413.32 | 1400.47 | 1404.25 | 1322300.0 |
| 2012-04-30 | NQ | Futures | 3140.42 | 3144.14 | 3111.2 | 3115.5 | 198658.0 |
| 2012-04-30 | YM | Futures | 12814.5 | 12834.9 | 12758.1 | 12793.1 | 89738.0 |
| 2012-04-30 | CL | Futures | 192.48 | 192.9 | 190.56 | 192.37 | 211453.0 |
| 2012-04-30 | GC | Futures | 2223.1 | 2228.4 | 2199.2 | 2224.7 | 115408.0 |
| 2012-04-30 | ZN | Futures | 114.490701 | 114.693771 | 114.368859 | 114.612543 | 646990.0 |
| 2012-04-30 | A6 | Futures | 0.9358 | 0.93715 | 0.93131 | 0.93275 | 94064.0 |
| 2012-04-30 | AD | Futures | 1.02493 | 1.02523 | 1.01567 | 1.01789 | 81177.0 |
| 2012-04-30 | B | Futures | 107.74 | 107.94 | 107.12 | 107.76 | 95606.0 |
| 2012-04-30 | B6 | Futures | 1.7073 | 1.7106 | 1.7021 | 1.7034 | 103201.0 |
| 2012-04-30 | BFX | Futures | 2680.7 | 2692.9 | 2679.4 | 2683.2 | 71.0 |
| 2012-04-30 | BR | Futures | 0.25068 | 0.25072 | 0.24841 | 0.24896 | 189.0 |
| 2012-04-30 | BZ | Futures | 114.84 | 114.84 | 114.84 | 114.84 | 388.0 |
| 2012-04-30 | C | Futures | 1520.0 | 1528.0 | 1443.0 | 1474.0 | 4591.0 |
| 2012-04-30 | CC | Futures | 1741.0 | 1759.0 | 1618.0 | 1673.0 | 25476.0 |
| 2012-04-30 | CSC | Futures | 3.373 | 3.377 | 3.348 | 3.377 | 9.0 |
| 2012-04-30 | CT | Futures | 111.61 | 112.12 | 107.5 | 109.37 | 19824.0 |
| 2012-04-30 | DC | Futures | 23.46 | 23.46 | 23.13 | 23.41 | 214.0 |
| 2012-04-30 | DX | Futures | 76.339 | 76.503 | 76.237 | 76.395 | 19460.0 |
| 2012-04-30 | E1 | Futures | 1.44463 | 1.44647 | 1.44005 | 1.44372 | 37122.0 |
| 2012-04-30 | E6 | Futures | 1.58136 | 1.58399 | 1.57707 | 1.58077 | 149908.0 |
| 2012-04-30 | E7 | Futures | 1.5663 | 1.5688 | 1.5619 | 1.5656 | 1758.0 |
| 2012-04-30 | EBM | Futures | 287.38 | 292.1 | 287.38 | 291.76 | 2671.0 |
| 2012-04-30 | ED | Futures | 95.0645 | 95.0693 | 95.0597 | 95.0693 | 60534.0 |
| 2012-04-30 | ER | Futures | 97.577 | 97.602 | 97.567 | 97.592 | 142917.0 |
| 2012-04-30 | EW | Futures | 1010.7 | 1012.4 | 997.8 | 1000.8 | 21606.0 |
| 2012-04-30 | FBTP | Futures | 65.86 | 66.43 | 65.66 | 66.27 | 7761.0 |
| 2012-04-30 | FBTS | Futures | 85.005 | 85.266 | 84.956 | 85.209 | 399.0 |
| 2012-04-30 | FCE | Futures | 2320.8 | 2334.5 | 2277.1 | 2283.2 | 108628.0 |
| 2012-04-30 | FDAX | Futures | 7543.6 | 7578.9 | 7466.7 | 7489.4 | 109072.0 |
| 2012-04-30 | FESX | Futures | 1581.9 | 1591.6 | 1555.7 | 1559.2 | 967657.0 |
| 2012-04-30 | FGBL | Futures | 115.37 | 115.79 | 115.28 | 115.69 | 524917.0 |
| 2012-04-30 | FGBM | Futures | 114.67 | 114.94 | 114.64 | 114.89 | 260486.0 |
| 2012-04-30 | FGBS | Futures | 110.158 | 110.233 | 110.153 | 110.208 | 265975.0 |
| 2012-04-30 | FGBX | Futures | 119.46 | 120.28 | 119.2 | 120.13 | 4154.0 |
| 2012-04-30 | FOAT | Futures | 94.7 | 95.24 | 94.7 | 95.14 | 6497.0 |
| 2012-04-30 | FTDX | Futures | 746.2 | 749.0 | 745.7 | 747.1 | 195.0 |
| 2012-04-30 | FTI | Futures | 267.15 | 268.11 | 264.12 | 264.64 | 27155.0 |
| 2012-04-30 | FTUK | Futures | 4189.2 | 4202.7 | 4150.6 | 4169.5 | 95558.0 |
| 2012-04-30 | FVSA | Futures | 8631.04 | 8912.13 | 8564.91 | 8862.53 | 2211.0 |
| 2012-04-30 | FXXP | Futures | 186.1 | 186.5 | 184.2 | 184.6 | 2037.0 |
| 2012-04-30 | G | Futures | 94.57 | 94.94 | 94.39 | 94.77 | 90413.0 |
| 2012-04-30 | GF | Futures | 309.896 | 313.593 | 308.802 | 312.083 | 3275.0 |
| 2012-04-30 | GSCI | Futures | 1082.91 | 1089.26 | 1079.82 | 1089.18 | 102.0 |
| 2012-04-30 | HE | Futures | 93.682 | 93.682 | 91.756 | 92.086 | 852.0 |
| 2012-04-30 | HG | Futures | 5.0243 | 5.057 | 4.9719 | 5.0151 | 50308.0 |
| 2012-04-30 | HO | Futures | 2.6181 | 2.6242 | 2.6025 | 2.6176 | 47095.0 |
| 2012-04-30 | HRC | Futures | 2629.4 | 2629.4 | 2629.4 | 2629.4 | 0.0 |
| 2012-04-30 | J1 | Futures | 0.0156134 | 0.0157325 | 0.0156046 | 0.0157188 | 75203.0 |
| 2012-04-30 | J7 | Futures | 0.015552 | 0.015657 | 0.015532 | 0.015645 | 593.0 |
> showing 50 of 98 rows — these rows as CSV