PREVIEW / stock_daily / 2024-01-22
file: by_date/stock_daily/2024/2024-01-22.parquet size: 235 KB rows: 7,322 symbols: 1,192
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-22 | AAPL | Stock | 192.3 | 195.33 | 192.26 | 193.89 | 60133900.0 |
| 2024-01-22 | MSFT | Stock | 400.02 | 400.62 | 393.59 | 396.51 | 27016900.0 |
| 2024-01-22 | NVDA | Stock | 60.049 | 60.331 | 59.07 | 59.654 | 452955000.0 |
| 2024-01-22 | AMZN | Stock | 156.89 | 157.05 | 153.9 | 154.78 | 43687500.0 |
| 2024-01-22 | GOOGL | Stock | 147.1 | 148.39 | 145.84 | 145.99 | 32200369.0 |
| 2024-01-22 | META | Stock | 387.95 | 390.35 | 381.16 | 381.78 | 17680500.0 |
| 2024-01-22 | TSLA | Stock | 212.26 | 217.8 | 206.27 | 208.8 | 117952500.0 |
| 2024-01-22 | TLT | Stock | 94.82 | 95.08 | 94.39 | 94.65 | 35756416.0 |
| 2024-01-22 | ES | Stock | 53.6 | 54.01 | 52.63 | 52.78 | 3718700.0 |
| 2024-01-22 | CL | Stock | 80.33 | 80.55 | 79.69 | 80.42 | 6237700.0 |
| 2024-01-22 | A | Stock | 131.5 | 132.73 | 131.25 | 132.55 | 1512300.0 |
| 2024-01-22 | AA | Stock | 26.87 | 27.855 | 26.77 | 27.62 | 5793800.0 |
| 2024-01-22 | AACG | Stock | 1.09 | 1.11 | 1.05 | 1.05 | 18100.0 |
| 2024-01-22 | AACT | Stock | 10.5 | 10.5 | 10.48 | 10.48 | 5200.0 |
| 2024-01-22 | AAGR-DELISTED | Stock | 0.8051 | 0.83 | 0.79 | 0.81 | 32214.0 |
| 2024-01-22 | AAGRW-DELISTED | Stock | 0.0153 | 0.0153 | 0.0153 | 0.0153 | 649.0 |
| 2024-01-22 | AAL | Stock | 13.96 | 14.08 | 13.54 | 13.62 | 38029500.0 |
| 2024-01-22 | AAMC-DELISTED | Stock | 4.9 | 5.22 | 4.68 | 5.11 | 49300.0 |
| 2024-01-22 | AAME | Stock | 2.59 | 2.66 | 2.47 | 2.48 | 5000.0 |
| 2024-01-22 | AAMI | Stock | 20.74 | 21.44 | 20.74 | 21.14 | 572700.0 |
| 2024-01-22 | AAN-DELISTED | Stock | 10.3 | 10.63 | 10.24 | 10.59 | 267800.0 |
| 2024-01-22 | AAOI | Stock | 16.1 | 17.19 | 15.89 | 17.1 | 2396400.0 |
| 2024-01-22 | AAON | Stock | 71.05 | 72.61 | 71.05 | 72.1 | 484300.0 |
| 2024-01-22 | AAP | Stock | 64.25 | 65.7 | 63.5 | 65.44 | 1751100.0 |
| 2024-01-22 | AAT | Stock | 23.17 | 23.64 | 23.17 | 23.52 | 483600.0 |
| 2024-01-22 | AATC | Stock | 7.74 | 7.9 | 7.676 | 7.9 | 11293.0 |
| 2024-01-22 | AAU-DELISTED | Stock | 0.135 | 0.136 | 0.135 | 0.1351 | 107229.0 |
| 2024-01-22 | AAUAF-DELISTED | Stock | 0.135 | 0.136 | 0.135 | 0.1351 | 108562.0 |
| 2024-01-22 | AAXJ | Stock | 62.22 | 62.61 | 62.1701 | 62.49 | 515141.0 |
| 2024-01-22 | AB | Stock | 33.61 | 33.99 | 33.38 | 33.65 | 341900.0 |
| 2024-01-22 | ABAT | Stock | 2.62 | 2.87 | 2.51 | 2.85 | 941118.0 |
| 2024-01-22 | ABBNY-DELISTED | Stock | 41.63 | 41.84 | 41.51 | 41.54 | 240144.0 |
| 2024-01-22 | ABBV | Stock | 164.44 | 165.45 | 163.76 | 165.39 | 4864000.0 |
| 2024-01-22 | ABCB | Stock | 52.35 | 53.13 | 52.01 | 53.09 | 295400.0 |
| 2024-01-22 | ABCL | Stock | 5.3 | 5.55 | 5.25 | 5.51 | 2635200.0 |
| 2024-01-22 | ABEO | Stock | 5.1 | 5.24 | 4.99 | 5.08 | 153600.0 |
| 2024-01-22 | ABEV | Stock | 2.67 | 2.7 | 2.63 | 2.65 | 9289900.0 |
| 2024-01-22 | ABG | Stock | 206.31 | 209.33 | 204.76 | 207.57 | 127700.0 |
| 2024-01-22 | ABLLW | Stock | 0.92 | 1.0 | 0.92 | 0.95 | 193558.0 |
| 2024-01-22 | ABLV | Stock | 2.64 | 2.688 | 2.45 | 2.6 | 146700.0 |
| 2024-01-22 | ABM | Stock | 42.09 | 42.61 | 41.97 | 42.41 | 442700.0 |
| 2024-01-22 | ABNB | Stock | 141.155 | 144.05 | 140.9 | 142.01 | 4482900.0 |
| 2024-01-22 | ABOS | Stock | 3.61 | 3.661 | 3.38 | 3.39 | 633800.0 |
| 2024-01-22 | ABR | Stock | 14.74 | 14.89 | 13.85 | 14.1 | 7071100.0 |
| 2024-01-22 | ABR.D | Stock | 17.785 | 17.92 | 17.58 | 17.74 | 21621.0 |
| 2024-01-22 | ABR.E | Stock | 17.68 | 17.6862 | 17.4 | 17.4095 | 6944.0 |
| 2024-01-22 | ABR.F | Stock | 18.7 | 18.75 | 18.55 | 18.67 | 26960.0 |
| 2024-01-22 | ABSI | Stock | 3.43 | 3.7 | 3.4 | 3.615 | 773400.0 |
| 2024-01-22 | ABT | Stock | 114.93 | 115.64 | 114.14 | 114.19 | 5062500.0 |
| 2024-01-22 | ABTC | Stock | 417.0 | 438.0 | 405.0 | 429.0 | 71.93333333333334 |
> showing 50 of 7,322 rows — these rows as CSV