PREVIEW / stock_daily / 2024-05-16
file: by_date/stock_daily/2024/2024-05-16.parquet size: 232 KB rows: 7,221 symbols: 969
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-16 | AAPL | Stock | 190.47 | 191.1 | 189.66 | 189.84 | 52845200.0 |
| 2024-05-16 | MSFT | Stock | 421.8 | 425.42 | 420.35 | 420.99 | 17530100.0 |
| 2024-05-16 | NVDA | Stock | 94.91 | 95.819 | 94.103 | 94.359 | 323952000.0 |
| 2024-05-16 | AMZN | Stock | 185.6 | 187.31 | 183.46 | 183.63 | 38834500.0 |
| 2024-05-16 | GOOGL | Stock | 173.29 | 175.115 | 172.69 | 174.18 | 27867947.0 |
| 2024-05-16 | META | Stock | 475.0 | 477.69 | 472.75 | 473.23 | 16608200.0 |
| 2024-05-16 | TSLA | Stock | 174.1 | 175.79 | 171.43 | 174.84 | 59812200.0 |
| 2024-05-16 | TLT | Stock | 92.39 | 92.4205 | 91.94 | 92.01 | 37902425.0 |
| 2024-05-16 | ES | Stock | 60.53 | 61.83 | 60.19 | 61.46 | 3011100.0 |
| 2024-05-16 | CL | Stock | 94.65 | 94.81 | 94.11 | 94.53 | 3240600.0 |
| 2024-05-16 | A | Stock | 152.57 | 154.84 | 152.57 | 154.31 | 1325000.0 |
| 2024-05-16 | AA | Stock | 40.0 | 40.8 | 39.8 | 40.15 | 3743700.0 |
| 2024-05-16 | AACG | Stock | 0.91 | 0.92 | 0.9 | 0.91 | 6600.0 |
| 2024-05-16 | AACIW-DELISTED | Stock | 0.1199 | 0.1413 | 0.1199 | 0.1413 | 16485.0 |
| 2024-05-16 | AACT | Stock | 10.64 | 10.64 | 10.6 | 10.625 | 6100.0 |
| 2024-05-16 | AAGR-DELISTED | Stock | 0.38 | 0.384 | 0.3675 | 0.3839 | 33195.0 |
| 2024-05-16 | AAGRW-DELISTED | Stock | 0.0113 | 0.0113 | 0.0113 | 0.0113 | 130.0 |
| 2024-05-16 | AAL | Stock | 15.0 | 15.08 | 14.66 | 14.79 | 22652500.0 |
| 2024-05-16 | AAMC-DELISTED | Stock | 3.51 | 3.51 | 2.61 | 2.72 | 52500.0 |
| 2024-05-16 | AAME | Stock | 1.73 | 1.75 | 1.69 | 1.71 | 5200.0 |
| 2024-05-16 | AAMI | Stock | 22.84 | 23.47 | 22.78 | 23.46 | 217300.0 |
| 2024-05-16 | AAN-DELISTED | Stock | 7.43 | 7.58 | 7.4 | 7.54 | 166900.0 |
| 2024-05-16 | AAOI | Stock | 11.3 | 11.895 | 11.01 | 11.23 | 2272200.0 |
| 2024-05-16 | AAON | Stock | 75.72 | 75.72 | 74.16 | 74.86 | 687100.0 |
| 2024-05-16 | AAP | Stock | 74.12 | 75.89 | 73.34 | 73.95 | 1715100.0 |
| 2024-05-16 | AAT | Stock | 22.55 | 22.81 | 22.5 | 22.79 | 366000.0 |
| 2024-05-16 | AATC | Stock | 6.75 | 6.7715 | 6.4 | 6.4025 | 7256.0 |
| 2024-05-16 | AAUAF-DELISTED | Stock | 0.1223 | 0.13 | 0.1219 | 0.13 | 109329.0 |
| 2024-05-16 | AAXJ | Stock | 72.98 | 73.32 | 72.82 | 73.11 | 926338.0 |
| 2024-05-16 | AB | Stock | 34.2 | 34.52 | 33.95 | 33.96 | 297200.0 |
| 2024-05-16 | ABAT | Stock | 1.37 | 1.37 | 1.28 | 1.33 | 377138.0 |
| 2024-05-16 | ABBV | Stock | 163.45 | 164.93 | 162.18 | 164.35 | 4642000.0 |
| 2024-05-16 | ABCB | Stock | 50.19 | 50.59 | 50.0 | 50.24 | 171000.0 |
| 2024-05-16 | ABCL | Stock | 3.73 | 3.85 | 3.665 | 3.78 | 1348100.0 |
| 2024-05-16 | ABEO | Stock | 4.83 | 4.83 | 4.53 | 4.6 | 501100.0 |
| 2024-05-16 | ABEV | Stock | 2.41 | 2.43 | 2.37 | 2.39 | 10319000.0 |
| 2024-05-16 | ABG | Stock | 243.52 | 245.15 | 238.97 | 243.88 | 190400.0 |
| 2024-05-16 | ABLLW | Stock | 0.38 | 0.4098 | 0.34 | 0.3435 | 63701.0 |
| 2024-05-16 | ABLV | Stock | 1.66 | 1.92 | 1.6 | 1.63 | 14400.0 |
| 2024-05-16 | ABM | Stock | 45.86 | 46.68 | 45.81 | 46.66 | 310700.0 |
| 2024-05-16 | ABNB | Stock | 146.34 | 147.79 | 145.85 | 147.19 | 3827800.0 |
| 2024-05-16 | ABOS | Stock | 3.79 | 3.85 | 3.72 | 3.73 | 83400.0 |
| 2024-05-16 | ABR | Stock | 14.14 | 14.17 | 13.66 | 13.81 | 4316600.0 |
| 2024-05-16 | ABR.D | Stock | 18.46 | 18.6 | 18.46 | 18.6 | 10155.0 |
| 2024-05-16 | ABR.E | Stock | 18.1676 | 18.4399 | 18.1107 | 18.35 | 6262.0 |
| 2024-05-16 | ABR.F | Stock | 19.95 | 19.95 | 19.6169 | 19.88 | 5835.0 |
| 2024-05-16 | ABSI | Stock | 4.85 | 4.865 | 4.64 | 4.74 | 692300.0 |
| 2024-05-16 | ABT | Stock | 104.45 | 105.19 | 104.16 | 104.87 | 8708300.0 |
| 2024-05-16 | ABTC | Stock | 129.75 | 130.5 | 117.0 | 122.25 | 7690.666666666667 |
| 2024-05-16 | ABTS | Stock | 9.96 | 10.95 | 9.96 | 10.65 | 1067.0 |
> showing 50 of 7,221 rows — these rows as CSV