PREVIEW / futures_daily / 2009-02-24
file: by_date/futures_daily/2009/2009-02-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-02-24 | ES | Futures | 703.49 | 731.59 | 701.84 | 725.92 | 2750323.0 |
| 2009-02-24 | NQ | Futures | 1270.03 | 1315.59 | 1266.68 | 1300.78 | 390287.0 |
| 2009-02-24 | YM | Futures | 6339.6 | 6558.6 | 6322.7 | 6503.4 | 228892.0 |
| 2009-02-24 | CL | Futures | 107.26 | 112.98 | 105.99 | 112.5 | 238188.0 |
| 2009-02-24 | GC | Futures | 1376.8 | 1383.6 | 1332.5 | 1345.4 | 156165.0 |
| 2009-02-24 | ZN | Futures | 94.272067 | 94.702369 | 93.877623 | 93.985198 | 778143.0 |
| 2009-02-24 | A6 | Futures | 0.50846 | 0.51694 | 0.506 | 0.51552 | 29972.0 |
| 2009-02-24 | AD | Futures | 0.78552 | 0.79259 | 0.78316 | 0.79092 | 36743.0 |
| 2009-02-24 | B | Futures | 41.2 | 43.01 | 41.0 | 42.91 | 63999.0 |
| 2009-02-24 | B6 | Futures | 1.5052 | 1.5147 | 1.4932 | 1.5055 | 61260.0 |
| 2009-02-24 | BFX | Futures | 1878.0 | 1878.0 | 1852.4 | 1867.0 | 298.0 |
| 2009-02-24 | BR | Futures | 0.15473 | 0.15473 | 0.15473 | 0.15473 | 16.0 |
| 2009-02-24 | BZ | Futures | 43.38 | 44.76 | 43.38 | 44.76 | 4.0 |
| 2009-02-24 | C | Futures | 1692.0 | 1746.0 | 1673.0 | 1733.0 | 4803.0 |
| 2009-02-24 | CB | Futures | 74.63 | 74.781 | 74.63 | 74.781 | 5.0 |
| 2009-02-24 | CC | Futures | 2073.0 | 2112.0 | 2035.0 | 2075.0 | 6600.0 |
| 2009-02-24 | CT | Futures | 41.22 | 41.77 | 41.06 | 41.3 | 4463.0 |
| 2009-02-24 | DC | Futures | 27.31 | 27.43 | 26.88 | 27.14 | 392.0 |
| 2009-02-24 | DX | Futures | 90.747 | 91.084 | 90.161 | 90.265 | 3964.0 |
| 2009-02-24 | E1 | Futures | 1.13803 | 1.15265 | 1.1351 | 1.14587 | 34851.0 |
| 2009-02-24 | E6 | Futures | 1.50403 | 1.52416 | 1.49858 | 1.5212 | 191073.0 |
| 2009-02-24 | E7 | Futures | 1.486 | 1.5067 | 1.4817 | 1.5038 | 1741.0 |
| 2009-02-24 | EBM | Futures | 214.75 | 214.75 | 211.68 | 212.83 | 2207.0 |
| 2009-02-24 | ED | Futures | 93.046 | 93.0483 | 92.9895 | 93.0012 | 161482.0 |
| 2009-02-24 | ER | Futures | 96.371 | 96.41 | 96.371 | 96.39 | 88158.0 |
| 2009-02-24 | EW | Futures | 439.7 | 457.9 | 437.7 | 453.4 | 31905.0 |
| 2009-02-24 | FCE | Futures | 1686.3 | 1732.8 | 1664.5 | 1689.8 | 157299.0 |
| 2009-02-24 | FDAX | Futures | 4261.3 | 4356.3 | 4168.0 | 4271.7 | 209000.0 |
| 2009-02-24 | FESX | Futures | 1136.4 | 1164.6 | 1116.9 | 1140.4 | 1692416.0 |
| 2009-02-24 | FEU3 | Futures | 96.958 | 96.978 | 96.948 | 96.958 | 1052.0 |
| 2009-02-24 | FGBL | Futures | 93.69 | 94.13 | 93.65 | 93.89 | 622209.0 |
| 2009-02-24 | FGBM | Futures | 98.27 | 98.57 | 98.26 | 98.41 | 296750.0 |
| 2009-02-24 | FGBS | Futures | 103.858 | 103.939 | 103.834 | 103.877 | 353781.0 |
| 2009-02-24 | FGBX | Futures | 85.41 | 85.94 | 85.24 | 85.74 | 1434.0 |
| 2009-02-24 | FTDX | Futures | 386.6 | 406.3 | 380.3 | 393.8 | 1036.0 |
| 2009-02-24 | FTI | Futures | 180.41 | 182.25 | 177.6 | 181.03 | 42534.0 |
| 2009-02-24 | FTUK | Futures | 2501.4 | 2548.2 | 2459.7 | 2489.9 | 153918.0 |
| 2009-02-24 | G | Futures | 76.86 | 77.0 | 76.64 | 76.86 | 206586.0 |
| 2009-02-24 | GF | Futures | 247.23 | 255.436 | 246.599 | 254.595 | 680.0 |
| 2009-02-24 | GSCI | Futures | 678.11 | 696.7 | 675.92 | 696.7 | 86.0 |
| 2009-02-24 | HE | Futures | 111.346 | 112.023 | 109.945 | 111.539 | 4173.0 |
| 2009-02-24 | HG | Futures | 2.0372 | 2.1724 | 2.0076 | 2.1133 | 12222.0 |
| 2009-02-24 | HO | Futures | 1.3169 | 1.3419 | 1.3117 | 1.335 | 6161.0 |
| 2009-02-24 | HRC | Futures | 2982.9 | 2982.9 | 2982.9 | 2982.9 | 0.0 |
| 2009-02-24 | J1 | Futures | 0.0133765 | 0.0134043 | 0.013033 | 0.0130443 | 96531.0 |
| 2009-02-24 | J7 | Futures | 0.013214 | 0.013241 | 0.012877 | 0.012887 | 195.0 |
| 2009-02-24 | JB | Futures | 116.95 | 116.95 | 116.71 | 116.95 | 2.0 |
| 2009-02-24 | KC | Futures | 317.44 | 320.96 | 314.77 | 318.71 | 4429.0 |
| 2009-02-24 | KE | Futures | 2736.17 | 2785.47 | 2725.08 | 2769.45 | 5566.0 |
| 2009-02-24 | L | Futures | 96.502 | 96.551 | 96.463 | 96.512 | 42324.0 |
> showing 50 of 87 rows — these rows as CSV