PREVIEW / futures_daily / 2015-11-04
file: by_date/futures_daily/2015/2015-11-04.parquet size: 9 KB rows: 110
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-11-04 | ES | Futures | 2236.54 | 2244.25 | 2223.77 | 2228.29 | 1546504.0 |
| 2015-11-04 | NQ | Futures | 5509.02 | 5530.06 | 5485.05 | 5506.39 | 231004.0 |
| 2015-11-04 | YM | Futures | 18402.8 | 18475.0 | 18320.2 | 18352.2 | 137072.0 |
| 2015-11-04 | CL | Futures | 75.8 | 76.66 | 73.31 | 73.55 | 459307.0 |
| 2015-11-04 | GC | Futures | 1442.4 | 1448.8 | 1427.2 | 1428.0 | 157673.0 |
| 2015-11-04 | ZN | Futures | 121.805634 | 121.925374 | 121.461381 | 121.581121 | 1373910.0 |
| 2015-11-04 | A6 | Futures | 0.71673 | 0.72093 | 0.71213 | 0.71343 | 74072.0 |
| 2015-11-04 | AD | Futures | 0.78387 | 0.7849 | 0.77609 | 0.77773 | 52120.0 |
| 2015-11-04 | ALI | Futures | 2099.68 | 2099.68 | 2099.68 | 2099.68 | 14.0 |
| 2015-11-04 | B | Futures | 44.98 | 45.55 | 43.49 | 43.54 | 204520.0 |
| 2015-11-04 | B6 | Futures | 1.6236 | 1.6261 | 1.6172 | 1.6193 | 69506.0 |
| 2015-11-04 | BFX | Futures | 4403.3 | 4403.3 | 4377.8 | 4382.1 | 7.0 |
| 2015-11-04 | BR | Futures | 0.16254 | 0.16291 | 0.16008 | 0.16103 | 1777.0 |
| 2015-11-04 | BZ | Futures | 44.8 | 45.23 | 43.23 | 43.26 | 20382.0 |
| 2015-11-04 | C | Futures | 2364.0 | 2364.0 | 2324.0 | 2330.0 | 6227.0 |
| 2015-11-04 | CB | Futures | 215.521 | 217.489 | 215.521 | 217.366 | 17.0 |
| 2015-11-04 | CC | Futures | 2418.0 | 2419.0 | 2379.0 | 2392.0 | 25247.0 |
| 2015-11-04 | CNH | Futures | 7.0737 | 7.0798 | 7.0731 | 7.0761 | 49.0 |
| 2015-11-04 | CSC | Futures | 4.202 | 4.243 | 4.202 | 4.235 | 53.0 |
| 2015-11-04 | CT | Futures | 75.14 | 75.44 | 74.14 | 74.3 | 27702.0 |
| 2015-11-04 | DC | Futures | 33.5 | 33.88 | 33.37 | 33.86 | 555.0 |
| 2015-11-04 | DX | Futures | 91.034 | 91.796 | 91.001 | 91.683 | 29911.0 |
| 2015-11-04 | E1 | Futures | 1.28176 | 1.28455 | 1.27605 | 1.27732 | 18958.0 |
| 2015-11-04 | E6 | Futures | 1.28471 | 1.28553 | 1.27089 | 1.27276 | 254062.0 |
| 2015-11-04 | E7 | Futures | 1.2777 | 1.2786 | 1.2639 | 1.2657 | 5301.0 |
| 2015-11-04 | EBM | Futures | 263.8 | 269.65 | 262.71 | 269.65 | 24489.0 |
| 2015-11-04 | ED | Futures | 95.7159 | 95.7256 | 95.6967 | 95.7063 | 357495.0 |
| 2015-11-04 | ER | Futures | 98.2 | 98.205 | 98.195 | 98.195 | 49279.0 |
| 2015-11-04 | EW | Futures | 1543.3 | 1550.0 | 1537.2 | 1540.8 | 14839.0 |
| 2015-11-04 | FBON | Futures | 115.23 | 115.25 | 114.89 | 114.89 | 990.0 |
| 2015-11-04 | FBTP | Futures | 104.07 | 104.56 | 103.87 | 103.93 | 113630.0 |
| 2015-11-04 | FBTS | Futures | 100.534 | 100.579 | 100.525 | 100.534 | 20672.0 |
| 2015-11-04 | FCE | Futures | 4129.2 | 4163.4 | 4116.7 | 4125.5 | 80735.0 |
| 2015-11-04 | FDAX | Futures | 12084.2 | 12125.0 | 11908.0 | 11938.8 | 94557.0 |
| 2015-11-04 | FDIV | Futures | 142.61 | 142.61 | 141.68 | 141.68 | 15.0 |
| 2015-11-04 | FDXM | Futures | 11288.1 | 11330.3 | 11127.6 | 11154.4 | 8500.0 |
| 2015-11-04 | FESX | Futures | 2584.2 | 2599.1 | 2566.9 | 2572.9 | 999983.0 |
| 2015-11-04 | FEU3 | Futures | 98.858 | 98.858 | 98.848 | 98.848 | 60.0 |
| 2015-11-04 | FGBL | Futures | 139.36 | 139.65 | 139.0 | 139.12 | 649956.0 |
| 2015-11-04 | FGBM | Futures | 125.56 | 125.7 | 125.5 | 125.52 | 431822.0 |
| 2015-11-04 | FGBS | Futures | 111.443 | 111.453 | 111.418 | 111.423 | 229348.0 |
| 2015-11-04 | FGBX | Futures | 158.39 | 158.67 | 156.78 | 157.25 | 30935.0 |
| 2015-11-04 | FMWO | Futures | 5753.4 | 5760.9 | 5730.0 | 5730.0 | 224.0 |
| 2015-11-04 | FOAT | Futures | 127.76 | 128.14 | 127.5 | 127.62 | 80474.0 |
| 2015-11-04 | FTDX | Futures | 1730.6 | 1730.6 | 1701.7 | 1703.1 | 186.0 |
| 2015-11-04 | FTI | Futures | 407.56 | 411.35 | 407.16 | 407.73 | 34005.0 |
| 2015-11-04 | FTUK | Futures | 5122.1 | 5177.2 | 5120.9 | 5137.8 | 104175.0 |
| 2015-11-04 | FVSA | Futures | 2021.86 | 2035.64 | 1980.5 | 2021.86 | 8676.0 |
| 2015-11-04 | FXXP | Futures | 295.7 | 297.8 | 295.2 | 295.7 | 23778.0 |
| 2015-11-04 | G | Futures | 103.64 | 103.77 | 103.4 | 103.5 | 182608.0 |
> showing 50 of 110 rows — these rows as CSV