PREVIEW / futures_daily / 2011-03-25
file: by_date/futures_daily/2011/2011-03-25.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-03-25 | ES | Futures | 1291.47 | 1301.37 | 1290.97 | 1296.91 | 1651563.0 |
| 2011-03-25 | NQ | Futures | 2625.7 | 2659.3 | 2623.99 | 2638.8 | 256984.0 |
| 2011-03-25 | YM | Futures | 11385.5 | 11466.4 | 11382.7 | 11441.9 | 94254.0 |
| 2011-03-25 | CL | Futures | 203.94 | 204.89 | 202.08 | 203.82 | 235658.0 |
| 2011-03-25 | GC | Futures | 1945.4 | 1951.7 | 1929.8 | 1935.5 | 182739.0 |
| 2011-03-25 | ZN | Futures | 100.671045 | 100.908073 | 100.328671 | 100.447185 | 1102318.0 |
| 2011-03-25 | A6 | Futures | 0.86703 | 0.87432 | 0.86531 | 0.87097 | 91393.0 |
| 2011-03-25 | AD | Futures | 1.01803 | 1.02022 | 1.01146 | 1.01305 | 68370.0 |
| 2011-03-25 | B | Futures | 98.15 | 98.4 | 97.61 | 97.9 | 58046.0 |
| 2011-03-25 | B6 | Futures | 1.6736 | 1.6754 | 1.6612 | 1.6621 | 108863.0 |
| 2011-03-25 | BFX | Futures | 3061.0 | 3095.5 | 3057.2 | 3072.6 | 121.0 |
| 2011-03-25 | BR | Futures | 0.26224 | 0.26224 | 0.26224 | 0.26224 | 1184.0 |
| 2011-03-25 | BZ | Futures | 103.39 | 103.65 | 102.99 | 103.22 | 725.0 |
| 2011-03-25 | C | Futures | 2296.0 | 2359.0 | 2285.0 | 2331.0 | 4118.0 |
| 2011-03-25 | CB | Futures | 117.922 | 117.922 | 117.922 | 117.922 | 5.0 |
| 2011-03-25 | CC | Futures | 2590.0 | 2644.0 | 2571.0 | 2606.0 | 7712.0 |
| 2011-03-25 | CSC | Futures | 4.433 | 4.433 | 4.433 | 4.433 | 1.0 |
| 2011-03-25 | CT | Futures | 187.5 | 188.82 | 181.2 | 182.86 | 8939.0 |
| 2011-03-25 | DC | Futures | 28.98 | 29.93 | 28.83 | 29.6 | 280.0 |
| 2011-03-25 | DX | Futures | 75.561 | 76.178 | 75.461 | 76.103 | 28286.0 |
| 2011-03-25 | E1 | Futures | 1.44269 | 1.44361 | 1.42148 | 1.42488 | 43132.0 |
| 2011-03-25 | E6 | Futures | 1.67677 | 1.67914 | 1.66255 | 1.66433 | 236849.0 |
| 2011-03-25 | E7 | Futures | 1.6641 | 1.6666 | 1.6502 | 1.6519 | 5119.0 |
| 2011-03-25 | EBM | Futures | 217.94 | 227.09 | 217.94 | 222.4 | 15475.0 |
| 2011-03-25 | ED | Futures | 94.8502 | 94.855 | 94.8359 | 94.8502 | 187154.0 |
| 2011-03-25 | ER | Futures | 97.272 | 97.272 | 97.252 | 97.262 | 52440.0 |
| 2011-03-25 | EW | Futures | 954.4 | 970.3 | 954.0 | 962.3 | 22599.0 |
| 2011-03-25 | FBTP | Futures | 64.23 | 64.29 | 64.0 | 64.21 | 5333.0 |
| 2011-03-25 | FCE | Futures | 2655.2 | 2657.9 | 2636.3 | 2645.2 | 89201.0 |
| 2011-03-25 | FDAX | Futures | 7470.6 | 7481.2 | 7410.8 | 7455.1 | 114463.0 |
| 2011-03-25 | FESX | Futures | 1824.1 | 1826.7 | 1810.0 | 1818.3 | 807704.0 |
| 2011-03-25 | FEU3 | Futures | 97.795 | 97.81 | 97.795 | 97.805 | 347.0 |
| 2011-03-25 | FGBL | Futures | 97.59 | 97.76 | 97.4 | 97.64 | 681796.0 |
| 2011-03-25 | FGBM | Futures | 103.04 | 103.13 | 102.89 | 103.03 | 371324.0 |
| 2011-03-25 | FGBS | Futures | 106.394 | 106.424 | 106.34 | 106.375 | 398543.0 |
| 2011-03-25 | FGBX | Futures | 93.92 | 94.1 | 93.48 | 93.83 | 3698.0 |
| 2011-03-25 | FTDX | Futures | 809.6 | 816.3 | 804.2 | 809.6 | 355.0 |
| 2011-03-25 | FTI | Futures | 295.99 | 301.29 | 294.85 | 295.79 | 32426.0 |
| 2011-03-25 | FTUK | Futures | 4103.5 | 4122.4 | 4082.2 | 4105.3 | 83790.0 |
| 2011-03-25 | FXXP | Futures | 181.8 | 182.3 | 181.3 | 181.8 | 1206.0 |
| 2011-03-25 | G | Futures | 81.79 | 81.96 | 81.64 | 81.81 | 85928.0 |
| 2011-03-25 | GF | Futures | 320.838 | 328.219 | 320.475 | 326.343 | 1206.0 |
| 2011-03-25 | GSCI | Futures | 1129.97 | 1129.97 | 1121.28 | 1124.88 | 291.0 |
| 2011-03-25 | HE | Futures | 105.83 | 108.088 | 105.83 | 108.088 | 990.0 |
| 2011-03-25 | HG | Futures | 5.8921 | 5.932 | 5.8594 | 5.8861 | 25983.0 |
| 2011-03-25 | HO | Futures | 2.5798 | 2.5804 | 2.5584 | 2.5636 | 17622.0 |
| 2011-03-25 | HRC | Futures | 3106.0 | 3106.0 | 3106.0 | 3106.0 | 0.0 |
| 2011-03-25 | J1 | Futures | 0.0155154 | 0.0155456 | 0.0154224 | 0.0154388 | 87929.0 |
| 2011-03-25 | J7 | Futures | 0.01542 | 0.015448 | 0.01533 | 0.015344 | 447.0 |
| 2011-03-25 | JB | Futures | 121.73 | 121.73 | 121.73 | 121.73 | 1294.0 |
> showing 50 of 94 rows — these rows as CSV