PREVIEW / futures_daily / 2009-08-25
file: by_date/futures_daily/2009/2009-08-25.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-25 | ES | Futures | 982.71 | 995.9 | 976.95 | 984.39 | 2067951.0 |
| 2009-08-25 | NQ | Futures | 1840.15 | 1864.36 | 1830.3 | 1842.96 | 290751.0 |
| 2009-08-25 | YM | Futures | 8562.4 | 8676.9 | 8518.1 | 8592.1 | 161675.0 |
| 2009-08-25 | CL | Futures | 184.56 | 187.13 | 177.42 | 179.77 | 324399.0 |
| 2009-08-25 | GC | Futures | 1304.7 | 1322.0 | 1303.8 | 1307.8 | 76992.0 |
| 2009-08-25 | ZN | Futures | 92.714227 | 92.96048 | 92.455662 | 92.886604 | 860756.0 |
| 2009-08-25 | A6 | Futures | 0.67223 | 0.67681 | 0.66902 | 0.67095 | 70935.0 |
| 2009-08-25 | AD | Futures | 0.91729 | 0.92154 | 0.9086 | 0.91037 | 61242.0 |
| 2009-08-25 | B | Futures | 70.33 | 70.77 | 67.78 | 68.53 | 50688.0 |
| 2009-08-25 | B6 | Futures | 1.7094 | 1.7128 | 1.7008 | 1.7023 | 78488.0 |
| 2009-08-25 | BFX | Futures | 2710.3 | 2757.6 | 2710.3 | 2750.2 | 156.0 |
| 2009-08-25 | BR | Futures | 0.21144 | 0.21144 | 0.21023 | 0.21023 | 253.0 |
| 2009-08-25 | BZ | Futures | 73.29 | 73.39 | 71.33 | 71.33 | 2.0 |
| 2009-08-25 | C | Futures | 1984.0 | 2014.0 | 1984.0 | 2008.0 | 1627.0 |
| 2009-08-25 | CC | Futures | 2563.0 | 2654.0 | 2557.0 | 2640.0 | 8605.0 |
| 2009-08-25 | CT | Futures | 50.36 | 50.6 | 49.4 | 49.51 | 185.0 |
| 2009-08-25 | DC | Futures | 23.16 | 23.48 | 23.16 | 23.31 | 103.0 |
| 2009-08-25 | DX | Futures | 80.133 | 80.332 | 79.693 | 80.138 | 5378.0 |
| 2009-08-25 | E1 | Futures | 1.24688 | 1.25323 | 1.24423 | 1.24781 | 28685.0 |
| 2009-08-25 | E6 | Futures | 1.69743 | 1.7061 | 1.69197 | 1.6985 | 176910.0 |
| 2009-08-25 | E7 | Futures | 1.68 | 1.6895 | 1.6745 | 1.6811 | 1578.0 |
| 2009-08-25 | ED | Futures | 94.0605 | 94.0652 | 94.051 | 94.0628 | 92476.0 |
| 2009-08-25 | ER | Futures | 97.135 | 97.139 | 97.13 | 97.139 | 37174.0 |
| 2009-08-25 | EW | Futures | 634.5 | 643.9 | 631.6 | 637.5 | 32857.0 |
| 2009-08-25 | FCE | Futures | 2369.5 | 2412.7 | 2364.6 | 2405.9 | 110417.0 |
| 2009-08-25 | FDAX | Futures | 6000.4 | 6120.6 | 5991.1 | 6096.4 | 130774.0 |
| 2009-08-25 | FESX | Futures | 1640.2 | 1677.2 | 1636.7 | 1671.9 | 1073804.0 |
| 2009-08-25 | FEU3 | Futures | 97.712 | 97.717 | 97.712 | 97.717 | 40.0 |
| 2009-08-25 | FGBL | Futures | 93.06 | 93.21 | 92.86 | 93.06 | 544851.0 |
| 2009-08-25 | FGBM | Futures | 98.38 | 98.47 | 98.31 | 98.42 | 318469.0 |
| 2009-08-25 | FGBS | Futures | 104.162 | 104.205 | 104.143 | 104.167 | 302178.0 |
| 2009-08-25 | FGBX | Futures | 86.72 | 86.74 | 86.22 | 86.62 | 1391.0 |
| 2009-08-25 | FTDX | Futures | 625.5 | 632.2 | 620.1 | 629.0 | 822.0 |
| 2009-08-25 | FTI | Futures | 242.4 | 248.43 | 242.4 | 247.65 | 33649.0 |
| 2009-08-25 | FTUK | Futures | 3231.1 | 3270.2 | 3225.1 | 3266.3 | 100537.0 |
| 2009-08-25 | G | Futures | 76.54 | 77.0 | 76.52 | 76.89 | 191668.0 |
| 2009-08-25 | GF | Futures | 278.038 | 278.038 | 276.379 | 276.379 | 656.0 |
| 2009-08-25 | GSCI | Futures | 968.55 | 968.85 | 937.57 | 940.42 | 474.0 |
| 2009-08-25 | HE | Futures | 70.189 | 73.15 | 70.152 | 72.4 | 12264.0 |
| 2009-08-25 | HG | Futures | 4.0412 | 4.0621 | 3.9681 | 4.0043 | 8208.0 |
| 2009-08-25 | HO | Futures | 1.9181 | 1.9339 | 1.8527 | 1.8709 | 9021.0 |
| 2009-08-25 | HRC | Futures | 2586.5 | 2586.5 | 2586.5 | 2586.5 | 0.0 |
| 2009-08-25 | J1 | Futures | 0.0133231 | 0.0134238 | 0.0133017 | 0.0133697 | 86418.0 |
| 2009-08-25 | J7 | Futures | 0.013186 | 0.013235 | 0.01313 | 0.013186 | 21.0 |
| 2009-08-25 | JB | Futures | 116.93 | 117.16 | 116.9 | 116.97 | 1279.0 |
| 2009-08-25 | KC | Futures | 323.1 | 326.53 | 320.2 | 320.46 | 6830.0 |
| 2009-08-25 | KE | Futures | 2413.77 | 2507.99 | 2405.62 | 2421.91 | 11824.0 |
| 2009-08-25 | L | Futures | 97.622 | 97.632 | 97.612 | 97.622 | 24377.0 |
| 2009-08-25 | LBS | Futures | 722.6 | 730.3 | 717.3 | 723.4 | 211.0 |
| 2009-08-25 | LE | Futures | 147.97 | 149.011 | 147.387 | 147.762 | 14852.0 |
> showing 50 of 85 rows — these rows as CSV