PREVIEW / stock_daily / 2024-10-14
file: by_date/stock_daily/2024/2024-10-14.parquet size: 245 KB rows: 7,122 symbols: 711
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-14 | AAPL | Stock | 228.7 | 231.73 | 228.6 | 231.3 | 34344586.0 |
| 2024-10-14 | MSFT | Stock | 417.77 | 424.04 | 417.52 | 419.14 | 16060964.0 |
| 2024-10-14 | NVDA | Stock | 136.47 | 139.6 | 136.3 | 138.07 | 223739058.0 |
| 2024-10-14 | AMZN | Stock | 189.78 | 189.83 | 187.36 | 187.54 | 22106973.0 |
| 2024-10-14 | GOOGL | Stock | 163.64 | 166.226 | 163.4 | 164.96 | 19016141.0 |
| 2024-10-14 | META | Stock | 594.22 | 600.1 | 589.96 | 590.42 | 7790758.0 |
| 2024-10-14 | TSLA | Stock | 220.13 | 221.91 | 213.74 | 219.16 | 85386551.0 |
| 2024-10-14 | TLT | Stock | 93.04 | 93.78 | 92.98 | 93.765 | 28795344.0 |
| 2024-10-14 | ES | Stock | 63.82 | 64.09 | 63.595 | 64.02 | 1643944.0 |
| 2024-10-14 | CL | Stock | 100.01 | 100.84 | 99.92 | 100.73 | 3114139.0 |
| 2024-10-14 | A | Stock | 144.0 | 145.07 | 142.82 | 144.25 | 1534858.0 |
| 2024-10-14 | AA | Stock | 40.45 | 41.99 | 40.44 | 41.8 | 5447492.0 |
| 2024-10-14 | AACG | Stock | 0.94 | 1.02 | 0.94 | 0.9999 | 145930.0 |
| 2024-10-14 | AACT | Stock | 10.9 | 10.9 | 10.82 | 10.83 | 8238.0 |
| 2024-10-14 | AAGR-DELISTED | Stock | 0.0198 | 0.0198 | 0.0151 | 0.019 | 124903.0 |
| 2024-10-14 | AAGRW-DELISTED | Stock | 0.0013 | 0.0013 | 0.0013 | 0.0013 | 385.0 |
| 2024-10-14 | AAL | Stock | 11.85 | 11.9476 | 11.7 | 11.87 | 20540948.0 |
| 2024-10-14 | AAM | Stock | 10.03 | 10.03 | 10.02 | 10.02 | 5118.0 |
| 2024-10-14 | AAME | Stock | 1.72 | 1.72 | 1.667 | 1.667 | 639.0 |
| 2024-10-14 | AAMI | Stock | 26.08 | 26.78 | 25.89 | 26.6 | 212267.0 |
| 2024-10-14 | AAOI | Stock | 18.5 | 19.4594 | 18.1 | 18.42 | 3952316.0 |
| 2024-10-14 | AAON | Stock | 112.86 | 113.86 | 111.78 | 112.03 | 263793.0 |
| 2024-10-14 | AAP | Stock | 37.55 | 39.5 | 37.4 | 39.47 | 2864075.0 |
| 2024-10-14 | AAT | Stock | 26.67 | 27.36 | 26.52 | 27.19 | 185126.0 |
| 2024-10-14 | AATC | Stock | 7.52 | 7.56 | 7.52 | 7.52 | 2784.0 |
| 2024-10-14 | AAUAF-DELISTED | Stock | 0.04 | 0.047 | 0.04 | 0.047 | 32724.0 |
| 2024-10-14 | AAXJ | Stock | 79.02 | 79.7 | 78.72 | 79.11 | 437289.0 |
| 2024-10-14 | AB | Stock | 35.7 | 36.2 | 35.485 | 36.11 | 319917.0 |
| 2024-10-14 | ABAT | Stock | 1.02 | 1.02 | 0.99 | 1.0 | 146859.0 |
| 2024-10-14 | ABBV | Stock | 194.24 | 196.34 | 193.662 | 195.65 | 3318804.0 |
| 2024-10-14 | ABCB | Stock | 63.27 | 64.21 | 62.685 | 63.9 | 198454.0 |
| 2024-10-14 | ABCL | Stock | 2.6 | 2.6 | 2.43 | 2.52 | 2040116.0 |
| 2024-10-14 | ABEO | Stock | 6.35 | 6.48 | 6.25 | 6.27 | 215813.0 |
| 2024-10-14 | ABEV | Stock | 2.32 | 2.34 | 2.3 | 2.34 | 13694395.0 |
| 2024-10-14 | ABG | Stock | 221.88 | 226.0486 | 221.39 | 225.65 | 77771.0 |
| 2024-10-14 | ABLLW | Stock | 1.71 | 1.71 | 1.63 | 1.63 | 12262.0 |
| 2024-10-14 | ABLV | Stock | 0.95 | 0.95 | 0.87 | 0.88 | 8725.0 |
| 2024-10-14 | ABM | Stock | 53.2 | 54.45 | 53.14 | 53.98 | 490149.0 |
| 2024-10-14 | ABNB | Stock | 133.97 | 134.98 | 133.42 | 134.79 | 2285450.0 |
| 2024-10-14 | ABOS | Stock | 2.37 | 2.42 | 2.33 | 2.35 | 76651.0 |
| 2024-10-14 | ABR | Stock | 15.1 | 15.27 | 15.04 | 15.24 | 1820422.0 |
| 2024-10-14 | ABR.D | Stock | 19.76 | 19.925 | 19.7221 | 19.925 | 25967.0 |
| 2024-10-14 | ABR.E | Stock | 20.425 | 20.6 | 20.12 | 20.43 | 4613.0 |
| 2024-10-14 | ABR.F | Stock | 20.0 | 20.165 | 19.88 | 20.02 | 34191.0 |
| 2024-10-14 | ABSI | Stock | 4.05 | 4.135 | 3.95 | 4.1 | 567583.0 |
| 2024-10-14 | ABT | Stock | 116.26 | 117.58 | 115.98 | 117.25 | 3658197.0 |
| 2024-10-14 | ABTC | Stock | 40.5 | 44.4975 | 38.865 | 42.1875 | 7771.733333333334 |
| 2024-10-14 | ABTS | Stock | 6.3 | 7.8 | 6.159 | 7.2 | 5555.0 |
| 2024-10-14 | ABUS | Stock | 3.88 | 3.9 | 3.83 | 3.86 | 419234.0 |
| 2024-10-14 | ABVC | Stock | 0.49 | 0.5177 | 0.4845 | 0.5001 | 95051.0 |
> showing 50 of 7,122 rows — these rows as CSV