PREVIEW / stock_daily / 2024-01-18
file: by_date/stock_daily/2024/2024-01-18.parquet size: 232 KB rows: 7,230 symbols: 1,167
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-18 | AAPL | Stock | 186.09 | 189.14 | 185.83 | 188.63 | 78005800.0 |
| 2024-01-18 | MSFT | Stock | 391.72 | 393.99 | 390.12 | 393.87 | 23392100.0 |
| 2024-01-18 | NVDA | Stock | 57.26 | 57.6 | 56.107 | 57.107 | 491650000.0 |
| 2024-01-18 | AMZN | Stock | 152.77 | 153.78 | 151.82 | 153.5 | 37850200.0 |
| 2024-01-18 | GOOGL | Stock | 142.05 | 144.21 | 141.99 | 143.48 | 25746417.0 |
| 2024-01-18 | META | Stock | 371.49 | 376.85 | 370.95 | 376.13 | 16354300.0 |
| 2024-01-18 | TSLA | Stock | 216.88 | 217.45 | 208.74 | 211.88 | 108595400.0 |
| 2024-01-18 | TLT | Stock | 94.46 | 94.58 | 93.51 | 93.79 | 77339062.0 |
| 2024-01-18 | ES | Stock | 54.51 | 54.83 | 53.55 | 54.0 | 2993700.0 |
| 2024-01-18 | CL | Stock | 80.43 | 80.87 | 80.05 | 80.83 | 4027100.0 |
| 2024-01-18 | A | Stock | 128.02 | 130.73 | 127.53 | 130.46 | 1404800.0 |
| 2024-01-18 | AA | Stock | 27.62 | 28.72 | 26.58 | 26.75 | 12853200.0 |
| 2024-01-18 | AACG | Stock | 1.05 | 1.08 | 1.05 | 1.08 | 2700.0 |
| 2024-01-18 | AACIW-DELISTED | Stock | 0.02 | 0.02 | 0.0181 | 0.02 | 62645.0 |
| 2024-01-18 | AACT | Stock | 10.465 | 10.47 | 10.465 | 10.465 | 148100.0 |
| 2024-01-18 | AAGR-DELISTED | Stock | 0.839 | 0.84 | 0.801 | 0.8375 | 59885.0 |
| 2024-01-18 | AAGRW-DELISTED | Stock | 0.0234 | 0.029 | 0.018 | 0.018 | 12992.0 |
| 2024-01-18 | AAL | Stock | 13.06 | 13.87 | 13.01 | 13.82 | 58528200.0 |
| 2024-01-18 | AAMC-DELISTED | Stock | 5.17 | 5.587 | 4.85 | 5.17 | 20100.0 |
| 2024-01-18 | AAME | Stock | 2.58 | 2.75 | 2.54 | 2.65 | 5300.0 |
| 2024-01-18 | AAMI | Stock | 19.58 | 19.89 | 19.33 | 19.7 | 431800.0 |
| 2024-01-18 | AAN-DELISTED | Stock | 10.25 | 10.32 | 10.08 | 10.24 | 211800.0 |
| 2024-01-18 | AAOI | Stock | 17.43 | 18.16 | 16.42 | 16.62 | 2807300.0 |
| 2024-01-18 | AAON | Stock | 70.4 | 71.34 | 69.55 | 70.35 | 385400.0 |
| 2024-01-18 | AAP | Stock | 60.94 | 62.31 | 60.94 | 62.17 | 1569300.0 |
| 2024-01-18 | AAT | Stock | 22.55 | 22.56 | 22.0 | 22.29 | 234300.0 |
| 2024-01-18 | AATC | Stock | 7.63 | 7.73 | 7.55 | 7.725 | 11677.0 |
| 2024-01-18 | AAU-DELISTED | Stock | 0.1354 | 0.136 | 0.135 | 0.1351 | 130676.0 |
| 2024-01-18 | AAUAF-DELISTED | Stock | 0.1354 | 0.136 | 0.135 | 0.1351 | 132568.0 |
| 2024-01-18 | AAXJ | Stock | 62.27 | 62.47 | 62.15 | 62.41 | 748663.0 |
| 2024-01-18 | AB | Stock | 32.67 | 32.96 | 32.4 | 32.86 | 209900.0 |
| 2024-01-18 | ABAT | Stock | 2.88 | 3.3699 | 2.52 | 2.97 | 1558522.0 |
| 2024-01-18 | ABBNY-DELISTED | Stock | 41.91 | 42.26 | 41.91 | 42.25 | 170662.0 |
| 2024-01-18 | ABBV | Stock | 161.16 | 163.66 | 161.0 | 163.3 | 5074300.0 |
| 2024-01-18 | ABCB | Stock | 49.69 | 50.12 | 49.45 | 49.9 | 260500.0 |
| 2024-01-18 | ABCL | Stock | 5.35 | 5.4 | 5.12 | 5.19 | 1231000.0 |
| 2024-01-18 | ABEO | Stock | 5.15 | 5.15 | 4.9 | 4.97 | 138800.0 |
| 2024-01-18 | ABEV | Stock | 2.67 | 2.7 | 2.66 | 2.7 | 6762800.0 |
| 2024-01-18 | ABG | Stock | 204.69 | 205.11 | 201.36 | 203.4 | 90100.0 |
| 2024-01-18 | ABLLW | Stock | 0.95 | 0.98 | 0.92 | 0.923 | 21191.0 |
| 2024-01-18 | ABLV | Stock | 2.71 | 2.91 | 2.6 | 2.6 | 149600.0 |
| 2024-01-18 | ABM | Stock | 41.66 | 41.92 | 41.15 | 41.91 | 405800.0 |
| 2024-01-18 | ABNB | Stock | 137.0 | 139.535 | 135.225 | 137.04 | 5273000.0 |
| 2024-01-18 | ABOS | Stock | 3.76 | 3.76 | 3.611 | 3.68 | 389000.0 |
| 2024-01-18 | ABR | Stock | 14.19 | 14.44 | 14.02 | 14.32 | 4268300.0 |
| 2024-01-18 | ABR.D | Stock | 17.82 | 17.86 | 17.4 | 17.55 | 23471.0 |
| 2024-01-18 | ABR.E | Stock | 17.63 | 17.69 | 17.41 | 17.4602 | 4515.0 |
| 2024-01-18 | ABR.F | Stock | 18.67 | 18.875 | 18.31 | 18.6 | 14966.0 |
| 2024-01-18 | ABSI | Stock | 3.66 | 3.71 | 3.52 | 3.62 | 957000.0 |
| 2024-01-18 | ABT | Stock | 114.2 | 114.57 | 113.41 | 114.02 | 5098000.0 |
> showing 50 of 7,230 rows — these rows as CSV