PREVIEW / stock_daily / 2004-01-27
file: by_date/stock_daily/2004/2004-01-27.parquet size: 125 KB rows: 3,655 symbols: 2,284
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-27 | AAPL | Stock | 0.4114 | 0.4152 | 0.4071 | 0.412 | 307070400.0 |
| 2004-01-27 | MSFT | Stock | 28.64 | 28.72 | 28.22 | 28.25 | 63196200.0 |
| 2004-01-27 | NVDA | Stock | 0.196 | 0.1992 | 0.1871 | 0.1886 | 934104000.0 |
| 2004-01-27 | AMZN | Stock | 2.8365 | 2.887 | 2.783 | 2.787 | 259282000.0 |
| 2004-01-27 | CL | Stock | 25.725 | 25.85 | 25.61 | 25.63 | 6221600.0 |
| 2004-01-27 | A | Stock | 26.7167 | 27.7539 | 25.7511 | 25.8226 | 30615082.0 |
| 2004-01-27 | AABA-DELISTED | Stock | 24.0349998474121 | 24.2250003814697 | 23.5 | 23.5200004577637 | 14656800.0 |
| 2004-01-27 | AAI-DELISTED | Stock | 13.41 | 13.6 | 13.08 | 13.09 | 1568200.0 |
| 2004-01-27 | AAIC-DELISTED | Stock | 510.0 | 515.8 | 494.4 | 497.0 | 1202500.0 |
| 2004-01-27 | AAME | Stock | 2.96 | 3.15 | 2.96 | 3.14 | 11000.0 |
| 2004-01-27 | AAON | Stock | 2.7391 | 2.8629 | 2.7391 | 2.8023 | 53916.0 |
| 2004-01-27 | AAP | Stock | 27.7533 | 27.7533 | 27.0 | 27.1467 | 1270950.0 |
| 2004-01-27 | AAXN-DELISTED | Stock | 11.2608337402344 | 12.2316665649414 | 11.1083335876465 | 11.1416664123535 | 23616000.0 |
| 2004-01-27 | ABAX-DELISTED | Stock | 23.2 | 23.45 | 20.3 | 20.7 | 1933053.0 |
| 2004-01-27 | ABB-DELISTED | Stock | 5.97 | 6.08 | 5.92 | 5.99 | 145800.0 |
| 2004-01-27 | ABC-DELISTED | Stock | 14.06 | 14.205 | 14.04 | 14.09 | 7698391.0 |
| 2004-01-27 | ABCB | Stock | 14.6707 | 15.003 | 14.6707 | 14.776 | 28992.0 |
| 2004-01-27 | ABCO-DELISTED | Stock | 18.003 | 18.467 | 18.003 | 18.287 | 294705.0 |
| 2004-01-27 | ABCW-DELISTED | Stock | 26.4 | 26.62 | 26.4 | 26.56 | 33300.0 |
| 2004-01-27 | ABE-DELISTED | Stock | 8.9 | 8.9 | 8.58 | 8.59 | 48500.0 |
| 2004-01-27 | ABFS-DELISTED | Stock | 30.3 | 30.68 | 29.28 | 29.8 | 479883.0 |
| 2004-01-27 | ABG | Stock | 19.05 | 19.05 | 18.78 | 18.95 | 15300.0 |
| 2004-01-27 | ABK-DELISTED | Stock | 73.47 | 74.0 | 72.84 | 73.11 | 463300.0 |
| 2004-01-27 | ABM | Stock | 18.65 | 18.83 | 18.42 | 18.54 | 70100.0 |
| 2004-01-27 | ABMD-DELISTED | Stock | 8.1 | 8.48 | 8.05 | 8.24 | 54230.0 |
| 2004-01-27 | ABP-DELISTED | Stock | 1.74 | 1.82 | 1.73 | 1.78 | 115500.0 |
| 2004-01-27 | ABT | Stock | 19.5586 | 19.7067 | 19.415 | 19.4778 | 9324553.0 |
| 2004-01-27 | ABTL-DELISTED | Stock | 61.1 | 67.65 | 60.3 | 63.65 | 454800.0 |
| 2004-01-27 | ABV-DELISTED | Stock | 26.4 | 26.93 | 26.15 | 26.6 | 373300.0 |
| 2004-01-27 | ABVA-DELISTED | Stock | 18.25 | 18.592 | 18.1 | 18.1 | 6558.0 |
| 2004-01-27 | ABVT-DELISTED | Stock | 52.86 | 57.0 | 52.0 | 57.0 | 8900.0 |
| 2004-01-27 | ABX-DELISTED | Stock | 20.17 | 20.8 | 20.1 | 20.44 | 2608000.0 |
| 2004-01-27 | ACAP-DELISTED | Stock | 19.15 | 19.29 | 18.86 | 19.0 | 50476.0 |
| 2004-01-27 | ACAS-DELISTED | Stock | 33.16 | 33.17 | 32.567 | 32.68 | 538117.0 |
| 2004-01-27 | ACAT-DELISTED | Stock | 27.16 | 27.16 | 26.64 | 26.64 | 34627.0 |
| 2004-01-27 | ACCL-DELISTED | Stock | 14.4098997116089 | 14.888500213623 | 14.4098997116089 | 14.888500213623 | 390500.0 |
| 2004-01-27 | ACE-DELISTED | Stock | 43.45 | 43.53 | 43.0 | 43.19 | 623858.0 |
| 2004-01-27 | ACF-DELISTED | Stock | 18.59 | 18.75 | 18.39 | 18.4 | 1422600.0 |
| 2004-01-27 | ACG-DELISTED | Stock | 8.8 | 8.84 | 8.78 | 8.82 | 448000.0 |
| 2004-01-27 | ACGL | Stock | 4.9422 | 5.0 | 4.94 | 4.9578 | 910800.0 |
| 2004-01-27 | ACGN-DELISTED | Stock | 1303.3288 | 1337.3288 | 1269.3288 | 1314.6712 | 87300.0 |
| 2004-01-27 | ACH | Stock | 16.0333 | 16.1 | 15.7667 | 15.96 | 100800.0 |
| 2004-01-27 | ACH-DELISTED | Stock | 17.55 | 17.64 | 17.15 | 17.265 | 420000.0 |
| 2004-01-27 | ACLS | Stock | 46.2 | 47.28 | 44.28 | 45.76 | 425200.0 |
| 2004-01-27 | ACO-DELISTED | Stock | 21.9 | 22.34 | 21.6 | 21.9 | 377800.0 |
| 2004-01-27 | ACPW-DELISTED | Stock | 20.14 | 20.54 | 19.352 | 19.55 | 49808.0 |
| 2004-01-27 | ACS-DELISTED | Stock | 54.61 | 54.89 | 53.81 | 54.16 | 1088900.0 |
| 2004-01-27 | ACTA-DELISTED | Stock | 10.0 | 10.0 | 9.4 | 9.4 | 2764300.0 |
| 2004-01-27 | ACTG | Stock | 6.6 | 6.73 | 6.39 | 6.64 | 134400.0 |
| 2004-01-27 | ACTI-DELISTED | Stock | 7.59 | 7.77 | 7.42 | 7.7 | 402383.0 |
> showing 50 of 3,655 rows — these rows as CSV