PREVIEW / futures_daily / 2010-08-11
file: by_date/futures_daily/2010/2010-08-11.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-08-11 | ES | Futures | 1091.66 | 1092.15 | 1057.77 | 1058.26 | 2638258.0 |
| 2010-08-11 | NQ | Futures | 2147.07 | 2148.2 | 2079.16 | 2080.01 | 407601.0 |
| 2010-08-11 | YM | Futures | 9816.4 | 9822.8 | 9554.7 | 9557.5 | 148797.0 |
| 2010-08-11 | CL | Futures | 170.32 | 170.78 | 164.01 | 165.65 | 416889.0 |
| 2010-08-11 | GC | Futures | 1640.5 | 1645.0 | 1623.2 | 1630.0 | 117462.0 |
| 2010-08-11 | ZN | Futures | 102.514175 | 103.000813 | 102.514175 | 102.949588 | 1362924.0 |
| 2010-08-11 | A6 | Futures | 0.75425 | 0.75466 | 0.74033 | 0.74157 | 117926.0 |
| 2010-08-11 | AD | Futures | 0.95774 | 0.95814 | 0.94234 | 0.94313 | 107244.0 |
| 2010-08-11 | B | Futures | 69.45 | 69.59 | 67.24 | 67.84 | 103489.0 |
| 2010-08-11 | B6 | Futures | 1.6449 | 1.646 | 1.6215 | 1.6261 | 158309.0 |
| 2010-08-11 | BR | Futures | 0.23538 | 0.23538 | 0.23488 | 0.23488 | 44.0 |
| 2010-08-11 | BZ | Futures | 73.0 | 73.0 | 73.0 | 73.0 | 72.0 |
| 2010-08-11 | C | Futures | 2315.0 | 2325.0 | 2290.0 | 2296.0 | 3416.0 |
| 2010-08-11 | CB | Futures | 91.744 | 93.193 | 91.744 | 91.768 | 53.0 |
| 2010-08-11 | CC | Futures | 2409.0 | 2449.0 | 2370.0 | 2385.0 | 13929.0 |
| 2010-08-11 | CT | Futures | 70.76 | 71.08 | 70.62 | 70.85 | 20.0 |
| 2010-08-11 | DC | Futures | 23.92 | 23.99 | 23.74 | 23.91 | 224.0 |
| 2010-08-11 | DX | Futures | 81.732 | 83.284 | 81.722 | 83.081 | 31466.0 |
| 2010-08-11 | E1 | Futures | 1.25357 | 1.25436 | 1.23912 | 1.24175 | 35093.0 |
| 2010-08-11 | E6 | Futures | 1.55817 | 1.55924 | 1.52057 | 1.52282 | 421976.0 |
| 2010-08-11 | E7 | Futures | 1.5471 | 1.548 | 1.5095 | 1.5119 | 5629.0 |
| 2010-08-11 | ED | Futures | 94.5558 | 94.5748 | 94.5558 | 94.5653 | 184163.0 |
| 2010-08-11 | ER | Futures | 97.252 | 97.281 | 97.252 | 97.272 | 108385.0 |
| 2010-08-11 | EW | Futures | 752.9 | 753.3 | 723.5 | 723.6 | 32325.0 |
| 2010-08-11 | FBTP | Futures | 66.87 | 67.01 | 66.71 | 66.95 | 4652.0 |
| 2010-08-11 | FCE | Futures | 2445.1 | 2445.1 | 2371.6 | 2379.5 | 134824.0 |
| 2010-08-11 | FDAX | Futures | 6828.7 | 6828.7 | 6684.0 | 6706.3 | 136604.0 |
| 2010-08-11 | FESX | Futures | 1730.0 | 1730.0 | 1678.0 | 1687.2 | 1322730.0 |
| 2010-08-11 | FEU3 | Futures | 97.82 | 97.835 | 97.82 | 97.83 | 24.0 |
| 2010-08-11 | FGBL | Futures | 101.98 | 102.5 | 101.85 | 102.42 | 803888.0 |
| 2010-08-11 | FGBM | Futures | 105.8 | 106.17 | 105.74 | 106.14 | 442394.0 |
| 2010-08-11 | FGBS | Futures | 107.559 | 107.682 | 107.515 | 107.657 | 547077.0 |
| 2010-08-11 | FGBX | Futures | 101.4 | 102.94 | 101.4 | 102.76 | 2608.0 |
| 2010-08-11 | FTDX | Futures | 679.2 | 679.2 | 652.7 | 656.7 | 528.0 |
| 2010-08-11 | FTI | Futures | 264.77 | 264.77 | 259.1 | 259.42 | 522.0 |
| 2010-08-11 | FTUK | Futures | 3664.1 | 3669.6 | 3582.2 | 3606.7 | 103715.0 |
| 2010-08-11 | G | Futures | 82.41 | 83.06 | 82.38 | 82.92 | 111625.0 |
| 2010-08-11 | GF | Futures | 284.003 | 285.583 | 281.854 | 284.508 | 2631.0 |
| 2010-08-11 | GSCI | Futures | 894.34 | 895.28 | 883.82 | 883.99 | 3460.0 |
| 2010-08-11 | HE | Futures | 97.581 | 97.911 | 96.495 | 97.021 | 13468.0 |
| 2010-08-11 | HG | Futures | 4.4424 | 4.4645 | 4.3372 | 4.358 | 36492.0 |
| 2010-08-11 | HO | Futures | 1.8579 | 1.8666 | 1.8031 | 1.8186 | 57887.0 |
| 2010-08-11 | HRC | Futures | 2753.7 | 2753.7 | 2753.7 | 2753.7 | 0.0 |
| 2010-08-11 | J1 | Futures | 0.0147463 | 0.0148519 | 0.0147249 | 0.0147651 | 140514.0 |
| 2010-08-11 | J7 | Futures | 0.014634 | 0.014739 | 0.014615 | 0.014654 | 322.0 |
| 2010-08-11 | JB | Futures | 120.89 | 121.19 | 120.89 | 121.1 | 1942.0 |
| 2010-08-11 | KC | Futures | 425.43 | 431.7 | 424.67 | 428.44 | 12994.0 |
| 2010-08-11 | KE | Futures | 3034.1 | 3093.75 | 2982.96 | 3025.57 | 15834.0 |
| 2010-08-11 | L | Futures | 98.096 | 98.135 | 98.076 | 98.125 | 59562.0 |
| 2010-08-11 | LBS | Futures | 593.1 | 595.1 | 577.7 | 586.0 | 443.0 |
> showing 50 of 89 rows — these rows as CSV