PREVIEW / stock_daily / 2024-12-27
file: by_date/stock_daily/2024/2024-12-27.parquet size: 245 KB rows: 7,132 symbols: 551
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-12-27 | AAPL | Stock | 257.83 | 258.7 | 253.06 | 255.59 | 40499007.0 |
| 2024-12-27 | MSFT | Stock | 434.6 | 435.22 | 426.35 | 430.53 | 17611745.0 |
| 2024-12-27 | NVDA | Stock | 138.55 | 139.02 | 134.71 | 137.01 | 168562734.0 |
| 2024-12-27 | AMZN | Stock | 225.6 | 226.03 | 220.9 | 223.75 | 26930109.0 |
| 2024-12-27 | GOOGL | Stock | 194.95 | 195.32 | 190.65 | 192.76 | 18891362.0 |
| 2024-12-27 | META | Stock | 599.41 | 601.85 | 589.8 | 599.81 | 7862353.0 |
| 2024-12-27 | TSLA | Stock | 449.52 | 450.0 | 426.5 | 431.66 | 81824668.0 |
| 2024-12-27 | TLT | Stock | 87.48 | 87.775 | 87.06 | 87.1 | 27262321.0 |
| 2024-12-27 | ES | Stock | 56.98 | 57.7999 | 56.77 | 57.32 | 1042803.0 |
| 2024-12-27 | CL | Stock | 92.73 | 92.73 | 91.65 | 91.81 | 2407779.0 |
| 2024-12-27 | A | Stock | 134.62 | 136.2221 | 134.59 | 135.54 | 570787.0 |
| 2024-12-27 | AA | Stock | 37.97 | 38.13 | 37.38 | 37.68 | 1910362.0 |
| 2024-12-27 | AACG | Stock | 0.78 | 0.78 | 0.74 | 0.76255 | 29728.0 |
| 2024-12-27 | AACT | Stock | 10.955 | 10.96 | 10.95 | 10.96 | 9844.0 |
| 2024-12-27 | AAGR-DELISTED | Stock | 0.0005 | 0.0005 | 0.0 | 0.0 | 130101.0 |
| 2024-12-27 | AAL | Stock | 17.19 | 17.38 | 17.01 | 17.35 | 29487979.0 |
| 2024-12-27 | AAM | Stock | 10.1 | 10.1 | 10.09 | 10.09 | 108606.0 |
| 2024-12-27 | AAME | Stock | 1.4843 | 1.4843 | 1.4843 | 1.4843 | 276.0 |
| 2024-12-27 | AAMI | Stock | 27.09 | 27.35 | 26.66 | 26.9 | 131187.0 |
| 2024-12-27 | AAOI | Stock | 40.19 | 40.4 | 37.02 | 37.74 | 2468597.0 |
| 2024-12-27 | AAON | Stock | 122.0 | 122.6 | 119.85 | 121.42 | 239339.0 |
| 2024-12-27 | AAP | Stock | 44.0 | 45.03 | 43.8 | 44.06 | 1124318.0 |
| 2024-12-27 | AAT | Stock | 26.29 | 26.66 | 26.02 | 26.12 | 212714.0 |
| 2024-12-27 | AATC | Stock | 8.11 | 8.1775 | 8.07 | 8.08 | 5443.0 |
| 2024-12-27 | AAUAF-DELISTED | Stock | 0.0376 | 0.04 | 0.0375 | 0.038 | 254435.0 |
| 2024-12-27 | AAXJ | Stock | 72.83 | 72.99 | 72.61 | 72.99 | 225027.0 |
| 2024-12-27 | AB | Stock | 37.44 | 37.77 | 37.06 | 37.24 | 314113.0 |
| 2024-12-27 | ABAT | Stock | 3.63 | 4.11 | 2.91 | 3.36 | 21458213.0 |
| 2024-12-27 | ABBV | Stock | 177.92 | 179.66 | 177.29 | 178.01 | 2603517.0 |
| 2024-12-27 | ABCB | Stock | 63.28 | 63.99 | 62.2681 | 63.05 | 230707.0 |
| 2024-12-27 | ABCL | Stock | 3.01 | 3.06 | 2.87 | 2.99 | 3382110.0 |
| 2024-12-27 | ABEO | Stock | 5.68 | 5.725 | 5.57 | 5.63 | 121821.0 |
| 2024-12-27 | ABEV | Stock | 1.9 | 1.91 | 1.86 | 1.87 | 61223113.0 |
| 2024-12-27 | ABG | Stock | 246.57 | 248.0 | 242.28 | 244.53 | 84763.0 |
| 2024-12-27 | ABLLW | Stock | 1.1 | 1.1 | 1.0 | 1.06 | 72226.0 |
| 2024-12-27 | ABLV | Stock | 0.6192 | 0.6946 | 0.6192 | 0.6819 | 3226.0 |
| 2024-12-27 | ABM | Stock | 50.92 | 51.89 | 50.5975 | 51.04 | 379415.0 |
| 2024-12-27 | ABNB | Stock | 133.59 | 134.5 | 132.16 | 133.385 | 2615519.0 |
| 2024-12-27 | ABOS | Stock | 1.9 | 1.9 | 1.75 | 1.78 | 326723.0 |
| 2024-12-27 | ABPWW | Stock | 0.1799 | 0.18 | 0.11 | 0.1425 | 104825.0 |
| 2024-12-27 | ABR | Stock | 13.86 | 13.92 | 13.59 | 13.66 | 1865337.0 |
| 2024-12-27 | ABR.D | Stock | 19.0 | 19.1 | 18.72 | 18.85 | 25631.0 |
| 2024-12-27 | ABR.E | Stock | 18.6 | 18.6783 | 18.25 | 18.59 | 7855.0 |
| 2024-12-27 | ABR.F | Stock | 22.88 | 23.048 | 22.78 | 23.0 | 24880.0 |
| 2024-12-27 | ABSI | Stock | 2.96 | 3.02 | 2.72 | 2.77 | 2365118.0 |
| 2024-12-27 | ABT | Stock | 115.01 | 115.95 | 114.51 | 114.99 | 2706885.0 |
| 2024-12-27 | ABTC | Stock | 34.095000000000006 | 35.985 | 32.2725 | 34.0125 | 7074.533333333333 |
| 2024-12-27 | ABTS | Stock | 6.6615 | 6.75 | 6.45 | 6.4965 | 2067.0 |
| 2024-12-27 | ABUS | Stock | 3.16 | 3.22 | 3.115 | 3.21 | 824263.0 |
| 2024-12-27 | ABVC | Stock | 0.5499 | 0.62947 | 0.5499 | 0.5812 | 343358.0 |
> showing 50 of 7,132 rows — these rows as CSV