PREVIEW / stock_daily / 2024-01-04
file: by_date/stock_daily/2024/2024-01-04.parquet size: 235 KB rows: 7,304 symbols: 1,194
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-04 | AAPL | Stock | 182.15 | 183.09 | 180.88 | 181.91 | 71983600.0 |
| 2024-01-04 | MSFT | Stock | 370.67 | 373.1 | 367.17 | 367.94 | 20901500.0 |
| 2024-01-04 | NVDA | Stock | 47.767 | 48.5 | 47.508 | 47.998 | 306535000.0 |
| 2024-01-04 | AMZN | Stock | 145.59 | 147.38 | 144.05 | 144.57 | 56039800.0 |
| 2024-01-04 | GOOGL | Stock | 138.42 | 139.16 | 136.35 | 136.39 | 27137735.0 |
| 2024-01-04 | META | Stock | 344.5 | 348.15 | 343.4 | 347.12 | 12099900.0 |
| 2024-01-04 | TSLA | Stock | 239.25 | 242.7 | 237.73 | 237.93 | 102629300.0 |
| 2024-01-04 | TLT | Stock | 97.42 | 97.64 | 97.065 | 97.22 | 52604511.0 |
| 2024-01-04 | ES | Stock | 64.33 | 64.64 | 62.82 | 62.89 | 2351100.0 |
| 2024-01-04 | CL | Stock | 79.89 | 80.59 | 79.76 | 80.34 | 4441900.0 |
| 2024-01-04 | A | Stock | 130.55 | 131.5 | 130.19 | 131.0 | 2446600.0 |
| 2024-01-04 | AA | Stock | 31.13 | 31.49 | 30.86 | 31.13 | 4543600.0 |
| 2024-01-04 | AACG | Stock | 1.14 | 1.15 | 1.09 | 1.09 | 5600.0 |
| 2024-01-04 | AACT | Stock | 10.44 | 10.452 | 10.44 | 10.44 | 6400.0 |
| 2024-01-04 | AAGR-DELISTED | Stock | 1.13 | 1.2 | 1.04 | 1.1 | 417239.0 |
| 2024-01-04 | AAGRW-DELISTED | Stock | 0.0198 | 0.02 | 0.018 | 0.0191 | 12241.0 |
| 2024-01-04 | AAL | Stock | 13.01 | 13.25 | 12.95 | 13.09 | 29105800.0 |
| 2024-01-04 | AAMC-DELISTED | Stock | 3.75 | 4.05 | 3.675 | 4.05 | 10700.0 |
| 2024-01-04 | AAME | Stock | 2.42 | 2.45 | 2.4 | 2.44 | 5000.0 |
| 2024-01-04 | AAMI | Stock | 18.27 | 18.45 | 18.17 | 18.27 | 383600.0 |
| 2024-01-04 | AAN-DELISTED | Stock | 11.25 | 11.438 | 11.23 | 11.36 | 274000.0 |
| 2024-01-04 | AAOI | Stock | 17.5 | 18.56 | 17.38 | 18.53 | 2066300.0 |
| 2024-01-04 | AAON | Stock | 72.89 | 74.2 | 72.5 | 73.74 | 394600.0 |
| 2024-01-04 | AAP | Stock | 60.83 | 61.51 | 60.2 | 60.49 | 2045800.0 |
| 2024-01-04 | AAT | Stock | 22.3 | 22.66 | 22.19 | 22.46 | 216600.0 |
| 2024-01-04 | AATC | Stock | 7.05 | 7.05 | 7.01 | 7.048 | 12373.0 |
| 2024-01-04 | AAU-DELISTED | Stock | 0.135 | 0.14 | 0.135 | 0.1363 | 87030.0 |
| 2024-01-04 | AAUAF-DELISTED | Stock | 0.135 | 0.14 | 0.135 | 0.1363 | 88952.0 |
| 2024-01-04 | AAXJ | Stock | 65.1 | 65.2203 | 64.83 | 64.84 | 963418.0 |
| 2024-01-04 | AB | Stock | 30.77 | 31.38 | 30.68 | 31.05 | 343500.0 |
| 2024-01-04 | ABAT | Stock | 4.25 | 4.33 | 4.11 | 4.25 | 427430.0 |
| 2024-01-04 | ABBNY-DELISTED | Stock | 42.58 | 42.96 | 42.57 | 42.6 | 285392.0 |
| 2024-01-04 | ABBV | Stock | 160.31 | 162.29 | 159.43 | 161.46 | 8332200.0 |
| 2024-01-04 | ABCB | Stock | 50.28 | 50.85 | 49.84 | 50.44 | 442100.0 |
| 2024-01-04 | ABCL | Stock | 5.67 | 5.995 | 5.56 | 5.94 | 1124900.0 |
| 2024-01-04 | ABEO | Stock | 5.83 | 5.94 | 5.7 | 5.76 | 238900.0 |
| 2024-01-04 | ABEV | Stock | 2.72 | 2.78 | 2.72 | 2.76 | 9229200.0 |
| 2024-01-04 | ABG | Stock | 209.85 | 209.85 | 205.94 | 207.0 | 119400.0 |
| 2024-01-04 | ABLLW | Stock | 0.83 | 0.85 | 0.8 | 0.84 | 29948.0 |
| 2024-01-04 | ABLV | Stock | 2.491 | 2.745 | 2.491 | 2.59 | 1000.0 |
| 2024-01-04 | ABM | Stock | 43.72 | 43.72 | 43.21 | 43.3 | 387600.0 |
| 2024-01-04 | ABNB | Stock | 132.86 | 137.034 | 132.5 | 133.72 | 4056900.0 |
| 2024-01-04 | ABOS | Stock | 3.94 | 4.3 | 3.84 | 4.02 | 598500.0 |
| 2024-01-04 | ABR | Stock | 14.67 | 14.92 | 14.55 | 14.81 | 2197200.0 |
| 2024-01-04 | ABR.D | Stock | 17.93 | 18.35 | 17.87 | 17.99 | 46450.0 |
| 2024-01-04 | ABR.E | Stock | 17.99 | 18.5999 | 17.85 | 18.075 | 10764.0 |
| 2024-01-04 | ABR.F | Stock | 18.9 | 19.135 | 18.85 | 18.85 | 25241.0 |
| 2024-01-04 | ABSI | Stock | 3.55 | 3.99 | 3.48 | 3.72 | 1455900.0 |
| 2024-01-04 | ABT | Stock | 109.68 | 111.03 | 109.51 | 110.98 | 5296100.0 |
| 2024-01-04 | ABTC | Stock | 579.0 | 630.0 | 555.0 | 591.0 | 40.666666666666664 |
> showing 50 of 7,304 rows — these rows as CSV