PREVIEW / stock_daily / 2021-01-26

all stock daily files

  file:    by_date/stock_daily/2021/2021-01-26.parquet
  size:    244 KB
  rows:    7,371
  symbols: 2,686

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-01-26	AAPL	Stock	143.6	144.3	141.37	143.16	98390600.0
2021-01-26	MSFT	Stock	231.86	234.18	230.08	232.33	49169600.0
2021-01-26	NVDA	Stock	13.5805	13.6448	13.3875	13.4352	163980000.0
2021-01-26	AMZN	Stock	164.818	166.9	164.1435	166.3065	59104000.0
2021-01-26	GOOGL	Stock	94.2995	95.7875	93.8065	95.3975	31461560.0
2021-01-26	META	Stock	278.14	285.39	277.81	282.05	19373600.0
2021-01-26	TSLA	Stock	297.1267	298.6333	290.5333	294.3633	69394800.0
2021-01-26	TLT	Stock	153.1	153.6	152.92	153.38	7690318.0
2021-01-26	ES	Stock	90.01	90.46	88.84	89.89	1079500.0
2021-01-26	CL	Stock	78.87	79.09	77.93	78.75	5788400.0
2021-01-26	A	Stock	125.5	125.95	123.87	123.92	1476600.0
2021-01-26	AA	Stock	19.6	19.66	18.55	18.56	5928800.0
2021-01-26	AACG	Stock	1.43	1.43	1.37	1.38	14800.0
2021-01-26	AACQ-DELISTED	Stock	11.01	11.05	10.6	10.6301	1779587.0
2021-01-26	AACQU-DELISTED	Stock	11.8	11.85	11.4	11.4	67011.0
2021-01-26	AACQW-DELISTED	Stock	2.59	2.6	2.31	2.35	476584.0
2021-01-26	AAIC-DELISTED	Stock	3.82	3.89	3.785	3.87	158036.0
2021-01-26	AAIC.C-DELISTED	Stock	21.52	21.55	21.52	21.55	1967.0
2021-01-26	AAL	Stock	15.52	15.77	15.33	15.53	44571100.0
2021-01-26	AAM.A-DELISTED	Stock	26.32	26.5787	26.32	26.5	9494.0
2021-01-26	AAM.B-DELISTED	Stock	26.94	27.0135	26.85	26.9	7957.0
2021-01-26	AAMC-DELISTED	Stock	6.2853	6.2853	6.2353	6.2353	4430.0
2021-01-26	AAME	Stock	2.52	2.63	2.51	2.56	5800.0
2021-01-26	AAMI	Stock	20.83	20.95	20.4	20.48	194700.0
2021-01-26	AAN-DELISTED	Stock	20.89	21.06	19.2	19.32	305000.0
2021-01-26	AAOI	Stock	11.13	11.19	10.66	11.14	1228700.0
2021-01-26	AAON	Stock	49.2667	49.38	47.9133	49.1533	246000.0
2021-01-26	AAP	Stock	160.01	160.11	156.56	157.63	824700.0
2021-01-26	AAT	Stock	28.87	29.15	28.45	28.69	177700.0
2021-01-26	AAU-DELISTED	Stock	0.585	0.585	0.5701	0.5777	1862659.0
2021-01-26	AAUAF-DELISTED	Stock	0.585	0.585	0.5701	0.5795	1920734.0
2021-01-26	AAWW-DELISTED	Stock	53.7	55.82	53.1941	55.25	333974.0
2021-01-26	AAXJ	Stock	98.13	98.22	97.62	98.18	691633.0
2021-01-26	AB	Stock	37.39	38.06	37.05	37.64	679200.0
2021-01-26	ABB-DELISTED	Stock	30.25	30.62	30.16	30.49	1638775.0
2021-01-26	ABBNY-DELISTED	Stock	30.25	30.62	30.16	30.52	1797259.0
2021-01-26	ABBV	Stock	111.3	111.3	108.56	108.8	5554600.0
2021-01-26	ABC-DELISTED	Stock	107.67	109.62	106.935	108.85	615107.0
2021-01-26	ABCB	Stock	44.06	44.41	42.66	42.81	265900.0
2021-01-26	ABCL	Stock	49.29	49.96	46.056	47.77	499800.0
2021-01-26	ABCM-DELISTED	Stock	23.48	23.68	22.09	22.42	160915.0
2021-01-26	ABEO	Stock	58.0	59.25	54.0	56.0	156448.0
2021-01-26	ABEV	Stock	2.9	2.94	2.88	2.9	28030200.0
2021-01-26	ABG	Stock	158.91	158.91	154.32	155.42	326200.0
2021-01-26	ABM	Stock	40.07	40.4	39.74	40.11	240400.0
2021-01-26	ABMD-DELISTED	Stock	349.69	350.0	339.47	341.11	344050.0
2021-01-26	ABNB	Stock	180.0	193.0	177.3	192.74	6460900.0
2021-01-26	ABR	Stock	14.5	14.74	14.22	14.57	773900.0
2021-01-26	ABR.A-DELISTED	Stock	25.7907	25.8265	25.7601	25.8265	3260.0
2021-01-26	ABR.B-DELISTED	Stock	25.28	25.4776	25.28	25.33	4364.0

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

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