PREVIEW / futures_daily / 2012-03-01
file: by_date/futures_daily/2012/2012-03-01.parquet size: 9 KB rows: 99
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-03-01 | ES | Futures | 1367.11 | 1380.15 | 1363.6 | 1379.4 | 1966089.0 |
| 2012-03-01 | NQ | Futures | 3000.51 | 3026.24 | 2992.22 | 3022.81 | 257365.0 |
| 2012-03-01 | YM | Futures | 12499.4 | 12596.2 | 12465.6 | 12545.9 | 127381.0 |
| 2012-03-01 | CL | Futures | 197.89 | 204.8 | 197.39 | 201.63 | 389838.0 |
| 2012-03-01 | GC | Futures | 2270.6 | 2313.1 | 2270.0 | 2306.2 | 239499.0 |
| 2012-03-01 | ZN | Futures | 113.489315 | 113.489315 | 112.922206 | 113.111242 | 187499.0 |
| 2012-03-01 | A6 | Futures | 0.95303 | 0.9605 | 0.95267 | 0.95872 | 117656.0 |
| 2012-03-01 | AD | Futures | 1.01396 | 1.01948 | 1.01336 | 1.01798 | 97601.0 |
| 2012-03-01 | B | Futures | 109.33 | 114.16 | 109.1 | 112.27 | 154923.0 |
| 2012-03-01 | B6 | Futures | 1.6636 | 1.67 | 1.6616 | 1.6674 | 82540.0 |
| 2012-03-01 | BFX | Futures | 2779.0 | 2801.0 | 2779.0 | 2797.2 | 20.0 |
| 2012-03-01 | BR | Futures | 0.27095 | 0.27379 | 0.27095 | 0.27307 | 161.0 |
| 2012-03-01 | BZ | Futures | 117.07 | 120.63 | 116.81 | 119.42 | 1476.0 |
| 2012-03-01 | C | Futures | 1517.0 | 1536.0 | 1488.0 | 1513.0 | 6436.0 |
| 2012-03-01 | CB | Futures | 84.502 | 84.502 | 84.502 | 84.502 | 8.0 |
| 2012-03-01 | CC | Futures | 1776.0 | 1809.0 | 1758.0 | 1800.0 | 8548.0 |
| 2012-03-01 | CSC | Futures | 3.68 | 3.687 | 3.68 | 3.687 | 10.0 |
| 2012-03-01 | CT | Futures | 113.56 | 114.5 | 111.96 | 112.22 | 11697.0 |
| 2012-03-01 | DC | Futures | 25.89 | 25.96 | 25.68 | 25.96 | 60.0 |
| 2012-03-01 | DX | Futures | 76.697 | 76.887 | 76.59 | 76.73 | 20780.0 |
| 2012-03-01 | E1 | Futures | 1.4519 | 1.45518 | 1.44691 | 1.44914 | 48821.0 |
| 2012-03-01 | E6 | Futures | 1.59238 | 1.59656 | 1.5876 | 1.59166 | 246951.0 |
| 2012-03-01 | E7 | Futures | 1.5779 | 1.5819 | 1.5732 | 1.5771 | 3831.0 |
| 2012-03-01 | EBM | Futures | 279.11 | 281.4 | 277.47 | 281.07 | 1633.0 |
| 2012-03-01 | ED | Futures | 95.0916 | 95.1035 | 95.0892 | 95.0963 | 173649.0 |
| 2012-03-01 | ER | Futures | 97.484 | 97.499 | 97.484 | 97.489 | 78649.0 |
| 2012-03-01 | EW | Futures | 981.0 | 995.9 | 978.8 | 993.9 | 29977.0 |
| 2012-03-01 | FBTP | Futures | 67.09 | 68.66 | 67.09 | 68.35 | 22314.0 |
| 2012-03-01 | FBTS | Futures | 85.58 | 86.495 | 85.58 | 86.327 | 2545.0 |
| 2012-03-01 | FCE | Futures | 2431.1 | 2482.0 | 2424.0 | 2472.1 | 119533.0 |
| 2012-03-01 | FDAX | Futures | 7534.7 | 7688.2 | 7528.1 | 7657.3 | 151449.0 |
| 2012-03-01 | FESX | Futures | 1674.1 | 1712.2 | 1669.4 | 1702.8 | 1326376.0 |
| 2012-03-01 | FGBL | Futures | 113.17 | 113.32 | 112.59 | 112.73 | 794676.0 |
| 2012-03-01 | FGBM | Futures | 113.65 | 113.75 | 113.32 | 113.43 | 428318.0 |
| 2012-03-01 | FGBS | Futures | 109.949 | 109.974 | 109.884 | 109.899 | 451896.0 |
| 2012-03-01 | FGBX | Futures | 118.57 | 118.68 | 117.18 | 117.31 | 5911.0 |
| 2012-03-01 | FTDX | Futures | 710.6 | 724.1 | 710.6 | 716.7 | 244.0 |
| 2012-03-01 | FTI | Futures | 271.9 | 275.6 | 271.18 | 274.42 | 29773.0 |
| 2012-03-01 | FTUK | Futures | 4227.0 | 4276.8 | 4210.4 | 4266.3 | 118084.0 |
| 2012-03-01 | FVSA | Futures | 9653.92 | 9691.92 | 9235.83 | 9254.84 | 1585.0 |
| 2012-03-01 | FXXP | Futures | 186.4 | 189.0 | 186.4 | 188.7 | 4067.0 |
| 2012-03-01 | G | Futures | 94.18 | 94.36 | 93.56 | 93.64 | 170233.0 |
| 2012-03-01 | GF | Futures | 335.073 | 337.724 | 332.952 | 336.292 | 3090.0 |
| 2012-03-01 | GSCI | Futures | 1110.38 | 1137.47 | 1106.44 | 1122.9 | 1362.0 |
| 2012-03-01 | HE | Futures | 107.374 | 109.338 | 106.649 | 109.006 | 22724.0 |
| 2012-03-01 | HG | Futures | 5.0652 | 5.1635 | 5.0455 | 5.1544 | 48225.0 |
| 2012-03-01 | HO | Futures | 2.6417 | 2.7214 | 2.6256 | 2.6897 | 44078.0 |
| 2012-03-01 | HRC | Futures | 2731.0 | 2731.0 | 2731.0 | 2731.0 | 0.0 |
| 2012-03-01 | J1 | Futures | 0.0154558 | 0.0155361 | 0.0154282 | 0.0154872 | 92555.0 |
| 2012-03-01 | J7 | Futures | 0.015388 | 0.015469 | 0.015371 | 0.015423 | 679.0 |
> showing 50 of 99 rows — these rows as CSV