PREVIEW / futures_daily / 2013-05-09
file: by_date/futures_daily/2013/2013-05-09.parquet size: 9 KB rows: 102
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 |
|---|---|---|---|---|---|---|---|
| 2013-05-09 | ES | Futures | 1671.66 | 1675.77 | 1663.19 | 1667.81 | 1825700.0 |
| 2013-05-09 | NQ | Futures | 3420.22 | 3440.15 | 3407.51 | 3416.76 | 185018.0 |
| 2013-05-09 | YM | Futures | 14825.7 | 14875.0 | 14779.4 | 14813.9 | 137079.0 |
| 2013-05-09 | CL | Futures | 168.48 | 168.77 | 166.3 | 168.11 | 272196.0 |
| 2013-05-09 | GC | Futures | 1955.4 | 1959.4 | 1927.7 | 1949.6 | 162465.0 |
| 2013-05-09 | ZN | Futures | 118.213342 | 118.422052 | 118.157686 | 118.185514 | 1298741.0 |
| 2013-05-09 | A6 | Futures | 0.93651 | 0.9475 | 0.92479 | 0.92562 | 176526.0 |
| 2013-05-09 | AD | Futures | 1.00094 | 1.00245 | 0.99481 | 0.99532 | 75227.0 |
| 2013-05-09 | B | Futures | 100.05 | 100.32 | 99.28 | 100.26 | 175646.0 |
| 2013-05-09 | B6 | Futures | 1.6255 | 1.6308 | 1.6137 | 1.6142 | 131945.0 |
| 2013-05-09 | BFX | Futures | 3256.3 | 3263.6 | 3256.3 | 3262.7 | 15.0 |
| 2013-05-09 | BR | Futures | 0.24601 | 0.24705 | 0.24482 | 0.24505 | 553.0 |
| 2013-05-09 | BZ | Futures | 101.25 | 101.31 | 100.3 | 101.27 | 5887.0 |
| 2013-05-09 | C | Futures | 1646.0 | 1666.0 | 1636.0 | 1645.0 | 3479.0 |
| 2013-05-09 | CB | Futures | 81.721 | 81.721 | 81.721 | 81.721 | 1.0 |
| 2013-05-09 | CC | Futures | 1800.0 | 1806.0 | 1751.0 | 1761.0 | 15329.0 |
| 2013-05-09 | CNH | Futures | 7.1686 | 7.1742 | 7.1624 | 7.1742 | 89.0 |
| 2013-05-09 | CSC | Futures | 3.649 | 3.665 | 3.635 | 3.653 | 43.0 |
| 2013-05-09 | CT | Futures | 104.99 | 105.95 | 103.8 | 105.37 | 15809.0 |
| 2013-05-09 | DC | Futures | 28.02 | 28.06 | 27.72 | 27.92 | 327.0 |
| 2013-05-09 | DX | Futures | 78.775 | 79.688 | 78.65 | 79.65 | 34972.0 |
| 2013-05-09 | E1 | Futures | 1.37581 | 1.3789 | 1.35446 | 1.356 | 47975.0 |
| 2013-05-09 | E6 | Futures | 1.5515 | 1.55398 | 1.53405 | 1.53488 | 282023.0 |
| 2013-05-09 | E7 | Futures | 1.5414 | 1.5436 | 1.524 | 1.5249 | 4180.0 |
| 2013-05-09 | ED | Futures | 95.2683 | 95.2683 | 95.2635 | 95.2683 | 38146.0 |
| 2013-05-09 | ER | Futures | 97.827 | 97.832 | 97.822 | 97.827 | 41351.0 |
| 2013-05-09 | EW | Futures | 1209.3 | 1210.6 | 1202.5 | 1206.2 | 14086.0 |
| 2013-05-09 | FBTP | Futures | 80.38 | 80.62 | 80.01 | 80.18 | 27083.0 |
| 2013-05-09 | FBTS | Futures | 93.177 | 93.254 | 93.1 | 93.151 | 4281.0 |
| 2013-05-09 | FCE | Futures | 3020.2 | 3026.0 | 3000.2 | 3015.6 | 77955.0 |
| 2013-05-09 | FDAX | Futures | 9168.2 | 9204.9 | 9143.8 | 9191.6 | 72585.0 |
| 2013-05-09 | FESX | Futures | 1928.8 | 1932.3 | 1915.5 | 1926.7 | 605545.0 |
| 2013-05-09 | FGBL | Futures | 122.22 | 122.56 | 122.17 | 122.27 | 595255.0 |
| 2013-05-09 | FGBM | Futures | 118.15 | 118.36 | 118.15 | 118.25 | 403516.0 |
| 2013-05-09 | FGBS | Futures | 110.512 | 110.537 | 110.507 | 110.527 | 169843.0 |
| 2013-05-09 | FGBX | Futures | 129.66 | 129.93 | 129.19 | 129.51 | 6258.0 |
| 2013-05-09 | FMWO | Futures | 4895.3 | 4895.3 | 4895.3 | 4895.3 | 0.0 |
| 2013-05-09 | FOAT | Futures | 109.91 | 110.02 | 109.68 | 109.73 | 29111.0 |
| 2013-05-09 | FTDX | Futures | 891.9 | 893.7 | 891.9 | 893.7 | 2.0 |
| 2013-05-09 | FTI | Futures | 310.35 | 312.18 | 309.61 | 311.49 | 15161.0 |
| 2013-05-09 | FTUK | Futures | 4873.5 | 4884.6 | 4857.2 | 4875.7 | 53829.0 |
| 2013-05-09 | FVSA | Futures | 2859.77 | 2883.54 | 2836.01 | 2859.77 | 4012.0 |
| 2013-05-09 | FXXP | Futures | 221.4 | 222.6 | 219.4 | 222.5 | 1038.0 |
| 2013-05-09 | G | Futures | 99.85 | 100.08 | 99.67 | 99.82 | 161663.0 |
| 2013-05-09 | GF | Futures | 246.084 | 246.402 | 245.314 | 245.994 | 1787.0 |
| 2013-05-09 | GSCI | Futures | 1010.91 | 1019.82 | 1010.91 | 1018.14 | 1749.0 |
| 2013-05-09 | HE | Futures | 90.029 | 90.127 | 88.68 | 88.852 | 29133.0 |
| 2013-05-09 | HG | Futures | 4.2883 | 4.3042 | 4.2233 | 4.2558 | 63212.0 |
| 2013-05-09 | HH | Futures | 44.17 | 45.125 | 43.934 | 44.755 | 3432.0 |
| 2013-05-09 | HO | Futures | 2.3513 | 2.3661 | 2.3364 | 2.3639 | 57605.0 |
> showing 50 of 102 rows — these rows as CSV