PREVIEW / stock_daily / 2024-11-07
file: by_date/stock_daily/2024/2024-11-07.parquet size: 246 KB rows: 7,132 symbols: 653
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-11-07 | AAPL | Stock | 224.625 | 227.875 | 224.57 | 227.48 | 40519649.0 |
| 2024-11-07 | MSFT | Stock | 421.28 | 426.85 | 419.88 | 425.43 | 18248743.0 |
| 2024-11-07 | NVDA | Stock | 146.39 | 148.93 | 146.17 | 148.88 | 198676456.0 |
| 2024-11-07 | AMZN | Stock | 207.44 | 212.25 | 207.19 | 210.05 | 49794047.0 |
| 2024-11-07 | GOOGL | Stock | 177.41 | 181.08 | 177.19 | 180.75 | 25352939.0 |
| 2024-11-07 | META | Stock | 576.89 | 594.7999 | 575.21 | 591.7 | 14263324.0 |
| 2024-11-07 | TSLA | Stock | 288.89 | 299.75 | 285.52 | 296.91 | 114383552.0 |
| 2024-11-07 | TLT | Stock | 90.75 | 91.62 | 90.65 | 91.33 | 56221411.0 |
| 2024-11-07 | ES | Stock | 60.79 | 61.76 | 60.58 | 60.82 | 2770319.0 |
| 2024-11-07 | CL | Stock | 90.82 | 91.58 | 90.31 | 90.77 | 4408548.0 |
| 2024-11-07 | A | Stock | 138.79 | 140.07 | 137.57 | 139.63 | 2134701.0 |
| 2024-11-07 | AA | Stock | 46.18 | 46.55 | 45.58 | 45.69 | 5691875.0 |
| 2024-11-07 | AACG | Stock | 1.02 | 1.05 | 1.0 | 1.05 | 27822.0 |
| 2024-11-07 | AACT | Stock | 10.87 | 10.8751 | 10.86 | 10.87 | 17125.0 |
| 2024-11-07 | AAGR-DELISTED | Stock | 0.0002 | 0.0003 | 0.0002 | 0.0002 | 2598.0 |
| 2024-11-07 | AAL | Stock | 13.94 | 14.0 | 13.6 | 13.62 | 19548220.0 |
| 2024-11-07 | AAM | Stock | 10.06 | 10.06 | 10.04 | 10.06 | 109862.0 |
| 2024-11-07 | AAME | Stock | 1.6346 | 1.72 | 1.6346 | 1.6502 | 3727.0 |
| 2024-11-07 | AAMI | Stock | 29.72 | 29.895 | 28.94 | 29.32 | 198955.0 |
| 2024-11-07 | AAOI | Stock | 16.83 | 18.34 | 16.3 | 17.9 | 7488609.0 |
| 2024-11-07 | AAON | Stock | 120.76 | 121.18 | 118.6 | 119.1 | 605875.0 |
| 2024-11-07 | AAP | Stock | 39.0 | 39.27 | 38.53 | 38.98 | 1649842.0 |
| 2024-11-07 | AAT | Stock | 28.02 | 28.28 | 27.82 | 27.96 | 164637.0 |
| 2024-11-07 | AATC | Stock | 7.71 | 7.9225 | 7.71 | 7.9 | 5912.0 |
| 2024-11-07 | AAUAF-DELISTED | Stock | 0.0508 | 0.0529 | 0.0508 | 0.0508 | 39592.0 |
| 2024-11-07 | AAXJ | Stock | 78.07 | 78.76 | 78.0 | 78.61 | 509166.0 |
| 2024-11-07 | AB | Stock | 38.24 | 38.2885 | 37.5101 | 37.55 | 233232.0 |
| 2024-11-07 | ABAT | Stock | 0.99 | 1.01 | 0.9803 | 0.985 | 351421.0 |
| 2024-11-07 | ABBV | Stock | 201.95 | 202.315 | 199.215 | 200.51 | 4389723.0 |
| 2024-11-07 | ABCB | Stock | 70.4 | 70.75 | 68.71 | 69.32 | 638727.0 |
| 2024-11-07 | ABCL | Stock | 2.8 | 2.84 | 2.63 | 2.72 | 2345766.0 |
| 2024-11-07 | ABEO | Stock | 6.3 | 6.48 | 6.25 | 6.38 | 171258.0 |
| 2024-11-07 | ABEV | Stock | 2.24 | 2.25 | 2.21 | 2.23 | 26184370.0 |
| 2024-11-07 | ABG | Stock | 257.75 | 262.875 | 256.09 | 259.88 | 171920.0 |
| 2024-11-07 | ABLLW | Stock | 1.495 | 1.53 | 1.29 | 1.32 | 16131.0 |
| 2024-11-07 | ABLV | Stock | 0.96 | 0.97 | 0.95 | 0.9536 | 4582.0 |
| 2024-11-07 | ABM | Stock | 56.96 | 57.53 | 56.61 | 56.96 | 346503.0 |
| 2024-11-07 | ABNB | Stock | 141.76 | 148.64 | 141.7 | 147.37 | 11734878.0 |
| 2024-11-07 | ABOS | Stock | 3.23 | 3.29 | 3.16 | 3.17 | 174556.0 |
| 2024-11-07 | ABR | Stock | 15.03 | 15.3097 | 14.995 | 15.14 | 1913986.0 |
| 2024-11-07 | ABR.D | Stock | 19.1341 | 19.46 | 19.015 | 19.45 | 15364.0 |
| 2024-11-07 | ABR.E | Stock | 19.55 | 19.6 | 19.5 | 19.5 | 22946.0 |
| 2024-11-07 | ABR.F | Stock | 20.485 | 20.9015 | 20.45 | 20.45 | 12555.0 |
| 2024-11-07 | ABSI | Stock | 4.14 | 4.22 | 4.01 | 4.03 | 928323.0 |
| 2024-11-07 | ABT | Stock | 117.49 | 117.49 | 114.54 | 115.3 | 5362674.0 |
| 2024-11-07 | ABTC | Stock | 51.375 | 52.807500000000005 | 46.65 | 49.0875 | 14736.666666666666 |
| 2024-11-07 | ABTS | Stock | 8.148 | 8.7 | 8.1 | 8.4 | 1231.0 |
| 2024-11-07 | ABUS | Stock | 3.92 | 3.92 | 3.7 | 3.73 | 1015802.0 |
| 2024-11-07 | ABVC | Stock | 0.541 | 0.5499 | 0.533 | 0.5424 | 89651.0 |
| 2024-11-07 | ABVE | Stock | 0.412 | 0.449 | 0.4 | 0.43 | 28170.0 |
> showing 50 of 7,132 rows — these rows as CSV