PREVIEW / stock_daily / 2024-10-10
file: by_date/stock_daily/2024/2024-10-10.parquet size: 245 KB rows: 7,088 symbols: 705
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-10 | AAPL | Stock | 227.78 | 229.5 | 227.17 | 229.04 | 27074587.0 |
| 2024-10-10 | MSFT | Stock | 415.225 | 417.35 | 413.15 | 415.84 | 13309957.0 |
| 2024-10-10 | NVDA | Stock | 131.91 | 135.0 | 131.0 | 134.81 | 239956898.0 |
| 2024-10-10 | AMZN | Stock | 187.13 | 188.134 | 185.83 | 186.65 | 27242278.0 |
| 2024-10-10 | GOOGL | Stock | 160.87 | 163.07 | 160.395 | 162.08 | 14144068.0 |
| 2024-10-10 | META | Stock | 587.57 | 590.23 | 582.52 | 583.83 | 7593311.0 |
| 2024-10-10 | TSLA | Stock | 241.81 | 242.7899 | 232.34 | 238.77 | 82461173.0 |
| 2024-10-10 | TLT | Stock | 93.88 | 94.09 | 93.41 | 94.08 | 53667357.0 |
| 2024-10-10 | ES | Stock | 63.67 | 64.415 | 63.185 | 63.86 | 2036179.0 |
| 2024-10-10 | CL | Stock | 101.22 | 101.22 | 98.93 | 99.24 | 3967396.0 |
| 2024-10-10 | A | Stock | 143.21 | 144.41 | 142.595 | 142.74 | 1000801.0 |
| 2024-10-10 | AA | Stock | 38.45 | 39.73 | 38.21 | 39.25 | 3643683.0 |
| 2024-10-10 | AACG | Stock | 0.91 | 0.91 | 0.8501 | 0.9075 | 43020.0 |
| 2024-10-10 | AACT | Stock | 10.835 | 10.84 | 10.82 | 10.82 | 55377.0 |
| 2024-10-10 | AAGR-DELISTED | Stock | 0.0168 | 0.0295 | 0.0162 | 0.0214 | 86666.0 |
| 2024-10-10 | AAGRW-DELISTED | Stock | 0.0012 | 0.00215 | 0.0012 | 0.0013 | 20095.0 |
| 2024-10-10 | AAL | Stock | 11.77 | 12.0 | 11.65 | 11.76 | 26369899.0 |
| 2024-10-10 | AAM | Stock | 10.02 | 10.02 | 10.02 | 10.02 | 91985.0 |
| 2024-10-10 | AAME | Stock | 1.66 | 1.66 | 1.65 | 1.66 | 1122.0 |
| 2024-10-10 | AAMI | Stock | 24.12 | 24.57 | 24.015 | 24.53 | 233175.0 |
| 2024-10-10 | AAOI | Stock | 16.04 | 16.73 | 15.54 | 16.66 | 1448562.0 |
| 2024-10-10 | AAON | Stock | 108.38 | 108.85 | 106.94 | 108.59 | 275966.0 |
| 2024-10-10 | AAP | Stock | 38.26 | 38.36 | 37.245 | 37.4 | 2042226.0 |
| 2024-10-10 | AAT | Stock | 26.38 | 26.495 | 26.08 | 26.31 | 174704.0 |
| 2024-10-10 | AATC | Stock | 7.67 | 7.67 | 7.52 | 7.52 | 8608.0 |
| 2024-10-10 | AAUAF-DELISTED | Stock | 0.044 | 0.05 | 0.044 | 0.046 | 29522.0 |
| 2024-10-10 | AAXJ | Stock | 79.01 | 79.21 | 78.3 | 78.97 | 325487.0 |
| 2024-10-10 | AB | Stock | 34.74 | 35.8326 | 34.6 | 35.2 | 385528.0 |
| 2024-10-10 | ABAT | Stock | 1.0 | 1.02 | 0.9901 | 1.0 | 335490.0 |
| 2024-10-10 | ABBV | Stock | 194.54 | 194.82 | 193.275 | 194.35 | 3029766.0 |
| 2024-10-10 | ABCB | Stock | 60.0 | 60.77 | 59.745 | 60.58 | 300974.0 |
| 2024-10-10 | ABCL | Stock | 2.49 | 2.5291 | 2.41 | 2.5 | 1650550.0 |
| 2024-10-10 | ABEO | Stock | 6.62 | 6.66 | 6.41 | 6.58 | 375543.0 |
| 2024-10-10 | ABEV | Stock | 2.37 | 2.38 | 2.35 | 2.36 | 13733455.0 |
| 2024-10-10 | ABG | Stock | 221.31 | 223.0599 | 219.5 | 221.83 | 125009.0 |
| 2024-10-10 | ABLLW | Stock | 1.6 | 1.65 | 1.45 | 1.65 | 14887.0 |
| 2024-10-10 | ABLV | Stock | 0.88 | 0.88 | 0.8415 | 0.86 | 6321.0 |
| 2024-10-10 | ABLVW | Stock | 0.0151 | 0.0151 | 0.0102 | 0.0106 | 241191.0 |
| 2024-10-10 | ABM | Stock | 52.3 | 52.35 | 51.43 | 52.0 | 391838.0 |
| 2024-10-10 | ABNB | Stock | 135.55 | 136.37 | 132.52 | 132.81 | 3001561.0 |
| 2024-10-10 | ABOS | Stock | 2.27 | 2.32 | 2.21 | 2.25 | 115597.0 |
| 2024-10-10 | ABR | Stock | 15.07 | 15.37 | 15.04 | 15.35 | 3369338.0 |
| 2024-10-10 | ABR.D | Stock | 19.95 | 19.95 | 19.5501 | 19.8 | 16391.0 |
| 2024-10-10 | ABR.E | Stock | 20.04 | 20.08 | 20.0 | 20.08 | 3074.0 |
| 2024-10-10 | ABR.F | Stock | 19.73 | 19.7799 | 19.5512 | 19.75 | 39988.0 |
| 2024-10-10 | ABSI | Stock | 3.81 | 3.81 | 3.685 | 3.79 | 557439.0 |
| 2024-10-10 | ABT | Stock | 116.215 | 116.85 | 115.45 | 115.62 | 3703832.0 |
| 2024-10-10 | ABTC | Stock | 40.7175 | 41.25 | 39.449999999999996 | 39.74250000000001 | 834.8 |
| 2024-10-10 | ABTS | Stock | 6.2565 | 7.3485 | 6.225 | 6.225 | 1021.0 |
| 2024-10-10 | ABUS | Stock | 3.7 | 3.8 | 3.68 | 3.79 | 632322.0 |
> showing 50 of 7,088 rows — these rows as CSV