PREVIEW / futures_daily / 2009-04-24
file: by_date/futures_daily/2009/2009-04-24.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-04-24 | ES | Futures | 808.7 | 828.0 | 802.03 | 825.86 | 2407351.0 |
| 2009-04-24 | NQ | Futures | 1508.87 | 1548.76 | 1500.45 | 1544.83 | 318441.0 |
| 2009-04-24 | YM | Futures | 7103.2 | 7249.4 | 7044.9 | 7226.1 | 169045.0 |
| 2009-04-24 | CL | Futures | 133.73 | 139.38 | 132.14 | 138.84 | 230865.0 |
| 2009-04-24 | GC | Futures | 1253.8 | 1267.5 | 1252.0 | 1265.7 | 74412.0 |
| 2009-04-24 | ZN | Futures | 94.827796 | 94.900619 | 94.305897 | 94.415132 | 485530.0 |
| 2009-04-24 | A6 | Futures | 0.56743 | 0.57556 | 0.5648 | 0.57405 | 41053.0 |
| 2009-04-24 | AD | Futures | 0.80508 | 0.81591 | 0.80261 | 0.81541 | 51262.0 |
| 2009-04-24 | B | Futures | 48.49 | 50.39 | 47.88 | 49.98 | 102058.0 |
| 2009-04-24 | B6 | Futures | 1.5314 | 1.5372 | 1.5163 | 1.5263 | 87733.0 |
| 2009-04-24 | BFX | Futures | 2086.9 | 2129.9 | 2080.3 | 2125.1 | 98.0 |
| 2009-04-24 | BZ | Futures | 52.05 | 53.1 | 52.01 | 52.76 | 158.0 |
| 2009-04-24 | C | Futures | 1893.0 | 1905.0 | 1872.0 | 1873.0 | 1152.0 |
| 2009-04-24 | CC | Futures | 2166.0 | 2181.0 | 2154.0 | 2162.0 | 3636.0 |
| 2009-04-24 | CT | Futures | 48.11 | 48.83 | 47.76 | 48.76 | 10134.0 |
| 2009-04-24 | DC | Futures | 27.0 | 27.02 | 26.76 | 26.85 | 331.0 |
| 2009-04-24 | DX | Futures | 88.25 | 88.312 | 87.153 | 87.447 | 8811.0 |
| 2009-04-24 | E1 | Futures | 1.1525 | 1.1696 | 1.15104 | 1.16483 | 39840.0 |
| 2009-04-24 | E6 | Futures | 1.55656 | 1.57636 | 1.55383 | 1.56995 | 159852.0 |
| 2009-04-24 | E7 | Futures | 1.5385 | 1.558 | 1.5362 | 1.5517 | 2536.0 |
| 2009-04-24 | EBM | Futures | 225.62 | 226.01 | 217.88 | 219.05 | 3398.0 |
| 2009-04-24 | ED | Futures | 93.2755 | 93.3273 | 93.2613 | 93.3037 | 193110.0 |
| 2009-04-24 | ER | Futures | 96.645 | 96.674 | 96.64 | 96.674 | 80683.0 |
| 2009-04-24 | EW | Futures | 518.0 | 534.4 | 513.7 | 533.3 | 33456.0 |
| 2009-04-24 | FCE | Futures | 1890.1 | 1953.6 | 1890.1 | 1944.0 | 126617.0 |
| 2009-04-24 | FDAX | Futures | 4975.1 | 5106.3 | 4962.0 | 5092.1 | 154200.0 |
| 2009-04-24 | FESX | Futures | 1324.3 | 1362.1 | 1320.7 | 1356.1 | 1106756.0 |
| 2009-04-24 | FEU3 | Futures | 97.229 | 97.249 | 97.214 | 97.214 | 127.0 |
| 2009-04-24 | FGBL | Futures | 92.3 | 92.64 | 92.17 | 92.42 | 570457.0 |
| 2009-04-24 | FGBM | Futures | 97.46 | 97.72 | 97.38 | 97.62 | 355144.0 |
| 2009-04-24 | FGBS | Futures | 103.575 | 103.719 | 103.546 | 103.675 | 460987.0 |
| 2009-04-24 | FGBX | Futures | 83.54 | 83.59 | 83.03 | 83.35 | 1184.0 |
| 2009-04-24 | FTDX | Futures | 504.5 | 509.9 | 500.0 | 509.9 | 933.0 |
| 2009-04-24 | FTI | Futures | 192.88 | 196.13 | 192.43 | 195.84 | 30864.0 |
| 2009-04-24 | FTUK | Futures | 2658.1 | 2751.3 | 2656.8 | 2735.0 | 100914.0 |
| 2009-04-24 | G | Futures | 76.27 | 76.67 | 76.05 | 76.53 | 82322.0 |
| 2009-04-24 | GF | Futures | 276.794 | 277.701 | 276.445 | 276.794 | 415.0 |
| 2009-04-24 | GSCI | Futures | 771.93 | 787.02 | 771.93 | 785.43 | 89.0 |
| 2009-04-24 | HE | Futures | 115.438 | 116.098 | 113.664 | 113.871 | 740.0 |
| 2009-04-24 | HG | Futures | 2.804 | 2.9032 | 2.7505 | 2.8842 | 10013.0 |
| 2009-04-24 | HO | Futures | 1.4543 | 1.5154 | 1.439 | 1.5119 | 29493.0 |
| 2009-04-24 | HRC | Futures | 2595.1 | 2595.1 | 2595.1 | 2595.1 | 0.0 |
| 2009-04-24 | J1 | Futures | 0.0128698 | 0.0130526 | 0.0128623 | 0.0129958 | 83448.0 |
| 2009-04-24 | J7 | Futures | 0.012742 | 0.012852 | 0.012707 | 0.012819 | 57.0 |
| 2009-04-24 | JB | Futures | 114.84 | 115.05 | 114.84 | 114.99 | 2716.0 |
| 2009-04-24 | KC | Futures | 326.96 | 331.12 | 322.8 | 330.98 | 6583.0 |
| 2009-04-24 | KE | Futures | 2879.14 | 2901.08 | 2855.98 | 2893.77 | 5425.0 |
| 2009-04-24 | L | Futures | 96.944 | 96.974 | 96.915 | 96.964 | 36057.0 |
| 2009-04-24 | LBS | Futures | 906.9 | 906.9 | 889.3 | 895.0 | 135.0 |
| 2009-04-24 | LE | Futures | 146.979 | 147.995 | 145.83 | 146.007 | 5897.0 |
> showing 50 of 85 rows — these rows as CSV