PREVIEW / futures_daily / 2011-04-15
file: by_date/futures_daily/2011/2011-04-15.parquet size: 9 KB rows: 94
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 |
|---|---|---|---|---|---|---|---|
| 2011-04-15 | ES | Futures | 1297.41 | 1306.07 | 1292.71 | 1305.58 | 1644200.0 |
| 2011-04-15 | NQ | Futures | 2621.43 | 2635.1 | 2607.19 | 2630.54 | 236995.0 |
| 2011-04-15 | YM | Futures | 11502.1 | 11577.3 | 11457.0 | 11567.0 | 87644.0 |
| 2011-04-15 | CL | Futures | 210.23 | 213.27 | 207.68 | 212.4 | 190936.0 |
| 2011-04-15 | GC | Futures | 1998.6 | 2015.5 | 1992.6 | 2011.3 | 160619.0 |
| 2011-04-15 | ZN | Futures | 100.328671 | 101.066091 | 100.328671 | 100.973914 | 1129867.0 |
| 2011-04-15 | A6 | Futures | 0.89739 | 0.90082 | 0.89499 | 0.89996 | 66142.0 |
| 2011-04-15 | AD | Futures | 1.03476 | 1.03705 | 1.03038 | 1.03516 | 62728.0 |
| 2011-04-15 | B | Futures | 103.83 | 105.2 | 103.14 | 104.72 | 136575.0 |
| 2011-04-15 | B6 | Futures | 1.6967 | 1.6997 | 1.6912 | 1.6927 | 85559.0 |
| 2011-04-15 | BFX | Futures | 3136.4 | 3195.6 | 3136.4 | 3195.6 | 12.0 |
| 2011-04-15 | BR | Futures | 0.27647 | 0.27792 | 0.27647 | 0.27676 | 56.0 |
| 2011-04-15 | BZ | Futures | 109.44 | 110.64 | 108.87 | 110.4 | 452.0 |
| 2011-04-15 | C | Futures | 2169.0 | 2191.0 | 2165.0 | 2178.0 | 1502.0 |
| 2011-04-15 | CB | Futures | 117.922 | 118.509 | 117.922 | 117.922 | 12.0 |
| 2011-04-15 | CC | Futures | 2489.0 | 2527.0 | 2477.0 | 2513.0 | 5262.0 |
| 2011-04-15 | CSC | Futures | 4.528 | 4.528 | 4.528 | 4.528 | 1.0 |
| 2011-04-15 | CT | Futures | 175.3 | 177.06 | 173.7 | 174.84 | 4714.0 |
| 2011-04-15 | DC | Futures | 30.21 | 30.52 | 30.03 | 30.07 | 162.0 |
| 2011-04-15 | DX | Futures | 74.506 | 74.845 | 74.452 | 74.654 | 19073.0 |
| 2011-04-15 | E1 | Futures | 1.4677 | 1.46927 | 1.46194 | 1.46652 | 25777.0 |
| 2011-04-15 | E6 | Futures | 1.71372 | 1.71562 | 1.70212 | 1.70757 | 255421.0 |
| 2011-04-15 | E7 | Futures | 1.7013 | 1.7029 | 1.6896 | 1.6949 | 4622.0 |
| 2011-04-15 | EBM | Futures | 222.87 | 224.51 | 219.81 | 223.81 | 5863.0 |
| 2011-04-15 | ED | Futures | 94.9311 | 94.9406 | 94.9264 | 94.9359 | 129188.0 |
| 2011-04-15 | ER | Futures | 97.242 | 97.252 | 97.227 | 97.242 | 79133.0 |
| 2011-04-15 | EW | Futures | 967.1 | 977.0 | 962.7 | 976.5 | 18534.0 |
| 2011-04-15 | FBTP | Futures | 64.45 | 64.51 | 64.22 | 64.45 | 6190.0 |
| 2011-04-15 | FCE | Futures | 2658.5 | 2666.4 | 2642.5 | 2659.6 | 120186.0 |
| 2011-04-15 | FDAX | Futures | 7658.5 | 7701.2 | 7646.2 | 7679.8 | 128499.0 |
| 2011-04-15 | FESX | Futures | 1823.5 | 1828.6 | 1811.3 | 1822.2 | 1190472.0 |
| 2011-04-15 | FEU3 | Futures | 97.79 | 97.79 | 97.785 | 97.785 | 50.0 |
| 2011-04-15 | FGBL | Futures | 96.57 | 97.02 | 96.49 | 96.98 | 885361.0 |
| 2011-04-15 | FGBM | Futures | 102.34 | 102.57 | 102.28 | 102.52 | 472687.0 |
| 2011-04-15 | FGBS | Futures | 106.137 | 106.201 | 106.097 | 106.176 | 499726.0 |
| 2011-04-15 | FGBX | Futures | 91.52 | 92.55 | 91.52 | 92.51 | 2677.0 |
| 2011-04-15 | FTDX | Futures | 819.9 | 823.4 | 819.0 | 819.4 | 179.0 |
| 2011-04-15 | FTI | Futures | 293.09 | 293.5 | 291.03 | 292.34 | 34725.0 |
| 2011-04-15 | FTUK | Futures | 4161.3 | 4179.5 | 4144.8 | 4166.9 | 81454.0 |
| 2011-04-15 | FXXP | Futures | 182.7 | 183.4 | 182.4 | 183.1 | 1122.0 |
| 2011-04-15 | G | Futures | 81.32 | 81.84 | 81.22 | 81.81 | 107665.0 |
| 2011-04-15 | GF | Futures | 321.888 | 322.61 | 319.962 | 320.805 | 1106.0 |
| 2011-04-15 | GSCI | Futures | 1150.64 | 1163.29 | 1145.02 | 1159.08 | 351.0 |
| 2011-04-15 | HE | Futures | 109.709 | 109.709 | 107.982 | 108.832 | 804.0 |
| 2011-04-15 | HG | Futures | 5.7342 | 5.7475 | 5.6376 | 5.6709 | 36242.0 |
| 2011-04-15 | HO | Futures | 2.6757 | 2.7042 | 2.659 | 2.6895 | 25076.0 |
| 2011-04-15 | HRC | Futures | 3000.1 | 3000.1 | 3000.1 | 3000.1 | 0.0 |
| 2011-04-15 | J1 | Futures | 0.0150468 | 0.0151486 | 0.0149965 | 0.0151172 | 93530.0 |
| 2011-04-15 | J7 | Futures | 0.014956 | 0.015053 | 0.014908 | 0.015025 | 445.0 |
| 2011-04-15 | JB | Futures | 121.13 | 121.13 | 121.07 | 121.11 | 7.0 |
> showing 50 of 94 rows — these rows as CSV