PREVIEW / futures_daily / 2009-05-29
file: by_date/futures_daily/2009/2009-05-29.parquet size: 8 KB rows: 86
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-05-29 | ES | Futures | 862.55 | 884.23 | 859.93 | 874.94 | 2009771.0 |
| 2009-05-29 | NQ | Futures | 1592.86 | 1620.95 | 1585.27 | 1612.8 | 271583.0 |
| 2009-05-29 | YM | Futures | 7518.5 | 7674.6 | 7491.6 | 7613.6 | 146422.0 |
| 2009-05-29 | CL | Futures | 172.43 | 177.41 | 172.19 | 176.53 | 261370.0 |
| 2009-05-29 | GC | Futures | 1330.2 | 1359.5 | 1329.6 | 1357.2 | 102467.0 |
| 2009-05-29 | ZN | Futures | 91.45366 | 92.242577 | 91.3687 | 92.145479 | 319268.0 |
| 2009-05-29 | A6 | Futures | 0.62453 | 0.63881 | 0.62381 | 0.63649 | 53958.0 |
| 2009-05-29 | AD | Futures | 0.88364 | 0.90422 | 0.88256 | 0.90019 | 74099.0 |
| 2009-05-29 | B | Futures | 61.99 | 63.51 | 61.87 | 63.31 | 47706.0 |
| 2009-05-29 | B6 | Futures | 1.6578 | 1.6858 | 1.6564 | 1.6791 | 104007.0 |
| 2009-05-29 | BFX | Futures | 2369.6 | 2376.4 | 2330.8 | 2330.8 | 121.0 |
| 2009-05-29 | BR | Futures | 0.19442 | 0.19442 | 0.19223 | 0.19223 | 9.0 |
| 2009-05-29 | BZ | Futures | 68.67 | 69.08 | 68.67 | 69.08 | 5.0 |
| 2009-05-29 | C | Futures | 1842.0 | 1871.0 | 1829.0 | 1829.0 | 24687.0 |
| 2009-05-29 | CB | Futures | 76.452 | 76.452 | 76.168 | 76.452 | 18.0 |
| 2009-05-29 | CC | Futures | 2282.0 | 2334.0 | 2272.0 | 2283.0 | 9865.0 |
| 2009-05-29 | CT | Futures | 50.5 | 52.95 | 50.17 | 52.71 | 8727.0 |
| 2009-05-29 | DC | Futures | 24.51 | 25.04 | 24.49 | 24.51 | 95.0 |
| 2009-05-29 | DX | Futures | 82.895 | 82.901 | 81.613 | 81.794 | 8627.0 |
| 2009-05-29 | E1 | Futures | 1.22251 | 1.24439 | 1.22092 | 1.24174 | 48666.0 |
| 2009-05-29 | E6 | Futures | 1.65175 | 1.67961 | 1.65045 | 1.67523 | 250610.0 |
| 2009-05-29 | E7 | Futures | 1.6332 | 1.6599 | 1.6313 | 1.6558 | 3518.0 |
| 2009-05-29 | ED | Futures | 93.629 | 93.6525 | 93.6266 | 93.6478 | 150285.0 |
| 2009-05-29 | ER | Futures | 96.753 | 96.777 | 96.743 | 96.762 | 85137.0 |
| 2009-05-29 | EW | Futures | 544.0 | 559.3 | 544.0 | 555.8 | 31309.0 |
| 2009-05-29 | FCE | Futures | 2135.6 | 2151.2 | 2115.4 | 2125.5 | 113817.0 |
| 2009-05-29 | FDAX | Futures | 5418.3 | 5458.6 | 5356.2 | 5375.9 | 120577.0 |
| 2009-05-29 | FESX | Futures | 1484.5 | 1495.3 | 1461.1 | 1466.5 | 1108579.0 |
| 2009-05-29 | FEU3 | Futures | 97.342 | 97.352 | 97.337 | 97.342 | 380.0 |
| 2009-05-29 | FGBL | Futures | 90.0 | 90.45 | 89.93 | 90.21 | 699881.0 |
| 2009-05-29 | FGBM | Futures | 96.71 | 97.13 | 96.71 | 96.97 | 427914.0 |
| 2009-05-29 | FGBS | Futures | 103.709 | 103.891 | 103.709 | 103.843 | 467212.0 |
| 2009-05-29 | FGBX | Futures | 79.03 | 79.83 | 79.03 | 79.66 | 3515.0 |
| 2009-05-29 | FTDX | Futures | 573.8 | 575.6 | 562.1 | 567.5 | 418.0 |
| 2009-05-29 | FTI | Futures | 216.97 | 218.53 | 212.89 | 213.92 | 29720.0 |
| 2009-05-29 | FTUK | Futures | 2936.4 | 2966.4 | 2917.4 | 2923.4 | 116967.0 |
| 2009-05-29 | G | Futures | 75.02 | 75.4 | 74.99 | 75.23 | 76571.0 |
| 2009-05-29 | GF | Futures | 280.867 | 281.143 | 279.076 | 280.454 | 1173.0 |
| 2009-05-29 | GSCI | Futures | 946.11 | 948.88 | 934.27 | 945.36 | 413.0 |
| 2009-05-29 | HE | Futures | 97.792 | 97.942 | 95.133 | 95.77 | 7600.0 |
| 2009-05-29 | HG | Futures | 2.9988 | 3.1022 | 2.9967 | 3.0917 | 19182.0 |
| 2009-05-29 | HO | Futures | 1.7635 | 1.7779 | 1.7527 | 1.7743 | 7401.0 |
| 2009-05-29 | HRC | Futures | 2495.0 | 2495.0 | 2495.0 | 2495.0 | 0.0 |
| 2009-05-29 | J1 | Futures | 0.0130034 | 0.0132681 | 0.0130021 | 0.0132466 | 91146.0 |
| 2009-05-29 | J7 | Futures | 0.012878 | 0.013077 | 0.012829 | 0.013067 | 48.0 |
| 2009-05-29 | JB | Futures | 114.23 | 114.33 | 114.14 | 114.28 | 1771.0 |
| 2009-05-29 | KC | Futures | 378.22 | 384.73 | 376.28 | 380.71 | 10030.0 |
| 2009-05-29 | KE | Futures | 3316.74 | 3387.44 | 3291.14 | 3349.65 | 8080.0 |
| 2009-05-29 | L | Futures | 97.131 | 97.17 | 97.111 | 97.141 | 39708.0 |
| 2009-05-29 | LBS | Futures | 878.9 | 918.2 | 873.0 | 874.8 | 672.0 |
> showing 50 of 86 rows — these rows as CSV