PREVIEW / stock_daily / 2024-04-24
file: by_date/stock_daily/2024/2024-04-24.parquet size: 230 KB rows: 7,177 symbols: 987
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-24 | AAPL | Stock | 166.54 | 169.3 | 166.21 | 169.02 | 48251800.0 |
| 2024-04-24 | MSFT | Stock | 409.56 | 412.47 | 406.78 | 409.06 | 15065300.0 |
| 2024-04-24 | NVDA | Stock | 83.95 | 84.082 | 79.183 | 79.677 | 512208000.0 |
| 2024-04-24 | AMZN | Stock | 179.94 | 180.32 | 176.18 | 176.59 | 34185100.0 |
| 2024-04-24 | GOOGL | Stock | 157.49 | 159.565 | 157.165 | 159.13 | 22779112.0 |
| 2024-04-24 | META | Stock | 508.06 | 510.0 | 484.58 | 493.5 | 37772700.0 |
| 2024-04-24 | TSLA | Stock | 162.84 | 167.97 | 157.51 | 162.13 | 181178000.0 |
| 2024-04-24 | TLT | Stock | 88.56 | 88.63 | 87.5 | 88.4 | 48986757.0 |
| 2024-04-24 | ES | Stock | 59.63 | 61.05 | 59.44 | 60.84 | 2087300.0 |
| 2024-04-24 | CL | Stock | 88.23 | 89.18 | 87.37 | 88.87 | 4066500.0 |
| 2024-04-24 | A | Stock | 138.34 | 139.89 | 136.21 | 137.49 | 1553200.0 |
| 2024-04-24 | AA | Stock | 35.96 | 36.55 | 35.74 | 36.08 | 5706800.0 |
| 2024-04-24 | AACG | Stock | 0.89 | 0.93 | 0.87 | 0.87 | 6300.0 |
| 2024-04-24 | AACIW-DELISTED | Stock | 0.18 | 0.18 | 0.16 | 0.16 | 3449.0 |
| 2024-04-24 | AACT | Stock | 10.64 | 10.65 | 10.615 | 10.615 | 13700.0 |
| 2024-04-24 | AAGR-DELISTED | Stock | 0.3399 | 0.45 | 0.3305 | 0.3999 | 360606.0 |
| 2024-04-24 | AAGRW-DELISTED | Stock | 0.0127 | 0.014 | 0.0127 | 0.0127 | 2370.0 |
| 2024-04-24 | AAL | Stock | 14.22 | 14.33 | 13.82 | 13.92 | 41035100.0 |
| 2024-04-24 | AAMC-DELISTED | Stock | 3.16 | 3.17 | 3.08 | 3.08 | 1000.0 |
| 2024-04-24 | AAME | Stock | 1.88 | 1.91 | 1.88 | 1.91 | 3100.0 |
| 2024-04-24 | AAMI | Stock | 23.29 | 23.343 | 22.95 | 23.08 | 143700.0 |
| 2024-04-24 | AAN-DELISTED | Stock | 7.45 | 7.48 | 7.3 | 7.43 | 222600.0 |
| 2024-04-24 | AAOI | Stock | 11.38 | 11.45 | 10.83 | 10.85 | 1347500.0 |
| 2024-04-24 | AAON | Stock | 88.87 | 91.85 | 87.93 | 89.67 | 512100.0 |
| 2024-04-24 | AAP | Stock | 77.37 | 77.6 | 75.82 | 76.53 | 895100.0 |
| 2024-04-24 | AAT | Stock | 21.43 | 21.43 | 21.14 | 21.29 | 249600.0 |
| 2024-04-24 | AATC | Stock | 6.444 | 6.45 | 6.37 | 6.42 | 1526.0 |
| 2024-04-24 | AAUAF-DELISTED | Stock | 0.1214 | 0.1222 | 0.118 | 0.12 | 35046.0 |
| 2024-04-24 | AAXJ | Stock | 67.5 | 67.62 | 67.175 | 67.41 | 418267.0 |
| 2024-04-24 | AB | Stock | 33.45 | 34.16 | 33.35 | 33.52 | 319300.0 |
| 2024-04-24 | ABAT | Stock | 1.29 | 1.38 | 1.288 | 1.37 | 740341.0 |
| 2024-04-24 | ABBV | Stock | 168.52 | 169.11 | 166.74 | 167.8 | 4074700.0 |
| 2024-04-24 | ABCB | Stock | 47.28 | 48.44 | 47.26 | 48.25 | 314800.0 |
| 2024-04-24 | ABCL | Stock | 4.01 | 4.25 | 3.89 | 3.9 | 1599000.0 |
| 2024-04-24 | ABEO | Stock | 3.45 | 3.52 | 3.14 | 3.17 | 2219400.0 |
| 2024-04-24 | ABEV | Stock | 2.3 | 2.34 | 2.29 | 2.32 | 13313500.0 |
| 2024-04-24 | ABG | Stock | 220.26 | 225.5 | 219.63 | 221.54 | 193900.0 |
| 2024-04-24 | ABLLW | Stock | 0.64499 | 0.64499 | 0.5101 | 0.578 | 5719.0 |
| 2024-04-24 | ABLV | Stock | 1.58 | 1.68 | 1.55 | 1.569 | 24600.0 |
| 2024-04-24 | ABM | Stock | 44.36 | 44.75 | 44.26 | 44.53 | 442800.0 |
| 2024-04-24 | ABNB | Stock | 164.475 | 166.745 | 161.09 | 162.84 | 3854500.0 |
| 2024-04-24 | ABOS | Stock | 3.12 | 3.21 | 3.105 | 3.18 | 152200.0 |
| 2024-04-24 | ABR | Stock | 13.14 | 13.19 | 12.8 | 13.02 | 3198400.0 |
| 2024-04-24 | ABR.D | Stock | 17.9 | 18.0396 | 17.86 | 17.94 | 6162.0 |
| 2024-04-24 | ABR.E | Stock | 17.87 | 17.87 | 17.6 | 17.75 | 6499.0 |
| 2024-04-24 | ABR.F | Stock | 18.85 | 18.89 | 18.62 | 18.89 | 19014.0 |
| 2024-04-24 | ABSI | Stock | 4.71 | 4.89 | 4.48 | 4.53 | 854500.0 |
| 2024-04-24 | ABT | Stock | 106.71 | 107.11 | 105.56 | 106.89 | 5052700.0 |
| 2024-04-24 | ABTC | Stock | 97.5 | 108.75 | 96.75 | 104.25 | 3106.6666666666665 |
| 2024-04-24 | ABTS | Stock | 11.985 | 11.985 | 10.8 | 11.4 | 207.0 |
> showing 50 of 7,177 rows — these rows as CSV