PREVIEW / stock_daily / 2022-07-07

all stock daily files

  file:    by_date/stock_daily/2022/2022-07-07.parquet
  size:    254 KB
  rows:    7,920
  symbols: 2,319

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-07-07	AAPL	Stock	143.29	146.55	143.28	146.35	66253700.0
2022-07-07	MSFT	Stock	265.12	269.06	265.02	268.4	20859900.0
2022-07-07	NVDA	Stock	15.456	15.945	15.389	15.858	492903000.0
2022-07-07	AMZN	Stock	113.85	116.99	113.49	116.33	57872300.0
2022-07-07	GOOGL	Stock	115.08	119.1895	114.8335	118.783	40935880.0
2022-07-07	META	Stock	169.45	172.72	167.78	172.19	24083400.0
2022-07-07	TSLA	Stock	233.92	245.3633	232.21	244.5433	81930600.0
2022-07-07	TLT	Stock	115.1	115.17	113.51	113.76	13087988.0
2022-07-07	ES	Stock	84.23	84.76	83.57	83.59	1911300.0
2022-07-07	CL	Stock	80.69	80.75	78.32	79.46	5148000.0
2022-07-07	A	Stock	120.99	123.22	120.62	123.15	1221200.0
2022-07-07	AA	Stock	45.5	46.73	45.18	45.65	7508200.0
2022-07-07	AAC-DELISTED	Stock	9.85	9.85	9.82	9.83	297577.0
2022-07-07	AACG	Stock	1.11	1.15	1.1	1.15	14800.0
2022-07-07	AAIC-DELISTED	Stock	3.12	3.23	3.12	3.2	52486.0
2022-07-07	AAIC.C-DELISTED	Stock	21.21	21.21	21.0	21.16	601.0
2022-07-07	AAL	Stock	13.94	14.2	13.64	14.1	33327700.0
2022-07-07	AAM.A-DELISTED	Stock	24.03	24.1663	23.93	24.146	8813.0
2022-07-07	AAM.B-DELISTED	Stock	24.87	24.88	24.44	24.46	9496.0
2022-07-07	AAMC-DELISTED	Stock	3.2235	3.2235	3.0	3.0	10414.0
2022-07-07	AAME	Stock	2.7	3.09	2.7	3.03	24300.0
2022-07-07	AAMI	Stock	17.89	18.23	17.89	17.99	208200.0
2022-07-07	AAN-DELISTED	Stock	14.6	15.11	14.6	15.1	212700.0
2022-07-07	AAOI	Stock	1.56	1.688	1.56	1.62	202900.0
2022-07-07	AAON	Stock	37.46	37.84	36.5867	37.1867	224700.0
2022-07-07	AAP	Stock	182.54	184.69	180.85	183.99	543900.0
2022-07-07	AAQC-DELISTED	Stock	9.77	9.78	9.77	9.78	10485.0
2022-07-07	AAT	Stock	30.16	30.37	29.94	29.96	108300.0
2022-07-07	AATC	Stock	5.42	5.42	5.29	5.31	20818.0
2022-07-07	AAU-DELISTED	Stock	0.2188	0.24	0.2188	0.23	287946.0
2022-07-07	AAUAF-DELISTED	Stock	0.2188	0.24	0.2188	0.23	293505.0
2022-07-07	AAWW-DELISTED	Stock	59.83	61.68	59.38	60.88	187364.0
2022-07-07	AAXJ	Stock	68.86	69.5	68.7221	69.28	959424.0
2022-07-07	AB	Stock	41.25	41.99	41.25	41.92	243200.0
2022-07-07	ABB-DELISTED	Stock	26.74	27.05	26.72	27.04	1279660.0
2022-07-07	ABBNY-DELISTED	Stock	26.72	27.05	26.72	27.03	1440874.0
2022-07-07	ABBV	Stock	150.2	152.58	150.01	152.0	6516100.0
2022-07-07	ABC-DELISTED	Stock	140.45	141.92	140.0723	140.74	584633.0
2022-07-07	ABCB	Stock	41.49	41.81	41.06	41.25	300700.0
2022-07-07	ABCL	Stock	10.55	11.595	10.494	11.49	2490600.0
2022-07-07	ABCM-DELISTED	Stock	14.85	15.114	14.82	14.97	110987.0
2022-07-07	ABEO	Stock	3.84	4.84	3.8	4.52	298200.0
2022-07-07	ABEV	Stock	2.59	2.64	2.58	2.63	26502300.0
2022-07-07	ABG	Stock	171.19	176.72	171.19	174.69	156700.0
2022-07-07	ABM	Stock	42.92	43.85	42.92	43.33	250200.0
2022-07-07	ABMD-DELISTED	Stock	254.48	268.08	252.01	267.32	175911.0
2022-07-07	ABNB	Stock	93.66	97.55	92.16	97.5	7480500.0
2022-07-07	ABOS	Stock	5.5	6.07	5.496	6.0	122400.0
2022-07-07	ABR	Stock	13.49	13.78	13.49	13.76	1724700.0
2022-07-07	ABR.D	Stock	21.16	21.16	20.4	20.74	15505.0

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

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