PREVIEW / stock_daily / 2009-04-21
file: by_date/stock_daily/2009/2009-04-21.parquet size: 176 KB rows: 5,725 symbols: 3,409
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-21 | AAPL | Stock | 4.2461 | 4.3621 | 4.2357 | 4.3486 | 470685600.0 |
| 2009-04-21 | MSFT | Stock | 18.59 | 19.08 | 18.57 | 18.97 | 60928300.0 |
| 2009-04-21 | NVDA | Stock | 0.2725 | 0.287 | 0.2685 | 0.2755 | 932184000.0 |
| 2009-04-21 | AMZN | Stock | 3.8665 | 3.955 | 3.8645 | 3.937 | 143244000.0 |
| 2009-04-21 | TLT | Stock | 104.04 | 104.21 | 102.22 | 102.22 | 1802538.0 |
| 2009-04-21 | ES | Stock | 21.05 | 21.31 | 20.54 | 20.92 | 1841500.0 |
| 2009-04-21 | CL | Stock | 30.08 | 30.665 | 30.05 | 30.3 | 5864000.0 |
| 2009-04-21 | A | Stock | 11.8026 | 12.0386 | 11.6738 | 11.8741 | 4251458.0 |
| 2009-04-21 | AABA-DELISTED | Stock | 13.95 | 14.59 | 13.71 | 14.35 | 52114712.0 |
| 2009-04-21 | AACC-DELISTED | Stock | 6.07 | 6.64 | 6.07 | 6.63 | 15874.0 |
| 2009-04-21 | AACG | Stock | 4.3 | 4.34 | 4.12 | 4.2 | 14300.0 |
| 2009-04-21 | AAI-DELISTED | Stock | 5.32 | 5.77 | 5.2 | 5.56 | 3129202.0 |
| 2009-04-21 | AAIC-DELISTED | Stock | 5.6 | 6.4 | 5.6 | 6.2 | 507707.0 |
| 2009-04-21 | AAME | Stock | 0.7 | 0.7 | 0.6 | 0.6 | 6100.0 |
| 2009-04-21 | AAON | Stock | 3.2711 | 3.518 | 3.2356 | 3.4509 | 955294.0 |
| 2009-04-21 | AAP | Stock | 42.0 | 42.67 | 41.46 | 42.61 | 1032900.0 |
| 2009-04-21 | AATI-DELISTED | Stock | 4.68 | 4.82 | 4.57 | 4.82 | 311330.0 |
| 2009-04-21 | AAU-DELISTED | Stock | 0.62 | 0.62 | 0.5699 | 0.59 | 65440.0 |
| 2009-04-21 | AAUAF-DELISTED | Stock | 0.62 | 0.62 | 0.5699 | 0.59 | 66840.0 |
| 2009-04-21 | AAV-DELISTED | Stock | 2.73 | 2.92 | 2.67 | 2.81 | 962333.0 |
| 2009-04-21 | AAWW-DELISTED | Stock | 20.84 | 24.73 | 20.4601 | 24.25 | 249177.0 |
| 2009-04-21 | AAXJ | Stock | 36.32 | 37.23 | 36.3 | 37.22 | 52048.0 |
| 2009-04-21 | AAXN-DELISTED | Stock | 4.65 | 5.0 | 4.63 | 4.99 | 699074.0 |
| 2009-04-21 | AB | Stock | 18.38 | 19.6 | 17.84 | 19.28 | 623200.0 |
| 2009-04-21 | ABAX-DELISTED | Stock | 15.03 | 15.5 | 14.86 | 15.29 | 193911.0 |
| 2009-04-21 | ABB-DELISTED | Stock | 14.05 | 14.7 | 13.99 | 14.66 | 2752614.0 |
| 2009-04-21 | ABBC-DELISTED | Stock | 8.44 | 9.11 | 8.23 | 9.03 | 106422.0 |
| 2009-04-21 | ABBNY-DELISTED | Stock | 14.05 | 14.7 | 13.99 | 14.65 | 2753614.0 |
| 2009-04-21 | ABC-DELISTED | Stock | 17.21 | 17.52 | 17.0 | 17.27 | 3924292.0 |
| 2009-04-21 | ABCB | Stock | 6.0888 | 7.538 | 5.5441 | 7.3824 | 23441.0 |
| 2009-04-21 | ABCO-DELISTED | Stock | 8.695 | 8.805 | 8.335 | 8.53 | 181300.0 |
| 2009-04-21 | ABCW-DELISTED | Stock | 1.7 | 1.72 | 1.6 | 1.71 | 122040.0 |
| 2009-04-21 | ABD-DELISTED | Stock | 1.24 | 1.42 | 1.24 | 1.42 | 181850.0 |
| 2009-04-21 | ABE-DELISTED | Stock | 12.41 | 12.59 | 12.146 | 12.58 | 11620.0 |
| 2009-04-21 | ABEO | Stock | 1762.5 | 1812.5 | 1500.0 | 1812.5 | 14.0 |
| 2009-04-21 | ABFS-DELISTED | Stock | 21.93 | 22.82 | 21.3 | 22.77 | 535203.0 |
| 2009-04-21 | ABG | Stock | 5.98 | 6.93 | 5.98 | 6.7 | 359100.0 |
| 2009-04-21 | ABII-DELISTED | Stock | 43.51 | 56.602 | 43.51 | 56.13 | 35970.0 |
| 2009-04-21 | ABK-DELISTED | Stock | 0.86 | 1.1 | 0.82 | 1.04 | 11663307.0 |
| 2009-04-21 | ABM | Stock | 16.72 | 17.3 | 16.72 | 17.22 | 177800.0 |
| 2009-04-21 | ABMD-DELISTED | Stock | 5.21 | 5.53 | 5.12 | 5.52 | 298288.0 |
| 2009-04-21 | ABR | Stock | 1.4 | 1.4 | 1.24 | 1.31 | 146600.0 |
| 2009-04-21 | ABT | Stock | 21.2216 | 21.5574 | 21.0488 | 21.2887 | 19551897.0 |
| 2009-04-21 | ABTL-DELISTED | Stock | 2.1259 | 2.784 | 1.8728 | 2.05 | 111552.0 |
| 2009-04-21 | ABV-DELISTED | Stock | 50.74 | 52.75 | 50.0 | 52.56 | 541477.0 |
| 2009-04-21 | ABVA-DELISTED | Stock | 1.9 | 1.95 | 1.9 | 1.95 | 3556.0 |
| 2009-04-21 | ABX-DELISTED | Stock | 29.5 | 29.72 | 27.67 | 28.16 | 10939355.0 |
| 2009-04-21 | ACAD | Stock | 1.0 | 1.06 | 1.0 | 1.06 | 72400.0 |
| 2009-04-21 | ACAP-DELISTED | Stock | 40.14 | 41.66 | 40.14 | 41.49 | 37299.0 |
| 2009-04-21 | ACAS-DELISTED | Stock | 2.2593 | 2.6 | 2.1589 | 2.59 | 4281036.0 |
> showing 50 of 5,725 rows — these rows as CSV