PREVIEW / futures_daily / 2012-06-01
file: by_date/futures_daily/2012/2012-06-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-06-01 | ES | Futures | 1316.33 | 1317.59 | 1283.33 | 1283.83 | 3278646.0 |
| 2012-06-01 | NQ | Futures | 2887.21 | 2889.51 | 2811.6 | 2812.74 | 362792.0 |
| 2012-06-01 | YM | Futures | 12029.7 | 12039.4 | 11762.3 | 11770.0 | 248257.0 |
| 2012-06-01 | CL | Futures | 158.42 | 158.69 | 150.81 | 152.53 | 407579.0 |
| 2012-06-01 | GC | Futures | 2087.8 | 2181.7 | 2066.0 | 2168.4 | 307040.0 |
| 2012-06-01 | ZN | Futures | 117.008765 | 117.753354 | 116.913999 | 117.536747 | 174099.0 |
| 2012-06-01 | A6 | Futures | 0.87382 | 0.87427 | 0.86042 | 0.87004 | 225476.0 |
| 2012-06-01 | AD | Futures | 0.97382 | 0.97422 | 0.96305 | 0.96718 | 166703.0 |
| 2012-06-01 | B | Futures | 91.99 | 92.16 | 88.19 | 88.97 | 153083.0 |
| 2012-06-01 | B6 | Futures | 1.6168 | 1.6205 | 1.6024 | 1.6134 | 175818.0 |
| 2012-06-01 | BFX | Futures | 2546.6 | 2546.6 | 2497.2 | 2500.2 | 11.0 |
| 2012-06-01 | BR | Futures | 0.23114 | 0.23162 | 0.22973 | 0.23081 | 283.0 |
| 2012-06-01 | BZ | Futures | 97.83 | 97.97 | 93.75 | 94.59 | 1436.0 |
| 2012-06-01 | C | Futures | 1460.0 | 1468.0 | 1439.0 | 1451.0 | 5968.0 |
| 2012-06-01 | CB | Futures | 80.062 | 80.062 | 79.793 | 79.793 | 4.0 |
| 2012-06-01 | CC | Futures | 1560.0 | 1573.0 | 1527.0 | 1555.0 | 13422.0 |
| 2012-06-01 | CSC | Futures | 3.599 | 3.599 | 3.575 | 3.582 | 70.0 |
| 2012-06-01 | CT | Futures | 87.75 | 87.9 | 83.86 | 83.91 | 19605.0 |
| 2012-06-01 | DC | Futures | 25.34 | 25.58 | 25.2 | 25.39 | 87.0 |
| 2012-06-01 | DX | Futures | 80.621 | 81.067 | 80.127 | 80.392 | 57677.0 |
| 2012-06-01 | E1 | Futures | 1.34788 | 1.35875 | 1.34002 | 1.35338 | 76159.0 |
| 2012-06-01 | E6 | Futures | 1.4756 | 1.48765 | 1.46688 | 1.48181 | 458185.0 |
| 2012-06-01 | E7 | Futures | 1.4616 | 1.4733 | 1.4529 | 1.4676 | 5069.0 |
| 2012-06-01 | ED | Futures | 95.0693 | 95.0693 | 95.0573 | 95.0645 | 217399.0 |
| 2012-06-01 | ER | Futures | 97.572 | 97.587 | 97.567 | 97.582 | 92843.0 |
| 2012-06-01 | EW | Futures | 932.2 | 933.5 | 904.0 | 905.2 | 37555.0 |
| 2012-06-01 | FBTP | Futures | 64.97 | 66.15 | 64.8 | 65.86 | 45785.0 |
| 2012-06-01 | FBTS | Futures | 83.427 | 83.777 | 83.321 | 83.646 | 4432.0 |
| 2012-06-01 | FCE | Futures | 2215.9 | 2224.0 | 2142.6 | 2163.6 | 199735.0 |
| 2012-06-01 | FDAX | Futures | 6903.5 | 6921.7 | 6642.1 | 6704.0 | 254928.0 |
| 2012-06-01 | FESX | Futures | 1456.3 | 1461.2 | 1400.4 | 1427.3 | 2269410.0 |
| 2012-06-01 | FGBL | Futures | 119.63 | 120.45 | 119.58 | 119.99 | 1385858.0 |
| 2012-06-01 | FGBM | Futures | 116.38 | 116.64 | 116.32 | 116.51 | 836800.0 |
| 2012-06-01 | FGBS | Futures | 110.402 | 110.447 | 110.378 | 110.407 | 824434.0 |
| 2012-06-01 | FGBX | Futures | 133.17 | 136.52 | 133.15 | 135.29 | 24341.0 |
| 2012-06-01 | FOAT | Futures | 100.01 | 102.42 | 99.89 | 100.99 | 40401.0 |
| 2012-06-01 | FTDX | Futures | 699.4 | 699.4 | 676.4 | 683.4 | 270.0 |
| 2012-06-01 | FTI | Futures | 250.8 | 251.8 | 243.57 | 246.04 | 52193.0 |
| 2012-06-01 | FTUK | Futures | 3884.3 | 3897.8 | 3804.7 | 3832.8 | 154660.0 |
| 2012-06-01 | FVSA | Futures | 11071.09 | 11743.49 | 11071.09 | 11665.3 | 6759.0 |
| 2012-06-01 | FXXP | Futures | 173.9 | 173.9 | 169.3 | 170.6 | 5457.0 |
| 2012-06-01 | G | Futures | 99.65 | 100.76 | 99.5 | 100.03 | 188728.0 |
| 2012-06-01 | GF | Futures | 310.298 | 311.285 | 307.535 | 310.594 | 2739.0 |
| 2012-06-01 | GSCI | Futures | 929.26 | 931.64 | 915.93 | 921.32 | 439.0 |
| 2012-06-01 | HE | Futures | 95.793 | 96.924 | 95.135 | 96.398 | 22339.0 |
| 2012-06-01 | HG | Futures | 4.397 | 4.4232 | 4.3217 | 4.3394 | 88401.0 |
| 2012-06-01 | HO | Futures | 2.2293 | 2.2333 | 2.1499 | 2.1653 | 15768.0 |
| 2012-06-01 | HRC | Futures | 2510.2 | 2510.2 | 2510.2 | 2510.2 | 0.0 |
| 2012-06-01 | J1 | Futures | 0.0160046 | 0.0161513 | 0.0159307 | 0.0160573 | 182346.0 |
| 2012-06-01 | J7 | Futures | 0.015933 | 0.016081 | 0.015858 | 0.015982 | 744.0 |
> showing 50 of 99 rows — these rows as CSV