PREVIEW / stock_daily / 2009-08-26
file: by_date/stock_daily/2009/2009-08-26.parquet size: 184 KB rows: 5,804 symbols: 3,456
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-26 | AAPL | Stock | 6.0329 | 6.0554 | 5.9557 | 5.9789 | 303998800.0 |
| 2009-08-26 | MSFT | Stock | 24.59 | 24.75 | 24.42 | 24.55 | 41079000.0 |
| 2009-08-26 | NVDA | Stock | 0.3408 | 0.3462 | 0.3395 | 0.3455 | 434308000.0 |
| 2009-08-26 | AMZN | Stock | 4.205 | 4.238 | 4.169 | 4.2 | 72276000.0 |
| 2009-08-26 | TLT | Stock | 96.18 | 96.55 | 95.91 | 96.45 | 3225758.0 |
| 2009-08-26 | ES | Stock | 24.33 | 24.43 | 24.11 | 24.32 | 918800.0 |
| 2009-08-26 | CL | Stock | 36.53 | 36.745 | 36.355 | 36.65 | 3808400.0 |
| 2009-08-26 | A | Stock | 18.1974 | 18.3405 | 17.99 | 18.226 | 4660233.0 |
| 2009-08-26 | AABA-DELISTED | Stock | 15.09 | 15.14 | 14.86 | 14.92 | 15521129.0 |
| 2009-08-26 | AACC-DELISTED | Stock | 8.37 | 8.51 | 8.06 | 8.47 | 84196.0 |
| 2009-08-26 | AACG | Stock | 6.99 | 7.44 | 6.75 | 7.43 | 9500.0 |
| 2009-08-26 | AAI-DELISTED | Stock | 6.86 | 7.07 | 6.81 | 6.84 | 2198396.0 |
| 2009-08-26 | AAIC-DELISTED | Stock | 9.2 | 10.4 | 9.2 | 9.2 | 2034287.0 |
| 2009-08-26 | AAME | Stock | 0.87 | 0.87 | 0.87 | 0.87 | 200.0 |
| 2009-08-26 | AAON | Stock | 4.318 | 4.3398 | 4.2785 | 4.3299 | 218700.0 |
| 2009-08-26 | AAP | Stock | 42.9 | 43.49 | 42.6 | 42.72 | 1720000.0 |
| 2009-08-26 | AATI-DELISTED | Stock | 4.59 | 4.66 | 4.38 | 4.5 | 303428.0 |
| 2009-08-26 | AAU-DELISTED | Stock | 0.63 | 0.66 | 0.63 | 0.64 | 9025.0 |
| 2009-08-26 | AAUAF-DELISTED | Stock | 0.63 | 0.66 | 0.63 | 0.64 | 11050.0 |
| 2009-08-26 | AAV-DELISTED | Stock | 5.65 | 5.75 | 5.58 | 5.73 | 861384.0 |
| 2009-08-26 | AAWW-DELISTED | Stock | 23.93 | 25.2 | 23.73 | 24.875 | 290996.0 |
| 2009-08-26 | AAXJ | Stock | 49.45 | 49.52 | 48.76 | 49.41 | 249687.0 |
| 2009-08-26 | AAXN-DELISTED | Stock | 4.85 | 4.9 | 4.8 | 4.85 | 280946.0 |
| 2009-08-26 | AB | Stock | 21.24 | 21.3 | 20.88 | 21.18 | 340900.0 |
| 2009-08-26 | ABAX-DELISTED | Stock | 27.9 | 28.0 | 27.56 | 27.81 | 149075.0 |
| 2009-08-26 | ABB-DELISTED | Stock | 19.25 | 19.36 | 19.0 | 19.24 | 3225585.0 |
| 2009-08-26 | ABBC-DELISTED | Stock | 8.28 | 8.37 | 8.2 | 8.35 | 28849.0 |
| 2009-08-26 | ABBNY-DELISTED | Stock | 19.25 | 19.36 | 19.0 | 19.23 | 3227290.0 |
| 2009-08-26 | ABC-DELISTED | Stock | 20.87 | 21.15 | 20.77 | 20.92 | 1990518.0 |
| 2009-08-26 | ABCB | Stock | 6.5362 | 6.5362 | 6.2346 | 6.4778 | 16039.0 |
| 2009-08-26 | ABCO-DELISTED | Stock | 13.453 | 13.577 | 13.353 | 13.512 | 58429.0 |
| 2009-08-26 | ABCW-DELISTED | Stock | 1.35 | 1.42 | 1.2487 | 1.28 | 116850.0 |
| 2009-08-26 | ABD-DELISTED | Stock | 5.89 | 5.96 | 5.7 | 5.92 | 270520.0 |
| 2009-08-26 | ABE-DELISTED | Stock | 16.5 | 16.53 | 16.3901 | 16.5142 | 4621.0 |
| 2009-08-26 | ABEO | Stock | 4250.0 | 4550.0 | 4000.0 | 4212.5 | 38.0 |
| 2009-08-26 | ABFS-DELISTED | Stock | 32.0 | 32.46 | 31.52 | 31.68 | 426841.0 |
| 2009-08-26 | ABG | Stock | 13.25 | 13.68 | 13.12 | 13.49 | 256800.0 |
| 2009-08-26 | ABII-DELISTED | Stock | 27.45 | 28.14 | 27.45 | 27.87 | 34092.0 |
| 2009-08-26 | ABK-DELISTED | Stock | 1.33 | 1.34 | 1.21 | 1.24 | 17371895.0 |
| 2009-08-26 | ABM | Stock | 22.88 | 23.13 | 22.7 | 22.89 | 95400.0 |
| 2009-08-26 | ABMD-DELISTED | Stock | 8.85 | 8.89 | 8.71 | 8.86 | 158138.0 |
| 2009-08-26 | ABR | Stock | 2.02 | 2.09 | 1.9 | 1.97 | 159100.0 |
| 2009-08-26 | ABT | Stock | 21.9844 | 22.2579 | 21.9508 | 22.1044 | 13752814.0 |
| 2009-08-26 | ABTL-DELISTED | Stock | 3.1124 | 3.2129 | 3.1124 | 3.1376 | 2889.0 |
| 2009-08-26 | ABV-DELISTED | Stock | 75.53 | 76.44 | 75.28 | 76.31 | 300216.0 |
| 2009-08-26 | ABVA-DELISTED | Stock | 2.49 | 2.5 | 2.49 | 2.5 | 1605.0 |
| 2009-08-26 | ABVT-DELISTED | Stock | 94.0 | 95.442 | 93.75 | 94.71 | 81735.0 |
| 2009-08-26 | ABX-DELISTED | Stock | 34.25 | 34.46 | 33.89 | 34.2 | 5515284.0 |
| 2009-08-26 | ACAD | Stock | 6.08 | 6.26 | 5.96 | 6.15 | 1536300.0 |
| 2009-08-26 | ACAP-DELISTED | Stock | 31.85 | 33.0 | 31.45 | 32.79 | 64891.0 |
> showing 50 of 5,804 rows — these rows as CSV