PREVIEW / futures_daily / 2009-07-16
file: by_date/futures_daily/2009/2009-07-16.parquet size: 8 KB rows: 86
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-16 | ES | Futures | 888.2 | 902.59 | 883.64 | 897.8 | 2191367.0 |
| 2009-07-16 | NQ | Futures | 1684.46 | 1712.05 | 1676.86 | 1703.6 | 296176.0 |
| 2009-07-16 | YM | Futures | 7701.6 | 7841.5 | 7671.8 | 7821.6 | 123736.0 |
| 2009-07-16 | CL | Futures | 162.15 | 162.8 | 158.21 | 162.36 | 158313.0 |
| 2009-07-16 | GC | Futures | 1300.4 | 1302.1 | 1291.2 | 1295.0 | 60370.0 |
| 2009-07-16 | ZN | Futures | 91.913905 | 92.529537 | 91.913905 | 92.209409 | 799503.0 |
| 2009-07-16 | A6 | Futures | 0.6425 | 0.64587 | 0.63695 | 0.64459 | 66221.0 |
| 2009-07-16 | AD | Futures | 0.88736 | 0.88815 | 0.88015 | 0.8839 | 61172.0 |
| 2009-07-16 | B | Futures | 60.62 | 60.82 | 59.51 | 60.69 | 127176.0 |
| 2009-07-16 | B6 | Futures | 1.7099 | 1.7186 | 1.7033 | 1.7136 | 78601.0 |
| 2009-07-16 | BFX | Futures | 2376.8 | 2388.3 | 2363.9 | 2379.5 | 1648.0 |
| 2009-07-16 | BR | Futures | 0.19997 | 0.19997 | 0.19997 | 0.19997 | 20.0 |
| 2009-07-16 | BZ | Futures | 64.0 | 64.75 | 64.0 | 64.75 | 2.0 |
| 2009-07-16 | C | Futures | 1816.0 | 1821.0 | 1776.0 | 1802.0 | 20839.0 |
| 2009-07-16 | CB | Futures | 75.33 | 76.452 | 75.33 | 75.33 | 18.0 |
| 2009-07-16 | CC | Futures | 2411.0 | 2415.0 | 2352.0 | 2381.0 | 4512.0 |
| 2009-07-16 | CT | Futures | 53.87 | 54.69 | 53.26 | 54.47 | 83.0 |
| 2009-07-16 | DC | Futures | 19.92 | 20.69 | 19.83 | 20.58 | 304.0 |
| 2009-07-16 | DX | Futures | 81.463 | 81.653 | 81.151 | 81.238 | 4050.0 |
| 2009-07-16 | E1 | Futures | 1.23205 | 1.23774 | 1.22782 | 1.2343 | 32315.0 |
| 2009-07-16 | E6 | Futures | 1.67405 | 1.68176 | 1.66871 | 1.67951 | 177036.0 |
| 2009-07-16 | E7 | Futures | 1.6572 | 1.6644 | 1.6516 | 1.6623 | 2147.0 |
| 2009-07-16 | ED | Futures | 93.8716 | 93.9094 | 93.8527 | 93.8999 | 127933.0 |
| 2009-07-16 | ER | Futures | 97.051 | 97.086 | 97.037 | 97.066 | 115936.0 |
| 2009-07-16 | EW | Futures | 559.6 | 571.8 | 556.4 | 568.2 | 27921.0 |
| 2009-07-16 | FCE | Futures | 2074.7 | 2126.1 | 2068.4 | 2096.9 | 91941.0 |
| 2009-07-16 | FDAX | Futures | 5399.2 | 5510.5 | 5380.0 | 5448.6 | 164269.0 |
| 2009-07-16 | FESX | Futures | 1455.9 | 1487.5 | 1452.3 | 1466.6 | 1295313.0 |
| 2009-07-16 | FEU3 | Futures | 97.623 | 97.643 | 97.623 | 97.643 | 1760.0 |
| 2009-07-16 | FGBL | Futures | 92.18 | 92.64 | 91.95 | 92.33 | 711344.0 |
| 2009-07-16 | FGBM | Futures | 98.12 | 98.44 | 97.99 | 98.27 | 359089.0 |
| 2009-07-16 | FGBS | Futures | 104.133 | 104.263 | 104.085 | 104.215 | 416414.0 |
| 2009-07-16 | FGBX | Futures | 84.25 | 84.88 | 83.83 | 84.43 | 863.0 |
| 2009-07-16 | FTDX | Futures | 572.8 | 586.2 | 572.8 | 578.2 | 1051.0 |
| 2009-07-16 | FTI | Futures | 214.25 | 217.29 | 212.44 | 215.44 | 18817.0 |
| 2009-07-16 | FTUK | Futures | 2864.4 | 2913.8 | 2851.1 | 2878.0 | 105903.0 |
| 2009-07-16 | G | Futures | 75.03 | 75.52 | 74.98 | 75.27 | 65408.0 |
| 2009-07-16 | GF | Futures | 284.657 | 288.309 | 284.519 | 286.38 | 1697.0 |
| 2009-07-16 | GSCI | Futures | 868.43 | 882.32 | 864.56 | 879.61 | 99.0 |
| 2009-07-16 | HE | Futures | 93.132 | 94.284 | 92.844 | 93.888 | 9486.0 |
| 2009-07-16 | HG | Futures | 3.3509 | 3.3839 | 3.3095 | 3.3551 | 14775.0 |
| 2009-07-16 | HO | Futures | 1.6431 | 1.6608 | 1.6148 | 1.6545 | 24534.0 |
| 2009-07-16 | HRC | Futures | 2409.0 | 2409.0 | 2409.0 | 2409.0 | 0.0 |
| 2009-07-16 | J1 | Futures | 0.0133659 | 0.0135119 | 0.0133369 | 0.0134377 | 91142.0 |
| 2009-07-16 | J7 | Futures | 0.01321 | 0.013318 | 0.013163 | 0.013253 | 48.0 |
| 2009-07-16 | JB | Futures | 116.73 | 116.75 | 116.41 | 116.73 | 3310.0 |
| 2009-07-16 | KC | Futures | 322.22 | 323.03 | 310.96 | 313.81 | 9512.0 |
| 2009-07-16 | KE | Futures | 2687.16 | 2749.51 | 2664.38 | 2683.56 | 8699.0 |
| 2009-07-16 | L | Futures | 97.298 | 97.327 | 97.288 | 97.317 | 35287.0 |
| 2009-07-16 | LBS | Futures | 777.8 | 785.5 | 746.9 | 756.7 | 754.0 |
> showing 50 of 86 rows — these rows as CSV