PREVIEW / stock_daily / 2024-11-18
file: by_date/stock_daily/2024/2024-11-18.parquet size: 245 KB rows: 7,141 symbols: 662
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-18 | AAPL | Stock | 225.25 | 229.74 | 225.17 | 228.02 | 41005077.0 |
| 2024-11-18 | MSFT | Stock | 414.87 | 418.4037 | 412.1 | 415.76 | 22559770.0 |
| 2024-11-18 | NVDA | Stock | 139.5 | 141.55 | 137.15 | 140.15 | 215732705.0 |
| 2024-11-18 | AMZN | Stock | 204.15 | 204.67 | 200.95 | 201.7 | 33471055.0 |
| 2024-11-18 | GOOGL | Stock | 173.42 | 175.438 | 172.9 | 175.3 | 20206613.0 |
| 2024-11-18 | META | Stock | 557.04 | 559.9 | 550.09 | 554.4 | 14094392.0 |
| 2024-11-18 | TSLA | Stock | 340.73 | 348.5499 | 330.01 | 338.74 | 122876211.0 |
| 2024-11-18 | TLT | Stock | 89.66 | 90.59 | 89.424 | 90.24 | 36058665.0 |
| 2024-11-18 | ES | Stock | 61.63 | 62.265 | 61.47 | 62.07 | 1630244.0 |
| 2024-11-18 | CL | Stock | 92.95 | 95.125 | 92.94 | 94.62 | 4337389.0 |
| 2024-11-18 | A | Stock | 126.92 | 128.09 | 126.01 | 126.92 | 1262414.0 |
| 2024-11-18 | AA | Stock | 43.96 | 44.2 | 42.83 | 43.98 | 3824760.0 |
| 2024-11-18 | AACG | Stock | 1.01 | 1.03 | 0.9909 | 1.0213 | 18357.0 |
| 2024-11-18 | AACT | Stock | 10.89 | 10.89 | 10.88 | 10.89 | 6654.0 |
| 2024-11-18 | AAGR-DELISTED | Stock | 0.0002 | 0.0005 | 0.0002 | 0.0005 | 4326.0 |
| 2024-11-18 | AAL | Stock | 14.39 | 14.435 | 14.03 | 14.29 | 18666358.0 |
| 2024-11-18 | AAM | Stock | 10.05 | 10.06 | 10.04 | 10.05 | 288999.0 |
| 2024-11-18 | AAME | Stock | 1.6 | 1.71 | 1.6 | 1.7 | 2865.0 |
| 2024-11-18 | AAMI | Stock | 29.7 | 29.99 | 29.42 | 29.84 | 156125.0 |
| 2024-11-18 | AAOI | Stock | 26.75 | 29.38 | 26.27 | 27.32 | 3329101.0 |
| 2024-11-18 | AAON | Stock | 135.01 | 135.63 | 130.88 | 131.34 | 567600.0 |
| 2024-11-18 | AAP | Stock | 37.56 | 40.19 | 37.55 | 40.09 | 3303412.0 |
| 2024-11-18 | AAT | Stock | 27.0 | 27.345 | 26.96 | 27.07 | 166597.0 |
| 2024-11-18 | AATC | Stock | 7.925 | 7.925 | 7.9 | 7.9 | 669.0 |
| 2024-11-18 | AAUAF-DELISTED | Stock | 0.04 | 0.0411 | 0.035 | 0.035 | 535394.0 |
| 2024-11-18 | AAXJ | Stock | 73.82 | 74.345 | 73.78 | 74.32 | 210506.0 |
| 2024-11-18 | AB | Stock | 36.73 | 37.1 | 36.616 | 36.64 | 316533.0 |
| 2024-11-18 | ABAT | Stock | 0.86 | 0.9199 | 0.8 | 0.8 | 615437.0 |
| 2024-11-18 | ABBV | Stock | 165.62 | 166.74 | 164.8 | 166.28 | 6729142.0 |
| 2024-11-18 | ABCB | Stock | 69.63 | 69.91 | 68.75 | 68.78 | 204640.0 |
| 2024-11-18 | ABCL | Stock | 2.66 | 2.71 | 2.59 | 2.65 | 2495525.0 |
| 2024-11-18 | ABEO | Stock | 5.82 | 5.91 | 5.63121 | 5.855 | 736146.0 |
| 2024-11-18 | ABEV | Stock | 2.21 | 2.23 | 2.16 | 2.18 | 24225341.0 |
| 2024-11-18 | ABG | Stock | 257.99 | 260.0 | 255.82 | 255.9 | 84526.0 |
| 2024-11-18 | ABLLW | Stock | 1.2 | 1.3285 | 1.19 | 1.27 | 8663.0 |
| 2024-11-18 | ABLV | Stock | 0.878 | 0.925 | 0.87 | 0.87 | 9088.0 |
| 2024-11-18 | ABM | Stock | 55.17 | 55.51 | 54.8 | 54.87 | 226590.0 |
| 2024-11-18 | ABNB | Stock | 132.56 | 133.4499 | 131.58 | 132.19 | 4190006.0 |
| 2024-11-18 | ABOS | Stock | 2.4 | 2.455 | 2.24 | 2.24 | 222786.0 |
| 2024-11-18 | ABPWW | Stock | 0.065 | 0.065 | 0.0501 | 0.0501 | 1223.0 |
| 2024-11-18 | ABR | Stock | 14.53 | 14.82 | 14.45 | 14.78 | 5039432.0 |
| 2024-11-18 | ABR.D | Stock | 18.72 | 18.95 | 18.58 | 18.58 | 18590.0 |
| 2024-11-18 | ABR.E | Stock | 19.15 | 19.265 | 18.6 | 19.05 | 3551.0 |
| 2024-11-18 | ABR.F | Stock | 20.25 | 20.5959 | 20.25 | 20.3128 | 37022.0 |
| 2024-11-18 | ABSI | Stock | 2.9 | 2.9385 | 2.76 | 2.77 | 958990.0 |
| 2024-11-18 | ABT | Stock | 115.575 | 117.94 | 115.51 | 117.36 | 4817246.0 |
| 2024-11-18 | ABTC | Stock | 49.5 | 52.6875 | 46.5375 | 50.6325 | 12493.866666666667 |
| 2024-11-18 | ABTS | Stock | 8.82 | 9.15 | 8.25 | 8.64 | 2458.0 |
| 2024-11-18 | ABUS | Stock | 3.64 | 3.68 | 3.49 | 3.52 | 1050460.0 |
| 2024-11-18 | ABVC | Stock | 0.5 | 0.55 | 0.5 | 0.5104 | 87639.0 |
> showing 50 of 7,141 rows — these rows as CSV