PREVIEW / stock_daily / 2024-10-22
file: by_date/stock_daily/2024/2024-10-22.parquet size: 243 KB rows: 7,075 symbols: 672
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-10-22 | AAPL | Stock | 233.885 | 236.22 | 232.6 | 235.86 | 35384634.0 |
| 2024-10-22 | MSFT | Stock | 418.49 | 430.5793 | 418.04 | 427.51 | 25043595.0 |
| 2024-10-22 | NVDA | Stock | 142.91 | 144.42 | 141.78 | 143.59 | 224530084.0 |
| 2024-10-22 | AMZN | Stock | 188.35 | 191.5201 | 186.975 | 189.7 | 29179306.0 |
| 2024-10-22 | GOOGL | Stock | 162.98 | 165.77 | 162.98 | 165.14 | 16568121.0 |
| 2024-10-22 | META | Stock | 574.29 | 583.53 | 572.12 | 582.01 | 7887300.0 |
| 2024-10-22 | TSLA | Stock | 217.31 | 218.22 | 215.26 | 217.97 | 42651883.0 |
| 2024-10-22 | TLT | Stock | 92.65 | 92.76 | 92.091 | 92.32 | 32096893.0 |
| 2024-10-22 | ES | Stock | 65.94 | 66.36 | 65.29 | 66.23 | 1228937.0 |
| 2024-10-22 | CL | Stock | 98.73 | 99.95 | 98.68 | 99.67 | 3915239.0 |
| 2024-10-22 | A | Stock | 134.69 | 134.75 | 131.98 | 133.46 | 1555882.0 |
| 2024-10-22 | AA | Stock | 42.08 | 42.81 | 41.7 | 42.02 | 3588371.0 |
| 2024-10-22 | AACG | Stock | 1.0 | 1.01 | 0.9602 | 1.0 | 56093.0 |
| 2024-10-22 | AACT | Stock | 10.9 | 10.9 | 10.86 | 10.86 | 531040.0 |
| 2024-10-22 | AAGR-DELISTED | Stock | 0.0002 | 0.0002 | 0.0 | 0.0 | 59443.0 |
| 2024-10-22 | AAL | Stock | 12.93 | 13.03 | 12.615 | 12.96 | 24059865.0 |
| 2024-10-22 | AAM | Stock | 10.0228 | 10.03 | 10.0228 | 10.03 | 5369.0 |
| 2024-10-22 | AAME | Stock | 1.6 | 1.69 | 1.6 | 1.69 | 3452.0 |
| 2024-10-22 | AAMI | Stock | 26.1 | 26.41 | 25.86 | 26.19 | 130050.0 |
| 2024-10-22 | AAOI | Stock | 18.1 | 18.37 | 17.403 | 17.63 | 1889912.0 |
| 2024-10-22 | AAON | Stock | 108.02 | 108.855 | 107.13 | 107.13 | 213511.0 |
| 2024-10-22 | AAP | Stock | 40.38 | 40.5095 | 38.74 | 38.75 | 2941807.0 |
| 2024-10-22 | AAT | Stock | 27.41 | 27.67 | 27.2802 | 27.37 | 99194.0 |
| 2024-10-22 | AATC | Stock | 7.49 | 7.49 | 7.31 | 7.43 | 2016.0 |
| 2024-10-22 | AAUAF-DELISTED | Stock | 0.0527 | 0.0529 | 0.0485 | 0.05 | 46763.0 |
| 2024-10-22 | AAXJ | Stock | 77.65 | 78.01 | 77.52 | 77.82 | 399747.0 |
| 2024-10-22 | AB | Stock | 37.84 | 38.11 | 37.7201 | 37.91 | 146728.0 |
| 2024-10-22 | ABAT | Stock | 1.02 | 1.03 | 0.9868 | 1.01 | 335609.0 |
| 2024-10-22 | ABBV | Stock | 186.32 | 189.1 | 186.23 | 188.76 | 3535499.0 |
| 2024-10-22 | ABCB | Stock | 62.4 | 63.02 | 62.23 | 62.89 | 201531.0 |
| 2024-10-22 | ABCL | Stock | 2.78 | 2.84 | 2.744 | 2.84 | 1210180.0 |
| 2024-10-22 | ABEO | Stock | 6.52 | 6.62 | 6.47 | 6.57 | 101488.0 |
| 2024-10-22 | ABEV | Stock | 2.28 | 2.29 | 2.25 | 2.27 | 28882033.0 |
| 2024-10-22 | ABG | Stock | 229.95 | 229.95 | 225.86 | 225.9 | 113363.0 |
| 2024-10-22 | ABLLW | Stock | 1.55 | 1.55 | 1.37 | 1.49 | 30333.0 |
| 2024-10-22 | ABLV | Stock | 0.95 | 0.9501 | 0.95 | 0.95 | 7959.0 |
| 2024-10-22 | ABM | Stock | 54.2 | 54.46 | 52.93 | 53.43 | 318224.0 |
| 2024-10-22 | ABNB | Stock | 136.11 | 136.35 | 135.3316 | 135.59 | 1907412.0 |
| 2024-10-22 | ABOS | Stock | 2.69 | 2.82 | 2.64 | 2.8 | 162187.0 |
| 2024-10-22 | ABR | Stock | 15.05 | 15.33 | 14.96 | 15.25 | 2209788.0 |
| 2024-10-22 | ABR.D | Stock | 19.7 | 19.9 | 19.65 | 19.9 | 12358.0 |
| 2024-10-22 | ABR.E | Stock | 19.75 | 20.025 | 19.65 | 20.0138 | 2302.0 |
| 2024-10-22 | ABR.F | Stock | 20.18 | 20.47 | 20.07 | 20.2 | 39095.0 |
| 2024-10-22 | ABSI | Stock | 4.02 | 4.16 | 3.98 | 4.14 | 456854.0 |
| 2024-10-22 | ABT | Stock | 116.865 | 117.2 | 115.84 | 116.12 | 4669496.0 |
| 2024-10-22 | ABTC | Stock | 50.925000000000004 | 50.925000000000004 | 42.9525 | 47.25 | 10250.066666666666 |
| 2024-10-22 | ABTS | Stock | 7.08 | 7.4985 | 7.05 | 7.0815 | 972.0 |
| 2024-10-22 | ABUS | Stock | 4.06 | 4.08 | 3.91 | 4.03 | 944016.0 |
| 2024-10-22 | ABVC | Stock | 0.54 | 0.579 | 0.532 | 0.56 | 75706.0 |
| 2024-10-22 | ABVE | Stock | 0.4801 | 0.5297 | 0.4801 | 0.51 | 41612.0 |
> showing 50 of 7,075 rows — these rows as CSV