PREVIEW / futures_daily / 2010-11-12
file: by_date/futures_daily/2010/2010-11-12.parquet size: 9 KB rows: 89
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-12 | ES | Futures | 1186.48 | 1187.71 | 1167.86 | 1171.78 | 2766115.0 |
| 2010-11-12 | NQ | Futures | 2462.53 | 2465.37 | 2403.0 | 2419.44 | 393579.0 |
| 2010-11-12 | YM | Futures | 10461.5 | 10469.0 | 10334.0 | 10376.8 | 154602.0 |
| 2010-11-12 | CL | Futures | 180.87 | 181.12 | 174.25 | 174.99 | 478815.0 |
| 2010-11-12 | GC | Futures | 1914.2 | 1916.6 | 1847.6 | 1856.1 | 301687.0 |
| 2010-11-12 | ZN | Futures | 104.651549 | 105.012861 | 103.709556 | 104.006348 | 1549019.0 |
| 2010-11-12 | A6 | Futures | 0.83409 | 0.83669 | 0.82158 | 0.82418 | 147267.0 |
| 2010-11-12 | AD | Futures | 0.98678 | 0.98747 | 0.97588 | 0.98034 | 110655.0 |
| 2010-11-12 | B | Futures | 75.7 | 75.71 | 73.21 | 73.61 | 222853.0 |
| 2010-11-12 | B6 | Futures | 1.673 | 1.6799 | 1.6592 | 1.6757 | 136538.0 |
| 2010-11-12 | BR | Futures | 0.2476 | 0.2476 | 0.24715 | 0.24715 | 91.0 |
| 2010-11-12 | BZ | Futures | 79.19 | 79.36 | 77.46 | 77.87 | 723.0 |
| 2010-11-12 | C | Futures | 1996.0 | 2006.0 | 1963.0 | 1965.0 | 4227.0 |
| 2010-11-12 | CC | Futures | 2317.0 | 2317.0 | 2249.0 | 2255.0 | 16081.0 |
| 2010-11-12 | CT | Futures | 120.92 | 120.92 | 117.83 | 118.65 | 14226.0 |
| 2010-11-12 | DC | Futures | 22.02 | 22.05 | 21.65 | 22.0 | 346.0 |
| 2010-11-12 | DX | Futures | 78.514 | 78.89 | 78.078 | 78.48 | 37467.0 |
| 2010-11-12 | E1 | Futures | 1.34549 | 1.35048 | 1.338 | 1.34325 | 41732.0 |
| 2010-11-12 | E6 | Futures | 1.61568 | 1.62928 | 1.60503 | 1.61934 | 482797.0 |
| 2010-11-12 | E7 | Futures | 1.6035 | 1.6168 | 1.593 | 1.6071 | 7944.0 |
| 2010-11-12 | ED | Futures | 94.7126 | 94.7363 | 94.7126 | 94.7316 | 282818.0 |
| 2010-11-12 | ER | Futures | 97.183 | 97.208 | 97.183 | 97.198 | 93031.0 |
| 2010-11-12 | EW | Futures | 840.7 | 840.8 | 825.0 | 826.9 | 25280.0 |
| 2010-11-12 | FBTP | Futures | 65.76 | 66.08 | 65.32 | 65.99 | 17192.0 |
| 2010-11-12 | FCE | Futures | 2563.2 | 2579.0 | 2524.7 | 2564.6 | 6777.0 |
| 2010-11-12 | FDAX | Futures | 7186.0 | 7279.0 | 7126.3 | 7248.9 | 205477.0 |
| 2010-11-12 | FESX | Futures | 1748.1 | 1772.5 | 1725.0 | 1761.2 | 1746412.0 |
| 2010-11-12 | FEU3 | Futures | 97.756 | 97.761 | 97.756 | 97.761 | 3.0 |
| 2010-11-12 | FGBL | Futures | 103.15 | 103.31 | 102.07 | 102.33 | 1285810.0 |
| 2010-11-12 | FGBM | Futures | 106.63 | 106.69 | 105.7 | 106.03 | 708831.0 |
| 2010-11-12 | FGBS | Futures | 107.435 | 107.45 | 107.199 | 107.263 | 596026.0 |
| 2010-11-12 | FGBX | Futures | 106.92 | 107.1 | 104.54 | 105.09 | 4078.0 |
| 2010-11-12 | FTDX | Futures | 690.6 | 691.9 | 682.7 | 689.3 | 1297.0 |
| 2010-11-12 | FTI | Futures | 274.36 | 277.66 | 269.53 | 276.25 | 1858.0 |
| 2010-11-12 | FTUK | Futures | 4021.0 | 4023.4 | 3939.4 | 4000.6 | 133524.0 |
| 2010-11-12 | G | Futures | 83.57 | 83.74 | 82.91 | 83.15 | 125275.0 |
| 2010-11-12 | GF | Futures | 286.286 | 287.968 | 284.169 | 284.978 | 2457.0 |
| 2010-11-12 | GSCI | Futures | 960.57 | 967.9 | 945.51 | 946.82 | 275.0 |
| 2010-11-12 | HE | Futures | 93.34 | 94.253 | 92.426 | 93.34 | 22028.0 |
| 2010-11-12 | HG | Futures | 5.3808 | 5.4055 | 5.1786 | 5.1966 | 51650.0 |
| 2010-11-12 | HO | Futures | 2.0471 | 2.0484 | 1.9821 | 1.9936 | 49759.0 |
| 2010-11-12 | HRC | Futures | 2437.0 | 2437.0 | 2437.0 | 2437.0 | 0.0 |
| 2010-11-12 | J1 | Futures | 0.0152328 | 0.0153873 | 0.0151989 | 0.0152416 | 136219.0 |
| 2010-11-12 | J7 | Futures | 0.015139 | 0.01528 | 0.015097 | 0.015137 | 241.0 |
| 2010-11-12 | JB | Futures | 121.25 | 121.74 | 121.2 | 121.61 | 3330.0 |
| 2010-11-12 | KC | Futures | 509.62 | 511.48 | 494.0 | 497.1 | 20842.0 |
| 2010-11-12 | KE | Futures | 3204.15 | 3228.13 | 3004.93 | 3045.61 | 21460.0 |
| 2010-11-12 | L | Futures | 98.115 | 98.145 | 98.106 | 98.135 | 52628.0 |
| 2010-11-12 | LBS | Futures | 763.7 | 763.7 | 742.4 | 750.9 | 117.0 |
| 2010-11-12 | LE | Futures | 155.977 | 156.134 | 153.979 | 154.214 | 19631.0 |
> showing 50 of 89 rows — these rows as CSV