PREVIEW / stock_daily / 2009-04-07
file: by_date/stock_daily/2009/2009-04-07.parquet size: 175 KB rows: 5,711 symbols: 3,409
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-04-07 | AAPL | Stock | 4.1618 | 4.1668 | 4.0782 | 4.1071 | 536580800.0 |
| 2009-04-07 | MSFT | Stock | 18.76 | 19.14 | 18.63 | 18.76 | 65815200.0 |
| 2009-04-07 | NVDA | Stock | 0.2783 | 0.2812 | 0.2723 | 0.274 | 607804000.0 |
| 2009-04-07 | AMZN | Stock | 3.8485 | 3.854 | 3.744 | 3.7755 | 114976000.0 |
| 2009-04-07 | TLT | Stock | 102.54 | 103.31 | 102.48 | 102.74 | 1312593.0 |
| 2009-04-07 | ES | Stock | 21.02 | 21.42 | 20.8 | 21.4 | 1877600.0 |
| 2009-04-07 | CL | Stock | 30.23 | 30.43 | 29.97 | 30.165 | 5179600.0 |
| 2009-04-07 | A | Stock | 11.2089 | 11.2589 | 11.0086 | 11.1588 | 4978138.0 |
| 2009-04-07 | AABA-DELISTED | Stock | 13.0 | 13.1 | 12.68 | 12.78 | 12173844.0 |
| 2009-04-07 | AACC-DELISTED | Stock | 6.08 | 6.21 | 5.97 | 6.0 | 18180.0 |
| 2009-04-07 | AACG | Stock | 4.25 | 4.25 | 4.16 | 4.16 | 3400.0 |
| 2009-04-07 | AAI-DELISTED | Stock | 5.0 | 5.12 | 4.93 | 5.02 | 2677293.0 |
| 2009-04-07 | AAIC-DELISTED | Stock | 5.4 | 7.2 | 5.2 | 6.0 | 1349675.0 |
| 2009-04-07 | AAME | Stock | 0.55 | 0.55 | 0.5 | 0.55 | 7100.0 |
| 2009-04-07 | AAON | Stock | 3.4509 | 3.522 | 3.358 | 3.362 | 309319.0 |
| 2009-04-07 | AAP | Stock | 39.91 | 40.04 | 39.2 | 39.49 | 1931600.0 |
| 2009-04-07 | AATI-DELISTED | Stock | 3.93 | 4.1 | 3.74 | 3.75 | 152873.0 |
| 2009-04-07 | AAU-DELISTED | Stock | 0.7 | 0.73 | 0.68 | 0.69 | 42880.0 |
| 2009-04-07 | AAUAF-DELISTED | Stock | 0.7 | 0.73 | 0.68 | 0.69 | 42980.0 |
| 2009-04-07 | AAV-DELISTED | Stock | 2.42 | 2.44 | 2.39 | 2.41 | 578051.0 |
| 2009-04-07 | AAWW-DELISTED | Stock | 18.55 | 18.81 | 17.53 | 17.54 | 190014.0 |
| 2009-04-07 | AAXJ | Stock | 35.38 | 35.71 | 35.15 | 35.4 | 71959.0 |
| 2009-04-07 | AAXN-DELISTED | Stock | 4.76 | 4.9401 | 4.73 | 4.79 | 728924.0 |
| 2009-04-07 | AB | Stock | 16.46 | 16.6 | 16.0 | 16.11 | 1013600.0 |
| 2009-04-07 | ABAX-DELISTED | Stock | 17.24 | 17.24 | 15.22 | 15.47 | 1512676.0 |
| 2009-04-07 | ABB-DELISTED | Stock | 14.18 | 14.34 | 14.06 | 14.15 | 3177012.0 |
| 2009-04-07 | ABBC-DELISTED | Stock | 8.29 | 8.3797 | 8.25 | 8.3 | 60036.0 |
| 2009-04-07 | ABBNY-DELISTED | Stock | 14.19 | 14.34 | 14.06 | 14.12 | 3341312.0 |
| 2009-04-07 | ABC-DELISTED | Stock | 16.27 | 16.5 | 16.11 | 16.26 | 1930330.0 |
| 2009-04-07 | ABCB | Stock | 6.4486 | 6.5653 | 5.6024 | 5.6705 | 17170.0 |
| 2009-04-07 | ABCO-DELISTED | Stock | 8.797 | 8.892 | 8.428 | 8.458 | 85397.0 |
| 2009-04-07 | ABCW-DELISTED | Stock | 1.4 | 1.5 | 1.3 | 1.31 | 151140.0 |
| 2009-04-07 | ABD-DELISTED | Stock | 1.19 | 1.24 | 0.97 | 1.12 | 556930.0 |
| 2009-04-07 | ABE-DELISTED | Stock | 12.49 | 12.5332 | 12.25 | 12.25 | 6433.0 |
| 2009-04-07 | ABEO | Stock | 2062.5 | 2125.0 | 2012.5 | 2125.0 | 5.0 |
| 2009-04-07 | ABFS-DELISTED | Stock | 19.32 | 19.52 | 17.98 | 18.27 | 677819.0 |
| 2009-04-07 | ABG | Stock | 5.13 | 5.25 | 4.9 | 4.91 | 329600.0 |
| 2009-04-07 | ABII-DELISTED | Stock | 44.7 | 44.92 | 43.03 | 43.9 | 14039.0 |
| 2009-04-07 | ABK-DELISTED | Stock | 0.88 | 0.91 | 0.85 | 0.86 | 4291010.0 |
| 2009-04-07 | ABM | Stock | 16.8 | 17.08 | 16.56 | 16.56 | 681500.0 |
| 2009-04-07 | ABMD-DELISTED | Stock | 5.12 | 5.32 | 5.1 | 5.18 | 318952.0 |
| 2009-04-07 | ABR | Stock | 0.85 | 0.85 | 0.78 | 0.78 | 173200.0 |
| 2009-04-07 | ABT | Stock | 20.6842 | 20.9577 | 20.4491 | 20.593 | 27135473.0 |
| 2009-04-07 | ABTL-DELISTED | Stock | 1.3 | 1.3 | 1.2 | 1.25 | 8264.0 |
| 2009-04-07 | ABV-DELISTED | Stock | 52.94 | 52.94 | 51.75 | 51.77 | 541243.0 |
| 2009-04-07 | ABVA-DELISTED | Stock | 1.98 | 1.98 | 1.98 | 1.98 | 1000.0 |
| 2009-04-07 | ABVT-DELISTED | Stock | 47.0 | 47.0 | 47.0 | 47.0 | 500.0 |
| 2009-04-07 | ABX-DELISTED | Stock | 29.19 | 29.69 | 29.02 | 29.06 | 12018202.0 |
| 2009-04-07 | ACAD | Stock | 1.02 | 1.05 | 1.0 | 1.03 | 487000.0 |
| 2009-04-07 | ACAP-DELISTED | Stock | 41.23 | 41.91 | 41.23 | 41.64 | 65257.0 |
> showing 50 of 5,711 rows — these rows as CSV