PREVIEW / stock_daily / 2010-10-21
file: by_date/stock_daily/2010/2010-10-21.parquet size: 193 KB rows: 5,989 symbols: 3,513
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-21 | AAPL | Stock | 11.1557 | 11.2407 | 10.9571 | 11.0543 | 551460000.0 |
| 2010-10-21 | MSFT | Stock | 25.4 | 25.54 | 25.05 | 25.42 | 50032400.0 |
| 2010-10-21 | NVDA | Stock | 0.2825 | 0.283 | 0.273 | 0.2772 | 1014428000.0 |
| 2010-10-21 | AMZN | Stock | 8.1335 | 8.3065 | 8.0645 | 8.2485 | 269650000.0 |
| 2010-10-21 | TSLA | Stock | 1.374 | 1.3967 | 1.3633 | 1.3833 | 6256500.0 |
| 2010-10-21 | TLT | Stock | 101.69 | 101.91 | 100.69 | 100.7 | 6836182.0 |
| 2010-10-21 | ES | Stock | 31.01 | 31.09 | 30.49 | 30.7 | 1445600.0 |
| 2010-10-21 | CL | Stock | 38.665 | 38.775 | 38.155 | 38.35 | 4943600.0 |
| 2010-10-21 | A | Stock | 24.8856 | 25.0358 | 24.6209 | 24.8569 | 4276622.0 |
| 2010-10-21 | AABA-DELISTED | Stock | 15.9 | 16.0 | 15.73 | 15.971 | 26477337.0 |
| 2010-10-21 | AACC-DELISTED | Stock | 5.79 | 5.79 | 5.28 | 5.43 | 29421.0 |
| 2010-10-21 | AAI-DELISTED | Stock | 7.46 | 7.49 | 7.435 | 7.48 | 8110783.0 |
| 2010-10-21 | AAIC-DELISTED | Stock | 23.46 | 23.61 | 23.22 | 23.5 | 50336.0 |
| 2010-10-21 | AAME | Stock | 1.65 | 1.71 | 1.65 | 1.71 | 1100.0 |
| 2010-10-21 | AAON | Stock | 4.8928 | 4.9304 | 4.804 | 4.9007 | 126562.0 |
| 2010-10-21 | AAP | Stock | 60.81 | 61.38 | 60.53 | 61.01 | 646200.0 |
| 2010-10-21 | AATI-DELISTED | Stock | 3.89 | 3.89 | 3.72 | 3.76 | 101377.0 |
| 2010-10-21 | AAU-DELISTED | Stock | 2.59 | 2.64 | 2.52 | 2.61 | 278137.0 |
| 2010-10-21 | AAUAF-DELISTED | Stock | 2.59 | 2.64 | 2.52 | 2.61 | 278367.0 |
| 2010-10-21 | AAV-DELISTED | Stock | 6.26 | 6.32 | 6.19 | 6.26 | 329551.0 |
| 2010-10-21 | AAWW-DELISTED | Stock | 55.23 | 55.38 | 52.46 | 53.37 | 255777.0 |
| 2010-10-21 | AAXJ | Stock | 62.83 | 62.95 | 62.03 | 62.44 | 869257.0 |
| 2010-10-21 | AAXN-DELISTED | Stock | 4.49 | 4.61 | 4.4 | 4.55 | 589664.0 |
| 2010-10-21 | AB | Stock | 26.45 | 26.72 | 26.12 | 26.27 | 192800.0 |
| 2010-10-21 | ABAC-DELISTED | Stock | 5.68 | 5.84 | 5.34 | 5.34 | 86471.0 |
| 2010-10-21 | ABAX-DELISTED | Stock | 23.99 | 24.01 | 22.27 | 22.88 | 157206.0 |
| 2010-10-21 | ABB-DELISTED | Stock | 22.71 | 22.91 | 22.49 | 22.69 | 2295084.0 |
| 2010-10-21 | ABBC-DELISTED | Stock | 10.76 | 10.8 | 10.43 | 10.63 | 59439.0 |
| 2010-10-21 | ABBNY-DELISTED | Stock | 22.71 | 22.91 | 22.49 | 22.69 | 2314210.0 |
| 2010-10-21 | ABC-DELISTED | Stock | 32.02 | 32.51 | 31.78 | 32.36 | 3243460.0 |
| 2010-10-21 | ABCB | Stock | 9.3 | 9.48 | 9.08 | 9.42 | 65300.0 |
| 2010-10-21 | ABCD-DELISTED | Stock | 3.34 | 3.4 | 3.27 | 3.31 | 37833.0 |
| 2010-10-21 | ABCO-DELISTED | Stock | 23.38 | 23.44 | 22.6 | 23.06 | 104939.0 |
| 2010-10-21 | ABCW-DELISTED | Stock | 0.69 | 0.71 | 0.68 | 0.68 | 67130.0 |
| 2010-10-21 | ABD-DELISTED | Stock | 6.07 | 6.12 | 5.6498 | 5.93 | 277550.0 |
| 2010-10-21 | ABE-DELISTED | Stock | 19.28 | 19.41 | 19.2 | 19.291 | 9052.0 |
| 2010-10-21 | ABEO | Stock | 3750.0 | 3875.0 | 3662.5 | 3687.5 | 43.0 |
| 2010-10-21 | ABFS-DELISTED | Stock | 25.75 | 25.88 | 25.1533 | 25.49 | 218775.0 |
| 2010-10-21 | ABG | Stock | 14.8 | 15.22 | 14.46 | 14.9 | 190600.0 |
| 2010-10-21 | ABK-DELISTED | Stock | 1.02 | 1.07 | 0.96 | 1.03 | 25436267.0 |
| 2010-10-21 | ABM | Stock | 22.56 | 22.81 | 22.05 | 22.33 | 166000.0 |
| 2010-10-21 | ABMD-DELISTED | Stock | 10.78 | 10.91 | 10.47 | 10.51 | 143876.0 |
| 2010-10-21 | ABR | Stock | 5.26 | 5.37 | 5.14 | 5.35 | 48900.0 |
| 2010-10-21 | ABT | Stock | 25.2759 | 25.4726 | 25.1847 | 25.3526 | 15314298.0 |
| 2010-10-21 | ABTL-DELISTED | Stock | 4.15 | 4.15 | 3.75 | 3.8 | 35438.0 |
| 2010-10-21 | ABV-DELISTED | Stock | 139.2 | 141.13 | 138.42 | 139.63 | 888149.0 |
| 2010-10-21 | ABVA-DELISTED | Stock | 2.77 | 2.77 | 2.67 | 2.67 | 5700.0 |
| 2010-10-21 | ABVT-DELISTED | Stock | 55.07 | 55.4792 | 53.9 | 54.06 | 75437.0 |
| 2010-10-21 | ABX-DELISTED | Stock | 46.07 | 46.45 | 44.86 | 45.45 | 9305821.0 |
| 2010-10-21 | ACAD | Stock | 0.88 | 0.9 | 0.87 | 0.9 | 345600.0 |
> showing 50 of 5,989 rows — these rows as CSV