PREVIEW / futures_daily / 2009-03-27
file: by_date/futures_daily/2009/2009-03-27.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-03-27 | ES | Futures | 787.97 | 791.07 | 771.53 | 777.72 | 2210455.0 |
| 2009-03-27 | NQ | Futures | 1430.79 | 1434.72 | 1402.14 | 1411.13 | 274212.0 |
| 2009-03-27 | YM | Futures | 7037.8 | 7057.5 | 6886.2 | 6962.4 | 169459.0 |
| 2009-03-27 | CL | Futures | 151.6 | 152.38 | 144.97 | 147.05 | 181165.0 |
| 2009-03-27 | GC | Futures | 1295.4 | 1299.9 | 1275.2 | 1281.2 | 79266.0 |
| 2009-03-27 | ZN | Futures | 95.980828 | 96.272121 | 95.640987 | 95.798771 | 433433.0 |
| 2009-03-27 | A6 | Futures | 0.55714 | 0.55802 | 0.54502 | 0.54917 | 35737.0 |
| 2009-03-27 | AD | Futures | 0.80163 | 0.8036 | 0.79178 | 0.79661 | 33183.0 |
| 2009-03-27 | B | Futures | 52.68 | 53.0 | 50.86 | 51.67 | 42514.0 |
| 2009-03-27 | B6 | Futures | 1.5043 | 1.5084 | 1.4848 | 1.4885 | 61544.0 |
| 2009-03-27 | BFX | Futures | 1950.6 | 1956.5 | 1904.8 | 1912.1 | 104.0 |
| 2009-03-27 | C | Futures | 1944.0 | 1987.0 | 1931.0 | 1986.0 | 6548.0 |
| 2009-03-27 | CB | Futures | 75.683 | 75.683 | 75.683 | 75.683 | 7.0 |
| 2009-03-27 | CC | Futures | 2254.0 | 2285.0 | 2213.0 | 2264.0 | 10354.0 |
| 2009-03-27 | CT | Futures | 41.4 | 41.73 | 40.76 | 40.88 | 9426.0 |
| 2009-03-27 | DC | Futures | 31.57 | 33.18 | 31.48 | 32.99 | 147.0 |
| 2009-03-27 | DX | Futures | 87.056 | 88.415 | 86.669 | 88.127 | 4333.0 |
| 2009-03-27 | E1 | Futures | 1.17809 | 1.18313 | 1.15688 | 1.16258 | 26870.0 |
| 2009-03-27 | E6 | Futures | 1.60315 | 1.61145 | 1.57161 | 1.5773 | 186511.0 |
| 2009-03-27 | E7 | Futures | 1.5849 | 1.5925 | 1.5531 | 1.559 | 2182.0 |
| 2009-03-27 | EBM | Futures | 204.73 | 204.73 | 203.57 | 204.73 | 2239.0 |
| 2009-03-27 | ED | Futures | 93.1246 | 93.1906 | 93.1199 | 93.1765 | 172371.0 |
| 2009-03-27 | ER | Futures | 96.611 | 96.684 | 96.611 | 96.674 | 123757.0 |
| 2009-03-27 | EW | Futures | 492.0 | 493.4 | 479.1 | 482.7 | 29469.0 |
| 2009-03-27 | FCE | Futures | 1833.3 | 1842.8 | 1788.5 | 1801.2 | 122968.0 |
| 2009-03-27 | FDAX | Futures | 4649.4 | 4666.8 | 4538.9 | 4587.9 | 138756.0 |
| 2009-03-27 | FESX | Futures | 1250.5 | 1257.1 | 1215.1 | 1224.1 | 1149616.0 |
| 2009-03-27 | FEU3 | Futures | 97.219 | 97.254 | 97.219 | 97.254 | 27.0 |
| 2009-03-27 | FGBL | Futures | 92.92 | 93.37 | 92.79 | 93.28 | 626091.0 |
| 2009-03-27 | FGBM | Futures | 97.66 | 98.08 | 97.66 | 98.03 | 402573.0 |
| 2009-03-27 | FGBS | Futures | 103.627 | 103.858 | 103.627 | 103.839 | 497364.0 |
| 2009-03-27 | FGBX | Futures | 82.67 | 83.88 | 80.88 | 83.69 | 1932.0 |
| 2009-03-27 | FTDX | Futures | 440.7 | 444.3 | 427.2 | 433.5 | 659.0 |
| 2009-03-27 | FTI | Futures | 183.78 | 184.52 | 179.83 | 180.86 | 28283.0 |
| 2009-03-27 | FTUK | Futures | 2583.5 | 2602.2 | 2545.2 | 2559.5 | 95343.0 |
| 2009-03-27 | G | Futures | 77.29 | 77.33 | 77.0 | 77.25 | 47811.0 |
| 2009-03-27 | GF | Futures | 261.785 | 262.413 | 259.132 | 260.039 | 314.0 |
| 2009-03-27 | GSCI | Futures | 794.25 | 795.32 | 778.31 | 781.5 | 262.0 |
| 2009-03-27 | HE | Futures | 117.625 | 118.12 | 116.511 | 117.501 | 191.0 |
| 2009-03-27 | HG | Futures | 2.6275 | 2.6726 | 2.538 | 2.5866 | 9507.0 |
| 2009-03-27 | HO | Futures | 1.6365 | 1.6365 | 1.5793 | 1.5907 | 12471.0 |
| 2009-03-27 | HRC | Futures | 2684.6 | 2684.6 | 2684.6 | 2684.6 | 0.0 |
| 2009-03-27 | J1 | Futures | 0.012764 | 0.0129984 | 0.012764 | 0.0128698 | 62319.0 |
| 2009-03-27 | J7 | Futures | 0.012618 | 0.012813 | 0.012584 | 0.012695 | 83.0 |
| 2009-03-27 | JB | Futures | 115.99 | 116.1 | 115.67 | 115.84 | 60.0 |
| 2009-03-27 | KC | Futures | 330.24 | 330.95 | 322.22 | 325.88 | 7559.0 |
| 2009-03-27 | KE | Futures | 2743.56 | 2769.45 | 2695.5 | 2711.52 | 5805.0 |
| 2009-03-27 | L | Futures | 96.757 | 96.797 | 96.748 | 96.787 | 28524.0 |
| 2009-03-27 | LBS | Futures | 908.9 | 931.8 | 900.7 | 914.6 | 128.0 |
| 2009-03-27 | LE | Futures | 145.432 | 145.918 | 144.106 | 144.195 | 4054.0 |
> showing 50 of 85 rows — these rows as CSV