PREVIEW / stock_daily / 2024-04-25
file: by_date/stock_daily/2024/2024-04-25.parquet size: 229 KB rows: 7,159 symbols: 980
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-25 | AAPL | Stock | 169.53 | 170.61 | 168.15 | 169.89 | 50558300.0 |
| 2024-04-25 | MSFT | Stock | 394.03 | 399.89 | 388.03 | 399.04 | 40586500.0 |
| 2024-04-25 | NVDA | Stock | 78.868 | 83.323 | 78.223 | 82.632 | 424641000.0 |
| 2024-04-25 | AMZN | Stock | 169.68 | 173.92 | 166.32 | 173.67 | 49249400.0 |
| 2024-04-25 | GOOGL | Stock | 151.33 | 156.49 | 150.87 | 156.0 | 57109730.0 |
| 2024-04-25 | META | Stock | 421.4 | 445.77 | 414.5 | 441.38 | 82890700.0 |
| 2024-04-25 | TSLA | Stock | 158.96 | 170.88 | 158.36 | 170.18 | 126427500.0 |
| 2024-04-25 | TLT | Stock | 87.46 | 87.9 | 87.34 | 87.78 | 49282640.0 |
| 2024-04-25 | ES | Stock | 60.89 | 61.18 | 59.67 | 60.52 | 1432000.0 |
| 2024-04-25 | CL | Stock | 89.0 | 89.5 | 88.84 | 89.29 | 6363600.0 |
| 2024-04-25 | A | Stock | 137.06 | 137.21 | 134.12 | 136.37 | 940800.0 |
| 2024-04-25 | AA | Stock | 35.86 | 36.06 | 34.78 | 35.94 | 4467400.0 |
| 2024-04-25 | AACG | Stock | 0.87 | 0.92 | 0.87 | 0.88 | 11900.0 |
| 2024-04-25 | AACIW-DELISTED | Stock | 0.165 | 0.165 | 0.13 | 0.145 | 15020.0 |
| 2024-04-25 | AACT | Stock | 10.62 | 10.625 | 10.61 | 10.615 | 162700.0 |
| 2024-04-25 | AAGR-DELISTED | Stock | 0.42 | 0.42 | 0.351 | 0.3559 | 195369.0 |
| 2024-04-25 | AAGRW-DELISTED | Stock | 0.014 | 0.014 | 0.0126 | 0.014 | 2484.0 |
| 2024-04-25 | AAL | Stock | 14.21 | 14.28 | 13.45 | 14.13 | 58363000.0 |
| 2024-04-25 | AAMC-DELISTED | Stock | 3.04 | 3.04 | 2.99 | 3.005 | 1600.0 |
| 2024-04-25 | AAME | Stock | 1.93 | 1.93 | 1.87 | 1.9 | 4400.0 |
| 2024-04-25 | AAMI | Stock | 22.91 | 23.03 | 22.68 | 22.96 | 150200.0 |
| 2024-04-25 | AAN-DELISTED | Stock | 7.38 | 7.38 | 7.23 | 7.32 | 181600.0 |
| 2024-04-25 | AAOI | Stock | 10.51 | 10.76 | 10.445 | 10.66 | 1316100.0 |
| 2024-04-25 | AAON | Stock | 88.48 | 90.45 | 87.03 | 89.9 | 396400.0 |
| 2024-04-25 | AAP | Stock | 74.74 | 74.86 | 71.82 | 74.71 | 1434300.0 |
| 2024-04-25 | AAT | Stock | 21.03 | 21.35 | 20.94 | 21.24 | 256900.0 |
| 2024-04-25 | AATC | Stock | 6.39 | 6.39 | 6.03 | 6.32 | 15747.0 |
| 2024-04-25 | AAUAF-DELISTED | Stock | 0.117 | 0.1217 | 0.117 | 0.1217 | 18957.0 |
| 2024-04-25 | AAXJ | Stock | 66.86 | 67.735 | 66.86 | 67.68 | 251569.0 |
| 2024-04-25 | AB | Stock | 33.4 | 33.93 | 32.53 | 33.71 | 410100.0 |
| 2024-04-25 | ABAT | Stock | 1.37 | 1.4 | 1.36 | 1.38 | 493410.0 |
| 2024-04-25 | ABBV | Stock | 167.66 | 169.29 | 165.57 | 167.29 | 5503700.0 |
| 2024-04-25 | ABCB | Stock | 47.56 | 47.84 | 46.74 | 47.51 | 251000.0 |
| 2024-04-25 | ABCL | Stock | 3.86 | 3.88 | 3.62 | 3.63 | 1829900.0 |
| 2024-04-25 | ABEO | Stock | 3.17 | 3.28 | 3.05 | 3.19 | 1104100.0 |
| 2024-04-25 | ABEV | Stock | 2.31 | 2.32 | 2.29 | 2.3 | 10349400.0 |
| 2024-04-25 | ABG | Stock | 217.37 | 218.47 | 206.62 | 217.12 | 321800.0 |
| 2024-04-25 | ABLLW | Stock | 0.5202 | 0.5698 | 0.5 | 0.52 | 17704.0 |
| 2024-04-25 | ABLV | Stock | 1.551 | 1.84 | 1.55 | 1.67 | 74800.0 |
| 2024-04-25 | ABM | Stock | 44.44 | 44.44 | 43.85 | 44.33 | 357700.0 |
| 2024-04-25 | ABNB | Stock | 161.51 | 163.73 | 159.5 | 163.01 | 2401800.0 |
| 2024-04-25 | ABOS | Stock | 3.11 | 3.21 | 3.07 | 3.19 | 167400.0 |
| 2024-04-25 | ABR | Stock | 12.86 | 12.9 | 12.51 | 12.54 | 3784400.0 |
| 2024-04-25 | ABR.D | Stock | 17.9 | 18.05 | 17.62 | 17.8187 | 12242.0 |
| 2024-04-25 | ABR.F | Stock | 18.71 | 18.74 | 18.59 | 18.6 | 6091.0 |
| 2024-04-25 | ABSI | Stock | 4.51 | 4.54 | 4.27 | 4.455 | 807100.0 |
| 2024-04-25 | ABT | Stock | 106.65 | 107.46 | 106.14 | 106.86 | 3112300.0 |
| 2024-04-25 | ABTC | Stock | 109.5 | 112.5 | 99.75 | 112.5 | 5774.666666666667 |
| 2024-04-25 | ABTS | Stock | 10.815 | 11.28 | 10.815 | 10.92 | 66.7 |
| 2024-04-25 | ABUS | Stock | 2.74 | 2.75 | 2.68 | 2.72 | 323300.0 |
> showing 50 of 7,159 rows — these rows as CSV