PREVIEW / futures_daily / 2009-11-12
file: by_date/futures_daily/2009/2009-11-12.parquet size: 9 KB rows: 88
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-11-12 | ES | Futures | 1057.13 | 1061.95 | 1044.11 | 1048.69 | 2020189.0 |
| 2009-11-12 | NQ | Futures | 2013.85 | 2024.58 | 1996.36 | 2002.28 | 279329.0 |
| 2009-11-12 | YM | Futures | 9312.9 | 9341.0 | 9203.0 | 9250.2 | 144443.0 |
| 2009-11-12 | CL | Futures | 194.19 | 195.27 | 187.5 | 188.53 | 412833.0 |
| 2009-11-12 | GC | Futures | 1544.5 | 1553.0 | 1524.4 | 1529.8 | 168528.0 |
| 2009-11-12 | ZN | Futures | 94.737586 | 94.911942 | 94.25188 | 94.787402 | 969804.0 |
| 2009-11-12 | A6 | Futures | 0.74954 | 0.75512 | 0.74211 | 0.74332 | 116750.0 |
| 2009-11-12 | AD | Futures | 0.9441 | 0.94647 | 0.93227 | 0.93473 | 76439.0 |
| 2009-11-12 | B | Futures | 73.37 | 73.42 | 70.9 | 71.32 | 178143.0 |
| 2009-11-12 | B6 | Futures | 1.7247 | 1.7297 | 1.7181 | 1.7238 | 127371.0 |
| 2009-11-12 | BR | Futures | 0.22925 | 0.22925 | 0.22925 | 0.22925 | 11.0 |
| 2009-11-12 | BZ | Futures | 76.55 | 76.55 | 75.7 | 75.93 | 5.0 |
| 2009-11-12 | C | Futures | 2166.0 | 2171.0 | 2120.0 | 2123.0 | 3479.0 |
| 2009-11-12 | CB | Futures | 81.224 | 81.224 | 80.821 | 80.821 | 3.0 |
| 2009-11-12 | CC | Futures | 2735.0 | 2754.0 | 2687.0 | 2692.0 | 10493.0 |
| 2009-11-12 | CT | Futures | 58.1 | 58.68 | 56.85 | 57.32 | 23288.0 |
| 2009-11-12 | DC | Futures | 24.83 | 25.04 | 24.42 | 24.46 | 374.0 |
| 2009-11-12 | DX | Futures | 76.643 | 77.47 | 76.602 | 77.281 | 16769.0 |
| 2009-11-12 | E1 | Futures | 1.31086 | 1.31337 | 1.29594 | 1.30029 | 65334.0 |
| 2009-11-12 | E6 | Futures | 1.77558 | 1.77961 | 1.75638 | 1.76148 | 315833.0 |
| 2009-11-12 | E7 | Futures | 1.759 | 1.7623 | 1.7397 | 1.7446 | 4517.0 |
| 2009-11-12 | ED | Futures | 94.2663 | 94.2663 | 94.2569 | 94.2663 | 95919.0 |
| 2009-11-12 | ER | Futures | 97.174 | 97.188 | 97.169 | 97.179 | 80881.0 |
| 2009-11-12 | EW | Futures | 679.9 | 683.3 | 668.4 | 671.6 | 36389.0 |
| 2009-11-12 | FBTP | Futures | 63.04 | 63.1 | 62.8 | 62.9 | 2747.0 |
| 2009-11-12 | FCE | Futures | 2511.1 | 2537.0 | 2501.8 | 2513.1 | 68837.0 |
| 2009-11-12 | FDAX | Futures | 6152.1 | 6234.8 | 6131.4 | 6172.2 | 161692.0 |
| 2009-11-12 | FESX | Futures | 1710.1 | 1731.6 | 1703.5 | 1714.3 | 1178725.0 |
| 2009-11-12 | FEU3 | Futures | 97.751 | 97.756 | 97.751 | 97.751 | 368.0 |
| 2009-11-12 | FGBL | Futures | 93.78 | 93.98 | 93.4 | 93.68 | 811157.0 |
| 2009-11-12 | FGBM | Futures | 99.38 | 99.49 | 99.19 | 99.36 | 442023.0 |
| 2009-11-12 | FGBS | Futures | 104.915 | 104.958 | 104.871 | 104.939 | 417618.0 |
| 2009-11-12 | FGBX | Futures | 86.89 | 87.23 | 86.07 | 86.55 | 2184.0 |
| 2009-11-12 | FTDX | Futures | 671.4 | 684.3 | 671.4 | 677.6 | 327.0 |
| 2009-11-12 | FTI | Futures | 258.73 | 260.57 | 257.1 | 258.16 | 1890.0 |
| 2009-11-12 | FTUK | Futures | 3483.5 | 3511.4 | 3471.6 | 3489.2 | 99325.0 |
| 2009-11-12 | G | Futures | 76.37 | 76.52 | 76.01 | 76.2 | 104495.0 |
| 2009-11-12 | GF | Futures | 253.203 | 253.61 | 250.626 | 250.898 | 2587.0 |
| 2009-11-12 | GSCI | Futures | 987.77 | 987.96 | 971.92 | 976.36 | 4099.0 |
| 2009-11-12 | HE | Futures | 84.643 | 84.757 | 82.775 | 83.004 | 21443.0 |
| 2009-11-12 | HG | Futures | 4.1555 | 4.182 | 4.083 | 4.1074 | 35057.0 |
| 2009-11-12 | HO | Futures | 1.9961 | 1.9961 | 1.9161 | 1.9287 | 48196.0 |
| 2009-11-12 | HRC | Futures | 2637.0 | 2637.0 | 2637.0 | 2637.0 | 0.0 |
| 2009-11-12 | J1 | Futures | 0.0139719 | 0.0140096 | 0.0138576 | 0.0139041 | 121662.0 |
| 2009-11-12 | J7 | Futures | 0.013792 | 0.013822 | 0.013679 | 0.013723 | 37.0 |
| 2009-11-12 | JB | Futures | 116.22 | 117.03 | 116.22 | 117.0 | 4390.0 |
| 2009-11-12 | KC | Futures | 350.29 | 350.68 | 343.16 | 344.88 | 17085.0 |
| 2009-11-12 | KE | Futures | 2469.6 | 2538.23 | 2447.5 | 2489.38 | 14401.0 |
| 2009-11-12 | L | Futures | 97.75 | 97.76 | 97.73 | 97.74 | 34410.0 |
| 2009-11-12 | LBS | Futures | 748.1 | 778.7 | 748.1 | 769.5 | 354.0 |
> showing 50 of 88 rows — these rows as CSV