PREVIEW / stock_daily / 2019-06-03

all stock daily files

  file:    by_date/stock_daily/2019/2019-06-03.parquet
  size:    220 KB
  rows:    6,555
  symbols: 2,561

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
2019-06-03	AAPL	Stock	43.9	44.48	42.5675	43.325	161584400.0
2019-06-03	MSFT	Stock	123.85	124.37	119.01	119.84	37983600.0
2019-06-03	NVDA	Stock	3.3978	3.4368	3.315	3.3445	478644000.0
2019-06-03	AMZN	Stock	88.0005	88.3145	83.6	84.6345	181974000.0
2019-06-03	GOOGL	Stock	53.3465	53.35	51.3515	51.937	96889600.0
2019-06-03	META	Stock	175.0	175.05	161.01	164.15	56059600.0
2019-06-03	TSLA	Stock	12.3673	12.4453	11.7993	11.9313	195966000.0
2019-06-03	TLT	Stock	131.91	132.58	131.55	132.44	17822448.0
2019-06-03	ES	Stock	74.15	74.87	73.86	74.83	2791700.0
2019-06-03	CL	Stock	69.7	70.8	69.59	70.69	3652200.0
2019-06-03	A	Stock	67.04	68.1	66.82	66.99	2560600.0
2019-06-03	AA	Stock	21.05	21.67	20.82	21.51	3181000.0
2019-06-03	AABA-DELISTED	Stock	59.3	60.22	59.04	59.39	8843466.0
2019-06-03	AAC-DELISTED	Stock	0.9001	1.1	0.9001	1.01	475442.0
2019-06-03	AACG	Stock	1.8	1.9	1.8	1.8	47400.0
2019-06-03	AAIC-DELISTED	Stock	6.69	6.82	6.65	6.76	353660.0
2019-06-03	AAIC.C-DELISTED	Stock	22.59	22.59	22.2001	22.21	7029.0
2019-06-03	AAL	Stock	27.12	27.81	27.02	27.2	6796300.0
2019-06-03	AAM.A-DELISTED	Stock	25.49	25.65	25.4545	25.62	9986.0
2019-06-03	AAM.B-DELISTED	Stock	25.45	25.58	25.41	25.54	49014.0
2019-06-03	AAMC-DELISTED	Stock	4.8029	5.1471	4.1176	4.1471	152725.0
2019-06-03	AAME	Stock	2.45	2.45	2.29	2.37	800.0
2019-06-03	AAMI	Stock	10.69	12.12	10.67	11.09	997600.0
2019-06-03	AAOI	Stock	8.65	8.94	8.561	8.81	400200.0
2019-06-03	AAON	Stock	30.18	30.6667	30.16	30.5733	266100.0
2019-06-03	AAP	Stock	154.41	154.49	151.83	153.17	1104200.0
2019-06-03	AAT	Stock	45.59	45.68	44.95	45.68	216000.0
2019-06-03	AAU-DELISTED	Stock	0.47	0.485	0.4599	0.485	293207.0
2019-06-03	AAUAF-DELISTED	Stock	0.47	0.485	0.4599	0.485	309288.0
2019-06-03	AAWW-DELISTED	Stock	35.42	37.09	35.345	37.01	249213.0
2019-06-03	AAXJ	Stock	66.39	66.68	66.24	66.37	1907786.0
2019-06-03	AAXN-DELISTED	Stock	66.65	67.54	64.7	67.47	883305.0
2019-06-03	AB	Stock	27.3	27.62	27.2	27.45	116500.0
2019-06-03	ABB-DELISTED	Stock	18.31	18.47	18.275	18.43	1522722.0
2019-06-03	ABBNY-DELISTED	Stock	18.31	18.47	18.275	18.43	1604526.0
2019-06-03	ABBV	Stock	76.63	76.84	73.81	75.7	8434400.0
2019-06-03	ABC-DELISTED	Stock	78.12	81.07	78.12	80.39	1036567.0
2019-06-03	ABCB	Stock	35.26	36.25	34.98	35.9	309200.0
2019-06-03	ABDC-DELISTED	Stock	8.27	8.41	8.05	8.11	56388.0
2019-06-03	ABEO	Stock	135.5	137.25	127.75	129.75	22780.0
2019-06-03	ABEOW-DELISTED	Stock	1.41	1.44	1.41	1.41	1278.0
2019-06-03	ABEV	Stock	4.49	4.51	4.44	4.48	25821300.0
2019-06-03	ABG	Stock	74.21	77.96	74.21	77.25	159300.0
2019-06-03	ABIL-DELISTED	Stock	1.23	1.29	1.18	1.2489	388341.0
2019-06-03	ABM	Stock	36.29	36.79	36.05	36.33	327500.0
2019-06-03	ABMD-DELISTED	Stock	260.76	265.05	257.98	261.37	456731.0
2019-06-03	ABR	Stock	12.3	12.51	12.29	12.43	1220800.0
2019-06-03	ABR.A-DELISTED	Stock	25.9293	25.93	25.9133	25.92	1837.0
2019-06-03	ABR.B-DELISTED	Stock	25.3964	25.455	25.3964	25.45	400.0
2019-06-03	ABR.C-DELISTED	Stock	25.919	26.2025	25.879	26.2025	3129.0

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

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