PREVIEW / stock_daily / 2019-05-22

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-22.parquet
  size:    219 KB
  rows:    6,535
  symbols: 2,559

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-05-22	AAPL	Stock	46.165	46.4275	45.6375	45.695	118994400.0
2019-05-22	MSFT	Stock	126.62	128.24	126.52	127.67	15396500.0
2019-05-22	NVDA	Stock	3.8375	3.8638	3.794	3.805	325868000.0
2019-05-22	AMZN	Stock	92.589	93.5745	92.55	92.984	58732000.0
2019-05-22	GOOGL	Stock	57.5625	58.189	57.55	57.7925	18825580.0
2019-05-22	META	Stock	184.73	186.74	183.61	185.32	9213800.0
2019-05-22	TSLA	Stock	13.2733	13.596	12.7853	12.8487	280278000.0
2019-05-22	TLT	Stock	125.77	126.33	125.72	126.25	5675312.0
2019-05-22	ES	Stock	73.39	73.77	73.1	73.74	852600.0
2019-05-22	CL	Stock	71.27	71.65	71.02	71.53	3862500.0
2019-05-22	A	Stock	68.17	68.64	67.51	67.97	4985400.0
2019-05-22	AA	Stock	24.6	24.75	24.04	24.24	2198400.0
2019-05-22	AABA-DELISTED	Stock	64.9	65.0	63.07	63.36	5121049.0
2019-05-22	AAC-DELISTED	Stock	1.3	1.35	1.11	1.16	623392.0
2019-05-22	AACG	Stock	2.25	2.26	2.05	2.05	137200.0
2019-05-22	AAIC-DELISTED	Stock	7.2	7.245	7.07	7.12	347622.0
2019-05-22	AAIC.C-DELISTED	Stock	23.6046	23.6046	23.17	23.49	13011.0
2019-05-22	AAL	Stock	31.23	31.23	29.81	29.92	10258700.0
2019-05-22	AAM.A-DELISTED	Stock	25.7	25.75	25.7	25.7	5198.0
2019-05-22	AAM.B-DELISTED	Stock	25.69	25.73	25.65	25.72	22923.0
2019-05-22	AAMC-DELISTED	Stock	6.0294	6.0294	6.0294	6.0294	2618.0
2019-05-22	AAME	Stock	2.24	2.46	2.24	2.46	1100.0
2019-05-22	AAMI	Stock	11.9	11.93	11.71	11.73	455900.0
2019-05-22	AAOI	Stock	9.42	9.46	9.0	9.08	545300.0
2019-05-22	AAON	Stock	31.7333	31.9	30.84	30.9133	169200.0
2019-05-22	AAP	Stock	165.69	170.99	164.6	166.29	3608400.0
2019-05-22	AAT	Stock	46.01	46.03	45.66	45.85	132000.0
2019-05-22	AAU-DELISTED	Stock	0.4465	0.4556	0.4461	0.4543	110948.0
2019-05-22	AAUAF-DELISTED	Stock	0.4465	0.4556	0.4461	0.4543	116388.0
2019-05-22	AAWW-DELISTED	Stock	39.95	40.1041	38.8	38.9	154802.0
2019-05-22	AAXJ	Stock	66.31	66.37	66.1	66.23	541287.0
2019-05-22	AAXN-DELISTED	Stock	67.43	68.32	67.0	68.31	244310.0
2019-05-22	AB	Stock	28.87	29.02	28.63	28.66	125600.0
2019-05-22	ABB-DELISTED	Stock	18.91	19.01	18.865	18.965	2300291.0
2019-05-22	ABBNY-DELISTED	Stock	18.91	19.01	18.865	18.96	2383636.0
2019-05-22	ABBV	Stock	80.51	81.75	79.88	81.59	4219500.0
2019-05-22	ABC-DELISTED	Stock	80.47	82.08	80.16	81.8	1367419.0
2019-05-22	ABCB	Stock	36.26	36.29	35.62	36.11	176900.0
2019-05-22	ABDC-DELISTED	Stock	8.47	8.6999	8.4	8.65	49451.0
2019-05-22	ABEO	Stock	183.75	186.25	174.75	175.25	16988.0
2019-05-22	ABEOW-DELISTED	Stock	2.56	2.56	2.56	2.56	200.0
2019-05-22	ABEV	Stock	4.25	4.3	4.22	4.25	36243500.0
2019-05-22	ABG	Stock	78.78	78.78	77.11	77.63	82400.0
2019-05-22	ABIL-DELISTED	Stock	1.26	1.32	1.25	1.27	18279.0
2019-05-22	ABM	Stock	37.82	38.07	37.74	38.05	145800.0
2019-05-22	ABMD-DELISTED	Stock	260.14	266.89	260.14	265.61	421859.0
2019-05-22	ABR	Stock	13.14	13.17	12.73	12.88	1884400.0
2019-05-22	ABR.B-DELISTED	Stock	25.856	25.856	25.856	25.856	400.0
2019-05-22	ABR.C-DELISTED	Stock	26.3286	26.3286	26.3286	26.3286	300.0
2019-05-22	ABT	Stock	76.14	76.59	75.85	76.26	3062700.0

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

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