PREVIEW / stock_daily / 2021-04-01

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-01.parquet
  size:    253 KB
  rows:    7,742
  symbols: 2,920

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-04-01	AAPL	Stock	123.66	124.18	122.49	123.0	75089100.0
2021-04-01	MSFT	Stock	238.47	242.84	238.05	242.35	30338000.0
2021-04-01	NVDA	Stock	13.5722	13.87	13.5113	13.8118	308276000.0
2021-04-01	AMZN	Stock	155.897	158.122	155.7775	158.05	58806000.0
2021-04-01	GOOGL	Stock	104.6125	106.7875	104.5715	106.489	39880100.0
2021-04-01	META	Stock	298.4	302.4	296.6	298.66	17616000.0
2021-04-01	TSLA	Stock	229.4567	230.8067	219.8067	220.5833	105895200.0
2021-04-01	TLT	Stock	136.55	137.62	136.3	137.51	14885947.0
2021-04-01	ES	Stock	86.58	86.66	85.79	86.47	846400.0
2021-04-01	CL	Stock	78.53	79.06	77.58	78.55	4881300.0
2021-04-01	A	Stock	128.0	128.3	127.01	127.69	1126400.0
2021-04-01	AA	Stock	32.2	32.58	31.49	32.23	5482100.0
2021-04-01	AAC-DELISTED	Stock	9.98	9.98	9.74	9.77	150673.0
2021-04-01	AACG	Stock	4.41	4.5	4.17	4.19	382300.0
2021-04-01	AACQ-DELISTED	Stock	10.1	10.36	10.1	10.33	1123458.0
2021-04-01	AACQU-DELISTED	Stock	10.74	10.79	10.71	10.77	2616.0
2021-04-01	AACQW-DELISTED	Stock	1.75	1.8	1.71	1.77	103942.0
2021-04-01	AAIC-DELISTED	Stock	4.05	4.16	4.04	4.15	174416.0
2021-04-01	AAIC.C-DELISTED	Stock	23.51	23.7	23.285	23.6	7445.0
2021-04-01	AAL	Stock	24.02	24.23	23.65	23.86	25956200.0
2021-04-01	AAM.A-DELISTED	Stock	25.95	26.09	25.95	26.04	24442.0
2021-04-01	AAM.B-DELISTED	Stock	26.83	27.01	26.83	26.92	25212.0
2021-04-01	AAMC-DELISTED	Stock	5.5882	6.0266	5.5882	5.8647	33157.0
2021-04-01	AAME	Stock	3.86	4.11	3.7	4.0	373700.0
2021-04-01	AAMI	Stock	20.54	20.92	20.07	20.79	528500.0
2021-04-01	AAN-DELISTED	Stock	25.61	26.215	25.61	26.01	178600.0
2021-04-01	AAOI	Stock	8.32	8.88	8.32	8.82	618100.0
2021-04-01	AAON	Stock	46.7533	47.4467	46.3867	47.2467	249900.0
2021-04-01	AAP	Stock	183.25	186.79	181.57	185.96	829000.0
2021-04-01	AAT	Stock	32.63	33.03	32.4	33.02	234300.0
2021-04-01	AAU-DELISTED	Stock	0.539	0.5585	0.533	0.5583	1642573.0
2021-04-01	AAUAF-DELISTED	Stock	0.539	0.5585	0.533	0.5583	1701346.0
2021-04-01	AAWW-DELISTED	Stock	60.58	61.3	60.06	61.16	295576.0
2021-04-01	AAXJ	Stock	93.97	94.2	93.6	93.71	677130.0
2021-04-01	AB	Stock	40.1	40.94	40.0	40.94	353800.0
2021-04-01	ABB-DELISTED	Stock	30.48	30.71	30.425	30.67	1168201.0
2021-04-01	ABBNY-DELISTED	Stock	30.49	30.71	30.425	30.66	1351664.0
2021-04-01	ABBV	Stock	108.92	108.98	107.32	108.52	5091700.0
2021-04-01	ABC-DELISTED	Stock	117.94	118.0	114.72	116.87	856670.0
2021-04-01	ABCB	Stock	52.68	53.53	52.12	53.24	314300.0
2021-04-01	ABCL	Stock	36.25	39.06	30.0	30.71	4230900.0
2021-04-01	ABCM-DELISTED	Stock	19.41	19.81	19.41	19.68	57201.0
2021-04-01	ABEO	Stock	48.0	50.0	44.75	46.5	74464.0
2021-04-01	ABEV	Stock	2.73	2.73	2.65	2.67	14989500.0
2021-04-01	ABG	Stock	196.86	198.63	192.32	196.71	90700.0
2021-04-01	ABGI-DELISTED	Stock	9.89	9.9	9.888	9.9	22455.0
2021-04-01	ABM	Stock	51.07	51.43	50.39	50.87	378300.0
2021-04-01	ABMD-DELISTED	Stock	321.1	322.588	314.61	315.16	123801.0
2021-04-01	ABNB	Stock	192.5	193.99	185.37	188.24	2921400.0
2021-04-01	ABR	Stock	16.01	16.16	15.75	16.16	1419600.0

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

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