PREVIEW / stock_daily / 2024-04-29
file: by_date/stock_daily/2024/2024-04-29.parquet size: 231 KB rows: 7,201 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-29 | AAPL | Stock | 173.37 | 176.03 | 173.1 | 173.5 | 68169400.0 |
| 2024-04-29 | MSFT | Stock | 405.25 | 406.32 | 399.19 | 402.25 | 19582100.0 |
| 2024-04-29 | NVDA | Stock | 87.595 | 87.992 | 85.266 | 87.757 | 388971000.0 |
| 2024-04-29 | AMZN | Stock | 182.75 | 183.53 | 179.39 | 180.96 | 54063900.0 |
| 2024-04-29 | GOOGL | Stock | 169.058 | 169.55 | 165.21 | 166.15 | 45610024.0 |
| 2024-04-29 | META | Stock | 439.56 | 439.76 | 428.56 | 432.62 | 21502600.0 |
| 2024-04-29 | TSLA | Stock | 188.42 | 198.87 | 184.54 | 194.05 | 243869700.0 |
| 2024-04-29 | TLT | Stock | 88.66 | 89.015 | 88.48 | 88.98 | 39228621.0 |
| 2024-04-29 | ES | Stock | 59.82 | 60.77 | 59.68 | 60.46 | 1789900.0 |
| 2024-04-29 | CL | Stock | 91.0 | 91.25 | 89.96 | 90.49 | 4472100.0 |
| 2024-04-29 | A | Stock | 138.26 | 139.87 | 137.88 | 139.59 | 781200.0 |
| 2024-04-29 | AA | Stock | 36.88 | 38.2 | 36.65 | 37.65 | 5667100.0 |
| 2024-04-29 | AACG | Stock | 0.91 | 0.91 | 0.87 | 0.87 | 14500.0 |
| 2024-04-29 | AACIW-DELISTED | Stock | 0.142 | 0.1805 | 0.136 | 0.145 | 114654.0 |
| 2024-04-29 | AACT | Stock | 10.61 | 10.625 | 10.61 | 10.62 | 30100.0 |
| 2024-04-29 | AAGR-DELISTED | Stock | 0.3299 | 0.3466 | 0.3299 | 0.3379 | 112988.0 |
| 2024-04-29 | AAGRW-DELISTED | Stock | 0.0128 | 0.014 | 0.0128 | 0.0139 | 1976.0 |
| 2024-04-29 | AAL | Stock | 13.85 | 14.02 | 13.73 | 13.98 | 28817400.0 |
| 2024-04-29 | AAMC-DELISTED | Stock | 3.12 | 3.15 | 2.748 | 2.93 | 21100.0 |
| 2024-04-29 | AAME | Stock | 1.99 | 2.03 | 1.88 | 1.88 | 1600.0 |
| 2024-04-29 | AAMI | Stock | 22.59 | 22.85 | 22.51 | 22.57 | 124200.0 |
| 2024-04-29 | AAN-DELISTED | Stock | 7.16 | 7.35 | 7.15 | 7.18 | 287300.0 |
| 2024-04-29 | AAOI | Stock | 11.02 | 11.02 | 10.2 | 10.22 | 2033800.0 |
| 2024-04-29 | AAON | Stock | 93.18 | 96.34 | 92.57 | 93.85 | 819000.0 |
| 2024-04-29 | AAP | Stock | 75.27 | 76.14 | 73.94 | 75.42 | 1221800.0 |
| 2024-04-29 | AAT | Stock | 21.42 | 21.75 | 21.42 | 21.72 | 193500.0 |
| 2024-04-29 | AATC | Stock | 6.35 | 7.18 | 6.35 | 6.73 | 4426.0 |
| 2024-04-29 | AAUAF-DELISTED | Stock | 0.12015 | 0.125 | 0.118 | 0.1214 | 30284.0 |
| 2024-04-29 | AAXJ | Stock | 68.62 | 69.0 | 68.58 | 68.98 | 209444.0 |
| 2024-04-29 | AB | Stock | 33.35 | 34.15 | 33.26 | 34.1 | 391200.0 |
| 2024-04-29 | ABAT | Stock | 1.34 | 1.35 | 1.3 | 1.325 | 386534.0 |
| 2024-04-29 | ABBV | Stock | 159.59 | 161.55 | 158.56 | 161.52 | 6219000.0 |
| 2024-04-29 | ABCB | Stock | 48.51 | 48.71 | 48.08 | 48.5 | 422300.0 |
| 2024-04-29 | ABCL | Stock | 3.78 | 3.86 | 3.762 | 3.84 | 1426300.0 |
| 2024-04-29 | ABEO | Stock | 3.49 | 3.78 | 3.37 | 3.44 | 2100000.0 |
| 2024-04-29 | ABEV | Stock | 2.33 | 2.36 | 2.32 | 2.36 | 6642200.0 |
| 2024-04-29 | ABG | Stock | 222.51 | 222.51 | 217.75 | 218.47 | 142000.0 |
| 2024-04-29 | ABLLW | Stock | 0.5071 | 0.53 | 0.5 | 0.5195 | 3543.0 |
| 2024-04-29 | ABLV | Stock | 1.53 | 1.63 | 1.42 | 1.42 | 64500.0 |
| 2024-04-29 | ABM | Stock | 44.11 | 44.45 | 44.05 | 44.27 | 347700.0 |
| 2024-04-29 | ABNB | Stock | 164.75 | 165.5 | 161.28 | 162.25 | 2312600.0 |
| 2024-04-29 | ABOS | Stock | 3.19 | 3.34 | 3.16 | 3.18 | 305100.0 |
| 2024-04-29 | ABR | Stock | 12.95 | 13.08 | 12.91 | 13.02 | 2350200.0 |
| 2024-04-29 | ABR.D | Stock | 18.14 | 18.2 | 18.03 | 18.03 | 6254.0 |
| 2024-04-29 | ABR.E | Stock | 17.75 | 18.0141 | 17.703 | 17.85 | 7408.0 |
| 2024-04-29 | ABR.F | Stock | 18.77 | 18.9399 | 18.47 | 18.9 | 26594.0 |
| 2024-04-29 | ABSI | Stock | 4.67 | 4.88 | 4.63 | 4.78 | 679900.0 |
| 2024-04-29 | ABT | Stock | 107.39 | 108.19 | 106.6 | 107.27 | 3305100.0 |
| 2024-04-29 | ABTC | Stock | 117.0 | 119.25 | 102.75 | 114.0 | 5506.666666666667 |
| 2024-04-29 | ABTS | Stock | 11.1 | 11.85 | 10.95 | 11.85 | 280.0 |
> showing 50 of 7,201 rows — these rows as CSV