PREVIEW / stock_daily / 2024-05-14
file: by_date/stock_daily/2024/2024-05-14.parquet size: 231 KB rows: 7,199 symbols: 967
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-14 | AAPL | Stock | 187.51 | 188.3 | 186.29 | 187.43 | 52393600.0 |
| 2024-05-14 | MSFT | Stock | 412.02 | 417.49 | 411.55 | 416.56 | 15109300.0 |
| 2024-05-14 | NVDA | Stock | 89.599 | 91.651 | 88.934 | 91.356 | 296507000.0 |
| 2024-05-14 | AMZN | Stock | 183.82 | 187.72 | 183.45 | 187.07 | 38698200.0 |
| 2024-05-14 | GOOGL | Stock | 169.77 | 171.25 | 168.8 | 170.34 | 25127138.0 |
| 2024-05-14 | META | Stock | 463.37 | 472.54 | 460.08 | 471.85 | 10478600.0 |
| 2024-05-14 | TSLA | Stock | 174.5 | 179.49 | 174.07 | 177.55 | 86407400.0 |
| 2024-05-14 | TLT | Stock | 90.65 | 90.9199 | 90.42 | 90.86 | 25746391.0 |
| 2024-05-14 | ES | Stock | 61.88 | 61.99 | 60.86 | 60.9 | 1767500.0 |
| 2024-05-14 | CL | Stock | 94.41 | 94.72 | 93.75 | 94.57 | 3971500.0 |
| 2024-05-14 | A | Stock | 148.75 | 151.55 | 148.38 | 151.28 | 1679900.0 |
| 2024-05-14 | AA | Stock | 40.38 | 40.84 | 39.509 | 39.83 | 5399200.0 |
| 2024-05-14 | AACG | Stock | 0.83 | 0.97 | 0.83 | 0.92 | 20600.0 |
| 2024-05-14 | AACIU | Stock | 11.59 | 11.59 | 10.45 | 11.11 | 2700.0 |
| 2024-05-14 | AACIW-DELISTED | Stock | 0.1419 | 0.1419 | 0.13 | 0.1301 | 6134.0 |
| 2024-05-14 | AACT | Stock | 10.58 | 10.63 | 10.58 | 10.58 | 32400.0 |
| 2024-05-14 | AAGR-DELISTED | Stock | 0.357 | 0.3966 | 0.357 | 0.3756 | 90423.0 |
| 2024-05-14 | AAL | Stock | 15.09 | 15.36 | 15.07 | 15.19 | 27970400.0 |
| 2024-05-14 | AAMC-DELISTED | Stock | 3.18 | 3.29 | 3.0 | 3.0 | 19800.0 |
| 2024-05-14 | AAME | Stock | 1.67 | 1.81 | 1.67 | 1.79 | 2600.0 |
| 2024-05-14 | AAMI | Stock | 22.78 | 23.01 | 22.71 | 22.96 | 275000.0 |
| 2024-05-14 | AAN-DELISTED | Stock | 7.7 | 7.78 | 7.57 | 7.59 | 150900.0 |
| 2024-05-14 | AAOI | Stock | 10.24 | 11.19 | 10.21 | 11.16 | 2368800.0 |
| 2024-05-14 | AAON | Stock | 76.0 | 76.65 | 74.67 | 75.4 | 618600.0 |
| 2024-05-14 | AAP | Stock | 76.38 | 76.9 | 74.84 | 75.64 | 1127500.0 |
| 2024-05-14 | AAT | Stock | 22.5 | 22.66 | 22.37 | 22.59 | 252000.0 |
| 2024-05-14 | AATC | Stock | 6.66 | 6.74 | 6.5 | 6.74 | 21956.0 |
| 2024-05-14 | AAUAF-DELISTED | Stock | 0.1223 | 0.1299 | 0.118 | 0.125 | 11033.0 |
| 2024-05-14 | AAXJ | Stock | 71.6 | 72.06 | 71.6 | 72.01 | 353816.0 |
| 2024-05-14 | AB | Stock | 32.87 | 33.69 | 32.79 | 33.52 | 254200.0 |
| 2024-05-14 | ABAT | Stock | 1.35 | 1.36 | 1.31 | 1.31 | 376625.0 |
| 2024-05-14 | ABBV | Stock | 161.65 | 162.25 | 159.72 | 161.59 | 4025000.0 |
| 2024-05-14 | ABCB | Stock | 50.1 | 50.25 | 49.34 | 49.91 | 176900.0 |
| 2024-05-14 | ABCL | Stock | 3.92 | 4.015 | 3.82 | 3.82 | 1267000.0 |
| 2024-05-14 | ABEO | Stock | 4.37 | 4.56 | 4.09 | 4.2 | 955300.0 |
| 2024-05-14 | ABEV | Stock | 2.35 | 2.38 | 2.34 | 2.36 | 10184700.0 |
| 2024-05-14 | ABG | Stock | 240.87 | 244.69 | 239.76 | 242.99 | 289700.0 |
| 2024-05-14 | ABLLW | Stock | 0.46595 | 0.46595 | 0.3333 | 0.3954 | 136585.0 |
| 2024-05-14 | ABLV | Stock | 1.605 | 1.605 | 1.54 | 1.55 | 3300.0 |
| 2024-05-14 | ABM | Stock | 46.26 | 46.27 | 45.43 | 45.95 | 375300.0 |
| 2024-05-14 | ABNB | Stock | 149.4 | 149.4 | 146.31 | 146.7 | 4167400.0 |
| 2024-05-14 | ABOS | Stock | 3.59 | 3.74 | 3.387 | 3.69 | 231200.0 |
| 2024-05-14 | ABR | Stock | 14.27 | 15.48 | 14.19 | 15.1 | 19817700.0 |
| 2024-05-14 | ABR.D | Stock | 18.49 | 18.64 | 18.35 | 18.42 | 13359.0 |
| 2024-05-14 | ABR.E | Stock | 18.25 | 18.32 | 18.0 | 18.0 | 12943.0 |
| 2024-05-14 | ABR.F | Stock | 19.5 | 19.65 | 19.25 | 19.29 | 17736.0 |
| 2024-05-14 | ABSI | Stock | 4.6 | 5.35 | 4.49 | 4.83 | 699000.0 |
| 2024-05-14 | ABT | Stock | 104.85 | 105.13 | 103.36 | 104.01 | 7035100.0 |
| 2024-05-14 | ABTC | Stock | 121.5 | 130.5 | 116.25 | 130.5 | 7790.666666666667 |
| 2024-05-14 | ABTS | Stock | 10.92 | 12.0 | 10.5 | 10.95 | 1680.0 |
> showing 50 of 7,199 rows — these rows as CSV