PREVIEW / futures_daily / 2013-01-22
file: by_date/futures_daily/2013/2013-01-22.parquet size: 9 KB rows: 100
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-01-22 | ES | Futures | 1512.28 | 1526.1 | 1509.21 | 1524.05 | 1474784.0 |
| 2013-01-22 | NQ | Futures | 3153.79 | 3181.18 | 3138.22 | 3173.11 | 195839.0 |
| 2013-01-22 | YM | Futures | 13310.6 | 13451.8 | 13268.4 | 13430.2 | 117582.0 |
| 2013-01-22 | CL | Futures | 168.66 | 170.74 | 168.24 | 170.37 | 236391.0 |
| 2013-01-22 | GC | Futures | 2247.5 | 2260.0 | 2245.2 | 2256.4 | 165132.0 |
| 2013-01-22 | ZN | Futures | 116.54208 | 116.735031 | 116.321566 | 116.66612 | 1136588.0 |
| 2013-01-22 | A6 | Futures | 0.9571 | 0.96405 | 0.95618 | 0.96296 | 124739.0 |
| 2013-01-22 | AD | Futures | 1.00911 | 1.01061 | 1.0069 | 1.00891 | 87695.0 |
| 2013-01-22 | B | Futures | 104.78 | 105.67 | 104.45 | 105.45 | 207850.0 |
| 2013-01-22 | B6 | Futures | 1.6556 | 1.6604 | 1.6512 | 1.6554 | 189342.0 |
| 2013-01-22 | BFX | Futures | 3057.7 | 3070.9 | 3057.7 | 3067.8 | 61.0 |
| 2013-01-22 | BR | Futures | 0.2389 | 0.2389 | 0.23826 | 0.23856 | 1573.0 |
| 2013-01-22 | BZ | Futures | 107.02 | 108.02 | 106.77 | 107.8 | 7873.0 |
| 2013-01-22 | C | Futures | 1582.0 | 1592.0 | 1543.0 | 1547.0 | 12396.0 |
| 2013-01-22 | CB | Futures | 85.488 | 86.987 | 85.488 | 85.488 | 13.0 |
| 2013-01-22 | CC | Futures | 1725.0 | 1727.0 | 1665.0 | 1670.0 | 20549.0 |
| 2013-01-22 | CSC | Futures | 3.646 | 3.646 | 3.616 | 3.621 | 32.0 |
| 2013-01-22 | CT | Futures | 98.67 | 100.93 | 98.44 | 100.59 | 29710.0 |
| 2013-01-22 | DC | Futures | 27.01 | 27.09 | 26.78 | 26.87 | 236.0 |
| 2013-01-22 | DX | Futures | 77.333 | 77.338 | 76.948 | 77.129 | 24735.0 |
| 2013-01-22 | E1 | Futures | 1.37763 | 1.3887 | 1.3775 | 1.38612 | 51300.0 |
| 2013-01-22 | E6 | Futures | 1.57061 | 1.57769 | 1.56531 | 1.57144 | 400822.0 |
| 2013-01-22 | E7 | Futures | 1.56 | 1.5669 | 1.5546 | 1.5607 | 7399.0 |
| 2013-01-22 | EBM | Futures | 281.18 | 282.01 | 277.84 | 281.46 | 14038.0 |
| 2013-01-22 | ED | Futures | 95.2247 | 95.2295 | 95.2199 | 95.2247 | 87369.0 |
| 2013-01-22 | ER | Futures | 97.744 | 97.759 | 97.729 | 97.754 | 119026.0 |
| 2013-01-22 | EW | Futures | 1091.9 | 1102.4 | 1089.6 | 1101.2 | 12673.0 |
| 2013-01-22 | FBTP | Futures | 77.06 | 77.51 | 76.89 | 77.21 | 29533.0 |
| 2013-01-22 | FBTS | Futures | 91.738 | 91.874 | 91.713 | 91.772 | 4922.0 |
| 2013-01-22 | FCE | Futures | 2817.3 | 2823.7 | 2794.4 | 2807.2 | 101812.0 |
| 2013-01-22 | FDAX | Futures | 8455.0 | 8464.9 | 8336.5 | 8416.8 | 138238.0 |
| 2013-01-22 | FESX | Futures | 1851.3 | 1856.1 | 1835.0 | 1849.9 | 859132.0 |
| 2013-01-22 | FEU3 | Futures | 98.359 | 98.359 | 98.359 | 98.359 | 51.0 |
| 2013-01-22 | FGBL | Futures | 118.16 | 118.39 | 117.82 | 118.3 | 892405.0 |
| 2013-01-22 | FGBM | Futures | 116.08 | 116.26 | 115.92 | 116.2 | 519126.0 |
| 2013-01-22 | FGBS | Futures | 110.083 | 110.143 | 110.058 | 110.128 | 443545.0 |
| 2013-01-22 | FGBX | Futures | 124.84 | 125.08 | 124.03 | 124.89 | 14068.0 |
| 2013-01-22 | FOAT | Futures | 104.75 | 105.11 | 104.67 | 105.03 | 25245.0 |
| 2013-01-22 | FTDX | Futures | 825.1 | 825.1 | 818.0 | 823.2 | 93.0 |
| 2013-01-22 | FTI | Futures | 302.05 | 304.2 | 301.45 | 303.3 | 28027.0 |
| 2013-01-22 | FTUK | Futures | 4517.4 | 4532.5 | 4492.1 | 4518.2 | 78898.0 |
| 2013-01-22 | FVSA | Futures | 3039.67 | 3230.22 | 3039.67 | 3103.19 | 12706.0 |
| 2013-01-22 | FXXP | Futures | 206.6 | 207.2 | 205.2 | 206.8 | 8095.0 |
| 2013-01-22 | G | Futures | 96.93 | 97.22 | 96.81 | 97.15 | 177220.0 |
| 2013-01-22 | GF | Futures | 274.4 | 275.381 | 273.279 | 274.633 | 2791.0 |
| 2013-01-22 | GSCI | Futures | 1066.38 | 1070.23 | 1064.21 | 1069.27 | 1027.0 |
| 2013-01-22 | HE | Futures | 98.694 | 99.142 | 98.554 | 98.89 | 8947.0 |
| 2013-01-22 | HG | Futures | 4.7308 | 4.761 | 4.7026 | 4.7578 | 55090.0 |
| 2013-01-22 | HH | Futures | 42.523 | 42.758 | 41.149 | 41.772 | 933.0 |
| 2013-01-22 | HO | Futures | 2.4508 | 2.4825 | 2.4439 | 2.4652 | 47600.0 |
> showing 50 of 100 rows — these rows as CSV