PREVIEW / stock_daily / 2024-01-02
file: by_date/stock_daily/2024/2024-01-02.parquet size: 235 KB rows: 7,291 symbols: 1,181
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-02 | AAPL | Stock | 187.15 | 188.44 | 183.89 | 185.64 | 82488700.0 |
| 2024-01-02 | MSFT | Stock | 373.86 | 375.9 | 366.77 | 370.87 | 25258600.0 |
| 2024-01-02 | NVDA | Stock | 49.244 | 49.295 | 47.595 | 48.168 | 411254000.0 |
| 2024-01-02 | AMZN | Stock | 151.54 | 152.38 | 148.39 | 149.93 | 47339400.0 |
| 2024-01-02 | GOOGL | Stock | 138.55 | 139.45 | 136.48 | 138.17 | 23711220.0 |
| 2024-01-02 | META | Stock | 351.32 | 353.16 | 340.01 | 346.29 | 19042200.0 |
| 2024-01-02 | TSLA | Stock | 250.08 | 251.25 | 244.41 | 248.42 | 104654200.0 |
| 2024-01-02 | TLT | Stock | 98.2293 | 98.65 | 98.0 | 98.31 | 47797425.0 |
| 2024-01-02 | ES | Stock | 61.51 | 63.84 | 61.39 | 63.74 | 2188000.0 |
| 2024-01-02 | CL | Stock | 79.63 | 80.73 | 79.39 | 80.72 | 6099500.0 |
| 2024-01-02 | A | Stock | 138.19 | 140.59 | 137.91 | 138.75 | 1441600.0 |
| 2024-01-02 | AA | Stock | 33.53 | 33.97 | 33.04 | 33.31 | 3838000.0 |
| 2024-01-02 | AACG | Stock | 1.15 | 1.15 | 0.97 | 0.97 | 15300.0 |
| 2024-01-02 | AACT | Stock | 10.43 | 10.43 | 10.43 | 10.43 | 2100.0 |
| 2024-01-02 | AAGR-DELISTED | Stock | 1.22 | 1.22 | 1.0 | 1.1 | 567648.0 |
| 2024-01-02 | AAGRW-DELISTED | Stock | 0.0336 | 0.0336 | 0.015 | 0.0151 | 30078.0 |
| 2024-01-02 | AAL | Stock | 13.65 | 13.72 | 13.39 | 13.44 | 34607500.0 |
| 2024-01-02 | AAMC-DELISTED | Stock | 4.16 | 4.16 | 4.08 | 4.08 | 3300.0 |
| 2024-01-02 | AAME | Stock | 2.4 | 2.45 | 2.22 | 2.44 | 30600.0 |
| 2024-01-02 | AAMI | Stock | 19.0 | 19.16 | 18.661 | 18.8 | 484600.0 |
| 2024-01-02 | AAN-DELISTED | Stock | 11.55 | 11.74 | 11.22 | 11.33 | 457400.0 |
| 2024-01-02 | AAOI | Stock | 18.82 | 19.0 | 17.51 | 18.69 | 2874900.0 |
| 2024-01-02 | AAON | Stock | 73.04 | 74.16 | 72.51 | 73.9 | 375700.0 |
| 2024-01-02 | AAP | Stock | 60.95 | 63.67 | 60.48 | 61.95 | 1415700.0 |
| 2024-01-02 | AAT | Stock | 22.51 | 23.13 | 22.44 | 22.94 | 270800.0 |
| 2024-01-02 | AATC | Stock | 6.91 | 7.05 | 6.91 | 7.05 | 11729.0 |
| 2024-01-02 | AAU-DELISTED | Stock | 0.1499 | 0.1499 | 0.14 | 0.1401 | 101133.0 |
| 2024-01-02 | AAUAF-DELISTED | Stock | 0.1499 | 0.1499 | 0.14 | 0.1401 | 103519.0 |
| 2024-01-02 | AAXJ | Stock | 65.47 | 65.76 | 65.305 | 65.44 | 641995.0 |
| 2024-01-02 | AB | Stock | 30.92 | 31.0 | 30.41 | 30.75 | 261100.0 |
| 2024-01-02 | ABAT | Stock | 4.63 | 4.68 | 4.35 | 4.405 | 298537.0 |
| 2024-01-02 | ABBNY-DELISTED | Stock | 43.61 | 43.87 | 43.38 | 43.44 | 206081.0 |
| 2024-01-02 | ABBV | Stock | 154.9 | 160.14 | 154.77 | 159.82 | 8059900.0 |
| 2024-01-02 | ABCB | Stock | 52.41 | 53.7 | 50.56 | 52.15 | 870700.0 |
| 2024-01-02 | ABCL | Stock | 5.62 | 5.89 | 5.54 | 5.73 | 1054400.0 |
| 2024-01-02 | ABEO | Stock | 4.95 | 5.56 | 4.95 | 5.53 | 283900.0 |
| 2024-01-02 | ABEV | Stock | 2.78 | 2.8 | 2.76 | 2.76 | 6389900.0 |
| 2024-01-02 | ABG | Stock | 222.98 | 225.63 | 220.64 | 222.84 | 165600.0 |
| 2024-01-02 | ABLLW | Stock | 0.749 | 0.93 | 0.70005 | 0.85 | 179683.0 |
| 2024-01-02 | ABLV | Stock | 2.6 | 2.85 | 2.6 | 2.65 | 15100.0 |
| 2024-01-02 | ABLVW | Stock | 0.0324 | 0.0324 | 0.0324 | 0.0324 | 400.0 |
| 2024-01-02 | ABM | Stock | 44.56 | 44.95 | 44.31 | 44.55 | 529000.0 |
| 2024-01-02 | ABNB | Stock | 134.43 | 135.6 | 133.34 | 134.48 | 3485200.0 |
| 2024-01-02 | ABOS | Stock | 3.84 | 4.285 | 3.77 | 4.23 | 1151900.0 |
| 2024-01-02 | ABR | Stock | 15.0 | 15.32 | 14.8 | 15.03 | 5620700.0 |
| 2024-01-02 | ABR.D | Stock | 17.73 | 18.75 | 17.7 | 18.39 | 73472.0 |
| 2024-01-02 | ABR.E | Stock | 17.64 | 18.1399 | 17.64 | 17.9727 | 6378.0 |
| 2024-01-02 | ABR.F | Stock | 18.81 | 19.25 | 18.8 | 18.96 | 25353.0 |
| 2024-01-02 | ABSI | Stock | 4.11 | 4.307 | 3.601 | 3.69 | 2049800.0 |
| 2024-01-02 | ABT | Stock | 109.56 | 111.0 | 109.56 | 109.85 | 5058600.0 |
> showing 50 of 7,291 rows — these rows as CSV