PREVIEW / stock_daily / 2017-03-29

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-29.parquet
  size:    215 KB
  rows:    6,481
  symbols: 3,073

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
2017-03-29	AAPL	Stock	35.92	36.1225	35.7975	36.03	116760000.0
2017-03-29	MSFT	Stock	65.12	65.5	64.95	65.47	13618400.0
2017-03-29	NVDA	Stock	2.6998	2.7122	2.6813	2.6835	349992000.0
2017-03-29	AMZN	Stock	42.9525	43.822	42.951	43.716	89716000.0
2017-03-29	GOOGL	Stock	42.1375	42.5792	42.069	42.4935	29146940.0
2017-03-29	META	Stock	141.99	142.86	141.43	142.65	16527600.0
2017-03-29	TSLA	Stock	18.556	18.64	18.3693	18.492	55143000.0
2017-03-29	TLT	Stock	120.94	121.3792	120.88	121.34	6291020.0
2017-03-29	ES	Stock	59.43	59.43	58.88	59.07	1453800.0
2017-03-29	CL	Stock	73.59	73.83	73.44	73.56	2450200.0
2017-03-29	A	Stock	53.26	53.42	52.78	53.12	1469900.0
2017-03-29	AA	Stock	32.91	33.29	32.73	32.91	2611700.0
2017-03-29	AAAP-DELISTED	Stock	39.21	40.0	39.21	40.0	231504.0
2017-03-29	AABA-DELISTED	Stock	46.52	46.84	46.3	46.79	4136031.0
2017-03-29	AAC-DELISTED	Stock	8.28	8.68	8.1	8.61	207713.0
2017-03-29	AACG	Stock	3.82	3.95	3.82	3.9	2800.0
2017-03-29	AAIC-DELISTED	Stock	14.01	14.23	13.95	14.15	648555.0
2017-03-29	AAL	Stock	42.69	42.76	41.87	41.96	5331400.0
2017-03-29	AAM.A-DELISTED	Stock	25.17	25.19	25.07	25.13	201983.0
2017-03-29	AAMC-DELISTED	Stock	19.9706	20.4118	19.7059	20.1471	27326.0
2017-03-29	AAME	Stock	3.85	3.85	3.85	3.85	2700.0
2017-03-29	AAMI	Stock	15.04	15.1	14.9	15.04	173500.0
2017-03-29	AAOI	Stock	59.18	59.418	57.5	58.02	1129300.0
2017-03-29	AAON	Stock	23.1333	23.4667	22.9333	23.3	184350.0
2017-03-29	AAP	Stock	148.61	150.07	147.61	149.67	738800.0
2017-03-29	AAT	Stock	41.32	41.52	41.08	41.18	247300.0
2017-03-29	AAU-DELISTED	Stock	1.07	1.13	1.06	1.12	176478.0
2017-03-29	AAUAF-DELISTED	Stock	1.07	1.13	1.06	1.12	183957.0
2017-03-29	AAV-DELISTED	Stock	6.5	6.6	6.425	6.575	88530.0
2017-03-29	AAWW-DELISTED	Stock	53.3	54.5	52.9	54.3	184927.0
2017-03-29	AAXJ	Stock	63.31	63.555	63.31	63.51	662806.0
2017-03-29	AAXN-DELISTED	Stock	22.76	22.82	22.56	22.63	449138.0
2017-03-29	AB	Stock	21.95	22.1	21.75	21.95	270700.0
2017-03-29	ABAC-DELISTED	Stock	2.39	2.45	2.35	2.35	15235.0
2017-03-29	ABAX-DELISTED	Stock	48.13	48.8	47.74	48.74	62332.0
2017-03-29	ABB-DELISTED	Stock	23.35	23.37	23.26	23.36	1081295.0
2017-03-29	ABBNY-DELISTED	Stock	23.35	23.37	23.26	23.36	1117800.0
2017-03-29	ABBV	Stock	65.95	66.27	65.68	65.77	3649900.0
2017-03-29	ABC-DELISTED	Stock	87.4	89.77	87.4	89.52	2012626.0
2017-03-29	ABCB	Stock	44.7	44.7	43.95	44.4	197000.0
2017-03-29	ABCD-DELISTED	Stock	4.96	5.08	4.94	5.0501	13460.0
2017-03-29	ABCO-DELISTED	Stock	46.85	47.0	46.5	46.8	208907.0
2017-03-29	ABDC-DELISTED	Stock	13.7	13.89	13.5301	13.85	54246.0
2017-03-29	ABE-DELISTED	Stock	12.9	13.0499	12.9	13.0095	13372.0
2017-03-29	ABEO	Stock	122.5	126.25	122.0	126.25	7076.0
2017-03-29	ABEV	Stock	5.67	5.78	5.67	5.77	12340000.0
2017-03-29	ABG	Stock	61.95	63.05	61.95	62.5	318100.0
2017-03-29	ABIL-DELISTED	Stock	2.13	2.15	2.11	2.12	2400.0
2017-03-29	ABM	Stock	42.99	43.11	42.77	43.0	228000.0
2017-03-29	ABMD-DELISTED	Stock	124.79	125.85	124.21	124.96	241749.0

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

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