PREVIEW / futures_daily / 2008-12-24
file: by_date/futures_daily/2008/2008-12-24.parquet size: 8 KB rows: 73
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-12-24 | ES | Futures | 811.38 | 818.23 | 808.31 | 816.81 | 239099.0 |
| 2008-12-24 | NQ | Futures | 1325.65 | 1329.85 | 1317.83 | 1319.22 | 39768.0 |
| 2008-12-24 | YM | Futures | 7467.7 | 7534.5 | 7445.5 | 7499.8 | 27871.0 |
| 2008-12-24 | CL | Futures | 155.43 | 157.57 | 139.47 | 140.34 | 93376.0 |
| 2008-12-24 | GC | Futures | 1171.8 | 1184.5 | 1164.7 | 1182.3 | 20523.0 |
| 2008-12-24 | ZN | Futures | 97.057079 | 97.415664 | 96.148663 | 96.93755 | 33032.0 |
| 2008-12-24 | A6 | Futures | 0.53463 | 0.53867 | 0.53217 | 0.53748 | 3013.0 |
| 2008-12-24 | AD | Futures | 0.80586 | 0.81362 | 0.80409 | 0.81234 | 3876.0 |
| 2008-12-24 | B | Futures | 45.14 | 45.14 | 40.25 | 40.71 | 49556.0 |
| 2008-12-24 | B6 | Futures | 1.5274 | 1.5357 | 1.5198 | 1.5253 | 8193.0 |
| 2008-12-24 | BZ | Futures | 43.63 | 44.52 | 41.54 | 41.54 | 112.0 |
| 2008-12-24 | C | Futures | 1814.0 | 1814.0 | 1775.0 | 1775.0 | 1730.0 |
| 2008-12-24 | CC | Futures | 2349.0 | 2349.0 | 2262.0 | 2317.0 | 1662.0 |
| 2008-12-24 | CT | Futures | 44.8 | 45.26 | 44.68 | 45.13 | 2681.0 |
| 2008-12-24 | DC | Futures | 32.36 | 32.39 | 31.96 | 32.01 | 56.0 |
| 2008-12-24 | DX | Futures | 85.319 | 85.339 | 84.904 | 85.002 | 706.0 |
| 2008-12-24 | E1 | Futures | 1.22296 | 1.24329 | 1.22283 | 1.23466 | 5014.0 |
| 2008-12-24 | E6 | Futures | 1.64598 | 1.65687 | 1.64491 | 1.65083 | 18669.0 |
| 2008-12-24 | E7 | Futures | 1.627 | 1.6377 | 1.6266 | 1.6319 | 323.0 |
| 2008-12-24 | EBM | Futures | 200.94 | 203.63 | 200.94 | 201.71 | 137.0 |
| 2008-12-24 | ED | Futures | 93.1048 | 93.1048 | 93.0625 | 93.086 | 17873.0 |
| 2008-12-24 | ER | Futures | 95.836 | 95.851 | 95.816 | 95.846 | 11714.0 |
| 2008-12-24 | EW | Futures | 490.9 | 496.6 | 487.6 | 495.1 | 8410.0 |
| 2008-12-24 | FCE | Futures | 1928.5 | 1947.9 | 1906.9 | 1923.6 | 12737.0 |
| 2008-12-24 | FTI | Futures | 193.94 | 194.82 | 192.58 | 193.22 | 3813.0 |
| 2008-12-24 | FTUK | Futures | 2792.5 | 2792.5 | 2738.1 | 2748.5 | 9212.0 |
| 2008-12-24 | G | Futures | 76.86 | 77.35 | 76.68 | 77.07 | 9688.0 |
| 2008-12-24 | GF | Futures | 259.306 | 262.623 | 259.306 | 262.278 | 19.0 |
| 2008-12-24 | HE | Futures | 118.112 | 118.499 | 117.097 | 117.629 | 915.0 |
| 2008-12-24 | HG | Futures | 1.8072 | 1.8522 | 1.7889 | 1.7931 | 2973.0 |
| 2008-12-24 | HO | Futures | 1.4944 | 1.4944 | 1.3806 | 1.3878 | 6578.0 |
| 2008-12-24 | HRC | Futures | 3101.0 | 3101.0 | 3101.0 | 3101.0 | 0.0 |
| 2008-12-24 | J1 | Futures | 0.0139045 | 0.014022 | 0.0139045 | 0.0139475 | 10346.0 |
| 2008-12-24 | J7 | Futures | 0.013747 | 0.013845 | 0.013747 | 0.01378 | 10.0 |
| 2008-12-24 | JB | Futures | 116.98 | 117.06 | 116.89 | 116.98 | 579.0 |
| 2008-12-24 | KC | Futures | 307.24 | 310.24 | 306.81 | 308.81 | 1135.0 |
| 2008-12-24 | KE | Futures | 2957.93 | 3019.14 | 2947.94 | 2997.9 | 1932.0 |
| 2008-12-24 | L | Futures | 96.674 | 96.704 | 96.669 | 96.694 | 7296.0 |
| 2008-12-24 | LBS | Futures | 1051.7 | 1076.4 | 1051.7 | 1076.4 | 3.0 |
| 2008-12-24 | LE | Futures | 155.375 | 158.461 | 155.375 | 158.014 | 805.0 |
| 2008-12-24 | MP | Futures | 0.03648 | 0.03697 | 0.03645 | 0.03668 | 1465.0 |
| 2008-12-24 | N6 | Futures | 0.44369 | 0.45142 | 0.44369 | 0.44819 | 195.0 |
| 2008-12-24 | NG | Futures | 361.462 | 376.549 | 349.735 | 374.648 | 38131.0 |
| 2008-12-24 | NIY | Futures | 6773.9 | 6837.8 | 6750.0 | 6813.8 | 2439.0 |
| 2008-12-24 | NKD | Futures | 8362.7 | 8382.0 | 8280.7 | 8324.1 | 1475.0 |
| 2008-12-24 | NOK | Futures | 0.139081 | 0.139081 | 0.139081 | 0.139081 | 0.0 |
| 2008-12-24 | OJ | Futures | 54.37 | 55.55 | 54.29 | 55.02 | 165.0 |
| 2008-12-24 | PA | Futures | 200.02 | 200.82 | 194.93 | 199.9 | 126.0 |
| 2008-12-24 | PJY | Futures | 109.44 | 109.44 | 109.44 | 109.44 | 0.0 |
| 2008-12-24 | PL | Futures | 983.3 | 1005.8 | 982.7 | 1003.0 | 584.0 |
> showing 50 of 73 rows — these rows as CSV