PREVIEW / futures_daily / 2011-02-23
file: by_date/futures_daily/2011/2011-02-23.parquet size: 9 KB rows: 93
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-23 | ES | Futures | 1293.4 | 1299.8 | 1277.16 | 1285.04 | 3075485.0 |
| 2011-02-23 | NQ | Futures | 2636.18 | 2650.65 | 2594.17 | 2615.17 | 407845.0 |
| 2011-02-23 | YM | Futures | 11399.6 | 11452.0 | 11273.3 | 11319.1 | 158122.0 |
| 2011-02-23 | CL | Futures | 185.9 | 194.2 | 184.85 | 190.61 | 489667.0 |
| 2011-02-23 | GC | Futures | 1899.1 | 1923.4 | 1894.5 | 1919.0 | 153788.0 |
| 2011-02-23 | ZN | Futures | 99.867614 | 100.062591 | 99.620642 | 99.672636 | 1710560.0 |
| 2011-02-23 | A6 | Futures | 0.84512 | 0.85105 | 0.84436 | 0.84707 | 105058.0 |
| 2011-02-23 | AD | Futures | 1.00178 | 1.00624 | 0.99602 | 1.00197 | 106923.0 |
| 2011-02-23 | B | Futures | 90.12 | 95.05 | 89.91 | 94.07 | 167649.0 |
| 2011-02-23 | B6 | Futures | 1.6746 | 1.6904 | 1.6745 | 1.6804 | 119004.0 |
| 2011-02-23 | BFX | Futures | 3111.3 | 3123.5 | 3091.7 | 3094.5 | 59.0 |
| 2011-02-23 | BR | Futures | 0.25782 | 0.25782 | 0.25738 | 0.2574 | 991.0 |
| 2011-02-23 | BZ | Futures | 96.29 | 99.95 | 96.29 | 99.09 | 1682.0 |
| 2011-02-23 | C | Futures | 2588.0 | 2597.0 | 2546.0 | 2594.0 | 1936.0 |
| 2011-02-23 | CB | Futures | 114.695 | 114.695 | 114.402 | 114.402 | 2.0 |
| 2011-02-23 | CC | Futures | 2883.0 | 2926.0 | 2842.0 | 2918.0 | 7462.0 |
| 2011-02-23 | CT | Futures | 162.34 | 167.98 | 161.79 | 164.74 | 18096.0 |
| 2011-02-23 | DC | Futures | 30.15 | 30.22 | 28.86 | 29.45 | 372.0 |
| 2011-02-23 | DX | Futures | 77.57 | 77.605 | 77.156 | 77.305 | 24180.0 |
| 2011-02-23 | E1 | Futures | 1.39672 | 1.40851 | 1.3958 | 1.40471 | 49876.0 |
| 2011-02-23 | E6 | Futures | 1.61521 | 1.63083 | 1.61497 | 1.62562 | 311028.0 |
| 2011-02-23 | E7 | Futures | 1.6031 | 1.6187 | 1.6031 | 1.6135 | 5940.0 |
| 2011-02-23 | EBM | Futures | 222.64 | 230.36 | 209.03 | 223.78 | 6467.0 |
| 2011-02-23 | ED | Futures | 94.848 | 94.8551 | 94.848 | 94.8527 | 144767.0 |
| 2011-02-23 | ER | Futures | 97.252 | 97.271 | 97.242 | 97.252 | 89536.0 |
| 2011-02-23 | EW | Futures | 944.9 | 951.1 | 922.1 | 929.4 | 29219.0 |
| 2011-02-23 | FBTP | Futures | 63.86 | 63.86 | 63.54 | 63.76 | 6249.0 |
| 2011-02-23 | FCE | Futures | 2682.4 | 2699.7 | 2650.8 | 2667.4 | 142981.0 |
| 2011-02-23 | FDAX | Futures | 7799.1 | 7834.4 | 7655.6 | 7718.7 | 188891.0 |
| 2011-02-23 | FESX | Futures | 1845.8 | 1860.1 | 1823.4 | 1838.3 | 1622536.0 |
| 2011-02-23 | FEU3 | Futures | 97.815 | 97.815 | 97.81 | 97.81 | 112.0 |
| 2011-02-23 | FGBL | Futures | 98.32 | 98.56 | 98.2 | 98.43 | 782826.0 |
| 2011-02-23 | FGBM | Futures | 103.76 | 103.78 | 103.54 | 103.71 | 559220.0 |
| 2011-02-23 | FGBS | Futures | 106.611 | 106.616 | 106.487 | 106.556 | 947060.0 |
| 2011-02-23 | FGBX | Futures | 95.67 | 96.28 | 95.48 | 96.08 | 2709.0 |
| 2011-02-23 | FTDX | Futures | 790.7 | 790.7 | 749.9 | 775.4 | 1758.0 |
| 2011-02-23 | FTI | Futures | 296.56 | 298.87 | 294.14 | 295.59 | 39325.0 |
| 2011-02-23 | FTUK | Futures | 4123.8 | 4144.0 | 4066.2 | 4109.3 | 116793.0 |
| 2011-02-23 | FXXP | Futures | 184.4 | 184.6 | 181.9 | 183.0 | 1870.0 |
| 2011-02-23 | G | Futures | 80.37 | 80.56 | 80.17 | 80.45 | 216627.0 |
| 2011-02-23 | GF | Futures | 319.811 | 321.723 | 314.816 | 317.838 | 2524.0 |
| 2011-02-23 | GSCI | Futures | 1051.85 | 1083.58 | 1051.85 | 1076.36 | 317.0 |
| 2011-02-23 | HE | Futures | 107.698 | 108.106 | 105.101 | 106.151 | 19603.0 |
| 2011-02-23 | HG | Futures | 5.7815 | 5.8115 | 5.6809 | 5.7162 | 23288.0 |
| 2011-02-23 | HO | Futures | 2.3493 | 2.4553 | 2.3483 | 2.4404 | 25064.0 |
| 2011-02-23 | HRC | Futures | 2992.7 | 2992.7 | 2992.7 | 2992.7 | 0.0 |
| 2011-02-23 | J1 | Futures | 0.0151699 | 0.0152578 | 0.0151511 | 0.0152227 | 146603.0 |
| 2011-02-23 | J7 | Futures | 0.015068 | 0.015147 | 0.015045 | 0.015114 | 614.0 |
| 2011-02-23 | JB | Futures | 120.64 | 120.81 | 120.58 | 120.72 | 2372.0 |
| 2011-02-23 | KC | Futures | 666.03 | 668.82 | 650.4 | 653.07 | 11648.0 |
> showing 50 of 93 rows — these rows as CSV