PREVIEW / futures_daily / 2009-07-13
file: by_date/futures_daily/2009/2009-07-13.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-07-13 | ES | Futures | 839.27 | 861.34 | 830.4 | 859.18 | 2053821.0 |
| 2009-07-13 | NQ | Futures | 1597.46 | 1629.28 | 1576.06 | 1624.49 | 324779.0 |
| 2009-07-13 | YM | Futures | 7295.6 | 7470.6 | 7234.2 | 7451.7 | 122887.0 |
| 2009-07-13 | CL | Futures | 157.5 | 159.63 | 153.45 | 157.05 | 301907.0 |
| 2009-07-13 | GC | Futures | 1263.0 | 1278.4 | 1256.3 | 1277.2 | 100035.0 |
| 2009-07-13 | ZN | Futures | 93.576112 | 93.773115 | 93.14517 | 93.243671 | 505548.0 |
| 2009-07-13 | A6 | Futures | 0.62337 | 0.62675 | 0.61582 | 0.6249 | 62444.0 |
| 2009-07-13 | AD | Futures | 0.85032 | 0.85862 | 0.84647 | 0.85704 | 53595.0 |
| 2009-07-13 | B | Futures | 57.87 | 58.68 | 56.64 | 57.79 | 120773.0 |
| 2009-07-13 | B6 | Futures | 1.6857 | 1.6915 | 1.6696 | 1.6878 | 82764.0 |
| 2009-07-13 | BFX | Futures | 2227.2 | 2271.1 | 2224.7 | 2262.9 | 631.0 |
| 2009-07-13 | BR | Futures | 0.1949 | 0.1949 | 0.1949 | 0.1949 | 24.0 |
| 2009-07-13 | C | Futures | 1815.0 | 1839.0 | 1810.0 | 1821.0 | 4126.0 |
| 2009-07-13 | CB | Futures | 73.61 | 73.61 | 73.07 | 73.07 | 18.0 |
| 2009-07-13 | CC | Futures | 2342.0 | 2387.0 | 2335.0 | 2369.0 | 4642.0 |
| 2009-07-13 | CT | Futures | 53.43 | 54.08 | 52.82 | 53.92 | 283.0 |
| 2009-07-13 | DC | Futures | 19.97 | 20.1 | 19.69 | 19.83 | 51.0 |
| 2009-07-13 | DX | Futures | 82.292 | 82.599 | 82.062 | 82.19 | 3363.0 |
| 2009-07-13 | E1 | Futures | 1.22093 | 1.22596 | 1.21656 | 1.22292 | 27750.0 |
| 2009-07-13 | E6 | Futures | 1.65541 | 1.6623 | 1.64983 | 1.65885 | 177078.0 |
| 2009-07-13 | E7 | Futures | 1.639 | 1.645 | 1.633 | 1.6418 | 1926.0 |
| 2009-07-13 | ED | Futures | 93.8999 | 93.9188 | 93.8575 | 93.8763 | 186913.0 |
| 2009-07-13 | ER | Futures | 97.032 | 97.051 | 97.027 | 97.037 | 107772.0 |
| 2009-07-13 | EW | Futures | 528.0 | 541.0 | 520.2 | 538.9 | 30462.0 |
| 2009-07-13 | FCE | Futures | 1947.5 | 2009.8 | 1940.0 | 2000.3 | 76953.0 |
| 2009-07-13 | FDAX | Futures | 4996.5 | 5214.3 | 4960.3 | 5163.3 | 170254.0 |
| 2009-07-13 | FESX | Futures | 1351.5 | 1409.3 | 1343.7 | 1392.0 | 1231034.0 |
| 2009-07-13 | FEU3 | Futures | 97.623 | 97.623 | 97.608 | 97.613 | 80.0 |
| 2009-07-13 | FGBL | Futures | 92.98 | 93.09 | 92.78 | 92.95 | 358944.0 |
| 2009-07-13 | FGBM | Futures | 98.57 | 98.7 | 98.49 | 98.61 | 201236.0 |
| 2009-07-13 | FGBS | Futures | 104.239 | 104.292 | 104.215 | 104.258 | 246859.0 |
| 2009-07-13 | FGBX | Futures | 84.76 | 85.16 | 84.71 | 85.04 | 1514.0 |
| 2009-07-13 | FTDX | Futures | 540.7 | 564.8 | 539.8 | 557.7 | 614.0 |
| 2009-07-13 | FTI | Futures | 197.66 | 204.97 | 197.24 | 204.35 | 2972.0 |
| 2009-07-13 | FTUK | Futures | 2711.4 | 2786.7 | 2695.1 | 2759.2 | 97443.0 |
| 2009-07-13 | G | Futures | 75.63 | 76.05 | 75.63 | 75.95 | 62468.0 |
| 2009-07-13 | GF | Futures | 284.037 | 289.205 | 283.899 | 286.104 | 3818.0 |
| 2009-07-13 | GSCI | Futures | 852.45 | 852.45 | 834.69 | 850.36 | 3625.0 |
| 2009-07-13 | HE | Futures | 91.693 | 93.06 | 90.613 | 90.685 | 19351.0 |
| 2009-07-13 | HG | Futures | 3.1101 | 3.1445 | 3.0652 | 3.1214 | 14802.0 |
| 2009-07-13 | HO | Futures | 1.5874 | 1.5953 | 1.5434 | 1.5631 | 21460.0 |
| 2009-07-13 | HRC | Futures | 2409.0 | 2409.0 | 2409.0 | 2409.0 | 0.0 |
| 2009-07-13 | J1 | Futures | 0.0136227 | 0.0137335 | 0.0135396 | 0.0135661 | 76349.0 |
| 2009-07-13 | J7 | Futures | 0.013426 | 0.013538 | 0.013356 | 0.013379 | 39.0 |
| 2009-07-13 | JB | Futures | 116.96 | 117.08 | 116.87 | 117.0 | 1229.0 |
| 2009-07-13 | KC | Futures | 309.6 | 312.31 | 307.7 | 311.77 | 4453.0 |
| 2009-07-13 | KE | Futures | 2626.0 | 2751.91 | 2618.81 | 2738.72 | 9478.0 |
| 2009-07-13 | L | Futures | 97.288 | 97.317 | 97.239 | 97.278 | 32892.0 |
| 2009-07-13 | LBS | Futures | 794.0 | 794.0 | 785.5 | 791.2 | 420.0 |
| 2009-07-13 | LE | Futures | 147.153 | 150.413 | 147.109 | 149.4 | 29506.0 |
> showing 50 of 85 rows — these rows as CSV