PREVIEW / stock_daily / 2005-08-01
file: by_date/stock_daily/2005/2005-08-01.parquet size: 140 KB rows: 4,174 symbols: 2,626
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-01 | AAPL | Stock | 1.5204 | 1.5386 | 1.5029 | 1.5268 | 314249600.0 |
| 2005-08-01 | MSFT | Stock | 25.81 | 26.05 | 25.76 | 25.92 | 61346800.0 |
| 2005-08-01 | NVDA | Stock | 0.2268 | 0.2299 | 0.2253 | 0.2289 | 389040000.0 |
| 2005-08-01 | AMZN | Stock | 2.244 | 2.2595 | 2.2175 | 2.2465 | 142544000.0 |
| 2005-08-01 | CL | Stock | 26.575 | 26.685 | 26.35 | 26.525 | 3779800.0 |
| 2005-08-01 | A | Stock | 18.7625 | 19.1345 | 18.7625 | 18.9628 | 1878632.0 |
| 2005-08-01 | AABA-DELISTED | Stock | 33.6300010681152 | 33.689998626709 | 33.310001373291 | 33.3300018310547 | 12637100.0 |
| 2005-08-01 | AACC-DELISTED | Stock | 27.65 | 28.48 | 27.63 | 27.96 | 356959.0 |
| 2005-08-01 | AACQ-DELISTED | Stock | 5.0 | 5.05 | 5.0 | 5.05 | 3700.0 |
| 2005-08-01 | AACQU-DELISTED | Stock | 5.87 | 5.87 | 5.87 | 5.87 | 900.0 |
| 2005-08-01 | AACQW-DELISTED | Stock | 0.51 | 0.51 | 0.49 | 0.49 | 15000.0 |
| 2005-08-01 | AAI-DELISTED | Stock | 11.45 | 11.89 | 11.39 | 11.801 | 1340100.0 |
| 2005-08-01 | AAIC-DELISTED | Stock | 282.0 | 282.0 | 273.4 | 276.6 | 1797000.0 |
| 2005-08-01 | AAME | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 2000.0 |
| 2005-08-01 | AAON | Stock | 2.5323 | 2.5626 | 2.506 | 2.5258 | 63787.0 |
| 2005-08-01 | AAP | Stock | 45.98 | 46.38 | 45.96 | 46.0333 | 872550.0 |
| 2005-08-01 | AAXN-DELISTED | Stock | 9.85999965667725 | 9.94999980926514 | 9.64000034332275 | 9.64999961853027 | 1513800.0 |
| 2005-08-01 | ABAX-DELISTED | Stock | 12.52 | 13.2 | 12.47 | 13.15 | 140232.0 |
| 2005-08-01 | ABB-DELISTED | Stock | 6.96 | 7.05 | 6.96 | 7.04 | 1272100.0 |
| 2005-08-01 | ABBC-DELISTED | Stock | 12.6 | 12.65 | 12.5 | 12.61 | 9280.0 |
| 2005-08-01 | ABC-DELISTED | Stock | 17.95 | 18.01 | 17.86 | 17.9 | 3140000.0 |
| 2005-08-01 | ABCB | Stock | 19.4529 | 19.6279 | 19.1805 | 19.375 | 13468.0 |
| 2005-08-01 | ABCO-DELISTED | Stock | 26.24 | 26.96 | 26.14 | 26.6 | 314279.0 |
| 2005-08-01 | ABCW-DELISTED | Stock | 32.0 | 32.73 | 31.75 | 32.25 | 20451.0 |
| 2005-08-01 | ABE-DELISTED | Stock | 10.5 | 10.74 | 10.5 | 10.71 | 25000.0 |
| 2005-08-01 | ABFS-DELISTED | Stock | 34.49 | 34.98 | 34.211 | 34.49 | 269337.0 |
| 2005-08-01 | ABG | Stock | 17.33 | 17.46 | 17.0 | 17.21 | 208300.0 |
| 2005-08-01 | ABK-DELISTED | Stock | 71.75 | 72.14 | 70.75 | 71.39 | 706500.0 |
| 2005-08-01 | ABM | Stock | 19.61 | 19.98 | 19.59 | 19.85 | 99000.0 |
| 2005-08-01 | ABMD-DELISTED | Stock | 9.7 | 9.87 | 9.6 | 9.86 | 35092.0 |
| 2005-08-01 | ABP-DELISTED | Stock | 4.85 | 4.85 | 4.6 | 4.6 | 883100.0 |
| 2005-08-01 | ABR | Stock | 30.85 | 31.04 | 30.6 | 30.72 | 59100.0 |
| 2005-08-01 | ABT | Stock | 22.4786 | 22.6562 | 22.3587 | 22.5602 | 8678616.0 |
| 2005-08-01 | ABTL-DELISTED | Stock | 26.33 | 26.58 | 25.52 | 25.67 | 18727.0 |
| 2005-08-01 | ABV-DELISTED | Stock | 31.09 | 31.68 | 31.02 | 31.34 | 195200.0 |
| 2005-08-01 | ABVA-DELISTED | Stock | 16.5 | 16.5 | 16.0 | 16.0 | 3472.0 |
| 2005-08-01 | ABVT-DELISTED | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 50000.0 |
| 2005-08-01 | ABX-DELISTED | Stock | 24.75 | 24.87 | 24.46 | 24.6 | 713300.0 |
| 2005-08-01 | ACAD | Stock | 9.65 | 9.8 | 9.42 | 9.64 | 42500.0 |
| 2005-08-01 | ACAP-DELISTED | Stock | 39.99 | 40.18 | 39.3 | 39.91 | 61179.0 |
| 2005-08-01 | ACAS-DELISTED | Stock | 37.7 | 37.7 | 37.26 | 37.32 | 673226.0 |
| 2005-08-01 | ACAT-DELISTED | Stock | 21.88 | 22.44 | 21.88 | 22.3 | 60340.0 |
| 2005-08-01 | ACC-DELISTED | Stock | 25.07 | 25.26 | 24.86 | 25.02 | 100576.0 |
| 2005-08-01 | ACCL-DELISTED | Stock | 5.5 | 5.68 | 5.48 | 5.67 | 98042.0 |
| 2005-08-01 | ACE-DELISTED | Stock | 46.48 | 46.48 | 45.89 | 46.25 | 778300.0 |
| 2005-08-01 | ACF-DELISTED | Stock | 26.82 | 27.35 | 26.77 | 26.86 | 876400.0 |
| 2005-08-01 | ACFC-DELISTED | Stock | 70.2 | 70.92 | 70.0 | 70.87 | 893.0 |
| 2005-08-01 | ACG-DELISTED | Stock | 8.37 | 8.39 | 8.36 | 8.37 | 372300.0 |
| 2005-08-01 | ACGL | Stock | 5.0467 | 5.0556 | 4.9444 | 4.9856 | 2513700.0 |
| 2005-08-01 | ACGN-DELISTED | Stock | 555.3288 | 589.3288 | 544.0 | 578.0 | 44600.0 |
> showing 50 of 4,174 rows — these rows as CSV