PREVIEW / stock_daily / 2024-11-21
file: by_date/stock_daily/2024/2024-11-21.parquet size: 247 KB rows: 7,145 symbols: 642
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-11-21 | AAPL | Stock | 228.88 | 230.155 | 225.7103 | 228.52 | 38524550.0 |
| 2024-11-21 | MSFT | Stock | 419.5 | 419.78 | 410.2887 | 412.87 | 18131541.0 |
| 2024-11-21 | NVDA | Stock | 149.35 | 152.89 | 140.7 | 146.67 | 394990078.0 |
| 2024-11-21 | AMZN | Stock | 203.49 | 203.49 | 195.75 | 198.38 | 57152606.0 |
| 2024-11-21 | GOOGL | Stock | 173.9 | 174.13 | 163.7 | 167.63 | 59734379.0 |
| 2024-11-21 | META | Stock | 569.52 | 570.0 | 549.05 | 563.09 | 10765524.0 |
| 2024-11-21 | TSLA | Stock | 343.81 | 347.9899 | 335.28 | 339.64 | 57672583.0 |
| 2024-11-21 | TLT | Stock | 90.45 | 90.85 | 90.0 | 90.34 | 28365740.0 |
| 2024-11-21 | ES | Stock | 61.68 | 62.8 | 61.39 | 62.75 | 1406790.0 |
| 2024-11-21 | CL | Stock | 94.15 | 94.92 | 93.3 | 94.25 | 3153186.0 |
| 2024-11-21 | A | Stock | 129.71 | 132.19 | 129.06 | 132.06 | 2304495.0 |
| 2024-11-21 | AA | Stock | 45.55 | 46.6 | 45.42 | 46.45 | 3113601.0 |
| 2024-11-21 | AACG | Stock | 1.0 | 1.02 | 0.99 | 1.01 | 33371.0 |
| 2024-11-21 | AACT | Stock | 10.89 | 10.93 | 10.89 | 10.91 | 387673.0 |
| 2024-11-21 | AAL | Stock | 14.47 | 14.575 | 14.175 | 14.2 | 20565495.0 |
| 2024-11-21 | AAM | Stock | 10.05 | 10.06 | 10.05 | 10.05 | 4510.0 |
| 2024-11-21 | AAME | Stock | 1.57 | 1.63 | 1.53 | 1.63 | 2652.0 |
| 2024-11-21 | AAMI | Stock | 30.49 | 30.765 | 30.2 | 30.53 | 135672.0 |
| 2024-11-21 | AAOI | Stock | 36.99 | 38.86 | 34.86 | 35.5 | 6403440.0 |
| 2024-11-21 | AAON | Stock | 132.54 | 137.2 | 132.54 | 135.56 | 460422.0 |
| 2024-11-21 | AAP | Stock | 38.63 | 38.9789 | 38.19 | 38.69 | 2335848.0 |
| 2024-11-21 | AAT | Stock | 27.7 | 28.1 | 27.61 | 27.84 | 161937.0 |
| 2024-11-21 | AATC | Stock | 8.0055 | 8.0055 | 7.965 | 7.9815 | 1372.0 |
| 2024-11-21 | AAUAF-DELISTED | Stock | 0.0404 | 0.0426 | 0.033 | 0.0426 | 51755.0 |
| 2024-11-21 | AAXJ | Stock | 74.02 | 74.21 | 73.77 | 74.12 | 176289.0 |
| 2024-11-21 | AB | Stock | 37.38 | 37.38 | 36.66 | 36.72 | 332444.0 |
| 2024-11-21 | ABAT | Stock | 0.7697 | 0.77 | 0.73 | 0.76 | 855624.0 |
| 2024-11-21 | ABBV | Stock | 168.59 | 172.455 | 166.92 | 171.73 | 6661711.0 |
| 2024-11-21 | ABCB | Stock | 68.85 | 70.23 | 68.36 | 69.74 | 323083.0 |
| 2024-11-21 | ABCL | Stock | 2.66 | 2.77 | 2.61 | 2.72 | 1426772.0 |
| 2024-11-21 | ABEO | Stock | 5.79 | 5.987 | 5.62 | 5.79 | 306454.0 |
| 2024-11-21 | ABEV | Stock | 2.14 | 2.17 | 2.14 | 2.15 | 22420428.0 |
| 2024-11-21 | ABG | Stock | 252.98 | 259.405 | 252.14 | 258.16 | 104931.0 |
| 2024-11-21 | ABLLW | Stock | 1.4 | 1.41 | 1.35 | 1.38 | 19256.0 |
| 2024-11-21 | ABLV | Stock | 0.86 | 0.89 | 0.8164 | 0.86 | 31746.0 |
| 2024-11-21 | ABM | Stock | 55.72 | 56.61 | 55.2 | 56.38 | 213274.0 |
| 2024-11-21 | ABNB | Stock | 134.18 | 134.95 | 132.58 | 133.26 | 4003704.0 |
| 2024-11-21 | ABOS | Stock | 2.4 | 2.4 | 2.25 | 2.31 | 128243.0 |
| 2024-11-21 | ABR | Stock | 14.58 | 14.62 | 14.47 | 14.5 | 2253412.0 |
| 2024-11-21 | ABR.D | Stock | 18.4 | 18.94 | 18.28 | 18.392 | 19359.0 |
| 2024-11-21 | ABR.E | Stock | 18.395 | 18.43 | 18.15 | 18.31 | 3411.0 |
| 2024-11-21 | ABR.F | Stock | 20.5 | 20.7 | 20.5 | 20.61 | 35596.0 |
| 2024-11-21 | ABSI | Stock | 2.66 | 2.695 | 2.52 | 2.55 | 1672553.0 |
| 2024-11-21 | ABT | Stock | 115.68 | 117.64 | 115.14 | 117.26 | 5042359.0 |
| 2024-11-21 | ABTC | Stock | 54.0 | 55.155 | 48.0 | 49.1325 | 16650.533333333333 |
| 2024-11-21 | ABTS | Stock | 9.45 | 9.75 | 9.375 | 9.5985 | 2743.0 |
| 2024-11-21 | ABUS | Stock | 3.44 | 3.56 | 3.428 | 3.46 | 919212.0 |
| 2024-11-21 | ABVC | Stock | 0.585 | 0.59 | 0.53 | 0.5499 | 89041.0 |
| 2024-11-21 | ABVE | Stock | 0.688 | 0.69 | 0.582 | 0.6121 | 1152727.0 |
| 2024-11-21 | ABVEW | Stock | 0.0151 | 0.02 | 0.0151 | 0.0181 | 22033.0 |
> showing 50 of 7,145 rows — these rows as CSV