PREVIEW / stock_daily / 2015-11-23

all stock daily files

  file:    by_date/stock_daily/2015/2015-11-23.parquet
  size:    222 KB
  rows:    6,637
  symbols: 3,403

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
2015-11-23	AAPL	Stock	29.8175	29.9325	29.335	29.4375	129930000.0
2015-11-23	MSFT	Stock	54.25	54.46	53.75	54.19	28235900.0
2015-11-23	NVDA	Stock	0.7912	0.7912	0.7702	0.773	242552000.0
2015-11-23	AMZN	Stock	33.575	34.1385	33.506	33.9495	87702000.0
2015-11-23	GOOGL	Stock	38.8735	39.145	38.6755	38.835	34648000.0
2015-11-23	META	Stock	107.19	107.47	106.08	106.95	19897200.0
2015-11-23	TSLA	Stock	14.49	14.612	14.312	14.5167	37893000.0
2015-11-23	TLT	Stock	120.53	121.12	120.32	120.82	5436264.0
2015-11-23	ES	Stock	51.5	51.69	50.98	51.13	1167100.0
2015-11-23	CL	Stock	66.1	66.94	66.07	66.89	2811100.0
2015-11-23	A	Stock	39.29	40.07	39.14	40.03	6473400.0
2015-11-23	AA.B-DELISTED	Stock	31.33	32.27	31.2101	31.69	56131.0
2015-11-23	AAAP-DELISTED	Stock	25.6	25.6	25.0	25.0	55738.0
2015-11-23	AABA-DELISTED	Stock	32.98	33.87	32.87	33.36	11279884.0
2015-11-23	AAC-DELISTED	Stock	23.13	24.5	23.13	23.67	132981.0
2015-11-23	AACG	Stock	5.41	5.71	5.28	5.5	72300.0
2015-11-23	AAIC-DELISTED	Stock	13.49	13.62	13.41	13.45	170810.0
2015-11-23	AAL	Stock	42.11	42.74	41.81	42.3	4166100.0
2015-11-23	AAMC-DELISTED	Stock	3.5294	4.0353	3.5294	3.9265	74433.0
2015-11-23	AAME	Stock	4.69	4.69	4.36	4.6	9100.0
2015-11-23	AAMI	Stock	15.95	16.13	15.89	16.05	104900.0
2015-11-23	AAOI	Stock	17.86	18.62	17.77	18.56	440900.0
2015-11-23	AAON	Stock	16.02	16.48	16.02	16.3067	223500.0
2015-11-23	AAP	Stock	162.68	164.5	161.5	162.62	895900.0
2015-11-23	AAT	Stock	40.15	40.36	39.97	40.14	58000.0
2015-11-23	AAU-DELISTED	Stock	0.5	0.51	0.5	0.51	38874.0
2015-11-23	AAUAF-DELISTED	Stock	0.5	0.51	0.5	0.51	38974.0
2015-11-23	AAV-DELISTED	Stock	5.2	5.34	5.2	5.25	45041.0
2015-11-23	AAVL-DELISTED	Stock	8.69	9.17	8.64	9.145	271960.0
2015-11-23	AAWW-DELISTED	Stock	40.29	41.39	40.02	40.7799	119900.0
2015-11-23	AAXJ	Stock	56.3	56.31	55.97	56.06	673663.0
2015-11-23	AAXN-DELISTED	Stock	18.28	18.425	18.01	18.24	1366937.0
2015-11-23	AB	Stock	25.75	26.09	25.71	25.87	221200.0
2015-11-23	ABAC-DELISTED	Stock	0.65	0.65	0.6	0.638	5928.0
2015-11-23	ABAX-DELISTED	Stock	51.93	55.15	51.93	54.96	208528.0
2015-11-23	ABB-DELISTED	Stock	18.59	18.67	18.42	18.48	1832004.0
2015-11-23	ABBNY-DELISTED	Stock	18.6	18.67	18.42	18.47	1872525.0
2015-11-23	ABBV	Stock	61.31	61.53	60.84	61.15	6405000.0
2015-11-23	ABC-DELISTED	Stock	99.0	99.0	98.4697	98.73	931427.0
2015-11-23	ABCB	Stock	33.95	34.22	33.91	34.11	207700.0
2015-11-23	ABCD-DELISTED	Stock	5.19	5.21	5.14	5.21	11114.0
2015-11-23	ABCO-DELISTED	Stock	50.92	52.23	50.35	51.62	188782.0
2015-11-23	ABCW-DELISTED	Stock	41.43	41.98	41.37	41.86	12633.0
2015-11-23	ABDC-DELISTED	Stock	11.86	12.181	11.785	11.91	30613.0
2015-11-23	ABE-DELISTED	Stock	11.26	11.28	11.21	11.26	12605.0
2015-11-23	ABEO	Stock	104.5	113.75	103.5	112.0	3016.0
2015-11-23	ABEOW-DELISTED	Stock	1.5	1.72	1.5	1.69	14000.0
2015-11-23	ABEV	Stock	5.14	5.17	5.04	5.06	12392000.0
2015-11-23	ABG	Stock	72.15	74.61	72.15	74.44	498200.0
2015-11-23	ABGB-DELISTED	Stock	4.77	4.84	4.71	4.71	18704.0

> showing 50 of 6,637 rows — these rows as CSV

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