PREVIEW / stock_daily / 2024-09-17
file: by_date/stock_daily/2024/2024-09-17.parquet size: 245 KB rows: 7,131 symbols: 737
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-17 | AAPL | Stock | 215.75 | 216.9 | 214.5 | 216.79 | 43955510.0 |
| 2024-09-17 | MSFT | Stock | 440.23 | 441.85 | 432.27 | 435.15 | 18620649.0 |
| 2024-09-17 | NVDA | Stock | 118.17 | 118.8 | 114.83 | 115.59 | 228795249.0 |
| 2024-09-17 | AMZN | Stock | 186.85 | 189.45 | 186.14 | 186.88 | 25600262.0 |
| 2024-09-17 | GOOGL | Stock | 159.02 | 160.55 | 158.375 | 159.32 | 20715612.0 |
| 2024-09-17 | META | Stock | 537.6 | 542.1 | 530.57 | 536.315 | 11416893.0 |
| 2024-09-17 | TSLA | Stock | 229.45 | 234.57 | 226.5533 | 227.87 | 66082342.0 |
| 2024-09-17 | TLT | Stock | 101.47 | 101.64 | 100.74 | 100.84 | 31699372.0 |
| 2024-09-17 | ES | Stock | 68.4 | 68.62 | 68.04 | 68.23 | 1524017.0 |
| 2024-09-17 | CL | Stock | 104.88 | 105.37 | 104.235 | 104.56 | 3904087.0 |
| 2024-09-17 | A | Stock | 138.66 | 139.775 | 137.39 | 138.35 | 1180504.0 |
| 2024-09-17 | AA | Stock | 34.01 | 34.24 | 33.4211 | 33.97 | 5026101.0 |
| 2024-09-17 | AACG | Stock | 0.5025 | 0.5344 | 0.5 | 0.5342 | 13502.0 |
| 2024-09-17 | AACT | Stock | 10.82 | 10.82 | 10.805 | 10.805 | 718.0 |
| 2024-09-17 | AAGR-DELISTED | Stock | 0.1242 | 0.13 | 0.1211 | 0.1251 | 160019.0 |
| 2024-09-17 | AAGRW-DELISTED | Stock | 0.0086 | 0.0089 | 0.0042 | 0.0042 | 780237.0 |
| 2024-09-17 | AAL | Stock | 10.99 | 11.26 | 10.95 | 11.17 | 38003364.0 |
| 2024-09-17 | AAM | Stock | 9.98 | 9.99 | 9.98 | 9.98 | 1564022.0 |
| 2024-09-17 | AAME | Stock | 1.67 | 1.74 | 1.6 | 1.62 | 5932.0 |
| 2024-09-17 | AAMI | Stock | 25.29 | 25.47 | 24.895 | 25.1 | 192005.0 |
| 2024-09-17 | AAN-DELISTED | Stock | 10.05 | 10.06 | 10.04 | 10.06 | 794705.0 |
| 2024-09-17 | AAOI | Stock | 13.51 | 13.67 | 13.179 | 13.58 | 1336617.0 |
| 2024-09-17 | AAON | Stock | 96.39 | 97.94 | 95.21 | 96.18 | 310943.0 |
| 2024-09-17 | AAP | Stock | 41.63 | 41.74 | 40.73 | 41.33 | 4944322.0 |
| 2024-09-17 | AAT | Stock | 27.12 | 27.3 | 26.82 | 26.99 | 238812.0 |
| 2024-09-17 | AATC | Stock | 7.52 | 7.7865 | 7.46 | 7.78 | 7920.0 |
| 2024-09-17 | AAUAF-DELISTED | Stock | 0.05 | 0.055 | 0.0456 | 0.0521 | 102713.0 |
| 2024-09-17 | AAXJ | Stock | 72.77 | 72.87 | 72.3 | 72.49 | 117969.0 |
| 2024-09-17 | AB | Stock | 34.6 | 34.65 | 34.38 | 34.52 | 229750.0 |
| 2024-09-17 | ABAT | Stock | 1.0 | 1.03 | 1.0 | 1.0 | 333465.0 |
| 2024-09-17 | ABBV | Stock | 194.8 | 196.075 | 191.82 | 193.45 | 3411697.0 |
| 2024-09-17 | ABCB | Stock | 62.39 | 63.46 | 61.9 | 62.16 | 342311.0 |
| 2024-09-17 | ABCL | Stock | 2.68 | 2.87 | 2.66 | 2.73 | 2189427.0 |
| 2024-09-17 | ABEO | Stock | 5.33 | 5.67 | 5.33 | 5.46 | 180125.0 |
| 2024-09-17 | ABEV | Stock | 2.35 | 2.38 | 2.34 | 2.37 | 22573732.0 |
| 2024-09-17 | ABG | Stock | 223.19 | 226.395 | 221.835 | 222.05 | 173829.0 |
| 2024-09-17 | ABLLW | Stock | 1.39 | 1.42 | 1.3 | 1.4 | 1987.0 |
| 2024-09-17 | ABLV | Stock | 1.14 | 1.14 | 1.01 | 1.07 | 21082.0 |
| 2024-09-17 | ABLVW | Stock | 0.0202 | 0.0202 | 0.0201 | 0.0202 | 1774.0 |
| 2024-09-17 | ABM | Stock | 52.35 | 52.35 | 50.88 | 50.96 | 379349.0 |
| 2024-09-17 | ABNB | Stock | 119.87 | 124.74 | 119.485 | 122.12 | 6293218.0 |
| 2024-09-17 | ABOS | Stock | 2.56 | 2.63 | 2.47 | 2.48 | 132242.0 |
| 2024-09-17 | ABR | Stock | 14.63 | 14.79 | 14.58 | 14.68 | 2422326.0 |
| 2024-09-17 | ABR.D | Stock | 19.1 | 19.17 | 19.0 | 19.1499 | 25552.0 |
| 2024-09-17 | ABR.E | Stock | 19.27 | 19.27 | 19.175 | 19.175 | 804.0 |
| 2024-09-17 | ABR.F | Stock | 19.39 | 19.4499 | 19.21 | 19.4 | 18789.0 |
| 2024-09-17 | ABSI | Stock | 3.9 | 4.01 | 3.85 | 3.95 | 678486.0 |
| 2024-09-17 | ABT | Stock | 117.8 | 118.54 | 117.26 | 118.13 | 4107085.0 |
| 2024-09-17 | ABTC | Stock | 39.7575 | 42.255 | 38.2575 | 39.0 | 1420.1333333333332 |
| 2024-09-17 | ABTS | Stock | 7.56 | 8.07 | 7.2 | 7.8015 | 456.0 |
> showing 50 of 7,131 rows — these rows as CSV