PREVIEW / stock_daily / 2019-06-05

all stock daily files

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

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-05	AAPL	Stock	46.07	46.2475	45.285	45.635	119093600.0
2019-06-05	MSFT	Stock	124.95	125.87	124.21	125.83	24926100.0
2019-06-05	NVDA	Stock	3.6492	3.6548	3.4955	3.532	511616000.0
2019-06-05	AMZN	Stock	87.48	87.6	85.7625	86.925	84796000.0
2019-06-05	GOOGL	Stock	52.75	52.8405	51.65	52.232	46988720.0
2019-06-05	META	Stock	167.48	168.72	164.63	168.17	19758300.0
2019-06-05	TSLA	Stock	13.2453	13.4187	12.79	13.106	202662000.0
2019-06-05	TLT	Stock	130.52	130.95	130.12	130.19	8815195.0
2019-06-05	ES	Stock	74.88	76.42	74.65	76.32	2306800.0
2019-06-05	CL	Stock	71.12	71.95	70.64	71.92	2675200.0
2019-06-05	A	Stock	68.61	69.01	67.89	68.35	2289200.0
2019-06-05	AA	Stock	22.02	22.05	21.04	21.37	5820500.0
2019-06-05	AABA-DELISTED	Stock	61.47	61.79	59.72	60.68	7568378.0
2019-06-05	AAC-DELISTED	Stock	1.07	1.0946	0.972	0.991	184389.0
2019-06-05	AACG	Stock	1.81	1.87	1.81	1.84	19600.0
2019-06-05	AAIC-DELISTED	Stock	6.89	6.94	6.845	6.88	295192.0
2019-06-05	AAIC.C-DELISTED	Stock	22.04	22.2913	21.98	22.0425	12254.0
2019-06-05	AAL	Stock	29.76	30.45	29.46	30.36	8713700.0
2019-06-05	AAM.A-DELISTED	Stock	25.78	25.79	25.72	25.78	12510.0
2019-06-05	AAM.B-DELISTED	Stock	25.705	25.78	25.6701	25.78	29157.0
2019-06-05	AAMC-DELISTED	Stock	4.3676	4.4147	4.1353	4.2618	6008.0
2019-06-05	AAME	Stock	2.37	2.37	2.37	2.37	100.0
2019-06-05	AAMI	Stock	11.11	11.12	10.84	10.88	422800.0
2019-06-05	AAOI	Stock	9.26	9.33	8.936	9.23	741000.0
2019-06-05	AAON	Stock	32.0267	32.2667	31.5733	32.0533	237600.0
2019-06-05	AAP	Stock	155.26	156.02	152.64	154.61	1093000.0
2019-06-05	AAT	Stock	45.25	46.39	45.2	46.39	184300.0
2019-06-05	AAU-DELISTED	Stock	0.47	0.4828	0.4603	0.4823	194728.0
2019-06-05	AAUAF-DELISTED	Stock	0.47	0.4828	0.4603	0.4641	204337.0
2019-06-05	AAWW-DELISTED	Stock	39.7	39.91	38.42	38.61	253298.0
2019-06-05	AAXJ	Stock	66.63	66.63	65.93	66.17	891560.0
2019-06-05	AAXN-DELISTED	Stock	67.98	68.97	67.44	67.99	348209.0
2019-06-05	AB	Stock	28.14	28.27	27.78	28.15	123800.0
2019-06-05	ABB-DELISTED	Stock	19.04	19.05	18.8637	18.91	1322038.0
2019-06-05	ABBNY-DELISTED	Stock	19.04	19.05	18.8637	18.9	1393610.0
2019-06-05	ABBV	Stock	77.41	78.17	76.66	77.06	3804400.0
2019-06-05	ABC-DELISTED	Stock	82.86	83.19	81.0154	81.65	831491.0
2019-06-05	ABCB	Stock	37.21	37.42	36.31	37.03	276300.0
2019-06-05	ABDC-DELISTED	Stock	8.1623	8.19	8.05	8.07	43466.0
2019-06-05	ABEO	Stock	141.0	141.0	130.25	131.0	15484.0
2019-06-05	ABEV	Stock	4.52	4.55	4.46	4.46	22313600.0
2019-06-05	ABG	Stock	80.52	80.99	77.57	77.8	104200.0
2019-06-05	ABIL-DELISTED	Stock	1.21	1.22	1.18	1.1969	55018.0
2019-06-05	ABM	Stock	37.48	37.65	36.7	37.28	584900.0
2019-06-05	ABMD-DELISTED	Stock	270.0	271.74	263.97	268.8	570568.0
2019-06-05	ABR	Stock	12.57	12.61	12.47	12.53	1233800.0
2019-06-05	ABR.B-DELISTED	Stock	25.7839	25.84	25.4001	25.55	5361.0
2019-06-05	ABR.C-DELISTED	Stock	25.9416	26.187	25.9416	26.187	2900.0
2019-06-05	ABT	Stock	77.84	78.85	77.83	78.69	5286200.0
2019-06-05	ABTC	Stock	306600.0	309030.0	306120.0	309000.0	1.0133333333333332

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

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