PREVIEW / futures_daily / 2009-02-27
file: by_date/futures_daily/2009/2009-02-27.parquet size: 9 KB rows: 87
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-02-27 | ES | Futures | 710.34 | 713.88 | 688.86 | 693.34 | 3023734.0 |
| 2009-02-27 | NQ | Futures | 1264.44 | 1273.11 | 1237.89 | 1248.79 | 401798.0 |
| 2009-02-27 | YM | Futures | 6390.3 | 6415.3 | 6243.4 | 6279.0 | 240794.0 |
| 2009-02-27 | CL | Futures | 125.53 | 126.43 | 119.79 | 126.01 | 274579.0 |
| 2009-02-27 | GC | Futures | 1314.2 | 1337.8 | 1286.4 | 1307.9 | 148526.0 |
| 2009-02-27 | ZN | Futures | 93.076782 | 93.722236 | 92.873584 | 93.100688 | 286061.0 |
| 2009-02-27 | A6 | Futures | 0.51337 | 0.51353 | 0.50211 | 0.50973 | 44727.0 |
| 2009-02-27 | AD | Futures | 0.78424 | 0.78474 | 0.7702 | 0.77363 | 51354.0 |
| 2009-02-27 | B | Futures | 46.38 | 46.57 | 44.51 | 46.2 | 70552.0 |
| 2009-02-27 | B6 | Futures | 1.4868 | 1.4927 | 1.4659 | 1.4882 | 78986.0 |
| 2009-02-27 | BFX | Futures | 1844.8 | 1864.8 | 1838.4 | 1858.2 | 63.0 |
| 2009-02-27 | BR | Futures | 0.15568 | 0.15568 | 0.15568 | 0.15568 | 31.0 |
| 2009-02-27 | BZ | Futures | 47.24 | 48.19 | 47.24 | 48.19 | 4.0 |
| 2009-02-27 | C | Futures | 1819.0 | 1844.0 | 1819.0 | 1835.0 | 1318.0 |
| 2009-02-27 | CB | Futures | 76.887 | 76.887 | 76.436 | 76.436 | 11.0 |
| 2009-02-27 | CC | Futures | 2102.0 | 2132.0 | 2081.0 | 2123.0 | 4443.0 |
| 2009-02-27 | CT | Futures | 41.79 | 41.9 | 40.36 | 40.81 | 6327.0 |
| 2009-02-27 | DC | Futures | 27.14 | 27.43 | 27.07 | 27.07 | 69.0 |
| 2009-02-27 | DX | Futures | 91.312 | 91.95 | 91.084 | 91.405 | 5967.0 |
| 2009-02-27 | E1 | Futures | 1.14108 | 1.1448 | 1.13005 | 1.13776 | 33163.0 |
| 2009-02-27 | E6 | Futures | 1.50734 | 1.50924 | 1.49184 | 1.50308 | 229340.0 |
| 2009-02-27 | E7 | Futures | 1.4897 | 1.4918 | 1.4749 | 1.4859 | 2261.0 |
| 2009-02-27 | EBM | Futures | 213.22 | 213.22 | 210.15 | 211.68 | 2320.0 |
| 2009-02-27 | ED | Futures | 92.9824 | 93.0012 | 92.9471 | 92.9753 | 168570.0 |
| 2009-02-27 | ER | Futures | 96.429 | 96.449 | 96.424 | 96.444 | 60181.0 |
| 2009-02-27 | EW | Futures | 444.2 | 449.6 | 430.5 | 438.7 | 49136.0 |
| 2009-02-27 | FCE | Futures | 1676.4 | 1708.2 | 1648.0 | 1684.2 | 164065.0 |
| 2009-02-27 | FDAX | Futures | 4229.1 | 4263.0 | 4106.9 | 4200.7 | 192940.0 |
| 2009-02-27 | FESX | Futures | 1134.7 | 1150.2 | 1112.3 | 1134.7 | 1611468.0 |
| 2009-02-27 | FEU3 | Futures | 97.007 | 97.017 | 96.993 | 97.012 | 1927.0 |
| 2009-02-27 | FGBL | Futures | 93.12 | 93.8 | 93.01 | 93.15 | 713020.0 |
| 2009-02-27 | FGBM | Futures | 97.97 | 98.39 | 97.86 | 98.01 | 390565.0 |
| 2009-02-27 | FGBS | Futures | 103.829 | 103.935 | 103.757 | 103.858 | 412578.0 |
| 2009-02-27 | FGBX | Futures | 84.56 | 85.55 | 84.53 | 84.8 | 1413.0 |
| 2009-02-27 | FTDX | Futures | 397.3 | 399.1 | 390.2 | 395.6 | 289.0 |
| 2009-02-27 | FTI | Futures | 177.64 | 181.07 | 175.0 | 178.66 | 41513.0 |
| 2009-02-27 | FTUK | Futures | 2514.8 | 2531.5 | 2452.2 | 2496.4 | 160303.0 |
| 2009-02-27 | G | Futures | 75.67 | 76.35 | 75.44 | 75.61 | 91606.0 |
| 2009-02-27 | GF | Futures | 259.785 | 262.59 | 256.979 | 259.785 | 415.0 |
| 2009-02-27 | GSCI | Futures | 722.07 | 736.95 | 715.07 | 734.32 | 121.0 |
| 2009-02-27 | HE | Futures | 114.101 | 118.064 | 113.279 | 117.725 | 7836.0 |
| 2009-02-27 | HG | Futures | 2.2112 | 2.2231 | 2.0809 | 2.1675 | 12710.0 |
| 2009-02-27 | HO | Futures | 1.4204 | 1.4204 | 1.3747 | 1.4154 | 6435.0 |
| 2009-02-27 | HRC | Futures | 2953.0 | 2953.0 | 2953.0 | 2953.0 | 0.0 |
| 2009-02-27 | J1 | Futures | 0.0128195 | 0.0130456 | 0.0128182 | 0.0129079 | 99843.0 |
| 2009-02-27 | J7 | Futures | 0.012672 | 0.012884 | 0.012672 | 0.012753 | 111.0 |
| 2009-02-27 | JB | Futures | 116.86 | 116.88 | 116.67 | 116.82 | 4.0 |
| 2009-02-27 | KC | Futures | 318.15 | 318.29 | 309.57 | 314.77 | 7993.0 |
| 2009-02-27 | KE | Futures | 2765.75 | 2794.1 | 2726.31 | 2760.82 | 5892.0 |
| 2009-02-27 | L | Futures | 96.522 | 96.581 | 96.522 | 96.551 | 26673.0 |
> showing 50 of 87 rows — these rows as CSV