PREVIEW / stock_daily / 2019-06-26

all stock daily files

  file:    by_date/stock_daily/2019/2019-06-26.parquet
  size:    221 KB
  rows:    6,619
  symbols: 2,578

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-26	AAPL	Stock	49.4425	50.2475	49.3375	49.95	104270000.0
2019-06-26	MSFT	Stock	134.35	135.74	133.6	133.93	23657700.0
2019-06-26	NVDA	Stock	3.9152	4.043	3.9023	3.9815	584072000.0
2019-06-26	AMZN	Stock	94.624	95.19	94.366	94.8915	48838000.0
2019-06-26	GOOGL	Stock	54.55	54.756	53.6844	54.016	34697460.0
2019-06-26	META	Stock	189.54	190.76	187.31	187.66	12808600.0
2019-06-26	TSLA	Stock	14.6873	15.1487	14.54	14.618	127608000.0
2019-06-26	TLT	Stock	132.68	132.7	131.88	131.97	12766810.0
2019-06-26	ES	Stock	76.91	76.92	75.28	75.37	1942400.0
2019-06-26	CL	Stock	73.72	73.73	72.27	72.35	2831100.0
2019-06-26	A	Stock	72.64	73.18	72.04	72.14	1583800.0
2019-06-26	AA	Stock	22.77	23.385	22.67	23.21	2578500.0
2019-06-26	AABA-DELISTED	Stock	69.38	70.16	69.2	69.66	5958861.0
2019-06-26	AAC-DELISTED	Stock	0.8	0.9182	0.8	0.8626	598587.0
2019-06-26	AACG	Stock	2.65	2.98	2.65	2.75	439700.0
2019-06-26	AAIC-DELISTED	Stock	6.5	6.735	6.5	6.67	873538.0
2019-06-26	AAIC.C-DELISTED	Stock	21.55	21.73	21.45	21.45	7301.0
2019-06-26	AAL	Stock	31.48	31.72	31.07	31.46	4089700.0
2019-06-26	AAM.A-DELISTED	Stock	25.69	25.7804	25.65	25.66	11349.0
2019-06-26	AAM.B-DELISTED	Stock	25.75	25.83	25.75	25.81	26403.0
2019-06-26	AAMC-DELISTED	Stock	4.1735	4.2647	4.0147	4.1147	12798.0
2019-06-26	AAME	Stock	2.49	2.49	2.49	2.49	100.0
2019-06-26	AAMI	Stock	10.89	10.98	10.82	10.97	361700.0
2019-06-26	AAOI	Stock	9.23	9.61	9.174	9.49	709700.0
2019-06-26	AAON	Stock	31.8667	32.6667	31.6733	32.32	135450.0
2019-06-26	AAP	Stock	153.69	153.92	149.2	149.93	1237800.0
2019-06-26	AAT	Stock	46.61	46.61	45.24	45.68	639500.0
2019-06-26	AAU-DELISTED	Stock	0.622	0.66	0.622	0.6365	174926.0
2019-06-26	AAUAF-DELISTED	Stock	0.622	0.66	0.622	0.6365	205270.0
2019-06-26	AAWW-DELISTED	Stock	40.73	42.38	40.73	41.97	196473.0
2019-06-26	AAXJ	Stock	69.22	69.51	69.2	69.26	1023943.0
2019-06-26	AAXN-DELISTED	Stock	69.2	69.8483	66.65	66.86	987730.0
2019-06-26	AB	Stock	28.76	29.17	28.71	28.95	121900.0
2019-06-26	ABB-DELISTED	Stock	19.79	19.85	19.75	19.78	927659.0
2019-06-26	ABBNY-DELISTED	Stock	19.79	19.85	19.75	19.78	1133543.0
2019-06-26	ABBV	Stock	67.24	68.41	66.8	68.0	42093800.0
2019-06-26	ABC-DELISTED	Stock	84.35	84.84	83.2539	83.81	834265.0
2019-06-26	ABCB	Stock	37.9	38.57	37.64	38.35	399800.0
2019-06-26	ABDC-DELISTED	Stock	8.69	8.74	8.68	8.69	109032.0
2019-06-26	ABEO	Stock	116.5	117.5	111.25	112.75	25700.0
2019-06-26	ABEOW-DELISTED	Stock	0.92	0.92	0.88	0.88	2600.0
2019-06-26	ABEV	Stock	4.74	4.77	4.66	4.7	27089100.0
2019-06-26	ABG	Stock	81.31	83.38	80.81	82.5	125100.0
2019-06-26	ABIL-DELISTED	Stock	0.9199	0.92	0.8803	0.91	24711.0
2019-06-26	ABM	Stock	39.14	39.28	38.68	38.93	307000.0
2019-06-26	ABMD-DELISTED	Stock	256.45	259.82	251.0	251.66	259222.0
2019-06-26	ABR	Stock	12.03	12.1	11.83	11.83	1746000.0
2019-06-26	ABR.A-DELISTED	Stock	26.14	26.14	26.084	26.084	365.0
2019-06-26	ABR.B-DELISTED	Stock	25.91	26.1936	25.58	25.58	2720.0
2019-06-26	ABT	Stock	84.05	84.37	82.63	82.96	5731400.0

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

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