PREVIEW / futures_daily / 2009-01-06
file: by_date/futures_daily/2009/2009-01-06.parquet size: 8 KB rows: 87
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-01-06 | ES | Futures | 875.59 | 890.23 | 872.05 | 878.66 | 1912293.0 |
| 2009-01-06 | NQ | Futures | 1412.86 | 1438.85 | 1408.1 | 1420.96 | 264042.0 |
| 2009-01-06 | YM | Futures | 7940.5 | 8056.3 | 7914.7 | 7969.0 | 163446.0 |
| 2009-01-06 | CL | Futures | 192.15 | 200.37 | 188.98 | 192.87 | 331307.0 |
| 2009-01-06 | GC | Futures | 1197.8 | 1214.9 | 1169.5 | 1207.4 | 101200.0 |
| 2009-01-06 | ZN | Futures | 95.132671 | 95.551021 | 94.307925 | 95.132671 | 444146.0 |
| 2009-01-06 | A6 | Futures | 0.5631 | 0.57341 | 0.55446 | 0.57175 | 29492.0 |
| 2009-01-06 | AD | Futures | 0.82501 | 0.83503 | 0.81843 | 0.83248 | 29350.0 |
| 2009-01-06 | B | Futures | 54.02 | 56.71 | 53.06 | 54.97 | 83881.0 |
| 2009-01-06 | B6 | Futures | 1.5248 | 1.5567 | 1.5052 | 1.5502 | 72634.0 |
| 2009-01-06 | BFX | Futures | 2207.7 | 2218.6 | 2190.6 | 2196.7 | 383.0 |
| 2009-01-06 | BR | Futures | 0.16273 | 0.16463 | 0.16273 | 0.16463 | 2.0 |
| 2009-01-06 | BZ | Futures | 55.46 | 56.24 | 55.19 | 55.19 | 75.0 |
| 2009-01-06 | C | Futures | 1790.0 | 1800.0 | 1763.0 | 1779.0 | 7691.0 |
| 2009-01-06 | CB | Futures | 77.994 | 77.994 | 77.664 | 77.664 | 21.0 |
| 2009-01-06 | CC | Futures | 2260.0 | 2327.0 | 2219.0 | 2266.0 | 9425.0 |
| 2009-01-06 | CT | Futures | 47.06 | 49.0 | 47.06 | 48.94 | 7940.0 |
| 2009-01-06 | DC | Futures | 28.77 | 28.82 | 27.91 | 28.04 | 376.0 |
| 2009-01-06 | DX | Futures | 86.812 | 88.118 | 86.584 | 86.812 | 5943.0 |
| 2009-01-06 | E1 | Futures | 1.1977 | 1.20129 | 1.17923 | 1.19146 | 36160.0 |
| 2009-01-06 | E6 | Futures | 1.61046 | 1.61342 | 1.57258 | 1.59732 | 174380.0 |
| 2009-01-06 | E7 | Futures | 1.5907 | 1.5947 | 1.5548 | 1.579 | 2985.0 |
| 2009-01-06 | EBM | Futures | 220.12 | 232.39 | 220.12 | 232.39 | 5700.0 |
| 2009-01-06 | ED | Futures | 93.1708 | 93.1755 | 93.0907 | 93.1519 | 178287.0 |
| 2009-01-06 | ER | Futures | 95.856 | 95.875 | 95.831 | 95.861 | 112530.0 |
| 2009-01-06 | EW | Futures | 537.5 | 551.4 | 535.7 | 542.6 | 28462.0 |
| 2009-01-06 | FCE | Futures | 2081.0 | 2113.9 | 2057.6 | 2091.1 | 96293.0 |
| 2009-01-06 | FDAX | Futures | 5483.1 | 5610.3 | 5435.6 | 5496.7 | 123002.0 |
| 2009-01-06 | FESX | Futures | 1477.7 | 1504.7 | 1463.3 | 1480.0 | 887243.0 |
| 2009-01-06 | FEU3 | Futures | 96.425 | 96.435 | 96.401 | 96.425 | 163.0 |
| 2009-01-06 | FGBL | Futures | 93.03 | 93.12 | 91.9 | 92.2 | 567167.0 |
| 2009-01-06 | FGBM | Futures | 97.52 | 97.67 | 96.83 | 97.16 | 312388.0 |
| 2009-01-06 | FGBS | Futures | 103.167 | 103.263 | 103.009 | 103.114 | 313880.0 |
| 2009-01-06 | FGBX | Futures | 86.82 | 86.82 | 84.19 | 84.7 | 2026.0 |
| 2009-01-06 | FTDX | Futures | 475.2 | 481.5 | 468.0 | 477.0 | 309.0 |
| 2009-01-06 | FTI | Futures | 210.18 | 217.58 | 207.3 | 215.62 | 33908.0 |
| 2009-01-06 | FTUK | Futures | 2999.3 | 3048.2 | 2969.2 | 3018.3 | 134406.0 |
| 2009-01-06 | G | Futures | 76.4 | 76.54 | 75.67 | 75.87 | 71083.0 |
| 2009-01-06 | GF | Futures | 268.083 | 270.917 | 264.835 | 265.733 | 245.0 |
| 2009-01-06 | GSCI | Futures | 911.05 | 915.57 | 890.83 | 896.77 | 292.0 |
| 2009-01-06 | HE | Futures | 121.35 | 124.733 | 121.205 | 123.621 | 9631.0 |
| 2009-01-06 | HG | Futures | 2.0443 | 2.2336 | 2.0408 | 2.228 | 16837.0 |
| 2009-01-06 | HO | Futures | 1.7642 | 1.8675 | 1.761 | 1.8241 | 17836.0 |
| 2009-01-06 | HRC | Futures | 3101.0 | 3101.0 | 3101.0 | 3101.0 | 0.0 |
| 2009-01-06 | J1 | Futures | 0.0135711 | 0.0136191 | 0.0133475 | 0.013446 | 74826.0 |
| 2009-01-06 | J7 | Futures | 0.013423 | 0.013444 | 0.013194 | 0.013284 | 49.0 |
| 2009-01-06 | JB | Futures | 116.92 | 116.92 | 116.17 | 116.23 | 4631.0 |
| 2009-01-06 | KC | Futures | 310.1 | 333.53 | 309.38 | 331.82 | 21427.0 |
| 2009-01-06 | KE | Futures | 3189.02 | 3347.66 | 3174.03 | 3347.66 | 10304.0 |
| 2009-01-06 | L | Futures | 96.709 | 96.743 | 96.709 | 96.723 | 40565.0 |
> showing 50 of 87 rows — these rows as CSV