PREVIEW / futures_daily / 2013-10-25
file: by_date/futures_daily/2013/2013-10-25.parquet size: 9 KB rows: 102
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-25 | ES | Futures | 1795.59 | 1803.55 | 1790.2 | 1801.75 | 1253456.0 |
| 2013-10-25 | NQ | Futures | 3878.29 | 3896.66 | 3860.49 | 3874.84 | 223017.0 |
| 2013-10-25 | YM | Futures | 15384.6 | 15436.4 | 15338.9 | 15419.4 | 99720.0 |
| 2013-10-25 | CL | Futures | 172.93 | 174.48 | 172.57 | 174.1 | 192632.0 |
| 2013-10-25 | GC | Futures | 1781.3 | 1793.9 | 1766.0 | 1788.7 | 120214.0 |
| 2013-10-25 | ZN | Futures | 115.475848 | 115.7166 | 115.419201 | 115.659953 | 609105.0 |
| 2013-10-25 | A6 | Futures | 0.90521 | 0.90596 | 0.90115 | 0.90219 | 60985.0 |
| 2013-10-25 | AD | Futures | 0.96824 | 0.96935 | 0.9646 | 0.96551 | 45193.0 |
| 2013-10-25 | B | Futures | 106.64 | 106.93 | 105.93 | 106.55 | 120318.0 |
| 2013-10-25 | B6 | Futures | 1.7 | 1.7048 | 1.6946 | 1.6971 | 73204.0 |
| 2013-10-25 | BR | Futures | 0.23107 | 0.23133 | 0.23059 | 0.23059 | 21.0 |
| 2013-10-25 | BZ | Futures | 107.28 | 107.62 | 106.66 | 107.26 | 6631.0 |
| 2013-10-25 | C | Futures | 1823.0 | 1845.0 | 1813.0 | 1838.0 | 6233.0 |
| 2013-10-25 | CB | Futures | 70.378 | 70.857 | 69.778 | 69.778 | 44.0 |
| 2013-10-25 | CC | Futures | 2000.0 | 2035.0 | 1992.0 | 2022.0 | 12847.0 |
| 2013-10-25 | CSC | Futures | 3.426 | 3.439 | 3.408 | 3.439 | 20.0 |
| 2013-10-25 | CT | Futures | 92.92 | 94.01 | 92.45 | 92.77 | 18470.0 |
| 2013-10-25 | DC | Futures | 26.07 | 26.21 | 25.89 | 26.13 | 296.0 |
| 2013-10-25 | DX | Futures | 75.514 | 75.633 | 75.328 | 75.505 | 11624.0 |
| 2013-10-25 | E1 | Futures | 1.44058 | 1.44572 | 1.43402 | 1.44019 | 27373.0 |
| 2013-10-25 | E6 | Futures | 1.62867 | 1.63257 | 1.62572 | 1.62938 | 148588.0 |
| 2013-10-25 | E7 | Futures | 1.6178 | 1.622 | 1.6152 | 1.6189 | 3111.0 |
| 2013-10-25 | ED | Futures | 95.359 | 95.3638 | 95.3542 | 95.359 | 73129.0 |
| 2013-10-25 | ER | Futures | 97.842 | 97.852 | 97.837 | 97.842 | 80319.0 |
| 2013-10-25 | EW | Futures | 1313.9 | 1318.3 | 1309.9 | 1317.8 | 14366.0 |
| 2013-10-25 | FBTP | Futures | 80.8 | 80.8 | 80.3 | 80.51 | 60246.0 |
| 2013-10-25 | FBTS | Futures | 94.673 | 94.673 | 94.474 | 94.543 | 15430.0 |
| 2013-10-25 | FCE | Futures | 3297.4 | 3314.5 | 3284.2 | 3308.2 | 76603.0 |
| 2013-10-25 | FDAX | Futures | 9932.7 | 10000.9 | 9916.0 | 9974.9 | 74663.0 |
| 2013-10-25 | FESX | Futures | 2116.8 | 2130.1 | 2113.3 | 2122.4 | 679896.0 |
| 2013-10-25 | FEU3 | Futures | 98.468 | 98.468 | 98.463 | 98.463 | 1.0 |
| 2013-10-25 | FGBL | Futures | 119.94 | 120.17 | 119.93 | 120.11 | 476676.0 |
| 2013-10-25 | FGBM | Futures | 117.91 | 117.99 | 117.84 | 117.91 | 290895.0 |
| 2013-10-25 | FGBS | Futures | 110.428 | 110.433 | 110.393 | 110.408 | 209694.0 |
| 2013-10-25 | FGBX | Futures | 120.85 | 121.32 | 120.76 | 121.18 | 14912.0 |
| 2013-10-25 | FMWO | Futures | 5282.6 | 5282.6 | 5282.6 | 5282.6 | 0.0 |
| 2013-10-25 | FOAT | Futures | 107.81 | 107.89 | 107.73 | 107.88 | 27427.0 |
| 2013-10-25 | FTDX | Futures | 1054.4 | 1056.8 | 1051.1 | 1054.4 | 46.0 |
| 2013-10-25 | FTI | Futures | 335.13 | 335.99 | 334.39 | 335.17 | 19402.0 |
| 2013-10-25 | FTUK | Futures | 5025.1 | 5032.6 | 5009.7 | 5023.2 | 68744.0 |
| 2013-10-25 | FVSA | Futures | 2148.37 | 2148.37 | 2099.68 | 2099.68 | 2344.0 |
| 2013-10-25 | FXXP | Futures | 232.8 | 233.7 | 232.6 | 233.2 | 3335.0 |
| 2013-10-25 | G | Futures | 93.17 | 93.36 | 93.04 | 93.34 | 108843.0 |
| 2013-10-25 | GF | Futures | 269.624 | 270.511 | 268.253 | 268.818 | 1330.0 |
| 2013-10-25 | GSCI | Futures | 1038.53 | 1042.29 | 1035.95 | 1040.62 | 328.0 |
| 2013-10-25 | HE | Futures | 113.471 | 114.769 | 113.281 | 114.452 | 16932.0 |
| 2013-10-25 | HG | Futures | 4.1373 | 4.1443 | 4.0949 | 4.1392 | 49176.0 |
| 2013-10-25 | HH | Futures | 38.741 | 39.131 | 38.72 | 39.11 | 116.0 |
| 2013-10-25 | HO | Futures | 2.323 | 2.3359 | 2.3151 | 2.3299 | 50751.0 |
| 2013-10-25 | HRC | Futures | 2317.9 | 2317.9 | 2317.9 | 2317.9 | 0.0 |
> showing 50 of 102 rows — these rows as CSV