PREVIEW / stock_daily / 2009-05-18
file: by_date/stock_daily/2009/2009-05-18.parquet size: 179 KB rows: 5,758 symbols: 3,425
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-18 | AAPL | Stock | 4.4189 | 4.525 | 4.3418 | 4.5232 | 458841600.0 |
| 2009-05-18 | MSFT | Stock | 20.36 | 20.6 | 20.24 | 20.6 | 46073800.0 |
| 2009-05-18 | NVDA | Stock | 0.224 | 0.2332 | 0.2235 | 0.2318 | 938320000.0 |
| 2009-05-18 | AMZN | Stock | 3.698 | 3.798 | 3.655 | 3.7975 | 136582000.0 |
| 2009-05-18 | TLT | Stock | 98.01 | 98.11 | 96.37 | 96.52 | 2234609.0 |
| 2009-05-18 | ES | Stock | 20.72 | 21.0 | 20.33 | 20.62 | 1097200.0 |
| 2009-05-18 | CL | Stock | 32.025 | 32.24 | 31.785 | 32.24 | 6383200.0 |
| 2009-05-18 | A | Stock | 12.6037 | 12.7825 | 12.3748 | 12.7825 | 3707216.0 |
| 2009-05-18 | AABA-DELISTED | Stock | 15.11 | 15.17 | 14.74 | 15.13 | 18264737.0 |
| 2009-05-18 | AACC-DELISTED | Stock | 8.1 | 8.47 | 7.84 | 8.45 | 38088.0 |
| 2009-05-18 | AACG | Stock | 5.15 | 5.2 | 5.0 | 5.0 | 27100.0 |
| 2009-05-18 | AAI-DELISTED | Stock | 6.47 | 6.67 | 6.25 | 6.61 | 1838810.0 |
| 2009-05-18 | AAIC-DELISTED | Stock | 8.56 | 9.4 | 8.56 | 8.8 | 444681.0 |
| 2009-05-18 | AAON | Stock | 4.0079 | 4.1244 | 3.9743 | 4.1047 | 468787.0 |
| 2009-05-18 | AAP | Stock | 41.12 | 42.04 | 40.43 | 41.97 | 1757300.0 |
| 2009-05-18 | AATI-DELISTED | Stock | 4.66 | 4.765 | 4.51 | 4.7 | 356425.0 |
| 2009-05-18 | AAU-DELISTED | Stock | 0.6 | 0.62 | 0.59 | 0.61 | 56915.0 |
| 2009-05-18 | AAUAF-DELISTED | Stock | 0.6 | 0.62 | 0.59 | 0.61 | 58915.0 |
| 2009-05-18 | AAV-DELISTED | Stock | 3.41 | 3.59 | 3.4 | 3.46 | 894313.0 |
| 2009-05-18 | AAWW-DELISTED | Stock | 23.92 | 24.96 | 23.92 | 24.85 | 434328.0 |
| 2009-05-18 | AAXJ | Stock | 41.91 | 43.76 | 41.91 | 43.37 | 417097.0 |
| 2009-05-18 | AAXN-DELISTED | Stock | 4.21 | 4.39 | 4.19 | 4.38 | 364627.0 |
| 2009-05-18 | AB | Stock | 17.1 | 17.98 | 16.92 | 17.82 | 593900.0 |
| 2009-05-18 | ABAX-DELISTED | Stock | 16.32 | 17.1 | 16.29 | 17.01 | 335460.0 |
| 2009-05-18 | ABB-DELISTED | Stock | 15.15 | 15.55 | 15.02 | 15.52 | 3495274.0 |
| 2009-05-18 | ABBC-DELISTED | Stock | 8.4 | 8.63 | 8.25 | 8.61 | 66128.0 |
| 2009-05-18 | ABBNY-DELISTED | Stock | 15.15 | 15.55 | 15.02 | 15.5 | 3599413.0 |
| 2009-05-18 | ABC-DELISTED | Stock | 17.59 | 17.79 | 17.32 | 17.77 | 2311326.0 |
| 2009-05-18 | ABCB | Stock | 5.8067 | 6.8377 | 5.8067 | 6.507 | 43695.0 |
| 2009-05-18 | ABCO-DELISTED | Stock | 11.16 | 11.61 | 10.995 | 11.485 | 147008.0 |
| 2009-05-18 | ABCW-DELISTED | Stock | 1.64 | 1.7 | 1.64 | 1.68 | 61640.0 |
| 2009-05-18 | ABD-DELISTED | Stock | 2.6451 | 3.2509 | 2.6451 | 3.16 | 355340.0 |
| 2009-05-18 | ABE-DELISTED | Stock | 14.11 | 14.85 | 14.11 | 14.85 | 16633.0 |
| 2009-05-18 | ABEO | Stock | 1625.0 | 1875.0 | 1600.0 | 1875.0 | 16.0 |
| 2009-05-18 | ABFS-DELISTED | Stock | 24.64 | 25.86 | 24.44 | 25.73 | 760243.0 |
| 2009-05-18 | ABG | Stock | 8.74 | 11.0 | 8.74 | 10.86 | 912400.0 |
| 2009-05-18 | ABII-DELISTED | Stock | 51.56 | 51.56 | 47.51 | 49.93 | 24738.0 |
| 2009-05-18 | ABK-DELISTED | Stock | 1.4 | 1.47 | 1.35 | 1.41 | 9398484.0 |
| 2009-05-18 | ABM | Stock | 16.57 | 16.63 | 16.37 | 16.48 | 185700.0 |
| 2009-05-18 | ABMD-DELISTED | Stock | 6.19 | 6.4 | 5.8801 | 6.36 | 550153.0 |
| 2009-05-18 | ABR | Stock | 1.99 | 1.99 | 1.73 | 1.93 | 207800.0 |
| 2009-05-18 | ABT | Stock | 20.9145 | 21.0296 | 20.5738 | 20.7274 | 21061901.0 |
| 2009-05-18 | ABTL-DELISTED | Stock | 2.2233 | 2.3 | 2.2233 | 2.3 | 2841.0 |
| 2009-05-18 | ABV-DELISTED | Stock | 59.04 | 61.26 | 59.04 | 61.04 | 374955.0 |
| 2009-05-18 | ABVA-DELISTED | Stock | 2.8999 | 2.99 | 2.8 | 2.97 | 11766.0 |
| 2009-05-18 | ABVT-DELISTED | Stock | 56.0 | 58.5 | 55.0 | 57.865 | 22200.0 |
| 2009-05-18 | ABX-DELISTED | Stock | 33.58 | 33.91 | 32.46 | 33.46 | 5963532.0 |
| 2009-05-18 | ACAD | Stock | 1.65 | 1.76 | 1.61 | 1.69 | 227400.0 |
| 2009-05-18 | ACAP-DELISTED | Stock | 38.27 | 38.28 | 37.52 | 38.2 | 85834.0 |
| 2009-05-18 | ACAS-DELISTED | Stock | 3.155 | 3.45 | 3.145 | 3.45 | 6091092.0 |
> showing 50 of 5,758 rows — these rows as CSV