PREVIEW / futures_daily / 2009-06-03
file: by_date/futures_daily/2009/2009-06-03.parquet size: 8 KB rows: 84
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-06-03 | ES | Futures | 898.53 | 901.39 | 879.23 | 888.04 | 1975454.0 |
| 2009-06-03 | NQ | Futures | 1661.67 | 1667.85 | 1638.92 | 1659.99 | 242330.0 |
| 2009-06-03 | YM | Futures | 7821.7 | 7849.5 | 7698.8 | 7776.0 | 125618.0 |
| 2009-06-03 | CL | Futures | 181.7 | 183.56 | 172.91 | 176.02 | 322365.0 |
| 2009-06-03 | GC | Futures | 1361.2 | 1373.5 | 1331.2 | 1336.8 | 127898.0 |
| 2009-06-03 | ZN | Futures | 91.198779 | 91.708541 | 90.992447 | 91.526483 | 63957.0 |
| 2009-06-03 | A6 | Futures | 0.65412 | 0.65867 | 0.63203 | 0.63378 | 85726.0 |
| 2009-06-03 | AD | Futures | 0.91042 | 0.912 | 0.88552 | 0.88867 | 76627.0 |
| 2009-06-03 | B | Futures | 65.51 | 66.31 | 62.82 | 63.78 | 78010.0 |
| 2009-06-03 | B6 | Futures | 1.7253 | 1.7339 | 1.6897 | 1.6936 | 133721.0 |
| 2009-06-03 | BFX | Futures | 2387.7 | 2401.5 | 2332.0 | 2346.8 | 86.0 |
| 2009-06-03 | C | Futures | 1822.0 | 1913.0 | 1805.0 | 1887.0 | 5834.0 |
| 2009-06-03 | CB | Futures | 75.884 | 75.884 | 75.884 | 75.884 | 2.0 |
| 2009-06-03 | CC | Futures | 2353.0 | 2428.0 | 2307.0 | 2412.0 | 13830.0 |
| 2009-06-03 | CT | Futures | 54.31 | 54.47 | 51.54 | 51.66 | 9295.0 |
| 2009-06-03 | DC | Futures | 24.33 | 24.33 | 23.57 | 23.9 | 195.0 |
| 2009-06-03 | DX | Futures | 80.887 | 82.066 | 80.717 | 81.902 | 8018.0 |
| 2009-06-03 | E1 | Futures | 1.24916 | 1.25062 | 1.23378 | 1.23789 | 43448.0 |
| 2009-06-03 | E6 | Futures | 1.69574 | 1.69977 | 1.6725 | 1.67546 | 262944.0 |
| 2009-06-03 | E7 | Futures | 1.6762 | 1.6799 | 1.6531 | 1.656 | 3135.0 |
| 2009-06-03 | ED | Futures | 93.6572 | 93.695 | 93.6525 | 93.6879 | 174848.0 |
| 2009-06-03 | ER | Futures | 96.777 | 96.787 | 96.753 | 96.758 | 123639.0 |
| 2009-06-03 | EW | Futures | 577.6 | 579.9 | 563.5 | 569.7 | 23132.0 |
| 2009-06-03 | FCE | Futures | 2194.1 | 2205.5 | 2132.6 | 2151.2 | 109415.0 |
| 2009-06-03 | FDAX | Futures | 5606.7 | 5631.8 | 5464.1 | 5512.5 | 131050.0 |
| 2009-06-03 | FESX | Futures | 1519.3 | 1527.7 | 1473.7 | 1489.9 | 1101985.0 |
| 2009-06-03 | FEU3 | Futures | 97.362 | 97.362 | 97.337 | 97.337 | 1318.0 |
| 2009-06-03 | FGBL | Futures | 89.89 | 90.56 | 89.71 | 90.44 | 1292785.0 |
| 2009-06-03 | FGBM | Futures | 96.95 | 97.31 | 96.83 | 97.21 | 667726.0 |
| 2009-06-03 | FGBS | Futures | 103.901 | 103.973 | 103.839 | 103.896 | 933788.0 |
| 2009-06-03 | FGBX | Futures | 78.55 | 80.44 | 78.43 | 80.28 | 15124.0 |
| 2009-06-03 | FTDX | Futures | 587.3 | 590.8 | 577.4 | 581.0 | 396.0 |
| 2009-06-03 | FTI | Futures | 221.7 | 223.51 | 216.8 | 217.54 | 30923.0 |
| 2009-06-03 | FTUK | Futures | 2976.0 | 2978.7 | 2895.5 | 2920.4 | 101447.0 |
| 2009-06-03 | G | Futures | 74.25 | 75.14 | 74.25 | 75.04 | 112699.0 |
| 2009-06-03 | GF | Futures | 267.844 | 267.844 | 264.812 | 264.95 | 2403.0 |
| 2009-06-03 | GSCI | Futures | 970.64 | 970.64 | 933.52 | 942.91 | 481.0 |
| 2009-06-03 | HE | Futures | 89.739 | 89.885 | 87.326 | 88.24 | 7995.0 |
| 2009-06-03 | HG | Futures | 3.2373 | 3.2859 | 3.0945 | 3.1121 | 24163.0 |
| 2009-06-03 | HO | Futures | 1.8629 | 1.8633 | 1.8048 | 1.8311 | 12581.0 |
| 2009-06-03 | HRC | Futures | 2279.4 | 2279.4 | 2279.4 | 2279.4 | 0.0 |
| 2009-06-03 | J1 | Futures | 0.0131773 | 0.0132151 | 0.0130727 | 0.0131509 | 82103.0 |
| 2009-06-03 | J7 | Futures | 0.012986 | 0.013029 | 0.0129 | 0.012972 | 49.0 |
| 2009-06-03 | JB | Futures | 114.18 | 114.33 | 114.16 | 114.25 | 1105.0 |
| 2009-06-03 | KC | Futures | 393.46 | 394.15 | 374.06 | 383.35 | 11910.0 |
| 2009-06-03 | KE | Futures | 3498.36 | 3503.24 | 3258.23 | 3275.29 | 13817.0 |
| 2009-06-03 | L | Futures | 97.141 | 97.151 | 97.092 | 97.111 | 44469.0 |
| 2009-06-03 | LBS | Futures | 939.6 | 957.0 | 910.4 | 917.2 | 577.0 |
| 2009-06-03 | LE | Futures | 142.571 | 143.056 | 141.514 | 142.351 | 6677.0 |
| 2009-06-03 | MP | Futures | 0.03902 | 0.03908 | 0.03841 | 0.03845 | 14413.0 |
> showing 50 of 84 rows — these rows as CSV