PREVIEW / futures_daily / 2009-08-24
file: by_date/futures_daily/2009/2009-08-24.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-08-24 | ES | Futures | 983.43 | 993.02 | 979.83 | 982.95 | 1725611.0 |
| 2009-08-24 | NQ | Futures | 1841.28 | 1856.2 | 1834.24 | 1840.15 | 249412.0 |
| 2009-08-24 | YM | Futures | 8559.6 | 8639.9 | 8547.9 | 8565.1 | 132686.0 |
| 2009-08-24 | CL | Futures | 184.01 | 186.65 | 183.56 | 185.56 | 208702.0 |
| 2009-08-24 | GC | Futures | 1320.0 | 1325.1 | 1293.5 | 1304.6 | 74590.0 |
| 2009-08-24 | ZN | Futures | 92.234034 | 92.751165 | 92.061657 | 92.640351 | 821155.0 |
| 2009-08-24 | A6 | Futures | 0.67215 | 0.67641 | 0.67063 | 0.67264 | 64049.0 |
| 2009-08-24 | AD | Futures | 0.91472 | 0.92094 | 0.91235 | 0.91689 | 47350.0 |
| 2009-08-24 | B | Futures | 70.29 | 70.8 | 69.92 | 70.33 | 83617.0 |
| 2009-08-24 | B6 | Futures | 1.7185 | 1.723 | 1.7071 | 1.7076 | 72146.0 |
| 2009-08-24 | BFX | Futures | 2691.0 | 2738.1 | 2691.0 | 2727.5 | 329.0 |
| 2009-08-24 | BR | Futures | 0.21331 | 0.21331 | 0.21144 | 0.21144 | 689.0 |
| 2009-08-24 | C | Futures | 1987.0 | 1989.0 | 1966.0 | 1970.0 | 1311.0 |
| 2009-08-24 | CB | Futures | 67.642 | 68.045 | 67.642 | 67.642 | 14.0 |
| 2009-08-24 | CC | Futures | 2596.0 | 2615.0 | 2556.0 | 2568.0 | 3123.0 |
| 2009-08-24 | CT | Futures | 49.93 | 50.9 | 49.93 | 50.35 | 69.0 |
| 2009-08-24 | DC | Futures | 23.16 | 23.34 | 23.12 | 23.16 | 192.0 |
| 2009-08-24 | DX | Futures | 79.887 | 80.23 | 79.836 | 80.174 | 2813.0 |
| 2009-08-24 | E1 | Futures | 1.25257 | 1.25323 | 1.24556 | 1.24635 | 25112.0 |
| 2009-08-24 | E6 | Futures | 1.70254 | 1.70468 | 1.6953 | 1.69613 | 140613.0 |
| 2009-08-24 | E7 | Futures | 1.6852 | 1.6869 | 1.6781 | 1.6787 | 1514.0 |
| 2009-08-24 | ED | Futures | 94.0463 | 94.0628 | 94.0369 | 94.0605 | 103483.0 |
| 2009-08-24 | ER | Futures | 97.135 | 97.139 | 97.12 | 97.135 | 63566.0 |
| 2009-08-24 | EW | Futures | 636.6 | 642.0 | 632.6 | 635.2 | 28425.0 |
| 2009-08-24 | FCE | Futures | 2376.4 | 2393.1 | 2365.6 | 2386.2 | 99631.0 |
| 2009-08-24 | FDAX | Futures | 6026.8 | 6071.7 | 5999.3 | 6042.7 | 114206.0 |
| 2009-08-24 | FESX | Futures | 1648.0 | 1661.1 | 1639.7 | 1652.2 | 1009635.0 |
| 2009-08-24 | FEU3 | Futures | 97.702 | 97.712 | 97.702 | 97.712 | 43.0 |
| 2009-08-24 | FGBL | Futures | 92.65 | 93.03 | 92.55 | 92.74 | 493839.0 |
| 2009-08-24 | FGBM | Futures | 98.09 | 98.43 | 98.01 | 98.19 | 290389.0 |
| 2009-08-24 | FGBS | Futures | 104.022 | 104.191 | 103.988 | 104.094 | 321342.0 |
| 2009-08-24 | FGBX | Futures | 86.53 | 86.53 | 85.85 | 86.22 | 1131.0 |
| 2009-08-24 | FTDX | Futures | 633.5 | 641.1 | 627.7 | 631.7 | 760.0 |
| 2009-08-24 | FTI | Futures | 244.72 | 246.78 | 243.52 | 245.83 | 33323.0 |
| 2009-08-24 | FTUK | Futures | 3245.7 | 3258.3 | 3218.8 | 3244.0 | 117041.0 |
| 2009-08-24 | G | Futures | 76.57 | 76.59 | 76.31 | 76.54 | 97005.0 |
| 2009-08-24 | GF | Futures | 276.794 | 277.969 | 276.518 | 277.347 | 810.0 |
| 2009-08-24 | GSCI | Futures | 962.02 | 970.58 | 962.02 | 968.14 | 321.0 |
| 2009-08-24 | HE | Futures | 72.55 | 73.225 | 69.965 | 70.189 | 10215.0 |
| 2009-08-24 | HG | Futures | 4.0273 | 4.0921 | 4.0057 | 4.0837 | 15313.0 |
| 2009-08-24 | HO | Futures | 1.9239 | 1.9422 | 1.9219 | 1.9304 | 6243.0 |
| 2009-08-24 | HRC | Futures | 2586.5 | 2586.5 | 2586.5 | 2586.5 | 0.0 |
| 2009-08-24 | J1 | Futures | 0.013342 | 0.013342 | 0.0132438 | 0.0133231 | 68751.0 |
| 2009-08-24 | J7 | Futures | 0.013154 | 0.013154 | 0.013059 | 0.01314 | 30.0 |
| 2009-08-24 | JB | Futures | 117.13 | 117.15 | 116.93 | 117.02 | 2072.0 |
| 2009-08-24 | KC | Futures | 330.23 | 333.66 | 322.7 | 323.36 | 8764.0 |
| 2009-08-24 | KE | Futures | 2368.2 | 2419.76 | 2362.2 | 2413.77 | 5909.0 |
| 2009-08-24 | L | Futures | 97.612 | 97.632 | 97.612 | 97.622 | 18898.0 |
| 2009-08-24 | LBS | Futures | 734.8 | 739.2 | 716.9 | 722.6 | 489.0 |
| 2009-08-24 | LE | Futures | 147.263 | 148.428 | 147.096 | 147.845 | 11311.0 |
> showing 50 of 85 rows — these rows as CSV