PREVIEW / stock_daily / 2024-04-23
file: by_date/stock_daily/2024/2024-04-23.parquet size: 229 KB rows: 7,164 symbols: 977
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-04-23 | AAPL | Stock | 165.35 | 167.05 | 164.92 | 166.9 | 49537800.0 |
| 2024-04-23 | MSFT | Stock | 404.24 | 408.2 | 403.06 | 407.57 | 15734500.0 |
| 2024-04-23 | NVDA | Stock | 80.769 | 82.769 | 80.264 | 82.423 | 438559000.0 |
| 2024-04-23 | AMZN | Stock | 178.08 | 179.93 | 175.98 | 179.54 | 37046500.0 |
| 2024-04-23 | GOOGL | Stock | 156.96 | 158.97 | 156.28 | 158.26 | 21151568.0 |
| 2024-04-23 | META | Stock | 491.25 | 498.76 | 488.97 | 496.1 | 15079200.0 |
| 2024-04-23 | TSLA | Stock | 143.33 | 147.26 | 141.11 | 144.68 | 124545100.0 |
| 2024-04-23 | TLT | Stock | 88.73 | 89.54 | 88.55 | 89.03 | 27222722.0 |
| 2024-04-23 | ES | Stock | 60.03 | 60.99 | 59.82 | 60.35 | 1831900.0 |
| 2024-04-23 | CL | Stock | 89.17 | 89.3 | 88.39 | 88.58 | 4014800.0 |
| 2024-04-23 | A | Stock | 137.98 | 139.65 | 136.01 | 139.2 | 1979400.0 |
| 2024-04-23 | AA | Stock | 35.0 | 36.395 | 34.51 | 36.06 | 7574400.0 |
| 2024-04-23 | AACG | Stock | 0.96 | 0.98 | 0.89 | 0.89 | 16900.0 |
| 2024-04-23 | AACIW-DELISTED | Stock | 0.1345 | 0.1898 | 0.13 | 0.16 | 225887.0 |
| 2024-04-23 | AACT | Stock | 10.65 | 10.65 | 10.61 | 10.61 | 41700.0 |
| 2024-04-23 | AAGR-DELISTED | Stock | 0.325 | 0.3847 | 0.31555 | 0.35 | 254598.0 |
| 2024-04-23 | AAGRW-DELISTED | Stock | 0.0126 | 0.0132 | 0.0126 | 0.0129 | 1431.0 |
| 2024-04-23 | AAL | Stock | 13.96 | 14.44 | 13.88 | 14.23 | 40237300.0 |
| 2024-04-23 | AAMC-DELISTED | Stock | 3.15 | 3.29 | 3.13 | 3.18 | 2500.0 |
| 2024-04-23 | AAME | Stock | 1.96 | 1.96 | 1.92 | 1.92 | 1700.0 |
| 2024-04-23 | AAMI | Stock | 23.4 | 23.63 | 23.36 | 23.51 | 148500.0 |
| 2024-04-23 | AAN-DELISTED | Stock | 7.4 | 7.55 | 7.341 | 7.35 | 138400.0 |
| 2024-04-23 | AAOI | Stock | 11.15 | 11.69 | 11.015 | 11.26 | 1095900.0 |
| 2024-04-23 | AAON | Stock | 87.25 | 88.97 | 86.74 | 88.56 | 452600.0 |
| 2024-04-23 | AAP | Stock | 77.44 | 78.08 | 75.87 | 78.0 | 1267500.0 |
| 2024-04-23 | AAT | Stock | 21.38 | 21.86 | 21.38 | 21.62 | 195200.0 |
| 2024-04-23 | AATC | Stock | 6.39 | 6.47 | 6.36 | 6.47 | 1743.0 |
| 2024-04-23 | AAUAF-DELISTED | Stock | 0.119 | 0.1246 | 0.116 | 0.12 | 240476.0 |
| 2024-04-23 | AAXJ | Stock | 66.57 | 66.97 | 66.405 | 66.97 | 393221.0 |
| 2024-04-23 | AB | Stock | 33.75 | 33.8 | 33.23 | 33.5 | 424000.0 |
| 2024-04-23 | ABAT | Stock | 1.35 | 1.36 | 1.24 | 1.28 | 628930.0 |
| 2024-04-23 | ABBV | Stock | 168.59 | 170.37 | 168.22 | 169.54 | 4084100.0 |
| 2024-04-23 | ABCB | Stock | 46.84 | 48.12 | 46.71 | 47.86 | 215700.0 |
| 2024-04-23 | ABCL | Stock | 4.0 | 4.31 | 3.965 | 3.97 | 1595100.0 |
| 2024-04-23 | ABEO | Stock | 3.81 | 4.25 | 3.34 | 3.41 | 5512800.0 |
| 2024-04-23 | ABEV | Stock | 2.29 | 2.31 | 2.28 | 2.3 | 8800700.0 |
| 2024-04-23 | ABG | Stock | 218.23 | 223.04 | 217.67 | 222.19 | 151400.0 |
| 2024-04-23 | ABLLW | Stock | 0.52 | 0.56 | 0.5 | 0.56 | 27701.0 |
| 2024-04-23 | ABLV | Stock | 1.6 | 1.65 | 1.58 | 1.6 | 68600.0 |
| 2024-04-23 | ABM | Stock | 44.33 | 44.76 | 44.3 | 44.65 | 360800.0 |
| 2024-04-23 | ABNB | Stock | 157.24 | 161.14 | 156.7 | 160.95 | 3455400.0 |
| 2024-04-23 | ABOS | Stock | 3.19 | 3.319 | 3.14 | 3.16 | 270700.0 |
| 2024-04-23 | ABR | Stock | 12.76 | 13.24 | 12.74 | 13.2 | 4736900.0 |
| 2024-04-23 | ABR.D | Stock | 18.23 | 18.28 | 17.77 | 17.89 | 15434.0 |
| 2024-04-23 | ABR.E | Stock | 17.788 | 18.08 | 17.75 | 17.9 | 7574.0 |
| 2024-04-23 | ABR.F | Stock | 18.99 | 18.99 | 18.55 | 18.84 | 12757.0 |
| 2024-04-23 | ABSI | Stock | 4.45 | 5.06 | 4.44 | 4.71 | 1238700.0 |
| 2024-04-23 | ABT | Stock | 107.67 | 108.11 | 107.31 | 107.59 | 3849600.0 |
| 2024-04-23 | ABTC | Stock | 102.0 | 103.5 | 95.25 | 99.0 | 4990.666666666667 |
| 2024-04-23 | ABTS | Stock | 11.13 | 11.55 | 10.8 | 11.265 | 2533.0 |
> showing 50 of 7,164 rows — these rows as CSV