PREVIEW / futures_daily / 2011-04-12
file: by_date/futures_daily/2011/2011-04-12.parquet size: 9 KB rows: 93
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 |
|---|---|---|---|---|---|---|---|
| 2011-04-12 | ES | Futures | 1307.06 | 1307.31 | 1292.21 | 1295.18 | 2078928.0 |
| 2011-04-12 | NQ | Futures | 2630.26 | 2630.83 | 2602.35 | 2611.47 | 288991.0 |
| 2011-04-12 | YM | Futures | 11583.9 | 11591.4 | 11448.5 | 11463.6 | 98554.0 |
| 2011-04-12 | CL | Futures | 210.73 | 213.18 | 203.96 | 205.47 | 555625.0 |
| 2011-04-12 | GC | Futures | 1983.2 | 1987.6 | 1955.8 | 1967.5 | 186445.0 |
| 2011-04-12 | ZN | Futures | 99.683428 | 100.539362 | 99.657092 | 100.368176 | 1292362.0 |
| 2011-04-12 | A6 | Futures | 0.89284 | 0.89541 | 0.88418 | 0.89104 | 121259.0 |
| 2011-04-12 | AD | Futures | 1.03984 | 1.04033 | 1.02938 | 1.03446 | 104046.0 |
| 2011-04-12 | B | Futures | 104.12 | 105.86 | 101.4 | 102.15 | 273726.0 |
| 2011-04-12 | B6 | Futures | 1.6969 | 1.697 | 1.6844 | 1.6873 | 138544.0 |
| 2011-04-12 | BFX | Futures | 3141.9 | 3141.9 | 3108.0 | 3108.0 | 1816.0 |
| 2011-04-12 | BR | Futures | 0.27559 | 0.27559 | 0.27469 | 0.27469 | 31.0 |
| 2011-04-12 | BZ | Futures | 111.02 | 111.02 | 106.97 | 107.7 | 1966.0 |
| 2011-04-12 | C | Futures | 2115.0 | 2146.0 | 2100.0 | 2140.0 | 4463.0 |
| 2011-04-12 | CB | Futures | 116.558 | 116.558 | 116.03 | 116.455 | 7.0 |
| 2011-04-12 | CC | Futures | 2406.0 | 2457.0 | 2405.0 | 2433.0 | 10549.0 |
| 2011-04-12 | CT | Futures | 183.76 | 184.28 | 176.7 | 178.6 | 13241.0 |
| 2011-04-12 | DC | Futures | 30.64 | 30.64 | 30.21 | 30.45 | 171.0 |
| 2011-04-12 | DX | Futures | 74.879 | 75.078 | 74.556 | 74.69 | 27137.0 |
| 2011-04-12 | E1 | Futures | 1.44518 | 1.46495 | 1.44308 | 1.46076 | 56466.0 |
| 2011-04-12 | E6 | Futures | 1.70745 | 1.71752 | 1.70046 | 1.71349 | 299001.0 |
| 2011-04-12 | E7 | Futures | 1.6945 | 1.7046 | 1.6878 | 1.7007 | 6597.0 |
| 2011-04-12 | EBM | Futures | 229.44 | 230.62 | 224.04 | 225.69 | 10072.0 |
| 2011-04-12 | ED | Futures | 94.9311 | 94.9359 | 94.9264 | 94.9311 | 184205.0 |
| 2011-04-12 | ER | Futures | 97.232 | 97.257 | 97.227 | 97.252 | 125596.0 |
| 2011-04-12 | EW | Futures | 972.6 | 973.4 | 961.4 | 961.9 | 20101.0 |
| 2011-04-12 | FBTP | Futures | 64.5 | 64.81 | 64.5 | 64.77 | 6220.0 |
| 2011-04-12 | FCE | Futures | 2688.5 | 2690.5 | 2654.1 | 2660.2 | 114481.0 |
| 2011-04-12 | FDAX | Futures | 7661.7 | 7688.9 | 7591.2 | 7611.5 | 146448.0 |
| 2011-04-12 | FESX | Futures | 1843.3 | 1851.7 | 1825.4 | 1829.9 | 1371309.0 |
| 2011-04-12 | FEU3 | Futures | 97.775 | 97.795 | 97.775 | 97.795 | 7.0 |
| 2011-04-12 | FGBL | Futures | 96.1 | 96.47 | 96.08 | 96.39 | 932360.0 |
| 2011-04-12 | FGBM | Futures | 102.05 | 102.34 | 102.03 | 102.28 | 636904.0 |
| 2011-04-12 | FGBS | Futures | 106.052 | 106.161 | 106.033 | 106.132 | 581600.0 |
| 2011-04-12 | FGBX | Futures | 90.81 | 91.48 | 90.73 | 91.32 | 4333.0 |
| 2011-04-12 | FTDX | Futures | 828.8 | 830.6 | 810.5 | 813.2 | 1006.0 |
| 2011-04-12 | FTI | Futures | 296.34 | 297.74 | 292.88 | 293.7 | 29520.0 |
| 2011-04-12 | FTUK | Futures | 4195.6 | 4195.6 | 4140.6 | 4146.6 | 107671.0 |
| 2011-04-12 | FXXP | Futures | 183.9 | 184.1 | 181.8 | 182.1 | 2687.0 |
| 2011-04-12 | G | Futures | 80.71 | 81.27 | 80.66 | 81.2 | 146075.0 |
| 2011-04-12 | GF | Futures | 325.076 | 325.076 | 318.278 | 318.278 | 3223.0 |
| 2011-04-12 | GSCI | Futures | 1180.95 | 1180.95 | 1137.83 | 1142.67 | 2850.0 |
| 2011-04-12 | HE | Futures | 107.318 | 107.318 | 105.485 | 106.468 | 998.0 |
| 2011-04-12 | HG | Futures | 5.9373 | 5.9606 | 5.8088 | 5.8388 | 50248.0 |
| 2011-04-12 | HO | Futures | 2.6996 | 2.7358 | 2.6309 | 2.6476 | 47404.0 |
| 2011-04-12 | HRC | Futures | 3017.7 | 3017.7 | 3017.7 | 3017.7 | 0.0 |
| 2011-04-12 | J1 | Futures | 0.0148408 | 0.0150581 | 0.0148219 | 0.0150104 | 172066.0 |
| 2011-04-12 | J7 | Futures | 0.014756 | 0.014962 | 0.014734 | 0.014918 | 1552.0 |
| 2011-04-12 | JB | Futures | 120.72 | 120.91 | 120.63 | 120.67 | 63.0 |
| 2011-04-12 | KC | Futures | 659.73 | 668.21 | 654.88 | 663.61 | 16276.0 |
> showing 50 of 93 rows — these rows as CSV