PREVIEW / stock_daily / 2024-11-14
file: by_date/stock_daily/2024/2024-11-14.parquet size: 245 KB rows: 7,127 symbols: 642
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-11-14 | AAPL | Stock | 225.02 | 228.87 | 225.0 | 228.22 | 41667159.0 |
| 2024-11-14 | MSFT | Stock | 425.0 | 428.17 | 420.0 | 426.89 | 27191932.0 |
| 2024-11-14 | NVDA | Stock | 147.64 | 149.0 | 145.55 | 146.76 | 187554409.0 |
| 2024-11-14 | AMZN | Stock | 214.16 | 215.9 | 210.88 | 211.48 | 40626518.0 |
| 2024-11-14 | GOOGL | Stock | 178.28 | 178.82 | 174.3218 | 175.58 | 31007457.0 |
| 2024-11-14 | META | Stock | 577.0 | 580.76 | 573.01 | 577.16 | 10465073.0 |
| 2024-11-14 | TSLA | Stock | 327.69 | 329.98 | 310.37 | 311.18 | 119252342.0 |
| 2024-11-14 | TLT | Stock | 90.56 | 91.025 | 90.27 | 90.32 | 53328347.0 |
| 2024-11-14 | ES | Stock | 60.75 | 61.92 | 60.66 | 61.48 | 1662736.0 |
| 2024-11-14 | CL | Stock | 91.01 | 91.63 | 90.79 | 91.45 | 4579593.0 |
| 2024-11-14 | A | Stock | 133.69 | 134.35 | 130.16 | 130.22 | 1931286.0 |
| 2024-11-14 | AA | Stock | 41.1 | 42.08 | 40.96 | 41.21 | 4467393.0 |
| 2024-11-14 | AACG | Stock | 1.03 | 1.03 | 1.005 | 1.02 | 20197.0 |
| 2024-11-14 | AACT | Stock | 10.88 | 10.9 | 10.88 | 10.9 | 123062.0 |
| 2024-11-14 | AAGR-DELISTED | Stock | 0.0001 | 0.0001 | 0.0001 | 0.0001 | 8958.0 |
| 2024-11-14 | AAGRW-DELISTED | Stock | 0.0 | 0.0 | 0.0 | 0.0 | 348.0 |
| 2024-11-14 | AAL | Stock | 14.22 | 14.665 | 14.175 | 14.26 | 32984768.0 |
| 2024-11-14 | AAM | Stock | 10.05 | 10.06 | 10.05 | 10.06 | 105094.0 |
| 2024-11-14 | AAME | Stock | 1.72 | 1.72 | 1.7 | 1.7 | 1309.0 |
| 2024-11-14 | AAMI | Stock | 29.54 | 29.965 | 29.315 | 29.66 | 191796.0 |
| 2024-11-14 | AAOI | Stock | 27.47 | 29.17 | 27.1 | 28.15 | 4166100.0 |
| 2024-11-14 | AAON | Stock | 133.71 | 135.33 | 130.89 | 133.18 | 463615.0 |
| 2024-11-14 | AAP | Stock | 43.49 | 45.4531 | 41.09 | 41.2 | 8155468.0 |
| 2024-11-14 | AAT | Stock | 27.45 | 27.63 | 27.115 | 27.24 | 175621.0 |
| 2024-11-14 | AATC | Stock | 7.97 | 7.99 | 7.97 | 7.99 | 883.0 |
| 2024-11-14 | AAUAF-DELISTED | Stock | 0.036 | 0.03935 | 0.03 | 0.03935 | 100077.0 |
| 2024-11-14 | AAXJ | Stock | 73.87 | 74.01 | 73.43 | 73.48 | 342187.0 |
| 2024-11-14 | AB | Stock | 36.05 | 37.065 | 35.82 | 37.03 | 406251.0 |
| 2024-11-14 | ABAT | Stock | 0.9901 | 1.0 | 0.95 | 0.9619 | 391065.0 |
| 2024-11-14 | ABBV | Stock | 170.0 | 171.62 | 168.59 | 169.63 | 6854261.0 |
| 2024-11-14 | ABCB | Stock | 70.07 | 70.385 | 69.15 | 69.62 | 311060.0 |
| 2024-11-14 | ABCL | Stock | 2.96 | 2.97 | 2.76 | 2.76 | 2753022.0 |
| 2024-11-14 | ABEO | Stock | 6.3 | 6.3 | 5.92 | 5.95 | 411834.0 |
| 2024-11-14 | ABEV | Stock | 2.23 | 2.24 | 2.2 | 2.21 | 25294703.0 |
| 2024-11-14 | ABG | Stock | 265.13 | 267.92 | 260.12 | 261.62 | 122600.0 |
| 2024-11-14 | ABLLW | Stock | 1.3 | 1.4 | 1.28 | 1.29 | 21141.0 |
| 2024-11-14 | ABLV | Stock | 0.85 | 0.89 | 0.85 | 0.88 | 5809.0 |
| 2024-11-14 | ABM | Stock | 56.82 | 56.9 | 55.46 | 55.58 | 160134.0 |
| 2024-11-14 | ABNB | Stock | 133.97 | 136.66 | 133.15 | 134.56 | 4715780.0 |
| 2024-11-14 | ABOS | Stock | 2.57 | 2.66 | 2.41 | 2.61 | 194983.0 |
| 2024-11-14 | ABPWW | Stock | 0.05 | 0.0768 | 0.05 | 0.06 | 405100.0 |
| 2024-11-14 | ABR | Stock | 15.38 | 15.4299 | 15.065 | 15.1 | 2844985.0 |
| 2024-11-14 | ABR.D | Stock | 18.98 | 19.0038 | 18.6 | 18.64 | 19265.0 |
| 2024-11-14 | ABR.E | Stock | 19.52 | 19.55 | 19.46 | 19.49 | 2973.0 |
| 2024-11-14 | ABR.F | Stock | 20.27 | 21.0 | 20.15 | 20.15 | 37971.0 |
| 2024-11-14 | ABSI | Stock | 3.2 | 3.2 | 2.95 | 3.015 | 3283062.0 |
| 2024-11-14 | ABT | Stock | 115.98 | 116.09 | 114.93 | 115.03 | 3486524.0 |
| 2024-11-14 | ABTC | Stock | 57.75 | 61.125 | 46.5075 | 51.375 | 27974.666666666668 |
| 2024-11-14 | ABTS | Stock | 9.3915 | 10.35 | 7.662 | 7.98 | 13926.0 |
| 2024-11-14 | ABUS | Stock | 3.66 | 3.81 | 3.625 | 3.63 | 1107512.0 |
> showing 50 of 7,127 rows — these rows as CSV