PREVIEW / stock_daily / 2010-01-14
file: by_date/stock_daily/2010/2010-01-14.parquet size: 188 KB rows: 5,882 symbols: 3,491
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 |
|---|---|---|---|---|---|---|---|
| 2010-01-14 | AAPL | Stock | 7.5039 | 7.5164 | 7.465 | 7.4796 | 432894000.0 |
| 2010-01-14 | MSFT | Stock | 30.31 | 31.1 | 30.26 | 30.96 | 63228100.0 |
| 2010-01-14 | NVDA | Stock | 0.4422 | 0.4455 | 0.4332 | 0.4408 | 608524000.0 |
| 2010-01-14 | AMZN | Stock | 6.457 | 6.519 | 6.32 | 6.3675 | 195498000.0 |
| 2010-01-14 | TLT | Stock | 89.69 | 90.52 | 89.54 | 90.52 | 4188789.0 |
| 2010-01-14 | ES | Stock | 26.32 | 26.47 | 26.27 | 26.39 | 603000.0 |
| 2010-01-14 | CL | Stock | 40.39 | 40.49 | 40.075 | 40.21 | 5403800.0 |
| 2010-01-14 | A | Stock | 21.8813 | 22.3462 | 21.8169 | 22.2818 | 6163782.0 |
| 2010-01-14 | AABA-DELISTED | Stock | 16.82 | 17.23 | 16.8 | 17.13 | 16554243.0 |
| 2010-01-14 | AACC-DELISTED | Stock | 6.21 | 6.62 | 6.21 | 6.46 | 19628.0 |
| 2010-01-14 | AACG | Stock | 4.32 | 4.32 | 4.32 | 4.32 | 200.0 |
| 2010-01-14 | AAI-DELISTED | Stock | 5.47 | 5.59 | 5.44 | 5.53 | 6331795.0 |
| 2010-01-14 | AAIC-DELISTED | Stock | 15.98 | 16.7 | 15.98 | 16.17 | 22522.0 |
| 2010-01-14 | AAON | Stock | 3.919 | 3.9368 | 3.8973 | 3.9328 | 107831.0 |
| 2010-01-14 | AAP | Stock | 39.94 | 39.94 | 39.25 | 39.56 | 1157600.0 |
| 2010-01-14 | AATI-DELISTED | Stock | 3.88 | 4.02 | 3.87 | 3.99 | 240356.0 |
| 2010-01-14 | AAU-DELISTED | Stock | 1.3 | 1.3 | 1.2 | 1.22 | 265110.0 |
| 2010-01-14 | AAUAF-DELISTED | Stock | 1.3 | 1.3 | 1.2 | 1.22 | 274908.0 |
| 2010-01-14 | AAV-DELISTED | Stock | 7.08 | 7.1701 | 7.08 | 7.12 | 272776.0 |
| 2010-01-14 | AAWW-DELISTED | Stock | 40.04 | 40.5899 | 39.85 | 40.33 | 214275.0 |
| 2010-01-14 | AAXJ | Stock | 57.46 | 57.49 | 57.16 | 57.29 | 266550.0 |
| 2010-01-14 | AAXN-DELISTED | Stock | 6.28 | 6.69 | 6.26 | 6.4 | 2507018.0 |
| 2010-01-14 | AB | Stock | 28.51 | 29.77 | 28.25 | 29.47 | 875000.0 |
| 2010-01-14 | ABAX-DELISTED | Stock | 25.8 | 26.35 | 25.61 | 26.04 | 83241.0 |
| 2010-01-14 | ABB-DELISTED | Stock | 20.23 | 20.32 | 20.19 | 20.25 | 2870683.0 |
| 2010-01-14 | ABBC-DELISTED | Stock | 6.83 | 6.92 | 6.79 | 6.89 | 13370.0 |
| 2010-01-14 | ABBNY-DELISTED | Stock | 20.23 | 20.32 | 20.19 | 20.24 | 2901783.0 |
| 2010-01-14 | ABC-DELISTED | Stock | 26.97 | 27.25 | 26.85 | 27.23 | 2048701.0 |
| 2010-01-14 | ABCB | Stock | 7.6939 | 8.1383 | 7.6939 | 7.9013 | 28451.0 |
| 2010-01-14 | ABCD-DELISTED | Stock | 3.95 | 4.02 | 3.93 | 4.0 | 100700.0 |
| 2010-01-14 | ABCO-DELISTED | Stock | 16.005 | 16.15 | 15.97 | 16.015 | 183873.0 |
| 2010-01-14 | ABCW-DELISTED | Stock | 0.93 | 1.07 | 0.92 | 0.93 | 314830.0 |
| 2010-01-14 | ABD-DELISTED | Stock | 8.025 | 8.135 | 7.925 | 8.125 | 220980.0 |
| 2010-01-14 | ABE-DELISTED | Stock | 16.94 | 17.02 | 16.94 | 17.02 | 15041.0 |
| 2010-01-14 | ABEO | Stock | 3762.5 | 4087.5 | 3762.5 | 4062.5 | 7.0 |
| 2010-01-14 | ABFS-DELISTED | Stock | 27.99 | 29.2 | 27.78 | 28.79 | 622771.0 |
| 2010-01-14 | ABG | Stock | 13.06 | 13.21 | 12.99 | 13.06 | 114400.0 |
| 2010-01-14 | ABII-DELISTED | Stock | 41.49 | 41.56 | 40.55 | 41.37 | 29240.0 |
| 2010-01-14 | ABK-DELISTED | Stock | 0.81 | 0.81 | 0.7782 | 0.7811 | 8809217.0 |
| 2010-01-14 | ABM | Stock | 20.82 | 20.99 | 20.75 | 20.87 | 241300.0 |
| 2010-01-14 | ABMD-DELISTED | Stock | 7.95 | 8.26 | 7.92 | 8.23 | 237901.0 |
| 2010-01-14 | ABR | Stock | 2.36 | 2.38 | 2.28 | 2.35 | 102500.0 |
| 2010-01-14 | ABT | Stock | 26.4946 | 26.6865 | 26.389 | 26.5569 | 8982493.0 |
| 2010-01-14 | ABTL-DELISTED | Stock | 5.1 | 5.1 | 4.75 | 5.0 | 13661.0 |
| 2010-01-14 | ABV-DELISTED | Stock | 103.98 | 107.5 | 103.96 | 106.03 | 476305.0 |
| 2010-01-14 | ABVT-DELISTED | Stock | 63.0 | 63.74 | 62.18 | 62.2 | 36165.0 |
| 2010-01-14 | ABX-DELISTED | Stock | 40.65 | 40.85 | 39.95 | 40.49 | 8415338.0 |
| 2010-01-14 | ACAD | Stock | 1.4 | 1.62 | 1.37 | 1.55 | 2250200.0 |
| 2010-01-14 | ACAP-DELISTED | Stock | 30.56 | 31.16 | 30.48 | 30.93 | 31949.0 |
| 2010-01-14 | ACAS-DELISTED | Stock | 3.76 | 4.07 | 3.7 | 3.95 | 16285715.0 |
> showing 50 of 5,882 rows — these rows as CSV