PREVIEW / futures_daily / 2014-04-22
file: by_date/futures_daily/2014/2014-04-22.parquet size: 9 KB rows: 103
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 |
|---|---|---|---|---|---|---|---|
| 2014-04-22 | ES | Futures | 1928.82 | 1943.83 | 1925.2 | 1938.91 | 1106460.0 |
| 2014-04-22 | NQ | Futures | 4090.74 | 4130.74 | 4081.53 | 4126.71 | 214083.0 |
| 2014-04-22 | YM | Futures | 16431.1 | 16565.6 | 16409.0 | 16525.5 | 112791.0 |
| 2014-04-22 | CL | Futures | 187.65 | 187.74 | 183.86 | 184.3 | 323723.0 |
| 2014-04-22 | GC | Futures | 1700.1 | 1703.8 | 1681.0 | 1688.0 | 118730.0 |
| 2014-04-22 | ZN | Futures | 114.736403 | 114.866785 | 114.504612 | 114.620508 | 928263.0 |
| 2014-04-22 | A6 | Futures | 0.89241 | 0.89769 | 0.89231 | 0.89606 | 54142.0 |
| 2014-04-22 | AD | Futures | 0.91968 | 0.92049 | 0.91694 | 0.91826 | 38685.0 |
| 2014-04-22 | B | Futures | 113.54 | 113.59 | 112.08 | 112.85 | 201105.0 |
| 2014-04-22 | B6 | Futures | 1.7643 | 1.7692 | 1.7635 | 1.7673 | 53898.0 |
| 2014-04-22 | BFX | Futures | 3715.8 | 3747.8 | 3715.8 | 3747.8 | 30.0 |
| 2014-04-22 | BR | Futures | 0.23265 | 0.23289 | 0.23176 | 0.23265 | 2715.0 |
| 2014-04-22 | BZ | Futures | 115.65 | 115.76 | 114.24 | 115.01 | 6487.0 |
| 2014-04-22 | C | Futures | 1956.0 | 1966.0 | 1948.0 | 1950.0 | 7134.0 |
| 2014-04-22 | CB | Futures | 93.415 | 93.415 | 93.415 | 93.415 | 39.0 |
| 2014-04-22 | CC | Futures | 2222.0 | 2235.0 | 2211.0 | 2217.0 | 7721.0 |
| 2014-04-22 | CSC | Futures | 4.325 | 4.406 | 4.301 | 4.383 | 37.0 |
| 2014-04-22 | CT | Futures | 100.77 | 102.46 | 100.77 | 102.29 | 2284.0 |
| 2014-04-22 | DC | Futures | 34.59 | 35.32 | 34.33 | 35.04 | 373.0 |
| 2014-04-22 | DX | Futures | 76.064 | 76.064 | 75.874 | 75.997 | 11179.0 |
| 2014-04-22 | E1 | Futures | 1.45073 | 1.45355 | 1.4488 | 1.4506 | 19090.0 |
| 2014-04-22 | E6 | Futures | 1.6282 | 1.63198 | 1.62702 | 1.62926 | 102650.0 |
| 2014-04-22 | E7 | Futures | 1.6176 | 1.621 | 1.6163 | 1.6184 | 2142.0 |
| 2014-04-22 | EBM | Futures | 302.62 | 302.97 | 299.1 | 302.62 | 18791.0 |
| 2014-04-22 | ED | Futures | 95.4091 | 95.4138 | 95.4043 | 95.4091 | 54810.0 |
| 2014-04-22 | ER | Futures | 97.837 | 97.842 | 97.827 | 97.832 | 38554.0 |
| 2014-04-22 | EW | Futures | 1394.9 | 1409.3 | 1392.0 | 1406.2 | 13176.0 |
| 2014-04-22 | FBTP | Futures | 88.45 | 88.78 | 88.39 | 88.72 | 35962.0 |
| 2014-04-22 | FBTS | Futures | 97.46 | 97.548 | 97.46 | 97.531 | 6128.0 |
| 2014-04-22 | FCE | Futures | 3482.5 | 3513.9 | 3477.8 | 3508.7 | 89473.0 |
| 2014-04-22 | FDAX | Futures | 10459.5 | 10635.1 | 10439.1 | 10621.3 | 85461.0 |
| 2014-04-22 | FESX | Futures | 2235.5 | 2258.5 | 2225.5 | 2257.1 | 718573.0 |
| 2014-04-22 | FGBL | Futures | 124.13 | 124.26 | 123.94 | 124.01 | 392472.0 |
| 2014-04-22 | FGBM | Futures | 119.76 | 119.84 | 119.67 | 119.72 | 266512.0 |
| 2014-04-22 | FGBS | Futures | 110.513 | 110.528 | 110.493 | 110.508 | 154831.0 |
| 2014-04-22 | FGBX | Futures | 127.74 | 127.86 | 127.27 | 127.35 | 11995.0 |
| 2014-04-22 | FMWO | Futures | 5574.6 | 5574.6 | 5574.6 | 5574.6 | 0.0 |
| 2014-04-22 | FOAT | Futures | 113.5 | 113.56 | 113.31 | 113.39 | 34861.0 |
| 2014-04-22 | FTDX | Futures | 1134.8 | 1151.7 | 1134.8 | 1149.4 | 193.0 |
| 2014-04-22 | FTI | Futures | 339.44 | 340.87 | 337.15 | 339.96 | 24442.0 |
| 2014-04-22 | FTUK | Futures | 5039.4 | 5076.0 | 5029.1 | 5059.2 | 93760.0 |
| 2014-04-22 | FVSA | Futures | 1766.03 | 1775.55 | 1723.19 | 1727.95 | 7969.0 |
| 2014-04-22 | FXXP | Futures | 247.9 | 250.3 | 247.6 | 250.1 | 9295.0 |
| 2014-04-22 | G | Futures | 93.91 | 93.96 | 93.56 | 93.6 | 100082.0 |
| 2014-04-22 | GF | Futures | 284.092 | 285.564 | 283.574 | 283.853 | 2773.0 |
| 2014-04-22 | GSCI | Futures | 1093.67 | 1093.67 | 1085.8 | 1090.19 | 126.0 |
| 2014-04-22 | HE | Futures | 140.447 | 141.176 | 139.397 | 141.176 | 384.0 |
| 2014-04-22 | HG | Futures | 3.8685 | 3.8838 | 3.8448 | 3.8768 | 21112.0 |
| 2014-04-22 | HH | Futures | 59.604 | 59.997 | 59.44 | 59.984 | 2680.0 |
| 2014-04-22 | HO | Futures | 2.3967 | 2.399 | 2.3713 | 2.3872 | 43376.0 |
> showing 50 of 103 rows — these rows as CSV