PREVIEW / stock_daily / 2017-03-30

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-30.parquet
  size:    216 KB
  rows:    6,492
  symbols: 3,067

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-30	AAPL	Stock	36.0475	36.125	35.875	35.9825	84829200.0
2017-03-30	MSFT	Stock	65.42	65.98	65.36	65.71	15122800.0
2017-03-30	NVDA	Stock	2.6908	2.75	2.685	2.735	525532000.0
2017-03-30	AMZN	Stock	43.7475	43.853	43.583	43.817	55254000.0
2017-03-30	GOOGL	Stock	42.599	42.6	42.3385	42.474	18987960.0
2017-03-30	META	Stock	142.4	142.95	141.85	142.41	12404000.0
2017-03-30	TSLA	Stock	18.536	18.8	18.4807	18.528	62226000.0
2017-03-30	TLT	Stock	121.07	121.09	120.32	120.36	7042448.0
2017-03-30	ES	Stock	58.83	58.94	58.37	58.62	1185900.0
2017-03-30	CL	Stock	73.32	73.55	73.11	73.23	2346000.0
2017-03-30	A	Stock	53.13	53.43	52.9	53.32	1627400.0
2017-03-30	AA	Stock	33.15	35.14	32.96	33.49	7122600.0
2017-03-30	AAAP-DELISTED	Stock	40.0	40.92	39.145	40.0	451524.0
2017-03-30	AABA-DELISTED	Stock	46.8	47.045	46.6	46.615	3254990.0
2017-03-30	AAC-DELISTED	Stock	8.57	8.59	8.38	8.5	139882.0
2017-03-30	AACG	Stock	3.9	3.93	3.72	3.93	12700.0
2017-03-30	AAIC-DELISTED	Stock	14.17	14.26	13.93	13.99	481233.0
2017-03-30	AAL	Stock	41.85	42.64	41.79	42.54	3681400.0
2017-03-30	AAM.A-DELISTED	Stock	25.13	25.17	25.08	25.15	147069.0
2017-03-30	AAMC-DELISTED	Stock	19.8235	22.0588	19.8235	22.0588	147645.0
2017-03-30	AAME	Stock	3.7	4.0	3.7	4.0	3800.0
2017-03-30	AAMI	Stock	15.05	15.14	14.95	15.09	261600.0
2017-03-30	AAOI	Stock	58.07	58.537	53.28	55.35	2586100.0
2017-03-30	AAON	Stock	23.3333	23.5333	23.2667	23.5	194550.0
2017-03-30	AAP	Stock	149.24	149.64	148.35	148.67	699600.0
2017-03-30	AAT	Stock	41.24	41.61	40.93	41.57	267600.0
2017-03-30	AAU-DELISTED	Stock	1.1	1.1	1.05	1.065	162227.0
2017-03-30	AAUAF-DELISTED	Stock	1.1	1.1	1.05	1.065	164811.0
2017-03-30	AAV-DELISTED	Stock	6.55	6.65	6.5	6.6	95049.0
2017-03-30	AAWW-DELISTED	Stock	54.75	55.95	54.45	55.6	217246.0
2017-03-30	AAXJ	Stock	63.21	63.37	63.19	63.25	255667.0
2017-03-30	AAXN-DELISTED	Stock	22.63	23.3442	22.63	23.215	896453.0
2017-03-30	AB	Stock	22.0	22.7	22.0	22.5	234500.0
2017-03-30	ABAC-DELISTED	Stock	2.35	2.42	2.28	2.33	20083.0
2017-03-30	ABAX-DELISTED	Stock	48.75	49.225	47.86	48.33	154228.0
2017-03-30	ABB-DELISTED	Stock	23.31	23.45	23.29	23.33	1172552.0
2017-03-30	ABBNY-DELISTED	Stock	23.31	23.45	23.29	23.34	1303094.0
2017-03-30	ABBV	Stock	65.76	65.82	65.25	65.46	3749600.0
2017-03-30	ABC-DELISTED	Stock	89.37	89.88	89.03	89.17	1204573.0
2017-03-30	ABCB	Stock	44.5	46.6	44.5	46.4	215400.0
2017-03-30	ABCD-DELISTED	Stock	4.9	5.05	4.9	4.95	11216.0
2017-03-30	ABCO-DELISTED	Stock	46.7	46.85	46.0	46.7	155944.0
2017-03-30	ABDC-DELISTED	Stock	13.85	13.99	13.835	13.98	58940.0
2017-03-30	ABE-DELISTED	Stock	13.02	13.07	12.98	13.07	4539.0
2017-03-30	ABEO	Stock	126.25	127.5	122.5	125.0	10348.0
2017-03-30	ABEV	Stock	5.74	5.82	5.72	5.79	20688500.0
2017-03-30	ABG	Stock	62.4	62.65	61.1	61.9	240800.0
2017-03-30	ABIL-DELISTED	Stock	2.15	2.15	2.08	2.08	250.0
2017-03-30	ABM	Stock	42.99	43.5	42.99	43.45	329100.0
2017-03-30	ABMD-DELISTED	Stock	125.0	126.035	124.57	125.0	212450.0

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

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