PREVIEW / stock_daily / 2024-01-30
file: by_date/stock_daily/2024/2024-01-30.parquet size: 235 KB rows: 7,309 symbols: 1,154
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-01-30 | AAPL | Stock | 190.94 | 191.8 | 187.47 | 188.04 | 55859400.0 |
| 2024-01-30 | MSFT | Stock | 412.26 | 413.05 | 406.45 | 408.59 | 33477600.0 |
| 2024-01-30 | NVDA | Stock | 62.9 | 63.493 | 62.26 | 62.774 | 410735000.0 |
| 2024-01-30 | AMZN | Stock | 160.7 | 161.73 | 158.49 | 159.0 | 45207400.0 |
| 2024-01-30 | GOOGL | Stock | 152.8 | 153.62 | 151.185 | 151.46 | 36331833.0 |
| 2024-01-30 | META | Stock | 403.59 | 406.36 | 399.57 | 400.06 | 18614700.0 |
| 2024-01-30 | TSLA | Stock | 195.33 | 196.36 | 190.61 | 191.59 | 109982300.0 |
| 2024-01-30 | TLT | Stock | 95.48 | 95.84 | 94.74 | 95.72 | 40151415.0 |
| 2024-01-30 | ES | Stock | 54.94 | 55.42 | 54.66 | 54.81 | 3605200.0 |
| 2024-01-30 | CL | Stock | 84.0 | 84.59 | 83.51 | 84.23 | 5659900.0 |
| 2024-01-30 | A | Stock | 132.83 | 134.52 | 132.69 | 134.28 | 1428700.0 |
| 2024-01-30 | AA | Stock | 30.34 | 30.84 | 30.0 | 30.61 | 4714700.0 |
| 2024-01-30 | AACG | Stock | 1.08 | 1.11 | 1.08 | 1.08 | 7600.0 |
| 2024-01-30 | AACIU | Stock | 9.81 | 10.89 | 8.87 | 10.89 | 12310.0 |
| 2024-01-30 | AACIW-DELISTED | Stock | 0.0289 | 0.0298 | 0.0256 | 0.0256 | 1760.0 |
| 2024-01-30 | AACT | Stock | 10.49 | 10.5 | 10.49 | 10.49 | 111900.0 |
| 2024-01-30 | AAGR-DELISTED | Stock | 1.1 | 1.13 | 1.01 | 1.12 | 235635.0 |
| 2024-01-30 | AAGRW-DELISTED | Stock | 0.0158 | 0.0158 | 0.0158 | 0.0158 | 877.0 |
| 2024-01-30 | AAL | Stock | 14.79 | 14.88 | 14.53 | 14.53 | 24943100.0 |
| 2024-01-30 | AAMC-DELISTED | Stock | 4.9 | 5.19 | 4.65 | 5.09 | 5600.0 |
| 2024-01-30 | AAME | Stock | 2.74 | 2.75 | 2.64 | 2.64 | 2400.0 |
| 2024-01-30 | AAMI | Stock | 22.44 | 22.65 | 22.43 | 22.5 | 197300.0 |
| 2024-01-30 | AAN-DELISTED | Stock | 10.73 | 10.81 | 10.62 | 10.78 | 165000.0 |
| 2024-01-30 | AAOI | Stock | 17.15 | 18.04 | 16.63 | 16.69 | 4371600.0 |
| 2024-01-30 | AAON | Stock | 70.61 | 73.83 | 70.32 | 73.77 | 400200.0 |
| 2024-01-30 | AAP | Stock | 66.96 | 67.7 | 66.76 | 67.25 | 875200.0 |
| 2024-01-30 | AAT | Stock | 23.65 | 23.78 | 23.18 | 23.24 | 329600.0 |
| 2024-01-30 | AATC | Stock | 9.34 | 9.34 | 9.11 | 9.15 | 23185.0 |
| 2024-01-30 | AAU-DELISTED | Stock | 0.1351 | 0.1354 | 0.132 | 0.1351 | 235882.0 |
| 2024-01-30 | AAUAF-DELISTED | Stock | 0.1351 | 0.1354 | 0.132 | 0.1351 | 236449.0 |
| 2024-01-30 | AAXJ | Stock | 63.36 | 63.52 | 63.22 | 63.47 | 1290331.0 |
| 2024-01-30 | AB | Stock | 33.39 | 34.12 | 33.3 | 33.96 | 328300.0 |
| 2024-01-30 | ABAT | Stock | 2.9 | 2.9 | 2.65 | 2.8 | 754835.0 |
| 2024-01-30 | ABBNY-DELISTED | Stock | 43.07 | 43.2983 | 42.96 | 43.17 | 136436.0 |
| 2024-01-30 | ABBV | Stock | 164.22 | 164.98 | 163.26 | 164.92 | 3819600.0 |
| 2024-01-30 | ABCB | Stock | 52.34 | 52.57 | 51.78 | 51.96 | 273600.0 |
| 2024-01-30 | ABCL | Stock | 5.6 | 5.6 | 5.22 | 5.28 | 990100.0 |
| 2024-01-30 | ABEO | Stock | 4.85 | 4.94 | 4.45 | 4.48 | 547300.0 |
| 2024-01-30 | ABEV | Stock | 2.64 | 2.65 | 2.61 | 2.63 | 6632900.0 |
| 2024-01-30 | ABG | Stock | 218.11 | 221.85 | 217.86 | 218.36 | 110300.0 |
| 2024-01-30 | ABLLW | Stock | 0.89 | 0.92 | 0.89 | 0.9 | 45505.0 |
| 2024-01-30 | ABLV | Stock | 2.64 | 2.76 | 2.64 | 2.7 | 170700.0 |
| 2024-01-30 | ABM | Stock | 41.6 | 41.96 | 41.47 | 41.92 | 327100.0 |
| 2024-01-30 | ABNB | Stock | 150.54 | 151.03 | 148.68 | 149.44 | 3884000.0 |
| 2024-01-30 | ABOS | Stock | 3.4 | 3.42 | 3.281 | 3.29 | 203600.0 |
| 2024-01-30 | ABR | Stock | 14.16 | 14.33 | 14.11 | 14.2 | 3573100.0 |
| 2024-01-30 | ABR.D | Stock | 18.1 | 18.41 | 18.0 | 18.3 | 28231.0 |
| 2024-01-30 | ABR.E | Stock | 18.0 | 18.3 | 17.93 | 18.14 | 3997.0 |
| 2024-01-30 | ABR.F | Stock | 18.8 | 18.8733 | 18.67 | 18.77 | 45912.0 |
| 2024-01-30 | ABSI | Stock | 3.98 | 4.205 | 3.83 | 3.855 | 2776100.0 |
> showing 50 of 7,309 rows — these rows as CSV