PREVIEW / stock_daily / 2009-08-10
file: by_date/stock_daily/2009/2009-08-10.parquet size: 185 KB rows: 5,837 symbols: 3,487
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-10 | AAPL | Stock | 5.9164 | 5.95 | 5.845 | 5.8829 | 300294400.0 |
| 2009-08-10 | MSFT | Stock | 23.46 | 23.55 | 23.3 | 23.42 | 35261900.0 |
| 2009-08-10 | NVDA | Stock | 0.3453 | 0.3502 | 0.3295 | 0.3315 | 693312000.0 |
| 2009-08-10 | AMZN | Stock | 4.2505 | 4.2735 | 4.1635 | 4.222 | 88812000.0 |
| 2009-08-10 | TLT | Stock | 90.51 | 91.64 | 90.41 | 91.62 | 3150534.0 |
| 2009-08-10 | ES | Stock | 23.29 | 23.42 | 23.12 | 23.32 | 911700.0 |
| 2009-08-10 | CL | Stock | 35.455 | 35.68 | 35.26 | 35.65 | 5451600.0 |
| 2009-08-10 | A | Stock | 16.9313 | 17.0815 | 16.7382 | 17.0458 | 3605162.0 |
| 2009-08-10 | AABA-DELISTED | Stock | 14.66 | 14.68 | 14.49 | 14.63 | 17408071.0 |
| 2009-08-10 | AACC-DELISTED | Stock | 7.48 | 7.94 | 7.2122 | 7.53 | 48224.0 |
| 2009-08-10 | AACG | Stock | 8.12 | 8.21 | 7.92 | 8.14 | 2300.0 |
| 2009-08-10 | AAI-DELISTED | Stock | 6.85 | 6.93 | 6.59 | 6.65 | 1804818.0 |
| 2009-08-10 | AAIC-DELISTED | Stock | 9.2 | 10.0 | 9.0 | 9.0 | 2611926.0 |
| 2009-08-10 | AAME | Stock | 0.68 | 0.68 | 0.68 | 0.68 | 100.0 |
| 2009-08-10 | AAON | Stock | 4.0691 | 4.0691 | 3.9723 | 4.0158 | 218194.0 |
| 2009-08-10 | AAP | Stock | 46.95 | 46.95 | 45.88 | 46.06 | 911200.0 |
| 2009-08-10 | AATI-DELISTED | Stock | 4.64 | 4.65 | 4.44 | 4.5 | 237442.0 |
| 2009-08-10 | AAU-DELISTED | Stock | 0.64 | 0.65 | 0.6227 | 0.63 | 42845.0 |
| 2009-08-10 | AAUAF-DELISTED | Stock | 0.64 | 0.65 | 0.6227 | 0.63 | 43445.0 |
| 2009-08-10 | AAV-DELISTED | Stock | 5.01 | 5.09 | 4.97 | 5.07 | 551282.0 |
| 2009-08-10 | AAWW-DELISTED | Stock | 28.12 | 28.69 | 27.56 | 28.15 | 220346.0 |
| 2009-08-10 | AAXJ | Stock | 50.12 | 50.12 | 49.38 | 49.71 | 124473.0 |
| 2009-08-10 | AAXN-DELISTED | Stock | 5.02 | 5.24 | 5.02 | 5.15 | 277748.0 |
| 2009-08-10 | AB | Stock | 21.31 | 21.4 | 20.81 | 21.13 | 397300.0 |
| 2009-08-10 | ABAX-DELISTED | Stock | 27.6 | 28.49 | 27.6 | 28.0 | 256667.0 |
| 2009-08-10 | ABB-DELISTED | Stock | 18.36 | 18.38 | 18.0809 | 18.22 | 2767310.0 |
| 2009-08-10 | ABBC-DELISTED | Stock | 8.24 | 8.32 | 8.05 | 8.06 | 40464.0 |
| 2009-08-10 | ABBNY-DELISTED | Stock | 18.36 | 18.38 | 18.0809 | 18.2 | 2767864.0 |
| 2009-08-10 | ABC-DELISTED | Stock | 20.315 | 20.42 | 20.16 | 20.33 | 2251208.0 |
| 2009-08-10 | ABCB | Stock | 6.5848 | 6.7113 | 6.4 | 6.6334 | 6273.0 |
| 2009-08-10 | ABCO-DELISTED | Stock | 13.535 | 13.94 | 13.175 | 13.68 | 210582.0 |
| 2009-08-10 | ABCW-DELISTED | Stock | 1.5485 | 1.5675 | 1.216 | 1.52 | 179520.0 |
| 2009-08-10 | ABD-DELISTED | Stock | 4.86 | 5.01 | 4.5598 | 4.91 | 593650.0 |
| 2009-08-10 | ABE-DELISTED | Stock | 16.75 | 16.91 | 16.6 | 16.86 | 5886.0 |
| 2009-08-10 | ABEO | Stock | 5812.5 | 5812.5 | 5375.0 | 5375.0 | 24.0 |
| 2009-08-10 | ABFS-DELISTED | Stock | 28.47 | 28.77 | 28.0 | 28.21 | 289103.0 |
| 2009-08-10 | ABG | Stock | 13.95 | 14.68 | 13.85 | 14.17 | 212300.0 |
| 2009-08-10 | ABII-DELISTED | Stock | 30.56 | 31.66 | 30.07 | 30.47 | 38562.0 |
| 2009-08-10 | ABK-DELISTED | Stock | 1.15 | 1.2 | 1.09 | 1.17 | 23197902.0 |
| 2009-08-10 | ABM | Stock | 21.84 | 22.13 | 21.8 | 22.0 | 118500.0 |
| 2009-08-10 | ABMD-DELISTED | Stock | 7.29 | 7.73 | 7.29 | 7.37 | 155769.0 |
| 2009-08-10 | ABR | Stock | 1.99 | 2.27 | 1.98 | 2.09 | 413800.0 |
| 2009-08-10 | ABT | Stock | 20.9673 | 21.3799 | 20.8761 | 21.3607 | 17182159.0 |
| 2009-08-10 | ABTL-DELISTED | Stock | 2.5253 | 2.5253 | 2.4854 | 2.5 | 32379.0 |
| 2009-08-10 | ABV-DELISTED | Stock | 73.34 | 73.99 | 73.0 | 73.57 | 314941.0 |
| 2009-08-10 | ABVA-DELISTED | Stock | 2.55 | 2.55 | 2.55 | 2.55 | 1000.0 |
| 2009-08-10 | ABVT-DELISTED | Stock | 89.15 | 94.3 | 89.0 | 92.21 | 164990.0 |
| 2009-08-10 | ABX-DELISTED | Stock | 34.31 | 34.55 | 33.95 | 34.21 | 4985496.0 |
| 2009-08-10 | ACAD | Stock | 4.64 | 5.54 | 4.64 | 5.36 | 3603900.0 |
| 2009-08-10 | ACAP-DELISTED | Stock | 32.72 | 33.42 | 32.65 | 32.99 | 56226.0 |
> showing 50 of 5,837 rows — these rows as CSV