PREVIEW / stock_daily / 2010-09-21

all stock daily files

  file:    by_date/stock_daily/2010/2010-09-21.parquet
  size:    191 KB
  rows:    5,961
  symbols: 3,500

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-09-21	AAPL	Stock	10.1379	10.2625	10.0996	10.1346	668074400.0
2010-09-21	MSFT	Stock	25.42	25.42	25.08	25.15	52675700.0
2010-09-21	NVDA	Stock	0.2663	0.2868	0.2663	0.2822	1779624000.0
2010-09-21	AMZN	Stock	7.538	7.6655	7.48	7.5365	150840000.0
2010-09-21	TSLA	Stock	1.3927	1.4367	1.378	1.3847	11940000.0
2010-09-21	TLT	Stock	102.67	104.02	102.26	103.68	12665916.0
2010-09-21	ES	Stock	29.55	29.57	29.17	29.23	2067500.0
2010-09-21	CL	Stock	39.075	39.5	38.94	39.275	8600200.0
2010-09-21	A	Stock	22.1602	22.3891	22.0243	22.2818	4078525.0
2010-09-21	AABA-DELISTED	Stock	13.94	14.26	13.92	14.18	32206984.0
2010-09-21	AACC-DELISTED	Stock	4.12	4.58	3.9	4.46	47816.0
2010-09-21	AACG	Stock	2.9	3.0	2.9	2.9	28500.0
2010-09-21	AAI-DELISTED	Stock	4.46	4.54	4.45	4.48	1506686.0
2010-09-21	AAIC-DELISTED	Stock	22.95	23.95	22.95	23.81	109973.0
2010-09-21	AAME	Stock	1.85	1.85	1.82	1.82	11300.0
2010-09-21	AAON	Stock	4.7822	4.7822	4.5412	4.5649	517894.0
2010-09-21	AAP	Stock	59.28	59.28	58.0	58.41	1305300.0
2010-09-21	AATI-DELISTED	Stock	3.48	3.48	3.45	3.46	56013.0
2010-09-21	AAU-DELISTED	Stock	2.63	2.63	2.52	2.6	273914.0
2010-09-21	AAUAF-DELISTED	Stock	2.63	2.63	2.52	2.6	274344.0
2010-09-21	AAV-DELISTED	Stock	6.23	6.26	6.12	6.21	289496.0
2010-09-21	AAWW-DELISTED	Stock	54.41	55.75	52.67	53.18	1692495.0
2010-09-21	AAXJ	Stock	59.35	59.38	58.88	59.07	344187.0
2010-09-21	AAXN-DELISTED	Stock	3.98	4.01	3.95	3.95	215228.0
2010-09-21	AB	Stock	26.36	26.38	25.98	26.15	181000.0
2010-09-21	ABAC-DELISTED	Stock	3.85	3.87	3.7801	3.7801	4700.0
2010-09-21	ABAX-DELISTED	Stock	21.89	22.38	21.14	22.1	133569.0
2010-09-21	ABB-DELISTED	Stock	21.12	21.2	20.83	21.05	1773367.0
2010-09-21	ABBC-DELISTED	Stock	10.13	10.48	10.13	10.43	28074.0
2010-09-21	ABBNY-DELISTED	Stock	21.12	21.2	20.83	21.06	3279140.0
2010-09-21	ABC-DELISTED	Stock	30.64	30.84	30.43	30.81	2768332.0
2010-09-21	ABCB	Stock	8.95	9.33	8.87	9.05	35500.0
2010-09-21	ABCD-DELISTED	Stock	3.29	3.2921	3.15	3.27	20527.0
2010-09-21	ABCO-DELISTED	Stock	21.75	22.04	21.36	21.78	72730.0
2010-09-21	ABCW-DELISTED	Stock	0.69	0.71	0.67	0.68	24690.0
2010-09-21	ABD-DELISTED	Stock	6.3	6.38	6.01	6.09	481890.0
2010-09-21	ABE-DELISTED	Stock	17.86	18.03	17.77	17.97	29061.0
2010-09-21	ABEO	Stock	2737.5	2812.5	2625.0	2625.0	114.0
2010-09-21	ABFS-DELISTED	Stock	24.41	25.01	23.81	24.01	323437.0
2010-09-21	ABG	Stock	13.0	13.16	12.68	12.91	124900.0
2010-09-21	ABII-DELISTED	Stock	75.41	75.94	75.23	75.85	40297.0
2010-09-21	ABK-DELISTED	Stock	0.5654	0.5799	0.5512	0.56	3813455.0
2010-09-21	ABM	Stock	21.86	22.0	21.81	21.84	314300.0
2010-09-21	ABMD-DELISTED	Stock	10.74	10.885	10.62	10.68	128083.0
2010-09-21	ABR	Stock	5.11	5.11	4.85	5.05	95900.0
2010-09-21	ABT	Stock	25.1223	25.1223	24.8296	25.0216	11983535.0
2010-09-21	ABTL-DELISTED	Stock	4.5	4.5	4.15	4.25	29294.0
2010-09-21	ABV-DELISTED	Stock	119.83	120.36	118.29	119.76	583553.0
2010-09-21	ABVA-DELISTED	Stock	2.95	2.99	2.9401	2.99	400.0
2010-09-21	ABVT-DELISTED	Stock	52.61	52.85	51.33	51.81	133247.0

> showing 50 of 5,961 rows — these rows as CSV

> unlock the full archive -- $79 one-time