PREVIEW / futures_daily / 2013-03-27
file: by_date/futures_daily/2013/2013-03-27.parquet size: 9 KB rows: 104
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-03-27 | ES | Futures | 1599.79 | 1602.1 | 1586.96 | 1598.25 | 1569031.0 |
| 2013-03-27 | NQ | Futures | 3236.85 | 3241.18 | 3207.11 | 3235.41 | 185710.0 |
| 2013-03-27 | YM | Futures | 14259.5 | 14273.3 | 14144.3 | 14224.1 | 130736.0 |
| 2013-03-27 | CL | Futures | 167.87 | 169.02 | 166.82 | 168.57 | 207777.0 |
| 2013-03-27 | GC | Futures | 2125.4 | 2136.0 | 2113.3 | 2133.6 | 179889.0 |
| 2013-03-27 | ZN | Futures | 117.253276 | 117.82375 | 117.183706 | 117.656782 | 1361486.0 |
| 2013-03-27 | A6 | Futures | 0.96162 | 0.9619 | 0.9559 | 0.95839 | 79538.0 |
| 2013-03-27 | AD | Futures | 0.98667 | 0.98808 | 0.98366 | 0.98678 | 71537.0 |
| 2013-03-27 | B | Futures | 105.01 | 105.63 | 104.58 | 105.37 | 169997.0 |
| 2013-03-27 | B6 | Futures | 1.5856 | 1.588 | 1.5785 | 1.5824 | 84832.0 |
| 2013-03-27 | BFX | Futures | 3094.1 | 3097.6 | 3094.1 | 3097.6 | 13.0 |
| 2013-03-27 | BR | Futures | 0.24307 | 0.24497 | 0.2427 | 0.24485 | 1054.0 |
| 2013-03-27 | BZ | Futures | 106.31 | 106.92 | 105.88 | 106.68 | 4791.0 |
| 2013-03-27 | C | Futures | 1528.0 | 1543.0 | 1524.0 | 1537.0 | 9029.0 |
| 2013-03-27 | CB | Futures | 83.817 | 84.803 | 83.718 | 84.063 | 29.0 |
| 2013-03-27 | CC | Futures | 1623.0 | 1633.0 | 1611.0 | 1626.0 | 8280.0 |
| 2013-03-27 | CNH | Futures | 7.2682 | 7.2683 | 7.2682 | 7.2683 | 1.0 |
| 2013-03-27 | CSC | Futures | 3.772 | 3.772 | 3.772 | 3.772 | 23.0 |
| 2013-03-27 | CT | Futures | 108.01 | 109.07 | 107.19 | 108.91 | 10850.0 |
| 2013-03-27 | DC | Futures | 28.78 | 29.03 | 28.68 | 28.86 | 228.0 |
| 2013-03-27 | DX | Futures | 79.808 | 80.269 | 79.779 | 80.165 | 28787.0 |
| 2013-03-27 | E1 | Futures | 1.3578 | 1.3587 | 1.34764 | 1.35021 | 29009.0 |
| 2013-03-27 | E6 | Futures | 1.51684 | 1.51778 | 1.50411 | 1.50694 | 289448.0 |
| 2013-03-27 | E7 | Futures | 1.5069 | 1.508 | 1.4943 | 1.4971 | 4387.0 |
| 2013-03-27 | EBM | Futures | 286.13 | 288.17 | 285.26 | 287.59 | 14292.0 |
| 2013-03-27 | ED | Futures | 95.211 | 95.2301 | 95.1966 | 95.2062 | 251409.0 |
| 2013-03-27 | ER | Futures | 97.773 | 97.788 | 97.744 | 97.759 | 181428.0 |
| 2013-03-27 | EW | Futures | 1164.4 | 1168.6 | 1153.9 | 1167.3 | 17577.0 |
| 2013-03-27 | FBTP | Futures | 75.44 | 75.59 | 74.35 | 74.52 | 61151.0 |
| 2013-03-27 | FBTS | Futures | 91.422 | 91.439 | 91.037 | 91.071 | 10660.0 |
| 2013-03-27 | FCE | Futures | 2834.9 | 2839.4 | 2763.4 | 2797.2 | 164239.0 |
| 2013-03-27 | FDAX | Futures | 8799.2 | 8817.5 | 8624.1 | 8679.1 | 142364.0 |
| 2013-03-27 | FESX | Futures | 1807.1 | 1811.3 | 1765.1 | 1781.9 | 1403739.0 |
| 2013-03-27 | FEU3 | Futures | 98.364 | 98.364 | 98.354 | 98.359 | 21.0 |
| 2013-03-27 | FGBL | Futures | 121.47 | 122.09 | 121.39 | 121.96 | 878567.0 |
| 2013-03-27 | FGBM | Futures | 118.13 | 118.39 | 118.07 | 118.31 | 456155.0 |
| 2013-03-27 | FGBS | Futures | 110.547 | 110.612 | 110.532 | 110.582 | 406745.0 |
| 2013-03-27 | FGBX | Futures | 127.92 | 129.44 | 127.78 | 129.13 | 10963.0 |
| 2013-03-27 | FMWO | Futures | 4640.4 | 4640.4 | 4640.4 | 4640.4 | 0.0 |
| 2013-03-27 | FOAT | Futures | 106.74 | 107.1 | 106.68 | 107.0 | 29594.0 |
| 2013-03-27 | FTDX | Futures | 878.6 | 878.6 | 867.2 | 868.7 | 76.0 |
| 2013-03-27 | FTI | Futures | 301.31 | 301.96 | 296.61 | 297.78 | 40801.0 |
| 2013-03-27 | FTUK | Futures | 4714.9 | 4732.3 | 4671.1 | 4703.4 | 93959.0 |
| 2013-03-27 | FVSA | Futures | 3497.24 | 3698.04 | 3447.04 | 3547.44 | 9291.0 |
| 2013-03-27 | FXXP | Futures | 213.2 | 213.2 | 210.2 | 211.4 | 3945.0 |
| 2013-03-27 | G | Futures | 99.67 | 100.1 | 99.57 | 99.93 | 148995.0 |
| 2013-03-27 | GF | Futures | 254.173 | 258.308 | 253.897 | 258.032 | 2859.0 |
| 2013-03-27 | GSCI | Futures | 1050.33 | 1057.71 | 1047.36 | 1057.63 | 353.0 |
| 2013-03-27 | HE | Futures | 89.331 | 89.86 | 88.601 | 89.86 | 169.0 |
| 2013-03-27 | HG | Futures | 4.404 | 4.4142 | 4.369 | 4.3932 | 51978.0 |
> showing 50 of 104 rows — these rows as CSV