PREVIEW / stock_daily / 2022-05-03
file: by_date/stock_daily/2022/2022-05-03.parquet size: 259 KB rows: 7,990 symbols: 2,425
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-05-03 | AAPL | Stock | 158.15 | 160.71 | 156.32 | 159.48 | 88966500.0 |
| 2022-05-03 | MSFT | Stock | 283.96 | 284.13 | 280.15 | 281.78 | 25978600.0 |
| 2022-05-03 | NVDA | Stock | 19.4 | 19.825 | 19.133 | 19.602 | 475751000.0 |
| 2022-05-03 | AMZN | Stock | 124.0535 | 126.2205 | 122.825 | 124.2535 | 79134000.0 |
| 2022-05-03 | GOOGL | Stock | 116.4305 | 118.4418 | 116.0345 | 117.334 | 24967360.0 |
| 2022-05-03 | META | Stock | 210.45 | 214.9 | 208.09 | 212.03 | 41556300.0 |
| 2022-05-03 | TSLA | Stock | 301.06 | 308.0267 | 296.1967 | 303.0833 | 63709500.0 |
| 2022-05-03 | TLT | Stock | 119.04 | 119.31 | 117.89 | 117.97 | 21256662.0 |
| 2022-05-03 | ES | Stock | 86.81 | 88.33 | 86.19 | 86.72 | 1644800.0 |
| 2022-05-03 | CL | Stock | 74.87 | 75.46 | 73.93 | 74.49 | 6073200.0 |
| 2022-05-03 | A | Stock | 119.72 | 123.98 | 119.09 | 122.4 | 3217800.0 |
| 2022-05-03 | AA | Stock | 65.17 | 67.66 | 64.2 | 64.66 | 6510800.0 |
| 2022-05-03 | AAC-DELISTED | Stock | 9.87 | 9.87 | 9.82 | 9.83 | 91264.0 |
| 2022-05-03 | AACG | Stock | 1.15 | 1.17 | 1.15 | 1.16 | 7100.0 |
| 2022-05-03 | AACIW-DELISTED | Stock | 0.2895 | 0.2895 | 0.28 | 0.28 | 7750.0 |
| 2022-05-03 | AAIC-DELISTED | Stock | 3.13 | 3.295 | 3.09 | 3.23 | 139078.0 |
| 2022-05-03 | AAIC.C-DELISTED | Stock | 24.54 | 24.8 | 24.52 | 24.75 | 8132.0 |
| 2022-05-03 | AAL | Stock | 18.68 | 19.34 | 18.34 | 19.13 | 30334200.0 |
| 2022-05-03 | AAM.A-DELISTED | Stock | 24.79 | 24.87 | 24.36 | 24.4 | 14095.0 |
| 2022-05-03 | AAM.B-DELISTED | Stock | 25.11 | 25.2196 | 24.98 | 25.02 | 8265.0 |
| 2022-05-03 | AAMC-DELISTED | Stock | 2.8382 | 3.2 | 2.8382 | 3.0444 | 84072.0 |
| 2022-05-03 | AAME | Stock | 3.02 | 3.02 | 2.99 | 3.01 | 1700.0 |
| 2022-05-03 | AAMI | Stock | 20.17 | 20.57 | 19.905 | 20.31 | 361800.0 |
| 2022-05-03 | AAN-DELISTED | Stock | 21.48 | 21.59 | 20.95 | 21.32 | 155700.0 |
| 2022-05-03 | AAOI | Stock | 2.58 | 2.8 | 2.58 | 2.77 | 246400.0 |
| 2022-05-03 | AAON | Stock | 32.9533 | 33.0133 | 32.14 | 32.3933 | 208800.0 |
| 2022-05-03 | AAP | Stock | 200.68 | 201.83 | 196.36 | 199.92 | 854000.0 |
| 2022-05-03 | AAQC-DELISTED | Stock | 9.78 | 9.78 | 9.78 | 9.78 | 832.0 |
| 2022-05-03 | AAT | Stock | 35.19 | 35.67 | 34.57 | 35.48 | 269900.0 |
| 2022-05-03 | AATC | Stock | 6.56 | 6.645 | 6.5001 | 6.57 | 3904.0 |
| 2022-05-03 | AAU-DELISTED | Stock | 0.298 | 0.298 | 0.2851 | 0.2884 | 310002.0 |
| 2022-05-03 | AAUAF-DELISTED | Stock | 0.298 | 0.298 | 0.2851 | 0.286 | 313627.0 |
| 2022-05-03 | AAWW-DELISTED | Stock | 68.72 | 70.54 | 68.42 | 70.27 | 263033.0 |
| 2022-05-03 | AAXJ | Stock | 71.39 | 71.67 | 71.22 | 71.59 | 1390121.0 |
| 2022-05-03 | AB | Stock | 39.75 | 41.33 | 39.44 | 40.18 | 717000.0 |
| 2022-05-03 | ABB-DELISTED | Stock | 29.68 | 29.8773 | 29.545 | 29.71 | 2035700.0 |
| 2022-05-03 | ABBNY-DELISTED | Stock | 29.68 | 29.8773 | 29.545 | 29.71 | 2329980.0 |
| 2022-05-03 | ABBV | Stock | 148.05 | 150.74 | 147.95 | 149.6 | 6163400.0 |
| 2022-05-03 | ABC-DELISTED | Stock | 149.39 | 151.75 | 149.2 | 150.4 | 1214642.0 |
| 2022-05-03 | ABCB | Stock | 43.0 | 43.61 | 42.59 | 43.15 | 344000.0 |
| 2022-05-03 | ABCL | Stock | 8.01 | 8.34 | 7.94 | 8.04 | 1383100.0 |
| 2022-05-03 | ABCM-DELISTED | Stock | 15.45 | 15.58 | 15.25 | 15.38 | 54593.0 |
| 2022-05-03 | ABEO | Stock | 5.5 | 6.0 | 5.25 | 5.25 | 124232.0 |
| 2022-05-03 | ABEV | Stock | 2.87 | 2.88 | 2.79 | 2.83 | 30971900.0 |
| 2022-05-03 | ABG | Stock | 188.28 | 195.98 | 185.32 | 194.7 | 243800.0 |
| 2022-05-03 | ABGI-DELISTED | Stock | 9.82 | 9.82 | 9.82 | 9.82 | 27480.0 |
| 2022-05-03 | ABM | Stock | 48.07 | 48.74 | 47.15 | 47.31 | 465500.0 |
| 2022-05-03 | ABMD-DELISTED | Stock | 286.18 | 289.7 | 282.92 | 285.88 | 164516.0 |
| 2022-05-03 | ABNB | Stock | 154.09 | 154.49 | 141.58 | 145.0 | 16774700.0 |
| 2022-05-03 | ABOS | Stock | 4.09 | 4.09 | 3.83 | 3.89 | 115400.0 |
> showing 50 of 7,990 rows — these rows as CSV