PREVIEW / stock_daily / 2024-01-26
file: by_date/stock_daily/2024/2024-01-26.parquet size: 234 KB rows: 7,304 symbols: 1,170
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-26 | AAPL | Stock | 194.27 | 194.76 | 191.94 | 192.42 | 44594000.0 |
| 2024-01-26 | MSFT | Stock | 404.37 | 406.17 | 402.43 | 403.93 | 17803300.0 |
| 2024-01-26 | NVDA | Stock | 60.96 | 61.783 | 60.573 | 61.031 | 390309000.0 |
| 2024-01-26 | AMZN | Stock | 158.42 | 160.72 | 157.91 | 159.12 | 51047400.0 |
| 2024-01-26 | GOOGL | Stock | 151.1 | 152.535 | 151.01 | 152.185 | 26115494.0 |
| 2024-01-26 | META | Stock | 394.35 | 396.79 | 391.59 | 394.14 | 13163700.0 |
| 2024-01-26 | TSLA | Stock | 185.5 | 186.78 | 182.1 | 183.25 | 107343200.0 |
| 2024-01-26 | TLT | Stock | 93.93 | 94.07 | 93.485 | 93.78 | 29276865.0 |
| 2024-01-26 | ES | Stock | 55.22 | 56.14 | 54.77 | 55.12 | 4415800.0 |
| 2024-01-26 | CL | Stock | 81.52 | 83.62 | 81.08 | 82.83 | 8668700.0 |
| 2024-01-26 | A | Stock | 133.71 | 134.23 | 130.64 | 130.99 | 1319800.0 |
| 2024-01-26 | AA | Stock | 30.22 | 30.7 | 29.871 | 30.61 | 5123900.0 |
| 2024-01-26 | AACG | Stock | 1.08 | 1.11 | 1.01 | 1.08 | 7200.0 |
| 2024-01-26 | AACIW-DELISTED | Stock | 0.0202 | 0.025 | 0.0202 | 0.025 | 108580.0 |
| 2024-01-26 | AACT | Stock | 10.49 | 10.49 | 10.49 | 10.49 | 25100.0 |
| 2024-01-26 | AAGR-DELISTED | Stock | 0.93 | 0.9674 | 0.9 | 0.94 | 62734.0 |
| 2024-01-26 | AAGRW-DELISTED | Stock | 0.0159 | 0.0159 | 0.0157 | 0.0157 | 10400.0 |
| 2024-01-26 | AAL | Stock | 15.55 | 15.84 | 15.0 | 15.13 | 45618600.0 |
| 2024-01-26 | AAMC-DELISTED | Stock | 5.03 | 5.16 | 4.89 | 4.89 | 11000.0 |
| 2024-01-26 | AAME | Stock | 2.65 | 2.73 | 2.56 | 2.62 | 2400.0 |
| 2024-01-26 | AAMI | Stock | 22.19 | 22.55 | 22.14 | 22.2 | 363600.0 |
| 2024-01-26 | AAN-DELISTED | Stock | 10.8 | 10.925 | 10.73 | 10.73 | 195500.0 |
| 2024-01-26 | AAOI | Stock | 16.22 | 16.35 | 14.88 | 14.99 | 2258300.0 |
| 2024-01-26 | AAON | Stock | 70.82 | 70.83 | 69.65 | 69.94 | 274900.0 |
| 2024-01-26 | AAP | Stock | 66.66 | 67.36 | 65.83 | 66.25 | 781800.0 |
| 2024-01-26 | AAT | Stock | 23.92 | 23.92 | 23.49 | 23.6 | 252400.0 |
| 2024-01-26 | AATC | Stock | 8.15 | 8.99 | 8.15 | 8.57 | 70323.0 |
| 2024-01-26 | AAU-DELISTED | Stock | 0.135 | 0.1351 | 0.135 | 0.1351 | 79746.0 |
| 2024-01-26 | AAUAF-DELISTED | Stock | 0.135 | 0.1351 | 0.135 | 0.1351 | 82195.0 |
| 2024-01-26 | AAXJ | Stock | 63.98 | 64.24 | 63.93 | 64.04 | 338198.0 |
| 2024-01-26 | AB | Stock | 34.26 | 34.47 | 33.64 | 33.75 | 290700.0 |
| 2024-01-26 | ABAT | Stock | 2.75 | 2.91 | 2.7066 | 2.84 | 358377.0 |
| 2024-01-26 | ABBNY-DELISTED | Stock | 42.48 | 42.57 | 42.4 | 42.54 | 204819.0 |
| 2024-01-26 | ABBV | Stock | 165.27 | 165.86 | 163.5 | 164.4 | 4654300.0 |
| 2024-01-26 | ABCB | Stock | 53.58 | 53.99 | 51.57 | 52.74 | 478700.0 |
| 2024-01-26 | ABCL | Stock | 5.37 | 5.48 | 5.26 | 5.32 | 1128200.0 |
| 2024-01-26 | ABEO | Stock | 4.75 | 4.77 | 4.56 | 4.69 | 112800.0 |
| 2024-01-26 | ABEV | Stock | 2.67 | 2.69 | 2.67 | 2.68 | 3738000.0 |
| 2024-01-26 | ABG | Stock | 214.17 | 215.35 | 211.38 | 213.92 | 140400.0 |
| 2024-01-26 | ABLLW | Stock | 0.909 | 0.9284 | 0.87 | 0.9018 | 73260.0 |
| 2024-01-26 | ABLV | Stock | 2.62 | 2.63 | 2.53 | 2.53 | 1100.0 |
| 2024-01-26 | ABM | Stock | 42.2 | 42.32 | 41.89 | 42.08 | 353500.0 |
| 2024-01-26 | ABNB | Stock | 142.11 | 151.53 | 141.49 | 149.62 | 11342600.0 |
| 2024-01-26 | ABOS | Stock | 3.27 | 3.32 | 3.215 | 3.24 | 341600.0 |
| 2024-01-26 | ABR | Stock | 13.75 | 14.01 | 13.71 | 13.77 | 3736000.0 |
| 2024-01-26 | ABR.D | Stock | 17.79 | 17.9 | 17.72 | 17.88 | 8094.0 |
| 2024-01-26 | ABR.E | Stock | 17.66 | 17.8 | 17.65 | 17.8 | 3578.0 |
| 2024-01-26 | ABR.F | Stock | 18.8 | 18.95 | 18.67 | 18.7 | 53188.0 |
| 2024-01-26 | ABSI | Stock | 3.65 | 3.84 | 3.53 | 3.71 | 1051800.0 |
| 2024-01-26 | ABT | Stock | 113.23 | 113.41 | 111.54 | 112.01 | 5176600.0 |
> showing 50 of 7,304 rows — these rows as CSV