PREVIEW / stock_daily / 2018-12-04

all stock daily files

  file:    by_date/stock_daily/2018/2018-12-04.parquet
  size:    221 KB
  rows:    6,583
  symbols: 2,717

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
2018-12-04	AAPL	Stock	45.2375	45.5975	44.0675	44.1725	165377200.0
2018-12-04	MSFT	Stock	111.94	112.64	108.21	108.52	45197000.0
2018-12-04	NVDA	Stock	4.206	4.211	3.9125	3.9278	812112000.0
2018-12-04	AMZN	Stock	87.8	88.517	83.25	83.42	173890000.0
2018-12-04	GOOGL	Stock	55.6495	55.712	53.0388	53.1235	45629700.0
2018-12-04	META	Stock	140.73	143.39	137.16	137.93	30307400.0
2018-12-04	TSLA	Stock	23.7367	24.5787	23.4667	23.98	126928500.0
2018-12-04	TLT	Stock	116.81	118.67	116.625	117.82	18100549.0
2018-12-04	ES	Stock	68.97	69.83	68.82	68.95	2665400.0
2018-12-04	CL	Stock	64.01	64.61	62.99	63.08	4237100.0
2018-12-04	A	Stock	74.7	75.11	72.63	72.91	4263800.0
2018-12-04	AA	Stock	32.11	32.19	30.27	30.4	3038000.0
2018-12-04	AABA-DELISTED	Stock	66.75	67.2	64.2	64.8	11887858.0
2018-12-04	AAC-DELISTED	Stock	2.33	2.36	2.08	2.13	266181.0
2018-12-04	AACG	Stock	1.16	1.16	1.1	1.11	83000.0
2018-12-04	AAIC-DELISTED	Stock	8.61	8.655	8.3	8.34	520695.0
2018-12-04	AAL	Stock	38.82	39.21	36.67	36.69	12315100.0
2018-12-04	AAM.A-DELISTED	Stock	23.3591	23.3591	22.81	22.9924	49427.0
2018-12-04	AAM.B-DELISTED	Stock	23.2179	23.3	22.85	22.96	61464.0
2018-12-04	AAMC-DELISTED	Stock	14.2647	14.65	14.1147	14.5382	6892.0
2018-12-04	AAME	Stock	2.66	2.69	2.65	2.68	2100.0
2018-12-04	AAMI	Stock	13.26	13.26	12.52	12.68	1215000.0
2018-12-04	AAOI	Stock	21.5	21.91	21.04	21.16	614500.0
2018-12-04	AAON	Stock	25.8333	25.86	24.0933	24.1933	273300.0
2018-12-04	AAP	Stock	180.12	181.73	175.62	178.19	1549500.0
2018-12-04	AAT	Stock	41.84	42.13	41.39	41.47	482400.0
2018-12-04	AAU-DELISTED	Stock	0.6682	0.672	0.61	0.6104	179101.0
2018-12-04	AAUAF-DELISTED	Stock	0.6682	0.672	0.61	0.6104	182584.0
2018-12-04	AAWW-DELISTED	Stock	54.0	54.23	50.65	50.76	179959.0
2018-12-04	AAXJ	Stock	68.23	68.36	66.7	66.88	1034844.0
2018-12-04	AAXN-DELISTED	Stock	45.15	46.045	43.57	43.64	713915.0
2018-12-04	AB	Stock	30.9	30.9	29.75	29.98	295700.0
2018-12-04	ABAC-DELISTED	Stock	1.4415	1.4415	1.35	1.4	13747.0
2018-12-04	ABB-DELISTED	Stock	20.26	20.27	19.65	19.66	2426795.0
2018-12-04	ABBNY-DELISTED	Stock	20.26	20.27	19.65	19.66	2517533.0
2018-12-04	ABBV	Stock	93.92	94.98	90.4	90.55	7008400.0
2018-12-04	ABC-DELISTED	Stock	88.6	90.255	87.41	87.62	1755340.0
2018-12-04	ABCB	Stock	42.7	42.91	39.1	39.14	412300.0
2018-12-04	ABCD-DELISTED	Stock	14.5	14.5	14.46	14.47	214769.0
2018-12-04	ABDC-DELISTED	Stock	6.55	6.58	6.43	6.51	35681.0
2018-12-04	ABEO	Stock	213.75	215.25	189.0	189.75	26388.0
2018-12-04	ABEOW-DELISTED	Stock	4.45	4.45	4.45	4.45	2700.0
2018-12-04	ABEV	Stock	4.34	4.41	4.26	4.27	23508600.0
2018-12-04	ABG	Stock	70.14	70.15	65.5	66.35	348500.0
2018-12-04	ABIL-DELISTED	Stock	2.6	2.67	2.36	2.43	300820.0
2018-12-04	ABM	Stock	30.99	31.3	29.63	29.65	559600.0
2018-12-04	ABMD-DELISTED	Stock	340.83	343.2	321.8963	327.3	427079.0
2018-12-04	ABR	Stock	11.9	12.03	11.65	11.7	1312200.0
2018-12-04	ABR.A-DELISTED	Stock	25.493	25.501	25.0	25.24	17653.0
2018-12-04	ABR.B-DELISTED	Stock	25.3505	25.49	25.28	25.48	4120.0

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

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