PREVIEW / stock_daily / 2018-10-26

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-26.parquet
  size:    220 KB
  rows:    6,540
  symbols: 2,708

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-10-26	AAPL	Stock	53.975	55.0475	53.1675	54.075	189033600.0
2018-10-26	MSFT	Stock	105.69	108.75	104.76	106.96	55523100.0
2018-10-26	NVDA	Stock	4.9578	5.121	4.828	4.9572	664784000.0
2018-10-26	AMZN	Stock	82.4795	84.923	80.15	82.1405	299276000.0
2018-10-26	GOOGL	Stock	52.4165	55.85	52.1115	54.1875	106437660.0
2018-10-26	META	Stock	145.82	149.0	143.8	145.37	31303300.0
2018-10-26	TSLA	Stock	20.55	22.66	20.4433	22.06	411382500.0
2018-10-26	TLT	Stock	114.93	115.32	114.79	114.99	18582470.0
2018-10-26	ES	Stock	63.9	64.48	62.22	62.77	1627600.0
2018-10-26	CL	Stock	61.49	62.26	59.26	59.58	9628700.0
2018-10-26	A	Stock	61.82	63.11	61.13	62.73	3119900.0
2018-10-26	AA	Stock	33.84	34.99	33.08	34.25	3944700.0
2018-10-26	AABA-DELISTED	Stock	58.83	61.06	58.56	60.17	4562247.0
2018-10-26	AAC-DELISTED	Stock	6.75	6.76	6.6	6.65	318639.0
2018-10-26	AACG	Stock	1.12	1.15	1.08	1.12	114300.0
2018-10-26	AAIC-DELISTED	Stock	8.4	8.42	8.16	8.34	546468.0
2018-10-26	AAL	Stock	31.4	33.01	31.3	32.46	11438600.0
2018-10-26	AAM.A-DELISTED	Stock	24.5	24.6	24.35	24.5847	14380.0
2018-10-26	AAM.B-DELISTED	Stock	24.39	24.54	24.31	24.54	16440.0
2018-10-26	AAME	Stock	2.94	2.94	2.72	2.93	1800.0
2018-10-26	AAMI	Stock	11.35	11.46	11.15	11.32	483800.0
2018-10-26	AAOI	Stock	21.05	21.39	20.44	20.52	1184100.0
2018-10-26	AAON	Stock	22.2067	22.5	21.78	22.0667	173550.0
2018-10-26	AAP	Stock	161.7	165.52	160.21	164.55	1668600.0
2018-10-26	AAT	Stock	37.47	37.78	36.52	36.92	209900.0
2018-10-26	AAU-DELISTED	Stock	0.56	0.6253	0.5553	0.5805	130334.0
2018-10-26	AAUAF-DELISTED	Stock	0.56	0.6253	0.5553	0.5805	140390.0
2018-10-26	AAWW-DELISTED	Stock	49.38	50.99	48.53	50.76	259979.0
2018-10-26	AAXJ	Stock	61.55	62.59	61.31	62.0	1922791.0
2018-10-26	AAXN-DELISTED	Stock	57.45	59.32	55.09	56.94	553906.0
2018-10-26	AB	Stock	29.0	29.11	28.17	28.25	863600.0
2018-10-26	ABAC-DELISTED	Stock	1.731	1.79	1.68	1.7	8862.0
2018-10-26	ABB-DELISTED	Stock	19.36	19.74	19.23	19.51	3051221.0
2018-10-26	ABBNY-DELISTED	Stock	19.36	19.74	19.23	19.51	3708070.0
2018-10-26	ABBV	Stock	81.02	81.53	79.43	80.79	6181500.0
2018-10-26	ABC-DELISTED	Stock	84.94	86.12	83.07	84.72	812969.0
2018-10-26	ABCB	Stock	41.6	42.59	41.22	41.71	334100.0
2018-10-26	ABCD-DELISTED	Stock	14.39	14.4	14.35	14.36	642524.0
2018-10-26	ABDC-DELISTED	Stock	5.71	5.87	5.62	5.81	62794.0
2018-10-26	ABEO	Stock	219.0	224.25	213.25	223.0	19432.0
2018-10-26	ABEV	Stock	4.06	4.2	3.97	4.13	44344300.0
2018-10-26	ABG	Stock	66.21	68.92	65.74	67.61	242500.0
2018-10-26	ABIL-DELISTED	Stock	3.1	3.14	2.85	3.0194	56915.0
2018-10-26	ABM	Stock	29.78	30.72	29.48	30.52	704400.0
2018-10-26	ABMD-DELISTED	Stock	320.1	337.52	317.56	330.35	566121.0
2018-10-26	ABR	Stock	11.83	11.87	11.69	11.75	916900.0
2018-10-26	ABR.A-DELISTED	Stock	25.43	25.4365	25.43	25.4365	810.0
2018-10-26	ABR.B-DELISTED	Stock	25.288	25.288	25.288	25.288	305.0
2018-10-26	ABT	Stock	66.75	67.69	65.78	66.99	8379000.0
2018-10-26	ABTC	Stock	306000.0	306000.0	305370.0	305580.0	0.76

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

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