PREVIEW / futures_daily / 2009-12-22
file: by_date/futures_daily/2009/2009-12-22.parquet size: 9 KB rows: 89
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-12-22 | ES | Futures | 1073.79 | 1081.55 | 1073.31 | 1079.37 | 930910.0 |
| 2009-12-22 | NQ | Futures | 2064.73 | 2082.26 | 2064.45 | 2082.26 | 165980.0 |
| 2009-12-22 | YM | Futures | 9447.7 | 9518.0 | 9438.5 | 9507.1 | 63758.0 |
| 2009-12-22 | CL | Futures | 174.14 | 177.65 | 172.45 | 176.44 | 196830.0 |
| 2009-12-22 | GC | Futures | 1504.0 | 1511.6 | 1479.9 | 1495.8 | 182486.0 |
| 2009-12-22 | ZN | Futures | 94.038488 | 94.07627 | 93.585108 | 93.685859 | 582318.0 |
| 2009-12-22 | A6 | Futures | 0.70844 | 0.71169 | 0.70495 | 0.70665 | 44348.0 |
| 2009-12-22 | AD | Futures | 0.92871 | 0.93671 | 0.92822 | 0.93523 | 55808.0 |
| 2009-12-22 | B | Futures | 67.05 | 67.98 | 66.11 | 67.48 | 96803.0 |
| 2009-12-22 | B6 | Futures | 1.6651 | 1.6715 | 1.6527 | 1.6577 | 72694.0 |
| 2009-12-22 | BFX | Futures | 2823.1 | 2825.3 | 2811.8 | 2816.1 | 172.0 |
| 2009-12-22 | BR | Futures | 0.22224 | 0.22345 | 0.22224 | 0.22345 | 35.0 |
| 2009-12-22 | C | Futures | 2259.0 | 2273.0 | 2246.0 | 2271.0 | 3945.0 |
| 2009-12-22 | CB | Futures | 71.643 | 71.643 | 71.063 | 71.557 | 28.0 |
| 2009-12-22 | CC | Futures | 2814.0 | 2833.0 | 2781.0 | 2805.0 | 5316.0 |
| 2009-12-22 | CT | Futures | 61.18 | 61.35 | 59.94 | 60.17 | 13322.0 |
| 2009-12-22 | DC | Futures | 24.82 | 24.91 | 24.44 | 24.59 | 246.0 |
| 2009-12-22 | DX | Futures | 79.723 | 80.105 | 79.545 | 79.942 | 15587.0 |
| 2009-12-22 | E1 | Futures | 1.2615 | 1.26335 | 1.25596 | 1.25873 | 28812.0 |
| 2009-12-22 | E6 | Futures | 1.68936 | 1.69647 | 1.68285 | 1.68723 | 176316.0 |
| 2009-12-22 | E7 | Futures | 1.6771 | 1.6847 | 1.6711 | 1.6755 | 2767.0 |
| 2009-12-22 | EBM | Futures | 222.66 | 223.08 | 221.81 | 222.24 | 2372.0 |
| 2009-12-22 | ED | Futures | 94.311 | 94.3157 | 94.2968 | 94.3063 | 104503.0 |
| 2009-12-22 | ER | Futures | 97.223 | 97.228 | 97.213 | 97.218 | 69966.0 |
| 2009-12-22 | EW | Futures | 700.7 | 709.3 | 700.3 | 707.1 | 16300.0 |
| 2009-12-22 | FBTP | Futures | 62.97 | 63.44 | 62.97 | 63.29 | 2541.0 |
| 2009-12-22 | FCE | Futures | 2531.9 | 2560.6 | 2531.9 | 2547.2 | 70629.0 |
| 2009-12-22 | FDAX | Futures | 6490.2 | 6543.2 | 6482.6 | 6510.4 | 103181.0 |
| 2009-12-22 | FESX | Futures | 1755.0 | 1772.4 | 1752.6 | 1761.6 | 631538.0 |
| 2009-12-22 | FEU3 | Futures | 97.781 | 97.786 | 97.781 | 97.781 | 133.0 |
| 2009-12-22 | FGBL | Futures | 94.58 | 94.62 | 94.24 | 94.35 | 424446.0 |
| 2009-12-22 | FGBM | Futures | 100.3 | 100.32 | 100.13 | 100.19 | 242698.0 |
| 2009-12-22 | FGBS | Futures | 105.464 | 105.464 | 105.406 | 105.445 | 228022.0 |
| 2009-12-22 | FGBX | Futures | 88.01 | 88.46 | 88.01 | 88.08 | 2210.0 |
| 2009-12-22 | FTDX | Futures | 723.4 | 725.2 | 713.3 | 715.5 | 384.0 |
| 2009-12-22 | FTI | Futures | 270.06 | 272.91 | 270.06 | 271.28 | 21962.0 |
| 2009-12-22 | FTUK | Futures | 3523.7 | 3564.2 | 3522.0 | 3543.4 | 64187.0 |
| 2009-12-22 | G | Futures | 75.74 | 75.99 | 75.59 | 75.68 | 48965.0 |
| 2009-12-22 | GF | Futures | 256.662 | 258.086 | 255.78 | 256.119 | 1650.0 |
| 2009-12-22 | GSCI | Futures | 940.33 | 951.42 | 933.13 | 947.92 | 388.0 |
| 2009-12-22 | HE | Futures | 85.573 | 86.777 | 85.171 | 86.643 | 8628.0 |
| 2009-12-22 | HG | Futures | 4.3394 | 4.3552 | 4.2945 | 4.329 | 13307.0 |
| 2009-12-22 | HO | Futures | 1.8468 | 1.8639 | 1.8167 | 1.8478 | 9241.0 |
| 2009-12-22 | HRC | Futures | 2561.7 | 2561.7 | 2561.7 | 2561.7 | 0.0 |
| 2009-12-22 | J1 | Futures | 0.0138088 | 0.0138352 | 0.0137018 | 0.0137169 | 67017.0 |
| 2009-12-22 | J7 | Futures | 0.013645 | 0.013658 | 0.013528 | 0.013545 | 407.0 |
| 2009-12-22 | JB | Futures | 118.44 | 118.46 | 118.21 | 118.22 | 2143.0 |
| 2009-12-22 | KC | Futures | 378.73 | 379.38 | 366.23 | 370.79 | 10898.0 |
| 2009-12-22 | KE | Futures | 2333.57 | 2348.27 | 2307.57 | 2339.23 | 5346.0 |
| 2009-12-22 | L | Futures | 97.76 | 97.789 | 97.75 | 97.769 | 26972.0 |
> showing 50 of 89 rows — these rows as CSV