PREVIEW / futures_daily / 2013-10-11
file: by_date/futures_daily/2013/2013-10-11.parquet size: 9 KB rows: 100
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 |
|---|---|---|---|---|---|---|---|
| 2013-10-11 | ES | Futures | 1728.82 | 1746.54 | 1718.55 | 1745.26 | 1558254.0 |
| 2013-10-11 | NQ | Futures | 3667.82 | 3710.32 | 3647.43 | 3704.57 | 230009.0 |
| 2013-10-11 | YM | Futures | 14949.8 | 15117.0 | 14874.2 | 15099.1 | 144838.0 |
| 2013-10-11 | CL | Futures | 182.24 | 182.26 | 178.1 | 180.62 | 298216.0 |
| 2013-10-11 | GC | Futures | 1677.0 | 1712.4 | 1665.9 | 1677.3 | 186264.0 |
| 2013-10-11 | ZN | Futures | 114.215442 | 114.569489 | 114.144633 | 114.300413 | 866391.0 |
| 2013-10-11 | A6 | Futures | 0.88962 | 0.89217 | 0.88707 | 0.89066 | 59339.0 |
| 2013-10-11 | AD | Futures | 0.97016 | 0.97581 | 0.96884 | 0.97551 | 51166.0 |
| 2013-10-11 | B | Futures | 110.57 | 110.62 | 109.37 | 110.06 | 222309.0 |
| 2013-10-11 | B6 | Futures | 1.6756 | 1.6789 | 1.6706 | 1.6745 | 62916.0 |
| 2013-10-11 | BR | Futures | 0.23105 | 0.23105 | 0.23016 | 0.23089 | 1037.0 |
| 2013-10-11 | BZ | Futures | 110.99 | 111.26 | 110.06 | 110.72 | 7289.0 |
| 2013-10-11 | C | Futures | 1884.0 | 1903.0 | 1883.0 | 1901.0 | 5650.0 |
| 2013-10-11 | CC | Futures | 2038.0 | 2051.0 | 2029.0 | 2047.0 | 7873.0 |
| 2013-10-11 | CSC | Futures | 3.338 | 3.371 | 3.338 | 3.358 | 14.0 |
| 2013-10-11 | CT | Futures | 97.69 | 98.65 | 97.57 | 97.8 | 10022.0 |
| 2013-10-11 | DC | Futures | 25.46 | 25.79 | 25.46 | 25.7 | 427.0 |
| 2013-10-11 | DX | Futures | 76.776 | 76.819 | 76.548 | 76.654 | 14418.0 |
| 2013-10-11 | E1 | Futures | 1.41089 | 1.4177 | 1.40768 | 1.41089 | 28412.0 |
| 2013-10-11 | E6 | Futures | 1.59646 | 1.60318 | 1.59587 | 1.59988 | 156465.0 |
| 2013-10-11 | E7 | Futures | 1.5862 | 1.5928 | 1.5856 | 1.5896 | 5486.0 |
| 2013-10-11 | ED | Futures | 95.3255 | 95.3255 | 95.3064 | 95.3208 | 106911.0 |
| 2013-10-11 | ER | Futures | 97.832 | 97.842 | 97.813 | 97.832 | 78021.0 |
| 2013-10-11 | EW | Futures | 1267.7 | 1285.2 | 1261.0 | 1284.8 | 18985.0 |
| 2013-10-11 | FBTP | Futures | 79.52 | 79.93 | 79.45 | 79.82 | 34130.0 |
| 2013-10-11 | FBTS | Futures | 94.085 | 94.241 | 94.059 | 94.223 | 8260.0 |
| 2013-10-11 | FCE | Futures | 3267.1 | 3268.3 | 3249.0 | 3259.0 | 97578.0 |
| 2013-10-11 | FDAX | Futures | 9686.3 | 9709.6 | 9652.5 | 9676.9 | 67168.0 |
| 2013-10-11 | FESX | Futures | 2084.6 | 2085.3 | 2071.9 | 2077.5 | 695165.0 |
| 2013-10-11 | FGBL | Futures | 119.04 | 119.1 | 118.76 | 119.03 | 613184.0 |
| 2013-10-11 | FGBM | Futures | 117.45 | 117.52 | 117.34 | 117.49 | 389063.0 |
| 2013-10-11 | FGBS | Futures | 110.413 | 110.438 | 110.393 | 110.418 | 226457.0 |
| 2013-10-11 | FGBX | Futures | 119.44 | 119.54 | 118.68 | 119.28 | 17652.0 |
| 2013-10-11 | FMWO | Futures | 5104.2 | 5104.2 | 5104.2 | 5104.2 | 0.0 |
| 2013-10-11 | FOAT | Futures | 106.62 | 106.64 | 106.39 | 106.63 | 34431.0 |
| 2013-10-11 | FTDX | Futures | 1025.2 | 1028.5 | 1018.6 | 1022.8 | 56.0 |
| 2013-10-11 | FTI | Futures | 322.99 | 324.76 | 322.99 | 323.9 | 214.0 |
| 2013-10-11 | FTUK | Futures | 4818.4 | 4868.7 | 4804.2 | 4843.5 | 80245.0 |
| 2013-10-11 | FVSA | Futures | 2634.39 | 2634.39 | 2464.85 | 2464.85 | 11753.0 |
| 2013-10-11 | FXXP | Futures | 226.6 | 227.1 | 226.1 | 226.7 | 12901.0 |
| 2013-10-11 | G | Futures | 92.32 | 92.53 | 92.18 | 92.45 | 106149.0 |
| 2013-10-11 | GF | Futures | 270.915 | 273.778 | 270.632 | 273.052 | 3420.0 |
| 2013-10-11 | GSCI | Futures | 1065.63 | 1065.63 | 1058.04 | 1063.96 | 1869.0 |
| 2013-10-11 | HE | Futures | 109.832 | 110.054 | 109.326 | 109.484 | 12526.0 |
| 2013-10-11 | HG | Futures | 4.1069 | 4.1449 | 4.0835 | 4.1392 | 49412.0 |
| 2013-10-11 | HH | Futures | 40.139 | 40.363 | 40.075 | 40.31 | 1386.0 |
| 2013-10-11 | HO | Futures | 2.4405 | 2.4408 | 2.407 | 2.4282 | 41001.0 |
| 2013-10-11 | HRC | Futures | 2324.5 | 2324.5 | 2324.5 | 2324.5 | 0.0 |
| 2013-10-11 | J1 | Futures | 0.0128094 | 0.0128559 | 0.0127628 | 0.0127804 | 100885.0 |
| 2013-10-11 | J7 | Futures | 0.012793 | 0.012843 | 0.012754 | 0.012769 | 550.0 |
> showing 50 of 100 rows — these rows as CSV