PREVIEW / stock_daily / 2013-12-04
file: by_date/stock_daily/2013/2013-12-04.parquet size: 216 KB rows: 6,450 symbols: 3,539
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-04 | AAPL | Stock | 20.1964 | 20.3282 | 20.0293 | 20.1786 | 377809600.0 |
| 2013-12-04 | MSFT | Stock | 38.21 | 38.98 | 38.12 | 38.94 | 51983600.0 |
| 2013-12-04 | NVDA | Stock | 0.3925 | 0.3998 | 0.3915 | 0.399 | 493176000.0 |
| 2013-12-04 | AMZN | Stock | 19.175 | 19.4845 | 19.0745 | 19.298 | 47106000.0 |
| 2013-12-04 | META | Stock | 46.46 | 48.77 | 46.26 | 48.62 | 60890000.0 |
| 2013-12-04 | TSLA | Stock | 9.6213 | 9.6287 | 9.142 | 9.2633 | 197215500.0 |
| 2013-12-04 | TLT | Stock | 102.75 | 103.05 | 102.38 | 102.72 | 8502926.0 |
| 2013-12-04 | ES | Stock | 40.71 | 41.31 | 40.6 | 41.12 | 1567900.0 |
| 2013-12-04 | CL | Stock | 64.94 | 65.14 | 64.32 | 65.04 | 2762600.0 |
| 2013-12-04 | A | Stock | 37.7969 | 38.505 | 37.711 | 38.3262 | 3377288.0 |
| 2013-12-04 | AABA-DELISTED | Stock | 36.47 | 38.15 | 36.25 | 38.12 | 25802774.0 |
| 2013-12-04 | AACG | Stock | 4.1 | 4.14 | 3.95 | 3.95 | 47600.0 |
| 2013-12-04 | AAIC-DELISTED | Stock | 25.9 | 26.5 | 25.8008 | 26.11 | 113385.0 |
| 2013-12-04 | AAMC-DELISTED | Stock | 256.25 | 260.2941 | 256.25 | 260.2941 | 1020.0 |
| 2013-12-04 | AAME | Stock | 4.02 | 4.04 | 4.02 | 4.04 | 900.0 |
| 2013-12-04 | AAMRQ-DELISTED | Stock | 10.715 | 10.82 | 10.11 | 10.17 | 15000273.0 |
| 2013-12-04 | AAOI | Stock | 12.38 | 12.91 | 12.3 | 12.89 | 75000.0 |
| 2013-12-04 | AAON | Stock | 12.8889 | 13.4133 | 12.7911 | 13.12 | 152550.0 |
| 2013-12-04 | AAP | Stock | 106.25 | 107.72 | 104.25 | 105.71 | 1425400.0 |
| 2013-12-04 | AAT | Stock | 31.57 | 31.9 | 31.09 | 31.51 | 103500.0 |
| 2013-12-04 | AAU-DELISTED | Stock | 1.05 | 1.09 | 1.03 | 1.04 | 225994.0 |
| 2013-12-04 | AAUAF-DELISTED | Stock | 1.05 | 1.09 | 1.03 | 1.04 | 226794.0 |
| 2013-12-04 | AAV-DELISTED | Stock | 4.02 | 4.07 | 3.99 | 4.07 | 163624.0 |
| 2013-12-04 | AAWW-DELISTED | Stock | 37.51 | 37.9 | 37.13 | 37.19 | 331272.0 |
| 2013-12-04 | AAXJ | Stock | 59.86 | 60.4 | 59.71 | 60.19 | 626101.0 |
| 2013-12-04 | AAXN-DELISTED | Stock | 16.36 | 16.38 | 15.78 | 16.0 | 1171231.0 |
| 2013-12-04 | AB | Stock | 22.37 | 22.78 | 22.2 | 22.64 | 257700.0 |
| 2013-12-04 | ABAC-DELISTED | Stock | 1.881 | 2.1 | 1.881 | 2.0 | 103554.0 |
| 2013-12-04 | ABAX-DELISTED | Stock | 35.75 | 36.01 | 35.64 | 35.79 | 121413.0 |
| 2013-12-04 | ABB-DELISTED | Stock | 24.6 | 24.898 | 24.57 | 24.86 | 1229368.0 |
| 2013-12-04 | ABBNY-DELISTED | Stock | 24.6 | 24.898 | 24.57 | 24.85 | 1271141.0 |
| 2013-12-04 | ABBV | Stock | 49.75 | 50.29 | 49.3 | 49.67 | 5309200.0 |
| 2013-12-04 | ABC-DELISTED | Stock | 70.35 | 70.82 | 68.78 | 69.45 | 2470019.0 |
| 2013-12-04 | ABCB | Stock | 19.96 | 20.33 | 19.57 | 19.81 | 52600.0 |
| 2013-12-04 | ABCD-DELISTED | Stock | 1.49 | 1.5 | 1.4201 | 1.47 | 5539.0 |
| 2013-12-04 | ABCO-DELISTED | Stock | 59.21 | 63.36 | 58.86 | 61.38 | 170315.0 |
| 2013-12-04 | ABE-DELISTED | Stock | 19.55 | 19.58 | 19.32 | 19.34 | 7358.0 |
| 2013-12-04 | ABEO | Stock | 312.5 | 337.5 | 312.5 | 337.5 | 12.0 |
| 2013-12-04 | ABEV | Stock | 7.09 | 7.15 | 6.91 | 7.09 | 14038300.0 |
| 2013-12-04 | ABFS-DELISTED | Stock | 33.48 | 34.74 | 33.48 | 34.41 | 534692.0 |
| 2013-12-04 | ABG | Stock | 51.05 | 52.39 | 50.33 | 50.78 | 354400.0 |
| 2013-12-04 | ABGB-DELISTED | Stock | 12.41 | 12.41 | 12.24 | 12.27 | 5100.0 |
| 2013-12-04 | ABM | Stock | 27.36 | 27.55 | 27.15 | 27.39 | 179900.0 |
| 2013-12-04 | ABMD-DELISTED | Stock | 28.03 | 28.03 | 26.8239 | 27.44 | 300295.0 |
| 2013-12-04 | ABR | Stock | 6.51 | 6.57 | 6.46 | 6.53 | 93900.0 |
| 2013-12-04 | ABR.A-DELISTED | Stock | 24.14 | 24.4899 | 24.14 | 24.18 | 1340.0 |
| 2013-12-04 | ABR.B-DELISTED | Stock | 22.15 | 22.15 | 22.15 | 22.15 | 100.0 |
| 2013-12-04 | ABT | Stock | 37.35 | 37.85 | 37.08 | 37.36 | 5092700.0 |
| 2013-12-04 | ABTL-DELISTED | Stock | 12.14 | 13.0 | 12.06 | 12.72 | 265210.0 |
| 2013-12-04 | ABUS | Stock | 8.32 | 8.4 | 8.02 | 8.18 | 119800.0 |
> showing 50 of 6,450 rows — these rows as CSV