PREVIEW / stock_daily / 2024-09-18
file: by_date/stock_daily/2024/2024-09-18.parquet size: 245 KB rows: 7,109 symbols: 723
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-09-18 | AAPL | Stock | 217.55 | 222.71 | 217.54 | 220.69 | 58927461.0 |
| 2024-09-18 | MSFT | Stock | 435.0 | 436.03 | 430.41 | 430.81 | 18416325.0 |
| 2024-09-18 | NVDA | Stock | 115.89 | 117.7 | 113.22 | 113.37 | 304495868.0 |
| 2024-09-18 | AMZN | Stock | 186.45 | 188.8 | 185.06 | 186.43 | 31659045.0 |
| 2024-09-18 | GOOGL | Stock | 159.86 | 160.5 | 158.595 | 159.81 | 23677315.0 |
| 2024-09-18 | META | Stock | 537.065 | 544.2 | 533.9026 | 537.95 | 9792072.0 |
| 2024-09-18 | TSLA | Stock | 230.09 | 235.68 | 226.88 | 227.2 | 77598175.0 |
| 2024-09-18 | TLT | Stock | 100.24 | 100.7266 | 99.54 | 99.59 | 48897047.0 |
| 2024-09-18 | ES | Stock | 67.95 | 68.145 | 67.14 | 67.49 | 1538960.0 |
| 2024-09-18 | CL | Stock | 104.23 | 104.75 | 102.26 | 103.18 | 4050911.0 |
| 2024-09-18 | A | Stock | 138.5 | 141.0 | 137.43 | 139.01 | 1339855.0 |
| 2024-09-18 | AA | Stock | 34.24 | 35.95 | 33.88 | 34.34 | 6442036.0 |
| 2024-09-18 | AACG | Stock | 0.5 | 0.533 | 0.5 | 0.5187 | 11100.0 |
| 2024-09-18 | AACT | Stock | 10.808 | 10.82 | 10.8 | 10.805 | 351894.0 |
| 2024-09-18 | AAGR-DELISTED | Stock | 0.1301 | 0.1341 | 0.1224 | 0.1224 | 82327.0 |
| 2024-09-18 | AAGRW-DELISTED | Stock | 0.0062 | 0.0063 | 0.0045 | 0.0045 | 155242.0 |
| 2024-09-18 | AAL | Stock | 11.24 | 11.285 | 10.92 | 11.03 | 37269479.0 |
| 2024-09-18 | AAM | Stock | 9.99 | 9.99 | 9.9817 | 9.9817 | 4468.0 |
| 2024-09-18 | AAME | Stock | 1.635 | 1.635 | 1.55 | 1.55 | 3571.0 |
| 2024-09-18 | AAMI | Stock | 25.0 | 25.67 | 25.0 | 25.12 | 170390.0 |
| 2024-09-18 | AAN-DELISTED | Stock | 10.06 | 10.06 | 10.045 | 10.05 | 476065.0 |
| 2024-09-18 | AAOI | Stock | 13.62 | 13.89 | 12.8 | 13.28 | 1347868.0 |
| 2024-09-18 | AAON | Stock | 96.27 | 99.27 | 95.25 | 96.93 | 260224.0 |
| 2024-09-18 | AAP | Stock | 41.43 | 42.9 | 41.1405 | 42.07 | 4271207.0 |
| 2024-09-18 | AAT | Stock | 27.0 | 27.62 | 26.85 | 27.11 | 336805.0 |
| 2024-09-18 | AATC | Stock | 7.89 | 7.9 | 7.78 | 7.9 | 4063.0 |
| 2024-09-18 | AAUAF-DELISTED | Stock | 0.04 | 0.0595 | 0.04 | 0.05375 | 65869.0 |
| 2024-09-18 | AAXJ | Stock | 72.65 | 73.13 | 72.16 | 72.26 | 192535.0 |
| 2024-09-18 | AB | Stock | 34.6 | 34.8 | 34.33 | 34.6 | 392950.0 |
| 2024-09-18 | ABAT | Stock | 1.01 | 1.03 | 0.99 | 0.99 | 317068.0 |
| 2024-09-18 | ABBV | Stock | 193.13 | 195.58 | 191.7776 | 192.94 | 3148764.0 |
| 2024-09-18 | ABCB | Stock | 62.17 | 64.92 | 61.28 | 62.58 | 444593.0 |
| 2024-09-18 | ABCL | Stock | 2.72 | 2.925 | 2.71 | 2.75 | 1886221.0 |
| 2024-09-18 | ABEO | Stock | 5.49 | 5.6099 | 5.43 | 5.45 | 160408.0 |
| 2024-09-18 | ABEV | Stock | 2.37 | 2.43 | 2.37 | 2.39 | 19636068.0 |
| 2024-09-18 | ABG | Stock | 221.86 | 228.77 | 218.47 | 219.95 | 275861.0 |
| 2024-09-18 | ABLLW | Stock | 1.4 | 1.5 | 1.33 | 1.5 | 30810.0 |
| 2024-09-18 | ABLV | Stock | 1.11 | 1.11 | 0.8351 | 0.9714 | 98241.0 |
| 2024-09-18 | ABM | Stock | 51.0 | 51.68 | 50.55 | 50.94 | 715795.0 |
| 2024-09-18 | ABNB | Stock | 122.32 | 125.66 | 122.0 | 122.42 | 3838080.0 |
| 2024-09-18 | ABOS | Stock | 2.49 | 2.54 | 2.44 | 2.44 | 126802.0 |
| 2024-09-18 | ABR | Stock | 14.69 | 15.25 | 14.69 | 15.03 | 5116325.0 |
| 2024-09-18 | ABR.D | Stock | 19.15 | 19.26 | 19.1 | 19.1 | 22793.0 |
| 2024-09-18 | ABR.E | Stock | 19.2498 | 19.79 | 19.2 | 19.2 | 9992.0 |
| 2024-09-18 | ABR.F | Stock | 19.4 | 19.51 | 19.27 | 19.27 | 20053.0 |
| 2024-09-18 | ABSI | Stock | 3.93 | 4.19 | 3.895 | 3.98 | 765372.0 |
| 2024-09-18 | ABT | Stock | 117.5 | 117.5 | 114.5162 | 114.88 | 5883480.0 |
| 2024-09-18 | ABTC | Stock | 40.575 | 41.8125 | 37.245000000000005 | 38.25 | 1789.6 |
| 2024-09-18 | ABTS | Stock | 7.401 | 8.025 | 7.2 | 8.025 | 127.0 |
| 2024-09-18 | ABUS | Stock | 4.07 | 4.215 | 4.07 | 4.13 | 1212230.0 |
> showing 50 of 7,109 rows — these rows as CSV