PREVIEW / futures_daily / 2009-04-13
file: by_date/futures_daily/2009/2009-04-13.parquet size: 8 KB rows: 68
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-04-13 | ES | Futures | 808.94 | 820.85 | 802.03 | 813.94 | 1635670.0 |
| 2009-04-13 | NQ | Futures | 1496.52 | 1509.44 | 1484.72 | 1496.52 | 193379.0 |
| 2009-04-13 | YM | Futures | 7168.7 | 7232.4 | 7096.1 | 7171.4 | 123069.0 |
| 2009-04-13 | CL | Futures | 146.66 | 147.63 | 139.01 | 142.7 | 176007.0 |
| 2009-04-13 | GC | Futures | 1222.5 | 1247.8 | 1222.5 | 1240.3 | 47867.0 |
| 2009-04-13 | ZN | Futures | 94.912756 | 95.762359 | 94.912756 | 95.62885 | 333548.0 |
| 2009-04-13 | A6 | Futures | 0.57317 | 0.58195 | 0.57078 | 0.57963 | 22193.0 |
| 2009-04-13 | AD | Futures | 0.80389 | 0.81 | 0.80065 | 0.80793 | 29699.0 |
| 2009-04-13 | B | Futures | 53.1 | 53.21 | 50.07 | 51.29 | 54079.0 |
| 2009-04-13 | B6 | Futures | 1.5229 | 1.5474 | 1.5196 | 1.5432 | 29857.0 |
| 2009-04-13 | BR | Futures | 0.17275 | 0.17309 | 0.17275 | 0.17309 | 164.0 |
| 2009-04-13 | BZ | Futures | 53.45 | 54.14 | 53.45 | 54.14 | 1.0 |
| 2009-04-13 | CB | Futures | 76.887 | 76.977 | 76.737 | 76.887 | 10.0 |
| 2009-04-13 | CC | Futures | 2266.0 | 2294.0 | 2235.0 | 2274.0 | 4237.0 |
| 2009-04-13 | CT | Futures | 45.48 | 46.14 | 44.13 | 45.42 | 16068.0 |
| 2009-04-13 | DC | Futures | 28.03 | 28.12 | 27.72 | 27.76 | 161.0 |
| 2009-04-13 | DX | Futures | 88.291 | 88.786 | 87.236 | 87.457 | 4036.0 |
| 2009-04-13 | E1 | Futures | 1.14733 | 1.17398 | 1.14322 | 1.1696 | 24386.0 |
| 2009-04-13 | E6 | Futures | 1.56284 | 1.58738 | 1.55573 | 1.58323 | 78413.0 |
| 2009-04-13 | E7 | Futures | 1.5444 | 1.5687 | 1.5376 | 1.5649 | 1010.0 |
| 2009-04-13 | ED | Futures | 93.2519 | 93.2613 | 93.2189 | 93.2519 | 67459.0 |
| 2009-04-13 | EW | Futures | 513.4 | 519.3 | 504.6 | 514.6 | 24783.0 |
| 2009-04-13 | GF | Futures | 276.165 | 278.958 | 274.979 | 278.19 | 628.0 |
| 2009-04-13 | GSCI | Futures | 815.73 | 815.73 | 796.38 | 805.95 | 69.0 |
| 2009-04-13 | HE | Futures | 121.214 | 121.214 | 119.358 | 121.008 | 485.0 |
| 2009-04-13 | HG | Futures | 2.9522 | 3.0551 | 2.9445 | 2.9945 | 15992.0 |
| 2009-04-13 | HO | Futures | 1.576 | 1.5983 | 1.4956 | 1.552 | 19964.0 |
| 2009-04-13 | HRC | Futures | 2619.0 | 2619.0 | 2619.0 | 2619.0 | 0.0 |
| 2009-04-13 | J1 | Futures | 0.0125598 | 0.0126329 | 0.0125169 | 0.0126039 | 25823.0 |
| 2009-04-13 | J7 | Futures | 0.012397 | 0.012458 | 0.012367 | 0.012433 | 34.0 |
| 2009-04-13 | JB | Futures | 114.51 | 114.54 | 114.35 | 114.46 | 723.0 |
| 2009-04-13 | KC | Futures | 335.16 | 338.4 | 317.86 | 324.05 | 15967.0 |
| 2009-04-13 | KE | Futures | 2817.51 | 2850.79 | 2780.54 | 2810.12 | 5652.0 |
| 2009-04-13 | LBS | Futures | 966.5 | 966.5 | 925.5 | 943.2 | 312.0 |
| 2009-04-13 | LE | Futures | 149.233 | 149.94 | 148.393 | 149.542 | 4697.0 |
| 2009-04-13 | MP | Futures | 0.0389 | 0.03908 | 0.03875 | 0.03893 | 5242.0 |
| 2009-04-13 | N6 | Futures | 0.46423 | 0.47091 | 0.46255 | 0.46948 | 875.0 |
| 2009-04-13 | NG | Futures | 226.249 | 228.434 | 218.697 | 226.436 | 52293.0 |
| 2009-04-13 | NIY | Futures | 7288.9 | 7450.9 | 7135.0 | 7244.4 | 7088.0 |
| 2009-04-13 | NKD | Futures | 8613.3 | 8935.3 | 8565.2 | 8671.0 | 3543.0 |
| 2009-04-13 | NOK | Futures | 0.148925 | 0.149624 | 0.148324 | 0.14922 | 38.0 |
| 2009-04-13 | OJ | Futures | 63.39 | 64.46 | 63.39 | 64.27 | 1253.0 |
| 2009-04-13 | PA | Futures | 270.41 | 279.62 | 270.41 | 278.93 | 574.0 |
| 2009-04-13 | PJY | Futures | 122.87 | 122.87 | 122.87 | 122.87 | 0.0 |
| 2009-04-13 | PL | Futures | 1404.7 | 1454.7 | 1404.7 | 1448.9 | 1100.0 |
| 2009-04-13 | QG | Futures | 231.115 | 231.115 | 220.71 | 228.782 | 2057.0 |
| 2009-04-13 | RB | Futures | 0.6828 | 0.6929 | 0.6508 | 0.6775 | 26094.0 |
| 2009-04-13 | RP | Futures | 1.01801 | 1.02215 | 1.01569 | 1.02068 | 9.0 |
| 2009-04-13 | RS | Futures | 453.9 | 458.3 | 447.3 | 456.8 | 4429.0 |
| 2009-04-13 | RTY | Futures | 465.0 | 469.7 | 456.2 | 464.6 | 120062.0 |
> showing 50 of 68 rows — these rows as CSV