PREVIEW / stock_daily / 2022-04-19

all stock daily files

  file:    by_date/stock_daily/2022/2022-04-19.parquet
  size:    259 KB
  rows:    7,975
  symbols: 2,432

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-04-19	AAPL	Stock	165.02	167.82	163.91	167.4	67723800.0
2022-04-19	MSFT	Stock	279.38	286.17	278.41	285.3	22297700.0
2022-04-19	NVDA	Stock	21.72	22.373	21.314	22.198	512781000.0
2022-04-19	AMZN	Stock	152.0295	158.649	151.5505	158.1155	54926000.0
2022-04-19	GOOGL	Stock	127.6915	130.333	126.9995	130.009	26489760.0
2022-04-19	META	Stock	210.52	218.43	209.0	217.31	20089900.0
2022-04-19	TSLA	Stock	335.02	344.98	331.7767	342.7167	49847700.0
2022-04-19	TLT	Stock	119.15	119.72	118.67	119.25	26012315.0
2022-04-19	ES	Stock	91.86	92.78	91.54	92.5	1347900.0
2022-04-19	CL	Stock	79.85	80.88	79.8	80.61	4644600.0
2022-04-19	A	Stock	123.71	126.83	123.7	126.53	1580000.0
2022-04-19	AA	Stock	87.85	88.2	85.51	86.58	5120600.0
2022-04-19	AAC-DELISTED	Stock	9.83	9.8375	9.825	9.83	10697.0
2022-04-19	AACG	Stock	1.19	1.23	1.16	1.16	36100.0
2022-04-19	AAIC-DELISTED	Stock	3.41	3.5	3.41	3.46	105060.0
2022-04-19	AAIC.C-DELISTED	Stock	24.6	24.6	24.5	24.5	7082.0
2022-04-19	AAL	Stock	18.86	19.8	18.86	19.59	41228000.0
2022-04-19	AAM.A-DELISTED	Stock	24.96	25.0	24.95	24.9781	16763.0
2022-04-19	AAM.B-DELISTED	Stock	25.1	25.34	25.0959	25.225	17043.0
2022-04-19	AAMC-DELISTED	Stock	3.1912	3.2608	3.1284	3.2608	4709.0
2022-04-19	AAME	Stock	3.1	3.27	3.06	3.15	5700.0
2022-04-19	AAMI	Stock	22.11	22.76	22.06	22.52	441600.0
2022-04-19	AAN-DELISTED	Stock	21.3	22.18	20.93	22.04	139700.0
2022-04-19	AAOI	Stock	3.07	3.075	2.99	3.02	135700.0
2022-04-19	AAON	Stock	34.52	35.62	34.52	35.1067	327900.0
2022-04-19	AAP	Stock	218.84	223.6	218.84	222.9	561900.0
2022-04-19	AAQC-DELISTED	Stock	9.77	9.775	9.77	9.77	49383.0
2022-04-19	AAT	Stock	35.93	36.6	35.93	36.38	227600.0
2022-04-19	AATC	Stock	6.27	6.8	6.27	6.7692	25683.0
2022-04-19	AAU-DELISTED	Stock	0.3799	0.38	0.3614	0.3792	708484.0
2022-04-19	AAUAF-DELISTED	Stock	0.3799	0.38	0.3614	0.3796	711640.0
2022-04-19	AAWW-DELISTED	Stock	69.11	71.3	68.525	71.05	277078.0
2022-04-19	AAXJ	Stock	72.12	72.75	71.84	72.69	1134751.0
2022-04-19	AB	Stock	42.24	44.69	42.24	44.15	444000.0
2022-04-19	ABB-DELISTED	Stock	31.2	31.585	31.19	31.53	2118587.0
2022-04-19	ABBNY-DELISTED	Stock	31.2	31.585	31.19	31.53	2401927.0
2022-04-19	ABBV	Stock	160.4	160.5	153.71	156.35	9359900.0
2022-04-19	ABC-DELISTED	Stock	162.38	163.46	161.61	162.87	635441.0
2022-04-19	ABCB	Stock	41.05	42.47	40.95	42.36	520600.0
2022-04-19	ABCL	Stock	8.33	8.75	8.29	8.67	759300.0
2022-04-19	ABCM-DELISTED	Stock	17.98	18.21	17.91	18.12	81769.0
2022-04-19	ABEO	Stock	6.75	7.0	6.5	6.5	29480.0
2022-04-19	ABEV	Stock	3.11	3.13	3.07	3.13	20420700.0
2022-04-19	ABG	Stock	155.95	166.06	155.95	164.22	288000.0
2022-04-19	ABGI-DELISTED	Stock	9.81	9.82	9.8	9.82	325961.0
2022-04-19	ABM	Stock	50.28	51.1	50.21	50.65	392700.0
2022-04-19	ABMD-DELISTED	Stock	302.72	327.31	302.72	323.61	160942.0
2022-04-19	ABNB	Stock	165.74	170.82	165.71	170.12	2857100.0
2022-04-19	ABOS	Stock	3.89	4.08	3.77	3.96	112700.0
2022-04-19	ABR	Stock	17.55	17.61	17.1	17.3	2646900.0

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

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