PREVIEW / stock_daily / 2009-04-14
file: by_date/stock_daily/2009/2009-04-14.parquet size: 177 KB rows: 5,768 symbols: 3,441
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 |
|---|---|---|---|---|---|---|---|
| 2009-04-14 | AAPL | Stock | 4.2704 | 4.2918 | 4.1875 | 4.2254 | 454622000.0 |
| 2009-04-14 | MSFT | Stock | 19.44 | 19.55 | 19.0 | 19.35 | 63796300.0 |
| 2009-04-14 | NVDA | Stock | 0.2872 | 0.3 | 0.286 | 0.293 | 711960000.0 |
| 2009-04-14 | AMZN | Stock | 3.9 | 3.973 | 3.847 | 3.861 | 123208000.0 |
| 2009-04-14 | TLT | Stock | 103.25 | 104.21 | 102.93 | 103.83 | 1335976.0 |
| 2009-04-14 | ES | Stock | 20.99 | 21.01 | 20.67 | 20.78 | 1329900.0 |
| 2009-04-14 | CL | Stock | 29.225 | 29.23 | 28.585 | 28.645 | 7471600.0 |
| 2009-04-14 | A | Stock | 11.917 | 11.9957 | 11.731 | 11.8169 | 3114185.0 |
| 2009-04-14 | AABA-DELISTED | Stock | 14.4 | 14.42 | 14.0 | 14.06 | 14591972.0 |
| 2009-04-14 | AACC-DELISTED | Stock | 6.68 | 6.68 | 6.15 | 6.19 | 38320.0 |
| 2009-04-14 | AACG | Stock | 4.5 | 4.55 | 4.35 | 4.35 | 71400.0 |
| 2009-04-14 | AAI-DELISTED | Stock | 5.51 | 5.67 | 5.14 | 5.27 | 2088340.0 |
| 2009-04-14 | AAIC-DELISTED | Stock | 6.4 | 6.8 | 6.0 | 6.0 | 542916.0 |
| 2009-04-14 | AAME | Stock | 0.6 | 0.68 | 0.6 | 0.68 | 4000.0 |
| 2009-04-14 | AAON | Stock | 3.5042 | 3.5042 | 3.1783 | 3.204 | 510300.0 |
| 2009-04-14 | AAP | Stock | 40.89 | 41.11 | 39.71 | 40.62 | 1608900.0 |
| 2009-04-14 | AATI-DELISTED | Stock | 4.27 | 4.5 | 4.19 | 4.43 | 651947.0 |
| 2009-04-14 | AAU-DELISTED | Stock | 0.6724 | 0.6724 | 0.62 | 0.65 | 31160.0 |
| 2009-04-14 | AAUAF-DELISTED | Stock | 0.6724 | 0.6724 | 0.62 | 0.65 | 32160.0 |
| 2009-04-14 | AAV-DELISTED | Stock | 2.72 | 2.99 | 2.67 | 2.93 | 1265130.0 |
| 2009-04-14 | AAWW-DELISTED | Stock | 21.88 | 22.28 | 20.85 | 21.69 | 219926.0 |
| 2009-04-14 | AAXJ | Stock | 37.16 | 37.444 | 36.91 | 37.07 | 28941.0 |
| 2009-04-14 | AAXN-DELISTED | Stock | 5.27 | 5.36 | 4.86 | 4.88 | 894736.0 |
| 2009-04-14 | AB | Stock | 19.02 | 19.76 | 18.7 | 18.94 | 778400.0 |
| 2009-04-14 | ABAX-DELISTED | Stock | 15.61 | 15.94 | 15.2 | 15.61 | 507438.0 |
| 2009-04-14 | ABB-DELISTED | Stock | 15.08 | 15.299 | 14.885 | 14.99 | 3187805.0 |
| 2009-04-14 | ABBC-DELISTED | Stock | 8.8 | 8.98 | 8.5 | 8.76 | 111739.0 |
| 2009-04-14 | ABBNY-DELISTED | Stock | 15.08 | 15.299 | 14.885 | 14.99 | 3192205.0 |
| 2009-04-14 | ABC-DELISTED | Stock | 16.64 | 16.64 | 16.4 | 16.57 | 1753486.0 |
| 2009-04-14 | ABCB | Stock | 7.3046 | 7.3046 | 6.7793 | 6.7988 | 24881.0 |
| 2009-04-14 | ABCO-DELISTED | Stock | 8.99 | 9.315 | 8.94 | 9.01 | 128480.0 |
| 2009-04-14 | ABCW-DELISTED | Stock | 1.5 | 1.7 | 1.45 | 1.61 | 171660.0 |
| 2009-04-14 | ABD-DELISTED | Stock | 1.25 | 1.27 | 1.13 | 1.14 | 404000.0 |
| 2009-04-14 | ABE-DELISTED | Stock | 13.1 | 13.1699 | 13.07 | 13.1 | 7297.0 |
| 2009-04-14 | ABEO | Stock | 1887.5 | 2050.0 | 1887.5 | 2050.0 | 3.0 |
| 2009-04-14 | ABFS-DELISTED | Stock | 22.08 | 24.22 | 21.63 | 23.31 | 1095545.0 |
| 2009-04-14 | ABG | Stock | 5.59 | 6.24 | 5.57 | 5.89 | 1236500.0 |
| 2009-04-14 | ABII-DELISTED | Stock | 44.35 | 45.5 | 43.81 | 44.0456 | 12217.0 |
| 2009-04-14 | ABK-DELISTED | Stock | 1.13 | 1.13 | 0.9805 | 1.03 | 15694551.0 |
| 2009-04-14 | ABM | Stock | 17.1 | 17.27 | 16.7 | 16.95 | 229400.0 |
| 2009-04-14 | ABMD-DELISTED | Stock | 5.57 | 5.65 | 5.39 | 5.39 | 309819.0 |
| 2009-04-14 | ABR | Stock | 1.03 | 1.35 | 1.03 | 1.16 | 657000.0 |
| 2009-04-14 | ABT | Stock | 21.3655 | 21.5478 | 21.188 | 21.4519 | 28324510.0 |
| 2009-04-14 | ABTL-DELISTED | Stock | 1.3002 | 1.3503 | 1.2502 | 1.3498 | 20224.0 |
| 2009-04-14 | ABV-DELISTED | Stock | 51.66 | 53.05 | 51.48 | 51.8 | 1135050.0 |
| 2009-04-14 | ABVA-DELISTED | Stock | 1.95 | 1.9999 | 1.95 | 1.982 | 19800.0 |
| 2009-04-14 | ABVT-DELISTED | Stock | 49.0 | 49.0 | 48.0 | 48.0 | 1021.0 |
| 2009-04-14 | ABX-DELISTED | Stock | 29.07 | 29.66 | 28.75 | 29.15 | 9557266.0 |
| 2009-04-14 | ACAD | Stock | 1.03 | 1.08 | 0.98 | 0.98 | 238000.0 |
| 2009-04-14 | ACAP-DELISTED | Stock | 41.74 | 41.83 | 39.95 | 40.59 | 59609.0 |
> showing 50 of 5,768 rows — these rows as CSV