PREVIEW / futures_daily / 2009-03-25
file: by_date/futures_daily/2009/2009-03-25.parquet size: 8 KB rows: 86
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-25 | ES | Futures | 765.57 | 784.87 | 750.08 | 770.34 | 3118269.0 |
| 2009-03-25 | NQ | Futures | 1388.1 | 1417.31 | 1354.11 | 1385.85 | 402757.0 |
| 2009-03-25 | YM | Futures | 6835.9 | 7004.6 | 6720.2 | 6888.9 | 237944.0 |
| 2009-03-25 | CL | Futures | 150.84 | 152.1 | 145.59 | 148.14 | 283727.0 |
| 2009-03-25 | GC | Futures | 1287.2 | 1307.2 | 1271.2 | 1298.6 | 162936.0 |
| 2009-03-25 | ZN | Futures | 96.18716 | 96.332807 | 95.398244 | 95.677399 | 722581.0 |
| 2009-03-25 | A6 | Futures | 0.55236 | 0.55961 | 0.54797 | 0.55044 | 60322.0 |
| 2009-03-25 | AD | Futures | 0.80065 | 0.80665 | 0.7975 | 0.79848 | 45572.0 |
| 2009-03-25 | B | Futures | 52.37 | 53.05 | 50.86 | 51.4 | 61416.0 |
| 2009-03-25 | B6 | Futures | 1.5299 | 1.5342 | 1.5104 | 1.5119 | 81260.0 |
| 2009-03-25 | BFX | Futures | 1907.7 | 1948.4 | 1906.4 | 1919.3 | 2337.0 |
| 2009-03-25 | BR | Futures | 0.16689 | 0.16689 | 0.1664 | 0.1664 | 1.0 |
| 2009-03-25 | C | Futures | 1962.0 | 1972.0 | 1932.0 | 1964.0 | 6756.0 |
| 2009-03-25 | CB | Futures | 75.382 | 75.382 | 75.232 | 75.382 | 13.0 |
| 2009-03-25 | CC | Futures | 2286.0 | 2300.0 | 2236.0 | 2275.0 | 6316.0 |
| 2009-03-25 | CT | Futures | 41.98 | 42.25 | 41.34 | 42.05 | 6657.0 |
| 2009-03-25 | DC | Futures | 30.5 | 31.98 | 30.5 | 31.74 | 176.0 |
| 2009-03-25 | DX | Futures | 87.143 | 87.354 | 86.139 | 86.803 | 6797.0 |
| 2009-03-25 | E1 | Futures | 1.17398 | 1.18936 | 1.17252 | 1.18512 | 39334.0 |
| 2009-03-25 | E6 | Futures | 1.5971 | 1.6188 | 1.5907 | 1.60825 | 245630.0 |
| 2009-03-25 | E7 | Futures | 1.5776 | 1.5998 | 1.5722 | 1.5896 | 2219.0 |
| 2009-03-25 | EBM | Futures | 210.53 | 210.53 | 206.66 | 207.05 | 5518.0 |
| 2009-03-25 | ED | Futures | 93.1152 | 93.1152 | 93.0681 | 93.0869 | 167930.0 |
| 2009-03-25 | ER | Futures | 96.591 | 96.62 | 96.571 | 96.596 | 121008.0 |
| 2009-03-25 | EW | Futures | 469.0 | 482.8 | 457.3 | 472.2 | 40411.0 |
| 2009-03-25 | FCE | Futures | 1819.3 | 1852.3 | 1789.2 | 1835.5 | 137809.0 |
| 2009-03-25 | FDAX | Futures | 4566.6 | 4660.3 | 4514.9 | 4612.9 | 179510.0 |
| 2009-03-25 | FESX | Futures | 1231.3 | 1258.3 | 1213.3 | 1245.1 | 1573316.0 |
| 2009-03-25 | FEU3 | Futures | 97.175 | 97.185 | 97.17 | 97.17 | 1830.0 |
| 2009-03-25 | FGBL | Futures | 92.83 | 93.09 | 92.55 | 92.85 | 687444.0 |
| 2009-03-25 | FGBM | Futures | 97.64 | 97.78 | 97.46 | 97.57 | 465151.0 |
| 2009-03-25 | FGBS | Futures | 103.623 | 103.695 | 103.575 | 103.613 | 399206.0 |
| 2009-03-25 | FGBX | Futures | 82.85 | 82.85 | 81.91 | 82.24 | 1473.0 |
| 2009-03-25 | FTDX | Futures | 413.7 | 426.3 | 411.9 | 423.6 | 702.0 |
| 2009-03-25 | FTI | Futures | 180.57 | 184.56 | 179.05 | 183.95 | 39032.0 |
| 2009-03-25 | FTUK | Futures | 2561.5 | 2596.2 | 2501.3 | 2564.2 | 125510.0 |
| 2009-03-25 | G | Futures | 76.9 | 77.37 | 75.76 | 77.3 | 124679.0 |
| 2009-03-25 | GF | Futures | 265.694 | 266.392 | 261.366 | 263.111 | 941.0 |
| 2009-03-25 | GSCI | Futures | 798.83 | 808.71 | 790.43 | 793.19 | 675.0 |
| 2009-03-25 | HE | Futures | 119.234 | 119.853 | 116.676 | 119.853 | 241.0 |
| 2009-03-25 | HG | Futures | 2.5268 | 2.5711 | 2.4866 | 2.5401 | 10789.0 |
| 2009-03-25 | HO | Futures | 1.6558 | 1.6656 | 1.6113 | 1.6287 | 13090.0 |
| 2009-03-25 | HRC | Futures | 2714.4 | 2714.4 | 2714.4 | 2714.4 | 0.0 |
| 2009-03-25 | J1 | Futures | 0.0129013 | 0.0130223 | 0.0128308 | 0.0129681 | 66025.0 |
| 2009-03-25 | J7 | Futures | 0.012686 | 0.012837 | 0.012681 | 0.012792 | 36.0 |
| 2009-03-25 | JB | Futures | 116.76 | 116.81 | 116.35 | 116.4 | 3471.0 |
| 2009-03-25 | KC | Futures | 327.15 | 329.68 | 324.33 | 328.27 | 7280.0 |
| 2009-03-25 | KE | Futures | 2901.32 | 2901.32 | 2736.17 | 2736.17 | 10035.0 |
| 2009-03-25 | L | Futures | 96.738 | 96.787 | 96.718 | 96.767 | 29114.0 |
| 2009-03-25 | LBS | Futures | 868.0 | 918.8 | 868.0 | 918.8 | 352.0 |
> showing 50 of 86 rows — these rows as CSV