PREVIEW / futures_daily / 2009-05-14
file: by_date/futures_daily/2009/2009-05-14.parquet size: 8 KB rows: 85
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-14 | ES | Futures | 843.49 | 854.69 | 837.53 | 847.78 | 2200806.0 |
| 2009-05-14 | NQ | Futures | 1510.56 | 1537.81 | 1501.57 | 1520.95 | 306161.0 |
| 2009-05-14 | YM | Futures | 7434.2 | 7488.9 | 7387.6 | 7433.3 | 141541.0 |
| 2009-05-14 | CL | Futures | 156.27 | 159.33 | 153.18 | 158.19 | 136774.0 |
| 2009-05-14 | GC | Futures | 1283.5 | 1286.9 | 1274.5 | 1285.5 | 76204.0 |
| 2009-05-14 | ZN | Futures | 94.475818 | 94.815659 | 94.366583 | 94.512229 | 528079.0 |
| 2009-05-14 | A6 | Futures | 0.59909 | 0.60635 | 0.59423 | 0.60555 | 57052.0 |
| 2009-05-14 | AD | Futures | 0.83855 | 0.84279 | 0.8352 | 0.8418 | 59809.0 |
| 2009-05-14 | B | Futures | 56.02 | 56.75 | 54.64 | 56.43 | 112867.0 |
| 2009-05-14 | B6 | Futures | 1.5755 | 1.5865 | 1.5667 | 1.5846 | 74668.0 |
| 2009-05-14 | BFX | Futures | 2280.7 | 2295.6 | 2239.6 | 2248.8 | 3922.0 |
| 2009-05-14 | BZ | Futures | 59.89 | 61.16 | 59.89 | 61.16 | 17.0 |
| 2009-05-14 | C | Futures | 1725.0 | 1732.0 | 1699.0 | 1718.0 | 7017.0 |
| 2009-05-14 | CB | Futures | 77.038 | 77.038 | 77.038 | 77.038 | 2.0 |
| 2009-05-14 | CC | Futures | 2048.0 | 2052.0 | 1996.0 | 2038.0 | 7340.0 |
| 2009-05-14 | CT | Futures | 54.74 | 54.86 | 53.71 | 54.64 | 8323.0 |
| 2009-05-14 | DC | Futures | 25.54 | 25.75 | 24.84 | 24.94 | 177.0 |
| 2009-05-14 | DX | Futures | 85.377 | 85.485 | 84.77 | 84.821 | 4497.0 |
| 2009-05-14 | E1 | Futures | 1.19798 | 1.20302 | 1.19228 | 1.20209 | 32710.0 |
| 2009-05-14 | E6 | Futures | 1.61085 | 1.61986 | 1.60303 | 1.6182 | 148663.0 |
| 2009-05-14 | E7 | Futures | 1.5923 | 1.601 | 1.5847 | 1.5994 | 2140.0 |
| 2009-05-14 | ED | Futures | 93.5441 | 93.563 | 93.53 | 93.5394 | 221280.0 |
| 2009-05-14 | ER | Futures | 96.802 | 96.811 | 96.792 | 96.811 | 107164.0 |
| 2009-05-14 | EW | Futures | 526.6 | 537.4 | 522.0 | 530.0 | 32888.0 |
| 2009-05-14 | FCE | Futures | 2016.1 | 2037.0 | 1996.0 | 2019.1 | 75447.0 |
| 2009-05-14 | FDAX | Futures | 5149.3 | 5196.7 | 5071.4 | 5162.4 | 180400.0 |
| 2009-05-14 | FESX | Futures | 1394.5 | 1410.1 | 1375.9 | 1397.5 | 1422885.0 |
| 2009-05-14 | FEU3 | Futures | 97.377 | 97.392 | 97.377 | 97.392 | 874.0 |
| 2009-05-14 | FGBL | Futures | 91.59 | 92.03 | 91.44 | 91.85 | 759391.0 |
| 2009-05-14 | FGBM | Futures | 97.69 | 97.94 | 97.61 | 97.82 | 487393.0 |
| 2009-05-14 | FGBS | Futures | 103.877 | 103.968 | 103.839 | 103.92 | 511180.0 |
| 2009-05-14 | FGBX | Futures | 81.28 | 81.52 | 80.9 | 81.28 | 3305.0 |
| 2009-05-14 | FTDX | Futures | 521.6 | 536.9 | 518.9 | 532.4 | 1348.0 |
| 2009-05-14 | FTI | Futures | 204.28 | 206.09 | 202.76 | 203.83 | 27612.0 |
| 2009-05-14 | FTUK | Futures | 2867.2 | 2905.8 | 2844.2 | 2887.1 | 118541.0 |
| 2009-05-14 | G | Futures | 76.39 | 76.83 | 76.39 | 76.67 | 91209.0 |
| 2009-05-14 | GF | Futures | 278.938 | 281.143 | 278.938 | 280.178 | 605.0 |
| 2009-05-14 | GSCI | Futures | 876.99 | 883.71 | 862.49 | 883.18 | 397.0 |
| 2009-05-14 | HE | Futures | 101.575 | 102.249 | 100.227 | 100.377 | 6852.0 |
| 2009-05-14 | HG | Futures | 2.842 | 2.8842 | 2.7674 | 2.8518 | 16808.0 |
| 2009-05-14 | HO | Futures | 1.6218 | 1.6397 | 1.5904 | 1.6307 | 30318.0 |
| 2009-05-14 | HRC | Futures | 2495.0 | 2495.0 | 2495.0 | 2495.0 | 0.0 |
| 2009-05-14 | J1 | Futures | 0.0132265 | 0.0132542 | 0.0131496 | 0.0131723 | 75720.0 |
| 2009-05-14 | J7 | Futures | 0.013047 | 0.013068 | 0.012973 | 0.012993 | 225.0 |
| 2009-05-14 | JB | Futures | 114.45 | 114.78 | 114.45 | 114.67 | 2248.0 |
| 2009-05-14 | KC | Futures | 350.37 | 355.78 | 345.94 | 354.67 | 9356.0 |
| 2009-05-14 | KE | Futures | 3103.42 | 3144.87 | 3069.29 | 3138.77 | 6888.0 |
| 2009-05-14 | L | Futures | 97.072 | 97.101 | 97.062 | 97.082 | 47806.0 |
| 2009-05-14 | LBS | Futures | 829.6 | 835.6 | 803.6 | 810.5 | 283.0 |
| 2009-05-14 | LE | Futures | 146.007 | 146.979 | 145.653 | 146.36 | 5938.0 |
> showing 50 of 85 rows — these rows as CSV