PREVIEW / futures_daily / 2012-08-17
file: by_date/futures_daily/2012/2012-08-17.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-08-17 | ES | Futures | 1431.73 | 1434.77 | 1428.69 | 1433.25 | 1139564.0 |
| 2012-08-17 | NQ | Futures | 3174.43 | 3191.36 | 3171.56 | 3186.19 | 151382.0 |
| 2012-08-17 | YM | Futures | 12833.5 | 12860.6 | 12818.9 | 12851.9 | 63238.0 |
| 2012-08-17 | CL | Futures | 172.86 | 174.72 | 172.33 | 174.25 | 131975.0 |
| 2012-08-17 | GC | Futures | 2158.5 | 2166.9 | 2154.0 | 2162.1 | 77285.0 |
| 2012-08-17 | ZN | Futures | 115.351152 | 115.637146 | 115.323914 | 115.48734 | 678183.0 |
| 2012-08-17 | A6 | Futures | 0.9428 | 0.94414 | 0.93362 | 0.93461 | 113449.0 |
| 2012-08-17 | AD | Futures | 1.01564 | 1.01594 | 1.01183 | 1.01343 | 71080.0 |
| 2012-08-17 | B | Futures | 103.94 | 104.2 | 102.32 | 103.24 | 187573.0 |
| 2012-08-17 | B6 | Futures | 1.6445 | 1.6448 | 1.638 | 1.6398 | 82714.0 |
| 2012-08-17 | BFX | Futures | 2851.7 | 2858.2 | 2850.1 | 2858.2 | 44.0 |
| 2012-08-17 | BR | Futures | 0.23594 | 0.23639 | 0.23549 | 0.23632 | 54.0 |
| 2012-08-17 | BZ | Futures | 108.98 | 109.32 | 107.89 | 108.8 | 1201.0 |
| 2012-08-17 | C | Futures | 1644.0 | 1678.0 | 1636.0 | 1653.0 | 1544.0 |
| 2012-08-17 | CB | Futures | 97.985 | 98.106 | 97.985 | 98.106 | 1.0 |
| 2012-08-17 | CC | Futures | 1821.0 | 1869.0 | 1812.0 | 1842.0 | 11754.0 |
| 2012-08-17 | CSC | Futures | 4.294 | 4.294 | 4.214 | 4.214 | 2.0 |
| 2012-08-17 | CT | Futures | 95.32 | 96.82 | 95.32 | 95.71 | 41.0 |
| 2012-08-17 | DC | Futures | 31.17 | 31.68 | 30.71 | 31.09 | 418.0 |
| 2012-08-17 | DX | Futures | 80.022 | 80.391 | 79.959 | 80.234 | 15870.0 |
| 2012-08-17 | E1 | Futures | 1.32899 | 1.3317 | 1.32176 | 1.32537 | 31020.0 |
| 2012-08-17 | E6 | Futures | 1.45787 | 1.46106 | 1.44997 | 1.45375 | 198739.0 |
| 2012-08-17 | E7 | Futures | 1.4486 | 1.4521 | 1.441 | 1.4447 | 3360.0 |
| 2012-08-17 | ED | Futures | 95.168 | 95.1752 | 95.168 | 95.1704 | 61961.0 |
| 2012-08-17 | ER | Futures | 97.817 | 97.842 | 97.817 | 97.832 | 72734.0 |
| 2012-08-17 | EW | Futures | 984.6 | 990.4 | 983.1 | 988.9 | 11802.0 |
| 2012-08-17 | FBTP | Futures | 66.6 | 66.69 | 66.34 | 66.5 | 7677.0 |
| 2012-08-17 | FBTS | Futures | 86.708 | 87.113 | 86.617 | 87.113 | 3136.0 |
| 2012-08-17 | FCE | Futures | 2603.0 | 2604.5 | 2585.5 | 2594.4 | 101081.0 |
| 2012-08-17 | FDAX | Futures | 7653.4 | 7702.5 | 7641.9 | 7681.2 | 99159.0 |
| 2012-08-17 | FESX | Futures | 1667.8 | 1675.2 | 1663.0 | 1668.4 | 935125.0 |
| 2012-08-17 | FGBL | Futures | 117.07 | 117.47 | 116.83 | 117.39 | 425398.0 |
| 2012-08-17 | FGBM | Futures | 115.85 | 116.12 | 115.78 | 116.07 | 263045.0 |
| 2012-08-17 | FGBS | Futures | 110.477 | 110.512 | 110.457 | 110.502 | 163003.0 |
| 2012-08-17 | FGBX | Futures | 124.06 | 125.08 | 123.71 | 124.89 | 6750.0 |
| 2012-08-17 | FOAT | Futures | 102.49 | 102.7 | 102.15 | 102.57 | 16452.0 |
| 2012-08-17 | FTDX | Futures | 735.2 | 741.7 | 735.2 | 741.7 | 16.0 |
| 2012-08-17 | FTI | Futures | 285.07 | 286.3 | 284.13 | 285.45 | 24232.0 |
| 2012-08-17 | FTUK | Futures | 4250.6 | 4261.2 | 4242.6 | 4255.0 | 60464.0 |
| 2012-08-17 | FVSA | Futures | 6660.87 | 6660.87 | 6468.73 | 6519.97 | 3865.0 |
| 2012-08-17 | FXXP | Futures | 194.6 | 195.5 | 194.6 | 195.5 | 2015.0 |
| 2012-08-17 | G | Futures | 98.91 | 99.17 | 98.85 | 99.14 | 69773.0 |
| 2012-08-17 | GF | Futures | 281.471 | 282.555 | 279.945 | 280.142 | 1542.0 |
| 2012-08-17 | GSCI | Futures | 1074.55 | 1077.53 | 1069.0 | 1075.44 | 248.0 |
| 2012-08-17 | HE | Futures | 93.338 | 95.099 | 93.121 | 94.172 | 10668.0 |
| 2012-08-17 | HG | Futures | 4.3576 | 4.4117 | 4.348 | 4.4053 | 44586.0 |
| 2012-08-17 | HO | Futures | 2.5392 | 2.5464 | 2.5121 | 2.5285 | 42832.0 |
| 2012-08-17 | HRC | Futures | 2548.9 | 2548.9 | 2548.9 | 2548.9 | 0.0 |
| 2012-08-17 | J1 | Futures | 0.015799 | 0.015819 | 0.0157476 | 0.0157576 | 69899.0 |
| 2012-08-17 | J7 | Futures | 0.015737 | 0.015756 | 0.01569 | 0.015696 | 247.0 |
> showing 50 of 99 rows — these rows as CSV