PREVIEW / stock_daily / 2024-05-24
file: by_date/stock_daily/2024/2024-05-24.parquet size: 231 KB rows: 7,171 symbols: 948
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-24 | AAPL | Stock | 188.82 | 190.58 | 188.04 | 189.98 | 36294600.0 |
| 2024-05-24 | MSFT | Stock | 427.19 | 431.06 | 424.41 | 430.16 | 11845800.0 |
| 2024-05-24 | NVDA | Stock | 104.449 | 106.475 | 103.0 | 106.469 | 429494000.0 |
| 2024-05-24 | AMZN | Stock | 181.65 | 182.44 | 180.3 | 180.75 | 27434100.0 |
| 2024-05-24 | GOOGL | Stock | 174.98 | 175.77 | 173.65 | 174.99 | 16579438.0 |
| 2024-05-24 | META | Stock | 467.62 | 479.85 | 466.3 | 478.22 | 12012300.0 |
| 2024-05-24 | TSLA | Stock | 174.84 | 180.08 | 173.73 | 179.24 | 65479700.0 |
| 2024-05-24 | TLT | Stock | 90.97 | 91.47 | 90.9 | 91.38 | 19164425.0 |
| 2024-05-24 | ES | Stock | 57.62 | 58.31 | 57.35 | 57.53 | 2058900.0 |
| 2024-05-24 | CL | Stock | 93.84 | 94.13 | 93.21 | 93.3 | 2554800.0 |
| 2024-05-24 | A | Stock | 150.81 | 151.46 | 149.56 | 150.66 | 784300.0 |
| 2024-05-24 | AA | Stock | 41.59 | 42.13 | 41.36 | 41.64 | 2919900.0 |
| 2024-05-24 | AACG | Stock | 0.88 | 0.88 | 0.85 | 0.85 | 6000.0 |
| 2024-05-24 | AACIW-DELISTED | Stock | 0.1586 | 0.16 | 0.1586 | 0.1599 | 600.0 |
| 2024-05-24 | AACT | Stock | 10.64 | 10.645 | 10.62 | 10.62 | 359200.0 |
| 2024-05-24 | AAGR-DELISTED | Stock | 0.36415 | 0.38 | 0.3503 | 0.3784 | 96280.0 |
| 2024-05-24 | AAGRW-DELISTED | Stock | 0.012 | 0.012 | 0.012 | 0.012 | 130.0 |
| 2024-05-24 | AAL | Stock | 13.87 | 14.03 | 13.66 | 13.84 | 19589300.0 |
| 2024-05-24 | AAMC-DELISTED | Stock | 2.41 | 2.51 | 2.27 | 2.51 | 3500.0 |
| 2024-05-24 | AAME | Stock | 1.68 | 1.68 | 1.65 | 1.65 | 1000.0 |
| 2024-05-24 | AAMI | Stock | 22.27 | 22.62 | 22.27 | 22.56 | 216800.0 |
| 2024-05-24 | AAN-DELISTED | Stock | 7.19 | 7.225 | 7.11 | 7.21 | 94000.0 |
| 2024-05-24 | AAOI | Stock | 12.0 | 13.04 | 11.79 | 12.54 | 2018000.0 |
| 2024-05-24 | AAON | Stock | 76.61 | 78.6 | 76.18 | 78.26 | 671100.0 |
| 2024-05-24 | AAP | Stock | 69.9 | 70.59 | 69.35 | 69.57 | 1245000.0 |
| 2024-05-24 | AAT | Stock | 21.19 | 21.32 | 21.08 | 21.13 | 611100.0 |
| 2024-05-24 | AATC | Stock | 6.2 | 6.25 | 5.9 | 6.2 | 11821.0 |
| 2024-05-24 | AAUAF-DELISTED | Stock | 0.1219 | 0.13 | 0.1219 | 0.1243 | 61024.0 |
| 2024-05-24 | AAXJ | Stock | 71.99 | 72.31 | 71.99 | 72.16 | 589799.0 |
| 2024-05-24 | AB | Stock | 33.59 | 34.0 | 33.53 | 33.74 | 118800.0 |
| 2024-05-24 | ABAT | Stock | 1.46 | 1.46 | 1.43 | 1.44 | 192777.0 |
| 2024-05-24 | ABBV | Stock | 158.36 | 158.78 | 156.36 | 157.06 | 3689900.0 |
| 2024-05-24 | ABCB | Stock | 48.17 | 48.58 | 47.6 | 48.02 | 193100.0 |
| 2024-05-24 | ABCL | Stock | 3.88 | 3.948 | 3.76 | 3.85 | 1047400.0 |
| 2024-05-24 | ABEO | Stock | 4.17 | 4.32 | 4.03 | 4.06 | 539900.0 |
| 2024-05-24 | ABEV | Stock | 2.29 | 2.31 | 2.28 | 2.29 | 7587900.0 |
| 2024-05-24 | ABG | Stock | 230.13 | 231.61 | 229.6 | 231.3 | 69100.0 |
| 2024-05-24 | ABLLW | Stock | 0.349 | 0.35 | 0.3111 | 0.319 | 40638.0 |
| 2024-05-24 | ABLV | Stock | 1.49 | 1.55 | 1.35 | 1.5 | 43600.0 |
| 2024-05-24 | ABM | Stock | 47.46 | 47.46 | 46.72 | 46.87 | 257500.0 |
| 2024-05-24 | ABNB | Stock | 142.5 | 145.97 | 142.3 | 144.47 | 4497100.0 |
| 2024-05-24 | ABOS | Stock | 3.41 | 3.48 | 3.28 | 3.4 | 205000.0 |
| 2024-05-24 | ABR | Stock | 13.3 | 13.46 | 13.21 | 13.37 | 2545900.0 |
| 2024-05-24 | ABR.D | Stock | 18.02 | 18.25 | 18.0 | 18.16 | 12957.0 |
| 2024-05-24 | ABR.E | Stock | 17.7 | 18.23 | 17.7 | 18.05 | 6432.0 |
| 2024-05-24 | ABR.F | Stock | 19.77 | 19.83 | 19.61 | 19.65 | 7748.0 |
| 2024-05-24 | ABSI | Stock | 4.43 | 4.435 | 4.16 | 4.21 | 874000.0 |
| 2024-05-24 | ABT | Stock | 104.15 | 104.37 | 103.58 | 103.95 | 4455600.0 |
| 2024-05-24 | ABTC | Stock | 105.0 | 105.75 | 94.5 | 98.625 | 5353.333333333333 |
| 2024-05-24 | ABTS | Stock | 10.35 | 10.485 | 9.75 | 9.75 | 1573.0 |
> showing 50 of 7,171 rows — these rows as CSV