PREVIEW / futures_daily / 2009-10-01
file: by_date/futures_daily/2009/2009-10-01.parquet size: 9 KB rows: 88
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-10-01 | ES | Futures | 1016.14 | 1018.55 | 988.16 | 991.06 | 2761051.0 |
| 2009-10-01 | NQ | Futures | 1937.09 | 1949.23 | 1878.11 | 1885.73 | 405570.0 |
| 2009-10-01 | YM | Futures | 8773.6 | 8791.8 | 8568.4 | 8598.4 | 188086.0 |
| 2009-10-01 | CL | Futures | 174.34 | 176.79 | 171.2 | 175.38 | 334690.0 |
| 2009-10-01 | GC | Futures | 1393.9 | 1397.8 | 1380.5 | 1383.4 | 113352.0 |
| 2009-10-01 | ZN | Futures | 94.31415 | 95.18593 | 94.226972 | 95.06139 | 1156105.0 |
| 2009-10-01 | A6 | Futures | 0.70922 | 0.7118 | 0.6971 | 0.69944 | 95630.0 |
| 2009-10-01 | AD | Futures | 0.92251 | 0.92399 | 0.909 | 0.90949 | 74827.0 |
| 2009-10-01 | B | Futures | 64.94 | 65.77 | 63.81 | 65.27 | 93790.0 |
| 2009-10-01 | B6 | Futures | 1.665 | 1.6673 | 1.6565 | 1.6592 | 118425.0 |
| 2009-10-01 | BFX | Futures | 2820.9 | 2830.1 | 2778.7 | 2780.9 | 466.0 |
| 2009-10-01 | BR | Futures | 0.22221 | 0.22221 | 0.22023 | 0.22106 | 160.0 |
| 2009-10-01 | BZ | Futures | 68.49 | 68.68 | 67.36 | 68.46 | 19.0 |
| 2009-10-01 | C | Futures | 2165.0 | 2172.0 | 2127.0 | 2134.0 | 7552.0 |
| 2009-10-01 | CB | Futures | 69.928 | 71.004 | 69.928 | 71.004 | 13.0 |
| 2009-10-01 | CC | Futures | 2755.0 | 2769.0 | 2694.0 | 2713.0 | 7574.0 |
| 2009-10-01 | CT | Futures | 54.12 | 54.21 | 52.63 | 52.94 | 7038.0 |
| 2009-10-01 | DC | Futures | 23.79 | 24.39 | 23.79 | 24.22 | 172.0 |
| 2009-10-01 | DX | Futures | 78.481 | 79.119 | 78.409 | 79.037 | 8947.0 |
| 2009-10-01 | E1 | Futures | 1.27573 | 1.27837 | 1.26423 | 1.26912 | 47515.0 |
| 2009-10-01 | E6 | Futures | 1.73493 | 1.73825 | 1.72024 | 1.72249 | 262497.0 |
| 2009-10-01 | E7 | Futures | 1.718 | 1.7215 | 1.7033 | 1.706 | 3781.0 |
| 2009-10-01 | ED | Futures | 94.186 | 94.2049 | 94.1812 | 94.186 | 182434.0 |
| 2009-10-01 | ER | Futures | 97.154 | 97.164 | 97.139 | 97.149 | 123520.0 |
| 2009-10-01 | EW | Futures | 667.8 | 669.9 | 646.8 | 650.3 | 49981.0 |
| 2009-10-01 | FCE | Futures | 2509.5 | 2523.0 | 2437.5 | 2455.0 | 161112.0 |
| 2009-10-01 | FDAX | Futures | 6178.7 | 6233.1 | 6017.7 | 6048.7 | 203795.0 |
| 2009-10-01 | FESX | Futures | 1707.7 | 1719.6 | 1661.1 | 1672.5 | 1489451.0 |
| 2009-10-01 | FEU3 | Futures | 97.732 | 97.732 | 97.722 | 97.722 | 223.0 |
| 2009-10-01 | FGBL | Futures | 93.8 | 94.44 | 93.64 | 94.26 | 1045393.0 |
| 2009-10-01 | FGBM | Futures | 99.1 | 99.5 | 98.94 | 99.39 | 558580.0 |
| 2009-10-01 | FGBS | Futures | 104.721 | 104.823 | 104.614 | 104.784 | 616823.0 |
| 2009-10-01 | FGBX | Futures | 88.1 | 88.77 | 87.32 | 88.28 | 3055.0 |
| 2009-10-01 | FTDX | Futures | 671.0 | 675.0 | 650.0 | 657.1 | 520.0 |
| 2009-10-01 | FTI | Futures | 256.75 | 258.32 | 250.5 | 251.53 | 40644.0 |
| 2009-10-01 | FTUK | Futures | 3384.0 | 3406.6 | 3310.1 | 3331.6 | 133907.0 |
| 2009-10-01 | G | Futures | 76.89 | 77.65 | 76.76 | 77.48 | 144039.0 |
| 2009-10-01 | GF | Futures | 265.846 | 266.396 | 260.201 | 261.44 | 942.0 |
| 2009-10-01 | GSCI | Futures | 924.56 | 928.46 | 907.55 | 920.06 | 509.0 |
| 2009-10-01 | HE | Futures | 75.229 | 76.525 | 73.629 | 74.124 | 13386.0 |
| 2009-10-01 | HG | Futures | 3.9221 | 3.9332 | 3.7702 | 3.8141 | 22428.0 |
| 2009-10-01 | HO | Futures | 1.793 | 1.8192 | 1.7654 | 1.7979 | 14511.0 |
| 2009-10-01 | HRC | Futures | 2763.8 | 2763.8 | 2763.8 | 2763.8 | 0.0 |
| 2009-10-01 | J1 | Futures | 0.0140045 | 0.0140497 | 0.0139317 | 0.0139958 | 78152.0 |
| 2009-10-01 | J7 | Futures | 0.013812 | 0.013864 | 0.013752 | 0.013813 | 46.0 |
| 2009-10-01 | JB | Futures | 117.58 | 117.62 | 117.52 | 117.59 | 1004.0 |
| 2009-10-01 | KC | Futures | 336.56 | 342.5 | 332.34 | 334.45 | 9276.0 |
| 2009-10-01 | KE | Futures | 2195.07 | 2202.05 | 2157.85 | 2184.6 | 6708.0 |
| 2009-10-01 | L | Futures | 97.819 | 97.838 | 97.789 | 97.819 | 82391.0 |
| 2009-10-01 | LBS | Futures | 694.1 | 702.6 | 689.6 | 699.8 | 1337.0 |
> showing 50 of 88 rows — these rows as CSV