PREVIEW / stock_daily / 2022-04-07
file: by_date/stock_daily/2022/2022-04-07.parquet size: 260 KB rows: 7,986 symbols: 2,442
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-07 | AAPL | Stock | 171.16 | 173.36 | 169.85 | 172.14 | 77594700.0 |
| 2022-04-07 | MSFT | Stock | 296.66 | 303.65 | 296.35 | 301.37 | 31411200.0 |
| 2022-04-07 | NVDA | Stock | 24.441 | 24.722 | 23.478 | 24.208 | 557992000.0 |
| 2022-04-07 | AMZN | Stock | 158.4 | 160.079 | 154.5115 | 157.7845 | 68136000.0 |
| 2022-04-07 | GOOGL | Stock | 136.01 | 137.1645 | 134.2274 | 135.8885 | 26233600.0 |
| 2022-04-07 | META | Stock | 223.93 | 225.52 | 218.56 | 222.95 | 21037200.0 |
| 2022-04-07 | TSLA | Stock | 350.7967 | 358.8633 | 340.5133 | 352.42 | 79447200.0 |
| 2022-04-07 | TLT | Stock | 126.11 | 126.67 | 125.41 | 126.49 | 23458768.0 |
| 2022-04-07 | ES | Stock | 92.14 | 92.55 | 91.17 | 92.14 | 2021000.0 |
| 2022-04-07 | CL | Stock | 78.87 | 80.62 | 78.61 | 80.42 | 8557200.0 |
| 2022-04-07 | A | Stock | 132.9 | 137.08 | 132.23 | 135.93 | 1956200.0 |
| 2022-04-07 | AA | Stock | 87.7 | 88.394 | 83.17 | 86.1 | 6516600.0 |
| 2022-04-07 | AAC-DELISTED | Stock | 9.8221 | 9.8221 | 9.81 | 9.81 | 40117.0 |
| 2022-04-07 | AACG | Stock | 1.32 | 1.32 | 1.22 | 1.27 | 26400.0 |
| 2022-04-07 | AACIW-DELISTED | Stock | 0.31 | 0.31 | 0.305 | 0.31 | 3300.0 |
| 2022-04-07 | AAIC-DELISTED | Stock | 3.47 | 3.495 | 3.45 | 3.48 | 67337.0 |
| 2022-04-07 | AAIC.C-DELISTED | Stock | 24.5001 | 24.5672 | 24.5001 | 24.5001 | 1800.0 |
| 2022-04-07 | AAL | Stock | 17.14 | 17.25 | 16.37 | 16.95 | 42285200.0 |
| 2022-04-07 | AAM.A-DELISTED | Stock | 24.9801 | 25.05 | 24.9801 | 25.01 | 17151.0 |
| 2022-04-07 | AAM.B-DELISTED | Stock | 25.28 | 25.64 | 25.28 | 25.3402 | 27796.0 |
| 2022-04-07 | AAMC-DELISTED | Stock | 3.6779 | 3.8971 | 3.6412 | 3.8676 | 47229.0 |
| 2022-04-07 | AAME | Stock | 3.28 | 3.57 | 3.25 | 3.32 | 52800.0 |
| 2022-04-07 | AAMI | Stock | 22.7 | 22.7 | 21.91 | 22.23 | 598700.0 |
| 2022-04-07 | AAN-DELISTED | Stock | 20.28 | 21.08 | 20.1 | 20.83 | 319600.0 |
| 2022-04-07 | AAOI | Stock | 3.19 | 3.244 | 3.11 | 3.22 | 215900.0 |
| 2022-04-07 | AAON | Stock | 35.5933 | 35.8467 | 35.24 | 35.3467 | 363750.0 |
| 2022-04-07 | AAP | Stock | 211.61 | 218.78 | 210.88 | 217.58 | 729500.0 |
| 2022-04-07 | AAQC-DELISTED | Stock | 9.76 | 9.76 | 9.75 | 9.755 | 1405549.0 |
| 2022-04-07 | AAT | Stock | 36.83 | 36.83 | 35.84 | 36.08 | 291800.0 |
| 2022-04-07 | AATC | Stock | 6.39 | 6.395 | 6.18 | 6.19 | 9255.0 |
| 2022-04-07 | AAU-DELISTED | Stock | 0.3283 | 0.335 | 0.315 | 0.3331 | 488813.0 |
| 2022-04-07 | AAUAF-DELISTED | Stock | 0.3283 | 0.335 | 0.315 | 0.3331 | 493242.0 |
| 2022-04-07 | AAWW-DELISTED | Stock | 70.65 | 70.76 | 67.13 | 67.24 | 810670.0 |
| 2022-04-07 | AAXJ | Stock | 74.87 | 75.02 | 74.28 | 74.68 | 1894895.0 |
| 2022-04-07 | AB | Stock | 47.76 | 48.47 | 47.53 | 47.99 | 341700.0 |
| 2022-04-07 | ABB-DELISTED | Stock | 31.75 | 31.96 | 31.57 | 31.79 | 1977114.0 |
| 2022-04-07 | ABBNY-DELISTED | Stock | 31.75 | 31.96 | 31.57 | 31.79 | 2173655.0 |
| 2022-04-07 | ABBV | Stock | 167.67 | 174.59 | 167.54 | 173.28 | 7469000.0 |
| 2022-04-07 | ABC-DELISTED | Stock | 158.13 | 163.805 | 157.52 | 162.94 | 1139087.0 |
| 2022-04-07 | ABCB | Stock | 41.34 | 41.45 | 39.74 | 40.48 | 811100.0 |
| 2022-04-07 | ABCL | Stock | 9.94 | 9.99 | 9.525 | 9.75 | 1059500.0 |
| 2022-04-07 | ABCM-DELISTED | Stock | 19.06 | 19.39 | 18.93 | 19.23 | 75914.0 |
| 2022-04-07 | ABEO | Stock | 8.0 | 8.25 | 7.5 | 8.25 | 75120.0 |
| 2022-04-07 | ABEV | Stock | 3.12 | 3.16 | 3.11 | 3.14 | 19996800.0 |
| 2022-04-07 | ABG | Stock | 155.21 | 155.68 | 150.26 | 153.95 | 516400.0 |
| 2022-04-07 | ABGI-DELISTED | Stock | 9.8 | 9.83 | 9.8 | 9.81 | 43840.0 |
| 2022-04-07 | ABM | Stock | 46.55 | 48.07 | 45.72 | 47.68 | 534400.0 |
| 2022-04-07 | ABMD-DELISTED | Stock | 314.24 | 320.41 | 314.24 | 317.97 | 89777.0 |
| 2022-04-07 | ABNB | Stock | 163.19 | 167.86 | 161.71 | 165.91 | 4146600.0 |
| 2022-04-07 | ABOS | Stock | 4.0 | 4.17 | 3.81 | 3.86 | 178000.0 |
> showing 50 of 7,986 rows — these rows as CSV