PREVIEW / stock_daily / 2024-03-22
file: by_date/stock_daily/2024/2024-03-22.parquet size: 232 KB rows: 7,230 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-03-22 | AAPL | Stock | 171.76 | 173.05 | 170.06 | 172.28 | 71106600.0 |
| 2024-03-22 | MSFT | Stock | 429.7 | 429.86 | 426.07 | 428.74 | 17636500.0 |
| 2024-03-22 | NVDA | Stock | 91.141 | 94.778 | 90.834 | 94.289 | 586719000.0 |
| 2024-03-22 | AMZN | Stock | 177.75 | 179.26 | 176.75 | 178.87 | 27964100.0 |
| 2024-03-22 | GOOGL | Stock | 149.12 | 151.58 | 148.98 | 150.77 | 29211769.0 |
| 2024-03-22 | META | Stock | 507.0 | 509.97 | 504.34 | 509.58 | 8117000.0 |
| 2024-03-22 | TSLA | Stock | 166.69 | 171.2 | 166.3 | 170.83 | 75454700.0 |
| 2024-03-22 | TLT | Stock | 94.19 | 94.21 | 93.78 | 93.98 | 30262284.0 |
| 2024-03-22 | ES | Stock | 58.4 | 58.6 | 57.78 | 57.89 | 2157100.0 |
| 2024-03-22 | CL | Stock | 88.98 | 89.31 | 88.83 | 89.2 | 3563000.0 |
| 2024-03-22 | A | Stock | 148.85 | 149.28 | 146.42 | 147.45 | 1076600.0 |
| 2024-03-22 | AA | Stock | 31.0 | 31.525 | 30.84 | 31.4 | 4331400.0 |
| 2024-03-22 | AACG | Stock | 1.18 | 1.18 | 1.0 | 1.08 | 77600.0 |
| 2024-03-22 | AACIW-DELISTED | Stock | 0.0844 | 0.093 | 0.0731 | 0.0731 | 4779.0 |
| 2024-03-22 | AACT | Stock | 10.57 | 10.57 | 10.56 | 10.57 | 6700.0 |
| 2024-03-22 | AAGR-DELISTED | Stock | 0.4021 | 0.443 | 0.3958 | 0.419 | 119747.0 |
| 2024-03-22 | AAGRW-DELISTED | Stock | 0.01475 | 0.0164 | 0.013 | 0.013 | 11891.0 |
| 2024-03-22 | AAL | Stock | 14.71 | 14.88 | 14.65 | 14.82 | 16146800.0 |
| 2024-03-22 | AAMC-DELISTED | Stock | 3.6 | 3.6 | 3.22 | 3.22 | 3900.0 |
| 2024-03-22 | AAME | Stock | 2.88 | 2.88 | 2.62 | 2.78 | 13400.0 |
| 2024-03-22 | AAMI | Stock | 22.79 | 22.875 | 22.5 | 22.52 | 163400.0 |
| 2024-03-22 | AAN-DELISTED | Stock | 7.55 | 7.55 | 7.4 | 7.42 | 176100.0 |
| 2024-03-22 | AAOI | Stock | 14.7 | 15.07 | 14.51 | 14.68 | 996700.0 |
| 2024-03-22 | AAON | Stock | 88.57 | 88.63 | 86.23 | 86.45 | 274500.0 |
| 2024-03-22 | AAP | Stock | 86.08 | 86.56 | 85.02 | 85.76 | 1579500.0 |
| 2024-03-22 | AAT | Stock | 21.47 | 21.53 | 20.99 | 21.05 | 237800.0 |
| 2024-03-22 | AATC | Stock | 7.2 | 7.4 | 6.54 | 6.8 | 57556.0 |
| 2024-03-22 | AAU-DELISTED | Stock | 0.14 | 0.1405 | 0.137 | 0.1401 | 169105.0 |
| 2024-03-22 | AAUAF-DELISTED | Stock | 0.14 | 0.1405 | 0.137 | 0.1401 | 170506.0 |
| 2024-03-22 | AAXJ | Stock | 67.56 | 67.595 | 67.385 | 67.46 | 310611.0 |
| 2024-03-22 | AB | Stock | 34.64 | 34.64 | 33.6 | 33.84 | 240300.0 |
| 2024-03-22 | ABAT | Stock | 1.97 | 1.97 | 1.88 | 1.9 | 585604.0 |
| 2024-03-22 | ABBV | Stock | 177.23 | 178.99 | 176.78 | 178.45 | 4084000.0 |
| 2024-03-22 | ABCB | Stock | 48.44 | 48.44 | 46.92 | 46.99 | 250500.0 |
| 2024-03-22 | ABCL | Stock | 4.7 | 4.7 | 4.56 | 4.59 | 616200.0 |
| 2024-03-22 | ABEO | Stock | 7.48 | 7.83 | 7.45 | 7.61 | 171400.0 |
| 2024-03-22 | ABEV | Stock | 2.49 | 2.5 | 2.46 | 2.47 | 6529700.0 |
| 2024-03-22 | ABG | Stock | 224.56 | 225.49 | 221.68 | 224.01 | 159100.0 |
| 2024-03-22 | ABLLW | Stock | 0.69 | 0.73 | 0.6 | 0.6002 | 9931.0 |
| 2024-03-22 | ABLV | Stock | 2.8 | 2.99 | 2.6 | 2.66 | 62000.0 |
| 2024-03-22 | ABLVW | Stock | 0.0561 | 0.0587 | 0.0378 | 0.0535 | 3107.0 |
| 2024-03-22 | ABM | Stock | 44.89 | 44.91 | 43.5 | 43.68 | 1043900.0 |
| 2024-03-22 | ABNB | Stock | 167.0 | 168.8 | 166.64 | 167.86 | 2834300.0 |
| 2024-03-22 | ABOS | Stock | 4.33 | 4.43 | 4.3 | 4.3 | 373700.0 |
| 2024-03-22 | ABR | Stock | 13.05 | 13.1 | 12.77 | 12.9 | 1959600.0 |
| 2024-03-22 | ABR.D | Stock | 18.9 | 19.05 | 18.9 | 18.95 | 19063.0 |
| 2024-03-22 | ABR.E | Stock | 19.48 | 20.2 | 19.46 | 19.46 | 12365.0 |
| 2024-03-22 | ABR.F | Stock | 19.26 | 19.325 | 19.125 | 19.31 | 26426.0 |
| 2024-03-22 | ABSI | Stock | 5.28 | 5.28 | 4.87 | 4.95 | 1106400.0 |
| 2024-03-22 | ABT | Stock | 111.52 | 111.98 | 110.54 | 110.57 | 5387100.0 |
> showing 50 of 7,230 rows — these rows as CSV