PREVIEW / stock_daily / 2024-01-29
file: by_date/stock_daily/2024/2024-01-29.parquet size: 235 KB rows: 7,327 symbols: 1,174
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-01-29 | AAPL | Stock | 192.01 | 192.2 | 189.58 | 191.73 | 47145600.0 |
| 2024-01-29 | MSFT | Stock | 406.06 | 409.98 | 404.33 | 409.72 | 24510200.0 |
| 2024-01-29 | NVDA | Stock | 61.232 | 62.489 | 60.907 | 62.465 | 348733000.0 |
| 2024-01-29 | AMZN | Stock | 159.34 | 161.29 | 158.9 | 161.26 | 45270400.0 |
| 2024-01-29 | GOOGL | Stock | 152.06 | 153.78 | 151.43 | 153.51 | 27784259.0 |
| 2024-01-29 | META | Stock | 394.99 | 402.93 | 393.1 | 401.02 | 18742400.0 |
| 2024-01-29 | TSLA | Stock | 185.63 | 191.48 | 183.67 | 190.93 | 125013100.0 |
| 2024-01-29 | TLT | Stock | 94.31 | 95.165 | 94.12 | 94.86 | 38243550.0 |
| 2024-01-29 | ES | Stock | 54.98 | 55.56 | 54.51 | 55.16 | 2756400.0 |
| 2024-01-29 | CL | Stock | 83.3 | 84.0 | 83.1 | 83.96 | 6426000.0 |
| 2024-01-29 | A | Stock | 131.75 | 132.9 | 131.28 | 132.83 | 1407200.0 |
| 2024-01-29 | AA | Stock | 30.46 | 30.97 | 29.689 | 30.91 | 4649100.0 |
| 2024-01-29 | AACG | Stock | 1.1 | 1.11 | 1.07 | 1.1 | 4200.0 |
| 2024-01-29 | AACT | Stock | 10.5 | 10.5 | 10.49 | 10.5 | 1900.0 |
| 2024-01-29 | AAGR-DELISTED | Stock | 0.94 | 1.09 | 0.93 | 1.09 | 162743.0 |
| 2024-01-29 | AAGRW-DELISTED | Stock | 0.0228 | 0.0228 | 0.0158 | 0.0158 | 287.0 |
| 2024-01-29 | AAL | Stock | 15.37 | 15.39 | 14.86 | 14.94 | 36835300.0 |
| 2024-01-29 | AAMC-DELISTED | Stock | 4.89 | 5.09 | 4.732 | 5.07 | 4900.0 |
| 2024-01-29 | AAME | Stock | 2.58 | 2.68 | 2.52 | 2.63 | 8100.0 |
| 2024-01-29 | AAMI | Stock | 22.17 | 22.63 | 22.17 | 22.62 | 277900.0 |
| 2024-01-29 | AAN-DELISTED | Stock | 10.81 | 10.86 | 10.57 | 10.79 | 182800.0 |
| 2024-01-29 | AAOI | Stock | 15.03 | 16.03 | 14.8 | 15.965 | 2724600.0 |
| 2024-01-29 | AAON | Stock | 69.9 | 71.03 | 69.54 | 71.01 | 470800.0 |
| 2024-01-29 | AAP | Stock | 66.25 | 68.02 | 65.4 | 66.96 | 1291000.0 |
| 2024-01-29 | AAT | Stock | 23.57 | 23.89 | 23.43 | 23.8 | 234900.0 |
| 2024-01-29 | AATC | Stock | 8.81 | 9.3299 | 8.8 | 9.05 | 138884.0 |
| 2024-01-29 | AAU-DELISTED | Stock | 0.1351 | 0.1351 | 0.135 | 0.1351 | 170805.0 |
| 2024-01-29 | AAUAF-DELISTED | Stock | 0.1351 | 0.1351 | 0.135 | 0.1351 | 170883.0 |
| 2024-01-29 | AAXJ | Stock | 64.14 | 64.3144 | 63.72 | 64.08 | 789441.0 |
| 2024-01-29 | AB | Stock | 33.75 | 33.85 | 32.92 | 33.32 | 462500.0 |
| 2024-01-29 | ABAT | Stock | 2.9 | 2.99 | 2.75 | 2.89 | 520856.0 |
| 2024-01-29 | ABBNY-DELISTED | Stock | 42.49 | 43.0 | 42.49 | 42.95 | 174500.0 |
| 2024-01-29 | ABBV | Stock | 165.85 | 166.76 | 163.68 | 163.91 | 4704100.0 |
| 2024-01-29 | ABCB | Stock | 52.86 | 53.19 | 51.94 | 52.62 | 418500.0 |
| 2024-01-29 | ABCL | Stock | 5.35 | 5.62 | 5.235 | 5.59 | 1308800.0 |
| 2024-01-29 | ABEO | Stock | 4.65 | 4.95 | 4.65 | 4.85 | 65600.0 |
| 2024-01-29 | ABEV | Stock | 2.67 | 2.67 | 2.64 | 2.67 | 5234600.0 |
| 2024-01-29 | ABG | Stock | 213.92 | 220.07 | 212.93 | 219.68 | 119000.0 |
| 2024-01-29 | ABLLW | Stock | 0.925 | 0.9251 | 0.89 | 0.89 | 8621.0 |
| 2024-01-29 | ABLV | Stock | 2.629 | 2.79 | 2.56 | 2.765 | 161100.0 |
| 2024-01-29 | ABM | Stock | 42.15 | 42.15 | 41.39 | 41.85 | 305400.0 |
| 2024-01-29 | ABNB | Stock | 150.0 | 153.38 | 148.54 | 152.7 | 5316300.0 |
| 2024-01-29 | ABOS | Stock | 3.22 | 3.43 | 3.15 | 3.42 | 320400.0 |
| 2024-01-29 | ABR | Stock | 13.8 | 14.29 | 13.73 | 14.25 | 4394500.0 |
| 2024-01-29 | ABR.D | Stock | 17.87 | 18.03 | 17.75 | 18.01 | 23954.0 |
| 2024-01-29 | ABR.E | Stock | 17.8 | 18.16 | 17.7999 | 17.85 | 7147.0 |
| 2024-01-29 | ABR.F | Stock | 18.71 | 18.97 | 18.68 | 18.78 | 39754.0 |
| 2024-01-29 | ABSI | Stock | 3.72 | 4.01 | 3.58 | 3.98 | 1387500.0 |
| 2024-01-29 | ABT | Stock | 112.15 | 113.47 | 112.03 | 113.45 | 6480600.0 |
| 2024-01-29 | ABTC | Stock | 459.0 | 585.0 | 459.0 | 553.5 | 222.26666666666665 |
> showing 50 of 7,327 rows — these rows as CSV