PREVIEW / stock_daily / 2024-04-15
file: by_date/stock_daily/2024/2024-04-15.parquet size: 231 KB rows: 7,227 symbols: 1,006
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-15 | AAPL | Stock | 175.36 | 176.63 | 172.5 | 172.69 | 73531800.0 |
| 2024-04-15 | MSFT | Stock | 426.6 | 426.82 | 413.43 | 413.64 | 20273500.0 |
| 2024-04-15 | NVDA | Stock | 89.098 | 90.613 | 85.929 | 86.001 | 443077000.0 |
| 2024-04-15 | AMZN | Stock | 187.43 | 188.69 | 183.0 | 183.62 | 48052400.0 |
| 2024-04-15 | GOOGL | Stock | 158.86 | 159.24 | 154.59 | 154.86 | 27136472.0 |
| 2024-04-15 | META | Stock | 516.72 | 518.53 | 497.28 | 500.23 | 13512900.0 |
| 2024-04-15 | TSLA | Stock | 170.24 | 170.69 | 161.38 | 161.48 | 100245300.0 |
| 2024-04-15 | TLT | Stock | 89.22 | 89.26 | 88.523 | 88.89 | 55993060.0 |
| 2024-04-15 | ES | Stock | 59.02 | 59.25 | 57.67 | 58.24 | 2131400.0 |
| 2024-04-15 | CL | Stock | 86.47 | 86.89 | 86.1 | 86.17 | 4716200.0 |
| 2024-04-15 | A | Stock | 142.31 | 143.25 | 139.02 | 140.22 | 1506000.0 |
| 2024-04-15 | AA | Stock | 37.0 | 37.59 | 36.465 | 36.57 | 9916300.0 |
| 2024-04-15 | AACG | Stock | 0.94 | 0.94 | 0.85 | 0.86 | 19100.0 |
| 2024-04-15 | AACIW-DELISTED | Stock | 0.1548 | 0.1553 | 0.15 | 0.15 | 9704.0 |
| 2024-04-15 | AACT | Stock | 10.61 | 10.62 | 10.61 | 10.61 | 24200.0 |
| 2024-04-15 | AAGR-DELISTED | Stock | 0.469 | 0.47 | 0.396 | 0.4174 | 114733.0 |
| 2024-04-15 | AAGRW-DELISTED | Stock | 0.0131 | 0.0169 | 0.013 | 0.01495 | 7998.0 |
| 2024-04-15 | AAL | Stock | 13.28 | 13.47 | 12.9 | 12.94 | 27451700.0 |
| 2024-04-15 | AAMC-DELISTED | Stock | 3.45 | 3.73 | 3.45 | 3.625 | 3600.0 |
| 2024-04-15 | AAME | Stock | 2.02 | 2.25 | 2.0 | 2.02 | 9500.0 |
| 2024-04-15 | AAMI | Stock | 22.42 | 22.62 | 22.3 | 22.61 | 197800.0 |
| 2024-04-15 | AAN-DELISTED | Stock | 7.18 | 7.21 | 7.01 | 7.09 | 205600.0 |
| 2024-04-15 | AAOI | Stock | 11.28 | 11.38 | 10.85 | 11.16 | 1301600.0 |
| 2024-04-15 | AAON | Stock | 88.5 | 89.57 | 86.33 | 87.14 | 470500.0 |
| 2024-04-15 | AAP | Stock | 72.1 | 72.49 | 69.97 | 70.08 | 1402500.0 |
| 2024-04-15 | AAT | Stock | 20.86 | 20.93 | 20.33 | 20.53 | 202200.0 |
| 2024-04-15 | AATC | Stock | 6.45 | 6.49 | 6.26 | 6.42 | 17665.0 |
| 2024-04-15 | AAUAF-DELISTED | Stock | 0.118 | 0.125 | 0.103 | 0.12 | 194363.0 |
| 2024-04-15 | AAXJ | Stock | 67.16 | 67.18 | 66.235 | 66.37 | 661925.0 |
| 2024-04-15 | AB | Stock | 32.87 | 33.37 | 32.29 | 32.47 | 315300.0 |
| 2024-04-15 | ABAT | Stock | 1.76 | 1.76 | 1.55 | 1.61 | 626372.0 |
| 2024-04-15 | ABBV | Stock | 164.52 | 164.7 | 161.5 | 161.67 | 5433700.0 |
| 2024-04-15 | ABCB | Stock | 45.33 | 45.82 | 44.57 | 45.05 | 251900.0 |
| 2024-04-15 | ABCL | Stock | 4.34 | 4.34 | 4.15 | 4.18 | 1358900.0 |
| 2024-04-15 | ABEO | Stock | 7.56 | 7.69 | 7.44 | 7.64 | 113700.0 |
| 2024-04-15 | ABEV | Stock | 2.32 | 2.34 | 2.3 | 2.32 | 15963400.0 |
| 2024-04-15 | ABG | Stock | 218.25 | 220.14 | 214.54 | 215.12 | 182200.0 |
| 2024-04-15 | ABLLW | Stock | 0.5 | 0.54 | 0.49 | 0.49 | 38537.0 |
| 2024-04-15 | ABLV | Stock | 2.03 | 2.06 | 1.84 | 1.88 | 93400.0 |
| 2024-04-15 | ABM | Stock | 43.64 | 44.49 | 43.59 | 44.46 | 690900.0 |
| 2024-04-15 | ABNB | Stock | 161.81 | 162.9 | 154.41 | 155.6 | 3723300.0 |
| 2024-04-15 | ABOS | Stock | 3.74 | 3.77 | 3.53 | 3.53 | 215000.0 |
| 2024-04-15 | ABR | Stock | 12.3 | 12.35 | 12.07 | 12.18 | 3707500.0 |
| 2024-04-15 | ABR.D | Stock | 18.48 | 18.68 | 18.0 | 18.1 | 33895.0 |
| 2024-04-15 | ABR.E | Stock | 18.2 | 18.33 | 17.96 | 18.33 | 7766.0 |
| 2024-04-15 | ABR.F | Stock | 19.66 | 19.66 | 18.8201 | 18.875 | 26888.0 |
| 2024-04-15 | ABSI | Stock | 5.82 | 5.87 | 5.34 | 5.43 | 1417200.0 |
| 2024-04-15 | ABT | Stock | 110.09 | 110.89 | 108.83 | 108.89 | 4595600.0 |
| 2024-04-15 | ABTC | Stock | 113.25 | 120.0 | 102.97500000000001 | 111.0 | 2646.6666666666665 |
| 2024-04-15 | ABTS | Stock | 11.58 | 12.3 | 10.8 | 11.85 | 31907.0 |
> showing 50 of 7,227 rows — these rows as CSV