PREVIEW / stock_daily / 2005-05-09
file: by_date/stock_daily/2005/2005-05-09.parquet size: 135 KB rows: 4,040 symbols: 2,527
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-05-09 | AAPL | Stock | 1.3314 | 1.3375 | 1.3125 | 1.3204 | 355695200.0 |
| 2005-05-09 | MSFT | Stock | 25.23 | 25.33 | 25.05 | 25.11 | 61872400.0 |
| 2005-05-09 | NVDA | Stock | 0.1939 | 0.198 | 0.1927 | 0.1967 | 745332000.0 |
| 2005-05-09 | AMZN | Stock | 1.72 | 1.74 | 1.7125 | 1.732 | 88632000.0 |
| 2005-05-09 | CL | Stock | 24.625 | 24.64 | 24.46 | 24.495 | 5998200.0 |
| 2005-05-09 | A | Stock | 15.3076 | 15.7225 | 15.2432 | 15.6581 | 2781041.0 |
| 2005-05-09 | AABA-DELISTED | Stock | 34.4799995422363 | 34.6500015258789 | 34.25 | 34.5900001525879 | 9991700.0 |
| 2005-05-09 | AACC-DELISTED | Stock | 21.69 | 22.1 | 21.67 | 21.81 | 193225.0 |
| 2005-05-09 | AACQW-DELISTED | Stock | 0.62 | 0.62 | 0.6 | 0.6 | 52500.0 |
| 2005-05-09 | AAI-DELISTED | Stock | 8.28 | 8.42 | 8.18 | 8.37 | 626400.0 |
| 2005-05-09 | AAIC-DELISTED | Stock | 250.0 | 257.8 | 249.6 | 257.2 | 2395400.0 |
| 2005-05-09 | AAON | Stock | 2.2756 | 2.3783 | 2.2703 | 2.2979 | 151116.0 |
| 2005-05-09 | AAP | Stock | 36.7 | 36.8533 | 36.2933 | 36.4867 | 749550.0 |
| 2005-05-09 | AAV-DELISTED | Stock | 14.81 | 14.85 | 13.72 | 14.81 | 59600.0 |
| 2005-05-09 | AAXN-DELISTED | Stock | 9.35000038146973 | 11.0299997329712 | 9.35000038146973 | 10.9399995803833 | 12998400.0 |
| 2005-05-09 | ABAX-DELISTED | Stock | 10.09 | 10.2 | 9.87 | 10.18 | 83096.0 |
| 2005-05-09 | ABB-DELISTED | Stock | 6.37 | 6.45 | 6.35 | 6.44 | 1544400.0 |
| 2005-05-09 | ABBC-DELISTED | Stock | 10.92 | 11.24 | 10.92 | 11.15 | 27539.0 |
| 2005-05-09 | ABC-DELISTED | Stock | 15.74 | 16.0 | 15.73 | 16.0 | 4172400.0 |
| 2005-05-09 | ABCB | Stock | 17.9064 | 17.9744 | 17.4297 | 17.6535 | 11823.0 |
| 2005-05-09 | ABCO-DELISTED | Stock | 22.22 | 22.29 | 21.26 | 22.03 | 447938.0 |
| 2005-05-09 | ABCW-DELISTED | Stock | 27.16 | 27.26 | 26.8 | 27.25 | 18630.0 |
| 2005-05-09 | ABE-DELISTED | Stock | 9.6 | 9.6 | 9.57 | 9.58 | 13800.0 |
| 2005-05-09 | ABFS-DELISTED | Stock | 32.7 | 33.2 | 32.61 | 33.1 | 178080.0 |
| 2005-05-09 | ABG | Stock | 14.09 | 14.12 | 13.99 | 14.12 | 26800.0 |
| 2005-05-09 | ABK-DELISTED | Stock | 71.05 | 71.76 | 70.65 | 71.75 | 646300.0 |
| 2005-05-09 | ABM | Stock | 18.67 | 18.88 | 18.47 | 18.88 | 63400.0 |
| 2005-05-09 | ABMD-DELISTED | Stock | 9.38 | 9.44 | 9.19 | 9.41 | 74672.0 |
| 2005-05-09 | ABP-DELISTED | Stock | 2.49 | 2.53 | 2.46 | 2.5 | 39400.0 |
| 2005-05-09 | ABR | Stock | 26.11 | 26.42 | 26.11 | 26.31 | 66800.0 |
| 2005-05-09 | ABT | Stock | 23.491 | 23.5726 | 23.3903 | 23.5438 | 5040434.0 |
| 2005-05-09 | ABTL-DELISTED | Stock | 23.75 | 24.5 | 23.05 | 24.45 | 16300.0 |
| 2005-05-09 | ABV-DELISTED | Stock | 28.67 | 28.94 | 28.56 | 28.82 | 350300.0 |
| 2005-05-09 | ABVA-DELISTED | Stock | 15.25 | 15.25 | 15.22 | 15.22 | 1700.0 |
| 2005-05-09 | ABX-DELISTED | Stock | 23.14 | 23.25 | 22.95 | 23.12 | 890400.0 |
| 2005-05-09 | ACAD | Stock | 7.39 | 7.4 | 7.38 | 7.4 | 5100.0 |
| 2005-05-09 | ACAP-DELISTED | Stock | 34.14 | 34.68 | 33.75 | 34.35 | 72117.0 |
| 2005-05-09 | ACAS-DELISTED | Stock | 34.1 | 34.39 | 33.84 | 34.33 | 958716.0 |
| 2005-05-09 | ACAT-DELISTED | Stock | 24.12 | 24.71 | 24.12 | 24.47 | 52231.0 |
| 2005-05-09 | ACC-DELISTED | Stock | 20.61 | 20.75 | 20.61 | 20.75 | 12800.0 |
| 2005-05-09 | ACCL-DELISTED | Stock | 5.58 | 5.95 | 5.52 | 5.81 | 178996.0 |
| 2005-05-09 | ACE-DELISTED | Stock | 43.39 | 43.78 | 43.31 | 43.74 | 636300.0 |
| 2005-05-09 | ACF-DELISTED | Stock | 23.64 | 23.96 | 23.5 | 23.94 | 1533400.0 |
| 2005-05-09 | ACFC-DELISTED | Stock | 57.35 | 58.67 | 57.35 | 58.67 | 1142.0 |
| 2005-05-09 | ACG-DELISTED | Stock | 8.07 | 8.1 | 8.03 | 8.06 | 468100.0 |
| 2005-05-09 | ACGL | Stock | 4.4767 | 4.4889 | 4.4311 | 4.4611 | 1895400.0 |
| 2005-05-09 | ACGN-DELISTED | Stock | 657.3288 | 668.6712 | 634.6712 | 646.0 | 43400.0 |
| 2005-05-09 | ACH | Stock | 20.1933 | 20.34 | 19.7867 | 20.34 | 238200.0 |
| 2005-05-09 | ACH-DELISTED | Stock | 13.65 | 13.677 | 13.513 | 13.563 | 167340.0 |
| 2005-05-09 | ACLS | Stock | 23.76 | 24.12 | 23.56 | 23.96 | 193375.0 |
> showing 50 of 4,040 rows — these rows as CSV