PREVIEW / stock_daily / 2019-04-12

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-12.parquet
  size:    220 KB
  rows:    6,527
  symbols: 2,588

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-04-12	AAPL	Stock	49.8	50.035	49.0525	49.7175	111042800.0
2019-04-12	MSFT	Stock	120.64	120.98	120.37	120.95	19745100.0
2019-04-12	NVDA	Stock	4.8275	4.8315	4.7415	4.7502	471708000.0
2019-04-12	AMZN	Stock	92.42	92.575	92.065	92.153	62288000.0
2019-04-12	GOOGL	Stock	60.781	61.1525	60.6645	61.1365	24312200.0
2019-04-12	META	Stock	178.0	179.63	177.95	179.1	12329800.0
2019-04-12	TSLA	Stock	18.0147	18.13	17.7887	17.8467	101190000.0
2019-04-12	TLT	Stock	122.89	123.06	122.63	122.67	7005541.0
2019-04-12	ES	Stock	70.3	70.75	69.88	70.68	1181800.0
2019-04-12	CL	Stock	68.01	68.77	67.69	68.77	3849700.0
2019-04-12	A	Stock	81.43	82.06	80.9	80.98	1249300.0
2019-04-12	AA	Stock	28.9	29.2	28.25	28.29	2752800.0
2019-04-12	AABA-DELISTED	Stock	75.6	77.03	75.6	76.69	4136841.0
2019-04-12	AAC-DELISTED	Stock	2.03	2.12	1.965	2.09	85693.0
2019-04-12	AACG	Stock	2.86	2.91	2.5	2.5	1562000.0
2019-04-12	AAIC-DELISTED	Stock	7.75	7.7695	7.55	7.58	617174.0
2019-04-12	AAIC.C-DELISTED	Stock	23.4837	23.6	23.303	23.5499	4057.0
2019-04-12	AAL	Stock	34.99	35.24	34.5	34.69	4610500.0
2019-04-12	AAM.A-DELISTED	Stock	24.83	24.9	24.83	24.85	30524.0
2019-04-12	AAM.B-DELISTED	Stock	24.75	24.82	24.73	24.75	28306.0
2019-04-12	AAME	Stock	2.31	2.32	2.3	2.32	1900.0
2019-04-12	AAMI	Stock	14.1	14.61	14.1	14.54	722900.0
2019-04-12	AAOI	Stock	12.5	13.24	12.47	13.09	946700.0
2019-04-12	AAON	Stock	30.2533	30.86	30.2333	30.84	123150.0
2019-04-12	AAP	Stock	180.96	181.8	179.74	180.11	922600.0
2019-04-12	AAT	Stock	45.83	45.86	45.41	45.75	240800.0
2019-04-12	AAU-DELISTED	Stock	0.57	0.57	0.5525	0.5683	161681.0
2019-04-12	AAUAF-DELISTED	Stock	0.57	0.57	0.5525	0.5683	167918.0
2019-04-12	AAWW-DELISTED	Stock	50.66	51.86	50.35	51.6	554149.0
2019-04-12	AAXJ	Stock	73.2	73.29	73.02	73.2	775436.0
2019-04-12	AAXN-DELISTED	Stock	61.74	62.0	61.05	61.8418	327779.0
2019-04-12	AB	Stock	29.58	29.63	29.26	29.46	155600.0
2019-04-12	ABB-DELISTED	Stock	19.82	19.82	19.6932	19.73	1410861.0
2019-04-12	ABBNY-DELISTED	Stock	19.82	19.82	19.6932	19.72	1562935.0
2019-04-12	ABBV	Stock	80.67	81.81	79.84	80.78	5011500.0
2019-04-12	ABC-DELISTED	Stock	74.58	76.24	74.48	74.74	1309127.0
2019-04-12	ABCB	Stock	35.86	36.26	35.35	35.95	234800.0
2019-04-12	ABDC-DELISTED	Stock	7.82	7.88	7.7501	7.88	23341.0
2019-04-12	ABEO	Stock	192.75	195.0	183.75	192.25	21484.0
2019-04-12	ABEV	Stock	4.42	4.52	4.35	4.41	30096600.0
2019-04-12	ABG	Stock	73.46	75.56	73.42	75.35	191500.0
2019-04-12	ABIL-DELISTED	Stock	1.65	1.71	1.6	1.69	26573.0
2019-04-12	ABM	Stock	37.28	37.44	36.9	37.42	227200.0
2019-04-12	ABMD-DELISTED	Stock	272.14	273.0	267.6	270.08	773156.0
2019-04-12	ABR	Stock	13.69	13.75	13.61	13.74	700100.0
2019-04-12	ABR.A-DELISTED	Stock	25.7615	25.809	25.701	25.786	825.0
2019-04-12	ABR.B-DELISTED	Stock	25.55	25.55	25.485	25.485	273.0
2019-04-12	ABR.C-DELISTED	Stock	26.14	26.44	26.14	26.14	1931.0
2019-04-12	ABT	Stock	78.37	78.85	77.82	78.01	5482000.0
2019-04-12	ABTC	Stock	303300.0	303900.0	303300.0	303330.0	0.2

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

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