PREVIEW / stock_daily / 2019-05-07

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-07.parquet
  size:    220 KB
  rows:    6,521
  symbols: 2,565

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-07	AAPL	Stock	51.47	51.855	50.2075	50.715	155054800.0
2019-05-07	MSFT	Stock	126.46	127.18	124.22	125.52	36017700.0
2019-05-07	NVDA	Stock	4.4475	4.4475	4.2792	4.3278	555220000.0
2019-05-07	AMZN	Stock	96.9995	97.455	95.169	96.05	118042000.0
2019-05-07	GOOGL	Stock	59.2905	59.7385	58.25	58.943	36604760.0
2019-05-07	META	Stock	192.54	192.9	187.85	189.77	16253000.0
2019-05-07	TSLA	Stock	17.12	17.1473	16.34	16.4707	151971000.0
2019-05-07	TLT	Stock	124.53	125.14	124.39	124.95	8984929.0
2019-05-07	ES	Stock	73.18	73.27	71.23	71.51	1175000.0
2019-05-07	CL	Stock	71.27	71.58	69.55	70.51	4125500.0
2019-05-07	A	Stock	78.59	78.77	76.03	76.67	1732200.0
2019-05-07	AA	Stock	25.61	25.72	25.0	25.18	4020300.0
2019-05-07	AABA-DELISTED	Stock	75.4	75.6	72.74	73.35	4592233.0
2019-05-07	AAC-DELISTED	Stock	1.94	2.1	1.91	1.99	159140.0
2019-05-07	AACG	Stock	1.88	2.63	1.8	2.26	3445800.0
2019-05-07	AAIC-DELISTED	Stock	7.7	7.76	7.61	7.65	329950.0
2019-05-07	AAIC.C-DELISTED	Stock	23.4832	23.5	23.3544	23.5	3124.0
2019-05-07	AAL	Stock	34.25	34.33	33.41	33.91	6957800.0
2019-05-07	AAM.A-DELISTED	Stock	25.5966	25.5966	25.52	25.54	31064.0
2019-05-07	AAM.B-DELISTED	Stock	25.51	25.57	25.51	25.53	53394.0
2019-05-07	AAMC-DELISTED	Stock	8.0853	8.0853	7.6471	7.6471	11883.0
2019-05-07	AAME	Stock	2.35	2.35	2.35	2.35	500.0
2019-05-07	AAMI	Stock	13.69	13.885	13.69	13.82	498800.0
2019-05-07	AAOI	Stock	12.5	12.63	12.01	12.08	799300.0
2019-05-07	AAON	Stock	32.3867	32.5467	31.1467	31.5867	436800.0
2019-05-07	AAP	Stock	161.09	162.59	159.65	160.66	1069400.0
2019-05-07	AAT	Stock	46.11	46.11	44.62	45.06	142600.0
2019-05-07	AAU-DELISTED	Stock	0.495	0.5037	0.495	0.5024	90144.0
2019-05-07	AAUAF-DELISTED	Stock	0.495	0.5037	0.495	0.5024	93320.0
2019-05-07	AAWW-DELISTED	Stock	44.43	44.61	43.04	43.625	261454.0
2019-05-07	AAXJ	Stock	70.66	70.71	69.495	69.89	3086820.0
2019-05-07	AAXN-DELISTED	Stock	64.81	65.83	63.8671	64.63	735801.0
2019-05-07	AB	Stock	28.98	29.24	28.31	28.36	577200.0
2019-05-07	ABB-DELISTED	Stock	19.14	19.18	18.979	19.07	1832282.0
2019-05-07	ABBNY-DELISTED	Stock	19.14	19.18	18.979	19.06	1961739.0
2019-05-07	ABBV	Stock	78.6	78.99	77.17	77.95	4275300.0
2019-05-07	ABC-DELISTED	Stock	77.61	79.06	76.77	77.46	1389475.0
2019-05-07	ABCB	Stock	36.6	36.99	36.26	36.63	345400.0
2019-05-07	ABDC-DELISTED	Stock	8.27	8.43	8.25	8.27	25287.0
2019-05-07	ABEO	Stock	197.5	202.25	191.5	196.5	15936.0
2019-05-07	ABEV	Stock	4.5	4.5	4.31	4.47	47354700.0
2019-05-07	ABG	Stock	80.17	80.29	79.01	79.8	86800.0
2019-05-07	ABIL-DELISTED	Stock	1.42	1.4393	1.36	1.39	44216.0
2019-05-07	ABM	Stock	38.07	38.33	37.54	37.96	237100.0
2019-05-07	ABMD-DELISTED	Stock	266.43	268.72	256.74	261.98	691791.0
2019-05-07	ABR	Stock	13.51	13.62	13.29	13.36	2007800.0
2019-05-07	ABR.A-DELISTED	Stock	26.1919	26.38	26.1919	26.38	3247.0
2019-05-07	ABR.B-DELISTED	Stock	25.6214	25.93	25.6214	25.8125	1250.0
2019-05-07	ABR.C-DELISTED	Stock	26.49	26.66	26.4	26.658	1900.0
2019-05-07	ABT	Stock	78.5	78.87	76.2	76.91	5322500.0

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

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