PREVIEW / stock_daily / 2024-01-24
file: by_date/stock_daily/2024/2024-01-24.parquet size: 233 KB rows: 7,261 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-24 | AAPL | Stock | 195.42 | 196.38 | 194.34 | 194.5 | 53631300.0 |
| 2024-01-24 | MSFT | Stock | 401.54 | 405.63 | 400.45 | 402.56 | 24867000.0 |
| 2024-01-24 | NVDA | Stock | 60.304 | 62.849 | 59.938 | 61.362 | 560271000.0 |
| 2024-01-24 | AMZN | Stock | 157.8 | 158.51 | 156.48 | 156.87 | 48547300.0 |
| 2024-01-24 | GOOGL | Stock | 148.54 | 149.855 | 148.1 | 148.7 | 25233450.0 |
| 2024-01-24 | META | Stock | 390.0 | 396.15 | 387.81 | 390.7 | 15698500.0 |
| 2024-01-24 | TSLA | Stock | 211.88 | 212.73 | 206.77 | 207.83 | 123369900.0 |
| 2024-01-24 | TLT | Stock | 94.51 | 94.54 | 93.1 | 93.35 | 54574914.0 |
| 2024-01-24 | ES | Stock | 53.38 | 53.56 | 52.86 | 53.16 | 6364800.0 |
| 2024-01-24 | CL | Stock | 80.87 | 81.02 | 80.05 | 80.08 | 5880900.0 |
| 2024-01-24 | A | Stock | 132.41 | 132.8 | 129.43 | 129.78 | 1141900.0 |
| 2024-01-24 | AA | Stock | 30.25 | 30.37 | 29.32 | 29.76 | 8916000.0 |
| 2024-01-24 | AACG | Stock | 1.03 | 1.09 | 1.03 | 1.09 | 6200.0 |
| 2024-01-24 | AACT | Stock | 10.47 | 10.49 | 10.47 | 10.48 | 143800.0 |
| 2024-01-24 | AAGR-DELISTED | Stock | 0.89 | 0.95 | 0.851 | 0.9299 | 133166.0 |
| 2024-01-24 | AAGRW-DELISTED | Stock | 0.0154 | 0.0154 | 0.0154 | 0.0154 | 456.0 |
| 2024-01-24 | AAL | Stock | 14.16 | 14.18 | 13.85 | 13.93 | 42219600.0 |
| 2024-01-24 | AAMC-DELISTED | Stock | 5.29 | 5.69 | 5.01 | 5.01 | 20300.0 |
| 2024-01-24 | AAME | Stock | 2.58 | 2.61 | 2.5 | 2.57 | 2100.0 |
| 2024-01-24 | AAMI | Stock | 21.46 | 21.84 | 21.43 | 21.72 | 318600.0 |
| 2024-01-24 | AAN-DELISTED | Stock | 10.66 | 10.71 | 10.36 | 10.44 | 190000.0 |
| 2024-01-24 | AAOI | Stock | 18.5 | 18.8 | 16.55 | 16.59 | 1948700.0 |
| 2024-01-24 | AAON | Stock | 71.42 | 72.03 | 69.74 | 69.81 | 302600.0 |
| 2024-01-24 | AAP | Stock | 66.81 | 66.95 | 65.09 | 65.44 | 1492300.0 |
| 2024-01-24 | AAT | Stock | 23.81 | 23.82 | 23.14 | 23.32 | 341800.0 |
| 2024-01-24 | AATC | Stock | 7.94 | 8.0 | 7.94 | 7.985 | 2704.0 |
| 2024-01-24 | AAU-DELISTED | Stock | 0.135 | 0.1351 | 0.135 | 0.1351 | 178964.0 |
| 2024-01-24 | AAUAF-DELISTED | Stock | 0.135 | 0.1351 | 0.135 | 0.1351 | 176424.0 |
| 2024-01-24 | AAXJ | Stock | 64.26 | 64.45 | 63.95 | 64.03 | 1333245.0 |
| 2024-01-24 | AB | Stock | 33.84 | 34.41 | 33.6 | 33.75 | 436300.0 |
| 2024-01-24 | ABAT | Stock | 2.83 | 3.13 | 2.68 | 2.71 | 974903.0 |
| 2024-01-24 | ABBNY-DELISTED | Stock | 41.96 | 41.975 | 41.71 | 41.72 | 754374.0 |
| 2024-01-24 | ABBV | Stock | 167.77 | 167.95 | 164.06 | 164.22 | 5422200.0 |
| 2024-01-24 | ABCB | Stock | 52.75 | 53.53 | 52.63 | 53.1 | 290400.0 |
| 2024-01-24 | ABCL | Stock | 5.41 | 5.46 | 5.235 | 5.26 | 854700.0 |
| 2024-01-24 | ABEO | Stock | 4.89 | 4.95 | 4.73 | 4.76 | 95800.0 |
| 2024-01-24 | ABEV | Stock | 2.71 | 2.71 | 2.64 | 2.64 | 9615000.0 |
| 2024-01-24 | ABG | Stock | 210.0 | 210.0 | 203.13 | 205.07 | 176900.0 |
| 2024-01-24 | ABLLW | Stock | 0.92 | 0.99 | 0.92 | 0.9202 | 20552.0 |
| 2024-01-24 | ABLV | Stock | 2.64 | 2.66 | 2.45 | 2.585 | 166200.0 |
| 2024-01-24 | ABLVW | Stock | 0.0446 | 0.045 | 0.0203 | 0.0203 | 1135.0 |
| 2024-01-24 | ABM | Stock | 42.81 | 42.81 | 41.85 | 42.03 | 380400.0 |
| 2024-01-24 | ABNB | Stock | 143.81 | 144.1 | 139.58 | 141.19 | 4857200.0 |
| 2024-01-24 | ABOS | Stock | 3.39 | 3.39 | 3.18 | 3.23 | 389900.0 |
| 2024-01-24 | ABR | Stock | 14.11 | 14.18 | 13.46 | 13.56 | 6067800.0 |
| 2024-01-24 | ABR.D | Stock | 17.8899 | 17.8899 | 17.6 | 17.63 | 19793.0 |
| 2024-01-24 | ABR.E | Stock | 17.66 | 17.7 | 17.55 | 17.56 | 5692.0 |
| 2024-01-24 | ABR.F | Stock | 18.72 | 18.72 | 18.58 | 18.64 | 17454.0 |
| 2024-01-24 | ABSI | Stock | 3.73 | 3.73 | 3.49 | 3.52 | 692200.0 |
| 2024-01-24 | ABT | Stock | 110.75 | 113.35 | 109.74 | 110.77 | 8710800.0 |
> showing 50 of 7,261 rows — these rows as CSV