PREVIEW / futures_daily / 2012-10-05
file: by_date/futures_daily/2012/2012-10-05.parquet size: 9 KB rows: 100
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-10-05 | ES | Futures | 1481.64 | 1492.07 | 1477.06 | 1481.38 | 1681666.0 |
| 2012-10-05 | NQ | Futures | 3247.03 | 3268.6 | 3221.42 | 3226.6 | 209852.0 |
| 2012-10-05 | YM | Futures | 13180.7 | 13279.3 | 13171.9 | 13217.8 | 110153.0 |
| 2012-10-05 | CL | Futures | 165.16 | 165.52 | 160.65 | 162.22 | 279131.0 |
| 2012-10-05 | GC | Futures | 2393.4 | 2400.7 | 2369.2 | 2377.6 | 158446.0 |
| 2012-10-05 | ZN | Futures | 117.23331 | 117.329447 | 116.780088 | 116.835024 | 1001753.0 |
| 2012-10-05 | A6 | Futures | 0.92562 | 0.92808 | 0.91708 | 0.91854 | 130089.0 |
| 2012-10-05 | AD | Futures | 1.02185 | 1.02938 | 1.02115 | 1.02356 | 88412.0 |
| 2012-10-05 | B | Futures | 102.42 | 102.72 | 100.48 | 101.89 | 223998.0 |
| 2012-10-05 | B6 | Futures | 1.6909 | 1.6933 | 1.6835 | 1.6855 | 103927.0 |
| 2012-10-05 | BFX | Futures | 2916.1 | 2916.4 | 2913.7 | 2916.4 | 4.0 |
| 2012-10-05 | BR | Futures | 0.23876 | 0.23876 | 0.23757 | 0.23757 | 41.0 |
| 2012-10-05 | BZ | Futures | 105.81 | 105.81 | 104.7 | 105.73 | 1987.0 |
| 2012-10-05 | C | Futures | 1545.0 | 1564.0 | 1544.0 | 1546.0 | 926.0 |
| 2012-10-05 | CB | Futures | 94.201 | 94.736 | 94.201 | 94.736 | 2.0 |
| 2012-10-05 | CC | Futures | 1815.0 | 1825.0 | 1791.0 | 1796.0 | 6638.0 |
| 2012-10-05 | CSC | Futures | 4.183 | 4.183 | 4.135 | 4.145 | 17.0 |
| 2012-10-05 | CT | Futures | 92.87 | 92.91 | 91.75 | 92.25 | 8572.0 |
| 2012-10-05 | DC | Futures | 31.23 | 31.4 | 30.89 | 31.02 | 170.0 |
| 2012-10-05 | DX | Futures | 76.985 | 77.029 | 76.695 | 76.935 | 17726.0 |
| 2012-10-05 | E1 | Futures | 1.38509 | 1.38921 | 1.38213 | 1.38638 | 29046.0 |
| 2012-10-05 | E6 | Futures | 1.5338 | 1.54028 | 1.53109 | 1.5358 | 247356.0 |
| 2012-10-05 | E7 | Futures | 1.5246 | 1.5312 | 1.522 | 1.5266 | 3568.0 |
| 2012-10-05 | ED | Futures | 95.2253 | 95.2301 | 95.2157 | 95.2205 | 82917.0 |
| 2012-10-05 | ER | Futures | 97.871 | 97.881 | 97.862 | 97.866 | 58538.0 |
| 2012-10-05 | EW | Futures | 1013.6 | 1022.4 | 1011.0 | 1012.2 | 20571.0 |
| 2012-10-05 | FBTP | Futures | 71.13 | 71.71 | 71.13 | 71.59 | 14107.0 |
| 2012-10-05 | FBTS | Futures | 89.407 | 89.625 | 89.391 | 89.6 | 2527.0 |
| 2012-10-05 | FCE | Futures | 2558.4 | 2589.8 | 2550.9 | 2584.5 | 82298.0 |
| 2012-10-05 | FDAX | Futures | 8039.2 | 8120.8 | 8014.0 | 8098.9 | 112202.0 |
| 2012-10-05 | FESX | Futures | 1696.7 | 1721.9 | 1692.6 | 1718.5 | 910758.0 |
| 2012-10-05 | FEU3 | Futures | 98.502 | 98.502 | 98.487 | 98.487 | 55.0 |
| 2012-10-05 | FGBL | Futures | 118.11 | 118.29 | 117.6 | 117.73 | 627228.0 |
| 2012-10-05 | FGBM | Futures | 116.16 | 116.27 | 115.94 | 116.03 | 310943.0 |
| 2012-10-05 | FGBS | Futures | 110.323 | 110.353 | 110.288 | 110.303 | 231801.0 |
| 2012-10-05 | FGBX | Futures | 124.89 | 125.07 | 123.54 | 123.82 | 4269.0 |
| 2012-10-05 | FOAT | Futures | 102.95 | 103.18 | 102.9 | 103.08 | 27379.0 |
| 2012-10-05 | FTDX | Futures | 775.4 | 782.5 | 774.0 | 780.1 | 70.0 |
| 2012-10-05 | FTI | Futures | 280.59 | 284.08 | 280.03 | 283.66 | 29367.0 |
| 2012-10-05 | FTUK | Futures | 4253.8 | 4287.0 | 4244.2 | 4272.0 | 71059.0 |
| 2012-10-05 | FVSA | Futures | 5523.5 | 5523.5 | 5169.12 | 5303.54 | 4845.0 |
| 2012-10-05 | FXXP | Futures | 196.4 | 197.6 | 195.7 | 197.1 | 1756.0 |
| 2012-10-05 | G | Futures | 99.49 | 99.55 | 98.94 | 99.05 | 125213.0 |
| 2012-10-05 | GF | Futures | 281.31 | 282.624 | 281.067 | 281.943 | 925.0 |
| 2012-10-05 | GSCI | Futures | 1069.45 | 1072.68 | 1057.6 | 1063.24 | 1578.0 |
| 2012-10-05 | HE | Futures | 95.088 | 95.461 | 94.218 | 95.151 | 18741.0 |
| 2012-10-05 | HG | Futures | 4.8698 | 4.8962 | 4.8191 | 4.8551 | 43899.0 |
| 2012-10-05 | HH | Futures | 43.303 | 43.303 | 43.303 | 43.303 | 1350.0 |
| 2012-10-05 | HO | Futures | 2.5577 | 2.5634 | 2.5173 | 2.5417 | 42859.0 |
| 2012-10-05 | HRC | Futures | 2434.9 | 2434.9 | 2434.9 | 2434.9 | 17.0 |
> showing 50 of 100 rows — these rows as CSV