PREVIEW / stock_daily / 2022-05-06

all stock daily files

  file:    by_date/stock_daily/2022/2022-05-06.parquet
  size:    258 KB
  rows:    7,946
  symbols: 2,385

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
2022-05-06	AAPL	Stock	156.01	159.44	154.18	157.28	116124600.0
2022-05-06	MSFT	Stock	274.81	279.25	271.27	274.73	37780300.0
2022-05-06	NVDA	Stock	18.736	19.512	17.99	18.675	633297000.0
2022-05-06	AMZN	Stock	114.85	119.0505	113.0815	114.7725	124260000.0
2022-05-06	GOOGL	Stock	115.1845	117.5715	114.0155	115.7465	39709580.0
2022-05-06	META	Stock	207.34	209.38	201.02	203.77	34747200.0
2022-05-06	TSLA	Stock	295.6667	296.0	281.0367	288.55	72903000.0
2022-05-06	TLT	Stock	114.14	115.04	113.31	113.67	32790491.0
2022-05-06	ES	Stock	89.29	91.41	89.29	90.4	2038000.0
2022-05-06	CL	Stock	76.07	77.06	75.77	76.84	5379600.0
2022-05-06	A	Stock	120.88	121.88	118.0	121.08	1629000.0
2022-05-06	AA	Stock	62.37	62.8	60.0	61.04	5591500.0
2022-05-06	AAC-DELISTED	Stock	9.83	9.835	9.81	9.81	1711212.0
2022-05-06	AACG	Stock	1.15	1.16	1.14	1.14	17600.0
2022-05-06	AACIU	Stock	9.96	9.96	9.96	9.96	488.0
2022-05-06	AAIC-DELISTED	Stock	3.21	3.2257	3.1	3.1	161215.0
2022-05-06	AAIC.C-DELISTED	Stock	24.6553	24.74	24.5	24.55	1036.0
2022-05-06	AAL	Stock	18.45	18.47	17.61	17.84	34360000.0
2022-05-06	AAM.A-DELISTED	Stock	24.65	24.79	24.5	24.71	8527.0
2022-05-06	AAM.B-DELISTED	Stock	24.98	25.1	24.86	24.96	19659.0
2022-05-06	AAMC-DELISTED	Stock	3.1647	3.1647	2.9412	3.0882	19944.0
2022-05-06	AAME	Stock	2.92	3.05	2.92	2.99	3900.0
2022-05-06	AAMI	Stock	20.98	21.19	20.02	20.25	598900.0
2022-05-06	AAN-DELISTED	Stock	20.84	21.02	20.2	20.26	153000.0
2022-05-06	AAOI	Stock	2.59	2.67	2.42	2.53	305200.0
2022-05-06	AAON	Stock	35.1467	35.1467	33.24	34.74	665100.0
2022-05-06	AAP	Stock	200.25	203.86	196.68	202.86	794700.0
2022-05-06	AAQC-DELISTED	Stock	9.78	9.79	9.78	9.78	22333.0
2022-05-06	AAT	Stock	34.58	34.85	33.92	34.38	188200.0
2022-05-06	AATC	Stock	6.4	6.425	6.31	6.33	7515.0
2022-05-06	AAU-DELISTED	Stock	0.2831	0.31	0.2831	0.2926	372918.0
2022-05-06	AAUAF-DELISTED	Stock	0.2831	0.31	0.2831	0.2926	378639.0
2022-05-06	AAWW-DELISTED	Stock	72.33	72.485	69.34	71.06	395658.0
2022-05-06	AAXJ	Stock	68.88	69.07	68.22	68.61	2109882.0
2022-05-06	AB	Stock	39.83	40.5	38.75	39.9	502100.0
2022-05-06	ABB-DELISTED	Stock	29.28	29.29	28.72	29.01	3099398.0
2022-05-06	ABBNY-DELISTED	Stock	29.28	29.29	28.72	29.0	3313796.0
2022-05-06	ABBV	Stock	149.68	153.52	149.01	152.83	6145600.0
2022-05-06	ABC-DELISTED	Stock	154.4	159.165	154.03	159.01	1293203.0
2022-05-06	ABCB	Stock	43.36	43.61	42.13	42.88	476200.0
2022-05-06	ABCL	Stock	7.75	7.75	7.057	7.44	1934100.0
2022-05-06	ABCM-DELISTED	Stock	14.19	14.19	13.7636	13.86	77772.0
2022-05-06	ABEO	Stock	4.75	4.75	4.0	4.0	156996.0
2022-05-06	ABEV	Stock	2.65	2.71	2.62	2.62	30264900.0
2022-05-06	ABG	Stock	190.41	194.18	188.38	191.63	208400.0
2022-05-06	ABGI-DELISTED	Stock	9.8101	9.8101	9.81	9.81	10467.0
2022-05-06	ABM	Stock	46.74	46.74	45.52	46.19	528400.0
2022-05-06	ABMD-DELISTED	Stock	270.93	270.93	252.06	257.67	266275.0
2022-05-06	ABNB	Stock	142.7	143.11	133.04	135.84	9573100.0
2022-05-06	ABOS	Stock	3.71	3.79	3.55	3.64	130000.0

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

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