PREVIEW / futures_daily / 2010-04-05
file: by_date/futures_daily/2010/2010-04-05.parquet size: 8 KB rows: 69
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-05 | ES | Futures | 1147.85 | 1152.72 | 1143.71 | 1151.99 | 1025888.0 |
| 2010-04-05 | NQ | Futures | 2228.03 | 2244.76 | 2218.1 | 2238.8 | 200178.0 |
| 2010-04-05 | YM | Futures | 10018.2 | 10045.8 | 9988.8 | 10028.3 | 65916.0 |
| 2010-04-05 | CL | Futures | 199.6 | 203.32 | 199.02 | 202.67 | 244106.0 |
| 2010-04-05 | GC | Futures | 1539.4 | 1556.3 | 1537.8 | 1555.6 | 75636.0 |
| 2010-04-05 | ZN | Futures | 94.121826 | 94.211101 | 93.726463 | 93.866753 | 641298.0 |
| 2010-04-05 | A6 | Futures | 0.74849 | 0.75087 | 0.74816 | 0.7498 | 29167.0 |
| 2010-04-05 | AD | Futures | 0.97916 | 0.98597 | 0.97827 | 0.9839 | 39016.0 |
| 2010-04-05 | B | Futures | 76.11 | 77.36 | 75.52 | 77.16 | 32682.0 |
| 2010-04-05 | B6 | Futures | 1.5839 | 1.59 | 1.5794 | 1.5872 | 42370.0 |
| 2010-04-05 | CB | Futures | 74.764 | 75.011 | 74.764 | 74.764 | 5.0 |
| 2010-04-05 | CC | Futures | 2531.0 | 2536.0 | 2486.0 | 2508.0 | 3651.0 |
| 2010-04-05 | CT | Futures | 66.44 | 67.27 | 66.32 | 66.91 | 7817.0 |
| 2010-04-05 | DC | Futures | 22.99 | 23.12 | 22.89 | 23.1 | 131.0 |
| 2010-04-05 | DX | Futures | 82.371 | 82.543 | 82.184 | 82.34 | 10926.0 |
| 2010-04-05 | E1 | Futures | 1.24038 | 1.24433 | 1.23722 | 1.23998 | 20927.0 |
| 2010-04-05 | E6 | Futures | 1.59609 | 1.60165 | 1.5923 | 1.59514 | 128059.0 |
| 2010-04-05 | E7 | Futures | 1.5834 | 1.5886 | 1.5793 | 1.5821 | 2369.0 |
| 2010-04-05 | ED | Futures | 94.3897 | 94.3992 | 94.3755 | 94.3802 | 140570.0 |
| 2010-04-05 | EW | Futures | 777.9 | 787.9 | 776.5 | 786.6 | 18095.0 |
| 2010-04-05 | GF | Futures | 289.645 | 294.015 | 288.731 | 293.95 | 781.0 |
| 2010-04-05 | GSCI | Futures | 998.33 | 1009.92 | 997.77 | 1006.61 | 420.0 |
| 2010-04-05 | HE | Futures | 99.349 | 101.576 | 99.349 | 101.423 | 415.0 |
| 2010-04-05 | HG | Futures | 4.8959 | 4.9677 | 4.885 | 4.9615 | 14551.0 |
| 2010-04-05 | HO | Futures | 2.0453 | 2.0869 | 2.0438 | 2.0803 | 19745.0 |
| 2010-04-05 | HRC | Futures | 3221.8 | 3221.8 | 3221.8 | 3221.8 | 0.0 |
| 2010-04-05 | J1 | Futures | 0.0132834 | 0.0133689 | 0.0132834 | 0.013345 | 51813.0 |
| 2010-04-05 | J7 | Futures | 0.013196 | 0.013261 | 0.013185 | 0.013239 | 166.0 |
| 2010-04-05 | JB | Futures | 117.83 | 117.83 | 117.64 | 117.68 | 907.0 |
| 2010-04-05 | KC | Futures | 353.14 | 359.18 | 352.63 | 358.66 | 10936.0 |
| 2010-04-05 | KE | Futures | 2083.8 | 2102.64 | 2060.54 | 2090.45 | 9179.0 |
| 2010-04-05 | LBS | Futures | 910.5 | 934.1 | 904.5 | 930.9 | 1042.0 |
| 2010-04-05 | LE | Futures | 150.191 | 152.238 | 150.191 | 151.234 | 23981.0 |
| 2010-04-05 | MFS | Futures | 1279.3 | 1285.5 | 1276.8 | 1283.6 | 675.0 |
| 2010-04-05 | MME | Futures | 874.2 | 881.5 | 874.2 | 880.8 | 372.0 |
| 2010-04-05 | MP | Futures | 0.04353 | 0.04376 | 0.04353 | 0.04368 | 9528.0 |
| 2010-04-05 | N6 | Futures | 0.56291 | 0.56355 | 0.55947 | 0.56107 | 5106.0 |
| 2010-04-05 | NG | Futures | 136.089 | 143.299 | 132.966 | 142.103 | 108980.0 |
| 2010-04-05 | NIY | Futures | 9080.6 | 9132.8 | 9072.6 | 9124.7 | 4968.0 |
| 2010-04-05 | NKD | Futures | 10644.1 | 10681.5 | 10611.4 | 10672.2 | 2941.0 |
| 2010-04-05 | NOK | Futures | 0.163929 | 0.163929 | 0.163929 | 0.163929 | 1.0 |
| 2010-04-05 | OJ | Futures | 83.9 | 84.62 | 83.63 | 84.06 | 1716.0 |
| 2010-04-05 | PA | Futures | 549.8 | 575.37 | 549.23 | 571.16 | 1913.0 |
| 2010-04-05 | PJY | Futures | 117.25 | 117.25 | 117.25 | 117.25 | 0.0 |
| 2010-04-05 | PL | Futures | 1931.9 | 1972.3 | 1928.4 | 1971.4 | 4157.0 |
| 2010-04-05 | QG | Futures | 140.401 | 148.134 | 137.823 | 147.0 | 2308.0 |
| 2010-04-05 | RB | Futures | 1.0172 | 1.0283 | 1.013 | 1.0221 | 18788.0 |
| 2010-04-05 | RP | Futures | 0.99977 | 1.00146 | 0.99638 | 0.99638 | 145.0 |
| 2010-04-05 | RS | Futures | 377.6 | 384.5 | 377.6 | 382.0 | 6621.0 |
| 2010-04-05 | RTY | Futures | 689.4 | 701.0 | 687.8 | 699.7 | 108643.0 |
> showing 50 of 69 rows — these rows as CSV