PREVIEW / stock_daily / 2014-04-03

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-03.parquet
  size:    219 KB
  rows:    6,502
  symbols: 3,537

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-04-03	AAPL	Stock	19.3354	19.375	19.2014	19.2425	162344000.0
2014-04-03	MSFT	Stock	41.29	41.29	40.71	41.01	30139600.0
2014-04-03	NVDA	Stock	0.4643	0.4795	0.464	0.4683	599548000.0
2014-04-03	AMZN	Stock	17.091	17.125	16.423	16.681	127986000.0
2014-04-03	GOOGL	Stock	28.6695	29.415	28.3005	28.575	80392520.0
2014-04-03	META	Stock	62.55	63.17	59.13	59.49	83859000.0
2014-04-03	TSLA	Stock	15.3533	15.7153	14.8	15.0267	163855500.0
2014-04-03	TLT	Stock	107.52	107.935	107.44	107.74	4937393.0
2014-04-03	ES	Stock	45.01	45.22	44.84	44.97	1035900.0
2014-04-03	CL	Stock	64.49	64.66	64.21	64.28	2426400.0
2014-04-03	A	Stock	40.608	40.8727	40.2504	40.4864	2240994.0
2014-04-03	AABA-DELISTED	Stock	36.66	36.79	35.51	35.77	15878476.0
2014-04-03	AACG	Stock	4.1	4.25	4.1	4.17	15200.0
2014-04-03	AAIC-DELISTED	Stock	26.55	26.63	26.24	26.54	195745.0
2014-04-03	AAL	Stock	37.72	38.44	36.96	37.34	7937400.0
2014-04-03	AAMC-DELISTED	Stock	344.7294	344.7294	321.1618	326.4706	58188.0
2014-04-03	AAME	Stock	3.69	3.7	3.61	3.69	11300.0
2014-04-03	AAOI	Stock	24.29	24.57	23.4	23.56	234100.0
2014-04-03	AAON	Stock	12.6844	12.6844	12.3111	12.3556	208125.0
2014-04-03	AAP	Stock	127.06	127.33	125.56	126.4	401800.0
2014-04-03	AAT	Stock	34.52	34.52	33.87	33.93	123200.0
2014-04-03	AAU-DELISTED	Stock	1.4	1.42	1.3751	1.39	62094.0
2014-04-03	AAUAF-DELISTED	Stock	1.41	1.43	1.38	1.38	62579.0
2014-04-03	AAV-DELISTED	Stock	5.02	5.23	5.02	5.15	722113.0
2014-04-03	AAWW-DELISTED	Stock	35.88	35.9	35.23	35.61	215880.0
2014-04-03	AAXJ	Stock	59.68	59.84	59.34	59.78	720924.0
2014-04-03	AAXN-DELISTED	Stock	18.65	18.79	18.176	18.33	745236.0
2014-04-03	AB	Stock	25.58	25.58	24.98	25.25	381600.0
2014-04-03	ABAC-DELISTED	Stock	1.87	1.98	1.8401	1.8401	8370.0
2014-04-03	ABAX-DELISTED	Stock	39.62	39.65	38.76	39.285	33188.0
2014-04-03	ABB-DELISTED	Stock	26.13	26.17	25.88	25.97	719501.0
2014-04-03	ABBNY-DELISTED	Stock	26.13	26.17	25.88	25.98	766401.0
2014-04-03	ABBV	Stock	53.35	53.83	53.21	53.5	6841400.0
2014-04-03	ABC-DELISTED	Stock	65.81	65.91	65.38	65.81	1784537.0
2014-04-03	ABCB	Stock	23.97	23.97	23.77	23.9	43600.0
2014-04-03	ABCD-DELISTED	Stock	2.34	2.38	2.24	2.27	62610.0
2014-04-03	ABCO-DELISTED	Stock	65.61	66.04	64.74	65.77	129348.0
2014-04-03	ABE-DELISTED	Stock	13.376	13.38	13.31	13.37	27613.0
2014-04-03	ABEO	Stock	600.0	650.0	587.5	650.0	12.0
2014-04-03	ABEV	Stock	7.56	7.57	7.41	7.5	8998000.0
2014-04-03	ABFS-DELISTED	Stock	38.62	39.78	37.9	38.15	232183.0
2014-04-03	ABG	Stock	57.52	58.83	57.27	57.67	373300.0
2014-04-03	ABGB-DELISTED	Stock	25.27	27.3325	25.27	25.99	32438.0
2014-04-03	ABIL-DELISTED	Stock	9.65	9.73	9.65	9.66	1540.0
2014-04-03	ABM	Stock	28.87	28.99	28.71	28.9	164100.0
2014-04-03	ABMD-DELISTED	Stock	26.1	26.26	25.57	25.98	384676.0
2014-04-03	ABR	Stock	6.95	7.15	6.93	7.12	117700.0
2014-04-03	ABR.B-DELISTED	Stock	22.9999	23.0	22.96	23.0	10096.0
2014-04-03	ABR.C-DELISTED	Stock	25.0	25.0	24.77	24.8	16795.0
2014-04-03	ABT	Stock	38.74	38.75	38.3	38.65	6029600.0

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

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