PREVIEW / futures_daily / 2015-01-20
file: by_date/futures_daily/2015/2015-01-20.parquet size: 9 KB rows: 106
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 |
|---|---|---|---|---|---|---|---|
| 2015-01-20 | ES | Futures | 2110.41 | 2124.03 | 2093.64 | 2113.81 | 1807759.0 |
| 2015-01-20 | NQ | Futures | 4802.16 | 4844.51 | 4767.64 | 4834.93 | 347445.0 |
| 2015-01-20 | YM | Futures | 17764.3 | 17860.0 | 17590.1 | 17783.6 | 231453.0 |
| 2015-01-20 | CL | Futures | 94.55 | 94.55 | 89.05 | 89.3 | 438892.0 |
| 2015-01-20 | GC | Futures | 1676.3 | 1697.9 | 1665.1 | 1694.0 | 249777.0 |
| 2015-01-20 | ZN | Futures | 122.307987 | 122.808526 | 122.16077 | 122.352153 | 1349692.0 |
| 2015-01-20 | A6 | Futures | 0.80238 | 0.80424 | 0.79601 | 0.79738 | 103229.0 |
| 2015-01-20 | AD | Futures | 0.84916 | 0.8514 | 0.83969 | 0.84091 | 79118.0 |
| 2015-01-20 | ALI | Futures | 2861.52 | 2861.52 | 2861.52 | 2861.52 | 0.0 |
| 2015-01-20 | B | Futures | 49.95 | 50.53 | 48.79 | 49.01 | 259584.0 |
| 2015-01-20 | B6 | Futures | 1.5907 | 1.5976 | 1.5826 | 1.5931 | 101412.0 |
| 2015-01-20 | BFX | Futures | 4112.0 | 4124.1 | 4106.0 | 4107.8 | 7.0 |
| 2015-01-20 | BR | Futures | 0.20814 | 0.20933 | 0.20668 | 0.20877 | 178.0 |
| 2015-01-20 | BZ | Futures | 51.54 | 51.67 | 49.08 | 49.28 | 33926.0 |
| 2015-01-20 | C | Futures | 2216.0 | 2227.0 | 2203.0 | 2204.0 | 3916.0 |
| 2015-01-20 | CB | Futures | 132.263 | 132.263 | 131.482 | 131.482 | 8.0 |
| 2015-01-20 | CC | Futures | 2180.0 | 2184.0 | 2154.0 | 2159.0 | 11088.0 |
| 2015-01-20 | CNH | Futures | 7.1181 | 7.1204 | 7.1019 | 7.1062 | 8.0 |
| 2015-01-20 | CSC | Futures | 4.248 | 4.27 | 4.208 | 4.262 | 69.0 |
| 2015-01-20 | CT | Futures | 75.61 | 75.85 | 73.78 | 73.81 | 25211.0 |
| 2015-01-20 | DC | Futures | 32.87 | 33.08 | 32.49 | 32.94 | 212.0 |
| 2015-01-20 | DX | Futures | 88.079 | 88.396 | 87.88 | 88.362 | 32220.0 |
| 2015-01-20 | E1 | Futures | 1.48761 | 1.49885 | 1.44981 | 1.45913 | 49435.0 |
| 2015-01-20 | E6 | Futures | 1.36104 | 1.36986 | 1.3581 | 1.35904 | 351981.0 |
| 2015-01-20 | E7 | Futures | 1.3528 | 1.3616 | 1.3501 | 1.3509 | 6328.0 |
| 2015-01-20 | EBM | Futures | 317.52 | 319.95 | 313.06 | 318.74 | 25330.0 |
| 2015-01-20 | ED | Futures | 95.4546 | 95.4594 | 95.4546 | 95.4594 | 115083.0 |
| 2015-01-20 | ER | Futures | 98.073 | 98.073 | 98.063 | 98.063 | 63918.0 |
| 2015-01-20 | EW | Futures | 1493.7 | 1500.1 | 1475.8 | 1488.5 | 19796.0 |
| 2015-01-20 | FBTP | Futures | 100.3 | 100.46 | 100.11 | 100.18 | 71811.0 |
| 2015-01-20 | FBTS | Futures | 98.969 | 99.031 | 98.969 | 99.014 | 14768.0 |
| 2015-01-20 | FCE | Futures | 3604.2 | 3644.6 | 3591.6 | 3625.8 | 99159.0 |
| 2015-01-20 | FDAX | Futures | 11451.6 | 11451.6 | 11340.6 | 11378.3 | 107501.0 |
| 2015-01-20 | FESX | Futures | 2333.7 | 2347.4 | 2322.9 | 2333.7 | 1121346.0 |
| 2015-01-20 | FGBL | Futures | 138.01 | 138.21 | 137.93 | 138.07 | 618305.0 |
| 2015-01-20 | FGBM | Futures | 124.13 | 124.15 | 123.99 | 124.06 | 304385.0 |
| 2015-01-20 | FGBS | Futures | 111.098 | 111.103 | 111.063 | 111.083 | 242413.0 |
| 2015-01-20 | FGBX | Futures | 161.99 | 162.71 | 161.93 | 162.55 | 25242.0 |
| 2015-01-20 | FMWO | Futures | 5565.5 | 5566.7 | 5522.2 | 5527.1 | 258.0 |
| 2015-01-20 | FOAT | Futures | 127.29 | 127.4 | 127.14 | 127.2 | 67531.0 |
| 2015-01-20 | FTDX | Futures | 1374.9 | 1376.8 | 1363.7 | 1371.2 | 165.0 |
| 2015-01-20 | FTI | Futures | 377.92 | 379.34 | 376.06 | 377.74 | 30997.0 |
| 2015-01-20 | FTUK | Futures | 5105.0 | 5136.6 | 5094.1 | 5108.9 | 81711.0 |
| 2015-01-20 | FVSA | Futures | 2091.9 | 2117.72 | 2005.81 | 2100.51 | 10750.0 |
| 2015-01-20 | FXXP | Futures | 267.4 | 269.2 | 267.0 | 268.1 | 9162.0 |
| 2015-01-20 | G | Futures | 105.14 | 105.25 | 104.73 | 105.05 | 185039.0 |
| 2015-01-20 | GF | Futures | 348.359 | 348.654 | 337.984 | 341.569 | 6643.0 |
| 2015-01-20 | GSCI | Futures | 671.93 | 671.93 | 656.93 | 657.45 | 268.0 |
| 2015-01-20 | HE | Futures | 103.937 | 103.937 | 100.181 | 100.181 | 13236.0 |
| 2015-01-20 | HG | Futures | 3.3453 | 3.3485 | 3.2456 | 3.2951 | 81573.0 |
> showing 50 of 106 rows — these rows as CSV