PREVIEW / futures_daily / 2011-02-24
file: by_date/futures_daily/2011/2011-02-24.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-02-24 | ES | Futures | 1285.28 | 1290.2 | 1272.24 | 1282.33 | 2903883.0 |
| 2011-02-24 | NQ | Futures | 2614.32 | 2635.04 | 2588.78 | 2620.57 | 362545.0 |
| 2011-02-24 | YM | Futures | 11321.0 | 11356.6 | 11197.4 | 11265.8 | 154384.0 |
| 2011-02-24 | CL | Futures | 192.3 | 200.92 | 185.79 | 189.01 | 507456.0 |
| 2011-02-24 | GC | Futures | 1916.4 | 1925.5 | 1889.4 | 1921.4 | 187391.0 |
| 2011-02-24 | ZN | Futures | 99.659637 | 100.127584 | 99.646639 | 99.867614 | 1940161.0 |
| 2011-02-24 | A6 | Futures | 0.84893 | 0.85674 | 0.84631 | 0.85445 | 117950.0 |
| 2011-02-24 | AD | Futures | 1.00287 | 1.0119 | 1.00178 | 1.00872 | 107671.0 |
| 2011-02-24 | B | Futures | 94.57 | 100.42 | 92.83 | 94.24 | 156805.0 |
| 2011-02-24 | B6 | Futures | 1.6815 | 1.686 | 1.6682 | 1.6741 | 131298.0 |
| 2011-02-24 | BFX | Futures | 3072.6 | 3081.0 | 3065.6 | 3078.2 | 181.0 |
| 2011-02-24 | BR | Futures | 0.2576 | 0.25958 | 0.2576 | 0.25909 | 3662.0 |
| 2011-02-24 | BZ | Futures | 101.97 | 102.6 | 98.9 | 99.27 | 2189.0 |
| 2011-02-24 | C | Futures | 2593.0 | 2608.0 | 2557.0 | 2580.0 | 2538.0 |
| 2011-02-24 | CB | Futures | 113.815 | 113.815 | 112.935 | 112.935 | 12.0 |
| 2011-02-24 | CC | Futures | 2926.0 | 2930.0 | 2863.0 | 2913.0 | 5956.0 |
| 2011-02-24 | CSC | Futures | 4.289 | 4.296 | 4.242 | 4.242 | 26.0 |
| 2011-02-24 | CT | Futures | 166.11 | 166.68 | 158.48 | 158.48 | 6027.0 |
| 2011-02-24 | DC | Futures | 29.27 | 29.45 | 28.57 | 28.69 | 240.0 |
| 2011-02-24 | DX | Futures | 77.141 | 77.38 | 76.891 | 76.957 | 18477.0 |
| 2011-02-24 | E1 | Futures | 1.40471 | 1.41992 | 1.40471 | 1.41782 | 59493.0 |
| 2011-02-24 | E6 | Futures | 1.62633 | 1.63485 | 1.62089 | 1.63319 | 311866.0 |
| 2011-02-24 | E7 | Futures | 1.6143 | 1.6227 | 1.6089 | 1.621 | 5496.0 |
| 2011-02-24 | EBM | Futures | 221.51 | 229.68 | 219.01 | 224.23 | 6821.0 |
| 2011-02-24 | ED | Futures | 94.8527 | 94.8599 | 94.8503 | 94.8575 | 115136.0 |
| 2011-02-24 | ER | Futures | 97.252 | 97.271 | 97.252 | 97.262 | 85944.0 |
| 2011-02-24 | EW | Futures | 929.8 | 937.5 | 921.1 | 928.8 | 29724.0 |
| 2011-02-24 | FBTP | Futures | 63.73 | 63.77 | 63.6 | 63.63 | 7211.0 |
| 2011-02-24 | FCE | Futures | 2667.1 | 2675.4 | 2639.9 | 2665.4 | 153887.0 |
| 2011-02-24 | FDAX | Futures | 7687.7 | 7691.4 | 7585.4 | 7640.6 | 191323.0 |
| 2011-02-24 | FESX | Futures | 1835.9 | 1839.0 | 1816.0 | 1833.4 | 1498051.0 |
| 2011-02-24 | FEU3 | Futures | 97.82 | 97.82 | 97.82 | 97.82 | 16.0 |
| 2011-02-24 | FGBL | Futures | 98.43 | 98.68 | 98.33 | 98.53 | 828501.0 |
| 2011-02-24 | FGBM | Futures | 103.72 | 103.93 | 103.66 | 103.76 | 552662.0 |
| 2011-02-24 | FGBS | Futures | 106.561 | 106.65 | 106.552 | 106.596 | 571133.0 |
| 2011-02-24 | FGBX | Futures | 96.08 | 96.54 | 95.81 | 96.1 | 2782.0 |
| 2011-02-24 | FTDX | Futures | 752.1 | 771.9 | 752.1 | 770.1 | 1058.0 |
| 2011-02-24 | FTI | Futures | 295.39 | 295.75 | 292.19 | 294.34 | 39091.0 |
| 2011-02-24 | FTUK | Futures | 4090.8 | 4112.7 | 4056.1 | 4104.7 | 109974.0 |
| 2011-02-24 | FXXP | Futures | 181.7 | 182.7 | 181.1 | 181.6 | 2518.0 |
| 2011-02-24 | G | Futures | 80.7 | 80.88 | 80.61 | 80.75 | 136524.0 |
| 2011-02-24 | GF | Futures | 318.454 | 320.058 | 317.036 | 319.194 | 2031.0 |
| 2011-02-24 | GSCI | Futures | 1088.77 | 1090.1 | 1062.37 | 1067.56 | 645.0 |
| 2011-02-24 | HE | Futures | 106.356 | 107.202 | 104.226 | 104.43 | 24089.0 |
| 2011-02-24 | HG | Futures | 5.7609 | 5.8148 | 5.6523 | 5.7855 | 31922.0 |
| 2011-02-24 | HO | Futures | 2.4643 | 2.5719 | 2.4 | 2.4289 | 23441.0 |
| 2011-02-24 | HRC | Futures | 2992.7 | 2992.7 | 2992.7 | 2992.7 | 0.0 |
| 2011-02-24 | J1 | Futures | 0.0152352 | 0.0153872 | 0.0152252 | 0.0153621 | 168460.0 |
| 2011-02-24 | J7 | Futures | 0.015116 | 0.015277 | 0.015116 | 0.015253 | 363.0 |
| 2011-02-24 | JB | Futures | 120.71 | 120.97 | 120.66 | 120.97 | 3501.0 |
> showing 50 of 94 rows — these rows as CSV