PREVIEW / stock_daily / 2012-11-23

all stock daily files

  file:    by_date/stock_daily/2012/2012-11-23.parquet
  size:    191 KB
  rows:    5,947
  symbols: 3,333

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
2012-11-23	AAPL	Stock	20.2561	20.4286	20.0929	20.4107	272826400.0
2012-11-23	MSFT	Stock	27.23	27.77	27.2	27.7	57845700.0
2012-11-23	NVDA	Stock	0.2968	0.301	0.2952	0.2975	276932000.0
2012-11-23	AMZN	Stock	11.9945	12.0	11.824	11.994	35536000.0
2012-11-23	META	Stock	24.58	24.68	23.88	24.0	29520900.0
2012-11-23	TSLA	Stock	2.1733	2.1887	2.1133	2.142	6454500.0
2012-11-23	TLT	Stock	124.3	124.45	124.11	124.21	987173.0
2012-11-23	ES	Stock	37.93	38.16	37.53	37.73	737100.0
2012-11-23	CL	Stock	53.255	54.0	53.24	54.0	1423600.0
2012-11-23	A	Stock	25.8655	26.402	25.7582	26.3805	3140327.0
2012-11-23	AABA-DELISTED	Stock	18.5	18.59	18.4	18.57	7613700.0
2012-11-23	AACC-DELISTED	Stock	4.32	4.41	4.23	4.33	12481.0
2012-11-23	AACG	Stock	4.41	4.56	4.41	4.56	200.0
2012-11-23	AAIC-DELISTED	Stock	21.09	21.09	20.881	21.09	54943.0
2012-11-23	AAME	Stock	2.93	2.93	2.93	2.93	300.0
2012-11-23	AAMRQ-DELISTED	Stock	0.425	0.455	0.42	0.45	3457540.0
2012-11-23	AAON	Stock	6.0415	6.0919	5.9822	6.0474	38813.0
2012-11-23	AAP	Stock	77.83	79.12	77.64	79.04	198500.0
2012-11-23	AAT	Stock	27.76	27.93	27.45	27.74	34500.0
2012-11-23	AAU-DELISTED	Stock	2.56	2.57	2.55	2.57	21834.0
2012-11-23	AAUAF-DELISTED	Stock	2.56	2.57	2.55	2.57	22315.0
2012-11-23	AAV-DELISTED	Stock	3.4	3.51	3.37	3.39	342854.0
2012-11-23	AAWW-DELISTED	Stock	42.49	42.49	41.53	42.46	115805.0
2012-11-23	AAXJ	Stock	57.14	57.549	57.14	57.46	151137.0
2012-11-23	AAXN-DELISTED	Stock	8.14	8.2	8.01	8.08	131100.0
2012-11-23	AB	Stock	18.0	18.29	17.88	18.24	222100.0
2012-11-23	ABAC-DELISTED	Stock	0.77	0.83	0.76	0.8	12400.0
2012-11-23	ABAX-DELISTED	Stock	36.86	36.98	36.44	36.77	30101.0
2012-11-23	ABB-DELISTED	Stock	18.79	18.85	18.7	18.79	1439797.0
2012-11-23	ABBNY-DELISTED	Stock	18.79	18.85	18.7	18.81	1439797.0
2012-11-23	ABC-DELISTED	Stock	40.85	41.49	40.82	41.37	1360916.0
2012-11-23	ABCB	Stock	10.83	10.89	10.79	10.87	19200.0
2012-11-23	ABCD-DELISTED	Stock	1.0	1.12	0.92	1.1099	6284.0
2012-11-23	ABCO-DELISTED	Stock	43.57	43.66	43.1	43.58	61613.0
2012-11-23	ABCW-DELISTED	Stock	0.35	0.42	0.35	0.42	11675.0
2012-11-23	ABE-DELISTED	Stock	20.28	20.28	20.28	20.28	200.0
2012-11-23	ABEO	Stock	312.5	312.5	312.5	312.5	64.0
2012-11-23	ABFS-DELISTED	Stock	7.43	7.54	7.36	7.52	143614.0
2012-11-23	ABG	Stock	30.01	30.76	29.88	30.76	114300.0
2012-11-23	ABM	Stock	18.71	18.97	18.71	18.97	61500.0
2012-11-23	ABMD-DELISTED	Stock	14.0	14.4	13.8	14.25	204926.0
2012-11-23	ABR	Stock	5.16	5.23	5.16	5.2	31400.0
2012-11-23	ABT	Stock	30.4577	30.9423	30.4385	30.9327	5827845.0
2012-11-23	ABTL-DELISTED	Stock	3.902	3.902	3.85	3.86	4836.0
2012-11-23	ABUS	Stock	5.15	5.2	4.95	5.19	48400.0
2012-11-23	ABV-DELISTED	Stock	40.33	41.09	40.32	40.87	664525.0
2012-11-23	ABVA-DELISTED	Stock	4.95	5.08	4.5	4.5	18343.0
2012-11-23	ABX-DELISTED	Stock	35.05	35.65	34.66	35.56	5008375.0
2012-11-23	ACAD	Stock	2.19	2.24	2.15	2.22	1077600.0
2012-11-23	ACAS-DELISTED	Stock	11.705	11.815	11.655	11.805	907122.0

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

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