PREVIEW / stock_daily / 2024-04-30
file: by_date/stock_daily/2024/2024-04-30.parquet size: 230 KB rows: 7,178 symbols: 973
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-30 | AAPL | Stock | 173.33 | 174.99 | 170.0 | 170.33 | 65934800.0 |
| 2024-04-30 | MSFT | Stock | 401.49 | 402.16 | 389.17 | 389.33 | 28781400.0 |
| 2024-04-30 | NVDA | Stock | 87.24 | 88.819 | 86.3 | 86.402 | 363709000.0 |
| 2024-04-30 | AMZN | Stock | 181.09 | 182.99 | 174.8 | 175.0 | 94639800.0 |
| 2024-04-30 | GOOGL | Stock | 165.612 | 168.1 | 162.6 | 162.78 | 33562861.0 |
| 2024-04-30 | META | Stock | 431.05 | 439.62 | 429.72 | 430.17 | 18429500.0 |
| 2024-04-30 | TSLA | Stock | 186.98 | 190.95 | 182.84 | 183.28 | 127031800.0 |
| 2024-04-30 | TLT | Stock | 88.42 | 88.73 | 88.095 | 88.22 | 41054666.0 |
| 2024-04-30 | ES | Stock | 59.85 | 60.88 | 59.1 | 60.62 | 3515900.0 |
| 2024-04-30 | CL | Stock | 90.95 | 92.09 | 90.79 | 91.92 | 5286700.0 |
| 2024-04-30 | A | Stock | 138.6 | 139.65 | 136.97 | 137.04 | 1087300.0 |
| 2024-04-30 | AA | Stock | 36.76 | 36.92 | 35.11 | 35.14 | 7993000.0 |
| 2024-04-30 | AACG | Stock | 0.9 | 0.9 | 0.87 | 0.89 | 11300.0 |
| 2024-04-30 | AACIW-DELISTED | Stock | 0.145 | 0.15 | 0.136 | 0.136 | 66795.0 |
| 2024-04-30 | AACT | Stock | 10.68 | 10.68 | 10.62 | 10.62 | 556100.0 |
| 2024-04-30 | AAGR-DELISTED | Stock | 0.3453 | 0.35 | 0.33 | 0.3445 | 55007.0 |
| 2024-04-30 | AAGRW-DELISTED | Stock | 0.014 | 0.014 | 0.0132 | 0.0139 | 1816.0 |
| 2024-04-30 | AAL | Stock | 13.85 | 13.93 | 13.5 | 13.51 | 25788900.0 |
| 2024-04-30 | AAMC-DELISTED | Stock | 2.77 | 2.81 | 2.75 | 2.81 | 1800.0 |
| 2024-04-30 | AAME | Stock | 1.88 | 1.88 | 1.88 | 1.88 | 800.0 |
| 2024-04-30 | AAMI | Stock | 22.47 | 22.77 | 22.21 | 22.24 | 298200.0 |
| 2024-04-30 | AAN-DELISTED | Stock | 7.13 | 7.175 | 6.89 | 6.91 | 246200.0 |
| 2024-04-30 | AAOI | Stock | 10.17 | 10.3 | 9.79 | 9.85 | 2608800.0 |
| 2024-04-30 | AAON | Stock | 93.8 | 95.3 | 92.96 | 94.09 | 945300.0 |
| 2024-04-30 | AAP | Stock | 74.74 | 75.96 | 72.77 | 72.98 | 1749500.0 |
| 2024-04-30 | AAT | Stock | 21.5 | 21.69 | 21.33 | 21.35 | 217800.0 |
| 2024-04-30 | AATC | Stock | 6.93 | 6.95 | 6.72 | 6.72 | 2886.0 |
| 2024-04-30 | AAUAF-DELISTED | Stock | 0.124 | 0.124 | 0.114 | 0.118 | 41646.0 |
| 2024-04-30 | AAXJ | Stock | 68.4 | 68.66 | 68.13 | 68.14 | 294464.0 |
| 2024-04-30 | AB | Stock | 34.0 | 34.18 | 32.92 | 33.49 | 435600.0 |
| 2024-04-30 | ABAT | Stock | 1.31 | 1.35 | 1.28 | 1.3 | 325292.0 |
| 2024-04-30 | ABBV | Stock | 161.27 | 163.05 | 159.69 | 162.64 | 5484800.0 |
| 2024-04-30 | ABCB | Stock | 48.12 | 48.15 | 47.27 | 47.48 | 348700.0 |
| 2024-04-30 | ABCL | Stock | 3.82 | 4.0 | 3.725 | 3.78 | 935400.0 |
| 2024-04-30 | ABEO | Stock | 3.46 | 4.21 | 3.44 | 4.14 | 2229200.0 |
| 2024-04-30 | ABEV | Stock | 2.36 | 2.37 | 2.32 | 2.32 | 11247100.0 |
| 2024-04-30 | ABG | Stock | 215.67 | 216.27 | 210.09 | 210.24 | 181700.0 |
| 2024-04-30 | ABLLW | Stock | 0.515 | 0.52 | 0.515 | 0.52 | 14285.0 |
| 2024-04-30 | ABLV | Stock | 1.37 | 1.62 | 1.182 | 1.37 | 19400.0 |
| 2024-04-30 | ABLVW | Stock | 0.0383 | 0.0383 | 0.038 | 0.038 | 915.0 |
| 2024-04-30 | ABM | Stock | 44.11 | 44.21 | 43.59 | 43.7 | 684800.0 |
| 2024-04-30 | ABNB | Stock | 160.56 | 162.09 | 158.52 | 158.57 | 3017900.0 |
| 2024-04-30 | ABOS | Stock | 3.16 | 3.245 | 3.15 | 3.22 | 82900.0 |
| 2024-04-30 | ABR | Stock | 12.88 | 13.0 | 12.72 | 12.83 | 2701800.0 |
| 2024-04-30 | ABR.D | Stock | 18.05 | 18.24 | 17.95 | 17.95 | 15012.0 |
| 2024-04-30 | ABR.E | Stock | 17.89 | 18.1386 | 17.64 | 17.64 | 9223.0 |
| 2024-04-30 | ABR.F | Stock | 18.97 | 19.175 | 18.89 | 19.07 | 48493.0 |
| 2024-04-30 | ABSI | Stock | 4.71 | 4.82 | 4.66 | 4.74 | 642700.0 |
| 2024-04-30 | ABT | Stock | 106.52 | 106.87 | 105.9 | 105.97 | 5074000.0 |
| 2024-04-30 | ABTC | Stock | 112.5 | 118.5 | 104.625 | 108.75 | 4213.333333333333 |
> showing 50 of 7,178 rows — these rows as CSV