PREVIEW / stock_daily / 2024-12-17
file: by_date/stock_daily/2024/2024-12-17.parquet size: 248 KB rows: 7,212 symbols: 610
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-17 | AAPL | Stock | 250.08 | 253.83 | 249.78 | 253.48 | 48610770.0 |
| 2024-12-17 | MSFT | Stock | 451.01 | 455.29 | 449.57 | 454.46 | 19738297.0 |
| 2024-12-17 | NVDA | Stock | 129.09 | 131.59 | 126.86 | 130.39 | 250400610.0 |
| 2024-12-17 | AMZN | Stock | 232.39 | 232.73 | 227.85 | 231.15 | 33478594.0 |
| 2024-12-17 | GOOGL | Stock | 197.25 | 201.42 | 194.98 | 195.42 | 43504025.0 |
| 2024-12-17 | META | Stock | 626.17 | 632.37 | 616.54 | 619.44 | 12313305.0 |
| 2024-12-17 | TSLA | Stock | 475.9 | 483.99 | 457.5101 | 479.86 | 128580282.0 |
| 2024-12-17 | TLT | Stock | 90.52 | 90.985 | 90.455 | 90.64 | 23839892.0 |
| 2024-12-17 | ES | Stock | 57.86 | 59.03 | 57.715 | 58.51 | 1776333.0 |
| 2024-12-17 | CL | Stock | 92.5 | 93.9 | 92.42 | 93.49 | 5061596.0 |
| 2024-12-17 | A | Stock | 137.58 | 139.34 | 136.2 | 136.46 | 1963120.0 |
| 2024-12-17 | AA | Stock | 38.0 | 38.87 | 37.53 | 38.44 | 4351202.0 |
| 2024-12-17 | AACG | Stock | 0.9095 | 0.9198 | 0.856 | 0.86 | 13555.0 |
| 2024-12-17 | AACT | Stock | 10.92 | 10.95 | 10.92 | 10.94 | 241234.0 |
| 2024-12-17 | AAGR-DELISTED | Stock | 0.0001 | 0.0074 | 0.0001 | 0.0001 | 13618.0 |
| 2024-12-17 | AAL | Stock | 16.45 | 16.74 | 16.22 | 16.72 | 23396268.0 |
| 2024-12-17 | AAM | Stock | 10.18 | 10.18 | 10.07 | 10.085 | 10094.0 |
| 2024-12-17 | AAME | Stock | 1.46 | 1.55 | 1.45 | 1.55 | 9089.0 |
| 2024-12-17 | AAMI | Stock | 30.0 | 30.05 | 29.59 | 29.72 | 225174.0 |
| 2024-12-17 | AAOI | Stock | 34.95 | 35.005 | 31.33 | 32.11 | 3130520.0 |
| 2024-12-17 | AAON | Stock | 133.3 | 133.58 | 127.57 | 128.67 | 432752.0 |
| 2024-12-17 | AAP | Stock | 43.53 | 44.59 | 43.225 | 44.46 | 1417840.0 |
| 2024-12-17 | AAT | Stock | 27.58 | 27.73 | 27.37 | 27.5 | 286854.0 |
| 2024-12-17 | AATC | Stock | 8.0 | 8.0 | 7.926 | 7.93 | 17079.0 |
| 2024-12-17 | AAUAF-DELISTED | Stock | 0.0417 | 0.0449 | 0.04 | 0.0429 | 48326.0 |
| 2024-12-17 | AAXJ | Stock | 73.47 | 73.82 | 73.3 | 73.73 | 285398.0 |
| 2024-12-17 | AB | Stock | 35.5 | 35.77 | 35.19 | 35.45 | 968109.0 |
| 2024-12-17 | ABAT | Stock | 0.8834 | 0.918 | 0.83 | 0.86 | 530562.0 |
| 2024-12-17 | ABBV | Stock | 170.58 | 176.5 | 170.21 | 175.38 | 6576470.0 |
| 2024-12-17 | ABCB | Stock | 66.37 | 67.03 | 65.34 | 65.36 | 614854.0 |
| 2024-12-17 | ABCL | Stock | 2.9 | 2.93 | 2.77 | 2.79 | 2126263.0 |
| 2024-12-17 | ABEO | Stock | 5.86 | 6.0 | 5.81 | 5.88 | 152092.0 |
| 2024-12-17 | ABEV | Stock | 2.09 | 2.14 | 2.07 | 2.12 | 35767975.0 |
| 2024-12-17 | ABG | Stock | 254.66 | 256.9 | 251.84 | 252.3 | 178371.0 |
| 2024-12-17 | ABLLW | Stock | 1.16 | 1.19 | 1.11 | 1.12 | 28800.0 |
| 2024-12-17 | ABLV | Stock | 0.704 | 0.7351 | 0.7 | 0.735 | 2457.0 |
| 2024-12-17 | ABM | Stock | 56.32 | 56.545 | 54.67 | 54.91 | 413142.0 |
| 2024-12-17 | ABNB | Stock | 132.2 | 132.61 | 130.88 | 132.24 | 3071281.0 |
| 2024-12-17 | ABOS | Stock | 1.97 | 2.0299 | 1.91 | 1.96 | 355474.0 |
| 2024-12-17 | ABPWW | Stock | 0.03 | 0.03 | 0.0297 | 0.03 | 2109.0 |
| 2024-12-17 | ABR | Stock | 14.38 | 14.52 | 14.21 | 14.22 | 1815662.0 |
| 2024-12-17 | ABR.D | Stock | 19.31 | 19.31 | 19.0311 | 19.05 | 10818.0 |
| 2024-12-17 | ABR.E | Stock | 18.6 | 18.65 | 18.5628 | 18.65 | 3581.0 |
| 2024-12-17 | ABR.F | Stock | 22.7 | 22.94 | 22.5 | 22.94 | 18327.0 |
| 2024-12-17 | ABSI | Stock | 3.75 | 3.859 | 3.32 | 3.33 | 2314571.0 |
| 2024-12-17 | ABT | Stock | 112.21 | 113.84 | 112.2 | 113.29 | 5300002.0 |
| 2024-12-17 | ABTC | Stock | 39.765 | 40.9875 | 35.025 | 35.775 | 15532.333333333334 |
| 2024-12-17 | ABTS | Stock | 7.8 | 7.8 | 7.071 | 7.371 | 7437.0 |
| 2024-12-17 | ABUS | Stock | 3.49 | 3.59 | 3.431 | 3.46 | 1167698.0 |
| 2024-12-17 | ABVC | Stock | 0.499 | 0.5085 | 0.4595 | 0.4815 | 178925.0 |
> showing 50 of 7,212 rows — these rows as CSV