PREVIEW / stock_daily / 2022-04-22
file: by_date/stock_daily/2022/2022-04-22.parquet size: 259 KB rows: 7,978 symbols: 2,437
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-22 | AAPL | Stock | 166.46 | 167.87 | 161.5 | 161.79 | 84882400.0 |
| 2022-04-22 | MSFT | Stock | 281.68 | 283.2 | 273.38 | 274.03 | 29405800.0 |
| 2022-04-22 | NVDA | Stock | 20.303 | 20.486 | 19.5 | 19.515 | 624713000.0 |
| 2022-04-22 | AMZN | Stock | 148.25 | 149.615 | 143.6975 | 144.35 | 73078000.0 |
| 2022-04-22 | GOOGL | Stock | 125.0 | 125.402 | 118.925 | 119.6355 | 56883720.0 |
| 2022-04-22 | META | Stock | 190.37 | 192.72 | 183.27 | 184.11 | 36426800.0 |
| 2022-04-22 | TSLA | Stock | 338.3033 | 344.95 | 331.3333 | 335.0167 | 69696600.0 |
| 2022-04-22 | TLT | Stock | 120.07 | 121.44 | 119.81 | 119.99 | 19773405.0 |
| 2022-04-22 | ES | Stock | 93.0 | 93.24 | 91.88 | 92.0 | 1089600.0 |
| 2022-04-22 | CL | Stock | 83.0 | 83.39 | 81.01 | 81.1 | 6136800.0 |
| 2022-04-22 | A | Stock | 124.77 | 125.1 | 121.15 | 121.32 | 1947200.0 |
| 2022-04-22 | AA | Stock | 71.87 | 72.3 | 66.72 | 67.37 | 10970300.0 |
| 2022-04-22 | AAC-DELISTED | Stock | 9.83 | 9.85 | 9.83 | 9.83 | 62224.0 |
| 2022-04-22 | AACG | Stock | 1.17 | 1.24 | 1.16 | 1.21 | 27700.0 |
| 2022-04-22 | AAIC-DELISTED | Stock | 3.43 | 3.45 | 3.375 | 3.4 | 50894.0 |
| 2022-04-22 | AAIC.C-DELISTED | Stock | 24.6 | 24.65 | 24.6 | 24.6499 | 900.0 |
| 2022-04-22 | AAL | Stock | 20.6 | 21.15 | 20.07 | 20.18 | 42141900.0 |
| 2022-04-22 | AAM.A-DELISTED | Stock | 25.03 | 25.0482 | 24.9 | 24.9449 | 40620.0 |
| 2022-04-22 | AAM.B-DELISTED | Stock | 25.26 | 25.34 | 25.11 | 25.18 | 23050.0 |
| 2022-04-22 | AAMC-DELISTED | Stock | 3.2209 | 3.2209 | 3.0088 | 3.1176 | 45407.0 |
| 2022-04-22 | AAME | Stock | 3.12 | 3.2 | 3.12 | 3.2 | 1300.0 |
| 2022-04-22 | AAMI | Stock | 21.59 | 21.82 | 21.375 | 21.75 | 613900.0 |
| 2022-04-22 | AAN-DELISTED | Stock | 20.86 | 20.99 | 20.42 | 20.48 | 206000.0 |
| 2022-04-22 | AAOI | Stock | 2.94 | 2.985 | 2.76 | 2.84 | 255900.0 |
| 2022-04-22 | AAON | Stock | 37.2333 | 37.92 | 36.5733 | 37.42 | 581250.0 |
| 2022-04-22 | AAP | Stock | 224.47 | 224.47 | 218.15 | 218.39 | 498300.0 |
| 2022-04-22 | AAQC-DELISTED | Stock | 9.77 | 9.78 | 9.7699 | 9.77 | 270277.0 |
| 2022-04-22 | AAT | Stock | 36.8 | 36.94 | 36.45 | 36.5 | 266800.0 |
| 2022-04-22 | AATC | Stock | 6.83 | 6.99 | 6.75 | 6.85 | 8615.0 |
| 2022-04-22 | AAU-DELISTED | Stock | 0.3606 | 0.3606 | 0.3285 | 0.3398 | 495876.0 |
| 2022-04-22 | AAUAF-DELISTED | Stock | 0.3606 | 0.3606 | 0.3285 | 0.3399 | 500734.0 |
| 2022-04-22 | AAWW-DELISTED | Stock | 69.35 | 69.9495 | 68.28 | 68.46 | 261049.0 |
| 2022-04-22 | AAXJ | Stock | 71.09 | 71.67 | 70.495 | 70.54 | 1945394.0 |
| 2022-04-22 | AB | Stock | 43.0 | 43.1 | 42.06 | 42.23 | 392900.0 |
| 2022-04-22 | ABB-DELISTED | Stock | 31.94 | 32.05 | 31.33 | 31.38 | 3159186.0 |
| 2022-04-22 | ABBNY-DELISTED | Stock | 31.94 | 32.05 | 31.33 | 31.37 | 3967692.0 |
| 2022-04-22 | ABBV | Stock | 157.28 | 158.32 | 154.34 | 154.99 | 7938300.0 |
| 2022-04-22 | ABC-DELISTED | Stock | 163.5 | 163.571 | 158.8 | 158.94 | 893567.0 |
| 2022-04-22 | ABCB | Stock | 42.38 | 42.63 | 41.09 | 41.22 | 520100.0 |
| 2022-04-22 | ABCL | Stock | 8.11 | 8.34 | 7.9 | 7.98 | 896700.0 |
| 2022-04-22 | ABCM-DELISTED | Stock | 17.24 | 17.31 | 16.9 | 16.94 | 97585.0 |
| 2022-04-22 | ABEO | Stock | 6.25 | 6.5 | 6.0 | 6.25 | 39392.0 |
| 2022-04-22 | ABEV | Stock | 3.09 | 3.1 | 3.01 | 3.02 | 28162600.0 |
| 2022-04-22 | ABG | Stock | 159.24 | 164.19 | 155.94 | 160.51 | 251300.0 |
| 2022-04-22 | ABM | Stock | 52.49 | 54.0 | 52.05 | 53.54 | 738700.0 |
| 2022-04-22 | ABMD-DELISTED | Stock | 312.95 | 320.75 | 295.53 | 296.22 | 139816.0 |
| 2022-04-22 | ABNB | Stock | 157.84 | 161.67 | 154.78 | 156.09 | 3863400.0 |
| 2022-04-22 | ABOS | Stock | 4.02 | 4.16 | 4.008 | 4.11 | 171500.0 |
| 2022-04-22 | ABR | Stock | 17.54 | 17.54 | 17.15 | 17.22 | 1478800.0 |
| 2022-04-22 | ABR.D | Stock | 22.8199 | 22.99 | 22.37 | 22.72 | 21494.0 |
> showing 50 of 7,978 rows — these rows as CSV