PREVIEW / stock_daily / 2013-09-27

all stock daily files

  file:    by_date/stock_daily/2013/2013-09-27.parquet
  size:    212 KB
  rows:    6,369
  symbols: 3,526

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-27	AAPL	Stock	17.2779	17.3096	17.1686	17.2411	228040400.0
2013-09-27	MSFT	Stock	32.88	33.75	32.87	33.27	55348000.0
2013-09-27	NVDA	Stock	0.3888	0.392	0.3873	0.3895	151920000.0
2013-09-27	AMZN	Stock	15.846	15.8605	15.6675	15.8005	33150000.0
2013-09-27	META	Stock	50.29	51.28	49.86	51.24	81410500.0
2013-09-27	TSLA	Stock	12.5013	12.752	12.4287	12.7267	88746000.0
2013-09-27	TLT	Stock	106.29	106.82	106.249	106.56	6461748.0
2013-09-27	ES	Stock	41.58	41.73	41.19	41.44	2107800.0
2013-09-27	CL	Stock	60.07	60.28	59.65	59.93	2945800.0
2013-09-27	A	Stock	37.0815	37.2675	36.7668	36.9313	2949920.0
2013-09-27	AABA-DELISTED	Stock	33.31	33.85	32.76	33.55	31233970.0
2013-09-27	AACG	Stock	4.9	5.0	4.9	4.95	16400.0
2013-09-27	AAIC-DELISTED	Stock	24.54	24.869	24.54	24.65	130209.0
2013-09-27	AAMC-DELISTED	Stock	147.0588	156.7647	147.0588	156.7647	7871.0
2013-09-27	AAME	Stock	4.04	4.05	4.03	4.05	8500.0
2013-09-27	AAMRQ-DELISTED	Stock	4.335	4.5	4.03	4.37	7577635.0
2013-09-27	AAOI	Stock	10.44	10.44	10.0	10.1	253300.0
2013-09-27	AAON	Stock	11.7022	11.9733	11.6578	11.9378	200250.0
2013-09-27	AAP	Stock	81.2	82.31	81.2	82.06	639600.0
2013-09-27	AAT	Stock	30.93	31.2	30.8	31.06	110400.0
2013-09-27	AAU-DELISTED	Stock	1.43	1.4699	1.36	1.4	80561.0
2013-09-27	AAUAF-DELISTED	Stock	1.43	1.4699	1.36	1.4	80861.0
2013-09-27	AAV-DELISTED	Stock	3.64	3.84	3.62	3.81	209038.0
2013-09-27	AAWW-DELISTED	Stock	46.15	46.25	45.81	45.82	112912.0
2013-09-27	AAXJ	Stock	59.14	59.14	58.73	58.9	293105.0
2013-09-27	AAXN-DELISTED	Stock	15.04	15.14	14.71	14.86	1002476.0
2013-09-27	AB	Stock	19.92	20.03	19.53	19.8	346500.0
2013-09-27	ABAC-DELISTED	Stock	0.82	0.93	0.81	0.81	48096.0
2013-09-27	ABAX-DELISTED	Stock	41.54	42.29	41.05	41.47	139926.0
2013-09-27	ABB-DELISTED	Stock	23.76	23.85	23.66	23.8	951472.0
2013-09-27	ABBNY-DELISTED	Stock	23.76	23.85	23.66	23.81	969439.0
2013-09-27	ABBV	Stock	44.87	44.9	44.02	44.33	6617300.0
2013-09-27	ABC-DELISTED	Stock	60.91	61.35	60.73	61.27	681516.0
2013-09-27	ABCB	Stock	18.62	18.95	18.57	18.63	29200.0
2013-09-27	ABCD-DELISTED	Stock	1.55	1.61	1.5035	1.56	3924.0
2013-09-27	ABCO-DELISTED	Stock	58.2	59.29	58.05	58.93	113779.0
2013-09-27	ABE-DELISTED	Stock	19.71	19.7676	19.56	19.65	5427.0
2013-09-27	ABEO	Stock	575.0	575.0	450.0	450.0	21.0
2013-09-27	ABFS-DELISTED	Stock	25.55	25.98	25.17	25.75	241571.0
2013-09-27	ABG	Stock	53.55	54.11	53.23	53.8	213400.0
2013-09-27	ABM	Stock	26.32	26.6	26.32	26.55	147200.0
2013-09-27	ABMD-DELISTED	Stock	18.64	18.8	18.15	18.76	397389.0
2013-09-27	ABR	Stock	6.88	6.93	6.84	6.88	279000.0
2013-09-27	ABR.A-DELISTED	Stock	24.7	24.7	24.5798	24.69	1000.0
2013-09-27	ABT	Stock	33.45	33.45	33.05	33.14	11822900.0
2013-09-27	ABTL-DELISTED	Stock	7.27	7.34	7.0	7.07	16779.0
2013-09-27	ABUS	Stock	7.72	7.72	7.26	7.36	193700.0
2013-09-27	ABV-DELISTED	Stock	38.91	38.96	38.57	38.67	1813044.0
2013-09-27	ABX-DELISTED	Stock	18.75	18.98	18.44	18.53	11733441.0
2013-09-27	ACAD	Stock	26.35	27.7	26.05	27.03	2570500.0

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

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