PREVIEW / stock_daily / 2018-06-06

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-06.parquet
  size:    219 KB
  rows:    6,523
  symbols: 2,806

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-06-06	AAPL	Stock	48.4075	48.52	47.98	48.495	83734400.0
2018-06-06	MSFT	Stock	102.48	102.6	101.9	102.49	21122900.0
2018-06-06	NVDA	Stock	6.5358	6.632	6.5192	6.6288	371356000.0
2018-06-06	AMZN	Stock	85.2255	85.725	84.3235	84.7875	109464000.0
2018-06-06	GOOGL	Stock	57.6385	57.7357	56.816	57.3475	34934380.0
2018-06-06	META	Stock	191.03	192.53	189.11	191.34	22558900.0
2018-06-06	TSLA	Stock	20.0333	21.478	19.832	21.3	281509500.0
2018-06-06	TLT	Stock	119.08	119.1	118.42	118.74	7813347.0
2018-06-06	ES	Stock	55.02	55.03	53.51	53.64	2206400.0
2018-06-06	CL	Stock	62.32	62.63	61.97	62.57	3390600.0
2018-06-06	A	Stock	63.75	65.19	63.06	65.19	3177600.0
2018-06-06	AA	Stock	49.89	50.19	49.17	50.13	2873400.0
2018-06-06	AABA-DELISTED	Stock	80.75	81.11	79.99	80.26	1874641.0
2018-06-06	AAC-DELISTED	Stock	10.12	10.64	10.08	10.43	196849.0
2018-06-06	AACG	Stock	5.27	5.28	5.13	5.13	2200.0
2018-06-06	AAIC-DELISTED	Stock	11.5	11.535	11.36	11.51	575311.0
2018-06-06	AAL	Stock	43.45	44.23	42.88	44.19	6502500.0
2018-06-06	AAM.A-DELISTED	Stock	25.17	25.29	25.1058	25.29	70007.0
2018-06-06	AAM.B-DELISTED	Stock	24.59	24.6599	24.5654	24.64	68063.0
2018-06-06	AAMC-DELISTED	Stock	20.6765	21.0588	19.8676	19.8676	13090.0
2018-06-06	AAME	Stock	2.94	2.94	2.7	2.7	3400.0
2018-06-06	AAMI	Stock	15.62	15.78	15.61	15.75	243300.0
2018-06-06	AAOI	Stock	47.0	47.0	44.25	44.86	1488000.0
2018-06-06	AAON	Stock	21.4667	21.7667	20.9667	21.7333	389250.0
2018-06-06	AAP	Stock	130.11	131.49	129.47	130.59	1173200.0
2018-06-06	AAT	Stock	36.94	37.53	36.94	37.35	229600.0
2018-06-06	AAU-DELISTED	Stock	0.73	0.7457	0.73	0.7375	117525.0
2018-06-06	AAUAF-DELISTED	Stock	0.73	0.7457	0.73	0.7375	119073.0
2018-06-06	AAV-DELISTED	Stock	2.95	3.1	2.95	3.075	323220.0
2018-06-06	AAWW-DELISTED	Stock	72.0	73.0	72.0	72.45	151479.0
2018-06-06	AAXJ	Stock	78.02	78.7	77.98	78.69	465409.0
2018-06-06	AAXN-DELISTED	Stock	67.64	69.09	66.93	67.9	945344.0
2018-06-06	AB	Stock	28.8	29.25	28.75	29.2	436000.0
2018-06-06	ABAC-DELISTED	Stock	2.3	2.4157	2.3	2.4	22170.0
2018-06-06	ABAX-DELISTED	Stock	83.1	83.4	82.89	83.38	239180.0
2018-06-06	ABB-DELISTED	Stock	22.97	23.185	22.91	23.17	1009877.0
2018-06-06	ABBNY-DELISTED	Stock	22.97	23.185	22.91	23.17	1092253.0
2018-06-06	ABBV	Stock	99.25	99.99	98.32	99.98	4933500.0
2018-06-06	ABC-DELISTED	Stock	84.87	87.19	84.84	87.15	925783.0
2018-06-06	ABCB	Stock	57.2	57.7	57.2	57.45	266600.0
2018-06-06	ABCD-DELISTED	Stock	10.36	10.39	10.18	10.29	209167.0
2018-06-06	ABDC-DELISTED	Stock	6.73	6.79	6.52	6.74	42622.0
2018-06-06	ABEO	Stock	420.0	443.75	400.0	407.5	58284.0
2018-06-06	ABEV	Stock	5.13	5.17	5.05	5.07	23697600.0
2018-06-06	ABG	Stock	72.6	73.7	72.0	73.5	144200.0
2018-06-06	ABIL-DELISTED	Stock	2.46	2.48	2.33	2.35	16043.0
2018-06-06	ABLX-DELISTED	Stock	52.62	52.8756	52.62	52.8756	2332.0
2018-06-06	ABM	Stock	28.72	29.3	28.54	29.0	1665400.0
2018-06-06	ABMD-DELISTED	Stock	406.92	411.01	404.5	410.27	423716.0
2018-06-06	ABR	Stock	9.33	9.49	9.33	9.49	831000.0

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

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