PREVIEW / stock_daily / 2014-10-08

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-08.parquet
  size:    221 KB
  rows:    6,609
  symbols: 3,549

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
2014-10-08	AAPL	Stock	24.69	25.2775	24.5775	25.2	229618800.0
2014-10-08	MSFT	Stock	45.48	46.89	45.34	46.78	33031000.0
2014-10-08	NVDA	Stock	0.4478	0.4588	0.4442	0.4565	260172000.0
2014-10-08	AMZN	Stock	15.829	16.2055	15.707	16.135	69056000.0
2014-10-08	GOOGL	Stock	28.7395	29.2345	28.382	29.187	44207200.0
2014-10-08	META	Stock	76.18	77.71	75.1	77.52	32976000.0
2014-10-08	TSLA	Stock	17.34	17.5253	16.8427	17.2853	75826500.0
2014-10-08	TLT	Stock	119.45	119.52	118.5126	119.39	9391292.0
2014-10-08	ES	Stock	45.78	46.74	45.75	46.67	2007100.0
2014-10-08	CL	Stock	64.9	65.86	64.85	65.82	3696600.0
2014-10-08	A	Stock	39.3848	40.4292	39.1989	40.3863	2970331.0
2014-10-08	AA.B-DELISTED	Stock	49.25	50.04	48.76	50.04	390418.0
2014-10-08	AABA-DELISTED	Stock	41.0	41.29	40.1	41.075	25283736.0
2014-10-08	AAC-DELISTED	Stock	19.17	19.48	18.9	19.13	35212.0
2014-10-08	AACG	Stock	4.3	4.4	4.3	4.32	6100.0
2014-10-08	AAIC-DELISTED	Stock	25.37	25.75	25.3	25.75	352981.0
2014-10-08	AAL	Stock	34.53	34.55	32.6	33.0	22753600.0
2014-10-08	AAMC-DELISTED	Stock	198.5294	201.3176	197.0588	199.9471	11645.0
2014-10-08	AAME	Stock	3.9	4.0	3.86	4.0	4100.0
2014-10-08	AAOI	Stock	14.49	14.98	14.07	14.7	184200.0
2014-10-08	AAON	Stock	11.3	11.5667	11.1867	11.5133	250050.0
2014-10-08	AAP	Stock	134.24	136.88	133.74	136.84	904700.0
2014-10-08	AAT	Stock	33.75	34.78	33.74	34.75	115000.0
2014-10-08	AAU-DELISTED	Stock	1.27	1.3417	1.22	1.33	135384.0
2014-10-08	AAUAF-DELISTED	Stock	1.26	1.33	1.21	1.33	138453.0
2014-10-08	AAV-DELISTED	Stock	4.78	4.82	4.53	4.785	415147.0
2014-10-08	AAVL-DELISTED	Stock	32.0	32.18	31.02	31.29	96604.0
2014-10-08	AAWW-DELISTED	Stock	32.28	33.0	31.63	32.83	138885.0
2014-10-08	AAXJ	Stock	60.82	61.74	60.48	61.65	672151.0
2014-10-08	AAXN-DELISTED	Stock	14.64	14.76	14.06	14.54	1953683.0
2014-10-08	AB	Stock	25.17	25.72	24.9	25.65	317800.0
2014-10-08	ABAC-DELISTED	Stock	2.0701	2.0701	2.02	2.05	10530.0
2014-10-08	ABAX-DELISTED	Stock	47.39	47.92	46.88	47.91	194048.0
2014-10-08	ABB-DELISTED	Stock	21.37	21.66	21.16	21.63	5610586.0
2014-10-08	ABBNY-DELISTED	Stock	21.37	21.66	21.16	21.62	5912186.0
2014-10-08	ABBV	Stock	56.54	58.45	56.18	58.34	10917200.0
2014-10-08	ABC-DELISTED	Stock	76.37	77.98	76.33	77.88	1250741.0
2014-10-08	ABCB	Stock	22.22	22.84	21.92	22.69	250000.0
2014-10-08	ABCD-DELISTED	Stock	1.62	1.62	1.6	1.61	2705.0
2014-10-08	ABCO-DELISTED	Stock	46.0	47.77	45.45	47.69	280241.0
2014-10-08	ABDC-DELISTED	Stock	12.94	13.13	12.7	13.13	37518.0
2014-10-08	ABE-DELISTED	Stock	14.0	14.1799	13.911	14.07	6545.0
2014-10-08	ABEO	Stock	312.5	325.0	312.5	325.0	32.0
2014-10-08	ABEV	Stock	6.93	6.95	6.67	6.77	19979900.0
2014-10-08	ABG	Stock	65.95	67.93	65.45	67.87	182200.0
2014-10-08	ABGB-DELISTED	Stock	22.36	22.79	22.21	22.72	37921.0
2014-10-08	ABM	Stock	25.51	26.24	25.43	26.23	220200.0
2014-10-08	ABMD-DELISTED	Stock	23.53	23.95	23.2681	23.86	213985.0
2014-10-08	ABR	Stock	6.61	6.72	6.5	6.65	132700.0
2014-10-08	ABR.A-DELISTED	Stock	24.54	24.75	24.54	24.75	7743.0

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

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