PREVIEW / futures_daily / 2013-04-24
file: by_date/futures_daily/2013/2013-04-24.parquet size: 9 KB rows: 105
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-04-24 | ES | Futures | 1615.45 | 1621.1 | 1612.63 | 1615.96 | 1421896.0 |
| 2013-04-24 | NQ | Futures | 3268.33 | 3278.43 | 3252.73 | 3261.97 | 257076.0 |
| 2013-04-24 | YM | Futures | 14423.0 | 14468.3 | 14384.6 | 14391.5 | 128020.0 |
| 2013-04-24 | CL | Futures | 156.27 | 159.97 | 155.59 | 159.46 | 257736.0 |
| 2013-04-24 | GC | Futures | 1875.1 | 1903.1 | 1873.8 | 1890.0 | 142300.0 |
| 2013-04-24 | ZN | Futures | 118.463794 | 118.616848 | 118.324654 | 118.533364 | 1010240.0 |
| 2013-04-24 | A6 | Futures | 0.94408 | 0.94694 | 0.94085 | 0.94574 | 93496.0 |
| 2013-04-24 | AD | Futures | 0.97813 | 0.97934 | 0.97623 | 0.97854 | 52924.0 |
| 2013-04-24 | B | Futures | 96.62 | 98.21 | 96.51 | 97.96 | 204010.0 |
| 2013-04-24 | B6 | Futures | 1.5941 | 1.5992 | 1.5928 | 1.5971 | 68502.0 |
| 2013-04-24 | BFX | Futures | 3107.3 | 3128.0 | 3107.3 | 3123.7 | 8.0 |
| 2013-04-24 | BR | Futures | 0.24364 | 0.24525 | 0.24364 | 0.2447 | 486.0 |
| 2013-04-24 | BZ | Futures | 98.1 | 99.41 | 97.72 | 99.17 | 4467.0 |
| 2013-04-24 | C | Futures | 1651.0 | 1654.0 | 1631.0 | 1642.0 | 4502.0 |
| 2013-04-24 | CB | Futures | 85.863 | 86.775 | 85.863 | 86.282 | 5.0 |
| 2013-04-24 | CC | Futures | 1737.0 | 1756.0 | 1731.0 | 1744.0 | 10010.0 |
| 2013-04-24 | CNH | Futures | 7.2087 | 7.2108 | 7.2073 | 7.208 | 45.0 |
| 2013-04-24 | CSC | Futures | 3.778 | 3.78 | 3.738 | 3.738 | 17.0 |
| 2013-04-24 | CT | Futures | 101.71 | 102.12 | 99.28 | 99.41 | 26918.0 |
| 2013-04-24 | DC | Futures | 29.06 | 29.18 | 28.81 | 28.86 | 301.0 |
| 2013-04-24 | DX | Futures | 79.971 | 80.082 | 79.736 | 79.795 | 24945.0 |
| 2013-04-24 | E1 | Futures | 1.36102 | 1.36282 | 1.35484 | 1.3596 | 43688.0 |
| 2013-04-24 | E6 | Futures | 1.53346 | 1.53724 | 1.5278 | 1.53582 | 241850.0 |
| 2013-04-24 | E7 | Futures | 1.5235 | 1.5272 | 1.5178 | 1.5258 | 3116.0 |
| 2013-04-24 | EBM | Futures | 280.01 | 280.31 | 278.56 | 279.43 | 8984.0 |
| 2013-04-24 | ED | Futures | 95.2587 | 95.2683 | 95.2587 | 95.2635 | 107618.0 |
| 2013-04-24 | ER | Futures | 97.842 | 97.852 | 97.832 | 97.847 | 73437.0 |
| 2013-04-24 | EW | Futures | 1156.7 | 1162.8 | 1155.2 | 1160.5 | 18176.0 |
| 2013-04-24 | FBTP | Futures | 79.24 | 79.69 | 78.93 | 79.1 | 41511.0 |
| 2013-04-24 | FBTS | Futures | 92.766 | 92.843 | 92.604 | 92.655 | 6662.0 |
| 2013-04-24 | FCE | Futures | 2873.2 | 2917.1 | 2865.1 | 2912.1 | 156016.0 |
| 2013-04-24 | FDAX | Futures | 8536.2 | 8654.6 | 8516.2 | 8632.4 | 140299.0 |
| 2013-04-24 | FDIV | Futures | 115.12 | 115.87 | 115.12 | 115.87 | 35.0 |
| 2013-04-24 | FESX | Futures | 1828.8 | 1856.0 | 1822.5 | 1851.1 | 1325987.0 |
| 2013-04-24 | FEU3 | Futures | 98.448 | 98.448 | 98.443 | 98.448 | 410.0 |
| 2013-04-24 | FGBL | Futures | 122.3 | 122.61 | 122.05 | 122.53 | 903623.0 |
| 2013-04-24 | FGBM | Futures | 118.19 | 118.36 | 118.05 | 118.3 | 518659.0 |
| 2013-04-24 | FGBS | Futures | 110.492 | 110.522 | 110.477 | 110.512 | 277726.0 |
| 2013-04-24 | FGBX | Futures | 129.4 | 130.31 | 129.25 | 130.14 | 18461.0 |
| 2013-04-24 | FMWO | Futures | 4729.1 | 4729.1 | 4729.1 | 4729.1 | 0.0 |
| 2013-04-24 | FOAT | Futures | 109.45 | 109.81 | 109.17 | 109.5 | 40902.0 |
| 2013-04-24 | FTDX | Futures | 870.1 | 872.9 | 866.8 | 871.0 | 37.0 |
| 2013-04-24 | FTI | Futures | 300.08 | 303.21 | 298.82 | 302.87 | 37231.0 |
| 2013-04-24 | FTUK | Futures | 4726.4 | 4752.8 | 4717.5 | 4749.1 | 86059.0 |
| 2013-04-24 | FVSA | Futures | 3137.03 | 3160.8 | 3065.74 | 3129.11 | 6499.0 |
| 2013-04-24 | FXXP | Futures | 212.7 | 214.5 | 212.5 | 214.1 | 7663.0 |
| 2013-04-24 | G | Futures | 100.26 | 100.6 | 100.05 | 100.51 | 151049.0 |
| 2013-04-24 | GF | Futures | 253.152 | 257.184 | 253.152 | 255.689 | 2762.0 |
| 2013-04-24 | GSCI | Futures | 977.99 | 988.43 | 977.99 | 987.3 | 75.0 |
| 2013-04-24 | HE | Futures | 88.601 | 89.231 | 88.35 | 89.205 | 217.0 |
> showing 50 of 105 rows — these rows as CSV