PREVIEW / futures_daily / 2008-01-18
file: by_date/futures_daily/2008/2008-01-18.parquet size: 7 KB rows: 47
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-18 | ES | Futures | 1242.69 | 1261.0 | 1219.52 | 1228.33 | 3219547.0 |
| 2008-01-18 | NQ | Futures | 2085.83 | 2118.1 | 2064.22 | 2076.01 | 644551.0 |
| 2008-01-18 | YM | Futures | 10855.5 | 11000.3 | 10704.5 | 10753.4 | 287144.0 |
| 2008-01-18 | CL | Futures | 383.39 | 389.48 | 382.19 | 385.7 | 194417.0 |
| 2008-01-18 | ZN | Futures | 83.843683 | 83.911027 | 83.495737 | 83.81001 | 937843.0 |
| 2008-01-18 | A6 | Futures | 0.65856 | 0.66421 | 0.6526 | 0.65833 | 66149.0 |
| 2008-01-18 | AD | Futures | 0.9545 | 0.96128 | 0.95273 | 0.95646 | 38068.0 |
| 2008-01-18 | B6 | Futures | 2.0003 | 2.0021 | 1.9794 | 1.9838 | 83221.0 |
| 2008-01-18 | DC | Futures | 41.84 | 42.21 | 41.59 | 42.09 | 266.0 |
| 2008-01-18 | DX | Futures | 82.522 | 82.717 | 82.285 | 82.587 | 1610.0 |
| 2008-01-18 | E1 | Futures | 1.21277 | 1.21597 | 1.20704 | 1.21343 | 49287.0 |
| 2008-01-18 | E6 | Futures | 1.69797 | 1.70435 | 1.69356 | 1.69611 | 153859.0 |
| 2008-01-18 | E7 | Futures | 1.6856 | 1.6914 | 1.6809 | 1.6833 | 1130.0 |
| 2008-01-18 | ED | Futures | 91.2044 | 91.2753 | 91.1666 | 91.228 | 298149.0 |
| 2008-01-18 | ER | Futures | 94.303 | 94.322 | 94.283 | 94.308 | 153875.0 |
| 2008-01-18 | EW | Futures | 756.6 | 767.8 | 744.4 | 751.0 | 41502.0 |
| 2008-01-18 | FDAX | Futures | 8450.9 | 8560.1 | 8312.2 | 8353.5 | 293877.0 |
| 2008-01-18 | FESX | Futures | 2328.1 | 2357.2 | 2278.0 | 2293.4 | 2439715.0 |
| 2008-01-18 | FEU3 | Futures | 94.769 | 94.794 | 94.764 | 94.784 | 586.0 |
| 2008-01-18 | FTDX | Futures | 752.8 | 757.4 | 721.8 | 728.2 | 2665.0 |
| 2008-01-18 | FTUK | Futures | 3813.0 | 3898.1 | 3784.5 | 3816.2 | 209618.0 |
| 2008-01-18 | G | Futures | 70.32 | 70.35 | 69.95 | 70.14 | 109607.0 |
| 2008-01-18 | GF | Futures | 300.445 | 305.773 | 300.149 | 302.813 | 296.0 |
| 2008-01-18 | HE | Futures | 146.547 | 147.894 | 145.844 | 146.254 | 2171.0 |
| 2008-01-18 | HG | Futures | 4.4306 | 4.5621 | 4.4208 | 4.5466 | 7043.0 |
| 2008-01-18 | J1 | Futures | 0.0120877 | 0.0121121 | 0.0119723 | 0.0120416 | 132134.0 |
| 2008-01-18 | J7 | Futures | 0.011891 | 0.011895 | 0.011765 | 0.011829 | 78.0 |
| 2008-01-18 | JB | Futures | 115.01 | 115.37 | 114.91 | 115.0 | 2916.0 |
| 2008-01-18 | KC | Futures | 426.12 | 427.71 | 421.67 | 423.26 | 9157.0 |
| 2008-01-18 | KE | Futures | 5317.13 | 5479.65 | 5238.58 | 5478.3 | 4069.0 |
| 2008-01-18 | L | Futures | 94.183 | 94.223 | 94.173 | 94.203 | 50780.0 |
| 2008-01-18 | LE | Futures | 197.899 | 200.272 | 197.635 | 198.795 | 3031.0 |
| 2008-01-18 | MP | Futures | 0.04288 | 0.04317 | 0.04285 | 0.04298 | 18874.0 |
| 2008-01-18 | N6 | Futures | 0.56995 | 0.5719 | 0.56261 | 0.56426 | 2470.0 |
| 2008-01-18 | PA | Futures | 446.17 | 451.03 | 440.35 | 449.89 | 632.0 |
| 2008-01-18 | PJY | Futures | 164.45 | 164.45 | 164.45 | 164.45 | 0.0 |
| 2008-01-18 | PL | Futures | 1844.6 | 1850.5 | 1826.9 | 1848.7 | 1200.0 |
| 2008-01-18 | PSI | Futures | 9044.9 | 9191.9 | 9044.9 | 9095.2 | 727.0 |
| 2008-01-18 | RP | Futures | 0.84768 | 0.85468 | 0.8462 | 0.85308 | 196.0 |
| 2008-01-18 | RTY | Futures | 692.4 | 701.9 | 675.9 | 683.3 | 373517.0 |
| 2008-01-18 | RY | Futures | 141.55 | 143.17 | 141.27 | 141.97 | 1344.0 |
| 2008-01-18 | SI | Futures | 27.429 | 28.291 | 27.076 | 27.937 | 28011.0 |
| 2008-01-18 | US | Futures | 91.433671 | 91.505048 | 90.910241 | 91.052995 | 304853.0 |
| 2008-01-18 | ZF | Futures | 92.4605033 | 92.588494 | 92.2557181 | 92.5372977 | 512161.0 |
| 2008-01-18 | ZL | Futures | 52.75 | 53.06 | 52.3 | 52.99 | 25687.0 |
| 2008-01-18 | ZT | Futures | 98.65592002 | 98.77186645 | 98.56171354 | 98.74287984 | 255244.0 |
| 2008-01-18 | ZW | Futures | 7179.71 | 7387.79 | 7051.8 | 7349.61 | 39898.0 |
> showing 47 of 47 rows — these rows as CSV