PREVIEW / stock_daily / 2024-02-23
file: by_date/stock_daily/2024/2024-02-23.parquet size: 235 KB rows: 7,314 symbols: 1,125
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-02-23 | AAPL | Stock | 185.01 | 185.04 | 182.23 | 182.52 | 45119700.0 |
| 2024-02-23 | MSFT | Stock | 415.67 | 415.86 | 408.97 | 410.34 | 16295900.0 |
| 2024-02-23 | NVDA | Stock | 80.79 | 82.394 | 77.57 | 78.817 | 829388000.0 |
| 2024-02-23 | AMZN | Stock | 174.28 | 175.75 | 173.7 | 174.99 | 59715200.0 |
| 2024-02-23 | GOOGL | Stock | 143.67 | 144.68 | 143.43 | 143.96 | 19493752.0 |
| 2024-02-23 | META | Stock | 488.05 | 494.36 | 482.35 | 484.03 | 18374300.0 |
| 2024-02-23 | TSLA | Stock | 195.31 | 197.57 | 191.5 | 191.97 | 78841900.0 |
| 2024-02-23 | TLT | Stock | 92.75 | 93.999 | 92.75 | 93.87 | 38406710.0 |
| 2024-02-23 | ES | Stock | 58.03 | 59.33 | 57.87 | 58.87 | 2184300.0 |
| 2024-02-23 | CL | Stock | 86.0 | 86.83 | 85.64 | 86.25 | 3161500.0 |
| 2024-02-23 | A | Stock | 132.8 | 133.36 | 131.57 | 132.03 | 1878000.0 |
| 2024-02-23 | AA | Stock | 27.62 | 27.71 | 26.47 | 26.52 | 5340300.0 |
| 2024-02-23 | AACG | Stock | 1.22 | 1.33 | 1.2 | 1.22 | 8100.0 |
| 2024-02-23 | AACT | Stock | 10.55 | 10.55 | 10.54 | 10.55 | 3300.0 |
| 2024-02-23 | AAGR-DELISTED | Stock | 0.7991 | 0.839 | 0.7151 | 0.763 | 200168.0 |
| 2024-02-23 | AAGRW-DELISTED | Stock | 0.0199 | 0.0199 | 0.0107 | 0.015 | 32875.0 |
| 2024-02-23 | AAL | Stock | 15.15 | 15.29 | 14.95 | 15.13 | 22914900.0 |
| 2024-02-23 | AAMC-DELISTED | Stock | 4.04 | 4.38 | 4.02 | 4.19 | 7300.0 |
| 2024-02-23 | AAME | Stock | 2.75 | 2.75 | 2.58 | 2.7 | 12700.0 |
| 2024-02-23 | AAMI | Stock | 22.69 | 22.74 | 22.43 | 22.47 | 151000.0 |
| 2024-02-23 | AAN-DELISTED | Stock | 10.25 | 10.55 | 10.16 | 10.54 | 236800.0 |
| 2024-02-23 | AAOI | Stock | 13.74 | 14.68 | 12.14 | 14.15 | 19663300.0 |
| 2024-02-23 | AAON | Stock | 82.64 | 84.38 | 82.23 | 84.05 | 226500.0 |
| 2024-02-23 | AAP | Stock | 60.32 | 62.05 | 60.32 | 61.1 | 1679800.0 |
| 2024-02-23 | AAT | Stock | 21.52 | 21.84 | 21.39 | 21.53 | 269500.0 |
| 2024-02-23 | AATC | Stock | 7.31 | 7.4 | 6.95 | 7.26 | 10759.0 |
| 2024-02-23 | AAU-DELISTED | Stock | 0.135 | 0.1351 | 0.135 | 0.135 | 126075.0 |
| 2024-02-23 | AAUAF-DELISTED | Stock | 0.135 | 0.1351 | 0.135 | 0.1351 | 126590.0 |
| 2024-02-23 | AAXJ | Stock | 66.92 | 67.087 | 66.71 | 66.97 | 270646.0 |
| 2024-02-23 | AB | Stock | 33.59 | 34.18 | 33.42 | 33.95 | 571000.0 |
| 2024-02-23 | ABAT | Stock | 2.25 | 2.25 | 2.145 | 2.18 | 589578.0 |
| 2024-02-23 | ABBV | Stock | 177.26 | 178.91 | 177.01 | 178.09 | 3941800.0 |
| 2024-02-23 | ABCB | Stock | 45.91 | 46.44 | 45.48 | 45.88 | 347900.0 |
| 2024-02-23 | ABCL | Stock | 4.9 | 5.085 | 4.82 | 4.87 | 2681000.0 |
| 2024-02-23 | ABEO | Stock | 6.7 | 6.98 | 6.6 | 6.98 | 242900.0 |
| 2024-02-23 | ABEV | Stock | 2.59 | 2.6 | 2.55 | 2.56 | 10464100.0 |
| 2024-02-23 | ABG | Stock | 211.91 | 216.55 | 210.87 | 214.62 | 92400.0 |
| 2024-02-23 | ABLLW | Stock | 0.86 | 0.88 | 0.7567 | 0.757 | 43028.0 |
| 2024-02-23 | ABLV | Stock | 3.03 | 3.03 | 2.73 | 3.02 | 94500.0 |
| 2024-02-23 | ABM | Stock | 40.19 | 40.7 | 40.16 | 40.62 | 876500.0 |
| 2024-02-23 | ABNB | Stock | 153.27 | 155.3 | 150.825 | 152.66 | 4851100.0 |
| 2024-02-23 | ABOS | Stock | 3.32 | 3.56 | 3.31 | 3.56 | 383400.0 |
| 2024-02-23 | ABR | Stock | 12.85 | 13.16 | 12.67 | 13.01 | 4284700.0 |
| 2024-02-23 | ABR.D | Stock | 18.0982 | 18.2199 | 18.05 | 18.05 | 19596.0 |
| 2024-02-23 | ABR.E | Stock | 18.11 | 18.33 | 18.11 | 18.33 | 1676.0 |
| 2024-02-23 | ABR.F | Stock | 18.93 | 19.0 | 18.77 | 18.91 | 16255.0 |
| 2024-02-23 | ABSI | Stock | 4.73 | 4.85 | 4.51 | 4.69 | 865600.0 |
| 2024-02-23 | ABT | Stock | 119.38 | 120.15 | 118.86 | 119.46 | 4261300.0 |
| 2024-02-23 | ABTC | Stock | 171.0 | 180.07500000000002 | 161.25 | 174.75 | 3136.0 |
| 2024-02-23 | ABTS | Stock | 14.85 | 14.85 | 13.65 | 13.74 | 3333.0 |
> showing 50 of 7,314 rows — these rows as CSV