PREVIEW / stock_daily / 2019-07-29

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-29.parquet
  size:    222 KB
  rows:    6,618
  symbols: 2,556

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-07-29	AAPL	Stock	52.115	52.66	52.11	52.42	86693600.0
2019-07-29	MSFT	Stock	141.5	141.51	139.37	141.03	16605900.0
2019-07-29	NVDA	Stock	4.3695	4.3868	4.2818	4.3705	248160000.0
2019-07-29	AMZN	Stock	96.5	96.6115	94.527	95.6225	89864000.0
2019-07-29	GOOGL	Stock	62.125	62.4498	61.51	62.092	41382540.0
2019-07-29	META	Stock	199.0	199.63	195.3	195.94	16530800.0
2019-07-29	TSLA	Stock	15.1393	15.7293	15.0687	15.718	139099500.0
2019-07-29	TLT	Stock	131.82	131.9499	131.395	131.51	6231836.0
2019-07-29	ES	Stock	76.54	76.96	76.18	76.81	1039000.0
2019-07-29	CL	Stock	73.85	75.67	73.72	75.57	4635900.0
2019-07-29	A	Stock	69.5	70.5	69.38	70.37	2750000.0
2019-07-29	AA	Stock	23.06	23.57	22.9	23.12	2393900.0
2019-07-29	AABA-DELISTED	Stock	71.0	71.21	70.72	70.8901	1127309.0
2019-07-29	AAC-DELISTED	Stock	0.99	1.02	0.9556	0.9806	98892.0
2019-07-29	AACG	Stock	2.61	2.65	2.6	2.6	7300.0
2019-07-29	AAIC-DELISTED	Stock	6.59	6.71	6.59	6.68	234900.0
2019-07-29	AAIC.C-DELISTED	Stock	23.23	23.26	23.07	23.1	15603.0
2019-07-29	AAL	Stock	30.97	31.19	30.54	30.74	6963900.0
2019-07-29	AAM.A-DELISTED	Stock	26.41	26.5191	26.41	26.49	19807.0
2019-07-29	AAM.B-DELISTED	Stock	26.868	26.95	26.8	26.95	37314.0
2019-07-29	AAMC-DELISTED	Stock	3.1029	3.4618	3.0882	3.0882	6174.0
2019-07-29	AAME	Stock	2.49	2.49	2.36	2.48	700.0
2019-07-29	AAMI	Stock	11.1	11.16	10.86	10.9	266400.0
2019-07-29	AAOI	Stock	9.28	9.38	8.98	9.28	643900.0
2019-07-29	AAON	Stock	34.4267	34.4267	33.7267	33.7867	143250.0
2019-07-29	AAP	Stock	152.29	153.42	150.94	153.04	782500.0
2019-07-29	AAT	Stock	47.07	47.38	46.83	47.0	200300.0
2019-07-29	AAU-DELISTED	Stock	0.75	0.7678	0.7283	0.7571	139635.0
2019-07-29	AAUAF-DELISTED	Stock	0.75	0.7678	0.7283	0.7571	166164.0
2019-07-29	AAWW-DELISTED	Stock	45.56	45.56	43.58	45.02	123465.0
2019-07-29	AAXJ	Stock	69.15	69.22	68.93	69.12	554441.0
2019-07-29	AAXN-DELISTED	Stock	69.68	70.0809	68.09	68.5	321349.0
2019-07-29	AB	Stock	29.87	29.87	29.37	29.5	240900.0
2019-07-29	ABB-DELISTED	Stock	18.56	18.58	18.48	18.53	1684977.0
2019-07-29	ABBNY-DELISTED	Stock	18.56	18.58	18.48	18.53	2020708.0
2019-07-29	ABBV	Stock	67.87	68.41	66.88	67.18	10117300.0
2019-07-29	ABC-DELISTED	Stock	86.11	87.2579	86.1	87.22	631300.0
2019-07-29	ABCB	Stock	39.7	39.99	39.16	39.25	417800.0
2019-07-29	ABDC-DELISTED	Stock	8.37	8.38	8.28	8.32	6700.0
2019-07-29	ABEO	Stock	79.25	82.5	74.5	75.0	28976.0
2019-07-29	ABEV	Stock	5.23	5.43	5.2	5.4	35419600.0
2019-07-29	ABG	Stock	88.76	95.14	88.76	94.52	260700.0
2019-07-29	ABIL-DELISTED	Stock	0.75	0.816	0.75	0.8	96872.0
2019-07-29	ABM	Stock	42.0	42.22	41.56	41.75	362300.0
2019-07-29	ABMD-DELISTED	Stock	271.98	276.46	267.5934	276.01	269262.0
2019-07-29	ABR	Stock	12.11	12.25	12.11	12.21	732400.0
2019-07-29	ABR.A-DELISTED	Stock	26.1	26.11	26.1	26.11	2205.0
2019-07-29	ABR.B-DELISTED	Stock	25.8543	25.8999	25.83	25.865	1200.0
2019-07-29	ABR.C-DELISTED	Stock	26.5082	26.5082	26.5082	26.5082	400.0
2019-07-29	ABT	Stock	88.06	88.62	87.38	88.55	3623900.0

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

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