PREVIEW / futures_daily / 2013-02-27
file: by_date/futures_daily/2013/2013-02-27.parquet size: 9 KB rows: 101
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-02-27 | ES | Futures | 1527.89 | 1554.49 | 1524.56 | 1550.91 | 2458935.0 |
| 2013-02-27 | NQ | Futures | 3126.97 | 3180.9 | 3118.03 | 3161.0 | 281226.0 |
| 2013-02-27 | YM | Futures | 13600.9 | 13817.6 | 13577.3 | 13787.2 | 183260.0 |
| 2013-02-27 | CL | Futures | 162.39 | 163.53 | 161.45 | 162.46 | 201512.0 |
| 2013-02-27 | GC | Futures | 2144.8 | 2145.8 | 2115.2 | 2121.0 | 172158.0 |
| 2013-02-27 | ZN | Futures | 116.98311 | 117.3001 | 116.900417 | 116.941764 | 1808848.0 |
| 2013-02-27 | A6 | Futures | 0.9344 | 0.93623 | 0.93047 | 0.93614 | 112856.0 |
| 2013-02-27 | AD | Futures | 0.97672 | 0.97993 | 0.97512 | 0.97933 | 72646.0 |
| 2013-02-27 | B | Futures | 106.72 | 107.2 | 105.56 | 105.76 | 79738.0 |
| 2013-02-27 | B6 | Futures | 1.5807 | 1.587 | 1.5757 | 1.5827 | 134279.0 |
| 2013-02-27 | BFX | Futures | 3052.1 | 3055.6 | 3052.1 | 3055.6 | 5.0 |
| 2013-02-27 | BR | Futures | 0.24735 | 0.24814 | 0.24735 | 0.24814 | 107.0 |
| 2013-02-27 | BZ | Futures | 109.23 | 109.76 | 108.11 | 108.3 | 4125.0 |
| 2013-02-27 | C | Futures | 1516.0 | 1520.0 | 1502.0 | 1512.0 | 6751.0 |
| 2013-02-27 | CB | Futures | 81.968 | 81.968 | 81.352 | 81.845 | 17.0 |
| 2013-02-27 | CC | Futures | 1602.0 | 1622.0 | 1597.0 | 1612.0 | 9504.0 |
| 2013-02-27 | CSC | Futures | 3.55 | 3.552 | 3.55 | 3.552 | 8.0 |
| 2013-02-27 | CT | Futures | 100.76 | 104.27 | 100.76 | 103.81 | 20119.0 |
| 2013-02-27 | DC | Futures | 26.81 | 26.95 | 26.73 | 26.81 | 51.0 |
| 2013-02-27 | DX | Futures | 79.026 | 79.069 | 78.655 | 78.768 | 38846.0 |
| 2013-02-27 | E1 | Futures | 1.38162 | 1.38664 | 1.37969 | 1.38252 | 32255.0 |
| 2013-02-27 | E6 | Futures | 1.54113 | 1.5508 | 1.53818 | 1.54844 | 346071.0 |
| 2013-02-27 | E7 | Futures | 1.5305 | 1.5401 | 1.5277 | 1.5379 | 4706.0 |
| 2013-02-27 | EBM | Futures | 270.33 | 274.51 | 270.33 | 274.23 | 5887.0 |
| 2013-02-27 | ED | Futures | 95.2342 | 95.2366 | 95.2318 | 95.2342 | 93292.0 |
| 2013-02-27 | ER | Futures | 97.798 | 97.808 | 97.793 | 97.803 | 117242.0 |
| 2013-02-27 | EW | Futures | 1105.8 | 1127.8 | 1103.7 | 1124.3 | 21098.0 |
| 2013-02-27 | FBTP | Futures | 73.49 | 74.24 | 73.29 | 74.08 | 83136.0 |
| 2013-02-27 | FBTS | Futures | 90.536 | 90.807 | 90.417 | 90.705 | 11676.0 |
| 2013-02-27 | FCE | Futures | 2728.0 | 2793.0 | 2718.2 | 2772.7 | 129612.0 |
| 2013-02-27 | FDAX | Futures | 8331.6 | 8435.9 | 8261.2 | 8384.1 | 151826.0 |
| 2013-02-27 | FESX | Futures | 1754.6 | 1792.7 | 1745.7 | 1779.8 | 1408568.0 |
| 2013-02-27 | FGBL | Futures | 119.94 | 120.18 | 119.68 | 119.92 | 989335.0 |
| 2013-02-27 | FGBM | Futures | 117.4 | 117.62 | 117.27 | 117.4 | 439185.0 |
| 2013-02-27 | FGBS | Futures | 110.407 | 110.452 | 110.377 | 110.417 | 382023.0 |
| 2013-02-27 | FGBX | Futures | 126.38 | 126.63 | 125.67 | 126.19 | 8423.0 |
| 2013-02-27 | FOAT | Futures | 105.36 | 105.6 | 105.33 | 105.43 | 60185.0 |
| 2013-02-27 | FTDX | Futures | 859.7 | 860.1 | 853.5 | 859.2 | 37.0 |
| 2013-02-27 | FTI | Futures | 288.59 | 291.73 | 286.36 | 289.92 | 34006.0 |
| 2013-02-27 | FTUK | Futures | 4607.2 | 4675.2 | 4597.2 | 4646.9 | 90411.0 |
| 2013-02-27 | FVSA | Futures | 3983.33 | 3983.33 | 3756.49 | 3801.86 | 9930.0 |
| 2013-02-27 | FXXP | Futures | 205.4 | 208.0 | 204.6 | 207.1 | 5050.0 |
| 2013-02-27 | G | Futures | 97.81 | 98.23 | 97.76 | 98.03 | 214029.0 |
| 2013-02-27 | GF | Futures | 263.751 | 265.245 | 263.003 | 264.264 | 2584.0 |
| 2013-02-27 | GSCI | Futures | 1050.51 | 1053.81 | 1044.64 | 1045.68 | 768.0 |
| 2013-02-27 | HE | Futures | 91.384 | 91.636 | 90.46 | 90.74 | 21982.0 |
| 2013-02-27 | HG | Futures | 4.5795 | 4.5865 | 4.5469 | 4.5508 | 51908.0 |
| 2013-02-27 | HH | Futures | 39.926 | 40.67 | 39.113 | 39.33 | 2519.0 |
| 2013-02-27 | HO | Futures | 2.4843 | 2.4952 | 2.4491 | 2.4512 | 25970.0 |
| 2013-02-27 | HRC | Futures | 2239.5 | 2239.5 | 2217.7 | 2217.7 | 1.0 |
> showing 50 of 101 rows — these rows as CSV