PREVIEW / stock_daily / 2019-04-10

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-10.parquet
  size:    221 KB
  rows:    6,531
  symbols: 2,586

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-10	AAPL	Stock	49.67	50.185	49.545	50.155	86781200.0
2019-04-10	MSFT	Stock	119.76	120.35	119.54	120.19	16477200.0
2019-04-10	NVDA	Stock	4.7307	4.8285	4.7262	4.8025	444772000.0
2019-04-10	AMZN	Stock	92.05	92.4	91.4405	92.3665	59280000.0
2019-04-10	GOOGL	Stock	60.2545	60.4469	60.033	60.3225	15509120.0
2019-04-10	META	Stock	178.18	178.79	176.54	177.82	11701500.0
2019-04-10	TSLA	Stock	18.4493	18.5587	18.1927	18.404	105919500.0
2019-04-10	TLT	Stock	124.27	124.52	124.1	124.28	7519916.0
2019-04-10	ES	Stock	71.08	71.4	70.24	70.31	1438800.0
2019-04-10	CL	Stock	68.05	68.39	67.82	68.11	2023100.0
2019-04-10	A	Stock	81.45	82.24	81.45	81.68	982900.0
2019-04-10	AA	Stock	29.21	29.34	28.88	29.15	2598100.0
2019-04-10	AABA-DELISTED	Stock	75.5	75.84	74.59	75.46	5909952.0
2019-04-10	AAC-DELISTED	Stock	2.11	2.18	2.06	2.17	100771.0
2019-04-10	AACG	Stock	2.57	4.5	2.27	3.85	53169400.0
2019-04-10	AAIC-DELISTED	Stock	7.92	7.95	7.86	7.89	304434.0
2019-04-10	AAIC.C-DELISTED	Stock	23.65	23.65	23.4556	23.59	5158.0
2019-04-10	AAL	Stock	33.76	34.13	33.09	34.02	7159500.0
2019-04-10	AAM.A-DELISTED	Stock	24.7918	24.879	24.7918	24.8	15961.0
2019-04-10	AAM.B-DELISTED	Stock	24.61	24.85	24.53	24.55	63884.0
2019-04-10	AAMC-DELISTED	Stock	9.0147	9.0147	8.5294	8.7941	36938.0
2019-04-10	AAME	Stock	2.35	2.5	2.35	2.48	10000.0
2019-04-10	AAMI	Stock	13.97	14.33	13.92	14.32	650200.0
2019-04-10	AAOI	Stock	12.1	12.42	11.98	12.3	404300.0
2019-04-10	AAON	Stock	29.88	30.06	29.5733	29.92	324000.0
2019-04-10	AAP	Stock	176.7	178.86	174.25	178.8	1079500.0
2019-04-10	AAT	Stock	45.67	46.22	45.52	46.08	255800.0
2019-04-10	AAU-DELISTED	Stock	0.57	0.5808	0.565	0.575	154785.0
2019-04-10	AAUAF-DELISTED	Stock	0.57	0.5808	0.565	0.575	157864.0
2019-04-10	AAWW-DELISTED	Stock	49.4	49.72	48.37	49.48	141257.0
2019-04-10	AAXJ	Stock	73.02	73.21	72.91	73.14	929495.0
2019-04-10	AAXN-DELISTED	Stock	58.75	60.37	58.2663	60.12	419705.0
2019-04-10	AB	Stock	29.11	29.4	29.03	29.36	228800.0
2019-04-10	ABB-DELISTED	Stock	19.42	19.46	19.37	19.45	1046613.0
2019-04-10	ABBNY-DELISTED	Stock	19.42	19.46	19.37	19.44	1275230.0
2019-04-10	ABBV	Stock	83.2	83.38	82.6	82.95	3641900.0
2019-04-10	ABC-DELISTED	Stock	75.35	75.45	72.15	74.01	2733546.0
2019-04-10	ABCB	Stock	34.82	35.18	34.4	35.09	252700.0
2019-04-10	ABDC-DELISTED	Stock	7.91	7.93	7.79	7.8	25418.0
2019-04-10	ABEO	Stock	181.75	190.75	177.5	188.5	7692.0
2019-04-10	ABEV	Stock	4.55	4.57	4.51	4.54	25170200.0
2019-04-10	ABG	Stock	71.77	72.69	71.09	72.64	143200.0
2019-04-10	ABIL-DELISTED	Stock	1.71	1.72	1.68	1.7	69722.0
2019-04-10	ABM	Stock	36.61	37.26	36.55	37.01	428400.0
2019-04-10	ABMD-DELISTED	Stock	282.77	282.77	278.2382	280.36	444086.0
2019-04-10	ABR	Stock	13.49	13.57	13.45	13.52	660300.0
2019-04-10	ABR.A-DELISTED	Stock	25.55	25.7953	25.55	25.62	5587.0
2019-04-10	ABR.B-DELISTED	Stock	25.51	25.67	25.33	25.48	6279.0
2019-04-10	ABR.C-DELISTED	Stock	26.2	26.41	26.0	26.27	2106.0
2019-04-10	ABT	Stock	78.72	79.42	78.56	78.97	5604600.0

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

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