PREVIEW / stock_daily / 2024-03-19
file: by_date/stock_daily/2024/2024-03-19.parquet size: 234 KB rows: 7,282 symbols: 1,063
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-03-19 | AAPL | Stock | 174.34 | 176.61 | 173.03 | 176.08 | 55215200.0 |
| 2024-03-19 | MSFT | Stock | 417.83 | 421.67 | 415.55 | 421.41 | 19837900.0 |
| 2024-03-19 | NVDA | Stock | 86.7 | 90.544 | 85.01 | 89.398 | 672171000.0 |
| 2024-03-19 | AMZN | Stock | 174.22 | 176.09 | 173.52 | 175.9 | 26880900.0 |
| 2024-03-19 | GOOGL | Stock | 148.16 | 148.7913 | 146.08 | 147.03 | 24070435.0 |
| 2024-03-19 | META | Stock | 488.17 | 496.63 | 481.28 | 496.24 | 10903100.0 |
| 2024-03-19 | TSLA | Stock | 172.36 | 172.82 | 167.42 | 171.32 | 77271400.0 |
| 2024-03-19 | TLT | Stock | 92.85 | 93.27 | 92.69 | 92.92 | 26953132.0 |
| 2024-03-19 | ES | Stock | 59.06 | 59.39 | 58.47 | 58.8 | 2784300.0 |
| 2024-03-19 | CL | Stock | 88.5 | 88.78 | 88.1 | 88.77 | 3265000.0 |
| 2024-03-19 | A | Stock | 145.99 | 147.57 | 145.47 | 147.39 | 1976200.0 |
| 2024-03-19 | AA | Stock | 30.3 | 30.47 | 28.72 | 29.67 | 9888700.0 |
| 2024-03-19 | AACG | Stock | 1.55 | 1.61 | 1.1 | 1.4 | 73500.0 |
| 2024-03-19 | AACIW-DELISTED | Stock | 0.087 | 0.087 | 0.087 | 0.087 | 637.0 |
| 2024-03-19 | AACT | Stock | 10.57 | 10.57 | 10.55 | 10.57 | 27200.0 |
| 2024-03-19 | AAGR-DELISTED | Stock | 0.4764 | 0.4764 | 0.43105 | 0.4499 | 97755.0 |
| 2024-03-19 | AAGRW-DELISTED | Stock | 0.019 | 0.019 | 0.013 | 0.013 | 37063.0 |
| 2024-03-19 | AAL | Stock | 14.08 | 14.11 | 13.9 | 13.93 | 19305800.0 |
| 2024-03-19 | AAMC-DELISTED | Stock | 3.932 | 3.97 | 3.53 | 3.53 | 8700.0 |
| 2024-03-19 | AAME | Stock | 2.72 | 2.82 | 2.72 | 2.8 | 1500.0 |
| 2024-03-19 | AAMI | Stock | 22.43 | 22.66 | 22.33 | 22.35 | 168800.0 |
| 2024-03-19 | AAN-DELISTED | Stock | 6.79 | 7.02 | 6.77 | 6.99 | 422200.0 |
| 2024-03-19 | AAOI | Stock | 13.35 | 13.75 | 13.0 | 13.6 | 2263900.0 |
| 2024-03-19 | AAON | Stock | 82.68 | 85.3 | 82.53 | 85.18 | 363700.0 |
| 2024-03-19 | AAP | Stock | 84.2 | 85.35 | 82.97 | 83.83 | 2761200.0 |
| 2024-03-19 | AAT | Stock | 21.07 | 21.29 | 21.01 | 21.13 | 278500.0 |
| 2024-03-19 | AATC | Stock | 7.2 | 7.47 | 7.2 | 7.295 | 1496.0 |
| 2024-03-19 | AAU-DELISTED | Stock | 0.14 | 0.1406 | 0.14 | 0.1401 | 134959.0 |
| 2024-03-19 | AAUAF-DELISTED | Stock | 0.14 | 0.1406 | 0.14 | 0.1401 | 137614.0 |
| 2024-03-19 | AAXJ | Stock | 67.04 | 67.28 | 66.83 | 67.21 | 231848.0 |
| 2024-03-19 | AB | Stock | 33.31 | 33.93 | 33.25 | 33.64 | 350500.0 |
| 2024-03-19 | ABAT | Stock | 2.17 | 2.17 | 1.97 | 1.99 | 817080.0 |
| 2024-03-19 | ABBV | Stock | 178.19 | 179.93 | 178.19 | 179.66 | 7625600.0 |
| 2024-03-19 | ABCB | Stock | 45.56 | 46.64 | 45.35 | 46.12 | 366300.0 |
| 2024-03-19 | ABCL | Stock | 4.56 | 4.635 | 4.41 | 4.6 | 693200.0 |
| 2024-03-19 | ABEO | Stock | 7.0 | 7.67 | 6.77 | 7.57 | 830200.0 |
| 2024-03-19 | ABEV | Stock | 2.47 | 2.49 | 2.46 | 2.47 | 18617600.0 |
| 2024-03-19 | ABG | Stock | 208.47 | 210.34 | 208.05 | 209.21 | 127900.0 |
| 2024-03-19 | ABLLW | Stock | 0.55 | 0.6 | 0.55 | 0.6 | 11000.0 |
| 2024-03-19 | ABLV | Stock | 3.01 | 3.05 | 2.75 | 3.01 | 150600.0 |
| 2024-03-19 | ABLVW | Stock | 0.0256 | 0.0946 | 0.0245 | 0.042 | 81253.0 |
| 2024-03-19 | ABM | Stock | 42.69 | 43.69 | 42.69 | 43.37 | 612600.0 |
| 2024-03-19 | ABNB | Stock | 161.49 | 164.1 | 161.055 | 161.79 | 3420700.0 |
| 2024-03-19 | ABOS | Stock | 3.96 | 4.03 | 3.935 | 4.0 | 292900.0 |
| 2024-03-19 | ABR | Stock | 12.68 | 12.8 | 12.53 | 12.61 | 2637700.0 |
| 2024-03-19 | ABR.D | Stock | 18.3538 | 18.91 | 18.335 | 18.71 | 42856.0 |
| 2024-03-19 | ABR.E | Stock | 18.8 | 18.98 | 18.7 | 18.81 | 10896.0 |
| 2024-03-19 | ABR.F | Stock | 19.15 | 19.24 | 18.93 | 19.24 | 12911.0 |
| 2024-03-19 | ABSI | Stock | 4.64 | 4.91 | 4.39 | 4.81 | 1133400.0 |
| 2024-03-19 | ABT | Stock | 112.44 | 114.42 | 112.04 | 113.16 | 8299200.0 |
> showing 50 of 7,282 rows — these rows as CSV