PREVIEW / stock_daily / 2022-01-19

all stock daily files

  file:    by_date/stock_daily/2022/2022-01-19.parquet
  size:    263 KB
  rows:    8,071
  symbols: 2,605

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-01-19	AAPL	Stock	170.0	171.08	165.94	166.23	94815000.0
2022-01-19	MSFT	Stock	306.29	313.91	302.7	303.33	45933900.0
2022-01-19	NVDA	Stock	26.079	26.543	25.052	25.067	488315000.0
2022-01-19	AMZN	Stock	158.762	159.25	156.25	156.299	53242000.0
2022-01-19	GOOGL	Stock	136.5235	137.9595	135.0155	135.1165	28647640.0
2022-01-19	META	Stock	319.58	327.1	319.33	319.59	20814700.0
2022-01-19	TSLA	Stock	347.2367	351.5567	331.6667	331.8833	75442500.0
2022-01-19	TLT	Stock	140.53	141.71	140.31	141.07	17927062.0
2022-01-19	ES	Stock	86.58	87.88	86.41	86.87	945000.0
2022-01-19	CL	Stock	83.63	85.04	83.5	84.06	5614600.0
2022-01-19	A	Stock	140.67	143.6	140.26	140.43	1472100.0
2022-01-19	AA	Stock	61.39	61.93	58.885	59.63	7851100.0
2022-01-19	AAC-DELISTED	Stock	9.73	9.74	9.73	9.74	223972.0
2022-01-19	AACG	Stock	1.76	1.88	1.63	1.82	121700.0
2022-01-19	AACIW-DELISTED	Stock	0.48	0.48	0.4795	0.48	1318.0
2022-01-19	AAIC-DELISTED	Stock	3.46	3.52	3.46	3.47	95391.0
2022-01-19	AAIC.C-DELISTED	Stock	25.29	25.29	25.1	25.1285	6324.0
2022-01-19	AAL	Stock	17.9	17.91	17.29	17.31	36133100.0
2022-01-19	AAM.A-DELISTED	Stock	25.5	25.5	25.37	25.45	56128.0
2022-01-19	AAM.B-DELISTED	Stock	26.32	26.76	26.27	26.65	34450.0
2022-01-19	AAME	Stock	2.59	2.59	2.45	2.5	11600.0
2022-01-19	AAMI	Stock	23.92	24.05	23.34	23.37	426900.0
2022-01-19	AAN-DELISTED	Stock	22.01	22.45	21.54	21.65	182900.0
2022-01-19	AAOI	Stock	3.97	4.14	3.97	4.1	458500.0
2022-01-19	AAON	Stock	46.3133	46.3133	44.7533	44.84	382200.0
2022-01-19	AAP	Stock	239.78	242.96	234.1	234.34	607300.0
2022-01-19	AAQC-DELISTED	Stock	9.7	9.8	9.7	9.75	108073.0
2022-01-19	AAT	Stock	38.58	38.58	37.28	37.29	207400.0
2022-01-19	AATC	Stock	6.3	6.3	6.06	6.12	15485.0
2022-01-19	AAU-DELISTED	Stock	0.29	0.305	0.2824	0.3049	1071475.0
2022-01-19	AAUAF-DELISTED	Stock	0.29	0.305	0.2824	0.3049	1076596.0
2022-01-19	AAWW-DELISTED	Stock	81.55	82.25	78.46	78.76	1127916.0
2022-01-19	AAXJ	Stock	83.51	83.71	83.15	83.18	1106472.0
2022-01-19	AB	Stock	50.89	51.8	50.16	50.23	350500.0
2022-01-19	ABB-DELISTED	Stock	37.38	37.465	36.98	37.03	2790236.0
2022-01-19	ABBNY-DELISTED	Stock	37.38	37.465	36.98	37.03	2998459.0
2022-01-19	ABBV	Stock	136.41	137.5	134.84	135.21	6196700.0
2022-01-19	ABC-DELISTED	Stock	133.8	135.23	132.12	132.39	576983.0
2022-01-19	ABCB	Stock	54.07	54.43	52.47	52.59	476200.0
2022-01-19	ABCL	Stock	9.82	10.09	9.39	9.42	1779000.0
2022-01-19	ABCM-DELISTED	Stock	18.14	18.3	17.75	17.75	137879.0
2022-01-19	ABEO	Stock	6.5	6.75	6.25	6.5	97612.0
2022-01-19	ABEV	Stock	2.66	2.68	2.63	2.65	27178400.0
2022-01-19	ABG	Stock	167.7	168.96	162.89	163.23	265600.0
2022-01-19	ABGI-DELISTED	Stock	9.74	9.74	9.74	9.74	100.0
2022-01-19	ABM	Stock	43.24	43.64	42.5	42.71	456000.0
2022-01-19	ABMD-DELISTED	Stock	294.19	303.07	292.4	302.36	346004.0
2022-01-19	ABNB	Stock	157.0	160.23	154.44	154.58	5127400.0
2022-01-19	ABOS	Stock	5.2	5.45	5.14	5.19	156900.0
2022-01-19	ABR	Stock	18.25	18.31	17.98	18.01	1280800.0

> showing 50 of 8,071 rows — these rows as CSV

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