PREVIEW / stock_daily / 2024-12-24
file: by_date/stock_daily/2024/2024-12-24.parquet size: 242 KB rows: 7,019 symbols: 546
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-12-24 | AAPL | Stock | 255.49 | 258.21 | 255.29 | 258.2 | 22420512.0 |
| 2024-12-24 | MSFT | Stock | 434.65 | 439.6 | 434.19 | 439.33 | 7015283.0 |
| 2024-12-24 | NVDA | Stock | 140.0 | 141.9 | 138.65 | 140.22 | 104017348.0 |
| 2024-12-24 | AMZN | Stock | 226.94 | 229.14 | 226.13 | 229.05 | 14710826.0 |
| 2024-12-24 | GOOGL | Stock | 194.84 | 196.11 | 193.78 | 196.11 | 10403259.0 |
| 2024-12-24 | META | Stock | 602.715 | 607.99 | 599.2849 | 607.75 | 4702090.0 |
| 2024-12-24 | TSLA | Stock | 435.9 | 462.78 | 435.14 | 462.28 | 59371086.0 |
| 2024-12-24 | TLT | Stock | 87.04 | 87.89 | 86.98 | 87.87 | 22377628.0 |
| 2024-12-24 | ES | Stock | 57.01 | 57.33 | 56.82 | 57.28 | 548232.0 |
| 2024-12-24 | CL | Stock | 91.83 | 92.495 | 91.7 | 92.39 | 1513599.0 |
| 2024-12-24 | A | Stock | 134.6 | 136.1 | 134.15 | 136.1 | 367372.0 |
| 2024-12-24 | AA | Stock | 39.0 | 39.21 | 38.2301 | 38.61 | 1054398.0 |
| 2024-12-24 | AACG | Stock | 0.8446 | 0.8446 | 0.79 | 0.79 | 3223.0 |
| 2024-12-24 | AACT | Stock | 11.0 | 11.0 | 10.96 | 10.96 | 4269.0 |
| 2024-12-24 | AAL | Stock | 17.0 | 17.36 | 16.8 | 17.35 | 14260574.0 |
| 2024-12-24 | AAM | Stock | 10.1 | 10.1 | 10.1 | 10.1 | 1939.0 |
| 2024-12-24 | AAME | Stock | 1.485 | 1.5 | 1.4701 | 1.485 | 1410.0 |
| 2024-12-24 | AAMI | Stock | 26.69 | 26.98 | 26.52 | 26.96 | 75530.0 |
| 2024-12-24 | AAOI | Stock | 36.75 | 40.1597 | 36.22 | 39.82 | 1815349.0 |
| 2024-12-24 | AAON | Stock | 123.22 | 124.12 | 122.0 | 123.44 | 245924.0 |
| 2024-12-24 | AAP | Stock | 43.77 | 43.98 | 42.87 | 43.73 | 527448.0 |
| 2024-12-24 | AAT | Stock | 26.07 | 26.25 | 25.94 | 26.25 | 75401.0 |
| 2024-12-24 | AATC | Stock | 7.983 | 7.983 | 7.983 | 7.983 | 271.0 |
| 2024-12-24 | AAUAF-DELISTED | Stock | 0.0357 | 0.047 | 0.0346 | 0.0375 | 66419.0 |
| 2024-12-24 | AAXJ | Stock | 73.25 | 73.61 | 73.25 | 73.55 | 96118.0 |
| 2024-12-24 | AB | Stock | 36.13 | 36.9898 | 36.0 | 36.8 | 139005.0 |
| 2024-12-24 | ABAT | Stock | 1.97 | 2.955 | 1.96 | 2.6 | 40169867.0 |
| 2024-12-24 | ABBV | Stock | 178.41 | 180.17 | 177.8408 | 180.0 | 2463558.0 |
| 2024-12-24 | ABCB | Stock | 63.31 | 63.69 | 62.78 | 63.58 | 123847.0 |
| 2024-12-24 | ABCL | Stock | 2.93 | 2.96 | 2.85 | 2.95 | 1649055.0 |
| 2024-12-24 | ABEO | Stock | 5.7 | 5.71 | 5.62 | 5.68 | 70352.0 |
| 2024-12-24 | ABEV | Stock | 1.92 | 1.92 | 1.89 | 1.9 | 10209136.0 |
| 2024-12-24 | ABG | Stock | 243.19 | 247.04 | 243.05 | 247.04 | 50009.0 |
| 2024-12-24 | ABLLW | Stock | 1.05 | 1.05 | 1.05 | 1.05 | 288.0 |
| 2024-12-24 | ABLV | Stock | 0.7245 | 0.74687 | 0.7245 | 0.74687 | 3576.0 |
| 2024-12-24 | ABM | Stock | 50.23 | 50.88 | 50.11 | 50.85 | 167318.0 |
| 2024-12-24 | ABNB | Stock | 134.33 | 135.07 | 132.83 | 134.99 | 1673649.0 |
| 2024-12-24 | ABOS | Stock | 1.8 | 1.83 | 1.73 | 1.79 | 280218.0 |
| 2024-12-24 | ABPWW | Stock | 0.14 | 0.14 | 0.1146 | 0.12 | 9964.0 |
| 2024-12-24 | ABR | Stock | 13.83 | 14.035 | 13.74 | 14.03 | 1054450.0 |
| 2024-12-24 | ABR.D | Stock | 19.04 | 19.0859 | 19.0 | 19.02 | 13320.0 |
| 2024-12-24 | ABR.E | Stock | 18.475 | 18.7 | 18.25 | 18.7 | 2463.0 |
| 2024-12-24 | ABR.F | Stock | 23.08 | 23.09 | 22.958 | 23.0 | 27508.0 |
| 2024-12-24 | ABSI | Stock | 2.92 | 3.03 | 2.875 | 3.01 | 1153875.0 |
| 2024-12-24 | ABT | Stock | 114.14 | 114.83 | 113.59 | 114.76 | 1462806.0 |
| 2024-12-24 | ABTC | Stock | 31.327499999999997 | 32.3475 | 30.749999999999996 | 32.205 | 3643.4 |
| 2024-12-24 | ABTS | Stock | 6.6765 | 6.9 | 6.675 | 6.7155 | 1036.0 |
| 2024-12-24 | ABUS | Stock | 3.21 | 3.21 | 3.11 | 3.18 | 369553.0 |
| 2024-12-24 | ABVC | Stock | 0.504 | 0.528 | 0.502 | 0.51 | 35929.0 |
| 2024-12-24 | ABVE | Stock | 0.526 | 0.54 | 0.5134 | 0.53 | 39998.0 |
> showing 50 of 7,019 rows — these rows as CSV