PREVIEW / stock_daily / 2022-03-24
file: by_date/stock_daily/2022/2022-03-24.parquet size: 260 KB rows: 8,002 symbols: 2,474
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 |
|---|---|---|---|---|---|---|---|
| 2022-03-24 | AAPL | Stock | 171.06 | 174.14 | 170.21 | 174.07 | 90131400.0 |
| 2022-03-24 | MSFT | Stock | 299.14 | 304.2 | 298.32 | 304.1 | 24484500.0 |
| 2022-03-24 | NVDA | Stock | 26.166 | 28.32 | 25.907 | 28.15 | 877379000.0 |
| 2022-03-24 | AMZN | Stock | 163.7495 | 164.1185 | 160.05 | 163.6495 | 56798000.0 |
| 2022-03-24 | GOOGL | Stock | 139.2 | 141.6188 | 137.7505 | 141.572 | 26396560.0 |
| 2022-03-24 | META | Stock | 215.0 | 220.67 | 214.79 | 219.57 | 31502300.0 |
| 2022-03-24 | TSLA | Stock | 336.5767 | 341.4967 | 329.6 | 337.9733 | 68920800.0 |
| 2022-03-24 | TLT | Stock | 129.65 | 131.18 | 129.6 | 130.47 | 17141591.0 |
| 2022-03-24 | ES | Stock | 84.75 | 85.56 | 84.49 | 85.42 | 1309300.0 |
| 2022-03-24 | CL | Stock | 73.66 | 74.01 | 73.17 | 73.65 | 3539500.0 |
| 2022-03-24 | A | Stock | 134.89 | 136.58 | 133.59 | 136.41 | 1346700.0 |
| 2022-03-24 | AA | Stock | 91.65 | 95.44 | 91.39 | 95.06 | 7352300.0 |
| 2022-03-24 | AAC-DELISTED | Stock | 9.79 | 9.8 | 9.765 | 9.79 | 518687.0 |
| 2022-03-24 | AACG | Stock | 1.44 | 1.46 | 1.41 | 1.44 | 17500.0 |
| 2022-03-24 | AACIW-DELISTED | Stock | 0.2525 | 0.2525 | 0.23 | 0.24 | 21735.0 |
| 2022-03-24 | AAIC-DELISTED | Stock | 3.46 | 3.54 | 3.46 | 3.5 | 36369.0 |
| 2022-03-24 | AAIC.C-DELISTED | Stock | 24.65 | 24.675 | 24.65 | 24.675 | 521.0 |
| 2022-03-24 | AAL | Stock | 16.31 | 16.76 | 16.1 | 16.72 | 33894000.0 |
| 2022-03-24 | AAM.A-DELISTED | Stock | 25.0 | 25.0799 | 25.0 | 25.03 | 10355.0 |
| 2022-03-24 | AAM.B-DELISTED | Stock | 25.3 | 25.3 | 25.17 | 25.25 | 45287.0 |
| 2022-03-24 | AAMC-DELISTED | Stock | 4.1632 | 4.2794 | 4.1471 | 4.1971 | 25214.0 |
| 2022-03-24 | AAME | Stock | 2.78 | 2.84 | 2.66 | 2.83 | 10900.0 |
| 2022-03-24 | AAMI | Stock | 24.75 | 24.87 | 24.4 | 24.65 | 677300.0 |
| 2022-03-24 | AAN-DELISTED | Stock | 21.24 | 21.485 | 21.03 | 21.4 | 318300.0 |
| 2022-03-24 | AAOI | Stock | 3.38 | 3.38 | 3.22 | 3.36 | 178900.0 |
| 2022-03-24 | AAON | Stock | 36.0267 | 36.78 | 34.9533 | 35.2867 | 232200.0 |
| 2022-03-24 | AAP | Stock | 213.72 | 215.68 | 212.32 | 214.67 | 817000.0 |
| 2022-03-24 | AAT | Stock | 35.93 | 36.19 | 35.72 | 36.06 | 279500.0 |
| 2022-03-24 | AATC | Stock | 6.44 | 6.5798 | 6.4 | 6.4001 | 7473.0 |
| 2022-03-24 | AAU-DELISTED | Stock | 0.3836 | 0.3899 | 0.3744 | 0.377 | 644756.0 |
| 2022-03-24 | AAUAF-DELISTED | Stock | 0.3836 | 0.3899 | 0.3744 | 0.377 | 652323.0 |
| 2022-03-24 | AAWW-DELISTED | Stock | 87.57 | 88.87 | 86.48 | 88.35 | 343783.0 |
| 2022-03-24 | AAXJ | Stock | 75.69 | 75.93 | 75.21 | 75.91 | 963998.0 |
| 2022-03-24 | AB | Stock | 45.7 | 46.25 | 45.42 | 45.72 | 204200.0 |
| 2022-03-24 | ABB-DELISTED | Stock | 34.66 | 34.8 | 34.35 | 34.78 | 2342634.0 |
| 2022-03-24 | ABBNY-DELISTED | Stock | 34.66 | 34.8 | 34.35 | 34.78 | 2581127.0 |
| 2022-03-24 | ABBV | Stock | 159.22 | 160.73 | 158.85 | 160.28 | 4638100.0 |
| 2022-03-24 | ABC-DELISTED | Stock | 152.48 | 152.87 | 151.29 | 152.61 | 431929.0 |
| 2022-03-24 | ABCB | Stock | 44.25 | 44.89 | 43.56 | 44.65 | 434700.0 |
| 2022-03-24 | ABCL | Stock | 9.505 | 9.72 | 9.2 | 9.71 | 1479900.0 |
| 2022-03-24 | ABCM-DELISTED | Stock | 17.92 | 18.1 | 17.82 | 18.005 | 97986.0 |
| 2022-03-24 | ABEO | Stock | 7.75 | 8.0 | 7.25 | 7.25 | 36788.0 |
| 2022-03-24 | ABEV | Stock | 2.92 | 2.98 | 2.9 | 2.92 | 21677800.0 |
| 2022-03-24 | ABG | Stock | 180.31 | 181.81 | 173.35 | 173.97 | 255100.0 |
| 2022-03-24 | ABGI-DELISTED | Stock | 9.75 | 9.775 | 9.75 | 9.77 | 1306.0 |
| 2022-03-24 | ABM | Stock | 44.82 | 44.84 | 44.4 | 44.61 | 178300.0 |
| 2022-03-24 | ABMD-DELISTED | Stock | 313.66 | 322.36 | 306.9664 | 321.64 | 155734.0 |
| 2022-03-24 | ABNB | Stock | 164.81 | 171.0 | 162.668 | 170.83 | 4223500.0 |
| 2022-03-24 | ABOS | Stock | 5.67 | 5.86 | 5.38 | 5.67 | 143000.0 |
| 2022-03-24 | ABR | Stock | 16.97 | 17.3 | 16.91 | 17.22 | 1709300.0 |
> showing 50 of 8,002 rows — these rows as CSV