PREVIEW / futures_daily / 2013-10-24
file: by_date/futures_daily/2013/2013-10-24.parquet size: 9 KB rows: 103
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-10-24 | ES | Futures | 1790.2 | 1799.44 | 1787.37 | 1796.1 | 1252875.0 |
| 2013-10-24 | NQ | Futures | 3838.66 | 3881.73 | 3830.91 | 3871.68 | 191455.0 |
| 2013-10-24 | YM | Futures | 15284.1 | 15397.6 | 15270.2 | 15376.7 | 120030.0 |
| 2013-10-24 | CL | Futures | 172.77 | 173.82 | 170.72 | 172.79 | 248742.0 |
| 2013-10-24 | GC | Futures | 1762.3 | 1788.5 | 1759.2 | 1785.8 | 138229.0 |
| 2013-10-24 | ZN | Futures | 115.603305 | 115.801571 | 115.447525 | 115.475848 | 844838.0 |
| 2013-10-24 | A6 | Futures | 0.90511 | 0.9104 | 0.90096 | 0.90483 | 86385.0 |
| 2013-10-24 | AD | Futures | 0.97167 | 0.97349 | 0.96662 | 0.96803 | 56769.0 |
| 2013-10-24 | B | Futures | 107.3 | 107.91 | 106.55 | 106.64 | 242315.0 |
| 2013-10-24 | B6 | Futures | 1.6962 | 1.7023 | 1.6932 | 1.7003 | 79591.0 |
| 2013-10-24 | BFX | Futures | 3462.4 | 3463.5 | 3462.4 | 3463.5 | 17.0 |
| 2013-10-24 | BR | Futures | 0.23 | 0.23 | 0.22853 | 0.22891 | 56.0 |
| 2013-10-24 | BZ | Futures | 107.99 | 108.53 | 107.17 | 107.28 | 7917.0 |
| 2013-10-24 | C | Futures | 1834.0 | 1842.0 | 1821.0 | 1823.0 | 7884.0 |
| 2013-10-24 | CB | Futures | 70.018 | 70.018 | 69.898 | 70.018 | 20.0 |
| 2013-10-24 | CC | Futures | 2017.0 | 2026.0 | 1997.0 | 2002.0 | 11375.0 |
| 2013-10-24 | CSC | Futures | 3.373 | 3.431 | 3.373 | 3.416 | 14.0 |
| 2013-10-24 | CT | Futures | 94.8 | 94.85 | 92.39 | 92.92 | 21291.0 |
| 2013-10-24 | DC | Futures | 25.8 | 26.1 | 25.73 | 26.04 | 296.0 |
| 2013-10-24 | DX | Futures | 75.609 | 75.628 | 75.4 | 75.504 | 13682.0 |
| 2013-10-24 | E1 | Futures | 1.44122 | 1.4461 | 1.43994 | 1.44122 | 26836.0 |
| 2013-10-24 | E6 | Futures | 1.62596 | 1.63174 | 1.62454 | 1.62903 | 176744.0 |
| 2013-10-24 | E7 | Futures | 1.6154 | 1.6213 | 1.6141 | 1.6185 | 3230.0 |
| 2013-10-24 | ED | Futures | 95.3542 | 95.359 | 95.3542 | 95.359 | 57918.0 |
| 2013-10-24 | ER | Futures | 97.862 | 97.862 | 97.842 | 97.847 | 93273.0 |
| 2013-10-24 | EW | Futures | 1312.7 | 1319.6 | 1309.1 | 1314.6 | 16024.0 |
| 2013-10-24 | FBTP | Futures | 80.96 | 81.15 | 80.65 | 80.87 | 40735.0 |
| 2013-10-24 | FBTS | Futures | 94.699 | 94.811 | 94.638 | 94.716 | 8549.0 |
| 2013-10-24 | FCE | Futures | 3313.7 | 3321.0 | 3298.6 | 3311.3 | 68179.0 |
| 2013-10-24 | FDAX | Futures | 9944.3 | 9988.7 | 9933.8 | 9961.0 | 71631.0 |
| 2013-10-24 | FDIV | Futures | 139.48 | 139.58 | 139.48 | 139.58 | 5.0 |
| 2013-10-24 | FESX | Futures | 2121.0 | 2128.0 | 2114.0 | 2124.5 | 677004.0 |
| 2013-10-24 | FEU3 | Futures | 98.473 | 98.473 | 98.468 | 98.468 | 16.0 |
| 2013-10-24 | FGBL | Futures | 119.82 | 120.25 | 119.81 | 119.95 | 639564.0 |
| 2013-10-24 | FGBM | Futures | 117.92 | 118.06 | 117.85 | 117.9 | 426345.0 |
| 2013-10-24 | FGBS | Futures | 110.453 | 110.473 | 110.418 | 110.428 | 269971.0 |
| 2013-10-24 | FGBX | Futures | 120.6 | 121.28 | 120.47 | 120.76 | 22352.0 |
| 2013-10-24 | FMWO | Futures | 5277.5 | 5282.6 | 5276.2 | 5282.6 | 185.0 |
| 2013-10-24 | FOAT | Futures | 107.73 | 107.96 | 107.68 | 107.78 | 34535.0 |
| 2013-10-24 | FTDX | Futures | 1056.8 | 1059.6 | 1053.9 | 1054.9 | 81.0 |
| 2013-10-24 | FTI | Futures | 335.69 | 336.29 | 335.04 | 336.03 | 18323.0 |
| 2013-10-24 | FTUK | Futures | 4998.1 | 5030.3 | 4993.2 | 5017.9 | 75518.0 |
| 2013-10-24 | FVSA | Futures | 2148.37 | 2154.46 | 2105.77 | 2111.86 | 6790.0 |
| 2013-10-24 | FXXP | Futures | 233.7 | 233.7 | 232.7 | 233.6 | 15203.0 |
| 2013-10-24 | G | Futures | 93.35 | 93.43 | 93.07 | 93.14 | 137477.0 |
| 2013-10-24 | GF | Futures | 270.511 | 270.713 | 269.1 | 269.302 | 1452.0 |
| 2013-10-24 | GSCI | Futures | 1038.95 | 1039.2 | 1033.95 | 1038.53 | 93.0 |
| 2013-10-24 | HE | Futures | 111.446 | 113.724 | 111.319 | 113.408 | 21580.0 |
| 2013-10-24 | HG | Futures | 4.1367 | 4.1544 | 4.1095 | 4.1322 | 50498.0 |
| 2013-10-24 | HH | Futures | 38.143 | 38.858 | 38.089 | 38.741 | 6222.0 |
> showing 50 of 103 rows — these rows as CSV