PREVIEW / stock_daily / 2006-05-12
file: by_date/stock_daily/2006/2006-05-12.parquet size: 148 KB rows: 4,417 symbols: 2,792
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-12 | AAPL | Stock | 2.4232 | 2.4532 | 2.3879 | 2.4179 | 641774000.0 |
| 2006-05-12 | MSFT | Stock | 23.14 | 23.37 | 23.05 | 23.17 | 83115900.0 |
| 2006-05-12 | NVDA | Stock | 0.4632 | 0.4655 | 0.429 | 0.4388 | 1568172000.0 |
| 2006-05-12 | AMZN | Stock | 1.678 | 1.689 | 1.6275 | 1.6365 | 97472000.0 |
| 2006-05-12 | CL | Stock | 29.565 | 29.79 | 29.51 | 29.62 | 5469600.0 |
| 2006-05-12 | A | Stock | 27.5036 | 27.5751 | 26.5951 | 26.6452 | 4735026.0 |
| 2006-05-12 | AABA-DELISTED | Stock | 30.7099990844727 | 31.1800003051758 | 30.3799991607666 | 30.8099994659424 | 16745600.0 |
| 2006-05-12 | AACC-DELISTED | Stock | 18.9 | 19.05 | 18.79 | 18.92 | 151615.0 |
| 2006-05-12 | AACQW-DELISTED | Stock | 0.7 | 0.7 | 0.695 | 0.695 | 30900.0 |
| 2006-05-12 | AAI-DELISTED | Stock | 13.5 | 13.8 | 13.24 | 13.25 | 1423000.0 |
| 2006-05-12 | AAIC-DELISTED | Stock | 208.8 | 210.0 | 202.6 | 204.6 | 1007500.0 |
| 2006-05-12 | AAME | Stock | 2.95 | 3.45 | 2.95 | 2.95 | 39500.0 |
| 2006-05-12 | AAON | Stock | 3.5556 | 3.5556 | 3.4568 | 3.4594 | 423731.0 |
| 2006-05-12 | AAP | Stock | 40.38 | 40.6 | 40.25 | 40.28 | 1115700.0 |
| 2006-05-12 | AATI-DELISTED | Stock | 10.78 | 11.25 | 10.55 | 11.25 | 226757.0 |
| 2006-05-12 | AAU-DELISTED | Stock | 3.15 | 3.17 | 2.82 | 2.9 | 174300.0 |
| 2006-05-12 | AAUAF-DELISTED | Stock | 3.15 | 3.17 | 2.82 | 2.9 | 174300.0 |
| 2006-05-12 | AAV-DELISTED | Stock | 19.59 | 19.59 | 19.35 | 19.42 | 267400.0 |
| 2006-05-12 | AAWW-DELISTED | Stock | 50.75 | 50.75 | 50.75 | 50.75 | 24000.0 |
| 2006-05-12 | AAXN-DELISTED | Stock | 9.77000045776367 | 9.78999996185303 | 9.13000011444092 | 9.4399995803833 | 3583200.0 |
| 2006-05-12 | AB | Stock | 66.24 | 66.99 | 64.75 | 65.6 | 341400.0 |
| 2006-05-12 | ABAX-DELISTED | Stock | 19.88 | 19.91 | 18.23 | 18.52 | 1188101.0 |
| 2006-05-12 | ABB-DELISTED | Stock | 14.58 | 14.59 | 14.01 | 14.2 | 2648300.0 |
| 2006-05-12 | ABC-DELISTED | Stock | 22.0 | 22.07 | 21.92 | 21.99 | 2152800.0 |
| 2006-05-12 | ABCB | Stock | 20.0364 | 20.4061 | 19.8516 | 20.0754 | 20769.0 |
| 2006-05-12 | ABCO-DELISTED | Stock | 26.36 | 26.45 | 25.69 | 25.97 | 199687.0 |
| 2006-05-12 | ABCW-DELISTED | Stock | 28.66 | 28.81 | 28.6 | 28.62 | 89940.0 |
| 2006-05-12 | ABD-DELISTED | Stock | 23.25 | 23.38 | 22.87 | 23.11 | 511840.0 |
| 2006-05-12 | ABE-DELISTED | Stock | 13.8 | 13.95 | 13.38 | 13.6 | 36900.0 |
| 2006-05-12 | ABFS-DELISTED | Stock | 45.27 | 45.35 | 43.34 | 43.38 | 290712.0 |
| 2006-05-12 | ABG | Stock | 19.67 | 20.12 | 19.51 | 19.66 | 57800.0 |
| 2006-05-12 | ABK-DELISTED | Stock | 83.16 | 83.63 | 82.6 | 82.61 | 1004100.0 |
| 2006-05-12 | ABM | Stock | 17.1 | 17.22 | 17.07 | 17.16 | 188600.0 |
| 2006-05-12 | ABMD-DELISTED | Stock | 12.6 | 12.68 | 11.96 | 12.3028 | 118933.0 |
| 2006-05-12 | ABP-DELISTED | Stock | 5.5 | 5.5 | 5.12 | 5.18 | 621200.0 |
| 2006-05-12 | ABR | Stock | 24.51 | 24.76 | 24.25 | 24.49 | 93000.0 |
| 2006-05-12 | ABT | Stock | 20.1516 | 20.2044 | 19.8685 | 19.8733 | 7684243.0 |
| 2006-05-12 | ABTL-DELISTED | Stock | 18.125 | 18.574 | 17.875 | 17.975 | 83839.0 |
| 2006-05-12 | ABV-DELISTED | Stock | 46.2 | 46.51 | 44.87 | 45.82 | 521800.0 |
| 2006-05-12 | ABVA-DELISTED | Stock | 18.85 | 18.85 | 18.7 | 18.7 | 1400.0 |
| 2006-05-12 | ABX-DELISTED | Stock | 34.55 | 34.83 | 32.91 | 33.6 | 6410400.0 |
| 2006-05-12 | ACAD | Stock | 11.03 | 11.21 | 10.62 | 10.86 | 310100.0 |
| 2006-05-12 | ACAP-DELISTED | Stock | 45.25 | 45.25 | 44.28 | 44.4 | 90421.0 |
| 2006-05-12 | ACAS-DELISTED | Stock | 34.25 | 34.58 | 34.0 | 34.12 | 1382623.0 |
| 2006-05-12 | ACAT-DELISTED | Stock | 18.59 | 19.47 | 18.13 | 19.01 | 203302.0 |
| 2006-05-12 | ACC-DELISTED | Stock | 24.0 | 24.0 | 22.97 | 23.36 | 92100.0 |
| 2006-05-12 | ACCL-DELISTED | Stock | 7.0 | 7.18 | 6.93 | 7.14 | 77292.0 |
| 2006-05-12 | ACCO | Stock | 23.25 | 23.38 | 22.87 | 23.11 | 512400.0 |
| 2006-05-12 | ACCP-DELISTED | Stock | 1.3 | 1.3 | 1.2 | 1.25 | 81542.0 |
| 2006-05-12 | ACE-DELISTED | Stock | 53.61 | 53.9 | 52.98 | 52.99 | 836577.0 |
> showing 50 of 4,417 rows — these rows as CSV