PREVIEW / stock_daily / 2021-01-13

all stock daily files

  file:    by_date/stock_daily/2021/2021-01-13.parquet
  size:    242 KB
  rows:    7,314
  symbols: 2,654

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-13	AAPL	Stock	128.76	131.45	128.49	130.89	88636800.0
2021-01-13	MSFT	Stock	214.02	216.76	213.93	216.34	20087100.0
2021-01-13	NVDA	Stock	13.49	13.625	13.385	13.5318	210028000.0
2021-01-13	AMZN	Stock	156.422	159.4975	156.104	158.2945	66424000.0
2021-01-13	GOOGL	Stock	86.366	87.8195	86.366	87.3625	23431800.0
2021-01-13	META	Stock	251.55	253.95	249.2	251.64	19528900.0
2021-01-13	TSLA	Stock	284.2533	286.8233	277.3333	284.8033	99937500.0
2021-01-13	TLT	Stock	151.66	153.07	151.57	152.65	12533256.0
2021-01-13	ES	Stock	89.7	92.21	89.22	90.16	2092000.0
2021-01-13	CL	Stock	82.25	82.93	82.25	82.49	4069400.0
2021-01-13	A	Stock	127.46	128.05	126.74	126.98	1530400.0
2021-01-13	AA	Stock	25.14	25.15	24.31	24.44	2599900.0
2021-01-13	AACG	Stock	1.21	1.26	1.21	1.21	31600.0
2021-01-13	AACQ-DELISTED	Stock	11.15	11.25	10.96	11.03	1365074.0
2021-01-13	AACQU-DELISTED	Stock	11.88	12.05	11.79	11.85	209590.0
2021-01-13	AACQW-DELISTED	Stock	2.6	2.6	2.4	2.54	407604.0
2021-01-13	AAIC-DELISTED	Stock	3.94	3.97	3.89	3.95	145942.0
2021-01-13	AAIC.C-DELISTED	Stock	21.22	21.25	21.22	21.22	1088.0
2021-01-13	AAL	Stock	15.29	15.63	15.11	15.53	42629300.0
2021-01-13	AAM.A-DELISTED	Stock	26.24	26.51	26.2302	26.5	24170.0
2021-01-13	AAM.B-DELISTED	Stock	26.84	26.85	26.59	26.73	20704.0
2021-01-13	AAMC-DELISTED	Stock	6.1882	6.5029	6.1853	6.4706	14413.0
2021-01-13	AAME	Stock	2.35	2.35	2.2	2.25	5900.0
2021-01-13	AAMI	Stock	20.86	21.25	20.61	21.08	264400.0
2021-01-13	AAN-DELISTED	Stock	20.71	21.67	20.68	21.5	587300.0
2021-01-13	AAOI	Stock	10.43	10.44	9.845	10.17	806600.0
2021-01-13	AAON	Stock	47.6467	47.76	46.5867	46.7133	211200.0
2021-01-13	AAP	Stock	176.02	176.11	171.25	171.76	880800.0
2021-01-13	AAT	Stock	28.13	28.8	28.13	28.47	230100.0
2021-01-13	AAU-DELISTED	Stock	0.616	0.6821	0.573	0.6374	7157140.0
2021-01-13	AAUAF-DELISTED	Stock	0.616	0.6821	0.573	0.65	7289458.0
2021-01-13	AAWW-DELISTED	Stock	51.91	53.63	51.34	53.47	332787.0
2021-01-13	AAXJ	Stock	95.03	95.51	94.59	95.06	639760.0
2021-01-13	AAXN-DELISTED	Stock	136.67	146.055	135.245	145.27	927366.0
2021-01-13	AB	Stock	36.03	36.19	35.84	35.93	252400.0
2021-01-13	ABB-DELISTED	Stock	30.42	30.525	30.245	30.27	2132100.0
2021-01-13	ABBNY-DELISTED	Stock	30.42	30.525	30.245	30.27	2249200.0
2021-01-13	ABBV	Stock	109.8	113.41	109.7	112.45	9821300.0
2021-01-13	ABC-DELISTED	Stock	106.32	106.52	105.4	105.62	586535.0
2021-01-13	ABCB	Stock	43.98	44.42	43.04	44.02	422400.0
2021-01-13	ABCL	Stock	39.9	44.99	39.72	43.88	1914300.0
2021-01-13	ABCM-DELISTED	Stock	22.89	24.02	22.66	23.58	218389.0
2021-01-13	ABEO	Stock	46.0	46.0	44.25	44.75	44324.0
2021-01-13	ABEV	Stock	3.08	3.1	3.02	3.08	23126200.0
2021-01-13	ABG	Stock	165.44	166.39	160.41	162.26	102500.0
2021-01-13	ABM	Stock	41.23	42.22	40.93	41.73	332200.0
2021-01-13	ABMD-DELISTED	Stock	323.53	327.3482	321.93	323.71	212429.0
2021-01-13	ABNB	Stock	160.81	178.62	159.35	169.99	12529700.0
2021-01-13	ABR	Stock	14.26	14.44	14.13	14.21	798700.0
2021-01-13	ABR.A-DELISTED	Stock	25.615	25.615	25.615	25.615	118.0

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

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