PREVIEW / stock_daily / 2013-09-09

all stock daily files

  file:    by_date/stock_daily/2013/2013-09-09.parquet
  size:    213 KB
  rows:    6,395
  symbols: 3,536

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-09-09	AAPL	Stock	18.0357	18.14	17.9814	18.0775	340687200.0
2013-09-09	MSFT	Stock	31.22	31.79	31.2	31.66	49628500.0
2013-09-09	NVDA	Stock	0.375	0.3783	0.374	0.3783	246408000.0
2013-09-09	AMZN	Stock	14.861	14.998	14.83	14.9855	32872000.0
2013-09-09	META	Stock	44.36	44.79	43.7	44.04	75794700.0
2013-09-09	TSLA	Stock	10.8747	10.9667	10.5673	10.7133	215167500.0
2013-09-09	TLT	Stock	103.8	103.8101	103.08	103.1	6875104.0
2013-09-09	ES	Stock	40.26	40.71	40.12	40.66	4325400.0
2013-09-09	CL	Stock	58.0	58.78	58.0	58.57	2094000.0
2013-09-09	A	Stock	34.0415	34.3705	33.8269	34.299	2333122.0
2013-09-09	AABA-DELISTED	Stock	28.32	29.32	28.32	29.24	21035851.0
2013-09-09	AACG	Stock	4.75	4.99	4.75	4.9	1600.0
2013-09-09	AAIC-DELISTED	Stock	23.47	24.28	23.24	24.26	223986.0
2013-09-09	AAMC-DELISTED	Stock	102.9412	111.3235	102.9412	108.8235	38794.0
2013-09-09	AAME	Stock	3.83	3.94	3.75	3.94	24400.0
2013-09-09	AAMRQ-DELISTED	Stock	3.245	3.38	3.18	3.29	4100762.0
2013-09-09	AAON	Stock	11.0222	11.2578	11.0222	11.2089	206100.0
2013-09-09	AAP	Stock	79.31	79.96	79.31	79.64	406900.0
2013-09-09	AAT	Stock	29.41	29.89	29.15	29.87	63000.0
2013-09-09	AAU-DELISTED	Stock	1.69	1.69	1.65	1.65	52860.0
2013-09-09	AAUAF-DELISTED	Stock	1.69	1.69	1.65	1.65	53060.0
2013-09-09	AAV-DELISTED	Stock	3.84	3.94	3.81	3.87	122061.0
2013-09-09	AAWW-DELISTED	Stock	46.48	47.52	46.48	47.38	155995.0
2013-09-09	AAXJ	Stock	57.54	58.434	57.54	58.36	716851.0
2013-09-09	AAXN-DELISTED	Stock	12.16	12.3	11.98	12.15	800451.0
2013-09-09	AB	Stock	20.16	20.59	20.15	20.4	322100.0
2013-09-09	ABAC-DELISTED	Stock	0.83	0.858	0.76	0.82	117081.0
2013-09-09	ABAX-DELISTED	Stock	40.07	40.93	39.55	40.93	83147.0
2013-09-09	ABB-DELISTED	Stock	22.36	22.62	22.34	22.6	1692730.0
2013-09-09	ABBNY-DELISTED	Stock	22.36	22.62	22.34	22.61	1845510.0
2013-09-09	ABBV	Stock	43.88	44.44	43.5	44.43	3287500.0
2013-09-09	ABC-DELISTED	Stock	58.38	58.79	58.15	58.67	916591.0
2013-09-09	ABCB	Stock	19.1	19.44	19.1	19.34	37700.0
2013-09-09	ABCD-DELISTED	Stock	1.6	1.6	1.44	1.53	18217.0
2013-09-09	ABCO-DELISTED	Stock	58.0	59.0	57.78	58.9	86155.0
2013-09-09	ABE-DELISTED	Stock	18.6	18.98	18.6	18.95	12541.0
2013-09-09	ABEO	Stock	475.0	512.5	412.5	462.5	21.0
2013-09-09	ABFS-DELISTED	Stock	26.0	26.55	26.0	26.09	608782.0
2013-09-09	ABG	Stock	52.34	53.05	52.34	52.96	160600.0
2013-09-09	ABM	Stock	25.32	25.67	25.32	25.67	146500.0
2013-09-09	ABMD-DELISTED	Stock	23.88	24.0	23.43	23.61	249580.0
2013-09-09	ABR	Stock	7.06	7.17	7.0	7.15	29400.0
2013-09-09	ABR.A-DELISTED	Stock	24.14	24.619	24.14	24.399	1100.0
2013-09-09	ABR.B-DELISTED	Stock	23.7199	23.7199	23.39	23.39	800.0
2013-09-09	ABT	Stock	33.5	33.8	33.46	33.8	5716200.0
2013-09-09	ABTL-DELISTED	Stock	7.11	7.55	7.0346	7.35	187607.0
2013-09-09	ABUS	Stock	5.55	5.66	5.55	5.65	31200.0
2013-09-09	ABV-DELISTED	Stock	35.62	36.17	35.33	36.16	3098888.0
2013-09-09	ABX-DELISTED	Stock	19.14	19.315	19.025	19.2	11768176.0
2013-09-09	ACAD	Stock	21.55	23.49	21.55	22.79	4312500.0

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

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