PREVIEW / stock_daily / 2024-11-20
file: by_date/stock_daily/2024/2024-11-20.parquet size: 246 KB rows: 7,128 symbols: 641
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-20 | AAPL | Stock | 228.06 | 229.93 | 225.89 | 229.0 | 33480944.0 |
| 2024-11-20 | MSFT | Stock | 416.87 | 417.29 | 410.58 | 415.49 | 17175921.0 |
| 2024-11-20 | NVDA | Stock | 147.41 | 147.56 | 142.73 | 145.89 | 299291627.0 |
| 2024-11-20 | AMZN | Stock | 202.98 | 203.13 | 199.45 | 202.88 | 31413149.0 |
| 2024-11-20 | GOOGL | Stock | 177.34 | 177.675 | 173.78 | 175.98 | 18997111.0 |
| 2024-11-20 | META | Stock | 562.93 | 566.3499 | 554.2001 | 565.52 | 9467651.0 |
| 2024-11-20 | TSLA | Stock | 345.0 | 346.5999 | 334.3 | 342.03 | 64561243.0 |
| 2024-11-20 | TLT | Stock | 90.15 | 90.83 | 90.11 | 90.41 | 27755434.0 |
| 2024-11-20 | ES | Stock | 61.58 | 61.64 | 61.19 | 61.61 | 2256271.0 |
| 2024-11-20 | CL | Stock | 93.41 | 94.44 | 92.86 | 93.91 | 3589629.0 |
| 2024-11-20 | A | Stock | 125.32 | 128.71 | 124.89 | 128.57 | 1645339.0 |
| 2024-11-20 | AA | Stock | 45.52 | 46.14 | 45.2 | 45.74 | 3833126.0 |
| 2024-11-20 | AACG | Stock | 1.02 | 1.02 | 0.9692 | 1.02 | 37740.0 |
| 2024-11-20 | AACT | Stock | 10.94 | 10.94 | 10.89 | 10.89 | 352570.0 |
| 2024-11-20 | AAL | Stock | 14.18 | 14.49 | 14.0 | 14.46 | 25359769.0 |
| 2024-11-20 | AAM | Stock | 10.05 | 10.06 | 10.05 | 10.0507 | 1079.0 |
| 2024-11-20 | AAME | Stock | 1.5799 | 1.65 | 1.54 | 1.59 | 5641.0 |
| 2024-11-20 | AAMI | Stock | 29.91 | 30.2 | 29.535 | 30.19 | 137712.0 |
| 2024-11-20 | AAOI | Stock | 29.95 | 34.09 | 29.73 | 34.07 | 6751645.0 |
| 2024-11-20 | AAON | Stock | 131.17 | 132.8425 | 128.74 | 132.05 | 443740.0 |
| 2024-11-20 | AAP | Stock | 38.89 | 39.55 | 37.96 | 38.63 | 2398442.0 |
| 2024-11-20 | AAT | Stock | 27.65 | 27.7961 | 27.345 | 27.67 | 146604.0 |
| 2024-11-20 | AATC | Stock | 8.01 | 8.01 | 8.01 | 8.01 | 200.0 |
| 2024-11-20 | AAUAF-DELISTED | Stock | 0.0319 | 0.05 | 0.0319 | 0.0384 | 44458.0 |
| 2024-11-20 | AAXJ | Stock | 74.28 | 74.53 | 73.88 | 74.3 | 423735.0 |
| 2024-11-20 | AB | Stock | 36.66 | 37.22 | 36.48 | 37.17 | 310201.0 |
| 2024-11-20 | ABAT | Stock | 0.8 | 0.805 | 0.748 | 0.7697 | 648639.0 |
| 2024-11-20 | ABBV | Stock | 166.91 | 167.91 | 165.65 | 167.76 | 4271556.0 |
| 2024-11-20 | ABCB | Stock | 68.22 | 68.76 | 67.48 | 68.11 | 292112.0 |
| 2024-11-20 | ABCL | Stock | 2.69 | 2.72 | 2.62 | 2.67 | 1716519.0 |
| 2024-11-20 | ABEO | Stock | 5.9 | 6.01 | 5.64 | 5.75 | 214800.0 |
| 2024-11-20 | ABEV | Stock | 2.18 | 2.185 | 2.16 | 2.17 | 3026490.0 |
| 2024-11-20 | ABG | Stock | 248.2 | 251.78 | 246.71 | 250.48 | 131007.0 |
| 2024-11-20 | ABLLW | Stock | 1.4 | 1.5 | 1.34 | 1.46 | 73883.0 |
| 2024-11-20 | ABLV | Stock | 0.84 | 0.9 | 0.8171 | 0.86 | 21460.0 |
| 2024-11-20 | ABM | Stock | 55.46 | 55.65 | 54.91 | 55.58 | 148461.0 |
| 2024-11-20 | ABNB | Stock | 130.22 | 135.38 | 130.22 | 135.25 | 5492154.0 |
| 2024-11-20 | ABOS | Stock | 2.42 | 2.45 | 2.32 | 2.37 | 177944.0 |
| 2024-11-20 | ABPWW | Stock | 0.0792 | 0.08 | 0.0792 | 0.08 | 400.0 |
| 2024-11-20 | ABR | Stock | 14.67 | 14.72 | 14.48 | 14.61 | 1243128.0 |
| 2024-11-20 | ABR.D | Stock | 18.6917 | 18.7399 | 18.3 | 18.39 | 13277.0 |
| 2024-11-20 | ABR.E | Stock | 18.57 | 18.58 | 18.5 | 18.5 | 6520.0 |
| 2024-11-20 | ABR.F | Stock | 20.4 | 20.5 | 20.34 | 20.43 | 20843.0 |
| 2024-11-20 | ABSI | Stock | 2.69 | 2.72 | 2.55 | 2.68 | 1057833.0 |
| 2024-11-20 | ABT | Stock | 116.69 | 116.77 | 115.53 | 115.93 | 5345138.0 |
| 2024-11-20 | ABTC | Stock | 54.0 | 57.45 | 49.17 | 50.1225 | 13252.4 |
| 2024-11-20 | ABTS | Stock | 9.0 | 9.735 | 9.0 | 9.2835 | 5490.0 |
| 2024-11-20 | ABUS | Stock | 3.53 | 3.5399 | 3.42 | 3.44 | 612994.0 |
| 2024-11-20 | ABVC | Stock | 0.55 | 0.57 | 0.5457 | 0.5674 | 27939.0 |
| 2024-11-20 | ABVE | Stock | 0.63 | 0.67 | 0.525 | 0.668 | 1269912.0 |
> showing 50 of 7,128 rows — these rows as CSV