PREVIEW / stock_daily / 2024-01-19
file: by_date/stock_daily/2024/2024-01-19.parquet size: 233 KB rows: 7,266 symbols: 1,166
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-19 | AAPL | Stock | 189.33 | 191.95 | 188.82 | 191.56 | 68741000.0 |
| 2024-01-19 | MSFT | Stock | 395.76 | 398.67 | 393.5 | 398.67 | 29272000.0 |
| 2024-01-19 | NVDA | Stock | 57.989 | 59.5 | 57.225 | 59.491 | 543501000.0 |
| 2024-01-19 | AMZN | Stock | 153.83 | 155.76 | 152.74 | 155.34 | 51033700.0 |
| 2024-01-19 | GOOGL | Stock | 144.74 | 146.45 | 144.38 | 146.38 | 34271867.0 |
| 2024-01-19 | META | Stock | 379.0 | 384.36 | 377.97 | 383.45 | 21470100.0 |
| 2024-01-19 | TSLA | Stock | 209.99 | 213.19 | 207.56 | 212.19 | 102095800.0 |
| 2024-01-19 | TLT | Stock | 93.71 | 94.165 | 93.26 | 94.09 | 47030912.0 |
| 2024-01-19 | ES | Stock | 54.0 | 54.07 | 53.01 | 53.41 | 5158000.0 |
| 2024-01-19 | CL | Stock | 80.23 | 80.59 | 80.04 | 80.38 | 5147500.0 |
| 2024-01-19 | A | Stock | 130.17 | 131.99 | 129.21 | 131.22 | 1523300.0 |
| 2024-01-19 | AA | Stock | 26.73 | 27.38 | 26.345 | 27.36 | 5999900.0 |
| 2024-01-19 | AACG | Stock | 1.05 | 1.11 | 1.05 | 1.09 | 2300.0 |
| 2024-01-19 | AACT | Stock | 10.5 | 10.5 | 10.46 | 10.47 | 103700.0 |
| 2024-01-19 | AAGR-DELISTED | Stock | 0.8396 | 0.86 | 0.8101 | 0.845 | 44441.0 |
| 2024-01-19 | AAL | Stock | 13.83 | 13.83 | 13.41 | 13.66 | 38757300.0 |
| 2024-01-19 | AAMC-DELISTED | Stock | 5.068 | 5.08 | 4.59 | 4.79 | 44500.0 |
| 2024-01-19 | AAME | Stock | 2.62 | 2.66 | 2.53 | 2.63 | 8100.0 |
| 2024-01-19 | AAMI | Stock | 19.91 | 20.605 | 19.845 | 20.58 | 663500.0 |
| 2024-01-19 | AAN-DELISTED | Stock | 10.32 | 10.32 | 10.08 | 10.24 | 142600.0 |
| 2024-01-19 | AAOI | Stock | 16.61 | 16.798 | 15.02 | 15.81 | 3511500.0 |
| 2024-01-19 | AAON | Stock | 70.79 | 70.81 | 69.6 | 70.32 | 406000.0 |
| 2024-01-19 | AAP | Stock | 62.49 | 63.85 | 60.89 | 63.75 | 1473900.0 |
| 2024-01-19 | AAT | Stock | 22.39 | 23.03 | 22.03 | 23.0 | 454200.0 |
| 2024-01-19 | AATC | Stock | 7.68 | 7.74 | 7.596 | 7.61 | 20404.0 |
| 2024-01-19 | AAU-DELISTED | Stock | 0.135 | 0.1359 | 0.135 | 0.1351 | 110244.0 |
| 2024-01-19 | AAUAF-DELISTED | Stock | 0.135 | 0.1359 | 0.135 | 0.1351 | 106225.0 |
| 2024-01-19 | AAXJ | Stock | 62.7 | 63.235 | 62.38 | 63.17 | 646351.0 |
| 2024-01-19 | AB | Stock | 32.77 | 33.61 | 32.56 | 33.57 | 229800.0 |
| 2024-01-19 | ABAT | Stock | 2.97 | 2.97 | 2.6 | 2.605 | 729065.0 |
| 2024-01-19 | ABBNY-DELISTED | Stock | 40.69 | 40.8 | 40.3918 | 40.8 | 222196.0 |
| 2024-01-19 | ABBV | Stock | 163.91 | 164.87 | 162.6 | 164.77 | 5863000.0 |
| 2024-01-19 | ABCB | Stock | 50.27 | 51.57 | 49.42 | 51.54 | 316700.0 |
| 2024-01-19 | ABCL | Stock | 5.19 | 5.325 | 5.06 | 5.24 | 1182400.0 |
| 2024-01-19 | ABEO | Stock | 4.94 | 5.03 | 4.88 | 5.0 | 79100.0 |
| 2024-01-19 | ABEV | Stock | 2.7 | 2.71 | 2.67 | 2.7 | 6367300.0 |
| 2024-01-19 | ABG | Stock | 204.25 | 206.79 | 201.11 | 204.46 | 102200.0 |
| 2024-01-19 | ABLLW | Stock | 0.93 | 1.05 | 0.91 | 0.985 | 162030.0 |
| 2024-01-19 | ABLV | Stock | 2.56 | 2.83 | 2.56 | 2.71 | 147200.0 |
| 2024-01-19 | ABLVW | Stock | 0.0446 | 0.0449 | 0.0446 | 0.0449 | 1316.0 |
| 2024-01-19 | ABM | Stock | 42.05 | 42.12 | 40.99 | 41.74 | 245400.0 |
| 2024-01-19 | ABNB | Stock | 138.6 | 140.285 | 136.32 | 139.93 | 4085300.0 |
| 2024-01-19 | ABOS | Stock | 3.65 | 3.66 | 3.395 | 3.62 | 355000.0 |
| 2024-01-19 | ABR | Stock | 14.44 | 14.65 | 14.05 | 14.64 | 3231700.0 |
| 2024-01-19 | ABR.D | Stock | 17.76 | 17.76 | 17.59 | 17.7 | 10949.0 |
| 2024-01-19 | ABR.E | Stock | 17.7 | 17.7 | 17.43 | 17.49 | 4536.0 |
| 2024-01-19 | ABR.F | Stock | 18.6499 | 18.65 | 18.48 | 18.65 | 16327.0 |
| 2024-01-19 | ABSI | Stock | 3.59 | 3.59 | 3.09 | 3.41 | 1628800.0 |
| 2024-01-19 | ABT | Stock | 113.63 | 114.86 | 113.46 | 114.69 | 6843100.0 |
| 2024-01-19 | ABTC | Stock | 459.0 | 462.0 | 399.0 | 418.5 | 133.13333333333333 |
> showing 50 of 7,266 rows — these rows as CSV