PREVIEW / futures_daily / 2009-07-03
file: by_date/futures_daily/2009/2009-07-03.parquet size: 8 KB rows: 64
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-03 | ES | Futures | 857.02 | 861.34 | 852.94 | 857.02 | 1850449.0 |
| 2009-07-03 | NQ | Futures | 1627.3 | 1633.22 | 1619.98 | 1627.59 | 263370.0 |
| 2009-07-03 | YM | Futures | 7436.3 | 7461.6 | 7403.0 | 7435.4 | 134523.0 |
| 2009-07-03 | CL | Futures | 174.95 | 176.73 | 172.08 | 175.58 | 230109.0 |
| 2009-07-03 | GC | Futures | 1285.9 | 1293.5 | 1284.5 | 1288.9 | 96250.0 |
| 2009-07-03 | ZN | Futures | 92.12322 | 92.172471 | 91.963156 | 92.07397 | 687226.0 |
| 2009-07-03 | A6 | Futures | 0.63278 | 0.64017 | 0.63253 | 0.63583 | 76306.0 |
| 2009-07-03 | AD | Futures | 0.84894 | 0.85467 | 0.84854 | 0.85082 | 54816.0 |
| 2009-07-03 | B | Futures | 63.5 | 64.42 | 62.59 | 62.93 | 28441.0 |
| 2009-07-03 | B6 | Futures | 1.7024 | 1.7112 | 1.6977 | 1.7102 | 107146.0 |
| 2009-07-03 | BFX | Futures | 2325.1 | 2325.1 | 2301.8 | 2312.5 | 99.0 |
| 2009-07-03 | BR | Futures | 0.19732 | 0.19732 | 0.19732 | 0.19732 | 17.0 |
| 2009-07-03 | C | Futures | 1695.0 | 1702.0 | 1688.0 | 1693.0 | 756.0 |
| 2009-07-03 | DX | Futures | 82.436 | 82.574 | 82.308 | 82.564 | 733.0 |
| 2009-07-03 | E1 | Futures | 1.21802 | 1.22424 | 1.21617 | 1.22424 | 34412.0 |
| 2009-07-03 | E6 | Futures | 1.65707 | 1.66515 | 1.65482 | 1.66491 | 228046.0 |
| 2009-07-03 | E7 | Futures | 1.6402 | 1.6478 | 1.6385 | 1.6478 | 2858.0 |
| 2009-07-03 | ED | Futures | 93.848 | 93.8716 | 93.848 | 93.848 | 189384.0 |
| 2009-07-03 | ER | Futures | 96.988 | 97.002 | 96.973 | 96.978 | 122283.0 |
| 2009-07-03 | EW | Futures | 547.7 | 549.0 | 543.5 | 546.7 | 23835.0 |
| 2009-07-03 | FCE | Futures | 2035.6 | 2044.4 | 2016.7 | 2035.3 | 57677.0 |
| 2009-07-03 | FDAX | Futures | 5194.6 | 5213.2 | 5140.8 | 5152.3 | 72451.0 |
| 2009-07-03 | FESX | Futures | 1413.5 | 1420.1 | 1401.0 | 1409.3 | 401515.0 |
| 2009-07-03 | FEU3 | Futures | 97.559 | 97.559 | 97.554 | 97.554 | 40.0 |
| 2009-07-03 | FGBL | Futures | 92.46 | 92.47 | 92.3 | 92.4 | 206608.0 |
| 2009-07-03 | FGBM | Futures | 98.39 | 98.39 | 98.24 | 98.28 | 161761.0 |
| 2009-07-03 | FGBS | Futures | 104.234 | 104.244 | 104.157 | 104.186 | 201948.0 |
| 2009-07-03 | FGBX | Futures | 83.69 | 84.13 | 83.59 | 83.96 | 1777.0 |
| 2009-07-03 | FTDX | Futures | 557.7 | 557.7 | 547.0 | 549.6 | 791.0 |
| 2009-07-03 | FTI | Futures | 205.41 | 206.84 | 203.91 | 205.94 | 17571.0 |
| 2009-07-03 | FTUK | Futures | 2795.0 | 2809.6 | 2778.1 | 2785.4 | 55334.0 |
| 2009-07-03 | G | Futures | 75.41 | 75.69 | 75.27 | 75.49 | 33980.0 |
| 2009-07-03 | HG | Futures | 3.2246 | 3.2449 | 3.1691 | 3.2372 | 3598.0 |
| 2009-07-03 | HO | Futures | 1.77 | 1.7763 | 1.735 | 1.77 | 11615.0 |
| 2009-07-03 | HRC | Futures | 2280.5 | 2280.5 | 2280.5 | 2280.5 | 0.0 |
| 2009-07-03 | J1 | Futures | 0.0131355 | 0.0131632 | 0.0131053 | 0.0131519 | 89909.0 |
| 2009-07-03 | J7 | Futures | 0.012971 | 0.012971 | 0.012971 | 0.012971 | 43.0 |
| 2009-07-03 | JB | Futures | 116.36 | 116.67 | 116.33 | 116.59 | 2111.0 |
| 2009-07-03 | L | Futures | 97.209 | 97.219 | 97.18 | 97.19 | 23248.0 |
| 2009-07-03 | LBS | Futures | 861.1 | 861.1 | 861.1 | 861.1 | 221.0 |
| 2009-07-03 | MP | Futures | 0.03907 | 0.03948 | 0.03907 | 0.03926 | 6347.0 |
| 2009-07-03 | N6 | Futures | 0.5003 | 0.50607 | 0.49934 | 0.5023 | 7058.0 |
| 2009-07-03 | NG | Futures | 212.447 | 215.074 | 209.704 | 210.988 | 86962.0 |
| 2009-07-03 | NIY | Futures | 7743.8 | 7928.4 | 7715.8 | 7771.9 | 13142.0 |
| 2009-07-03 | NKD | Futures | 9330.1 | 9344.3 | 9216.5 | 9226.0 | 8727.0 |
| 2009-07-03 | NOK | Futures | 0.152838 | 0.152838 | 0.152838 | 0.152838 | 2.0 |
| 2009-07-03 | PA | Futures | 288.49 | 288.49 | 285.57 | 288.43 | 765.0 |
| 2009-07-03 | PJY | Futures | 129.56 | 129.56 | 129.56 | 129.56 | 33.0 |
| 2009-07-03 | PL | Futures | 1370.5 | 1377.2 | 1365.7 | 1374.0 | 2575.0 |
| 2009-07-03 | PSI | Futures | 5700.0 | 5752.8 | 5671.9 | 5752.8 | 220.0 |
> showing 50 of 64 rows — these rows as CSV