PREVIEW / stock_daily / 2022-04-05
file: by_date/stock_daily/2022/2022-04-05.parquet size: 260 KB rows: 8,026 symbols: 2,477
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-04-05 | AAPL | Stock | 177.5 | 178.3 | 174.42 | 175.06 | 73401800.0 |
| 2022-04-05 | MSFT | Stock | 313.27 | 314.87 | 309.87 | 310.88 | 23156700.0 |
| 2022-04-05 | NVDA | Stock | 27.254 | 27.319 | 25.82 | 25.931 | 436615000.0 |
| 2022-04-05 | AMZN | Stock | 167.7415 | 168.1105 | 163.266 | 164.055 | 53728000.0 |
| 2022-04-05 | GOOGL | Stock | 142.869 | 142.9905 | 140.3825 | 140.591 | 21418120.0 |
| 2022-04-05 | META | Stock | 234.08 | 236.86 | 231.02 | 231.84 | 29727200.0 |
| 2022-04-05 | TSLA | Stock | 378.7667 | 384.29 | 362.4333 | 363.7533 | 80075100.0 |
| 2022-04-05 | TLT | Stock | 130.76 | 130.775 | 128.29 | 128.49 | 25196929.0 |
| 2022-04-05 | ES | Stock | 89.25 | 90.96 | 89.25 | 90.09 | 1654100.0 |
| 2022-04-05 | CL | Stock | 76.28 | 77.81 | 76.28 | 77.45 | 4398500.0 |
| 2022-04-05 | A | Stock | 134.09 | 135.42 | 132.85 | 133.26 | 1797200.0 |
| 2022-04-05 | AA | Stock | 93.2 | 93.2 | 85.1 | 87.71 | 6846100.0 |
| 2022-04-05 | AAC-DELISTED | Stock | 9.79 | 9.85 | 9.79 | 9.82 | 576147.0 |
| 2022-04-05 | AACG | Stock | 1.4 | 1.46 | 1.4 | 1.44 | 16300.0 |
| 2022-04-05 | AACIW-DELISTED | Stock | 0.3099 | 0.31 | 0.30841 | 0.31 | 2601.0 |
| 2022-04-05 | AAIC-DELISTED | Stock | 3.51 | 3.535 | 3.5 | 3.505 | 51976.0 |
| 2022-04-05 | AAIC.C-DELISTED | Stock | 24.7 | 24.7001 | 24.62 | 24.62 | 910.0 |
| 2022-04-05 | AAL | Stock | 18.35 | 18.57 | 17.58 | 17.84 | 35187300.0 |
| 2022-04-05 | AAM.A-DELISTED | Stock | 25.15 | 25.19 | 25.11 | 25.11 | 13207.0 |
| 2022-04-05 | AAM.B-DELISTED | Stock | 25.54 | 25.9 | 25.52 | 25.54 | 15738.0 |
| 2022-04-05 | AAMC-DELISTED | Stock | 4.1471 | 4.1471 | 3.6176 | 3.9412 | 40997.0 |
| 2022-04-05 | AAME | Stock | 3.22 | 3.45 | 3.17 | 3.4 | 37400.0 |
| 2022-04-05 | AAMI | Stock | 24.35 | 24.35 | 23.39 | 23.52 | 470700.0 |
| 2022-04-05 | AAN-DELISTED | Stock | 20.93 | 21.48 | 20.81 | 20.86 | 348700.0 |
| 2022-04-05 | AAOI | Stock | 3.42 | 3.42 | 3.29 | 3.3 | 219800.0 |
| 2022-04-05 | AAON | Stock | 37.06 | 37.24 | 36.1733 | 36.3867 | 421800.0 |
| 2022-04-05 | AAP | Stock | 210.92 | 212.83 | 208.74 | 211.73 | 570000.0 |
| 2022-04-05 | AAQC-DELISTED | Stock | 9.75 | 9.75 | 9.74 | 9.74 | 19326.0 |
| 2022-04-05 | AAT | Stock | 37.88 | 38.44 | 36.77 | 36.85 | 253100.0 |
| 2022-04-05 | AATC | Stock | 6.35 | 6.42 | 6.24 | 6.24 | 7494.0 |
| 2022-04-05 | AAU-DELISTED | Stock | 0.348 | 0.359 | 0.3272 | 0.328 | 802174.0 |
| 2022-04-05 | AAUAF-DELISTED | Stock | 0.348 | 0.359 | 0.3272 | 0.335 | 810993.0 |
| 2022-04-05 | AAWW-DELISTED | Stock | 79.17 | 79.85 | 73.0 | 73.4 | 1520310.0 |
| 2022-04-05 | AAXJ | Stock | 77.64 | 77.64 | 76.33 | 76.49 | 1672990.0 |
| 2022-04-05 | AB | Stock | 47.79 | 47.99 | 46.97 | 47.25 | 185300.0 |
| 2022-04-05 | ABB-DELISTED | Stock | 32.71 | 32.81 | 32.11 | 32.21 | 1833097.0 |
| 2022-04-05 | ABBNY-DELISTED | Stock | 32.71 | 32.81 | 32.11 | 32.21 | 2021950.0 |
| 2022-04-05 | ABBV | Stock | 161.89 | 165.96 | 161.84 | 163.43 | 6683300.0 |
| 2022-04-05 | ABC-DELISTED | Stock | 154.62 | 157.76 | 154.62 | 155.77 | 435699.0 |
| 2022-04-05 | ABCB | Stock | 42.63 | 42.85 | 41.54 | 41.56 | 533000.0 |
| 2022-04-05 | ABCL | Stock | 10.38 | 10.49 | 9.92 | 10.06 | 1901200.0 |
| 2022-04-05 | ABCM-DELISTED | Stock | 18.93 | 19.2 | 18.77 | 18.88 | 79975.0 |
| 2022-04-05 | ABEO | Stock | 8.25 | 9.25 | 7.75 | 8.5 | 283384.0 |
| 2022-04-05 | ABEV | Stock | 3.25 | 3.28 | 3.2 | 3.2 | 16753600.0 |
| 2022-04-05 | ABG | Stock | 154.0 | 155.17 | 149.74 | 153.84 | 301700.0 |
| 2022-04-05 | ABGI-DELISTED | Stock | 9.78 | 9.79 | 9.78 | 9.79 | 150800.0 |
| 2022-04-05 | ABM | Stock | 46.11 | 46.69 | 45.66 | 45.94 | 334800.0 |
| 2022-04-05 | ABMD-DELISTED | Stock | 329.1 | 336.05 | 321.2 | 322.73 | 98876.0 |
| 2022-04-05 | ABNB | Stock | 177.19 | 179.09 | 170.12 | 171.21 | 4065000.0 |
| 2022-04-05 | ABOS | Stock | 4.08 | 4.16 | 3.97 | 4.08 | 116800.0 |
> showing 50 of 8,026 rows — these rows as CSV