PREVIEW / stock_daily / 2024-03-26
file: by_date/stock_daily/2024/2024-03-26.parquet size: 234 KB rows: 7,291 symbols: 1,063
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-26 | AAPL | Stock | 170.0 | 171.42 | 169.58 | 169.71 | 57388400.0 |
| 2024-03-26 | MSFT | Stock | 425.61 | 425.99 | 421.35 | 421.65 | 16725600.0 |
| 2024-03-26 | NVDA | Stock | 95.851 | 96.375 | 92.502 | 92.561 | 513648000.0 |
| 2024-03-26 | AMZN | Stock | 180.15 | 180.45 | 177.95 | 178.3 | 29659000.0 |
| 2024-03-26 | GOOGL | Stock | 150.22 | 152.256 | 149.98 | 150.67 | 22149137.0 |
| 2024-03-26 | META | Stock | 505.13 | 510.0 | 495.21 | 495.89 | 11205400.0 |
| 2024-03-26 | TSLA | Stock | 178.58 | 184.25 | 177.38 | 177.67 | 113186200.0 |
| 2024-03-26 | TLT | Stock | 93.51 | 93.87 | 93.2813 | 93.77 | 34422997.0 |
| 2024-03-26 | ES | Stock | 57.49 | 57.82 | 56.16 | 56.29 | 2165600.0 |
| 2024-03-26 | CL | Stock | 88.73 | 89.17 | 88.59 | 88.9 | 3287700.0 |
| 2024-03-26 | A | Stock | 145.61 | 146.26 | 144.38 | 144.41 | 2021000.0 |
| 2024-03-26 | AA | Stock | 32.32 | 32.32 | 31.23 | 31.58 | 3765000.0 |
| 2024-03-26 | AACG | Stock | 1.08 | 1.08 | 1.01 | 1.02 | 7300.0 |
| 2024-03-26 | AACIW-DELISTED | Stock | 0.0755 | 0.0755 | 0.0755 | 0.0755 | 100.0 |
| 2024-03-26 | AACT | Stock | 10.58 | 10.58 | 10.56 | 10.56 | 55000.0 |
| 2024-03-26 | AAGR-DELISTED | Stock | 0.3973 | 0.41 | 0.3907 | 0.3995 | 59150.0 |
| 2024-03-26 | AAGRW-DELISTED | Stock | 0.0174 | 0.0175 | 0.0126 | 0.0126 | 3550.0 |
| 2024-03-26 | AAL | Stock | 14.99 | 15.12 | 14.9 | 14.92 | 20898500.0 |
| 2024-03-26 | AAME | Stock | 2.78 | 2.78 | 2.63 | 2.75 | 3400.0 |
| 2024-03-26 | AAMI | Stock | 22.7 | 22.77 | 22.5 | 22.55 | 173800.0 |
| 2024-03-26 | AAN-DELISTED | Stock | 7.32 | 7.32 | 7.04 | 7.04 | 193200.0 |
| 2024-03-26 | AAOI | Stock | 14.68 | 14.94 | 14.43 | 14.44 | 1150800.0 |
| 2024-03-26 | AAON | Stock | 86.09 | 86.95 | 85.76 | 86.57 | 238000.0 |
| 2024-03-26 | AAP | Stock | 84.35 | 85.11 | 83.87 | 84.25 | 1698100.0 |
| 2024-03-26 | AAT | Stock | 21.41 | 21.5 | 21.07 | 21.09 | 227000.0 |
| 2024-03-26 | AATC | Stock | 6.54 | 6.655 | 5.84 | 6.485 | 21065.0 |
| 2024-03-26 | AAU-DELISTED | Stock | 0.1405 | 0.1408 | 0.14 | 0.1401 | 170428.0 |
| 2024-03-26 | AAUAF-DELISTED | Stock | 0.1405 | 0.1408 | 0.14 | 0.1401 | 169010.0 |
| 2024-03-26 | AAXJ | Stock | 67.77 | 67.8 | 67.51 | 67.52 | 768335.0 |
| 2024-03-26 | AB | Stock | 33.99 | 34.4 | 33.85 | 34.2 | 259100.0 |
| 2024-03-26 | ABAT | Stock | 1.77 | 1.78 | 1.7 | 1.705 | 550808.0 |
| 2024-03-26 | ABBV | Stock | 179.23 | 179.77 | 178.38 | 179.19 | 4392400.0 |
| 2024-03-26 | ABCB | Stock | 47.3 | 47.3 | 46.42 | 46.55 | 293700.0 |
| 2024-03-26 | ABCL | Stock | 4.64 | 4.69 | 4.27 | 4.29 | 1669800.0 |
| 2024-03-26 | ABEO | Stock | 7.22 | 7.52 | 7.16 | 7.36 | 198600.0 |
| 2024-03-26 | ABEV | Stock | 2.48 | 2.49 | 2.45 | 2.47 | 8367700.0 |
| 2024-03-26 | ABG | Stock | 225.36 | 226.9 | 223.2 | 225.54 | 122900.0 |
| 2024-03-26 | ABLLW | Stock | 0.6428 | 0.6673 | 0.595 | 0.61 | 20754.0 |
| 2024-03-26 | ABLV | Stock | 2.28 | 2.45 | 2.07 | 2.443 | 38200.0 |
| 2024-03-26 | ABLVW | Stock | 0.043 | 0.0529 | 0.043 | 0.045 | 7915.0 |
| 2024-03-26 | ABM | Stock | 43.86 | 43.89 | 43.43 | 43.74 | 358500.0 |
| 2024-03-26 | ABNB | Stock | 169.69 | 170.0 | 167.32 | 167.39 | 2747700.0 |
| 2024-03-26 | ABOS | Stock | 4.06 | 4.255 | 3.31 | 3.75 | 1387600.0 |
| 2024-03-26 | ABR | Stock | 13.05 | 13.08 | 12.81 | 12.85 | 2055200.0 |
| 2024-03-26 | ABR.D | Stock | 19.02 | 19.1 | 18.92 | 19.09 | 11684.0 |
| 2024-03-26 | ABR.E | Stock | 19.12 | 19.12 | 19.01 | 19.1043 | 3271.0 |
| 2024-03-26 | ABR.F | Stock | 19.35 | 19.4899 | 19.3 | 19.48 | 29538.0 |
| 2024-03-26 | ABSI | Stock | 5.11 | 5.56 | 5.11 | 5.21 | 2082200.0 |
| 2024-03-26 | ABT | Stock | 110.49 | 111.9 | 109.93 | 111.5 | 7770600.0 |
| 2024-03-26 | ABTC | Stock | 110.25 | 113.25 | 101.25 | 103.5 | 5246.666666666667 |
> showing 50 of 7,291 rows — these rows as CSV