PREVIEW / futures_daily / 2010-10-01
file: by_date/futures_daily/2010/2010-10-01.parquet size: 9 KB rows: 90
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-10-01 | ES | Futures | 1113.22 | 1123.75 | 1111.99 | 1119.59 | 2065971.0 |
| 2010-10-01 | NQ | Futures | 2262.97 | 2285.36 | 2250.78 | 2261.55 | 321294.0 |
| 2010-10-01 | YM | Futures | 9972.1 | 10055.8 | 9968.4 | 10019.5 | 142330.0 |
| 2010-10-01 | CL | Futures | 166.35 | 170.33 | 166.06 | 169.97 | 359944.0 |
| 2010-10-01 | GC | Futures | 1780.1 | 1796.9 | 1777.0 | 1791.2 | 114682.0 |
| 2010-10-01 | ZN | Futures | 104.148292 | 104.264429 | 103.709556 | 104.122484 | 1234193.0 |
| 2010-10-01 | A6 | Futures | 0.80387 | 0.81134 | 0.80186 | 0.80874 | 91773.0 |
| 2010-10-01 | AD | Futures | 0.96013 | 0.97103 | 0.95904 | 0.97073 | 113150.0 |
| 2010-10-01 | B | Futures | 70.79 | 72.15 | 70.79 | 72.11 | 108609.0 |
| 2010-10-01 | B6 | Futures | 1.6307 | 1.6472 | 1.6295 | 1.6429 | 108607.0 |
| 2010-10-01 | BFX | Futures | 2963.7 | 2977.9 | 2943.9 | 2949.5 | 185.0 |
| 2010-10-01 | BR | Futures | 0.25071 | 0.25189 | 0.25071 | 0.25135 | 174.0 |
| 2010-10-01 | BZ | Futures | 75.74 | 76.67 | 75.74 | 76.67 | 468.0 |
| 2010-10-01 | C | Futures | 2097.0 | 2115.0 | 2037.0 | 2039.0 | 6501.0 |
| 2010-10-01 | CC | Futures | 2344.0 | 2398.0 | 2288.0 | 2304.0 | 10187.0 |
| 2010-10-01 | CT | Futures | 86.25 | 87.0 | 82.88 | 82.97 | 13169.0 |
| 2010-10-01 | DC | Futures | 24.92 | 25.24 | 24.92 | 25.22 | 199.0 |
| 2010-10-01 | DX | Futures | 79.242 | 79.267 | 78.469 | 78.562 | 20933.0 |
| 2010-10-01 | E1 | Futures | 1.33669 | 1.35139 | 1.33459 | 1.34719 | 38424.0 |
| 2010-10-01 | E6 | Futures | 1.61154 | 1.6307 | 1.61 | 1.62904 | 323301.0 |
| 2010-10-01 | E7 | Futures | 1.5986 | 1.6182 | 1.5979 | 1.6167 | 5172.0 |
| 2010-10-01 | ED | Futures | 94.7078 | 94.7126 | 94.6936 | 94.6983 | 160365.0 |
| 2010-10-01 | ER | Futures | 97.227 | 97.242 | 97.193 | 97.227 | 310940.0 |
| 2010-10-01 | EW | Futures | 784.8 | 793.5 | 782.8 | 787.6 | 32915.0 |
| 2010-10-01 | FBTP | Futures | 67.07 | 67.25 | 67.06 | 67.2 | 4651.0 |
| 2010-10-01 | FCE | Futures | 2447.8 | 2463.9 | 2409.1 | 2422.9 | 189145.0 |
| 2010-10-01 | FDAX | Futures | 6722.4 | 6780.5 | 6663.2 | 6681.5 | 198160.0 |
| 2010-10-01 | FESX | Futures | 1711.9 | 1726.3 | 1689.5 | 1696.9 | 1608746.0 |
| 2010-10-01 | FEU3 | Futures | 97.8 | 97.8 | 97.77 | 97.79 | 114.0 |
| 2010-10-01 | FGBL | Futures | 104.02 | 104.04 | 103.3 | 103.84 | 1115596.0 |
| 2010-10-01 | FGBM | Futures | 106.4 | 106.43 | 106.1 | 106.35 | 568803.0 |
| 2010-10-01 | FGBS | Futures | 107.41 | 107.445 | 107.332 | 107.415 | 760521.0 |
| 2010-10-01 | FGBX | Futures | 108.51 | 108.51 | 107.08 | 108.1 | 3379.0 |
| 2010-10-01 | FTDX | Futures | 687.1 | 691.0 | 682.7 | 684.4 | 581.0 |
| 2010-10-01 | FTI | Futures | 268.41 | 270.13 | 266.44 | 267.73 | 45109.0 |
| 2010-10-01 | FTUK | Futures | 3842.3 | 3867.2 | 3827.4 | 3841.3 | 135445.0 |
| 2010-10-01 | G | Futures | 84.49 | 84.55 | 83.92 | 84.37 | 109678.0 |
| 2010-10-01 | GF | Futures | 280.847 | 282.105 | 279.778 | 281.162 | 911.0 |
| 2010-10-01 | GSCI | Futures | 920.74 | 921.99 | 913.57 | 916.07 | 618.0 |
| 2010-10-01 | HE | Futures | 101.324 | 101.493 | 98.313 | 98.617 | 23835.0 |
| 2010-10-01 | HG | Futures | 4.8783 | 4.9677 | 4.8763 | 4.9257 | 24904.0 |
| 2010-10-01 | HO | Futures | 1.9203 | 1.9524 | 1.919 | 1.9487 | 32944.0 |
| 2010-10-01 | HRC | Futures | 2662.6 | 2662.6 | 2662.6 | 2662.6 | 0.0 |
| 2010-10-01 | J1 | Futures | 0.0150569 | 0.0151172 | 0.0150393 | 0.015082 | 95776.0 |
| 2010-10-01 | J7 | Futures | 0.014939 | 0.015011 | 0.014939 | 0.014979 | 207.0 |
| 2010-10-01 | JB | Futures | 122.17 | 122.18 | 121.93 | 122.14 | 2718.0 |
| 2010-10-01 | KC | Futures | 455.43 | 461.76 | 447.62 | 449.11 | 8143.0 |
| 2010-10-01 | KE | Futures | 2956.95 | 2973.64 | 2853.69 | 2875.6 | 14076.0 |
| 2010-10-01 | L | Futures | 98.145 | 98.155 | 98.125 | 98.135 | 26234.0 |
| 2010-10-01 | LBS | Futures | 666.2 | 676.1 | 640.0 | 640.0 | 1887.0 |
> showing 50 of 90 rows — these rows as CSV