PREVIEW / stock_daily / 2024-12-09
file: by_date/stock_daily/2024/2024-12-09.parquet size: 246 KB rows: 7,176 symbols: 618
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-12-09 | AAPL | Stock | 241.83 | 247.24 | 241.75 | 246.75 | 40870197.0 |
| 2024-12-09 | MSFT | Stock | 442.6 | 448.33 | 440.5 | 446.02 | 17074557.0 |
| 2024-12-09 | NVDA | Stock | 138.97 | 139.95 | 137.13 | 138.81 | 180383600.0 |
| 2024-12-09 | AMZN | Stock | 227.21 | 230.08 | 225.67 | 226.09 | 43556324.0 |
| 2024-12-09 | GOOGL | Stock | 173.96 | 176.26 | 173.65 | 175.37 | 25389631.0 |
| 2024-12-09 | META | Stock | 623.925 | 626.4 | 606.1701 | 613.57 | 10650790.0 |
| 2024-12-09 | TSLA | Stock | 397.61 | 404.8 | 378.01 | 389.79 | 95025291.0 |
| 2024-12-09 | TLT | Stock | 93.99 | 94.04 | 93.465 | 93.52 | 30509582.0 |
| 2024-12-09 | ES | Stock | 60.0 | 61.17 | 59.66 | 60.25 | 2158034.0 |
| 2024-12-09 | CL | Stock | 94.05 | 94.5 | 92.8 | 92.94 | 4526774.0 |
| 2024-12-09 | A | Stock | 140.81 | 144.57 | 140.44 | 144.0 | 1405711.0 |
| 2024-12-09 | AA | Stock | 44.11 | 44.735 | 41.87 | 41.99 | 5813597.0 |
| 2024-12-09 | AACG | Stock | 0.88 | 0.88 | 0.8201 | 0.8201 | 9824.0 |
| 2024-12-09 | AACT | Stock | 10.95 | 10.95 | 10.92 | 10.93 | 4594.0 |
| 2024-12-09 | AAGR-DELISTED | Stock | 0.008 | 0.008 | 0.008 | 0.008 | 101.0 |
| 2024-12-09 | AAGRW-DELISTED | Stock | 0.0 | 0.0 | 0.0 | 0.0 | 140.0 |
| 2024-12-09 | AAL | Stock | 17.52 | 17.52 | 17.01 | 17.16 | 28120705.0 |
| 2024-12-09 | AAM | Stock | 10.08 | 10.08 | 10.07 | 10.075 | 5792.0 |
| 2024-12-09 | AAME | Stock | 1.5175 | 1.54 | 1.486 | 1.53 | 2216.0 |
| 2024-12-09 | AAMI | Stock | 31.01 | 31.13 | 30.56 | 30.59 | 128743.0 |
| 2024-12-09 | AAOI | Stock | 38.59 | 39.39 | 34.9136 | 36.16 | 3653860.0 |
| 2024-12-09 | AAON | Stock | 138.25 | 138.25 | 128.84 | 129.06 | 477860.0 |
| 2024-12-09 | AAP | Stock | 45.45 | 48.95 | 45.27 | 47.44 | 3991269.0 |
| 2024-12-09 | AAT | Stock | 27.89 | 28.41 | 27.675 | 28.0 | 253957.0 |
| 2024-12-09 | AATC | Stock | 7.9625 | 7.9625 | 7.9625 | 7.9625 | 282.0 |
| 2024-12-09 | AAUAF-DELISTED | Stock | 0.033 | 0.0393 | 0.0306 | 0.03682 | 66838.0 |
| 2024-12-09 | AAXJ | Stock | 76.89 | 77.51 | 76.8 | 76.86 | 517399.0 |
| 2024-12-09 | AB | Stock | 34.58 | 36.42 | 34.5309 | 36.32 | 864580.0 |
| 2024-12-09 | ABAT | Stock | 0.8883 | 0.93 | 0.8501 | 0.9079 | 507706.0 |
| 2024-12-09 | ABBV | Stock | 175.59 | 178.13 | 174.38 | 176.57 | 3997449.0 |
| 2024-12-09 | ABCB | Stock | 69.8 | 69.87 | 67.76 | 67.89 | 241096.0 |
| 2024-12-09 | ABCL | Stock | 3.03 | 3.085 | 2.95 | 2.95 | 2717235.0 |
| 2024-12-09 | ABEO | Stock | 6.05 | 6.055 | 5.8597 | 5.92 | 163230.0 |
| 2024-12-09 | ABEV | Stock | 2.29 | 2.33 | 2.29 | 2.3 | 21889910.0 |
| 2024-12-09 | ABG | Stock | 261.59 | 261.7 | 256.8 | 257.26 | 123153.0 |
| 2024-12-09 | ABLLW | Stock | 1.09 | 1.16 | 1.09 | 1.12 | 13916.0 |
| 2024-12-09 | ABLV | Stock | 0.71 | 0.75 | 0.68 | 0.71 | 16599.0 |
| 2024-12-09 | ABM | Stock | 57.68 | 57.75 | 56.81 | 56.83 | 353603.0 |
| 2024-12-09 | ABNB | Stock | 137.0 | 138.97 | 136.59 | 137.27 | 3508118.0 |
| 2024-12-09 | ABOS | Stock | 2.15 | 2.29 | 2.15 | 2.25 | 257390.0 |
| 2024-12-09 | ABPWW | Stock | 0.0445 | 0.0445 | 0.0445 | 0.0445 | 1058.0 |
| 2024-12-09 | ABR | Stock | 14.46 | 14.53 | 14.22 | 14.29 | 1549814.0 |
| 2024-12-09 | ABR.D | Stock | 19.05 | 19.4855 | 19.05 | 19.29 | 15264.0 |
| 2024-12-09 | ABR.E | Stock | 18.6 | 18.75 | 18.55 | 18.6 | 52538.0 |
| 2024-12-09 | ABR.F | Stock | 21.32 | 21.78 | 21.31 | 21.78 | 20933.0 |
| 2024-12-09 | ABSI | Stock | 3.25 | 3.47 | 3.19 | 3.21 | 1848033.0 |
| 2024-12-09 | ABT | Stock | 115.67 | 115.87 | 113.85 | 114.9 | 4537705.0 |
| 2024-12-09 | ABTC | Stock | 50.6625 | 50.8125 | 42.66 | 44.145 | 13306.733333333334 |
| 2024-12-09 | ABTS | Stock | 10.17 | 10.2 | 9.45 | 9.603 | 4618.0 |
| 2024-12-09 | ABUS | Stock | 3.69 | 3.73 | 3.65 | 3.68 | 479021.0 |
> showing 50 of 7,176 rows — these rows as CSV