PREVIEW / stock_daily / 2024-04-02
file: by_date/stock_daily/2024/2024-04-02.parquet size: 233 KB rows: 7,256 symbols: 1,047
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-04-02 | AAPL | Stock | 169.08 | 169.34 | 168.23 | 168.84 | 49329500.0 |
| 2024-04-02 | MSFT | Stock | 420.11 | 422.38 | 417.84 | 421.44 | 17912000.0 |
| 2024-04-02 | NVDA | Stock | 88.448 | 90.094 | 87.62 | 89.452 | 433064000.0 |
| 2024-04-02 | AMZN | Stock | 179.07 | 180.79 | 178.38 | 180.69 | 32611500.0 |
| 2024-04-02 | GOOGL | Stock | 153.5 | 154.7 | 152.15 | 154.56 | 24585985.0 |
| 2024-04-02 | META | Stock | 485.1 | 497.53 | 484.65 | 497.37 | 11081000.0 |
| 2024-04-02 | TSLA | Stock | 164.75 | 167.69 | 163.43 | 166.63 | 116650600.0 |
| 2024-04-02 | TLT | Stock | 91.57 | 92.2 | 91.335 | 92.04 | 43086304.0 |
| 2024-04-02 | ES | Stock | 58.56 | 59.65 | 58.51 | 59.27 | 1839500.0 |
| 2024-04-02 | CL | Stock | 88.77 | 89.25 | 88.67 | 89.06 | 3307300.0 |
| 2024-04-02 | A | Stock | 144.02 | 144.33 | 142.59 | 144.17 | 1376500.0 |
| 2024-04-02 | AA | Stock | 34.06 | 35.75 | 33.82 | 35.64 | 8190100.0 |
| 2024-04-02 | AACG | Stock | 1.0 | 1.04 | 1.0 | 1.01 | 10600.0 |
| 2024-04-02 | AACT | Stock | 10.57 | 10.57 | 10.56 | 10.57 | 155100.0 |
| 2024-04-02 | AAGR-DELISTED | Stock | 0.336 | 0.336 | 0.2901 | 0.3053 | 298796.0 |
| 2024-04-02 | AAGRW-DELISTED | Stock | 0.0166 | 0.0166 | 0.0112 | 0.0112 | 6790.0 |
| 2024-04-02 | AAL | Stock | 15.06 | 15.11 | 14.36 | 14.4 | 34155400.0 |
| 2024-04-02 | AAMC-DELISTED | Stock | 3.39 | 4.1 | 3.25 | 3.55 | 8600.0 |
| 2024-04-02 | AAME | Stock | 2.65 | 2.72 | 2.41 | 2.58 | 22800.0 |
| 2024-04-02 | AAMI | Stock | 22.52 | 22.66 | 22.46 | 22.65 | 185100.0 |
| 2024-04-02 | AAN-DELISTED | Stock | 7.42 | 7.59 | 7.32 | 7.48 | 488100.0 |
| 2024-04-02 | AAOI | Stock | 13.52 | 13.67 | 13.24 | 13.39 | 1478600.0 |
| 2024-04-02 | AAON | Stock | 87.34 | 87.34 | 84.38 | 85.27 | 402800.0 |
| 2024-04-02 | AAP | Stock | 84.46 | 85.58 | 83.4 | 83.92 | 1316300.0 |
| 2024-04-02 | AAT | Stock | 21.01 | 21.18 | 20.8 | 21.1 | 331800.0 |
| 2024-04-02 | AATC | Stock | 6.285 | 6.37 | 6.285 | 6.37 | 2782.0 |
| 2024-04-02 | AAU-DELISTED | Stock | 0.14 | 0.1499 | 0.14 | 0.1452 | 1002598.0 |
| 2024-04-02 | AAUAF-DELISTED | Stock | 0.14 | 0.1499 | 0.14 | 0.1452 | 1003696.0 |
| 2024-04-02 | AAXJ | Stock | 68.24 | 68.54 | 68.24 | 68.31 | 653173.0 |
| 2024-04-02 | AB | Stock | 34.25 | 34.88 | 34.1 | 34.61 | 387100.0 |
| 2024-04-02 | ABAT | Stock | 1.73 | 1.73 | 1.555 | 1.64 | 1000169.0 |
| 2024-04-02 | ABBV | Stock | 179.39 | 181.03 | 178.51 | 180.69 | 4523800.0 |
| 2024-04-02 | ABCB | Stock | 46.66 | 46.9 | 46.38 | 46.82 | 722100.0 |
| 2024-04-02 | ABCL | Stock | 4.44 | 4.44 | 4.27 | 4.32 | 1338900.0 |
| 2024-04-02 | ABEO | Stock | 7.6 | 7.68 | 7.3 | 7.48 | 229800.0 |
| 2024-04-02 | ABEV | Stock | 2.43 | 2.45 | 2.41 | 2.41 | 10069300.0 |
| 2024-04-02 | ABG | Stock | 230.97 | 230.97 | 224.27 | 226.36 | 212900.0 |
| 2024-04-02 | ABLLW | Stock | 0.6 | 0.64 | 0.59 | 0.6 | 6101.0 |
| 2024-04-02 | ABLV | Stock | 2.14 | 2.23 | 2.03 | 2.21 | 230700.0 |
| 2024-04-02 | ABM | Stock | 44.35 | 44.95 | 44.22 | 44.59 | 768100.0 |
| 2024-04-02 | ABNB | Stock | 160.95 | 160.98 | 158.68 | 160.11 | 4000900.0 |
| 2024-04-02 | ABOS | Stock | 3.98 | 4.03 | 3.765 | 3.79 | 235800.0 |
| 2024-04-02 | ABR | Stock | 12.97 | 13.03 | 12.83 | 12.94 | 3488800.0 |
| 2024-04-02 | ABR.D | Stock | 19.6 | 19.62 | 19.4 | 19.6 | 21490.0 |
| 2024-04-02 | ABR.E | Stock | 19.515 | 19.9799 | 19.05 | 19.4512 | 1445.0 |
| 2024-04-02 | ABR.F | Stock | 20.18 | 20.2478 | 19.93 | 19.99 | 13191.0 |
| 2024-04-02 | ABSI | Stock | 5.37 | 5.405 | 5.1 | 5.14 | 1841500.0 |
| 2024-04-02 | ABT | Stock | 111.89 | 112.42 | 111.18 | 112.02 | 4560700.0 |
| 2024-04-02 | ABTC | Stock | 101.25 | 105.75 | 91.5 | 93.0 | 4328.0 |
| 2024-04-02 | ABTS | Stock | 10.8 | 11.1 | 9.915 | 10.065 | 4733.0 |
> showing 50 of 7,256 rows — these rows as CSV