PREVIEW / futures_daily / 2015-02-04
file: by_date/futures_daily/2015/2015-02-04.parquet size: 9 KB rows: 107
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-02-04 | ES | Futures | 2138.71 | 2147.88 | 2120.1 | 2127.7 | 1696963.0 |
| 2015-02-04 | NQ | Futures | 4882.22 | 4923.12 | 4858.72 | 4877.87 | 269497.0 |
| 2015-02-04 | YM | Futures | 17906.9 | 18039.3 | 17830.5 | 17892.6 | 176016.0 |
| 2015-02-04 | CL | Futures | 99.29 | 101.0 | 92.15 | 93.11 | 577515.0 |
| 2015-02-04 | GC | Futures | 1649.4 | 1664.8 | 1643.4 | 1653.3 | 136182.0 |
| 2015-02-04 | ZN | Futures | 122.455205 | 122.941021 | 122.087162 | 122.484648 | 1547015.0 |
| 2015-02-04 | A6 | Futures | 0.75918 | 0.76839 | 0.75653 | 0.76016 | 114505.0 |
| 2015-02-04 | AD | Futures | 0.81922 | 0.82146 | 0.80832 | 0.81015 | 89488.0 |
| 2015-02-04 | ALI | Futures | 2884.94 | 2884.94 | 2884.94 | 2884.94 | 0.0 |
| 2015-02-04 | B | Futures | 58.51 | 58.52 | 53.99 | 54.61 | 224731.0 |
| 2015-02-04 | B6 | Futures | 1.5927 | 1.6032 | 1.5915 | 1.6003 | 101998.0 |
| 2015-02-04 | BFX | Futures | 4289.5 | 4298.5 | 4289.5 | 4298.5 | 1.0 |
| 2015-02-04 | BR | Futures | 0.20187 | 0.20334 | 0.19917 | 0.19917 | 1334.0 |
| 2015-02-04 | BZ | Futures | 57.95 | 58.33 | 53.9 | 54.47 | 27932.0 |
| 2015-02-04 | C | Futures | 2091.0 | 2134.0 | 2075.0 | 2097.0 | 18390.0 |
| 2015-02-04 | CB | Futures | 154.443 | 156.908 | 154.033 | 156.908 | 68.0 |
| 2015-02-04 | CC | Futures | 2004.0 | 2055.0 | 2004.0 | 2015.0 | 21605.0 |
| 2015-02-04 | CNH | Futures | 7.1441 | 7.1537 | 7.1408 | 7.1452 | 124.0 |
| 2015-02-04 | CSC | Futures | 4.526 | 4.526 | 4.469 | 4.472 | 87.0 |
| 2015-02-04 | CT | Futures | 78.52 | 78.8 | 77.93 | 78.2 | 23017.0 |
| 2015-02-04 | DC | Futures | 36.7 | 36.96 | 36.37 | 36.47 | 339.0 |
| 2015-02-04 | DX | Futures | 88.93 | 89.64 | 88.76 | 89.134 | 21308.0 |
| 2015-02-04 | E1 | Futures | 1.38354 | 1.38967 | 1.37894 | 1.3852 | 11253.0 |
| 2015-02-04 | E6 | Futures | 1.3494 | 1.35152 | 1.33152 | 1.34363 | 293177.0 |
| 2015-02-04 | E7 | Futures | 1.3412 | 1.3432 | 1.3235 | 1.3356 | 4299.0 |
| 2015-02-04 | EBM | Futures | 304.95 | 306.16 | 301.3 | 302.51 | 19039.0 |
| 2015-02-04 | ED | Futures | 95.4498 | 95.4594 | 95.4402 | 95.4546 | 270262.0 |
| 2015-02-04 | ER | Futures | 98.038 | 98.043 | 98.033 | 98.038 | 55564.0 |
| 2015-02-04 | EW | Futures | 1537.6 | 1539.6 | 1522.9 | 1528.4 | 21221.0 |
| 2015-02-04 | FBTP | Futures | 101.19 | 101.69 | 100.99 | 101.49 | 82688.0 |
| 2015-02-04 | FBTS | Futures | 99.147 | 99.253 | 99.147 | 99.227 | 24150.0 |
| 2015-02-04 | FCE | Futures | 3828.5 | 3830.6 | 3786.5 | 3830.2 | 102428.0 |
| 2015-02-04 | FDAX | Futures | 12137.7 | 12147.7 | 11995.6 | 12104.4 | 113215.0 |
| 2015-02-04 | FESX | Futures | 2469.9 | 2469.9 | 2430.3 | 2458.4 | 1006098.0 |
| 2015-02-04 | FEU3 | Futures | 98.65 | 98.65 | 98.65 | 98.65 | 1.0 |
| 2015-02-04 | FGBL | Futures | 138.92 | 139.25 | 138.79 | 138.88 | 675582.0 |
| 2015-02-04 | FGBM | Futures | 124.34 | 124.48 | 124.33 | 124.36 | 384735.0 |
| 2015-02-04 | FGBS | Futures | 111.153 | 111.188 | 111.148 | 111.153 | 201652.0 |
| 2015-02-04 | FGBX | Futures | 167.32 | 168.62 | 167.12 | 167.78 | 23462.0 |
| 2015-02-04 | FMWO | Futures | 5652.0 | 5659.5 | 5645.9 | 5659.5 | 495.0 |
| 2015-02-04 | FOAT | Futures | 127.54 | 127.89 | 127.5 | 127.59 | 63997.0 |
| 2015-02-04 | FTDX | Futures | 1416.2 | 1416.7 | 1397.0 | 1404.5 | 73.0 |
| 2015-02-04 | FTI | Futures | 394.62 | 394.88 | 388.99 | 392.33 | 35226.0 |
| 2015-02-04 | FTUK | Futures | 5315.9 | 5322.9 | 5259.0 | 5298.7 | 97814.0 |
| 2015-02-04 | FVSA | Futures | 1997.2 | 2048.85 | 1967.07 | 1967.07 | 8866.0 |
| 2015-02-04 | FXXP | Futures | 280.1 | 281.0 | 278.3 | 280.6 | 9949.0 |
| 2015-02-04 | G | Futures | 105.56 | 105.74 | 105.03 | 105.15 | 237785.0 |
| 2015-02-04 | GF | Futures | 335.707 | 338.364 | 331.321 | 331.869 | 3555.0 |
| 2015-02-04 | GSCI | Futures | 705.03 | 705.03 | 678.13 | 683.65 | 343.0 |
| 2015-02-04 | HE | Futures | 93.976 | 94.245 | 91.058 | 91.394 | 19101.0 |
> showing 50 of 107 rows — these rows as CSV