PREVIEW / futures_daily / 2013-11-21
file: by_date/futures_daily/2013/2013-11-21.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 |
|---|---|---|---|---|---|---|---|
| 2013-11-21 | ES | Futures | 1827.95 | 1844.38 | 1824.1 | 1842.59 | 1390391.0 |
| 2013-11-21 | NQ | Futures | 3867.95 | 3911.88 | 3859.34 | 3905.57 | 204624.0 |
| 2013-11-21 | YM | Futures | 15800.5 | 15906.0 | 15768.7 | 15895.1 | 120600.0 |
| 2013-11-21 | CL | Futures | 165.83 | 169.19 | 165.37 | 168.85 | 222138.0 |
| 2013-11-21 | GC | Futures | 1642.3 | 1653.2 | 1634.4 | 1644.7 | 197767.0 |
| 2013-11-21 | ZN | Futures | 114.456194 | 114.626136 | 114.116309 | 114.527003 | 1614183.0 |
| 2013-11-21 | A6 | Futures | 0.87971 | 0.88027 | 0.86743 | 0.86941 | 142449.0 |
| 2013-11-21 | AD | Futures | 0.96611 | 0.96621 | 0.95924 | 0.95934 | 67045.0 |
| 2013-11-21 | B | Futures | 107.72 | 110.21 | 107.58 | 110.04 | 253964.0 |
| 2013-11-21 | B6 | Futures | 1.6896 | 1.7004 | 1.6868 | 1.6963 | 104146.0 |
| 2013-11-21 | BFX | Futures | 3437.4 | 3438.9 | 3437.4 | 3438.9 | 10.0 |
| 2013-11-21 | BR | Futures | 0.22146 | 0.22174 | 0.21922 | 0.22016 | 170.0 |
| 2013-11-21 | BZ | Futures | 108.53 | 110.96 | 108.33 | 110.77 | 8039.0 |
| 2013-11-21 | C | Futures | 1901.0 | 1906.0 | 1885.0 | 1891.0 | 3236.0 |
| 2013-11-21 | CB | Futures | 74.214 | 74.901 | 73.969 | 74.901 | 8.0 |
| 2013-11-21 | CC | Futures | 2077.0 | 2085.0 | 2058.0 | 2074.0 | 10473.0 |
| 2013-11-21 | CSC | Futures | 3.387 | 3.445 | 3.375 | 3.443 | 21.0 |
| 2013-11-21 | CT | Futures | 88.9 | 89.22 | 87.4 | 87.74 | 4244.0 |
| 2013-11-21 | DC | Futures | 25.85 | 26.39 | 25.73 | 26.34 | 776.0 |
| 2013-11-21 | DX | Futures | 77.358 | 77.496 | 77.176 | 77.288 | 17608.0 |
| 2013-11-21 | E1 | Futures | 1.40241 | 1.40819 | 1.39881 | 1.4046 | 33334.0 |
| 2013-11-21 | E6 | Futures | 1.58595 | 1.59174 | 1.58135 | 1.58855 | 230041.0 |
| 2013-11-21 | E7 | Futures | 1.576 | 1.5814 | 1.5713 | 1.5783 | 4416.0 |
| 2013-11-21 | ED | Futures | 95.371 | 95.3733 | 95.371 | 95.371 | 71498.0 |
| 2013-11-21 | ER | Futures | 97.891 | 97.896 | 97.881 | 97.886 | 52933.0 |
| 2013-11-21 | EW | Futures | 1313.3 | 1330.9 | 1311.1 | 1329.8 | 16333.0 |
| 2013-11-21 | FBTP | Futures | 81.5 | 81.75 | 81.33 | 81.61 | 39628.0 |
| 2013-11-21 | FBTS | Futures | 95.356 | 95.485 | 95.321 | 95.477 | 8108.0 |
| 2013-11-21 | FCE | Futures | 3289.6 | 3307.1 | 3271.3 | 3297.3 | 98713.0 |
| 2013-11-21 | FDAX | Futures | 10153.5 | 10230.6 | 10117.5 | 10213.4 | 86727.0 |
| 2013-11-21 | FESX | Futures | 2120.3 | 2141.4 | 2111.9 | 2135.1 | 738858.0 |
| 2013-11-21 | FEU3 | Futures | 98.512 | 98.512 | 98.507 | 98.507 | 6.0 |
| 2013-11-21 | FGBL | Futures | 119.87 | 120.1 | 119.69 | 120.05 | 837152.0 |
| 2013-11-21 | FGBM | Futures | 118.33 | 118.51 | 118.2 | 118.41 | 668652.0 |
| 2013-11-21 | FGBS | Futures | 110.598 | 110.633 | 110.573 | 110.618 | 430841.0 |
| 2013-11-21 | FGBX | Futures | 119.67 | 120.25 | 119.36 | 120.21 | 18998.0 |
| 2013-11-21 | FMWO | Futures | 5321.8 | 5329.4 | 5321.8 | 5329.4 | 4.0 |
| 2013-11-21 | FOAT | Futures | 108.1 | 108.48 | 107.99 | 108.35 | 44118.0 |
| 2013-11-21 | FTDX | Futures | 1068.5 | 1069.5 | 1068.1 | 1069.0 | 45.0 |
| 2013-11-21 | FTI | Futures | 340.18 | 342.34 | 339.49 | 341.09 | 22971.0 |
| 2013-11-21 | FTUK | Futures | 5001.4 | 5025.4 | 4981.2 | 5017.9 | 84402.0 |
| 2013-11-21 | FVSA | Futures | 2027.11 | 2045.26 | 1954.49 | 1960.54 | 14500.0 |
| 2013-11-21 | FXXP | Futures | 234.5 | 235.5 | 233.7 | 235.3 | 3536.0 |
| 2013-11-21 | G | Futures | 91.92 | 91.97 | 91.26 | 91.62 | 240725.0 |
| 2013-11-21 | GF | Futures | 262.13 | 263.377 | 261.486 | 263.015 | 2924.0 |
| 2013-11-21 | GSCI | Futures | 1023.13 | 1032.0 | 1023.13 | 1032.0 | 85.0 |
| 2013-11-21 | HE | Futures | 110.144 | 110.325 | 109.147 | 109.389 | 12243.0 |
| 2013-11-21 | HG | Futures | 3.9823 | 4.0511 | 3.9791 | 4.0404 | 20659.0 |
| 2013-11-21 | HH | Futures | 37.971 | 38.33 | 37.622 | 37.981 | 9753.0 |
| 2013-11-21 | HO | Futures | 2.3534 | 2.3957 | 2.3495 | 2.3948 | 15127.0 |
> showing 50 of 103 rows — these rows as CSV