PREVIEW / stock_daily / 2024-03-28
file: by_date/stock_daily/2024/2024-03-28.parquet size: 235 KB rows: 7,288 symbols: 1,058
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 |
|---|---|---|---|---|---|---|---|
| 2024-03-28 | AAPL | Stock | 171.75 | 172.23 | 170.51 | 171.48 | 65672700.0 |
| 2024-03-28 | MSFT | Stock | 420.96 | 421.87 | 419.12 | 420.72 | 21871200.0 |
| 2024-03-28 | NVDA | Stock | 90.0 | 91.3 | 89.193 | 90.356 | 435212000.0 |
| 2024-03-28 | AMZN | Stock | 180.17 | 181.7 | 179.26 | 180.38 | 38051600.0 |
| 2024-03-28 | GOOGL | Stock | 150.85 | 151.43 | 150.17 | 150.93 | 24485390.0 |
| 2024-03-28 | META | Stock | 492.84 | 492.89 | 485.15 | 485.58 | 15212800.0 |
| 2024-03-28 | TSLA | Stock | 177.45 | 179.57 | 175.3 | 175.79 | 77654800.0 |
| 2024-03-28 | TLT | Stock | 94.49 | 95.02 | 94.32 | 94.62 | 34540428.0 |
| 2024-03-28 | ES | Stock | 59.27 | 59.99 | 58.8 | 59.77 | 1921000.0 |
| 2024-03-28 | CL | Stock | 90.2 | 90.37 | 89.9 | 90.05 | 3459700.0 |
| 2024-03-28 | A | Stock | 147.54 | 147.68 | 145.36 | 145.51 | 2176500.0 |
| 2024-03-28 | AA | Stock | 33.24 | 33.965 | 33.2 | 33.79 | 6147100.0 |
| 2024-03-28 | AACG | Stock | 1.06 | 1.13 | 1.05 | 1.06 | 12400.0 |
| 2024-03-28 | AACIU | Stock | 12.5 | 12.5 | 11.06 | 11.06 | 2480.0 |
| 2024-03-28 | AACIW-DELISTED | Stock | 0.0929 | 0.0929 | 0.0849 | 0.0849 | 6613.0 |
| 2024-03-28 | AACT | Stock | 10.57 | 10.57 | 10.57 | 10.57 | 100.0 |
| 2024-03-28 | AAGR-DELISTED | Stock | 0.412 | 0.4198 | 0.3511 | 0.393 | 194483.0 |
| 2024-03-28 | AAGRW-DELISTED | Stock | 0.0132 | 0.0132 | 0.0126 | 0.0126 | 8546.0 |
| 2024-03-28 | AAL | Stock | 15.28 | 15.5 | 15.13 | 15.35 | 36396000.0 |
| 2024-03-28 | AAMC-DELISTED | Stock | 3.487 | 3.487 | 3.26 | 3.26 | 700.0 |
| 2024-03-28 | AAME | Stock | 2.79 | 2.8 | 2.5 | 2.8 | 25000.0 |
| 2024-03-28 | AAMI | Stock | 22.76 | 22.985 | 22.76 | 22.84 | 358700.0 |
| 2024-03-28 | AAN-DELISTED | Stock | 7.41 | 7.52 | 7.39 | 7.5 | 309300.0 |
| 2024-03-28 | AAOI | Stock | 13.88 | 14.444 | 13.6 | 13.86 | 2449400.0 |
| 2024-03-28 | AAON | Stock | 86.65 | 88.23 | 86.37 | 88.1 | 364900.0 |
| 2024-03-28 | AAP | Stock | 85.54 | 86.31 | 85.03 | 85.09 | 1459800.0 |
| 2024-03-28 | AAT | Stock | 21.75 | 22.04 | 21.75 | 21.91 | 175300.0 |
| 2024-03-28 | AATC | Stock | 6.1 | 6.35 | 6.1 | 6.25 | 21238.0 |
| 2024-03-28 | AAU-DELISTED | Stock | 0.14 | 0.1408 | 0.14 | 0.14 | 236661.0 |
| 2024-03-28 | AAUAF-DELISTED | Stock | 0.14 | 0.1408 | 0.14 | 0.14 | 237586.0 |
| 2024-03-28 | AAXJ | Stock | 67.64 | 67.96 | 67.64 | 67.75 | 671154.0 |
| 2024-03-28 | AB | Stock | 34.8 | 35.33 | 34.71 | 34.74 | 230200.0 |
| 2024-03-28 | ABAT | Stock | 1.62 | 1.84 | 1.62 | 1.75 | 770033.0 |
| 2024-03-28 | ABBV | Stock | 181.0 | 182.3 | 180.3 | 182.1 | 5418700.0 |
| 2024-03-28 | ABCB | Stock | 48.07 | 48.7 | 48.0 | 48.38 | 371400.0 |
| 2024-03-28 | ABCL | Stock | 4.51 | 4.645 | 4.485 | 4.53 | 929000.0 |
| 2024-03-28 | ABEO | Stock | 7.27 | 7.46 | 7.1 | 7.25 | 267300.0 |
| 2024-03-28 | ABEV | Stock | 2.47 | 2.5 | 2.47 | 2.48 | 13814600.0 |
| 2024-03-28 | ABG | Stock | 234.81 | 236.61 | 233.96 | 235.78 | 183400.0 |
| 2024-03-28 | ABLLW | Stock | 0.577 | 0.66 | 0.577 | 0.64 | 35890.0 |
| 2024-03-28 | ABLV | Stock | 2.339 | 2.47 | 2.28 | 2.47 | 51500.0 |
| 2024-03-28 | ABM | Stock | 44.41 | 44.98 | 44.31 | 44.62 | 485800.0 |
| 2024-03-28 | ABNB | Stock | 166.57 | 167.38 | 164.59 | 164.96 | 3416000.0 |
| 2024-03-28 | ABOS | Stock | 4.12 | 4.275 | 4.012 | 4.05 | 511400.0 |
| 2024-03-28 | ABR | Stock | 13.27 | 13.43 | 13.15 | 13.25 | 2813800.0 |
| 2024-03-28 | ABR.D | Stock | 19.1999 | 19.65 | 19.05 | 19.56 | 110184.0 |
| 2024-03-28 | ABR.E | Stock | 20.16 | 20.94 | 19.23 | 19.5 | 9649.0 |
| 2024-03-28 | ABR.F | Stock | 19.73 | 20.36 | 19.73 | 20.26 | 252213.0 |
| 2024-03-28 | ABSI | Stock | 5.54 | 5.76 | 5.51 | 5.68 | 1217900.0 |
| 2024-03-28 | ABT | Stock | 113.28 | 114.02 | 112.93 | 113.66 | 5278000.0 |
> showing 50 of 7,288 rows — these rows as CSV