PREVIEW / futures_daily / 2010-09-16
file: by_date/futures_daily/2010/2010-09-16.parquet size: 9 KB rows: 89
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 |
|---|---|---|---|---|---|---|---|
| 2010-09-16 | ES | Futures | 1098.76 | 1101.7 | 1090.67 | 1100.23 | 1866295.0 |
| 2010-09-16 | NQ | Futures | 2199.18 | 2214.78 | 2187.85 | 2210.81 | 328922.0 |
| 2010-09-16 | YM | Futures | 9779.5 | 9823.2 | 9725.5 | 9816.7 | 134041.0 |
| 2010-09-16 | CL | Futures | 160.14 | 160.64 | 156.95 | 157.81 | 211074.0 |
| 2010-09-16 | GC | Futures | 1725.0 | 1739.2 | 1721.0 | 1731.4 | 99894.0 |
| 2010-09-16 | ZN | Futures | 102.561099 | 102.806275 | 102.096554 | 102.328827 | 1393514.0 |
| 2010-09-16 | A6 | Futures | 0.77869 | 0.78054 | 0.77483 | 0.77701 | 80402.0 |
| 2010-09-16 | AD | Futures | 0.96369 | 0.96548 | 0.96082 | 0.9626 | 53624.0 |
| 2010-09-16 | B | Futures | 68.24 | 68.68 | 67.15 | 67.68 | 155455.0 |
| 2010-09-16 | B6 | Futures | 1.6214 | 1.6236 | 1.612 | 1.6228 | 95523.0 |
| 2010-09-16 | BFX | Futures | 2977.9 | 2977.9 | 2948.5 | 2956.2 | 1438.0 |
| 2010-09-16 | BR | Futures | 0.24544 | 0.24544 | 0.24544 | 0.24544 | 59.0 |
| 2010-09-16 | BZ | Futures | 72.72 | 72.86 | 71.3 | 71.83 | 502.0 |
| 2010-09-16 | C | Futures | 2044.0 | 2085.0 | 2031.0 | 2056.0 | 8989.0 |
| 2010-09-16 | CC | Futures | 2230.0 | 2305.0 | 2230.0 | 2268.0 | 11898.0 |
| 2010-09-16 | CT | Futures | 78.28 | 79.92 | 78.28 | 79.86 | 24.0 |
| 2010-09-16 | DC | Futures | 24.99 | 25.4 | 24.99 | 25.39 | 229.0 |
| 2010-09-16 | DX | Futures | 81.99 | 82.131 | 81.594 | 81.761 | 16837.0 |
| 2010-09-16 | E1 | Futures | 1.31004 | 1.31411 | 1.29179 | 1.29441 | 66016.0 |
| 2010-09-16 | E6 | Futures | 1.53855 | 1.55097 | 1.5343 | 1.54672 | 350791.0 |
| 2010-09-16 | E7 | Futures | 1.5269 | 1.5392 | 1.5228 | 1.535 | 4402.0 |
| 2010-09-16 | ED | Futures | 94.6698 | 94.6793 | 94.6555 | 94.6746 | 131255.0 |
| 2010-09-16 | ER | Futures | 97.301 | 97.311 | 97.276 | 97.301 | 241914.0 |
| 2010-09-16 | EW | Futures | 765.7 | 765.8 | 759.6 | 764.6 | 29449.0 |
| 2010-09-16 | FBTP | Futures | 66.91 | 66.91 | 66.72 | 66.73 | 3169.0 |
| 2010-09-16 | FCE | Futures | 2460.9 | 2472.7 | 2446.8 | 2453.1 | 73828.0 |
| 2010-09-16 | FDAX | Futures | 6804.2 | 6834.1 | 6779.7 | 6800.9 | 148947.0 |
| 2010-09-16 | FESX | Futures | 1730.7 | 1741.3 | 1725.7 | 1731.3 | 1097100.0 |
| 2010-09-16 | FEU3 | Futures | 97.859 | 97.859 | 97.855 | 97.859 | 37.0 |
| 2010-09-16 | FGBL | Futures | 102.8 | 102.86 | 102.18 | 102.31 | 1223169.0 |
| 2010-09-16 | FGBM | Futures | 106.07 | 106.08 | 105.68 | 105.78 | 639406.0 |
| 2010-09-16 | FGBS | Futures | 107.573 | 107.573 | 107.42 | 107.474 | 594609.0 |
| 2010-09-16 | FGBX | Futures | 104.94 | 104.94 | 103.44 | 103.69 | 4166.0 |
| 2010-09-16 | FTDX | Futures | 681.3 | 683.5 | 677.4 | 679.6 | 1886.0 |
| 2010-09-16 | FTI | Futures | 269.49 | 270.09 | 268.05 | 268.77 | 21394.0 |
| 2010-09-16 | FTUK | Futures | 3824.7 | 3833.0 | 3809.8 | 3818.1 | 100339.0 |
| 2010-09-16 | FXXP | Futures | 170.0 | 170.0 | 170.0 | 170.0 | 1500.0 |
| 2010-09-16 | G | Futures | 83.33 | 83.5 | 83.0 | 83.13 | 137478.0 |
| 2010-09-16 | GF | Futures | 280.784 | 283.299 | 279.527 | 281.853 | 2286.0 |
| 2010-09-16 | GSCI | Futures | 885.2 | 888.45 | 875.19 | 880.86 | 237.0 |
| 2010-09-16 | HE | Futures | 104.201 | 104.925 | 102.06 | 103.015 | 14438.0 |
| 2010-09-16 | HG | Futures | 4.6314 | 4.6941 | 4.596 | 4.6627 | 23343.0 |
| 2010-09-16 | HO | Futures | 1.8244 | 1.8286 | 1.792 | 1.8043 | 25555.0 |
| 2010-09-16 | HRC | Futures | 2707.8 | 2707.8 | 2707.8 | 2707.8 | 0.0 |
| 2010-09-16 | J1 | Futures | 0.0146663 | 0.0147529 | 0.0146311 | 0.014655 | 136188.0 |
| 2010-09-16 | J7 | Futures | 0.014563 | 0.014649 | 0.014533 | 0.014554 | 214.0 |
| 2010-09-16 | JB | Futures | 120.93 | 121.37 | 120.74 | 121.16 | 1595.0 |
| 2010-09-16 | KC | Futures | 477.63 | 490.03 | 472.67 | 475.64 | 9767.0 |
| 2010-09-16 | KE | Futures | 3171.81 | 3208.32 | 3106.1 | 3131.13 | 13013.0 |
| 2010-09-16 | L | Futures | 98.106 | 98.125 | 98.086 | 98.115 | 60823.0 |
> showing 50 of 89 rows — these rows as CSV