PREVIEW / stock_daily / 2024-03-27
file: by_date/stock_daily/2024/2024-03-27.parquet size: 233 KB rows: 7,259 symbols: 1,039
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-03-27 | AAPL | Stock | 170.41 | 173.6 | 170.11 | 173.31 | 60273300.0 |
| 2024-03-27 | MSFT | Stock | 424.44 | 424.45 | 419.01 | 421.43 | 16705000.0 |
| 2024-03-27 | NVDA | Stock | 93.112 | 93.24 | 89.123 | 90.25 | 586067000.0 |
| 2024-03-27 | AMZN | Stock | 179.88 | 180.0 | 177.31 | 179.83 | 33272600.0 |
| 2024-03-27 | GOOGL | Stock | 151.18 | 151.635 | 148.9 | 150.87 | 22879178.0 |
| 2024-03-27 | META | Stock | 499.3 | 499.89 | 488.07 | 493.86 | 9989700.0 |
| 2024-03-27 | TSLA | Stock | 181.41 | 181.91 | 176.0 | 179.83 | 81804000.0 |
| 2024-03-27 | TLT | Stock | 93.99 | 94.7 | 93.94 | 94.7 | 50157816.0 |
| 2024-03-27 | ES | Stock | 56.91 | 58.99 | 56.91 | 58.98 | 2840900.0 |
| 2024-03-27 | CL | Stock | 89.6 | 90.27 | 89.33 | 89.95 | 4078600.0 |
| 2024-03-27 | A | Stock | 145.65 | 147.48 | 144.53 | 147.37 | 1212200.0 |
| 2024-03-27 | AA | Stock | 31.72 | 33.23 | 31.67 | 33.21 | 6439000.0 |
| 2024-03-27 | AACG | Stock | 1.16 | 1.17 | 1.02 | 1.12 | 55600.0 |
| 2024-03-27 | AACIU | Stock | 11.45 | 12.0 | 11.4 | 11.9 | 3628.0 |
| 2024-03-27 | AACIW-DELISTED | Stock | 0.0799 | 0.08 | 0.0755 | 0.0789 | 1194.0 |
| 2024-03-27 | AACT | Stock | 10.56 | 10.565 | 10.56 | 10.565 | 55100.0 |
| 2024-03-27 | AAGR-DELISTED | Stock | 0.39 | 0.4166 | 0.367 | 0.39 | 119267.0 |
| 2024-03-27 | AAL | Stock | 15.0 | 15.3 | 14.9 | 15.3 | 24789300.0 |
| 2024-03-27 | AAMC-DELISTED | Stock | 3.45 | 3.45 | 3.45 | 3.45 | 400.0 |
| 2024-03-27 | AAME | Stock | 2.6 | 2.8 | 2.6 | 2.8 | 17200.0 |
| 2024-03-27 | AAMI | Stock | 22.77 | 22.85 | 22.65 | 22.76 | 169900.0 |
| 2024-03-27 | AAN-DELISTED | Stock | 7.09 | 7.43 | 7.09 | 7.41 | 238400.0 |
| 2024-03-27 | AAOI | Stock | 14.44 | 14.5 | 13.89 | 13.96 | 1376800.0 |
| 2024-03-27 | AAON | Stock | 87.0 | 87.55 | 85.65 | 86.67 | 254100.0 |
| 2024-03-27 | AAP | Stock | 84.88 | 85.93 | 84.77 | 85.32 | 2264200.0 |
| 2024-03-27 | AAT | Stock | 21.3 | 21.68 | 21.3 | 21.64 | 206200.0 |
| 2024-03-27 | AATC | Stock | 6.4225 | 6.43 | 5.75 | 6.1 | 48345.0 |
| 2024-03-27 | AAU-DELISTED | Stock | 0.1401 | 0.1407 | 0.14 | 0.14 | 259960.0 |
| 2024-03-27 | AAUAF-DELISTED | Stock | 0.1401 | 0.1407 | 0.14 | 0.14 | 261304.0 |
| 2024-03-27 | AAXJ | Stock | 67.42 | 67.56 | 67.335 | 67.54 | 885440.0 |
| 2024-03-27 | AB | Stock | 34.21 | 34.9 | 34.16 | 34.75 | 350900.0 |
| 2024-03-27 | ABAT | Stock | 1.74 | 1.74 | 1.59 | 1.6 | 1088428.0 |
| 2024-03-27 | ABBV | Stock | 179.8 | 180.58 | 178.81 | 180.35 | 5073500.0 |
| 2024-03-27 | ABCB | Stock | 46.45 | 48.16 | 46.23 | 48.14 | 459200.0 |
| 2024-03-27 | ABCL | Stock | 4.31 | 4.51 | 4.27 | 4.49 | 1337800.0 |
| 2024-03-27 | ABEO | Stock | 7.47 | 7.61 | 7.28 | 7.34 | 131100.0 |
| 2024-03-27 | ABEV | Stock | 2.46 | 2.48 | 2.45 | 2.48 | 14230000.0 |
| 2024-03-27 | ABG | Stock | 228.3 | 234.34 | 227.03 | 233.73 | 129700.0 |
| 2024-03-27 | ABLLW | Stock | 0.614 | 0.614 | 0.577 | 0.578 | 29131.0 |
| 2024-03-27 | ABLV | Stock | 2.5 | 2.5 | 2.12 | 2.24 | 112700.0 |
| 2024-03-27 | ABLVW | Stock | 0.0429 | 0.0709 | 0.0408 | 0.0491 | 50828.0 |
| 2024-03-27 | ABM | Stock | 44.03 | 44.42 | 43.93 | 44.41 | 798400.0 |
| 2024-03-27 | ABNB | Stock | 169.11 | 169.11 | 165.5 | 166.41 | 3921900.0 |
| 2024-03-27 | ABOS | Stock | 3.75 | 4.28 | 3.7 | 4.1 | 600400.0 |
| 2024-03-27 | ABR | Stock | 12.93 | 13.42 | 12.93 | 13.39 | 4615900.0 |
| 2024-03-27 | ABR.D | Stock | 19.05 | 19.185 | 18.98 | 19.13 | 11263.0 |
| 2024-03-27 | ABR.E | Stock | 19.05 | 20.36 | 19.0 | 19.5 | 14516.0 |
| 2024-03-27 | ABR.F | Stock | 19.39 | 19.725 | 19.39 | 19.68 | 47443.0 |
| 2024-03-27 | ABSI | Stock | 5.27 | 5.655 | 5.145 | 5.54 | 1449800.0 |
| 2024-03-27 | ABT | Stock | 112.0 | 113.7 | 111.94 | 113.48 | 7533400.0 |
> showing 50 of 7,259 rows — these rows as CSV