PREVIEW / stock_daily / 2009-08-17
file: by_date/stock_daily/2009/2009-08-17.parquet size: 182 KB rows: 5,812 symbols: 3,463
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-08-17 | AAPL | Stock | 5.8411 | 5.8425 | 5.6936 | 5.6996 | 524381200.0 |
| 2009-08-17 | MSFT | Stock | 23.32 | 23.6 | 23.23 | 23.25 | 42474400.0 |
| 2009-08-17 | NVDA | Stock | 0.3253 | 0.3263 | 0.318 | 0.3215 | 465032000.0 |
| 2009-08-17 | AMZN | Stock | 4.058 | 4.089 | 4.0125 | 4.053 | 137772000.0 |
| 2009-08-17 | TLT | Stock | 93.95 | 94.75 | 93.87 | 94.73 | 3570338.0 |
| 2009-08-17 | ES | Stock | 23.62 | 23.64 | 23.31 | 23.63 | 1165300.0 |
| 2009-08-17 | CL | Stock | 35.445 | 35.74 | 35.355 | 35.67 | 3826600.0 |
| 2009-08-17 | A | Stock | 17.0815 | 17.103 | 16.6524 | 16.8526 | 5681192.0 |
| 2009-08-17 | AABA-DELISTED | Stock | 14.69 | 14.78 | 14.51 | 14.52 | 25385809.0 |
| 2009-08-17 | AACC-DELISTED | Stock | 7.1 | 7.46 | 7.1 | 7.34 | 19626.0 |
| 2009-08-17 | AACG | Stock | 7.41 | 7.49 | 7.3 | 7.3 | 6400.0 |
| 2009-08-17 | AAI-DELISTED | Stock | 6.55 | 6.56 | 6.35 | 6.36 | 1700018.0 |
| 2009-08-17 | AAIC-DELISTED | Stock | 9.2 | 9.2 | 8.4 | 8.6 | 493451.0 |
| 2009-08-17 | AAON | Stock | 4.2074 | 4.2449 | 4.1679 | 4.2133 | 444994.0 |
| 2009-08-17 | AAP | Stock | 42.37 | 43.5 | 42.19 | 43.07 | 1646700.0 |
| 2009-08-17 | AATI-DELISTED | Stock | 4.63 | 4.63 | 4.43 | 4.47 | 220841.0 |
| 2009-08-17 | AAU-DELISTED | Stock | 0.64 | 0.64 | 0.6 | 0.61 | 55100.0 |
| 2009-08-17 | AAUAF-DELISTED | Stock | 0.64 | 0.64 | 0.6 | 0.61 | 60100.0 |
| 2009-08-17 | AAV-DELISTED | Stock | 4.9 | 5.04 | 4.84 | 4.98 | 983046.0 |
| 2009-08-17 | AAWW-DELISTED | Stock | 25.05 | 25.35 | 24.4 | 24.65 | 203720.0 |
| 2009-08-17 | AAXJ | Stock | 47.7 | 47.99 | 42.02 | 47.29 | 831718.0 |
| 2009-08-17 | AAXN-DELISTED | Stock | 4.89 | 4.94 | 4.65 | 4.76 | 472591.0 |
| 2009-08-17 | AB | Stock | 21.19 | 21.2 | 20.52 | 20.54 | 357700.0 |
| 2009-08-17 | ABAX-DELISTED | Stock | 27.63 | 27.63 | 27.18 | 27.5 | 259915.0 |
| 2009-08-17 | ABB-DELISTED | Stock | 17.79 | 17.85 | 17.65 | 17.73 | 3627844.0 |
| 2009-08-17 | ABBC-DELISTED | Stock | 8.14 | 8.47 | 8.14 | 8.19 | 56868.0 |
| 2009-08-17 | ABBNY-DELISTED | Stock | 17.79 | 17.85 | 17.65 | 17.72 | 3688819.0 |
| 2009-08-17 | ABC-DELISTED | Stock | 20.22 | 20.425 | 20.15 | 20.24 | 3216521.0 |
| 2009-08-17 | ABCB | Stock | 5.9914 | 6.4195 | 5.9914 | 6.0012 | 23030.0 |
| 2009-08-17 | ABCO-DELISTED | Stock | 13.23 | 13.555 | 13.09 | 13.33 | 106272.0 |
| 2009-08-17 | ABCW-DELISTED | Stock | 1.6 | 1.65 | 1.42 | 1.51 | 111380.0 |
| 2009-08-17 | ABD-DELISTED | Stock | 4.64 | 4.8 | 4.5 | 4.7 | 350130.0 |
| 2009-08-17 | ABE-DELISTED | Stock | 15.75 | 16.0 | 15.54 | 15.745 | 22288.0 |
| 2009-08-17 | ABEO | Stock | 5062.5 | 5125.0 | 3950.0 | 4762.5 | 56.0 |
| 2009-08-17 | ABFS-DELISTED | Stock | 29.0 | 29.0 | 27.75 | 28.06 | 369831.0 |
| 2009-08-17 | ABG | Stock | 12.66 | 12.76 | 11.74 | 12.33 | 389400.0 |
| 2009-08-17 | ABII-DELISTED | Stock | 29.55 | 30.14 | 29.13 | 30.14 | 17870.0 |
| 2009-08-17 | ABK-DELISTED | Stock | 0.98 | 0.98 | 0.89 | 0.94 | 8587080.0 |
| 2009-08-17 | ABM | Stock | 21.01 | 21.02 | 20.5 | 20.59 | 153600.0 |
| 2009-08-17 | ABMD-DELISTED | Stock | 7.34 | 7.46 | 7.25 | 7.4 | 96181.0 |
| 2009-08-17 | ABR | Stock | 1.88 | 1.92 | 1.8 | 1.8 | 155400.0 |
| 2009-08-17 | ABT | Stock | 21.1112 | 21.567 | 21.0632 | 21.4758 | 19072947.0 |
| 2009-08-17 | ABTL-DELISTED | Stock | 2.5 | 2.5 | 2.35 | 2.35 | 34189.0 |
| 2009-08-17 | ABV-DELISTED | Stock | 72.38 | 73.93 | 71.84 | 73.55 | 457462.0 |
| 2009-08-17 | ABVA-DELISTED | Stock | 2.2 | 2.2 | 2.2 | 2.2 | 2875.0 |
| 2009-08-17 | ABVT-DELISTED | Stock | 92.0 | 93.67 | 91.45 | 93.0 | 90056.0 |
| 2009-08-17 | ABX-DELISTED | Stock | 32.87 | 33.22 | 32.17 | 32.92 | 8069846.0 |
| 2009-08-17 | ACAD | Stock | 5.77 | 5.98 | 5.5 | 5.73 | 1894300.0 |
| 2009-08-17 | ACAP-DELISTED | Stock | 31.74 | 31.99 | 31.26 | 31.85 | 37198.0 |
| 2009-08-17 | ACAS-DELISTED | Stock | 2.9 | 2.9 | 2.74 | 2.77 | 4570353.0 |
> showing 50 of 5,812 rows — these rows as CSV