PREVIEW / futures_daily / 2012-05-04
file: by_date/futures_daily/2012/2012-05-04.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-05-04 | ES | Futures | 1397.2 | 1399.72 | 1372.01 | 1373.01 | 2076198.0 |
| 2012-05-04 | NQ | Futures | 3088.0 | 3094.02 | 3007.8 | 3008.09 | 320105.0 |
| 2012-05-04 | YM | Futures | 12782.4 | 12805.7 | 12595.7 | 12600.5 | 139189.0 |
| 2012-05-04 | CL | Futures | 188.19 | 188.43 | 178.87 | 180.67 | 443060.0 |
| 2012-05-04 | GC | Futures | 2187.5 | 2203.0 | 2174.7 | 2199.3 | 144960.0 |
| 2012-05-04 | ZN | Futures | 114.477163 | 114.978068 | 114.355321 | 114.923916 | 1299349.0 |
| 2012-05-04 | A6 | Futures | 0.91961 | 0.92069 | 0.91088 | 0.91223 | 160266.0 |
| 2012-05-04 | AD | Futures | 1.01668 | 1.01929 | 1.00883 | 1.00994 | 103796.0 |
| 2012-05-04 | B | Futures | 104.69 | 104.91 | 100.91 | 102.05 | 160034.0 |
| 2012-05-04 | B6 | Futures | 1.6978 | 1.7001 | 1.6937 | 1.6941 | 99435.0 |
| 2012-05-04 | BFX | Futures | 2666.0 | 2666.0 | 2632.9 | 2632.9 | 1.0 |
| 2012-05-04 | BR | Futures | 0.24803 | 0.24803 | 0.246 | 0.24691 | 103.0 |
| 2012-05-04 | BZ | Futures | 110.27 | 110.63 | 107.61 | 108.75 | 4265.0 |
| 2012-05-04 | C | Futures | 1512.0 | 1534.0 | 1505.0 | 1513.0 | 1063.0 |
| 2012-05-04 | CB | Futures | 71.517 | 71.585 | 70.508 | 70.508 | 5.0 |
| 2012-05-04 | CC | Futures | 1739.0 | 1765.0 | 1713.0 | 1726.0 | 7914.0 |
| 2012-05-04 | CSC | Futures | 3.361 | 3.403 | 3.357 | 3.357 | 32.0 |
| 2012-05-04 | CT | Futures | 109.28 | 109.56 | 107.54 | 107.64 | 9891.0 |
| 2012-05-04 | DC | Futures | 23.27 | 23.56 | 23.05 | 23.12 | 215.0 |
| 2012-05-04 | DX | Futures | 76.775 | 77.138 | 76.683 | 77.111 | 24757.0 |
| 2012-05-04 | E1 | Futures | 1.43416 | 1.43704 | 1.42617 | 1.42722 | 39567.0 |
| 2012-05-04 | E6 | Futures | 1.57026 | 1.5736 | 1.56167 | 1.5625 | 237586.0 |
| 2012-05-04 | E7 | Futures | 1.5552 | 1.5584 | 1.5468 | 1.5475 | 2747.0 |
| 2012-05-04 | EBM | Futures | 293.11 | 298.5 | 291.09 | 296.48 | 7054.0 |
| 2012-05-04 | ED | Futures | 95.0693 | 95.074 | 95.0645 | 95.0693 | 85154.0 |
| 2012-05-04 | ER | Futures | 97.577 | 97.592 | 97.572 | 97.582 | 66404.0 |
| 2012-05-04 | EW | Futures | 989.4 | 993.9 | 970.6 | 971.4 | 26228.0 |
| 2012-05-04 | FBTP | Futures | 66.44 | 67.08 | 66.36 | 66.64 | 13549.0 |
| 2012-05-04 | FBTS | Futures | 85.42 | 85.599 | 85.396 | 85.485 | 1335.0 |
| 2012-05-04 | FCE | Futures | 2285.8 | 2307.4 | 2251.8 | 2258.7 | 148356.0 |
| 2012-05-04 | FDAX | Futures | 7370.0 | 7397.1 | 7227.4 | 7257.2 | 160874.0 |
| 2012-05-04 | FESX | Futures | 1536.4 | 1559.2 | 1519.8 | 1525.3 | 1404905.0 |
| 2012-05-04 | FGBL | Futures | 116.21 | 116.54 | 116.0 | 116.48 | 545276.0 |
| 2012-05-04 | FGBM | Futures | 115.05 | 115.22 | 114.92 | 115.18 | 302258.0 |
| 2012-05-04 | FGBS | Futures | 110.218 | 110.228 | 110.178 | 110.203 | 271837.0 |
| 2012-05-04 | FGBX | Futures | 120.73 | 121.51 | 120.56 | 121.36 | 4582.0 |
| 2012-05-04 | FOAT | Futures | 95.64 | 96.41 | 95.64 | 96.08 | 14654.0 |
| 2012-05-04 | FTDX | Futures | 744.3 | 744.8 | 730.2 | 732.1 | 87.0 |
| 2012-05-04 | FTI | Futures | 263.16 | 264.72 | 258.65 | 259.08 | 43460.0 |
| 2012-05-04 | FTUK | Futures | 4165.9 | 4179.4 | 4087.8 | 4100.2 | 129747.0 |
| 2012-05-04 | FVSA | Futures | 9094.01 | 9507.38 | 9027.87 | 9490.84 | 3432.0 |
| 2012-05-04 | FXXP | Futures | 184.0 | 184.5 | 181.2 | 181.7 | 5766.0 |
| 2012-05-04 | G | Futures | 95.49 | 95.98 | 95.43 | 95.83 | 94294.0 |
| 2012-05-04 | GF | Futures | 317.447 | 318.072 | 316.197 | 317.759 | 1679.0 |
| 2012-05-04 | GSCI | Futures | 1052.35 | 1052.35 | 1030.6 | 1037.58 | 310.0 |
| 2012-05-04 | HE | Futures | 90.619 | 90.966 | 88.566 | 89.312 | 31678.0 |
| 2012-05-04 | HG | Futures | 4.8927 | 4.9176 | 4.8488 | 4.873 | 50067.0 |
| 2012-05-04 | HO | Futures | 2.5409 | 2.5434 | 2.4494 | 2.4734 | 81202.0 |
| 2012-05-04 | HRC | Futures | 2609.8 | 2609.8 | 2609.8 | 2609.8 | 0.0 |
| 2012-05-04 | J1 | Futures | 0.0156423 | 0.01572 | 0.0156009 | 0.015705 | 78990.0 |
> showing 50 of 98 rows — these rows as CSV