PREVIEW / stock_daily / 2006-05-22
file: by_date/stock_daily/2006/2006-05-22.parquet size: 148 KB rows: 4,426 symbols: 2,791
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-22 | AAPL | Stock | 2.2811 | 2.2854 | 2.2418 | 2.2636 | 718975600.0 |
| 2006-05-22 | MSFT | Stock | 22.48 | 23.02 | 22.45 | 22.88 | 87322300.0 |
| 2006-05-22 | NVDA | Stock | 0.4033 | 0.4042 | 0.389 | 0.4 | 734886000.0 |
| 2006-05-22 | AMZN | Stock | 1.698 | 1.7495 | 1.659 | 1.7415 | 222458000.0 |
| 2006-05-22 | CL | Stock | 29.74 | 30.185 | 29.735 | 29.995 | 4480600.0 |
| 2006-05-22 | A | Stock | 24.9857 | 25.0143 | 24.4278 | 24.6352 | 4911034.0 |
| 2006-05-22 | AABA-DELISTED | Stock | 30.4200000762939 | 30.9799995422363 | 29.8899993896484 | 30.4599990844727 | 35089300.0 |
| 2006-05-22 | AACC-DELISTED | Stock | 18.48 | 18.52 | 17.41 | 17.53 | 284052.0 |
| 2006-05-22 | AACQ-DELISTED | Stock | 5.34 | 5.34 | 5.34 | 5.34 | 1000.0 |
| 2006-05-22 | AACQU-DELISTED | Stock | 6.6 | 6.6 | 6.5 | 6.5 | 6000.0 |
| 2006-05-22 | AACQW-DELISTED | Stock | 0.6 | 0.61 | 0.6 | 0.6 | 109415.0 |
| 2006-05-22 | AAI-DELISTED | Stock | 12.89 | 13.02 | 12.51 | 12.68 | 2087600.0 |
| 2006-05-22 | AAIC-DELISTED | Stock | 195.2 | 196.398 | 191.4 | 194.4 | 740000.0 |
| 2006-05-22 | AAME | Stock | 2.8 | 3.25 | 2.8 | 2.8 | 3000.0 |
| 2006-05-22 | AAON | Stock | 3.1342 | 3.2487 | 3.0867 | 3.1276 | 109350.0 |
| 2006-05-22 | AAP | Stock | 38.93 | 38.99 | 38.19 | 38.35 | 1444500.0 |
| 2006-05-22 | AATI-DELISTED | Stock | 10.98 | 10.98 | 10.2 | 10.47 | 302852.0 |
| 2006-05-22 | AAU-DELISTED | Stock | 2.45 | 2.5 | 2.13 | 2.5 | 71800.0 |
| 2006-05-22 | AAUAF-DELISTED | Stock | 2.45 | 2.5 | 2.13 | 2.5 | 71800.0 |
| 2006-05-22 | AAV-DELISTED | Stock | 18.12 | 18.78 | 17.51 | 18.71 | 420100.0 |
| 2006-05-22 | AAWW-DELISTED | Stock | 50.5 | 50.5 | 49.0 | 49.0 | 3600.0 |
| 2006-05-22 | AAXN-DELISTED | Stock | 9.43000030517578 | 9.57999992370605 | 9.10000038146973 | 9.17000007629395 | 1289300.0 |
| 2006-05-22 | AB | Stock | 63.5 | 64.94 | 62.6 | 64.5 | 195500.0 |
| 2006-05-22 | ABAX-DELISTED | Stock | 18.1 | 18.19 | 17.05 | 17.73 | 678738.0 |
| 2006-05-22 | ABB-DELISTED | Stock | 12.0 | 12.18 | 11.86 | 12.07 | 6200800.0 |
| 2006-05-22 | ABBC-DELISTED | Stock | 13.9 | 13.99 | 13.63 | 13.68 | 3348.0 |
| 2006-05-22 | ABC-DELISTED | Stock | 21.68 | 22.05 | 21.62 | 21.8 | 3433000.0 |
| 2006-05-22 | ABCB | Stock | 20.8632 | 20.9799 | 20.5908 | 20.9021 | 42462.0 |
| 2006-05-22 | ABCO-DELISTED | Stock | 24.97 | 25.09 | 24.47 | 24.5 | 506938.0 |
| 2006-05-22 | ABCW-DELISTED | Stock | 28.88 | 29.25 | 28.7 | 28.71 | 89150.0 |
| 2006-05-22 | ABD-DELISTED | Stock | 22.9 | 22.9 | 21.92 | 22.1 | 692900.0 |
| 2006-05-22 | ABE-DELISTED | Stock | 12.6 | 12.6 | 12.0101 | 12.25 | 54800.0 |
| 2006-05-22 | ABFS-DELISTED | Stock | 43.0 | 43.54 | 41.3 | 43.33 | 805925.0 |
| 2006-05-22 | ABG | Stock | 19.4 | 19.92 | 19.4 | 19.63 | 55200.0 |
| 2006-05-22 | ABK-DELISTED | Stock | 81.0 | 81.38 | 80.46 | 80.58 | 704000.0 |
| 2006-05-22 | ABM | Stock | 17.44 | 17.71 | 17.16 | 17.61 | 342500.0 |
| 2006-05-22 | ABMD-DELISTED | Stock | 12.0 | 12.3 | 11.8 | 12.12 | 121514.0 |
| 2006-05-22 | ABP-DELISTED | Stock | 4.25 | 4.42 | 4.18 | 4.42 | 405000.0 |
| 2006-05-22 | ABR | Stock | 23.92 | 23.96 | 23.35 | 23.75 | 197400.0 |
| 2006-05-22 | ABT | Stock | 20.0556 | 20.4923 | 20.0077 | 20.0316 | 10409546.0 |
| 2006-05-22 | ABTL-DELISTED | Stock | 17.35 | 17.35 | 15.4 | 15.55 | 69783.0 |
| 2006-05-22 | ABV-DELISTED | Stock | 40.4 | 41.65 | 39.1101 | 40.63 | 1003700.0 |
| 2006-05-22 | ABVA-DELISTED | Stock | 18.8 | 18.8 | 18.8 | 18.8 | 380.0 |
| 2006-05-22 | ABX-DELISTED | Stock | 29.9 | 30.9 | 29.32 | 30.75 | 6671700.0 |
| 2006-05-22 | ACAD | Stock | 10.15 | 10.53 | 10.0 | 10.33 | 278000.0 |
| 2006-05-22 | ACAP-DELISTED | Stock | 45.13 | 45.93 | 44.26 | 45.17 | 111357.0 |
| 2006-05-22 | ACAS-DELISTED | Stock | 34.15 | 34.36 | 33.8 | 34.2 | 1490666.0 |
| 2006-05-22 | ACAT-DELISTED | Stock | 19.26 | 19.86 | 18.86 | 19.57 | 38279.0 |
| 2006-05-22 | ACC-DELISTED | Stock | 23.0 | 23.54 | 22.82 | 23.52 | 113100.0 |
| 2006-05-22 | ACCL-DELISTED | Stock | 6.52 | 6.77 | 6.44 | 6.49 | 298409.0 |
> showing 50 of 4,426 rows — these rows as CSV