PREVIEW / futures_daily / 2012-02-22
file: by_date/futures_daily/2012/2012-02-22.parquet size: 9 KB rows: 98
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-22 | ES | Futures | 1364.6 | 1368.86 | 1357.83 | 1360.84 | 1439240.0 |
| 2012-02-22 | NQ | Futures | 2962.2 | 2973.92 | 2945.05 | 2949.05 | 186677.0 |
| 2012-02-22 | YM | Futures | 12514.9 | 12549.7 | 12466.6 | 12490.7 | 95441.0 |
| 2012-02-22 | CL | Futures | 196.39 | 197.71 | 195.65 | 196.89 | 241329.0 |
| 2012-02-22 | GC | Futures | 2358.7 | 2388.2 | 2344.4 | 2372.0 | 176268.0 |
| 2012-02-22 | ZN | Futures | 112.814185 | 113.286776 | 112.665657 | 113.246268 | 1027852.0 |
| 2012-02-22 | A6 | Futures | 0.94511 | 0.94822 | 0.94092 | 0.94448 | 121424.0 |
| 2012-02-22 | AD | Futures | 1.00563 | 1.00774 | 1.00111 | 1.00372 | 99402.0 |
| 2012-02-22 | B | Futures | 108.21 | 109.75 | 107.77 | 109.46 | 171816.0 |
| 2012-02-22 | B6 | Futures | 1.6497 | 1.653 | 1.6355 | 1.638 | 135343.0 |
| 2012-02-22 | BFX | Futures | 2785.1 | 2785.1 | 2762.7 | 2762.7 | 2.0 |
| 2012-02-22 | BR | Futures | 0.27271 | 0.27386 | 0.27259 | 0.27379 | 872.0 |
| 2012-02-22 | BZ | Futures | 115.04 | 116.93 | 114.95 | 116.65 | 1019.0 |
| 2012-02-22 | C | Futures | 1580.0 | 1605.0 | 1571.0 | 1602.0 | 1778.0 |
| 2012-02-22 | CB | Futures | 85.067 | 85.067 | 85.04 | 85.04 | 22.0 |
| 2012-02-22 | CC | Futures | 1850.0 | 1867.0 | 1826.0 | 1855.0 | 8163.0 |
| 2012-02-22 | CSC | Futures | 3.708 | 3.708 | 3.708 | 3.708 | 3.0 |
| 2012-02-22 | CT | Futures | 117.46 | 118.04 | 113.98 | 114.07 | 5356.0 |
| 2012-02-22 | DC | Futures | 25.86 | 25.93 | 25.76 | 25.79 | 169.0 |
| 2012-02-22 | DX | Futures | 77.087 | 77.345 | 76.97 | 77.187 | 22019.0 |
| 2012-02-22 | E1 | Futures | 1.43877 | 1.44324 | 1.4368 | 1.44179 | 32780.0 |
| 2012-02-22 | E6 | Futures | 1.58138 | 1.58593 | 1.57923 | 1.58318 | 238054.0 |
| 2012-02-22 | E7 | Futures | 1.5666 | 1.5713 | 1.5649 | 1.5687 | 3628.0 |
| 2012-02-22 | EBM | Futures | 277.8 | 279.43 | 277.47 | 277.8 | 3426.0 |
| 2012-02-22 | ED | Futures | 95.0844 | 95.0868 | 95.0725 | 95.0796 | 89503.0 |
| 2012-02-22 | ER | Futures | 97.444 | 97.444 | 97.43 | 97.435 | 66995.0 |
| 2012-02-22 | EW | Futures | 987.2 | 991.0 | 979.7 | 981.9 | 24097.0 |
| 2012-02-22 | FBTP | Futures | 65.54 | 65.71 | 65.12 | 65.38 | 18392.0 |
| 2012-02-22 | FBTS | Futures | 84.729 | 84.746 | 84.497 | 84.673 | 1499.0 |
| 2012-02-22 | FCE | Futures | 2445.2 | 2456.9 | 2430.4 | 2435.3 | 76211.0 |
| 2012-02-22 | FDAX | Futures | 7625.8 | 7644.6 | 7532.5 | 7564.0 | 138331.0 |
| 2012-02-22 | FESX | Futures | 1698.1 | 1702.8 | 1679.4 | 1685.4 | 921880.0 |
| 2012-02-22 | FGBL | Futures | 111.56 | 112.5 | 111.45 | 112.11 | 713171.0 |
| 2012-02-22 | FGBM | Futures | 112.92 | 113.35 | 112.83 | 113.17 | 346954.0 |
| 2012-02-22 | FGBS | Futures | 109.76 | 109.815 | 109.745 | 109.79 | 381782.0 |
| 2012-02-22 | FGBX | Futures | 115.75 | 117.23 | 115.49 | 116.59 | 4796.0 |
| 2012-02-22 | FTDX | Futures | 726.9 | 727.3 | 718.5 | 721.3 | 113.0 |
| 2012-02-22 | FTI | Futures | 277.82 | 278.54 | 274.12 | 274.63 | 28988.0 |
| 2012-02-22 | FTUK | Futures | 4254.1 | 4267.8 | 4235.3 | 4255.9 | 83648.0 |
| 2012-02-22 | FVSA | Futures | 10281.04 | 10395.06 | 10148.01 | 10186.02 | 3956.0 |
| 2012-02-22 | FXXP | Futures | 188.5 | 188.6 | 186.6 | 186.9 | 2435.0 |
| 2012-02-22 | G | Futures | 93.16 | 94.16 | 93.08 | 93.85 | 189982.0 |
| 2012-02-22 | GF | Futures | 336.239 | 336.663 | 335.391 | 335.974 | 1947.0 |
| 2012-02-22 | GSCI | Futures | 1100.85 | 1110.69 | 1098.49 | 1110.69 | 360.0 |
| 2012-02-22 | HE | Futures | 108.552 | 109.942 | 108.401 | 109.157 | 16655.0 |
| 2012-02-22 | HG | Futures | 5.0403 | 5.0593 | 4.9859 | 5.0377 | 16380.0 |
| 2012-02-22 | HO | Futures | 2.6389 | 2.6721 | 2.6282 | 2.6649 | 30227.0 |
| 2012-02-22 | HRC | Futures | 2731.0 | 2731.0 | 2731.0 | 2731.0 | 63.0 |
| 2012-02-22 | J1 | Futures | 0.0157509 | 0.0157521 | 0.015619 | 0.0156554 | 95457.0 |
| 2012-02-22 | J7 | Futures | 0.015671 | 0.015671 | 0.015553 | 0.015591 | 560.0 |
> showing 50 of 98 rows — these rows as CSV