PREVIEW / stock_daily / 2009-05-21
file: by_date/stock_daily/2009/2009-05-21.parquet size: 179 KB rows: 5,766 symbols: 3,444
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 |
|---|---|---|---|---|---|---|---|
| 2009-05-21 | AAPL | Stock | 4.4696 | 4.5279 | 4.3889 | 4.435 | 407946000.0 |
| 2009-05-21 | MSFT | Stock | 20.14 | 20.23 | 19.51 | 19.82 | 58232800.0 |
| 2009-05-21 | NVDA | Stock | 0.2402 | 0.245 | 0.235 | 0.2418 | 965600000.0 |
| 2009-05-21 | AMZN | Stock | 3.8375 | 3.8985 | 3.77 | 3.798 | 112810000.0 |
| 2009-05-21 | TLT | Stock | 97.55 | 97.64 | 94.35 | 94.58 | 4771832.0 |
| 2009-05-21 | ES | Stock | 19.83 | 20.26 | 19.78 | 20.22 | 2274900.0 |
| 2009-05-21 | CL | Stock | 31.6 | 31.96 | 31.375 | 31.95 | 7062800.0 |
| 2009-05-21 | A | Stock | 13.0329 | 13.1545 | 12.5107 | 12.6466 | 4439908.0 |
| 2009-05-21 | AABA-DELISTED | Stock | 14.92 | 15.12 | 14.6207 | 14.87 | 15153653.0 |
| 2009-05-21 | AACC-DELISTED | Stock | 7.28 | 7.46 | 6.91 | 7.02 | 43199.0 |
| 2009-05-21 | AACG | Stock | 4.95 | 5.2 | 4.95 | 5.18 | 32300.0 |
| 2009-05-21 | AAI-DELISTED | Stock | 5.89 | 6.14 | 5.75 | 5.96 | 4806013.0 |
| 2009-05-21 | AAIC-DELISTED | Stock | 8.6 | 9.4 | 8.4 | 8.4 | 558716.0 |
| 2009-05-21 | AAME | Stock | 0.7 | 0.7 | 0.7 | 0.7 | 5100.0 |
| 2009-05-21 | AAON | Stock | 4.0889 | 4.1541 | 4.0435 | 4.1422 | 394369.0 |
| 2009-05-21 | AAP | Stock | 42.53 | 43.16 | 41.5 | 42.77 | 4158700.0 |
| 2009-05-21 | AATI-DELISTED | Stock | 4.43 | 4.48 | 4.18 | 4.37 | 202128.0 |
| 2009-05-21 | AAU-DELISTED | Stock | 0.65 | 0.69 | 0.6401 | 0.67 | 161992.0 |
| 2009-05-21 | AAUAF-DELISTED | Stock | 0.65 | 0.69 | 0.6401 | 0.67 | 165392.0 |
| 2009-05-21 | AAV-DELISTED | Stock | 3.98 | 4.07 | 3.87 | 4.06 | 1087658.0 |
| 2009-05-21 | AAWW-DELISTED | Stock | 23.0 | 23.1494 | 22.12 | 22.4875 | 544876.0 |
| 2009-05-21 | AAXJ | Stock | 42.58 | 42.66 | 42.04 | 42.58 | 388696.0 |
| 2009-05-21 | AAXN-DELISTED | Stock | 4.12 | 4.22 | 4.08 | 4.12 | 351072.0 |
| 2009-05-21 | AB | Stock | 17.5 | 18.36 | 17.26 | 18.27 | 825700.0 |
| 2009-05-21 | ABAX-DELISTED | Stock | 16.87 | 17.18 | 16.588 | 17.04 | 194898.0 |
| 2009-05-21 | ABB-DELISTED | Stock | 15.86 | 16.16 | 15.59 | 15.74 | 4686994.0 |
| 2009-05-21 | ABBC-DELISTED | Stock | 8.06 | 8.33 | 7.8 | 8.13 | 101108.0 |
| 2009-05-21 | ABBNY-DELISTED | Stock | 15.86 | 16.16 | 15.59 | 15.7 | 4694598.0 |
| 2009-05-21 | ABC-DELISTED | Stock | 18.36 | 18.58 | 18.06 | 18.18 | 3238474.0 |
| 2009-05-21 | ABCB | Stock | 6.2152 | 6.3319 | 5.9428 | 6.0109 | 23030.0 |
| 2009-05-21 | ABCO-DELISTED | Stock | 11.495 | 11.525 | 11.13 | 11.5 | 240440.0 |
| 2009-05-21 | ABCW-DELISTED | Stock | 1.65 | 1.73 | 1.47 | 1.47 | 119290.0 |
| 2009-05-21 | ABD-DELISTED | Stock | 2.91 | 3.04 | 2.6932 | 2.78 | 244600.0 |
| 2009-05-21 | ABE-DELISTED | Stock | 14.98 | 14.98 | 14.6301 | 14.8 | 5071.0 |
| 2009-05-21 | ABEO | Stock | 1725.0 | 2000.0 | 1550.0 | 1562.5 | 17.0 |
| 2009-05-21 | ABFS-DELISTED | Stock | 27.24 | 27.24 | 26.19 | 26.52 | 645751.0 |
| 2009-05-21 | ABG | Stock | 9.85 | 10.11 | 9.38 | 9.93 | 506700.0 |
| 2009-05-21 | ABII-DELISTED | Stock | 49.35 | 49.35 | 46.5 | 47.46 | 28340.0 |
| 2009-05-21 | ABK-DELISTED | Stock | 1.3 | 1.34 | 1.26 | 1.32 | 6261669.0 |
| 2009-05-21 | ABM | Stock | 15.91 | 16.1 | 15.75 | 16.04 | 215200.0 |
| 2009-05-21 | ABMD-DELISTED | Stock | 5.6 | 6.06 | 5.57 | 5.77 | 315471.0 |
| 2009-05-21 | ABR | Stock | 1.93 | 1.95 | 1.75 | 1.81 | 298200.0 |
| 2009-05-21 | ABT | Stock | 20.6362 | 20.8377 | 20.5354 | 20.7849 | 13163818.0 |
| 2009-05-21 | ABTL-DELISTED | Stock | 2.3497 | 2.4003 | 2.3497 | 2.4003 | 12664.0 |
| 2009-05-21 | ABV-DELISTED | Stock | 61.46 | 62.34 | 61.22 | 62.14 | 360253.0 |
| 2009-05-21 | ABVA-DELISTED | Stock | 3.5 | 3.77 | 3.4001 | 3.4234 | 773.0 |
| 2009-05-21 | ABVT-DELISTED | Stock | 58.0 | 61.0 | 58.0 | 60.5 | 183992.0 |
| 2009-05-21 | ABX-DELISTED | Stock | 36.13 | 37.41 | 35.33 | 36.91 | 13072023.0 |
| 2009-05-21 | ACAD | Stock | 1.82 | 1.88 | 1.71 | 1.85 | 344200.0 |
| 2009-05-21 | ACAP-DELISTED | Stock | 36.42 | 37.8757 | 36.19 | 37.66 | 51902.0 |
> showing 50 of 5,766 rows — these rows as CSV