PREVIEW / stock_daily / 2021-03-19

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-19.parquet
  size:    254 KB
  rows:    7,665
  symbols: 2,893

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
2021-03-19	AAPL	Stock	119.9	121.43	119.68	119.99	185549500.0
2021-03-19	MSFT	Stock	231.02	232.47	229.35	230.35	46430700.0
2021-03-19	NVDA	Stock	12.75	12.9215	12.6125	12.8458	299208000.0
2021-03-19	AMZN	Stock	151.4615	153.8645	150.8315	153.748	92508000.0
2021-03-19	GOOGL	Stock	101.4865	101.852	100.1465	101.348	46071920.0
2021-03-19	META	Stock	281.22	292.8	281.2	290.11	38930500.0
2021-03-19	TSLA	Stock	215.5333	219.0767	208.2067	218.29	128682000.0
2021-03-19	TLT	Stock	134.08	134.83	133.8	134.75	18684950.0
2021-03-19	ES	Stock	81.66	83.08	80.61	82.14	4682900.0
2021-03-19	CL	Stock	76.1	76.5	74.85	74.98	11878800.0
2021-03-19	A	Stock	122.87	123.5	121.51	122.69	2597000.0
2021-03-19	AA	Stock	31.13	31.62	30.07	31.14	6934800.0
2021-03-19	AACG	Stock	4.81	5.5	4.64	5.29	1743400.0
2021-03-19	AACQ-DELISTED	Stock	10.45	10.535	10.295	10.32	1404688.0
2021-03-19	AACQU-DELISTED	Stock	11.0934	11.36	11.0934	11.11	9872.0
2021-03-19	AACQW-DELISTED	Stock	2.39	2.4485	2.19	2.2	148297.0
2021-03-19	AAIC-DELISTED	Stock	4.0	4.115	3.93	3.96	464544.0
2021-03-19	AAIC.C-DELISTED	Stock	22.3999	22.45	22.34	22.3601	9528.0
2021-03-19	AAL	Stock	24.68	25.11	23.88	24.97	49461200.0
2021-03-19	AAM.A-DELISTED	Stock	25.85	25.93	25.83	25.93	12371.0
2021-03-19	AAM.B-DELISTED	Stock	26.63	26.67	26.5248	26.67	9357.0
2021-03-19	AAMC-DELISTED	Stock	5.6794	5.7353	5.1529	5.1559	71087.0
2021-03-19	AAME	Stock	5.49	6.74	5.12	5.7	19828200.0
2021-03-19	AAMI	Stock	19.54	20.07	19.01	19.85	1071600.0
2021-03-19	AAN-DELISTED	Stock	26.0	26.41	25.37	25.86	658600.0
2021-03-19	AAOI	Stock	8.49	8.62	8.34	8.48	1006800.0
2021-03-19	AAON	Stock	48.4667	48.7467	47.68	48.2267	672300.0
2021-03-19	AAP	Stock	182.05	187.18	181.45	186.0	1818900.0
2021-03-19	AAT	Stock	34.98	35.14	33.75	33.75	766100.0
2021-03-19	AAU-DELISTED	Stock	0.615	0.615	0.5969	0.6032	4199414.0
2021-03-19	AAUAF-DELISTED	Stock	0.615	0.615	0.5969	0.613	4266550.0
2021-03-19	AAWW-DELISTED	Stock	59.31	59.68	57.27	59.22	718533.0
2021-03-19	AAXJ	Stock	93.48	94.37	93.12	94.3	450016.0
2021-03-19	AB	Stock	41.66	42.93	41.58	42.36	651800.0
2021-03-19	ABB-DELISTED	Stock	30.88	31.455	30.74	31.36	2642545.0
2021-03-19	ABBNY-DELISTED	Stock	30.88	31.455	30.74	31.36	2822906.0
2021-03-19	ABBV	Stock	103.93	104.43	102.92	103.42	10899100.0
2021-03-19	ABC-DELISTED	Stock	115.35	117.12	115.025	115.96	2152823.0
2021-03-19	ABCB	Stock	54.36	56.23	53.82	55.98	1748200.0
2021-03-19	ABCL	Stock	31.5	32.19	30.81	31.2	858900.0
2021-03-19	ABCM-DELISTED	Stock	20.59	21.06	20.43	21.01	174280.0
2021-03-19	ABEO	Stock	54.5	56.25	52.75	54.5	85460.0
2021-03-19	ABEV	Stock	2.79	2.89	2.78	2.87	20946000.0
2021-03-19	ABG	Stock	193.69	193.69	186.76	188.54	386400.0
2021-03-19	ABGI-DELISTED	Stock	9.95	10.01	9.94	10.01	266961.0
2021-03-19	ABM	Stock	50.21	50.7	48.65	50.39	1008400.0
2021-03-19	ABMD-DELISTED	Stock	299.91	303.36	295.3	299.27	386031.0
2021-03-19	ABNB	Stock	193.01	196.49	187.81	194.39	4444600.0
2021-03-19	ABR	Stock	16.75	16.89	16.3	16.63	2018800.0
2021-03-19	ABR.A-DELISTED	Stock	25.64	25.73	25.64	25.65	2115.0

> showing 50 of 7,665 rows — these rows as CSV

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