PREVIEW / stock_daily / 2019-03-22

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-22.parquet
  size:    219 KB
  rows:    6,517
  symbols: 2,593

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-03-22	AAPL	Stock	48.835	49.4225	47.695	47.7625	169630800.0
2019-03-22	MSFT	Stock	119.5	119.59	117.04	117.05	33624500.0
2019-03-22	NVDA	Stock	4.571	4.62	4.4235	4.4375	747644000.0
2019-03-22	AMZN	Stock	90.5085	90.949	88.1555	88.2385	127260000.0
2019-03-22	GOOGL	Stock	61.4425	61.6815	60.3	60.3825	34422660.0
2019-03-22	META	Stock	165.65	167.42	164.09	164.34	16389200.0
2019-03-22	TSLA	Stock	18.172	18.1867	17.6	17.6353	131184000.0
2019-03-22	TLT	Stock	124.21	125.28	124.06	124.86	13077043.0
2019-03-22	ES	Stock	71.19	72.15	71.02	71.69	1482700.0
2019-03-22	CL	Stock	65.78	66.44	65.2	66.0	2877600.0
2019-03-22	A	Stock	81.54	81.68	78.97	78.99	1435800.0
2019-03-22	AA	Stock	29.1	29.27	27.8	28.12	3356000.0
2019-03-22	AABA-DELISTED	Stock	73.06	73.35	71.72	72.0	9642520.0
2019-03-22	AAC-DELISTED	Stock	2.31	2.33	2.03	2.13	198880.0
2019-03-22	AACG	Stock	1.03	1.03	1.0	1.03	29100.0
2019-03-22	AAIC-DELISTED	Stock	8.22	8.3	8.16	8.25	719591.0
2019-03-22	AAIC.C-DELISTED	Stock	23.35	23.385	23.06	23.06	13428.0
2019-03-22	AAL	Stock	31.32	31.44	30.53	30.57	7488900.0
2019-03-22	AAM.A-DELISTED	Stock	25.0946	25.0946	25.02	25.0699	16316.0
2019-03-22	AAM.B-DELISTED	Stock	24.79	24.79	24.62	24.68	25842.0
2019-03-22	AAMC-DELISTED	Stock	9.9676	10.1471	9.9676	10.1471	1785.0
2019-03-22	AAME	Stock	2.65	2.65	2.65	2.65	100.0
2019-03-22	AAMI	Stock	13.07	13.115	12.45	12.54	514400.0
2019-03-22	AAOI	Stock	13.72	13.74	12.66	12.71	1105800.0
2019-03-22	AAON	Stock	29.24	29.5667	28.1933	28.2533	289950.0
2019-03-22	AAP	Stock	168.33	168.58	164.72	164.84	941600.0
2019-03-22	AAT	Stock	45.65	46.06	45.11	45.11	269900.0
2019-03-22	AAU-DELISTED	Stock	0.61	0.61	0.5951	0.6	99509.0
2019-03-22	AAUAF-DELISTED	Stock	0.61	0.61	0.5951	0.6	108923.0
2019-03-22	AAWW-DELISTED	Stock	48.56	48.7	46.58	46.66	220913.0
2019-03-22	AAXJ	Stock	70.49	70.56	69.56	69.56	1846417.0
2019-03-22	AAXN-DELISTED	Stock	54.11	55.08	52.0	52.06	657222.0
2019-03-22	AB	Stock	28.74	28.85	27.41	27.82	512400.0
2019-03-22	ABB-DELISTED	Stock	18.89	18.94	18.58	18.585	2801614.0
2019-03-22	ABBNY-DELISTED	Stock	18.91	18.94	18.58	18.58	2904184.0
2019-03-22	ABBV	Stock	80.78	81.99	79.69	79.76	4992500.0
2019-03-22	ABC-DELISTED	Stock	80.14	80.38	78.67	78.77	829771.0
2019-03-22	ABCB	Stock	34.57	34.72	33.02	33.49	512600.0
2019-03-22	ABDC-DELISTED	Stock	7.55	7.61	7.5	7.57	23837.0
2019-03-22	ABEO	Stock	206.75	206.75	187.0	188.0	23156.0
2019-03-22	ABEV	Stock	4.29	4.34	4.23	4.28	54303800.0
2019-03-22	ABG	Stock	69.38	69.46	66.83	66.89	168300.0
2019-03-22	ABIL-DELISTED	Stock	1.96	2.0	1.9	1.92	105535.0
2019-03-22	ABM	Stock	34.66	34.66	33.6	33.88	816500.0
2019-03-22	ABMD-DELISTED	Stock	334.24	337.39	322.87	323.21	282545.0
2019-03-22	ABR	Stock	12.88	12.94	12.78	12.83	1090500.0
2019-03-22	ABR.A-DELISTED	Stock	25.6694	25.7669	25.6645	25.6645	399.0
2019-03-22	ABR.C-DELISTED	Stock	25.99	26.0	25.99	26.0	870.0
2019-03-22	ABT	Stock	79.81	80.0	77.69	77.97	7532900.0
2019-03-22	ABTC	Stock	304500.0	304500.0	302400.0	304350.0	3.76

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

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