PREVIEW / stock_daily / 2009-08-04
file: by_date/stock_daily/2009/2009-08-04.parquet size: 184 KB rows: 5,822 symbols: 3,468
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-04 | AAPL | Stock | 5.8904 | 5.9132 | 5.8646 | 5.9125 | 395810800.0 |
| 2009-08-04 | MSFT | Stock | 23.68 | 23.79 | 23.53 | 23.77 | 49218300.0 |
| 2009-08-04 | NVDA | Stock | 0.3263 | 0.34 | 0.3258 | 0.3342 | 695380000.0 |
| 2009-08-04 | AMZN | Stock | 4.374 | 4.374 | 4.2465 | 4.29 | 123558000.0 |
| 2009-08-04 | TLT | Stock | 93.63 | 93.72 | 91.67 | 92.32 | 3832186.0 |
| 2009-08-04 | ES | Stock | 23.25 | 23.34 | 22.92 | 23.01 | 847600.0 |
| 2009-08-04 | CL | Stock | 36.05 | 36.355 | 35.985 | 36.105 | 5950800.0 |
| 2009-08-04 | A | Stock | 17.0601 | 17.4177 | 16.9528 | 17.289 | 3824229.0 |
| 2009-08-04 | AABA-DELISTED | Stock | 14.44 | 14.68 | 14.37 | 14.5 | 42747523.0 |
| 2009-08-04 | AACC-DELISTED | Stock | 7.43 | 7.54 | 7.01 | 7.45 | 33069.0 |
| 2009-08-04 | AACG | Stock | 8.02 | 8.35 | 8.0 | 8.02 | 11300.0 |
| 2009-08-04 | AAI-DELISTED | Stock | 6.86 | 7.17 | 6.86 | 7.13 | 2364104.0 |
| 2009-08-04 | AAIC-DELISTED | Stock | 8.0 | 8.7 | 8.0 | 8.7 | 482097.0 |
| 2009-08-04 | AAME | Stock | 0.69 | 0.69 | 0.69 | 0.69 | 500.0 |
| 2009-08-04 | AAON | Stock | 4.0454 | 4.1521 | 4.0 | 4.1521 | 455625.0 |
| 2009-08-04 | AAP | Stock | 47.0 | 47.06 | 45.28 | 45.46 | 1101100.0 |
| 2009-08-04 | AATI-DELISTED | Stock | 4.87 | 4.91 | 4.78 | 4.89 | 175953.0 |
| 2009-08-04 | AAU-DELISTED | Stock | 0.6701 | 0.6998 | 0.6599 | 0.67 | 95712.0 |
| 2009-08-04 | AAUAF-DELISTED | Stock | 0.6703 | 0.7 | 0.66 | 0.67 | 97982.0 |
| 2009-08-04 | AAV-DELISTED | Stock | 5.21 | 5.32 | 5.18 | 5.28 | 541424.0 |
| 2009-08-04 | AAWW-DELISTED | Stock | 25.48 | 26.5 | 25.09 | 25.69 | 181917.0 |
| 2009-08-04 | AAXJ | Stock | 50.99 | 51.36 | 50.68 | 51.0152 | 278454.0 |
| 2009-08-04 | AAXN-DELISTED | Stock | 5.24 | 5.36 | 5.15 | 5.26 | 347793.0 |
| 2009-08-04 | AB | Stock | 20.7 | 21.18 | 20.39 | 20.4 | 788800.0 |
| 2009-08-04 | ABAX-DELISTED | Stock | 27.28 | 27.28 | 26.92 | 26.99 | 577242.0 |
| 2009-08-04 | ABB-DELISTED | Stock | 18.55 | 18.76 | 18.44 | 18.74 | 4036511.0 |
| 2009-08-04 | ABBC-DELISTED | Stock | 8.28 | 8.45 | 8.15 | 8.38 | 31763.0 |
| 2009-08-04 | ABBNY-DELISTED | Stock | 18.55 | 18.76 | 18.44 | 18.74 | 4123509.0 |
| 2009-08-04 | ABC-DELISTED | Stock | 20.33 | 20.51 | 19.91 | 20.42 | 4469956.0 |
| 2009-08-04 | ABCB | Stock | 6.6626 | 6.7599 | 6.4 | 6.7599 | 15011.0 |
| 2009-08-04 | ABCO-DELISTED | Stock | 13.155 | 13.435 | 12.98 | 13.155 | 123646.0 |
| 2009-08-04 | ABCW-DELISTED | Stock | 1.43 | 1.5 | 1.37 | 1.44 | 141630.0 |
| 2009-08-04 | ABD-DELISTED | Stock | 4.5 | 4.71 | 3.93 | 4.32 | 924130.0 |
| 2009-08-04 | ABE-DELISTED | Stock | 17.3 | 17.41 | 16.7 | 17.21 | 20870.0 |
| 2009-08-04 | ABEO | Stock | 5812.5 | 5875.0 | 5337.5 | 5550.0 | 18.0 |
| 2009-08-04 | ABFS-DELISTED | Stock | 28.31 | 28.68 | 27.83 | 28.04 | 506666.0 |
| 2009-08-04 | ABG | Stock | 13.79 | 14.33 | 13.59 | 13.93 | 511400.0 |
| 2009-08-04 | ABII-DELISTED | Stock | 30.89 | 32.0 | 30.18 | 32.0 | 28267.0 |
| 2009-08-04 | ABK-DELISTED | Stock | 0.765 | 0.99 | 0.75 | 0.9048 | 33311596.0 |
| 2009-08-04 | ABM | Stock | 21.29 | 22.0 | 21.29 | 21.75 | 171200.0 |
| 2009-08-04 | ABMD-DELISTED | Stock | 7.56 | 7.82 | 7.47 | 7.72 | 235669.0 |
| 2009-08-04 | ABR | Stock | 1.78 | 1.92 | 1.72 | 1.92 | 291900.0 |
| 2009-08-04 | ABT | Stock | 21.4279 | 21.4902 | 21.2216 | 21.2551 | 21876198.0 |
| 2009-08-04 | ABTL-DELISTED | Stock | 2.45 | 2.5 | 2.4345 | 2.5 | 11523.0 |
| 2009-08-04 | ABV-DELISTED | Stock | 73.86 | 75.06 | 73.39 | 75.06 | 655359.0 |
| 2009-08-04 | ABVT-DELISTED | Stock | 83.8 | 85.75 | 83.8 | 85.35 | 109922.0 |
| 2009-08-04 | ABX-DELISTED | Stock | 35.79 | 36.67 | 35.52 | 36.13 | 7249052.0 |
| 2009-08-04 | ACAD | Stock | 4.77 | 5.07 | 4.71 | 4.9 | 2678100.0 |
| 2009-08-04 | ACAP-DELISTED | Stock | 34.04 | 35.11 | 33.33 | 33.73 | 57441.0 |
| 2009-08-04 | ACAS-DELISTED | Stock | 3.51 | 3.69 | 3.41 | 3.61 | 3662361.0 |
> showing 50 of 5,822 rows — these rows as CSV