PREVIEW / futures_daily / 2013-05-01
file: by_date/futures_daily/2013/2013-05-01.parquet size: 8 KB rows: 84
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-05-01 | ES | Futures | 1636.24 | 1638.04 | 1618.02 | 1619.3 | 1467806.0 |
| 2013-05-01 | NQ | Futures | 3331.28 | 3334.74 | 3306.16 | 3307.6 | 154074.0 |
| 2013-05-01 | YM | Futures | 14556.9 | 14566.7 | 14402.3 | 14412.1 | 112691.0 |
| 2013-05-01 | CL | Futures | 162.34 | 162.65 | 157.16 | 158.76 | 332382.0 |
| 2013-05-01 | GC | Futures | 1958.9 | 1961.3 | 1911.2 | 1919.9 | 170191.0 |
| 2013-05-01 | ZN | Futures | 118.755988 | 119.131666 | 118.686418 | 118.978612 | 792192.0 |
| 2013-05-01 | A6 | Futures | 0.95368 | 0.95497 | 0.94427 | 0.94676 | 100648.0 |
| 2013-05-01 | AD | Futures | 0.99642 | 0.99853 | 0.99371 | 0.99722 | 63617.0 |
| 2013-05-01 | B | Futures | 97.45 | 98.11 | 94.6 | 95.77 | 134730.0 |
| 2013-05-01 | B6 | Futures | 1.6248 | 1.6327 | 1.6242 | 1.6309 | 94655.0 |
| 2013-05-01 | BR | Futures | 0.24646 | 0.24646 | 0.24646 | 0.24646 | 2.0 |
| 2013-05-01 | BZ | Futures | 98.33 | 99.07 | 95.59 | 96.73 | 7296.0 |
| 2013-05-01 | C | Futures | 1634.0 | 1663.0 | 1622.0 | 1658.0 | 3032.0 |
| 2013-05-01 | CB | Futures | 86.159 | 86.282 | 86.159 | 86.282 | 5.0 |
| 2013-05-01 | CC | Futures | 1780.0 | 1815.0 | 1770.0 | 1811.0 | 21804.0 |
| 2013-05-01 | CSC | Futures | 3.835 | 3.843 | 3.833 | 3.843 | 7.0 |
| 2013-05-01 | CT | Futures | 104.82 | 104.99 | 100.19 | 100.52 | 23900.0 |
| 2013-05-01 | DC | Futures | 29.62 | 29.62 | 29.22 | 29.54 | 291.0 |
| 2013-05-01 | DX | Futures | 78.559 | 78.597 | 78.203 | 78.349 | 24788.0 |
| 2013-05-01 | E1 | Futures | 1.38456 | 1.39189 | 1.3825 | 1.39035 | 30639.0 |
| 2013-05-01 | E6 | Futures | 1.5528 | 1.56188 | 1.55209 | 1.55822 | 198603.0 |
| 2013-05-01 | E7 | Futures | 1.5428 | 1.5516 | 1.5418 | 1.5481 | 3306.0 |
| 2013-05-01 | ED | Futures | 95.2683 | 95.2731 | 95.2683 | 95.2683 | 81552.0 |
| 2013-05-01 | ER | Futures | 97.842 | 97.852 | 97.842 | 97.847 | 25779.0 |
| 2013-05-01 | EW | Futures | 1182.2 | 1182.3 | 1158.4 | 1159.1 | 28077.0 |
| 2013-05-01 | FTUK | Futures | 4752.4 | 4782.1 | 4735.7 | 4755.7 | 43938.0 |
| 2013-05-01 | G | Futures | 100.6 | 100.86 | 100.37 | 100.75 | 77035.0 |
| 2013-05-01 | GF | Futures | 252.517 | 254.465 | 252.336 | 252.789 | 1710.0 |
| 2013-05-01 | GSCI | Futures | 992.44 | 992.44 | 976.7 | 982.0 | 315.0 |
| 2013-05-01 | HE | Futures | 90.716 | 91.402 | 90.225 | 91.182 | 19349.0 |
| 2013-05-01 | HG | Futures | 4.0634 | 4.0717 | 3.8761 | 3.9239 | 61278.0 |
| 2013-05-01 | HH | Futures | 49.013 | 49.867 | 48.463 | 48.609 | 3748.0 |
| 2013-05-01 | HO | Futures | 2.2763 | 2.2858 | 2.2215 | 2.245 | 59188.0 |
| 2013-05-01 | HRC | Futures | 2135.1 | 2135.1 | 2135.1 | 2135.1 | 0.0 |
| 2013-05-01 | J1 | Futures | 0.0128823 | 0.012935 | 0.012846 | 0.0128861 | 113026.0 |
| 2013-05-01 | J7 | Futures | 0.012837 | 0.012912 | 0.012812 | 0.012852 | 1081.0 |
| 2013-05-01 | JB | Futures | 127.88 | 127.97 | 127.81 | 127.92 | 2525.0 |
| 2013-05-01 | KC | Futures | 272.93 | 273.03 | 267.49 | 271.22 | 13113.0 |
| 2013-05-01 | KE | Futures | 2558.68 | 2570.02 | 2517.36 | 2535.18 | 13038.0 |
| 2013-05-01 | L | Futures | 98.916 | 98.926 | 98.906 | 98.916 | 76211.0 |
| 2013-05-01 | LBS | Futures | 599.7 | 601.5 | 582.9 | 588.1 | 559.0 |
| 2013-05-01 | LE | Futures | 156.357 | 157.895 | 155.877 | 156.902 | 29041.0 |
| 2013-05-01 | MFS | Futures | 1609.4 | 1612.5 | 1595.4 | 1598.6 | 4733.0 |
| 2013-05-01 | MGC | Futures | 1935.3 | 1938.2 | 1888.5 | 1897.6 | 2219.0 |
| 2013-05-01 | MME | Futures | 964.5 | 966.0 | 951.1 | 953.7 | 9612.0 |
| 2013-05-01 | MP | Futures | 0.04827 | 0.04833 | 0.04783 | 0.04812 | 44617.0 |
| 2013-05-01 | N6 | Futures | 0.7336 | 0.7348 | 0.72613 | 0.72896 | 11960.0 |
| 2013-05-01 | NG | Futures | 65.338 | 66.903 | 64.886 | 65.127 | 165590.0 |
| 2013-05-01 | NIY | Futures | 11459.0 | 11459.0 | 11368.0 | 11392.8 | 20784.0 |
| 2013-05-01 | NKD | Futures | 13104.7 | 13104.7 | 12991.7 | 13010.5 | 4330.0 |
> showing 50 of 84 rows — these rows as CSV