PREVIEW / stock_daily / 2024-09-20
file: by_date/stock_daily/2024/2024-09-20.parquet size: 245 KB rows: 7,123 symbols: 732
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-20 | AAPL | Stock | 229.97 | 233.09 | 227.62 | 228.2 | 283704670.0 |
| 2024-09-20 | MSFT | Stock | 437.22 | 439.24 | 434.22 | 435.27 | 50065027.0 |
| 2024-09-20 | NVDA | Stock | 117.06 | 118.6181 | 115.3901 | 116.0 | 367457202.0 |
| 2024-09-20 | AMZN | Stock | 190.23 | 191.84 | 187.41 | 191.6 | 95416049.0 |
| 2024-09-20 | GOOGL | Stock | 163.5 | 163.73 | 162.06 | 163.59 | 40896438.0 |
| 2024-09-20 | META | Stock | 560.0 | 564.5 | 556.3001 | 561.35 | 20402209.0 |
| 2024-09-20 | TSLA | Stock | 241.52 | 243.99 | 235.92 | 238.25 | 95782107.0 |
| 2024-09-20 | TLT | Stock | 98.99 | 99.245 | 98.72 | 98.88 | 37067571.0 |
| 2024-09-20 | ES | Stock | 67.14 | 67.54 | 66.77 | 67.14 | 4106799.0 |
| 2024-09-20 | CL | Stock | 102.28 | 103.06 | 101.87 | 103.06 | 9919576.0 |
| 2024-09-20 | A | Stock | 141.21 | 141.3952 | 137.88 | 140.09 | 2380889.0 |
| 2024-09-20 | AA | Stock | 33.6 | 34.055 | 33.205 | 33.83 | 8730799.0 |
| 2024-09-20 | AACG | Stock | 0.53 | 0.53121 | 0.51 | 0.5103 | 8008.0 |
| 2024-09-20 | AACT | Stock | 10.8 | 10.82 | 10.8 | 10.81 | 564337.0 |
| 2024-09-20 | AAGR-DELISTED | Stock | 0.1447 | 0.15 | 0.1355 | 0.15 | 2513946.0 |
| 2024-09-20 | AAGRW-DELISTED | Stock | 0.0071 | 0.0071 | 0.0052 | 0.0061 | 52294.0 |
| 2024-09-20 | AAL | Stock | 11.07 | 11.12 | 10.88 | 11.01 | 125829642.0 |
| 2024-09-20 | AAM | Stock | 9.99 | 10.0 | 9.98 | 9.99 | 212652.0 |
| 2024-09-20 | AAME | Stock | 1.59 | 1.65 | 1.43 | 1.43 | 16571.0 |
| 2024-09-20 | AAMI | Stock | 25.91 | 25.91 | 25.46 | 25.56 | 1001521.0 |
| 2024-09-20 | AAN-DELISTED | Stock | 10.03 | 10.04 | 10.02 | 10.02 | 1300404.0 |
| 2024-09-20 | AAOI | Stock | 14.09 | 14.15 | 13.5501 | 13.83 | 1509425.0 |
| 2024-09-20 | AAON | Stock | 101.98 | 104.73 | 101.11 | 104.05 | 1296267.0 |
| 2024-09-20 | AAP | Stock | 42.29 | 42.65 | 40.73 | 40.99 | 2759437.0 |
| 2024-09-20 | AAT | Stock | 27.2 | 27.37 | 26.88 | 26.94 | 1077596.0 |
| 2024-09-20 | AATC | Stock | 7.79 | 7.79 | 7.79 | 7.79 | 173.0 |
| 2024-09-20 | AAUAF-DELISTED | Stock | 0.04 | 0.05568 | 0.04 | 0.046 | 37649.0 |
| 2024-09-20 | AAXJ | Stock | 73.97 | 74.115 | 73.68 | 74.0 | 697695.0 |
| 2024-09-20 | AB | Stock | 35.01 | 35.235 | 34.8 | 34.95 | 216936.0 |
| 2024-09-20 | ABAT | Stock | 1.06 | 1.21 | 0.99 | 1.04 | 5989960.0 |
| 2024-09-20 | ABBV | Stock | 193.0 | 193.821 | 192.13 | 193.47 | 10765660.0 |
| 2024-09-20 | ABCB | Stock | 64.82 | 65.24 | 63.9 | 64.08 | 1219250.0 |
| 2024-09-20 | ABCL | Stock | 2.73 | 2.73 | 2.5 | 2.59 | 3217150.0 |
| 2024-09-20 | ABEO | Stock | 5.81 | 6.02 | 5.72 | 6.02 | 418982.0 |
| 2024-09-20 | ABEV | Stock | 2.37 | 2.38 | 2.3 | 2.3 | 14122559.0 |
| 2024-09-20 | ABG | Stock | 225.48 | 225.48 | 222.905 | 224.95 | 576495.0 |
| 2024-09-20 | ABLLW | Stock | 1.51 | 1.67 | 1.42 | 1.61 | 413961.0 |
| 2024-09-20 | ABLV | Stock | 0.9301 | 0.96 | 0.93 | 0.9401 | 5145.0 |
| 2024-09-20 | ABM | Stock | 51.53 | 52.34 | 51.12 | 52.08 | 3419053.0 |
| 2024-09-20 | ABNB | Stock | 129.83 | 131.95 | 129.03 | 131.18 | 11826745.0 |
| 2024-09-20 | ABOS | Stock | 2.55 | 2.56 | 2.49 | 2.5 | 305496.0 |
| 2024-09-20 | ABR | Stock | 15.08 | 15.15 | 14.9213 | 15.0 | 3421407.0 |
| 2024-09-20 | ABR.D | Stock | 19.4 | 19.44 | 19.25 | 19.31 | 27486.0 |
| 2024-09-20 | ABR.E | Stock | 19.241 | 19.75 | 19.241 | 19.625 | 6425.0 |
| 2024-09-20 | ABR.F | Stock | 19.68 | 19.68 | 19.03 | 19.12 | 104872.0 |
| 2024-09-20 | ABSI | Stock | 4.31 | 4.44 | 4.06 | 4.32 | 1624402.0 |
| 2024-09-20 | ABT | Stock | 113.75 | 114.16 | 113.2 | 113.7 | 7456886.0 |
| 2024-09-20 | ABTC | Stock | 40.1625 | 42.8325 | 37.65 | 37.65 | 3575.0 |
| 2024-09-20 | ABTS | Stock | 8.085 | 8.1 | 7.608 | 7.8 | 299.0 |
| 2024-09-20 | ABUS | Stock | 4.15 | 4.18 | 4.015 | 4.02 | 5633569.0 |
> showing 50 of 7,123 rows — these rows as CSV