PREVIEW / futures_daily / 2011-04-20
file: by_date/futures_daily/2011/2011-04-20.parquet size: 9 KB rows: 93
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-20 | ES | Futures | 1295.68 | 1317.21 | 1295.43 | 1314.98 | 1871971.0 |
| 2011-04-20 | NQ | Futures | 2635.1 | 2692.04 | 2634.24 | 2682.08 | 307353.0 |
| 2011-04-20 | YM | Futures | 11473.9 | 11689.2 | 11473.9 | 11654.4 | 109648.0 |
| 2011-04-20 | CL | Futures | 208.99 | 215.18 | 208.05 | 214.77 | 291546.0 |
| 2011-04-20 | GC | Futures | 2025.0 | 2039.1 | 2021.9 | 2028.8 | 147867.0 |
| 2011-04-20 | ZN | Futures | 101.276783 | 101.289951 | 100.960746 | 101.052923 | 842609.0 |
| 2011-04-20 | A6 | Futures | 0.89687 | 0.91334 | 0.89644 | 0.90939 | 94027.0 |
| 2011-04-20 | AD | Futures | 1.04004 | 1.0472 | 1.03984 | 1.04193 | 72898.0 |
| 2011-04-20 | B | Futures | 102.82 | 105.38 | 102.72 | 105.06 | 159345.0 |
| 2011-04-20 | B6 | Futures | 1.6943 | 1.7056 | 1.6929 | 1.7034 | 121211.0 |
| 2011-04-20 | BFX | Futures | 3134.6 | 3188.9 | 3134.6 | 3188.9 | 42.0 |
| 2011-04-20 | BR | Futures | 0.27999 | 0.27999 | 0.27823 | 0.27916 | 566.0 |
| 2011-04-20 | BZ | Futures | 109.85 | 111.04 | 109.15 | 110.76 | 1099.0 |
| 2011-04-20 | C | Futures | 2130.0 | 2138.0 | 2109.0 | 2112.0 | 1359.0 |
| 2011-04-20 | CB | Futures | 118.802 | 119.081 | 117.922 | 119.081 | 14.0 |
| 2011-04-20 | CC | Futures | 2457.0 | 2492.0 | 2432.0 | 2473.0 | 5766.0 |
| 2011-04-20 | CT | Futures | 170.17 | 173.25 | 163.66 | 163.79 | 6957.0 |
| 2011-04-20 | DC | Futures | 29.38 | 29.78 | 29.21 | 29.6 | 217.0 |
| 2011-04-20 | DX | Futures | 74.815 | 74.835 | 74.083 | 74.195 | 28103.0 |
| 2011-04-20 | E1 | Futures | 1.45605 | 1.47595 | 1.45539 | 1.47346 | 44314.0 |
| 2011-04-20 | E6 | Futures | 1.69548 | 1.72131 | 1.69513 | 1.71716 | 310725.0 |
| 2011-04-20 | E7 | Futures | 1.6829 | 1.7086 | 1.6826 | 1.7044 | 5995.0 |
| 2011-04-20 | EBM | Futures | 238.6 | 240.48 | 237.19 | 238.37 | 6994.0 |
| 2011-04-20 | ED | Futures | 94.9216 | 94.9311 | 94.9168 | 94.9264 | 117289.0 |
| 2011-04-20 | ER | Futures | 97.237 | 97.247 | 97.212 | 97.232 | 158027.0 |
| 2011-04-20 | EW | Futures | 964.6 | 983.3 | 964.6 | 982.1 | 20011.0 |
| 2011-04-20 | FBTP | Futures | 64.41 | 64.58 | 64.28 | 64.45 | 5770.0 |
| 2011-04-20 | FCE | Futures | 2642.2 | 2684.4 | 2639.8 | 2677.3 | 130722.0 |
| 2011-04-20 | FDAX | Futures | 7620.0 | 7775.4 | 7611.5 | 7749.8 | 150414.0 |
| 2011-04-20 | FESX | Futures | 1803.0 | 1830.5 | 1801.0 | 1822.8 | 1408448.0 |
| 2011-04-20 | FEU3 | Futures | 97.765 | 97.775 | 97.765 | 97.775 | 334.0 |
| 2011-04-20 | FGBL | Futures | 97.62 | 97.68 | 97.36 | 97.57 | 867764.0 |
| 2011-04-20 | FGBM | Futures | 102.86 | 102.87 | 102.62 | 102.74 | 577995.0 |
| 2011-04-20 | FGBS | Futures | 106.28 | 106.28 | 106.181 | 106.241 | 560518.0 |
| 2011-04-20 | FGBX | Futures | 93.59 | 93.61 | 92.95 | 93.3 | 2805.0 |
| 2011-04-20 | FTDX | Futures | 813.6 | 821.2 | 808.3 | 817.6 | 542.0 |
| 2011-04-20 | FTI | Futures | 290.29 | 293.33 | 289.96 | 292.84 | 32671.0 |
| 2011-04-20 | FTUK | Futures | 4127.0 | 4199.8 | 4125.9 | 4187.5 | 98813.0 |
| 2011-04-20 | FXXP | Futures | 182.8 | 184.3 | 182.7 | 183.9 | 1665.0 |
| 2011-04-20 | G | Futures | 81.97 | 82.11 | 81.88 | 82.01 | 94133.0 |
| 2011-04-20 | GF | Futures | 324.294 | 326.099 | 320.083 | 323.211 | 1931.0 |
| 2011-04-20 | GSCI | Futures | 1162.43 | 1174.07 | 1160.72 | 1168.45 | 409.0 |
| 2011-04-20 | HE | Futures | 109.496 | 109.895 | 108.248 | 109.337 | 548.0 |
| 2011-04-20 | HG | Futures | 5.6417 | 5.8025 | 5.6417 | 5.7912 | 15987.0 |
| 2011-04-20 | HO | Futures | 2.6321 | 2.6988 | 2.6289 | 2.6888 | 44946.0 |
| 2011-04-20 | HRC | Futures | 3000.1 | 3000.1 | 3000.1 | 3000.1 | 0.0 |
| 2011-04-20 | J1 | Futures | 0.0152189 | 0.0152767 | 0.0151197 | 0.0152503 | 117391.0 |
| 2011-04-20 | J7 | Futures | 0.015121 | 0.015182 | 0.01503 | 0.015157 | 1041.0 |
| 2011-04-20 | JB | Futures | 121.41 | 121.5 | 121.35 | 121.46 | 19.0 |
| 2011-04-20 | KC | Futures | 705.61 | 725.39 | 705.61 | 718.08 | 13476.0 |
> showing 50 of 93 rows — these rows as CSV