PREVIEW / stock_daily / 2023-06-08
file: by_date/stock_daily/2023/2023-06-08.parquet size: 243 KB rows: 7,536 symbols: 1,628
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 |
|---|---|---|---|---|---|---|---|
| 2023-06-08 | AAPL | Stock | 177.9 | 180.84 | 177.46 | 180.57 | 50214900.0 |
| 2023-06-08 | MSFT | Stock | 323.94 | 326.64 | 323.35 | 325.26 | 23277700.0 |
| 2023-06-08 | NVDA | Stock | 37.724 | 38.864 | 37.505 | 38.51 | 417772000.0 |
| 2023-06-08 | AMZN | Stock | 123.01 | 125.63 | 122.26 | 124.25 | 62159300.0 |
| 2023-06-08 | GOOGL | Stock | 122.225 | 123.225 | 121.24 | 122.14 | 29389167.0 |
| 2023-06-08 | META | Stock | 260.62 | 267.65 | 258.88 | 264.58 | 20899400.0 |
| 2023-06-08 | TSLA | Stock | 224.22 | 235.23 | 223.01 | 234.86 | 164489700.0 |
| 2023-06-08 | TLT | Stock | 100.87 | 102.14 | 100.8 | 102.06 | 23848659.0 |
| 2023-06-08 | ES | Stock | 71.47 | 71.85 | 70.75 | 71.59 | 1852000.0 |
| 2023-06-08 | CL | Stock | 75.27 | 75.76 | 75.07 | 75.73 | 3218800.0 |
| 2023-06-08 | A | Stock | 115.93 | 116.9 | 114.66 | 114.69 | 2558600.0 |
| 2023-06-08 | AA | Stock | 35.61 | 35.95 | 34.76 | 35.58 | 3779400.0 |
| 2023-06-08 | AAC-DELISTED | Stock | 10.5 | 10.5 | 10.49 | 10.5 | 94941.0 |
| 2023-06-08 | AACG | Stock | 1.62 | 1.62 | 1.34 | 1.4 | 37400.0 |
| 2023-06-08 | AACIW-DELISTED | Stock | 0.0695 | 0.0695 | 0.0695 | 0.0695 | 420.0 |
| 2023-06-08 | AAIC-DELISTED | Stock | 4.24 | 4.335 | 4.24 | 4.32 | 381434.0 |
| 2023-06-08 | AAIC.C-DELISTED | Stock | 22.7 | 22.9 | 22.5771 | 22.8999 | 1200.0 |
| 2023-06-08 | AAL | Stock | 15.16 | 15.6 | 15.09 | 15.3 | 21698100.0 |
| 2023-06-08 | AAM.A-DELISTED | Stock | 24.02 | 24.25 | 24.0 | 24.25 | 23395.0 |
| 2023-06-08 | AAM.B-DELISTED | Stock | 24.55 | 24.55 | 24.0 | 24.47 | 6437.0 |
| 2023-06-08 | AAMC-DELISTED | Stock | 27.3529 | 27.3529 | 26.9118 | 27.0882 | 17428.0 |
| 2023-06-08 | AAME | Stock | 2.17 | 2.17 | 2.17 | 2.17 | 100.0 |
| 2023-06-08 | AAMI | Stock | 22.74 | 23.23 | 22.59 | 22.84 | 421500.0 |
| 2023-06-08 | AAN-DELISTED | Stock | 14.5 | 14.709 | 13.99 | 14.41 | 257900.0 |
| 2023-06-08 | AAOI | Stock | 2.72 | 3.17 | 2.72 | 3.12 | 1116100.0 |
| 2023-06-08 | AAON | Stock | 63.22 | 63.7733 | 62.8867 | 63.42 | 585000.0 |
| 2023-06-08 | AAP | Stock | 65.49 | 66.22 | 64.74 | 64.74 | 3901400.0 |
| 2023-06-08 | AAT | Stock | 20.36 | 20.36 | 19.63 | 19.78 | 428900.0 |
| 2023-06-08 | AATC | Stock | 4.2925 | 4.32 | 4.245 | 4.27 | 5095.0 |
| 2023-06-08 | AAU-DELISTED | Stock | 0.135 | 0.1372 | 0.123 | 0.126 | 273823.0 |
| 2023-06-08 | AAUAF-DELISTED | Stock | 0.135 | 0.1372 | 0.123 | 0.126 | 276930.0 |
| 2023-06-08 | AAXJ | Stock | 66.63 | 67.15 | 66.63 | 67.06 | 696115.0 |
| 2023-06-08 | AB | Stock | 34.62 | 34.78 | 34.07 | 34.69 | 161200.0 |
| 2023-06-08 | ABBNY-DELISTED | Stock | 37.79 | 38.01 | 37.753 | 37.98 | 181737.0 |
| 2023-06-08 | ABBV | Stock | 137.0 | 137.89 | 136.0 | 137.64 | 4714200.0 |
| 2023-06-08 | ABC-DELISTED | Stock | 173.87 | 176.68 | 172.2783 | 176.45 | 620020.0 |
| 2023-06-08 | ABCB | Stock | 36.64 | 36.84 | 35.67 | 36.61 | 477400.0 |
| 2023-06-08 | ABCL | Stock | 7.35 | 7.35 | 6.99 | 7.16 | 2975200.0 |
| 2023-06-08 | ABCM-DELISTED | Stock | 16.68 | 16.99 | 16.015 | 16.04 | 1875746.0 |
| 2023-06-08 | ABEO | Stock | 4.13 | 4.69 | 4.06 | 4.29 | 370300.0 |
| 2023-06-08 | ABEV | Stock | 2.97 | 3.02 | 2.96 | 3.0 | 4646700.0 |
| 2023-06-08 | ABG | Stock | 228.93 | 231.49 | 225.78 | 230.9 | 133800.0 |
| 2023-06-08 | ABM | Stock | 47.79 | 48.1 | 46.93 | 47.13 | 776800.0 |
| 2023-06-08 | ABNB | Stock | 114.97 | 116.33 | 113.58 | 115.5 | 4432700.0 |
| 2023-06-08 | ABOS | Stock | 5.08 | 5.1 | 4.76 | 4.87 | 119600.0 |
| 2023-06-08 | ABR | Stock | 14.08 | 14.21 | 13.88 | 14.13 | 2324700.0 |
| 2023-06-08 | ABR.D | Stock | 18.445 | 18.4499 | 18.4 | 18.4 | 4613.0 |
| 2023-06-08 | ABR.E | Stock | 17.855 | 18.0069 | 17.71 | 17.885 | 6246.0 |
| 2023-06-08 | ABR.F | Stock | 18.8 | 19.05 | 18.66 | 18.75 | 56716.0 |
| 2023-06-08 | ABSI | Stock | 1.79 | 1.82 | 1.631 | 1.7 | 730000.0 |
> showing 50 of 7,536 rows — these rows as CSV