PREVIEW / stock_daily / 2024-05-17
file: by_date/stock_daily/2024/2024-05-17.parquet size: 231 KB rows: 7,191 symbols: 963
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 |
|---|---|---|---|---|---|---|---|
| 2024-05-17 | AAPL | Stock | 189.51 | 190.81 | 189.18 | 189.87 | 41282900.0 |
| 2024-05-17 | MSFT | Stock | 422.54 | 422.92 | 418.03 | 420.21 | 15352200.0 |
| 2024-05-17 | NVDA | Stock | 94.369 | 94.74 | 91.806 | 92.479 | 359691000.0 |
| 2024-05-17 | AMZN | Stock | 183.76 | 185.3 | 183.35 | 184.7 | 33175700.0 |
| 2024-05-17 | GOOGL | Stock | 174.18 | 176.265 | 173.69 | 176.06 | 24479262.0 |
| 2024-05-17 | META | Stock | 470.83 | 472.8 | 468.42 | 471.91 | 10807300.0 |
| 2024-05-17 | TSLA | Stock | 173.55 | 179.63 | 172.75 | 177.46 | 77445800.0 |
| 2024-05-17 | TLT | Stock | 91.64 | 91.8 | 91.34 | 91.39 | 24755012.0 |
| 2024-05-17 | ES | Stock | 61.25 | 61.38 | 60.62 | 60.96 | 1921700.0 |
| 2024-05-17 | CL | Stock | 94.54 | 94.54 | 93.75 | 94.13 | 4135200.0 |
| 2024-05-17 | A | Stock | 154.51 | 155.35 | 153.03 | 154.23 | 1857000.0 |
| 2024-05-17 | AA | Stock | 40.74 | 41.55 | 40.66 | 41.22 | 4260700.0 |
| 2024-05-17 | AACG | Stock | 0.93 | 0.93 | 0.91 | 0.91 | 3200.0 |
| 2024-05-17 | AACIW-DELISTED | Stock | 0.12 | 0.1613 | 0.111 | 0.13 | 27286.0 |
| 2024-05-17 | AACT | Stock | 10.62 | 10.63 | 10.62 | 10.62 | 4400.0 |
| 2024-05-17 | AAGR-DELISTED | Stock | 0.38 | 0.3898 | 0.36 | 0.37 | 55498.0 |
| 2024-05-17 | AAGRW-DELISTED | Stock | 0.0113 | 0.0135 | 0.0113 | 0.0115 | 100917.0 |
| 2024-05-17 | AAL | Stock | 14.85 | 14.99 | 14.72 | 14.73 | 18472100.0 |
| 2024-05-17 | AAMC-DELISTED | Stock | 2.876 | 2.876 | 2.75 | 2.75 | 1800.0 |
| 2024-05-17 | AAME | Stock | 1.68 | 1.74 | 1.68 | 1.71 | 2800.0 |
| 2024-05-17 | AAMI | Stock | 23.54 | 23.54 | 22.71 | 22.81 | 321100.0 |
| 2024-05-17 | AAN-DELISTED | Stock | 7.54 | 7.62 | 7.437 | 7.59 | 146100.0 |
| 2024-05-17 | AAOI | Stock | 11.2 | 11.79 | 11.08 | 11.725 | 1799300.0 |
| 2024-05-17 | AAON | Stock | 75.19 | 75.52 | 74.3 | 74.88 | 648100.0 |
| 2024-05-17 | AAP | Stock | 73.44 | 74.72 | 73.04 | 74.55 | 1041600.0 |
| 2024-05-17 | AAT | Stock | 22.89 | 22.99 | 22.74 | 22.95 | 160700.0 |
| 2024-05-17 | AATC | Stock | 6.47 | 6.76 | 6.27 | 6.438 | 13169.0 |
| 2024-05-17 | AAUAF-DELISTED | Stock | 0.1219 | 0.13 | 0.1219 | 0.126 | 111858.0 |
| 2024-05-17 | AAXJ | Stock | 73.22 | 73.64 | 73.09 | 73.45 | 888007.0 |
| 2024-05-17 | AB | Stock | 34.0 | 34.17 | 33.7 | 33.85 | 187300.0 |
| 2024-05-17 | ABAT | Stock | 1.36 | 1.55 | 1.33 | 1.51 | 958846.0 |
| 2024-05-17 | ABBV | Stock | 165.39 | 166.49 | 164.49 | 166.42 | 5152200.0 |
| 2024-05-17 | ABCB | Stock | 50.4 | 50.79 | 50.07 | 50.45 | 208400.0 |
| 2024-05-17 | ABCL | Stock | 3.82 | 3.83 | 3.63 | 3.64 | 1041100.0 |
| 2024-05-17 | ABEO | Stock | 4.53 | 4.62 | 4.4 | 4.4 | 522900.0 |
| 2024-05-17 | ABEV | Stock | 2.4 | 2.42 | 2.37 | 2.42 | 12964900.0 |
| 2024-05-17 | ABG | Stock | 243.57 | 244.7 | 240.63 | 241.13 | 169000.0 |
| 2024-05-17 | ABLLW | Stock | 0.331 | 0.39 | 0.32 | 0.36555 | 79076.0 |
| 2024-05-17 | ABLV | Stock | 1.673 | 1.882 | 1.673 | 1.807 | 13700.0 |
| 2024-05-17 | ABM | Stock | 46.74 | 47.19 | 46.43 | 47.1 | 341200.0 |
| 2024-05-17 | ABNB | Stock | 146.81 | 147.495 | 145.305 | 145.66 | 3279000.0 |
| 2024-05-17 | ABOS | Stock | 3.74 | 3.767 | 3.56 | 3.65 | 79200.0 |
| 2024-05-17 | ABR | Stock | 13.79 | 13.95 | 13.73 | 13.89 | 2375000.0 |
| 2024-05-17 | ABR.D | Stock | 18.65 | 18.65 | 18.4 | 18.49 | 12074.0 |
| 2024-05-17 | ABR.E | Stock | 18.38 | 18.465 | 18.2108 | 18.43 | 6207.0 |
| 2024-05-17 | ABR.F | Stock | 19.93 | 19.9499 | 19.7 | 19.79 | 3688.0 |
| 2024-05-17 | ABSI | Stock | 4.75 | 4.75 | 4.58 | 4.615 | 551300.0 |
| 2024-05-17 | ABT | Stock | 104.41 | 104.8 | 103.94 | 104.09 | 7004600.0 |
| 2024-05-17 | ABTC | Stock | 123.75 | 123.75 | 117.75 | 120.0 | 3496.0 |
| 2024-05-17 | ABTS | Stock | 10.2 | 10.53 | 9.9 | 9.9 | 673.0 |
> showing 50 of 7,191 rows — these rows as CSV