PREVIEW / futures_daily / 2012-08-15
file: by_date/futures_daily/2012/2012-08-15.parquet size: 9 KB rows: 98
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 |
|---|---|---|---|---|---|---|---|
| 2012-08-15 | ES | Futures | 1419.07 | 1423.63 | 1414.77 | 1421.35 | 1103484.0 |
| 2012-08-15 | NQ | Futures | 3128.52 | 3145.73 | 3120.19 | 3143.15 | 162515.0 |
| 2012-08-15 | YM | Futures | 12738.4 | 12777.2 | 12708.3 | 12743.3 | 80307.0 |
| 2012-08-15 | CL | Futures | 169.26 | 172.24 | 168.25 | 171.18 | 148221.0 |
| 2012-08-15 | GC | Futures | 2137.8 | 2148.0 | 2125.7 | 2145.0 | 101682.0 |
| 2012-08-15 | ZN | Futures | 115.991235 | 116.086566 | 115.460102 | 115.555434 | 1217534.0 |
| 2012-08-15 | A6 | Futures | 0.94037 | 0.94262 | 0.93722 | 0.94208 | 90526.0 |
| 2012-08-15 | AD | Futures | 1.01002 | 1.01343 | 1.00832 | 1.01333 | 74389.0 |
| 2012-08-15 | B | Futures | 101.62 | 104.21 | 101.32 | 103.78 | 220545.0 |
| 2012-08-15 | B6 | Futures | 1.6379 | 1.6408 | 1.6365 | 1.6394 | 74954.0 |
| 2012-08-15 | BFX | Futures | 2808.1 | 2825.1 | 2804.6 | 2818.9 | 250.0 |
| 2012-08-15 | BR | Futures | 0.23546 | 0.23565 | 0.23546 | 0.23556 | 38.0 |
| 2012-08-15 | BZ | Futures | 107.31 | 109.78 | 107.31 | 109.37 | 1863.0 |
| 2012-08-15 | C | Futures | 1685.0 | 1690.0 | 1658.0 | 1667.0 | 2386.0 |
| 2012-08-15 | CC | Futures | 1841.0 | 1860.0 | 1825.0 | 1837.0 | 15046.0 |
| 2012-08-15 | CSC | Futures | 4.088 | 4.119 | 4.088 | 4.119 | 14.0 |
| 2012-08-15 | CT | Futures | 95.66 | 96.11 | 94.41 | 95.78 | 74.0 |
| 2012-08-15 | DC | Futures | 29.84 | 30.58 | 29.84 | 30.53 | 322.0 |
| 2012-08-15 | DX | Futures | 80.168 | 80.411 | 80.085 | 80.281 | 12114.0 |
| 2012-08-15 | E1 | Futures | 1.32473 | 1.32744 | 1.31918 | 1.32176 | 28214.0 |
| 2012-08-15 | E6 | Futures | 1.45351 | 1.45658 | 1.44702 | 1.45009 | 160227.0 |
| 2012-08-15 | E7 | Futures | 1.4444 | 1.4474 | 1.4381 | 1.4411 | 2937.0 |
| 2012-08-15 | ED | Futures | 95.1728 | 95.1752 | 95.1704 | 95.1728 | 100991.0 |
| 2012-08-15 | ER | Futures | 97.827 | 97.832 | 97.822 | 97.822 | 32454.0 |
| 2012-08-15 | EW | Futures | 970.5 | 977.5 | 967.4 | 976.7 | 15117.0 |
| 2012-08-15 | FBTP | Futures | 66.19 | 66.77 | 66.14 | 66.65 | 5039.0 |
| 2012-08-15 | FBTS | Futures | 86.419 | 86.568 | 86.377 | 86.485 | 456.0 |
| 2012-08-15 | FCE | Futures | 2554.6 | 2576.9 | 2547.9 | 2565.7 | 116959.0 |
| 2012-08-15 | FDAX | Futures | 7580.8 | 7615.2 | 7541.5 | 7590.1 | 89877.0 |
| 2012-08-15 | FESX | Futures | 1636.0 | 1649.5 | 1631.3 | 1644.8 | 586524.0 |
| 2012-08-15 | FGBL | Futures | 117.6 | 117.66 | 116.73 | 116.8 | 594259.0 |
| 2012-08-15 | FGBM | Futures | 116.07 | 116.1 | 115.65 | 115.69 | 358536.0 |
| 2012-08-15 | FGBS | Futures | 110.487 | 110.497 | 110.437 | 110.457 | 261428.0 |
| 2012-08-15 | FGBX | Futures | 124.99 | 125.04 | 122.99 | 123.18 | 6146.0 |
| 2012-08-15 | FOAT | Futures | 102.73 | 102.77 | 102.26 | 102.28 | 11036.0 |
| 2012-08-15 | FTDX | Futures | 723.1 | 727.2 | 723.1 | 726.8 | 34.0 |
| 2012-08-15 | FTI | Futures | 281.2 | 284.18 | 281.2 | 283.32 | 53451.0 |
| 2012-08-15 | FTUK | Futures | 4249.5 | 4259.0 | 4233.9 | 4244.4 | 66959.0 |
| 2012-08-15 | FVSA | Futures | 6699.3 | 6750.54 | 6430.3 | 6724.92 | 4740.0 |
| 2012-08-15 | FXXP | Futures | 193.4 | 194.4 | 192.6 | 193.8 | 1280.0 |
| 2012-08-15 | G | Futures | 99.36 | 99.56 | 98.98 | 99.05 | 123594.0 |
| 2012-08-15 | GF | Futures | 285.806 | 286.544 | 284.131 | 284.624 | 1439.0 |
| 2012-08-15 | GSCI | Futures | 1054.11 | 1069.72 | 1054.11 | 1066.58 | 307.0 |
| 2012-08-15 | HE | Futures | 95.84 | 96.056 | 93.338 | 93.43 | 16149.0 |
| 2012-08-15 | HG | Futures | 4.3157 | 4.3447 | 4.2951 | 4.3151 | 35969.0 |
| 2012-08-15 | HO | Futures | 2.4778 | 2.5292 | 2.4701 | 2.5225 | 57139.0 |
| 2012-08-15 | HRC | Futures | 2548.9 | 2548.9 | 2548.9 | 2548.9 | 0.0 |
| 2012-08-15 | J1 | Futures | 0.0159268 | 0.0159494 | 0.0158566 | 0.0158867 | 74690.0 |
| 2012-08-15 | J7 | Futures | 0.015843 | 0.015888 | 0.015796 | 0.015824 | 228.0 |
| 2012-08-15 | JB | Futures | 126.29 | 126.3 | 125.97 | 126.0 | 4744.0 |
> showing 50 of 98 rows — these rows as CSV