PREVIEW / stock_daily / 2024-03-20
file: by_date/stock_daily/2024/2024-03-20.parquet size: 234 KB rows: 7,269 symbols: 1,078
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-03-20 | AAPL | Stock | 175.72 | 178.67 | 175.09 | 178.67 | 53423100.0 |
| 2024-03-20 | MSFT | Stock | 422.0 | 425.96 | 420.66 | 425.23 | 17860100.0 |
| 2024-03-20 | NVDA | Stock | 89.797 | 90.41 | 88.223 | 90.372 | 479063000.0 |
| 2024-03-20 | AMZN | Stock | 176.14 | 178.53 | 174.64 | 178.15 | 29947200.0 |
| 2024-03-20 | GOOGL | Stock | 148.0 | 148.86 | 146.735 | 148.74 | 21311501.0 |
| 2024-03-20 | META | Stock | 499.5 | 508.2 | 495.17 | 505.52 | 11711100.0 |
| 2024-03-20 | TSLA | Stock | 173.0 | 176.25 | 170.82 | 175.66 | 83846700.0 |
| 2024-03-20 | TLT | Stock | 93.1 | 93.79 | 92.29 | 92.89 | 43460080.0 |
| 2024-03-20 | ES | Stock | 58.69 | 59.66 | 58.44 | 59.21 | 1955200.0 |
| 2024-03-20 | CL | Stock | 88.38 | 88.82 | 88.24 | 88.35 | 3366600.0 |
| 2024-03-20 | A | Stock | 147.21 | 147.71 | 146.38 | 147.28 | 1526500.0 |
| 2024-03-20 | AA | Stock | 29.63 | 31.88 | 29.52 | 31.35 | 7446900.0 |
| 2024-03-20 | AACG | Stock | 1.15 | 1.33 | 1.1 | 1.27 | 56300.0 |
| 2024-03-20 | AACIU | Stock | 12.08 | 13.2 | 11.5 | 11.51 | 1158.0 |
| 2024-03-20 | AACIW-DELISTED | Stock | 0.0836 | 0.0929 | 0.08 | 0.087 | 16127.0 |
| 2024-03-20 | AACT | Stock | 10.558 | 10.56 | 10.55 | 10.55 | 7700.0 |
| 2024-03-20 | AAGR-DELISTED | Stock | 0.4401 | 0.469 | 0.413 | 0.425 | 207979.0 |
| 2024-03-20 | AAGRW-DELISTED | Stock | 0.0188 | 0.0188 | 0.013 | 0.013 | 12463.0 |
| 2024-03-20 | AAL | Stock | 13.96 | 14.58 | 13.92 | 14.57 | 33974600.0 |
| 2024-03-20 | AAMC-DELISTED | Stock | 3.51 | 3.79 | 3.41 | 3.57 | 3200.0 |
| 2024-03-20 | AAME | Stock | 2.87 | 2.87 | 2.61 | 2.79 | 12600.0 |
| 2024-03-20 | AAMI | Stock | 22.25 | 22.92 | 22.25 | 22.6 | 168100.0 |
| 2024-03-20 | AAN-DELISTED | Stock | 6.96 | 7.35 | 6.93 | 7.31 | 289700.0 |
| 2024-03-20 | AAOI | Stock | 13.85 | 14.63 | 13.53 | 14.47 | 1758300.0 |
| 2024-03-20 | AAON | Stock | 85.4 | 85.98 | 84.28 | 85.33 | 281900.0 |
| 2024-03-20 | AAP | Stock | 85.17 | 85.35 | 83.75 | 84.84 | 1522100.0 |
| 2024-03-20 | AAT | Stock | 20.95 | 21.63 | 20.95 | 21.51 | 206500.0 |
| 2024-03-20 | AATC | Stock | 7.34 | 7.34 | 7.3 | 7.3 | 1564.0 |
| 2024-03-20 | AAU-DELISTED | Stock | 0.14 | 0.1404 | 0.14 | 0.14 | 211254.0 |
| 2024-03-20 | AAUAF-DELISTED | Stock | 0.14 | 0.1404 | 0.14 | 0.14 | 211821.0 |
| 2024-03-20 | AAXJ | Stock | 67.5 | 67.89 | 67.21 | 67.83 | 434577.0 |
| 2024-03-20 | AB | Stock | 33.62 | 34.6 | 33.37 | 34.48 | 358100.0 |
| 2024-03-20 | ABAT | Stock | 1.99 | 2.13 | 1.94 | 2.05 | 679350.0 |
| 2024-03-20 | ABBV | Stock | 179.22 | 179.23 | 175.73 | 176.27 | 7326600.0 |
| 2024-03-20 | ABCB | Stock | 45.9 | 48.18 | 45.78 | 47.59 | 398600.0 |
| 2024-03-20 | ABCL | Stock | 4.61 | 4.745 | 4.51 | 4.73 | 665400.0 |
| 2024-03-20 | ABEO | Stock | 7.52 | 7.74 | 7.41 | 7.53 | 370900.0 |
| 2024-03-20 | ABEV | Stock | 2.47 | 2.5 | 2.46 | 2.5 | 7377900.0 |
| 2024-03-20 | ABG | Stock | 208.04 | 218.96 | 208.04 | 218.61 | 181400.0 |
| 2024-03-20 | ABLLW | Stock | 0.6 | 0.65 | 0.6 | 0.62 | 26403.0 |
| 2024-03-20 | ABLV | Stock | 3.01 | 3.09 | 2.7 | 2.86 | 241600.0 |
| 2024-03-20 | ABLVW | Stock | 0.08 | 0.08 | 0.0372 | 0.04 | 84176.0 |
| 2024-03-20 | ABM | Stock | 43.17 | 44.01 | 43.14 | 43.8 | 793300.0 |
| 2024-03-20 | ABNB | Stock | 162.39 | 165.75 | 162.265 | 164.71 | 4766300.0 |
| 2024-03-20 | ABOS | Stock | 4.0 | 4.21 | 3.99 | 4.15 | 279700.0 |
| 2024-03-20 | ABR | Stock | 12.61 | 13.05 | 12.52 | 12.98 | 3627000.0 |
| 2024-03-20 | ABR.D | Stock | 18.65 | 18.88 | 18.475 | 18.77 | 17083.0 |
| 2024-03-20 | ABR.E | Stock | 18.83 | 19.49 | 18.83 | 19.49 | 3469.0 |
| 2024-03-20 | ABR.F | Stock | 19.2243 | 19.4 | 19.1201 | 19.3 | 22848.0 |
| 2024-03-20 | ABSI | Stock | 4.81 | 5.2 | 4.72 | 5.09 | 848000.0 |
> showing 50 of 7,269 rows — these rows as CSV