PREVIEW / stock_daily / 2024-05-15
file: by_date/stock_daily/2024/2024-05-15.parquet size: 232 KB rows: 7,245 symbols: 985
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-15 | AAPL | Stock | 187.91 | 190.65 | 187.37 | 189.72 | 70400000.0 |
| 2024-05-15 | MSFT | Stock | 417.9 | 423.81 | 417.27 | 423.08 | 22239500.0 |
| 2024-05-15 | NVDA | Stock | 92.472 | 94.862 | 91.599 | 94.63 | 417735000.0 |
| 2024-05-15 | AMZN | Stock | 185.97 | 186.72 | 182.73 | 185.99 | 75459900.0 |
| 2024-05-15 | GOOGL | Stock | 170.63 | 172.65 | 170.51 | 172.51 | 26948370.0 |
| 2024-05-15 | META | Stock | 474.98 | 482.5 | 471.2 | 481.54 | 13100500.0 |
| 2024-05-15 | TSLA | Stock | 179.9 | 180.0 | 173.11 | 173.99 | 79663000.0 |
| 2024-05-15 | TLT | Stock | 91.87 | 92.255 | 91.63 | 92.1 | 65142886.0 |
| 2024-05-15 | ES | Stock | 60.85 | 61.01 | 60.32 | 60.53 | 2109000.0 |
| 2024-05-15 | CL | Stock | 94.29 | 94.76 | 94.21 | 94.53 | 2536100.0 |
| 2024-05-15 | A | Stock | 153.0 | 154.55 | 152.51 | 154.08 | 1524600.0 |
| 2024-05-15 | AA | Stock | 40.4 | 40.5 | 39.07 | 40.04 | 5737100.0 |
| 2024-05-15 | AACG | Stock | 0.91 | 0.94 | 0.88 | 0.93 | 8100.0 |
| 2024-05-15 | AACIU | Stock | 11.43 | 11.43 | 11.43 | 11.43 | 100.0 |
| 2024-05-15 | AACIW-DELISTED | Stock | 0.13 | 0.1349 | 0.12 | 0.12 | 6669.0 |
| 2024-05-15 | AACT | Stock | 10.61 | 10.63 | 10.61 | 10.622 | 23500.0 |
| 2024-05-15 | AAGR-DELISTED | Stock | 0.3625 | 0.4081 | 0.3513 | 0.3751 | 28826.0 |
| 2024-05-15 | AAGRW-DELISTED | Stock | 0.0113 | 0.01185 | 0.0113 | 0.0113 | 2494.0 |
| 2024-05-15 | AAL | Stock | 15.2 | 15.25 | 14.91 | 14.94 | 25983600.0 |
| 2024-05-15 | AAMC-DELISTED | Stock | 2.96 | 3.13 | 2.96 | 3.13 | 2300.0 |
| 2024-05-15 | AAME | Stock | 1.79 | 1.79 | 1.76 | 1.76 | 2200.0 |
| 2024-05-15 | AAMI | Stock | 23.07 | 23.26 | 22.77 | 22.8 | 234300.0 |
| 2024-05-15 | AAN-DELISTED | Stock | 7.67 | 7.67 | 7.35 | 7.4 | 126500.0 |
| 2024-05-15 | AAOI | Stock | 11.4 | 11.48 | 10.74 | 11.01 | 1983700.0 |
| 2024-05-15 | AAON | Stock | 76.39 | 78.0 | 75.21 | 75.82 | 1002300.0 |
| 2024-05-15 | AAP | Stock | 76.37 | 77.13 | 75.45 | 75.86 | 1274600.0 |
| 2024-05-15 | AAT | Stock | 22.96 | 23.02 | 22.58 | 22.62 | 152700.0 |
| 2024-05-15 | AATC | Stock | 6.685 | 6.738 | 6.685 | 6.73 | 2446.0 |
| 2024-05-15 | AAUAF-DELISTED | Stock | 0.13 | 0.13 | 0.1219 | 0.1219 | 52921.0 |
| 2024-05-15 | AAXJ | Stock | 72.59 | 72.89 | 72.31 | 72.84 | 293858.0 |
| 2024-05-15 | AB | Stock | 33.72 | 34.23 | 33.57 | 34.18 | 365700.0 |
| 2024-05-15 | ABAT | Stock | 1.33 | 1.37 | 1.3 | 1.31 | 416222.0 |
| 2024-05-15 | ABBV | Stock | 162.31 | 164.42 | 161.87 | 163.79 | 5261300.0 |
| 2024-05-15 | ABCB | Stock | 50.6 | 50.7 | 49.8 | 50.2 | 217800.0 |
| 2024-05-15 | ABCL | Stock | 3.9 | 3.915 | 3.69 | 3.7 | 1027500.0 |
| 2024-05-15 | ABEO | Stock | 4.24 | 4.94 | 4.24 | 4.71 | 1101500.0 |
| 2024-05-15 | ABEV | Stock | 2.37 | 2.41 | 2.35 | 2.39 | 16055900.0 |
| 2024-05-15 | ABG | Stock | 245.09 | 245.09 | 236.97 | 239.73 | 152700.0 |
| 2024-05-15 | ABLLW | Stock | 0.37 | 0.4499 | 0.33 | 0.37 | 115908.0 |
| 2024-05-15 | ABLV | Stock | 1.595 | 1.98 | 1.595 | 1.67 | 14800.0 |
| 2024-05-15 | ABM | Stock | 46.15 | 46.19 | 45.76 | 46.02 | 377800.0 |
| 2024-05-15 | ABNB | Stock | 147.57 | 147.69 | 144.75 | 145.8 | 5996000.0 |
| 2024-05-15 | ABOS | Stock | 3.69 | 3.92 | 3.601 | 3.8 | 214000.0 |
| 2024-05-15 | ABR | Stock | 15.21 | 15.28 | 14.42 | 14.68 | 7360400.0 |
| 2024-05-15 | ABR.D | Stock | 18.6 | 18.64 | 18.5001 | 18.6 | 7089.0 |
| 2024-05-15 | ABR.E | Stock | 18.33 | 18.33 | 18.0001 | 18.3 | 4257.0 |
| 2024-05-15 | ABR.F | Stock | 19.59 | 20.0 | 19.4 | 20.0 | 10403.0 |
| 2024-05-15 | ABSI | Stock | 4.96 | 5.09 | 4.7 | 4.825 | 597600.0 |
| 2024-05-15 | ABT | Stock | 104.1 | 104.83 | 104.1 | 104.59 | 5443200.0 |
| 2024-05-15 | ABTC | Stock | 126.74999999999999 | 131.25 | 120.0 | 123.375 | 5186.666666666667 |
> showing 50 of 7,245 rows — these rows as CSV