PREVIEW / stock_daily / 2024-05-31
file: by_date/stock_daily/2024/2024-05-31.parquet size: 231 KB rows: 7,198 symbols: 959
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-05-31 | AAPL | Stock | 191.44 | 192.57 | 189.91 | 192.25 | 75158300.0 |
| 2024-05-31 | MSFT | Stock | 416.75 | 416.75 | 404.51 | 415.13 | 47995300.0 |
| 2024-05-31 | NVDA | Stock | 112.52 | 112.717 | 106.94 | 109.633 | 613263000.0 |
| 2024-05-31 | AMZN | Stock | 178.3 | 179.21 | 173.87 | 176.44 | 58903900.0 |
| 2024-05-31 | GOOGL | Stock | 171.86 | 173.06 | 169.44 | 172.5 | 37638876.0 |
| 2024-05-31 | META | Stock | 465.8 | 469.12 | 454.46 | 466.83 | 16919800.0 |
| 2024-05-31 | TSLA | Stock | 178.5 | 180.32 | 173.82 | 178.08 | 67314600.0 |
| 2024-05-31 | TLT | Stock | 90.48 | 90.66 | 90.25 | 90.45 | 41308832.0 |
| 2024-05-31 | ES | Stock | 57.85 | 59.26 | 57.66 | 59.23 | 4679600.0 |
| 2024-05-31 | CL | Stock | 90.93 | 93.04 | 90.77 | 92.96 | 6648000.0 |
| 2024-05-31 | A | Stock | 131.0 | 134.07 | 129.56 | 130.41 | 5333100.0 |
| 2024-05-31 | AA | Stock | 44.76 | 45.46 | 43.3 | 44.27 | 4527300.0 |
| 2024-05-31 | AACG | Stock | 0.94 | 0.95 | 0.9 | 0.95 | 5200.0 |
| 2024-05-31 | AACT | Stock | 10.64 | 10.648 | 10.64 | 10.64 | 944200.0 |
| 2024-05-31 | AAGR-DELISTED | Stock | 0.3969 | 0.397 | 0.3728 | 0.3828 | 34032.0 |
| 2024-05-31 | AAL | Stock | 11.51 | 11.57 | 11.25 | 11.5 | 60868400.0 |
| 2024-05-31 | AAMC-DELISTED | Stock | 2.34 | 2.7 | 2.34 | 2.57 | 19600.0 |
| 2024-05-31 | AAME | Stock | 1.65 | 1.73 | 1.65 | 1.67 | 4800.0 |
| 2024-05-31 | AAMI | Stock | 22.53 | 22.65 | 21.96 | 22.17 | 983600.0 |
| 2024-05-31 | AAN-DELISTED | Stock | 7.72 | 8.48 | 7.71 | 8.48 | 427000.0 |
| 2024-05-31 | AAOI | Stock | 11.69 | 11.82 | 10.35 | 10.49 | 2245300.0 |
| 2024-05-31 | AAON | Stock | 74.6 | 75.2 | 73.54 | 75.05 | 914100.0 |
| 2024-05-31 | AAP | Stock | 67.89 | 70.67 | 67.63 | 70.64 | 2808000.0 |
| 2024-05-31 | AAT | Stock | 21.18 | 21.78 | 21.05 | 21.75 | 675700.0 |
| 2024-05-31 | AATC | Stock | 6.075 | 6.1685 | 6.047 | 6.15 | 17666.0 |
| 2024-05-31 | AAUAF-DELISTED | Stock | 0.1219 | 0.1219 | 0.1129 | 0.12 | 73905.0 |
| 2024-05-31 | AAXJ | Stock | 70.09 | 70.15 | 69.54 | 70.15 | 702746.0 |
| 2024-05-31 | AB | Stock | 33.42 | 33.88 | 33.34 | 33.55 | 129500.0 |
| 2024-05-31 | ABAT | Stock | 1.38 | 1.39 | 1.36 | 1.38 | 223545.0 |
| 2024-05-31 | ABBV | Stock | 156.65 | 161.64 | 156.2 | 161.24 | 15664400.0 |
| 2024-05-31 | ABCB | Stock | 47.82 | 51.18 | 47.25 | 49.95 | 253400.0 |
| 2024-05-31 | ABCL | Stock | 4.04 | 4.2 | 3.9 | 3.92 | 1082700.0 |
| 2024-05-31 | ABEO | Stock | 4.22 | 4.47 | 4.22 | 4.38 | 443100.0 |
| 2024-05-31 | ABEV | Stock | 2.21 | 2.23 | 2.17 | 2.22 | 23228400.0 |
| 2024-05-31 | ABG | Stock | 235.41 | 237.12 | 232.8 | 235.07 | 161000.0 |
| 2024-05-31 | ABLLW | Stock | 0.32 | 0.3655 | 0.32 | 0.34 | 127031.0 |
| 2024-05-31 | ABLV | Stock | 1.112 | 1.2 | 0.858 | 1.12 | 9000.0 |
| 2024-05-31 | ABM | Stock | 46.59 | 47.4 | 46.59 | 47.27 | 377200.0 |
| 2024-05-31 | ABNB | Stock | 145.78 | 146.43 | 142.57 | 144.93 | 3778600.0 |
| 2024-05-31 | ABOS | Stock | 3.0 | 3.07 | 2.9 | 2.94 | 371100.0 |
| 2024-05-31 | ABR | Stock | 13.59 | 13.79 | 13.42 | 13.68 | 3376000.0 |
| 2024-05-31 | ABR.D | Stock | 18.23 | 18.3 | 18.1 | 18.1 | 11605.0 |
| 2024-05-31 | ABR.E | Stock | 18.2 | 18.2 | 17.83 | 17.83 | 1416.0 |
| 2024-05-31 | ABR.F | Stock | 19.92 | 20.4 | 19.8004 | 20.4 | 43410.0 |
| 2024-05-31 | ABSI | Stock | 4.21 | 4.39 | 4.12 | 4.21 | 1075000.0 |
| 2024-05-31 | ABT | Stock | 101.86 | 102.3 | 101.39 | 102.19 | 7915700.0 |
| 2024-05-31 | ABTC | Stock | 91.5 | 96.0 | 89.25 | 91.5 | 3806.6666666666665 |
| 2024-05-31 | ABTS | Stock | 10.44 | 10.44 | 9.84 | 9.9 | 500.0 |
| 2024-05-31 | ABUS | Stock | 3.32 | 3.39 | 3.31 | 3.36 | 831300.0 |
| 2024-05-31 | ABVC | Stock | 0.85 | 0.85 | 0.782 | 0.794 | 218100.0 |
> showing 50 of 7,198 rows — these rows as CSV