PREVIEW / stock_daily / 2024-05-03
file: by_date/stock_daily/2024/2024-05-03.parquet size: 230 KB rows: 7,152 symbols: 972
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-03 | AAPL | Stock | 186.65 | 187.0 | 182.66 | 183.38 | 163224100.0 |
| 2024-05-03 | MSFT | Stock | 402.28 | 407.15 | 401.86 | 406.66 | 17446700.0 |
| 2024-05-03 | NVDA | Stock | 87.789 | 89.281 | 87.04 | 88.789 | 398341000.0 |
| 2024-05-03 | AMZN | Stock | 186.99 | 187.87 | 185.42 | 186.21 | 39172000.0 |
| 2024-05-03 | GOOGL | Stock | 167.56 | 167.96 | 163.05 | 167.24 | 34662432.0 |
| 2024-05-03 | META | Stock | 445.93 | 454.17 | 443.85 | 451.96 | 16489100.0 |
| 2024-05-03 | TSLA | Stock | 182.1 | 184.78 | 178.42 | 181.19 | 75491500.0 |
| 2024-05-03 | TLT | Stock | 89.93 | 90.12 | 89.27 | 89.84 | 50066075.0 |
| 2024-05-03 | ES | Stock | 61.19 | 61.5 | 58.9 | 60.01 | 3447900.0 |
| 2024-05-03 | CL | Stock | 92.93 | 93.05 | 91.31 | 92.88 | 5432700.0 |
| 2024-05-03 | A | Stock | 139.69 | 140.95 | 138.41 | 139.45 | 1097900.0 |
| 2024-05-03 | AA | Stock | 36.7 | 37.2 | 36.25 | 36.77 | 5496600.0 |
| 2024-05-03 | AACG | Stock | 0.89 | 0.94 | 0.86 | 0.91 | 12000.0 |
| 2024-05-03 | AACIW-DELISTED | Stock | 0.1495 | 0.15 | 0.14 | 0.14 | 10818.0 |
| 2024-05-03 | AACT | Stock | 10.62 | 10.64 | 10.62 | 10.62 | 12200.0 |
| 2024-05-03 | AAGR-DELISTED | Stock | 0.3605 | 0.373 | 0.33 | 0.349 | 90695.0 |
| 2024-05-03 | AAGRW-DELISTED | Stock | 0.01335 | 0.01399 | 0.0115 | 0.0115 | 16514.0 |
| 2024-05-03 | AAL | Stock | 14.0 | 14.07 | 13.72 | 13.85 | 22056600.0 |
| 2024-05-03 | AAMC-DELISTED | Stock | 3.06 | 3.21 | 3.06 | 3.21 | 2400.0 |
| 2024-05-03 | AAME | Stock | 1.98 | 1.98 | 1.87 | 1.88 | 1700.0 |
| 2024-05-03 | AAMI | Stock | 22.96 | 22.96 | 22.55 | 22.56 | 180600.0 |
| 2024-05-03 | AAN-DELISTED | Stock | 6.93 | 7.05 | 6.88 | 6.95 | 151000.0 |
| 2024-05-03 | AAOI | Stock | 10.6 | 11.45 | 10.54 | 11.07 | 1829600.0 |
| 2024-05-03 | AAON | Stock | 87.0 | 87.23 | 76.67 | 78.4 | 2042900.0 |
| 2024-05-03 | AAP | Stock | 75.85 | 77.39 | 75.71 | 76.31 | 790100.0 |
| 2024-05-03 | AAT | Stock | 21.92 | 22.08 | 21.24 | 21.51 | 248200.0 |
| 2024-05-03 | AATC | Stock | 6.59 | 6.64 | 6.54 | 6.555 | 2194.0 |
| 2024-05-03 | AAUAF-DELISTED | Stock | 0.1249 | 0.125 | 0.118 | 0.118 | 40181.0 |
| 2024-05-03 | AAXJ | Stock | 70.48 | 70.77 | 70.27 | 70.76 | 268105.0 |
| 2024-05-03 | AB | Stock | 32.82 | 33.7 | 32.7 | 33.16 | 244500.0 |
| 2024-05-03 | ABAT | Stock | 1.36 | 1.4 | 1.32 | 1.37 | 502662.0 |
| 2024-05-03 | ABBV | Stock | 161.16 | 164.25 | 160.74 | 163.79 | 5849900.0 |
| 2024-05-03 | ABCB | Stock | 49.86 | 49.99 | 49.19 | 49.82 | 317100.0 |
| 2024-05-03 | ABCL | Stock | 3.92 | 4.2 | 3.92 | 4.03 | 2202900.0 |
| 2024-05-03 | ABEO | Stock | 4.35 | 5.11 | 4.34 | 4.6 | 2685600.0 |
| 2024-05-03 | ABEV | Stock | 2.44 | 2.45 | 2.41 | 2.43 | 5538800.0 |
| 2024-05-03 | ABG | Stock | 211.91 | 215.16 | 211.03 | 213.75 | 201900.0 |
| 2024-05-03 | ABLLW | Stock | 0.58 | 0.5988 | 0.5003 | 0.56972 | 15277.0 |
| 2024-05-03 | ABLV | Stock | 1.48 | 1.48 | 1.44 | 1.44 | 800.0 |
| 2024-05-03 | ABM | Stock | 45.26 | 45.26 | 44.32 | 44.77 | 297600.0 |
| 2024-05-03 | ABNB | Stock | 161.81 | 165.5 | 159.15 | 159.71 | 4529900.0 |
| 2024-05-03 | ABOS | Stock | 3.58 | 3.71 | 3.485 | 3.49 | 247700.0 |
| 2024-05-03 | ABR | Stock | 13.4 | 13.64 | 12.7 | 12.89 | 7027900.0 |
| 2024-05-03 | ABR.D | Stock | 18.43 | 18.54 | 18.3001 | 18.4 | 9253.0 |
| 2024-05-03 | ABR.E | Stock | 18.11 | 18.31 | 17.9 | 18.02 | 14875.0 |
| 2024-05-03 | ABR.F | Stock | 19.57 | 19.57 | 19.3 | 19.5 | 13641.0 |
| 2024-05-03 | ABSI | Stock | 5.23 | 5.44 | 5.055 | 5.08 | 536400.0 |
| 2024-05-03 | ABT | Stock | 106.11 | 106.64 | 105.48 | 105.9 | 3610300.0 |
| 2024-05-03 | ABTC | Stock | 115.5 | 118.5 | 111.75 | 116.25 | 1536.0 |
| 2024-05-03 | ABTS | Stock | 11.55 | 11.7 | 11.25 | 11.7 | 193.0 |
> showing 50 of 7,152 rows — these rows as CSV