PREVIEW / stock_daily / 2017-03-02

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-02.parquet
  size:    217 KB
  rows:    6,489
  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-02	AAPL	Stock	35.0	35.07	34.69	34.74	104844000.0
2017-03-02	MSFT	Stock	64.69	64.75	63.88	64.01	24539600.0
2017-03-02	NVDA	Stock	2.5568	2.571	2.4723	2.475	754332000.0
2017-03-02	AMZN	Stock	42.654	42.741	42.364	42.4455	42642000.0
2017-03-02	GOOGL	Stock	42.8155	42.8245	42.436	42.4925	25018760.0
2017-03-02	META	Stock	137.09	137.82	136.31	136.76	12294800.0
2017-03-02	TSLA	Stock	16.6473	16.8853	16.5513	16.6987	50277000.0
2017-03-02	TLT	Stock	119.01	119.21	118.615	119.04	8201247.0
2017-03-02	ES	Stock	58.0	58.96	57.9	58.59	1258900.0
2017-03-02	CL	Stock	72.99	73.8	72.7	73.74	4442400.0
2017-03-02	A	Stock	52.04	52.08	51.33	51.38	1706400.0
2017-03-02	AA	Stock	37.64	38.17	35.83	35.85	5099300.0
2017-03-02	AAAP-DELISTED	Stock	37.85	38.27	36.5	37.43	58543.0
2017-03-02	AABA-DELISTED	Stock	46.02	46.13	45.62	45.93	5183986.0
2017-03-02	AAC-DELISTED	Stock	8.87	9.03	8.7	8.9	100884.0
2017-03-02	AACG	Stock	3.7	3.85	3.64	3.84	37600.0
2017-03-02	AAIC-DELISTED	Stock	14.7	14.73	14.46	14.48	652605.0
2017-03-02	AAL	Stock	46.67	46.74	45.64	45.72	7590700.0
2017-03-02	AAMC-DELISTED	Stock	21.8971	23.2353	21.2568	23.2353	20210.0
2017-03-02	AAME	Stock	3.75	3.75	3.7	3.75	4600.0
2017-03-02	AAMI	Stock	15.14	15.14	14.83	14.97	349200.0
2017-03-02	AAOI	Stock	46.97	49.25	46.69	49.23	1533700.0
2017-03-02	AAON	Stock	23.4667	23.7667	23.3333	23.7	391800.0
2017-03-02	AAP	Stock	156.68	158.09	156.45	157.36	1158100.0
2017-03-02	AAT	Stock	43.56	43.56	42.8	43.09	254700.0
2017-03-02	AAU-DELISTED	Stock	1.14	1.17	1.06	1.06	272750.0
2017-03-02	AAUAF-DELISTED	Stock	1.14	1.17	1.06	1.06	277289.0
2017-03-02	AAV-DELISTED	Stock	6.0	6.05	5.85	5.9	172783.0
2017-03-02	AAWW-DELISTED	Stock	57.6	57.6	56.35	57.15	156557.0
2017-03-02	AAXJ	Stock	60.72	60.72	60.3	60.35	1559875.0
2017-03-02	AAXN-DELISTED	Stock	24.23	24.23	22.52	22.96	4050237.0
2017-03-02	AB	Stock	23.45	23.55	23.3	23.35	160400.0
2017-03-02	ABAC-DELISTED	Stock	2.67	2.85	2.67	2.74	12614.0
2017-03-02	ABAX-DELISTED	Stock	50.43	50.43	49.76	49.8	75279.0
2017-03-02	ABB-DELISTED	Stock	22.78	22.82	22.665	22.67	1039586.0
2017-03-02	ABBNY-DELISTED	Stock	22.78	22.82	22.665	22.68	1128375.0
2017-03-02	ABBV	Stock	62.78	63.6	62.6	63.25	8190000.0
2017-03-02	ABC-DELISTED	Stock	91.89	92.73	91.45	91.94	1147845.0
2017-03-02	ABCB	Stock	47.9	48.0	46.35	46.35	316600.0
2017-03-02	ABCD-DELISTED	Stock	4.82	4.93	4.74	4.9	28786.0
2017-03-02	ABCO-DELISTED	Stock	45.75	46.5	45.1	45.3	601124.0
2017-03-02	ABDC-DELISTED	Stock	12.6	12.8	12.51	12.53	68331.0
2017-03-02	ABE-DELISTED	Stock	12.09	12.126	12.0334	12.0334	22947.0
2017-03-02	ABEO	Stock	136.25	138.75	123.75	126.25	10108.0
2017-03-02	ABEV	Stock	5.52	5.57	5.41	5.42	25474900.0
2017-03-02	ABG	Stock	65.55	66.1	65.0	65.65	127600.0
2017-03-02	ABIL-DELISTED	Stock	2.65	2.7	2.42	2.5	64639.0
2017-03-02	ABM	Stock	41.0	41.45	40.88	41.19	439400.0
2017-03-02	ABMD-DELISTED	Stock	121.75	122.1764	119.8	120.14	267544.0
2017-03-02	ABR	Stock	7.39	7.43	7.38	7.42	76300.0

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

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