PREVIEW / futures_daily / 2008-01-23
file: by_date/futures_daily/2008/2008-01-23.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-23 | ES | Futures | 1215.81 | 1246.17 | 1168.77 | 1243.39 | 4119794.0 |
| 2008-01-23 | NQ | Futures | 2031.11 | 2033.91 | 1906.23 | 2028.86 | 888037.0 |
| 2008-01-23 | YM | Futures | 10629.9 | 10925.7 | 10334.1 | 10900.8 | 326465.0 |
| 2008-01-23 | CL | Futures | 382.4 | 383.64 | 371.68 | 373.14 | 261820.0 |
| 2008-01-23 | ZN | Futures | 84.898744 | 85.594635 | 83.854907 | 84.909968 | 2277289.0 |
| 2008-01-23 | A6 | Futures | 0.65162 | 0.6566 | 0.64551 | 0.65109 | 66105.0 |
| 2008-01-23 | AD | Futures | 0.95509 | 0.96 | 0.95106 | 0.95312 | 45217.0 |
| 2008-01-23 | B6 | Futures | 1.9908 | 1.9919 | 1.9734 | 1.9797 | 80047.0 |
| 2008-01-23 | DC | Futures | 41.46 | 42.01 | 40.77 | 40.91 | 269.0 |
| 2008-01-23 | DX | Futures | 82.549 | 82.976 | 82.495 | 82.668 | 2699.0 |
| 2008-01-23 | E1 | Futures | 1.2201 | 1.22703 | 1.21397 | 1.22276 | 58694.0 |
| 2008-01-23 | E6 | Futures | 1.70005 | 1.70029 | 1.68068 | 1.69089 | 229113.0 |
| 2008-01-23 | E7 | Futures | 1.6866 | 1.6871 | 1.6682 | 1.6781 | 1779.0 |
| 2008-01-23 | ED | Futures | 91.7054 | 91.9275 | 91.6676 | 91.7621 | 671086.0 |
| 2008-01-23 | ER | Futures | 94.431 | 94.579 | 94.401 | 94.505 | 317457.0 |
| 2008-01-23 | EW | Futures | 745.4 | 767.8 | 722.7 | 767.2 | 58446.0 |
| 2008-01-23 | FDAX | Futures | 7710.5 | 7849.7 | 7223.7 | 7223.7 | 444086.0 |
| 2008-01-23 | FESX | Futures | 2155.6 | 2192.6 | 2009.9 | 2011.6 | 3556991.0 |
| 2008-01-23 | FEU3 | Futures | 94.942 | 95.036 | 94.927 | 94.992 | 3030.0 |
| 2008-01-23 | FTDX | Futures | 689.0 | 716.3 | 652.5 | 672.5 | 3752.0 |
| 2008-01-23 | FTUK | Futures | 3750.9 | 3783.2 | 3557.3 | 3638.9 | 268114.0 |
| 2008-01-23 | G | Futures | 70.01 | 70.5 | 69.9 | 70.18 | 124657.0 |
| 2008-01-23 | GF | Futures | 303.701 | 305.181 | 300.593 | 304.959 | 109.0 |
| 2008-01-23 | HE | Futures | 147.015 | 148.714 | 144.673 | 144.731 | 3993.0 |
| 2008-01-23 | HG | Futures | 4.4707 | 4.4981 | 4.3083 | 4.3182 | 16846.0 |
| 2008-01-23 | J1 | Futures | 0.0120672 | 0.0122582 | 0.0119839 | 0.0121685 | 200362.0 |
| 2008-01-23 | J7 | Futures | 0.011822 | 0.012031 | 0.011774 | 0.011954 | 176.0 |
| 2008-01-23 | JB | Futures | 115.66 | 115.77 | 115.37 | 115.4 | 2888.0 |
| 2008-01-23 | KC | Futures | 428.03 | 430.26 | 415.95 | 417.54 | 12329.0 |
| 2008-01-23 | KE | Futures | 5336.09 | 5410.58 | 5172.22 | 5172.22 | 8288.0 |
| 2008-01-23 | L | Futures | 94.312 | 94.412 | 94.282 | 94.352 | 131746.0 |
| 2008-01-23 | LE | Futures | 199.006 | 199.533 | 197.319 | 197.477 | 2469.0 |
| 2008-01-23 | MP | Futures | 0.04306 | 0.04318 | 0.04276 | 0.04288 | 23175.0 |
| 2008-01-23 | N6 | Futures | 0.57002 | 0.5716 | 0.56096 | 0.56485 | 2524.0 |
| 2008-01-23 | PA | Futures | 447.25 | 447.25 | 437.84 | 443.17 | 657.0 |
| 2008-01-23 | PJY | Futures | 162.4 | 162.4 | 162.4 | 162.4 | 0.0 |
| 2008-01-23 | PL | Futures | 1830.6 | 1843.9 | 1820.9 | 1841.1 | 1350.0 |
| 2008-01-23 | PSI | Futures | 8824.0 | 8824.0 | 8427.8 | 8427.8 | 544.0 |
| 2008-01-23 | RP | Futures | 0.85194 | 0.85308 | 0.84847 | 0.85217 | 54.0 |
| 2008-01-23 | RTY | Futures | 680.2 | 705.1 | 656.8 | 703.6 | 461519.0 |
| 2008-01-23 | RY | Futures | 141.97 | 142.58 | 138.67 | 140.06 | 3751.0 |
| 2008-01-23 | SI | Futures | 27.8 | 27.998 | 27.162 | 27.515 | 36251.0 |
| 2008-01-23 | US | Futures | 92.385362 | 93.551183 | 90.838865 | 92.456739 | 810381.0 |
| 2008-01-23 | ZF | Futures | 93.5100272 | 94.0731865 | 92.6780875 | 93.4844291 | 1075751.0 |
| 2008-01-23 | ZL | Futures | 51.62 | 52.06 | 49.54 | 49.54 | 116915.0 |
| 2008-01-23 | ZT | Futures | 99.16318565 | 99.43131178 | 98.84433297 | 99.17767896 | 516853.0 |
| 2008-01-23 | ZW | Futures | 7139.62 | 7267.52 | 6902.9 | 6910.54 | 118665.0 |
> showing 47 of 47 rows — these rows as CSV