PREVIEW / stock_daily / 2017-03-06

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-06.parquet
  size:    216 KB
  rows:    6,500
  symbols: 3,074

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-06	AAPL	Stock	34.8425	34.9425	34.65	34.835	87000000.0
2017-03-06	MSFT	Stock	63.97	64.56	63.81	64.27	18750300.0
2017-03-06	NVDA	Stock	2.424	2.4525	2.3793	2.4418	883568000.0
2017-03-06	AMZN	Stock	42.2615	42.4245	42.056	42.3305	52208000.0
2017-03-06	GOOGL	Stock	42.343	42.447	42.0585	42.3635	20957440.0
2017-03-06	META	Stock	136.88	137.83	136.51	137.42	12748200.0
2017-03-06	TSLA	Stock	16.5273	16.78	16.5007	16.7473	50332500.0
2017-03-06	TLT	Stock	119.12	119.12	118.52	118.78	4489229.0
2017-03-06	ES	Stock	58.26	58.48	57.96	58.35	1538800.0
2017-03-06	CL	Stock	73.24	73.85	73.15	73.79	3994700.0
2017-03-06	A	Stock	51.64	51.82	51.18	51.25	1883700.0
2017-03-06	AA	Stock	36.8	37.48	35.8	36.93	5764000.0
2017-03-06	AAAP-DELISTED	Stock	38.14	38.23	37.46	38.145	95996.0
2017-03-06	AABA-DELISTED	Stock	45.61	45.69	45.39	45.64	4837777.0
2017-03-06	AAC-DELISTED	Stock	8.97	9.065	8.8201	9.0	126060.0
2017-03-06	AACG	Stock	3.87	3.98	3.7	3.71	16800.0
2017-03-06	AAIC-DELISTED	Stock	14.35	14.38	14.08	14.13	410276.0
2017-03-06	AAL	Stock	46.41	46.68	44.38	45.31	11336600.0
2017-03-06	AAMC-DELISTED	Stock	25.1912	26.2119	23.7059	23.7059	28023.0
2017-03-06	AAME	Stock	3.75	3.75	3.4	3.6	9200.0
2017-03-06	AAMI	Stock	14.99	15.04	14.83	15.01	275300.0
2017-03-06	AAOI	Stock	52.75	52.75	50.5	51.46	1296200.0
2017-03-06	AAON	Stock	23.3333	23.4667	22.9	23.2	407100.0
2017-03-06	AAP	Stock	155.35	156.1	154.19	154.25	1057600.0
2017-03-06	AAT	Stock	42.84	43.03	42.58	42.69	155800.0
2017-03-06	AAU-DELISTED	Stock	1.1	1.11	1.0	1.0	344815.0
2017-03-06	AAUAF-DELISTED	Stock	1.1	1.11	1.0	1.0	365399.0
2017-03-06	AAV-DELISTED	Stock	5.8	5.95	5.7	5.85	198537.0
2017-03-06	AAWW-DELISTED	Stock	56.35	56.7	55.8	56.35	116426.0
2017-03-06	AAXJ	Stock	60.36	60.43	60.2	60.38	659120.0
2017-03-06	AAXN-DELISTED	Stock	22.8	23.111	22.4	22.535	1439123.0
2017-03-06	AB	Stock	23.0	23.3	22.95	23.0	320300.0
2017-03-06	ABAC-DELISTED	Stock	2.75	2.84	2.65	2.65	19081.0
2017-03-06	ABAX-DELISTED	Stock	49.19	50.1325	48.935	49.48	77380.0
2017-03-06	ABB-DELISTED	Stock	22.58	22.59	22.485	22.57	1740763.0
2017-03-06	ABBNY-DELISTED	Stock	22.58	22.59	22.485	22.57	1781914.0
2017-03-06	ABBV	Stock	63.0	63.85	62.88	63.55	6837000.0
2017-03-06	ABC-DELISTED	Stock	91.58	91.87	89.74	89.95	1589031.0
2017-03-06	ABCB	Stock	46.4	47.9	46.25	47.35	659900.0
2017-03-06	ABCD-DELISTED	Stock	4.81	4.97	4.63	4.65	64743.0
2017-03-06	ABCO-DELISTED	Stock	45.1	45.375	44.6	44.75	835586.0
2017-03-06	ABDC-DELISTED	Stock	12.5	12.74	12.5	12.6	34341.0
2017-03-06	ABE-DELISTED	Stock	12.12	12.14	12.1	12.14	8567.0
2017-03-06	ABEO	Stock	126.25	126.25	121.25	123.75	4784.0
2017-03-06	ABEV	Stock	5.55	5.55	5.41	5.46	17143300.0
2017-03-06	ABG	Stock	65.0	65.05	64.1	64.6	795100.0
2017-03-06	ABIL-DELISTED	Stock	2.49	2.49	2.2	2.39	42661.0
2017-03-06	ABM	Stock	40.4	40.81	40.15	40.47	481900.0
2017-03-06	ABMD-DELISTED	Stock	119.28	120.29	118.04	119.81	211022.0
2017-03-06	ABR	Stock	7.65	7.7	7.55	7.66	200600.0

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

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