PREVIEW / stock_daily / 2024-10-15
file: by_date/stock_daily/2024/2024-10-15.parquet size: 247 KB rows: 7,150 symbols: 699
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-15 | AAPL | Stock | 233.61 | 237.49 | 232.37 | 233.85 | 60753550.0 |
| 2024-10-15 | MSFT | Stock | 422.18 | 422.48 | 415.26 | 418.74 | 17695934.0 |
| 2024-10-15 | NVDA | Stock | 137.87 | 138.57 | 128.74 | 131.6 | 372626045.0 |
| 2024-10-15 | AMZN | Stock | 187.63 | 188.41 | 184.58 | 187.69 | 31379893.0 |
| 2024-10-15 | GOOGL | Stock | 165.785 | 167.68 | 164.625 | 165.46 | 20247195.0 |
| 2024-10-15 | META | Stock | 590.16 | 590.61 | 580.143 | 586.27 | 9364075.0 |
| 2024-10-15 | TSLA | Stock | 220.01 | 224.26 | 217.12 | 219.57 | 61843540.0 |
| 2024-10-15 | TLT | Stock | 94.46 | 95.0 | 94.3736 | 94.91 | 46429050.0 |
| 2024-10-15 | ES | Stock | 64.36 | 65.71 | 64.26 | 65.4 | 3302784.0 |
| 2024-10-15 | CL | Stock | 100.95 | 102.61 | 100.95 | 101.55 | 3758299.0 |
| 2024-10-15 | A | Stock | 144.35 | 146.66 | 144.068 | 144.58 | 1223034.0 |
| 2024-10-15 | AA | Stock | 41.34 | 41.81 | 41.0 | 41.3 | 4548384.0 |
| 2024-10-15 | AACG | Stock | 1.0 | 1.01 | 0.98635 | 1.0 | 56146.0 |
| 2024-10-15 | AACT | Stock | 10.89 | 10.89 | 10.83 | 10.83 | 40998.0 |
| 2024-10-15 | AAGR-DELISTED | Stock | 0.0151 | 0.0195 | 0.015 | 0.0152 | 109946.0 |
| 2024-10-15 | AAGRW-DELISTED | Stock | 0.0013 | 0.0045 | 0.0006 | 0.00228 | 166891.0 |
| 2024-10-15 | AAL | Stock | 12.12 | 12.47 | 12.0 | 12.03 | 36409420.0 |
| 2024-10-15 | AAM | Stock | 10.02 | 10.02 | 10.0178 | 10.0178 | 523.0 |
| 2024-10-15 | AAME | Stock | 1.69 | 1.7298 | 1.6883 | 1.69 | 2790.0 |
| 2024-10-15 | AAMI | Stock | 26.42 | 27.31 | 26.42 | 26.63 | 206956.0 |
| 2024-10-15 | AAOI | Stock | 18.55 | 18.79 | 16.925 | 17.4 | 3272866.0 |
| 2024-10-15 | AAON | Stock | 112.07 | 112.48 | 110.2 | 110.99 | 261077.0 |
| 2024-10-15 | AAP | Stock | 40.4 | 41.42 | 39.3 | 39.47 | 3875739.0 |
| 2024-10-15 | AAT | Stock | 27.16 | 28.225 | 27.1 | 27.79 | 250400.0 |
| 2024-10-15 | AATC | Stock | 7.6 | 7.6 | 6.57 | 7.4 | 48692.0 |
| 2024-10-15 | AAUAF-DELISTED | Stock | 0.0474 | 0.0488 | 0.046 | 0.0464 | 41316.0 |
| 2024-10-15 | AAXJ | Stock | 78.27 | 78.3832 | 77.02 | 77.16 | 447474.0 |
| 2024-10-15 | AB | Stock | 36.26 | 36.85 | 36.2393 | 36.67 | 300014.0 |
| 2024-10-15 | ABAT | Stock | 1.0 | 1.02 | 0.98 | 0.9949 | 275112.0 |
| 2024-10-15 | ABBV | Stock | 194.73 | 196.25 | 191.215 | 191.86 | 6248343.0 |
| 2024-10-15 | ABCB | Stock | 64.31 | 66.22 | 63.665 | 64.59 | 529993.0 |
| 2024-10-15 | ABCL | Stock | 2.53 | 2.61 | 2.51 | 2.56 | 1820367.0 |
| 2024-10-15 | ABEO | Stock | 6.28 | 6.55 | 6.15 | 6.54 | 142808.0 |
| 2024-10-15 | ABEV | Stock | 2.31 | 2.31 | 2.27 | 2.28 | 15621997.0 |
| 2024-10-15 | ABG | Stock | 224.45 | 232.12 | 224.45 | 225.83 | 183196.0 |
| 2024-10-15 | ABLLW | Stock | 1.68 | 1.695 | 1.4801 | 1.4801 | 47794.0 |
| 2024-10-15 | ABLV | Stock | 0.8801 | 0.93 | 0.88 | 0.902 | 18578.0 |
| 2024-10-15 | ABLVW | Stock | 0.01945 | 0.0196 | 0.0133 | 0.0133 | 2807.0 |
| 2024-10-15 | ABM | Stock | 53.97 | 54.55 | 53.12 | 53.21 | 423821.0 |
| 2024-10-15 | ABNB | Stock | 133.51 | 134.0 | 132.3 | 133.27 | 3393885.0 |
| 2024-10-15 | ABOS | Stock | 2.36 | 2.41 | 2.29 | 2.33 | 98324.0 |
| 2024-10-15 | ABR | Stock | 15.3 | 15.42 | 15.16 | 15.17 | 1726838.0 |
| 2024-10-15 | ABR.D | Stock | 19.49 | 19.6782 | 19.3001 | 19.63 | 27640.0 |
| 2024-10-15 | ABR.E | Stock | 20.12 | 20.12 | 19.4 | 19.91 | 3250.0 |
| 2024-10-15 | ABR.F | Stock | 19.515 | 19.63 | 19.4 | 19.55 | 21125.0 |
| 2024-10-15 | ABSI | Stock | 4.05 | 4.07 | 3.87 | 3.98 | 609796.0 |
| 2024-10-15 | ABT | Stock | 116.75 | 118.36 | 115.81 | 116.05 | 5652262.0 |
| 2024-10-15 | ABTC | Stock | 42.3825 | 44.9925 | 39.9375 | 42.375 | 6349.8 |
| 2024-10-15 | ABTS | Stock | 7.2 | 7.2 | 6.618 | 6.6276 | 768.0 |
| 2024-10-15 | ABUS | Stock | 3.91 | 4.12 | 3.89 | 4.11 | 1152500.0 |
> showing 50 of 7,150 rows — these rows as CSV