PREVIEW / stock_daily / 2005-03-23
file: by_date/stock_daily/2005/2005-03-23.parquet size: 135 KB rows: 4,037 symbols: 2,539
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-03-23 | AAPL | Stock | 1.5161 | 1.55 | 1.5007 | 1.5196 | 609823200.0 |
| 2005-03-23 | MSFT | Stock | 23.99 | 24.39 | 23.96 | 24.18 | 79293300.0 |
| 2005-03-23 | NVDA | Stock | 0.2043 | 0.2104 | 0.2039 | 0.209 | 728784000.0 |
| 2005-03-23 | AMZN | Stock | 1.6545 | 1.692 | 1.641 | 1.659 | 126474000.0 |
| 2005-03-23 | CL | Stock | 25.3 | 26.205 | 25.3 | 26.065 | 5533600.0 |
| 2005-03-23 | A | Stock | 16.166 | 16.2375 | 16.0944 | 16.1159 | 3152770.0 |
| 2005-03-23 | AABA-DELISTED | Stock | 30.9099998474121 | 31.3299999237061 | 30.8500003814697 | 30.8700008392334 | 13917100.0 |
| 2005-03-23 | AACC-DELISTED | Stock | 19.99 | 20.13 | 19.65 | 19.76 | 45811.0 |
| 2005-03-23 | AACQ-DELISTED | Stock | 5.15 | 5.2 | 5.15 | 5.15 | 1800.0 |
| 2005-03-23 | AACQU-DELISTED | Stock | 6.44 | 6.45 | 6.44 | 6.45 | 4000.0 |
| 2005-03-23 | AACQW-DELISTED | Stock | 0.65 | 0.68 | 0.65 | 0.67 | 16500.0 |
| 2005-03-23 | AAI-DELISTED | Stock | 8.79 | 9.2 | 8.59 | 9.1 | 2151200.0 |
| 2005-03-23 | AAIC-DELISTED | Stock | 321.0 | 327.0 | 313.8 | 313.8 | 2303600.0 |
| 2005-03-23 | AAME | Stock | 3.08 | 3.16 | 3.08 | 3.13 | 1700.0 |
| 2005-03-23 | AAON | Stock | 2.1149 | 2.1307 | 2.107 | 2.1149 | 427528.0 |
| 2005-03-23 | AAP | Stock | 32.6133 | 32.8667 | 32.5533 | 32.6867 | 924450.0 |
| 2005-03-23 | AAV-DELISTED | Stock | 17.08 | 17.08 | 16.55 | 16.55 | 136600.0 |
| 2005-03-23 | AAXN-DELISTED | Stock | 12.4300003051758 | 12.6000003814697 | 12.0200004577637 | 12.0799999237061 | 2869500.0 |
| 2005-03-23 | ABAX-DELISTED | Stock | 9.17 | 9.24 | 9.05 | 9.08 | 125991.0 |
| 2005-03-23 | ABB-DELISTED | Stock | 6.4 | 6.5 | 6.36 | 6.45 | 2611800.0 |
| 2005-03-23 | ABBC-DELISTED | Stock | 13.25 | 13.26 | 13.06 | 13.07 | 11350.0 |
| 2005-03-23 | ABC-DELISTED | Stock | 15.16 | 15.44 | 15.08 | 15.4 | 2719200.0 |
| 2005-03-23 | ABCB | Stock | 17.6729 | 18.0425 | 17.1477 | 17.2936 | 29919.0 |
| 2005-03-23 | ABCO-DELISTED | Stock | 21.82 | 21.92 | 21.5 | 21.71 | 459483.0 |
| 2005-03-23 | ABCW-DELISTED | Stock | 28.07 | 28.1 | 27.98 | 28.0 | 70870.0 |
| 2005-03-23 | ABE-DELISTED | Stock | 9.45 | 9.53 | 9.39 | 9.53 | 19200.0 |
| 2005-03-23 | ABFS-DELISTED | Stock | 40.86 | 40.93 | 38.89 | 39.5 | 737186.0 |
| 2005-03-23 | ABG | Stock | 14.81 | 14.91 | 14.51 | 14.57 | 44900.0 |
| 2005-03-23 | ABK-DELISTED | Stock | 74.54 | 75.89 | 74.3 | 75.3 | 652600.0 |
| 2005-03-23 | ABM | Stock | 19.27 | 19.44 | 19.12 | 19.21 | 164600.0 |
| 2005-03-23 | ABMD-DELISTED | Stock | 10.43 | 10.43 | 10.138 | 10.26 | 51913.0 |
| 2005-03-23 | ABP-DELISTED | Stock | 2.58 | 2.7 | 2.45 | 2.7 | 264100.0 |
| 2005-03-23 | ABR | Stock | 25.75 | 25.75 | 24.99 | 24.99 | 55400.0 |
| 2005-03-23 | ABT | Stock | 20.9385 | 21.5334 | 20.9385 | 21.3991 | 8553147.0 |
| 2005-03-23 | ABTL-DELISTED | Stock | 26.8 | 26.8 | 25.65 | 26.05 | 32600.0 |
| 2005-03-23 | ABV-DELISTED | Stock | 27.9 | 27.95 | 27.52 | 27.52 | 1019600.0 |
| 2005-03-23 | ABVA-DELISTED | Stock | 16.0 | 16.0 | 15.8 | 15.82 | 1520.0 |
| 2005-03-23 | ABX-DELISTED | Stock | 23.98 | 24.0 | 23.62 | 23.66 | 2199087.0 |
| 2005-03-23 | ACAD | Stock | 7.01 | 7.19 | 6.92 | 7.19 | 7100.0 |
| 2005-03-23 | ACAP-DELISTED | Stock | 34.22 | 34.65 | 33.75 | 33.99 | 63104.0 |
| 2005-03-23 | ACAS-DELISTED | Stock | 31.54 | 31.59 | 31.25 | 31.25 | 3665994.0 |
| 2005-03-23 | ACAT-DELISTED | Stock | 28.15 | 28.24 | 28.01 | 28.02 | 48724.0 |
| 2005-03-23 | ACC-DELISTED | Stock | 21.55 | 21.55 | 20.67 | 20.7 | 72300.0 |
| 2005-03-23 | ACCL-DELISTED | Stock | 5.11 | 5.25 | 5.09 | 5.22 | 66667.0 |
| 2005-03-23 | ACE-DELISTED | Stock | 41.92 | 42.34 | 41.83 | 41.83 | 1649074.0 |
| 2005-03-23 | ACF-DELISTED | Stock | 23.7 | 23.74 | 22.79 | 23.53 | 1575000.0 |
| 2005-03-23 | ACFC-DELISTED | Stock | 66.07 | 66.33 | 64.85 | 64.85 | 2936.0 |
| 2005-03-23 | ACG-DELISTED | Stock | 8.09 | 8.1 | 7.89 | 8.02 | 1154000.0 |
| 2005-03-23 | ACGL | Stock | 4.39 | 4.4544 | 4.39 | 4.4078 | 440100.0 |
| 2005-03-23 | ACGN-DELISTED | Stock | 680.0 | 736.6712 | 668.6712 | 736.6712 | 193500.0 |
> showing 50 of 4,037 rows — these rows as CSV