PREVIEW / futures_daily / 2016-03-01
file: by_date/futures_daily/2016/2016-03-01.parquet size: 9 KB rows: 109
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 |
|---|---|---|---|---|---|---|---|
| 2016-03-01 | ES | Futures | 2059.37 | 2113.31 | 2051.62 | 2112.77 | 2035550.0 |
| 2016-03-01 | NQ | Futures | 4922.81 | 5086.35 | 4900.54 | 5085.18 | 295763.0 |
| 2016-03-01 | YM | Futures | 17068.0 | 17442.6 | 17003.8 | 17435.4 | 173083.0 |
| 2016-03-01 | CL | Futures | 42.59 | 43.67 | 41.93 | 43.22 | 566226.0 |
| 2016-03-01 | GC | Futures | 1591.9 | 1605.3 | 1577.5 | 1581.5 | 225605.0 |
| 2016-03-01 | ZN | Futures | 126.063436 | 126.319143 | 125.130858 | 125.1459 | 154089.0 |
| 2016-03-01 | A6 | Futures | 0.71562 | 0.72033 | 0.71192 | 0.71853 | 96428.0 |
| 2016-03-01 | AD | Futures | 0.75539 | 0.76388 | 0.75447 | 0.76347 | 82555.0 |
| 2016-03-01 | ALI | Futures | 2129.53 | 2129.53 | 2129.53 | 2129.53 | 0.0 |
| 2016-03-01 | B | Futures | 30.48 | 31.02 | 29.94 | 30.66 | 276263.0 |
| 2016-03-01 | B6 | Futures | 1.4649 | 1.4752 | 1.4628 | 1.4681 | 98006.0 |
| 2016-03-01 | BR | Futures | 0.15842 | 0.16135 | 0.15842 | 0.16102 | 238.0 |
| 2016-03-01 | BZ | Futures | 30.24 | 30.71 | 29.63 | 30.35 | 28210.0 |
| 2016-03-01 | C | Futures | 2322.0 | 2329.0 | 2300.0 | 2313.0 | 16856.0 |
| 2016-03-01 | CB | Futures | 248.281 | 248.281 | 246.33 | 246.36 | 6.0 |
| 2016-03-01 | CC | Futures | 2155.0 | 2171.0 | 2137.0 | 2148.0 | 15438.0 |
| 2016-03-01 | CNH | Futures | 7.1939 | 7.1939 | 7.1939 | 7.1939 | 36.0 |
| 2016-03-01 | CSC | Futures | 3.651 | 3.651 | 3.558 | 3.563 | 95.0 |
| 2016-03-01 | CT | Futures | 65.1 | 66.33 | 64.37 | 64.44 | 22612.0 |
| 2016-03-01 | DC | Futures | 28.71 | 28.75 | 27.95 | 27.99 | 196.0 |
| 2016-03-01 | DX | Futures | 91.738 | 92.093 | 91.649 | 91.887 | 19335.0 |
| 2016-03-01 | E1 | Futures | 1.26539 | 1.26816 | 1.26198 | 1.26678 | 16660.0 |
| 2016-03-01 | E6 | Futures | 1.27297 | 1.27426 | 1.26724 | 1.27099 | 194223.0 |
| 2016-03-01 | E7 | Futures | 1.2654 | 1.2671 | 1.2601 | 1.2639 | 3599.0 |
| 2016-03-01 | EBM | Futures | 207.29 | 208.35 | 204.11 | 204.81 | 7739.0 |
| 2016-03-01 | ED | Futures | 95.6241 | 95.6313 | 95.6169 | 95.6241 | 197234.0 |
| 2016-03-01 | ER | Futures | 98.318 | 98.318 | 98.298 | 98.303 | 76235.0 |
| 2016-03-01 | EW | Futures | 1409.4 | 1440.7 | 1402.5 | 1440.4 | 21062.0 |
| 2016-03-01 | FBON | Futures | 117.71 | 117.99 | 117.67 | 117.96 | 527.0 |
| 2016-03-01 | FBTP | Futures | 106.58 | 106.86 | 106.47 | 106.7 | 150209.0 |
| 2016-03-01 | FBTS | Futures | 101.006 | 101.078 | 100.998 | 101.06 | 35400.0 |
| 2016-03-01 | FCE | Futures | 3593.9 | 3690.9 | 3592.2 | 3669.3 | 89600.0 |
| 2016-03-01 | FDAX | Futures | 10227.8 | 10601.3 | 10220.2 | 10534.1 | 120989.0 |
| 2016-03-01 | FDXM | Futures | 9771.0 | 10137.0 | 9771.0 | 10072.7 | 22726.0 |
| 2016-03-01 | FESX | Futures | 2221.0 | 2293.2 | 2219.5 | 2276.5 | 1479064.0 |
| 2016-03-01 | FEU3 | Futures | 98.961 | 98.961 | 98.961 | 98.961 | 250.0 |
| 2016-03-01 | FGBL | Futures | 146.81 | 146.83 | 146.14 | 146.3 | 917758.0 |
| 2016-03-01 | FGBM | Futures | 128.0 | 128.01 | 127.81 | 127.89 | 698328.0 |
| 2016-03-01 | FGBS | Futures | 111.867 | 111.867 | 111.817 | 111.837 | 291808.0 |
| 2016-03-01 | FGBX | Futures | 174.1 | 174.12 | 171.3 | 171.86 | 55949.0 |
| 2016-03-01 | FMWO | Futures | 5301.6 | 5311.6 | 5301.6 | 5311.6 | 150.0 |
| 2016-03-01 | FOAT | Futures | 133.36 | 133.36 | 132.63 | 132.84 | 152416.0 |
| 2016-03-01 | FTDX | Futures | 1543.8 | 1583.2 | 1543.8 | 1578.9 | 327.0 |
| 2016-03-01 | FTI | Futures | 374.92 | 388.91 | 374.92 | 386.65 | 38026.0 |
| 2016-03-01 | FTUK | Futures | 4914.4 | 5025.3 | 4902.1 | 4995.5 | 136852.0 |
| 2016-03-01 | FVSA | Futures | 3343.63 | 3355.32 | 3168.26 | 3209.18 | 14089.0 |
| 2016-03-01 | FXXP | Futures | 260.7 | 267.9 | 260.7 | 266.2 | 30437.0 |
| 2016-03-01 | G | Futures | 109.18 | 109.34 | 108.39 | 108.78 | 238293.0 |
| 2016-03-01 | GF | Futures | 309.747 | 312.643 | 306.801 | 310.336 | 3509.0 |
| 2016-03-01 | GSCI | Futures | 465.68 | 466.6 | 459.12 | 465.68 | 585.0 |
> showing 50 of 109 rows — these rows as CSV