PREVIEW / stock_daily / 2009-06-17
file: by_date/stock_daily/2009/2009-06-17.parquet size: 180 KB rows: 5,755 symbols: 3,431
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-06-17 | AAPL | Stock | 4.8811 | 4.9089 | 4.8046 | 4.8421 | 571412800.0 |
| 2009-06-17 | MSFT | Stock | 23.5 | 23.82 | 23.17 | 23.68 | 86483100.0 |
| 2009-06-17 | NVDA | Stock | 0.2795 | 0.2848 | 0.2688 | 0.282 | 799016000.0 |
| 2009-06-17 | AMZN | Stock | 4.125 | 4.215 | 4.032 | 4.1325 | 155702000.0 |
| 2009-06-17 | TLT | Stock | 92.45 | 93.33 | 91.84 | 91.84 | 7197109.0 |
| 2009-06-17 | ES | Stock | 21.65 | 22.05 | 21.52 | 21.66 | 1386800.0 |
| 2009-06-17 | CL | Stock | 34.265 | 34.995 | 34.25 | 34.76 | 5595200.0 |
| 2009-06-17 | A | Stock | 13.3405 | 13.4049 | 13.1044 | 13.1474 | 4365395.0 |
| 2009-06-17 | AABA-DELISTED | Stock | 15.91 | 16.03 | 15.46 | 15.6 | 16363928.0 |
| 2009-06-17 | AACC-DELISTED | Stock | 8.78 | 9.06 | 8.5775 | 8.97 | 20862.0 |
| 2009-06-17 | AACG | Stock | 7.1 | 7.12 | 6.89 | 6.91 | 14700.0 |
| 2009-06-17 | AAI-DELISTED | Stock | 5.62 | 6.03 | 5.42 | 5.94 | 2865802.0 |
| 2009-06-17 | AAIC-DELISTED | Stock | 8.6 | 8.6 | 8.2 | 8.2 | 434406.0 |
| 2009-06-17 | AAME | Stock | 0.74 | 0.8 | 0.71 | 0.8 | 3200.0 |
| 2009-06-17 | AAON | Stock | 3.8084 | 3.8993 | 3.7748 | 3.8716 | 270844.0 |
| 2009-06-17 | AAP | Stock | 40.92 | 42.73 | 40.72 | 42.16 | 1921500.0 |
| 2009-06-17 | AATI-DELISTED | Stock | 4.58 | 4.77 | 4.46 | 4.58 | 182981.0 |
| 2009-06-17 | AAU-DELISTED | Stock | 0.68 | 0.69 | 0.6612 | 0.67 | 73260.0 |
| 2009-06-17 | AAUAF-DELISTED | Stock | 0.68 | 0.69 | 0.6612 | 0.67 | 73660.0 |
| 2009-06-17 | AAV-DELISTED | Stock | 4.94 | 5.05 | 4.73 | 4.94 | 1480876.0 |
| 2009-06-17 | AAWW-DELISTED | Stock | 22.92 | 23.28 | 21.96 | 22.64 | 246363.0 |
| 2009-06-17 | AAXJ | Stock | 43.21 | 43.4 | 42.5 | 43.18 | 329925.0 |
| 2009-06-17 | AAXN-DELISTED | Stock | 4.11 | 4.4 | 4.06 | 4.39 | 443451.0 |
| 2009-06-17 | AB | Stock | 20.43 | 20.61 | 19.82 | 20.18 | 189100.0 |
| 2009-06-17 | ABAX-DELISTED | Stock | 17.06 | 17.68 | 16.9406 | 17.58 | 97773.0 |
| 2009-06-17 | ABB-DELISTED | Stock | 15.49 | 15.7001 | 15.31 | 15.55 | 4598177.0 |
| 2009-06-17 | ABBC-DELISTED | Stock | 8.41 | 8.74 | 8.25 | 8.55 | 35291.0 |
| 2009-06-17 | ABBNY-DELISTED | Stock | 15.49 | 15.7001 | 15.31 | 15.57 | 4599577.0 |
| 2009-06-17 | ABC-DELISTED | Stock | 17.79 | 18.56 | 17.79 | 18.25 | 3189257.0 |
| 2009-06-17 | ABCB | Stock | 6.1471 | 6.4389 | 5.972 | 6.3806 | 15936.0 |
| 2009-06-17 | ABCO-DELISTED | Stock | 12.39 | 13.21 | 12.39 | 12.825 | 238522.0 |
| 2009-06-17 | ABCW-DELISTED | Stock | 1.09 | 1.15 | 1.05 | 1.08 | 178810.0 |
| 2009-06-17 | ABD-DELISTED | Stock | 3.17 | 3.32 | 2.85 | 3.14 | 267450.0 |
| 2009-06-17 | ABE-DELISTED | Stock | 14.8 | 14.95 | 14.22 | 14.48 | 66805.0 |
| 2009-06-17 | ABEO | Stock | 2787.5 | 2787.5 | 2500.0 | 2525.0 | 20.0 |
| 2009-06-17 | ABFS-DELISTED | Stock | 28.86 | 29.59 | 28.36 | 29.13 | 550359.0 |
| 2009-06-17 | ABG | Stock | 10.24 | 10.94 | 9.78 | 10.78 | 400700.0 |
| 2009-06-17 | ABII-DELISTED | Stock | 39.94 | 40.2499 | 38.53 | 38.68 | 29364.0 |
| 2009-06-17 | ABK-DELISTED | Stock | 1.28 | 1.28 | 1.17 | 1.21 | 5176753.0 |
| 2009-06-17 | ABM | Stock | 17.88 | 18.21 | 17.72 | 17.95 | 117600.0 |
| 2009-06-17 | ABMD-DELISTED | Stock | 7.68 | 8.16 | 7.57 | 7.98 | 417090.0 |
| 2009-06-17 | ABR | Stock | 2.01 | 2.05 | 1.85 | 2.05 | 139400.0 |
| 2009-06-17 | ABT | Stock | 21.4806 | 22.1764 | 21.4711 | 22.0324 | 18319717.0 |
| 2009-06-17 | ABTL-DELISTED | Stock | 2.2235 | 2.2235 | 2.1 | 2.1 | 6787.0 |
| 2009-06-17 | ABV-DELISTED | Stock | 63.71 | 65.45 | 63.2 | 65.01 | 877173.0 |
| 2009-06-17 | ABVT-DELISTED | Stock | 75.25 | 77.0 | 74.8 | 76.7 | 32081.0 |
| 2009-06-17 | ABX-DELISTED | Stock | 33.52 | 33.59 | 32.56 | 33.39 | 9282876.0 |
| 2009-06-17 | ACAD | Stock | 2.26 | 2.28 | 2.12 | 2.19 | 147200.0 |
| 2009-06-17 | ACAP-DELISTED | Stock | 38.04 | 39.74 | 38.04 | 38.87 | 49907.0 |
| 2009-06-17 | ACAS-DELISTED | Stock | 3.83 | 3.86 | 3.5 | 3.54 | 8567321.0 |
> showing 50 of 5,755 rows — these rows as CSV