PREVIEW / futures_daily / 2009-04-29
file: by_date/futures_daily/2009/2009-04-29.parquet size: 8 KB rows: 84
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-04-29 | ES | Futures | 810.37 | 838.01 | 809.41 | 828.24 | 2418138.0 |
| 2009-04-29 | NQ | Futures | 1527.13 | 1569.83 | 1522.36 | 1547.92 | 289106.0 |
| 2009-04-29 | YM | Futures | 7138.2 | 7360.7 | 7125.7 | 7288.0 | 171544.0 |
| 2009-04-29 | CL | Futures | 132.65 | 138.49 | 132.3 | 137.28 | 234826.0 |
| 2009-04-29 | GC | Futures | 1237.8 | 1251.7 | 1230.0 | 1246.8 | 69351.0 |
| 2009-04-29 | ZN | Futures | 94.451544 | 94.730699 | 93.601941 | 94.087428 | 770215.0 |
| 2009-04-29 | A6 | Futures | 0.56225 | 0.58059 | 0.56065 | 0.57955 | 49887.0 |
| 2009-04-29 | AD | Futures | 0.80734 | 0.82132 | 0.80616 | 0.82044 | 49696.0 |
| 2009-04-29 | B | Futures | 48.43 | 50.37 | 48.43 | 49.89 | 60815.0 |
| 2009-04-29 | B6 | Futures | 1.5227 | 1.5415 | 1.5209 | 1.5365 | 68997.0 |
| 2009-04-29 | BFX | Futures | 2093.7 | 2133.1 | 2093.6 | 2125.4 | 224.0 |
| 2009-04-29 | BZ | Futures | 54.35 | 54.35 | 54.07 | 54.07 | 2.0 |
| 2009-04-29 | C | Futures | 1837.0 | 1842.0 | 1814.0 | 1831.0 | 1555.0 |
| 2009-04-29 | CB | Futures | 76.436 | 78.091 | 76.436 | 76.436 | 15.0 |
| 2009-04-29 | CC | Futures | 2125.0 | 2143.0 | 2096.0 | 2120.0 | 3701.0 |
| 2009-04-29 | CT | Futures | 48.8 | 50.14 | 48.38 | 49.35 | 8587.0 |
| 2009-04-29 | DC | Futures | 25.99 | 26.23 | 25.75 | 26.14 | 235.0 |
| 2009-04-29 | DX | Futures | 87.982 | 87.982 | 86.747 | 87.174 | 7195.0 |
| 2009-04-29 | E1 | Futures | 1.16019 | 1.17411 | 1.15913 | 1.16868 | 31518.0 |
| 2009-04-29 | E6 | Futures | 1.55763 | 1.58383 | 1.55525 | 1.57529 | 164285.0 |
| 2009-04-29 | E7 | Futures | 1.5391 | 1.5643 | 1.5374 | 1.557 | 2434.0 |
| 2009-04-29 | EBM | Futures | 216.72 | 219.05 | 216.34 | 217.5 | 3111.0 |
| 2009-04-29 | ED | Futures | 93.3226 | 93.3697 | 93.3132 | 93.365 | 185416.0 |
| 2009-04-29 | ER | Futures | 96.689 | 96.713 | 96.669 | 96.709 | 113154.0 |
| 2009-04-29 | EW | Futures | 526.0 | 547.0 | 524.7 | 540.8 | 40674.0 |
| 2009-04-29 | FCE | Futures | 1920.5 | 1970.7 | 1919.0 | 1953.6 | 120004.0 |
| 2009-04-29 | FDAX | Futures | 5053.5 | 5166.7 | 5040.4 | 5140.6 | 174693.0 |
| 2009-04-29 | FESX | Futures | 1340.5 | 1378.9 | 1335.7 | 1368.7 | 1157618.0 |
| 2009-04-29 | FEU3 | Futures | 97.259 | 97.288 | 97.259 | 97.288 | 603.0 |
| 2009-04-29 | FGBL | Futures | 92.67 | 92.96 | 92.3 | 92.89 | 860346.0 |
| 2009-04-29 | FGBM | Futures | 97.88 | 98.1 | 97.67 | 98.05 | 425196.0 |
| 2009-04-29 | FGBS | Futures | 103.776 | 103.81 | 103.704 | 103.805 | 466289.0 |
| 2009-04-29 | FGBX | Futures | 83.75 | 84.76 | 83.28 | 84.53 | 1650.0 |
| 2009-04-29 | FTDX | Futures | 494.6 | 517.1 | 494.6 | 511.7 | 983.0 |
| 2009-04-29 | FTI | Futures | 193.17 | 196.22 | 192.22 | 195.31 | 31839.0 |
| 2009-04-29 | FTUK | Futures | 2708.0 | 2783.9 | 2696.4 | 2768.3 | 101217.0 |
| 2009-04-29 | G | Futures | 76.52 | 76.92 | 76.51 | 76.79 | 61852.0 |
| 2009-04-29 | GF | Futures | 273.792 | 276.514 | 273.722 | 275.746 | 581.0 |
| 2009-04-29 | GSCI | Futures | 769.8 | 777.24 | 766.4 | 776.82 | 162.0 |
| 2009-04-29 | HE | Futures | 104.629 | 104.629 | 99.513 | 99.76 | 1967.0 |
| 2009-04-29 | HG | Futures | 2.6978 | 2.8553 | 2.6886 | 2.8209 | 13069.0 |
| 2009-04-29 | HO | Futures | 1.447 | 1.5034 | 1.4452 | 1.4701 | 39738.0 |
| 2009-04-29 | HRC | Futures | 2595.1 | 2595.1 | 2595.1 | 2595.1 | 0.0 |
| 2009-04-29 | J1 | Futures | 0.0130778 | 0.0130828 | 0.0128673 | 0.0129139 | 65576.0 |
| 2009-04-29 | J7 | Futures | 0.012829 | 0.012879 | 0.012704 | 0.012739 | 390.0 |
| 2009-04-29 | KC | Futures | 322.25 | 324.47 | 320.17 | 322.8 | 4253.0 |
| 2009-04-29 | KE | Futures | 2791.38 | 2849.88 | 2779.19 | 2832.82 | 7670.0 |
| 2009-04-29 | L | Futures | 96.925 | 96.964 | 96.915 | 96.954 | 23935.0 |
| 2009-04-29 | LBS | Futures | 841.1 | 844.7 | 826.0 | 826.0 | 143.0 |
| 2009-04-29 | LE | Futures | 144.946 | 147.023 | 144.902 | 146.625 | 8433.0 |
> showing 50 of 84 rows — these rows as CSV