PREVIEW / stock_daily / 2024-01-31
file: by_date/stock_daily/2024/2024-01-31.parquet size: 234 KB rows: 7,317 symbols: 1,176
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-31 | AAPL | Stock | 187.04 | 187.1 | 184.35 | 184.4 | 55467800.0 |
| 2024-01-31 | MSFT | Stock | 406.96 | 415.32 | 397.21 | 397.58 | 47871100.0 |
| 2024-01-31 | NVDA | Stock | 61.44 | 62.269 | 60.7 | 61.527 | 453795000.0 |
| 2024-01-31 | AMZN | Stock | 157.0 | 159.01 | 154.81 | 155.2 | 50284400.0 |
| 2024-01-31 | GOOGL | Stock | 143.62 | 144.0 | 139.87 | 140.1 | 71910044.0 |
| 2024-01-31 | META | Stock | 389.0 | 398.0 | 387.1 | 390.14 | 20180800.0 |
| 2024-01-31 | TSLA | Stock | 187.0 | 193.97 | 185.85 | 187.29 | 103221400.0 |
| 2024-01-31 | TLT | Stock | 96.22 | 96.91 | 96.0 | 96.66 | 80646722.0 |
| 2024-01-31 | ES | Stock | 54.95 | 55.48 | 54.06 | 54.22 | 6070200.0 |
| 2024-01-31 | CL | Stock | 84.39 | 84.95 | 83.91 | 84.2 | 6330600.0 |
| 2024-01-31 | A | Stock | 134.61 | 134.62 | 130.0 | 130.1 | 1101400.0 |
| 2024-01-31 | AA | Stock | 30.49 | 31.36 | 29.715 | 29.75 | 5760400.0 |
| 2024-01-31 | AACG | Stock | 1.08 | 1.1 | 1.08 | 1.09 | 1500.0 |
| 2024-01-31 | AACIW-DELISTED | Stock | 0.0215 | 0.0215 | 0.0215 | 0.0215 | 100.0 |
| 2024-01-31 | AACT | Stock | 10.5 | 10.52 | 10.49 | 10.5 | 124600.0 |
| 2024-01-31 | AAGR-DELISTED | Stock | 1.119 | 1.12 | 0.96 | 1.05 | 203992.0 |
| 2024-01-31 | AAGRW-DELISTED | Stock | 0.022 | 0.022 | 0.022 | 0.022 | 5000.0 |
| 2024-01-31 | AAL | Stock | 14.49 | 14.61 | 14.21 | 14.23 | 31538800.0 |
| 2024-01-31 | AAMC-DELISTED | Stock | 5.02 | 5.02 | 4.81 | 4.81 | 2600.0 |
| 2024-01-31 | AAME | Stock | 2.64 | 2.72 | 2.5 | 2.72 | 7600.0 |
| 2024-01-31 | AAMI | Stock | 22.34 | 22.74 | 22.08 | 22.12 | 558300.0 |
| 2024-01-31 | AAN-DELISTED | Stock | 10.77 | 10.89 | 10.26 | 10.29 | 335700.0 |
| 2024-01-31 | AAOI | Stock | 16.42 | 16.823 | 15.68 | 15.73 | 2262600.0 |
| 2024-01-31 | AAON | Stock | 73.81 | 73.81 | 70.14 | 70.16 | 488300.0 |
| 2024-01-31 | AAP | Stock | 67.51 | 68.71 | 66.51 | 66.85 | 1775200.0 |
| 2024-01-31 | AAT | Stock | 23.25 | 23.25 | 22.31 | 22.43 | 543000.0 |
| 2024-01-31 | AATC | Stock | 9.15 | 9.33 | 9.0205 | 9.12 | 50011.0 |
| 2024-01-31 | AAU-DELISTED | Stock | 0.135 | 0.1356 | 0.135 | 0.135 | 70473.0 |
| 2024-01-31 | AAUAF-DELISTED | Stock | 0.135 | 0.1356 | 0.135 | 0.135 | 71784.0 |
| 2024-01-31 | AAXJ | Stock | 63.12 | 63.63 | 62.92 | 63.05 | 995603.0 |
| 2024-01-31 | AB | Stock | 33.84 | 33.84 | 33.27 | 33.55 | 251800.0 |
| 2024-01-31 | ABAT | Stock | 2.8 | 2.81 | 2.65 | 2.7 | 571135.0 |
| 2024-01-31 | ABBNY-DELISTED | Stock | 43.09 | 43.14 | 42.24 | 42.38 | 226403.0 |
| 2024-01-31 | ABBV | Stock | 165.75 | 165.86 | 163.95 | 164.4 | 4993900.0 |
| 2024-01-31 | ABCB | Stock | 50.89 | 51.87 | 49.52 | 49.64 | 343600.0 |
| 2024-01-31 | ABCL | Stock | 5.25 | 5.36 | 5.11 | 5.11 | 958200.0 |
| 2024-01-31 | ABEO | Stock | 4.45 | 4.57 | 4.02 | 4.07 | 1057500.0 |
| 2024-01-31 | ABEV | Stock | 2.65 | 2.66 | 2.61 | 2.62 | 8409100.0 |
| 2024-01-31 | ABG | Stock | 214.95 | 219.1 | 208.65 | 209.06 | 225300.0 |
| 2024-01-31 | ABLLW | Stock | 0.91 | 0.95 | 0.89 | 0.95 | 37496.0 |
| 2024-01-31 | ABLV | Stock | 2.752 | 2.858 | 2.67 | 2.74 | 177100.0 |
| 2024-01-31 | ABLVW | Stock | 0.0207 | 0.0276 | 0.0205 | 0.0205 | 12253.0 |
| 2024-01-31 | ABM | Stock | 41.99 | 41.99 | 40.62 | 40.79 | 489400.0 |
| 2024-01-31 | ABNB | Stock | 148.645 | 148.74 | 143.92 | 144.14 | 4126600.0 |
| 2024-01-31 | ABOS | Stock | 3.28 | 3.36 | 3.17 | 3.18 | 267100.0 |
| 2024-01-31 | ABR | Stock | 14.0 | 14.05 | 13.27 | 13.3 | 8287000.0 |
| 2024-01-31 | ABR.D | Stock | 18.28 | 18.3795 | 18.01 | 18.1 | 28943.0 |
| 2024-01-31 | ABR.E | Stock | 18.1222 | 18.1222 | 17.79 | 17.79 | 3093.0 |
| 2024-01-31 | ABR.F | Stock | 18.7 | 18.87 | 18.5 | 18.5 | 36905.0 |
| 2024-01-31 | ABSI | Stock | 3.93 | 4.265 | 3.9 | 3.96 | 1405800.0 |
> showing 50 of 7,317 rows — these rows as CSV