PREVIEW / futures_daily / 2009-03-06
file: by_date/futures_daily/2009/2009-03-06.parquet size: 8 KB rows: 84
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-03-06 | ES | Futures | 648.02 | 660.29 | 628.66 | 649.43 | 3329849.0 |
| 2009-03-06 | NQ | Futures | 1211.9 | 1218.05 | 1166.06 | 1203.51 | 455925.0 |
| 2009-03-06 | YM | Futures | 5900.6 | 6006.6 | 5751.9 | 5942.5 | 270589.0 |
| 2009-03-06 | CL | Futures | 122.77 | 130.35 | 122.32 | 128.15 | 258063.0 |
| 2009-03-06 | GC | Futures | 1296.4 | 1312.1 | 1291.4 | 1308.2 | 87163.0 |
| 2009-03-06 | ZN | Futures | 94.379642 | 94.905567 | 94.11668 | 94.439406 | 41438.0 |
| 2009-03-06 | A6 | Futures | 0.50528 | 0.51306 | 0.50489 | 0.50624 | 48033.0 |
| 2009-03-06 | AD | Futures | 0.76224 | 0.76971 | 0.76145 | 0.76214 | 42489.0 |
| 2009-03-06 | B | Futures | 44.44 | 45.3 | 43.22 | 44.97 | 106034.0 |
| 2009-03-06 | B6 | Futures | 1.4672 | 1.4868 | 1.4589 | 1.4643 | 80918.0 |
| 2009-03-06 | BFX | Futures | 1724.1 | 1736.9 | 1665.8 | 1671.3 | 394.0 |
| 2009-03-06 | BZ | Futures | 45.48 | 47.11 | 45.36 | 46.91 | 13.0 |
| 2009-03-06 | C | Futures | 1792.0 | 1810.0 | 1771.0 | 1810.0 | 2728.0 |
| 2009-03-06 | CC | Futures | 1979.0 | 2013.0 | 1970.0 | 1999.0 | 5277.0 |
| 2009-03-06 | CT | Futures | 39.24 | 40.21 | 39.02 | 39.08 | 5338.0 |
| 2009-03-06 | DC | Futures | 27.67 | 28.15 | 27.43 | 28.08 | 130.0 |
| 2009-03-06 | DX | Futures | 92.416 | 92.416 | 91.157 | 91.82 | 12242.0 |
| 2009-03-06 | E1 | Futures | 1.1359 | 1.1577 | 1.13497 | 1.14932 | 46273.0 |
| 2009-03-06 | E6 | Futures | 1.48485 | 1.51007 | 1.48414 | 1.49894 | 222352.0 |
| 2009-03-06 | E7 | Futures | 1.4679 | 1.4928 | 1.4674 | 1.4818 | 1728.0 |
| 2009-03-06 | EBM | Futures | 209.76 | 214.4 | 208.98 | 212.85 | 2593.0 |
| 2009-03-06 | ED | Futures | 92.9377 | 92.9447 | 92.827 | 92.907 | 228431.0 |
| 2009-03-06 | ER | Futures | 96.449 | 96.469 | 96.429 | 96.439 | 125883.0 |
| 2009-03-06 | EW | Futures | 404.8 | 408.5 | 388.3 | 403.1 | 39963.0 |
| 2009-03-06 | FCE | Futures | 1603.4 | 1620.6 | 1555.7 | 1581.3 | 178121.0 |
| 2009-03-06 | FDAX | Futures | 4054.4 | 4118.3 | 3953.5 | 3991.7 | 214305.0 |
| 2009-03-06 | FESX | Futures | 1065.2 | 1073.2 | 1025.0 | 1038.7 | 1991569.0 |
| 2009-03-06 | FEU3 | Futures | 97.017 | 97.027 | 97.007 | 97.012 | 1286.0 |
| 2009-03-06 | FGBL | Futures | 93.9 | 94.67 | 93.9 | 94.62 | 758851.0 |
| 2009-03-06 | FGBM | Futures | 98.61 | 98.98 | 98.6 | 98.9 | 345602.0 |
| 2009-03-06 | FGBS | Futures | 104.035 | 104.131 | 103.978 | 104.055 | 326592.0 |
| 2009-03-06 | FGBX | Futures | 85.74 | 86.46 | 85.27 | 86.32 | 1719.0 |
| 2009-03-06 | FTDX | Futures | 377.7 | 379.4 | 355.3 | 360.7 | 586.0 |
| 2009-03-06 | FTI | Futures | 163.51 | 166.45 | 161.44 | 162.29 | 37142.0 |
| 2009-03-06 | FTUK | Futures | 2303.3 | 2347.3 | 2266.3 | 2303.3 | 143919.0 |
| 2009-03-06 | G | Futures | 78.07 | 79.12 | 78.04 | 79.0 | 143705.0 |
| 2009-03-06 | GF | Futures | 258.522 | 259.434 | 253.052 | 253.893 | 194.0 |
| 2009-03-06 | GSCI | Futures | 718.57 | 732.14 | 716.17 | 730.6 | 116.0 |
| 2009-03-06 | HE | Futures | 119.513 | 121.543 | 118.16 | 120.818 | 10775.0 |
| 2009-03-06 | HG | Futures | 2.3133 | 2.4211 | 2.3049 | 2.3795 | 8725.0 |
| 2009-03-06 | HO | Futures | 1.3323 | 1.3875 | 1.3094 | 1.3822 | 9649.0 |
| 2009-03-06 | HRC | Futures | 2959.0 | 2959.0 | 2959.0 | 2959.0 | 0.0 |
| 2009-03-06 | J1 | Futures | 0.0128814 | 0.0130797 | 0.0128233 | 0.0129003 | 108045.0 |
| 2009-03-06 | J7 | Futures | 0.012723 | 0.012917 | 0.012675 | 0.012745 | 244.0 |
| 2009-03-06 | JB | Futures | 116.13 | 116.39 | 115.98 | 116.07 | 1203.0 |
| 2009-03-06 | KC | Futures | 305.21 | 307.18 | 301.41 | 301.55 | 5769.0 |
| 2009-03-06 | KE | Futures | 2750.96 | 2854.49 | 2744.8 | 2829.84 | 5316.0 |
| 2009-03-06 | L | Futures | 96.472 | 96.512 | 96.404 | 96.482 | 63625.0 |
| 2009-03-06 | LBS | Futures | 848.1 | 858.8 | 835.8 | 847.0 | 106.0 |
| 2009-03-06 | LE | Futures | 143.71 | 144.911 | 140.923 | 141.437 | 11103.0 |
> showing 50 of 84 rows — these rows as CSV