PREVIEW / futures_daily / 2009-03-24
file: by_date/futures_daily/2009/2009-03-24.parquet size: 9 KB rows: 87
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-03-24 | ES | Futures | 779.63 | 781.54 | 763.67 | 765.81 | 2433671.0 |
| 2009-03-24 | NQ | Futures | 1408.32 | 1410.01 | 1383.6 | 1388.94 | 272775.0 |
| 2009-03-24 | YM | Futures | 6915.8 | 6945.4 | 6805.4 | 6835.0 | 183040.0 |
| 2009-03-24 | CL | Futures | 151.12 | 151.77 | 147.25 | 151.54 | 212790.0 |
| 2009-03-24 | GC | Futures | 1302.2 | 1310.8 | 1272.4 | 1282.0 | 154379.0 |
| 2009-03-24 | ZN | Futures | 96.478453 | 96.587687 | 95.895868 | 96.466316 | 717232.0 |
| 2009-03-24 | A6 | Futures | 0.55842 | 0.56304 | 0.54989 | 0.55531 | 47136.0 |
| 2009-03-24 | AD | Futures | 0.80439 | 0.80764 | 0.79956 | 0.80429 | 34436.0 |
| 2009-03-24 | B | Futures | 52.1 | 52.48 | 51.31 | 52.37 | 84455.0 |
| 2009-03-24 | B6 | Futures | 1.5154 | 1.538 | 1.5142 | 1.532 | 74268.0 |
| 2009-03-24 | BFX | Futures | 1955.0 | 1955.0 | 1893.4 | 1907.7 | 451.0 |
| 2009-03-24 | BR | Futures | 0.16621 | 0.16625 | 0.16621 | 0.16621 | 47.0 |
| 2009-03-24 | BZ | Futures | 54.17 | 54.62 | 54.0 | 54.62 | 5.0 |
| 2009-03-24 | C | Futures | 1964.0 | 1969.0 | 1949.0 | 1966.0 | 3879.0 |
| 2009-03-24 | CB | Futures | 75.232 | 75.382 | 75.232 | 75.382 | 2.0 |
| 2009-03-24 | CC | Futures | 2287.0 | 2310.0 | 2284.0 | 2295.0 | 3895.0 |
| 2009-03-24 | CT | Futures | 42.21 | 42.46 | 41.46 | 41.8 | 8451.0 |
| 2009-03-24 | DC | Futures | 30.54 | 30.69 | 30.47 | 30.57 | 57.0 |
| 2009-03-24 | DX | Futures | 86.412 | 87.303 | 86.191 | 86.839 | 7051.0 |
| 2009-03-24 | E1 | Futures | 1.18034 | 1.18512 | 1.17292 | 1.17902 | 25710.0 |
| 2009-03-24 | E6 | Futures | 1.61489 | 1.62152 | 1.59224 | 1.60267 | 211087.0 |
| 2009-03-24 | E7 | Futures | 1.5956 | 1.6027 | 1.5739 | 1.5841 | 2471.0 |
| 2009-03-24 | EBM | Futures | 214.79 | 214.79 | 210.92 | 211.31 | 4822.0 |
| 2009-03-24 | ED | Futures | 93.1199 | 93.1293 | 93.0869 | 93.1105 | 149695.0 |
| 2009-03-24 | ER | Futures | 96.615 | 96.625 | 96.576 | 96.596 | 150187.0 |
| 2009-03-24 | EW | Futures | 477.6 | 478.8 | 466.5 | 469.7 | 27191.0 |
| 2009-03-24 | FCE | Futures | 1844.7 | 1859.3 | 1802.5 | 1824.4 | 135663.0 |
| 2009-03-24 | FDAX | Futures | 4618.9 | 4642.9 | 4534.0 | 4581.3 | 157120.0 |
| 2009-03-24 | FESX | Futures | 1250.5 | 1259.5 | 1220.5 | 1234.3 | 1462922.0 |
| 2009-03-24 | FEU3 | Futures | 97.185 | 97.195 | 97.165 | 97.18 | 1738.0 |
| 2009-03-24 | FGBL | Futures | 93.53 | 93.58 | 92.69 | 92.86 | 753385.0 |
| 2009-03-24 | FGBM | Futures | 98.01 | 98.02 | 97.58 | 97.64 | 437451.0 |
| 2009-03-24 | FGBS | Futures | 103.738 | 103.738 | 103.603 | 103.637 | 468937.0 |
| 2009-03-24 | FGBX | Futures | 82.85 | 83.13 | 82.0 | 82.13 | 2614.0 |
| 2009-03-24 | FTDX | Futures | 415.5 | 420.0 | 409.2 | 418.2 | 3315.0 |
| 2009-03-24 | FTI | Futures | 182.79 | 183.82 | 178.18 | 180.78 | 35855.0 |
| 2009-03-24 | FTUK | Futures | 2637.1 | 2643.4 | 2544.9 | 2573.9 | 123549.0 |
| 2009-03-24 | G | Futures | 77.75 | 77.82 | 76.55 | 76.98 | 109051.0 |
| 2009-03-24 | GF | Futures | 264.996 | 266.252 | 262.832 | 265.624 | 349.0 |
| 2009-03-24 | GSCI | Futures | 807.23 | 813.92 | 800.0 | 813.92 | 372.0 |
| 2009-03-24 | HE | Futures | 119.151 | 120.967 | 118.409 | 119.647 | 53.0 |
| 2009-03-24 | HG | Futures | 2.6155 | 2.6472 | 2.5077 | 2.5444 | 11929.0 |
| 2009-03-24 | HO | Futures | 1.6414 | 1.6762 | 1.6229 | 1.6745 | 8879.0 |
| 2009-03-24 | HRC | Futures | 2714.4 | 2714.4 | 2714.4 | 2714.4 | 0.0 |
| 2009-03-24 | J1 | Futures | 0.0129996 | 0.0130198 | 0.012803 | 0.0129001 | 64866.0 |
| 2009-03-24 | J7 | Futures | 0.012799 | 0.012821 | 0.012652 | 0.012725 | 58.0 |
| 2009-03-24 | JB | Futures | 116.91 | 116.96 | 116.7 | 116.83 | 1447.0 |
| 2009-03-24 | KC | Futures | 329.12 | 331.65 | 327.01 | 328.41 | 6946.0 |
| 2009-03-24 | KE | Futures | 2967.88 | 2967.88 | 2864.35 | 2898.86 | 6956.0 |
| 2009-03-24 | L | Futures | 96.757 | 96.787 | 96.718 | 96.757 | 49885.0 |
> showing 50 of 87 rows — these rows as CSV