PREVIEW / futures_daily / 2010-05-27
file: by_date/futures_daily/2010/2010-05-27.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-05-27 | ES | Futures | 1032.21 | 1074.09 | 1027.83 | 1072.14 | 2613372.0 |
| 2010-05-27 | NQ | Futures | 2028.65 | 2115.15 | 2021.28 | 2114.3 | 326868.0 |
| 2010-05-27 | YM | Futures | 9115.5 | 9424.3 | 9034.6 | 9408.7 | 156254.0 |
| 2010-05-27 | CL | Futures | 154.79 | 164.0 | 154.64 | 163.13 | 401812.0 |
| 2010-05-27 | GC | Futures | 1655.3 | 1665.0 | 1647.0 | 1656.5 | 138265.0 |
| 2010-05-27 | ZN | Futures | 99.082989 | 99.108497 | 98.062699 | 98.202989 | 1987347.0 |
| 2010-05-27 | A6 | Futures | 0.67365 | 0.6986 | 0.67316 | 0.69474 | 146026.0 |
| 2010-05-27 | AD | Futures | 0.9223 | 0.94194 | 0.92171 | 0.93977 | 100576.0 |
| 2010-05-27 | B | Futures | 63.22 | 66.41 | 63.08 | 66.19 | 70099.0 |
| 2010-05-27 | B6 | Futures | 1.4922 | 1.5167 | 1.4922 | 1.5144 | 138585.0 |
| 2010-05-27 | BFX | Futures | 2768.2 | 2806.7 | 2748.9 | 2806.7 | 74.0 |
| 2010-05-27 | BR | Futures | 0.22453 | 0.22453 | 0.22453 | 0.22453 | 307.0 |
| 2010-05-27 | BZ | Futures | 71.46 | 71.49 | 71.38 | 71.38 | 16.0 |
| 2010-05-27 | C | Futures | 2420.0 | 2435.0 | 2402.0 | 2418.0 | 6108.0 |
| 2010-05-27 | CB | Futures | 77.741 | 78.224 | 77.741 | 78.224 | 19.0 |
| 2010-05-27 | CC | Futures | 2453.0 | 2535.0 | 2435.0 | 2497.0 | 8326.0 |
| 2010-05-27 | CT | Futures | 65.05 | 65.46 | 64.54 | 64.6 | 9478.0 |
| 2010-05-27 | DC | Futures | 22.42 | 22.91 | 22.36 | 22.8 | 105.0 |
| 2010-05-27 | DX | Futures | 88.537 | 88.542 | 87.357 | 87.435 | 30115.0 |
| 2010-05-27 | E1 | Futures | 1.13469 | 1.14667 | 1.12969 | 1.14482 | 58182.0 |
| 2010-05-27 | E6 | Futures | 1.43922 | 1.46655 | 1.43792 | 1.46442 | 479857.0 |
| 2010-05-27 | E7 | Futures | 1.4274 | 1.4545 | 1.4263 | 1.4524 | 9668.0 |
| 2010-05-27 | ED | Futures | 94.0936 | 94.1836 | 94.0936 | 94.1789 | 274486.0 |
| 2010-05-27 | ER | Futures | 97.345 | 97.36 | 97.345 | 97.35 | 101459.0 |
| 2010-05-27 | EW | Futures | 717.9 | 751.5 | 712.5 | 748.6 | 33322.0 |
| 2010-05-27 | FBTP | Futures | 64.42 | 64.44 | 64.05 | 64.18 | 4777.0 |
| 2010-05-27 | FCE | Futures | 2235.0 | 2343.4 | 2235.0 | 2327.5 | 158989.0 |
| 2010-05-27 | FDAX | Futures | 6257.1 | 6498.0 | 6256.5 | 6470.2 | 211678.0 |
| 2010-05-27 | FESX | Futures | 1539.6 | 1613.1 | 1539.6 | 1602.0 | 1940679.0 |
| 2010-05-27 | FEU3 | Futures | 97.904 | 97.919 | 97.904 | 97.909 | 111.0 |
| 2010-05-27 | FGBL | Futures | 100.38 | 100.49 | 99.98 | 100.15 | 1006601.0 |
| 2010-05-27 | FGBM | Futures | 104.98 | 105.1 | 104.7 | 104.79 | 591807.0 |
| 2010-05-27 | FGBS | Futures | 107.52 | 107.579 | 107.471 | 107.506 | 495954.0 |
| 2010-05-27 | FGBX | Futures | 98.98 | 99.09 | 98.17 | 98.42 | 3778.0 |
| 2010-05-27 | FTDX | Futures | 636.8 | 655.8 | 635.9 | 653.6 | 1323.0 |
| 2010-05-27 | FTI | Futures | 244.68 | 254.32 | 244.68 | 252.67 | 44463.0 |
| 2010-05-27 | FTUK | Futures | 3427.9 | 3532.5 | 3422.9 | 3505.1 | 147345.0 |
| 2010-05-27 | G | Futures | 79.5 | 79.64 | 79.2 | 79.32 | 114752.0 |
| 2010-05-27 | GF | Futures | 272.698 | 274.908 | 271.561 | 274.087 | 2074.0 |
| 2010-05-27 | GSCI | Futures | 843.17 | 858.12 | 841.77 | 855.69 | 427.0 |
| 2010-05-27 | HE | Futures | 102.194 | 102.76 | 101.692 | 102.037 | 6205.0 |
| 2010-05-27 | HG | Futures | 4.1438 | 4.3196 | 4.1349 | 4.2891 | 26106.0 |
| 2010-05-27 | HO | Futures | 1.7514 | 1.801 | 1.7514 | 1.7969 | 11354.0 |
| 2010-05-27 | J1 | Futures | 0.0139749 | 0.01399 | 0.0138002 | 0.0138442 | 140891.0 |
| 2010-05-27 | J7 | Futures | 0.013868 | 0.013868 | 0.013695 | 0.013734 | 291.0 |
| 2010-05-27 | JB | Futures | 119.48 | 119.68 | 119.29 | 119.42 | 1796.0 |
| 2010-05-27 | KC | Futures | 340.2 | 343.12 | 339.06 | 342.1 | 11173.0 |
| 2010-05-27 | KE | Futures | 2120.47 | 2178.08 | 2109.6 | 2142.21 | 7947.0 |
| 2010-05-27 | L | Futures | 97.918 | 97.967 | 97.908 | 97.947 | 74909.0 |
| 2010-05-27 | LBS | Futures | 696.4 | 725.8 | 684.6 | 709.1 | 755.0 |
> showing 50 of 89 rows — these rows as CSV