PREVIEW / stock_daily / 2022-08-09

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-09.parquet
  size:    255 KB
  rows:    7,937
  symbols: 2,298

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-08-09	AAPL	Stock	164.02	165.82	163.25	164.92	63135500.0
2022-08-09	MSFT	Stock	279.64	283.08	277.61	282.3	23405200.0
2022-08-09	NVDA	Stock	17.252	17.447	16.724	17.086	668263000.0
2022-08-09	AMZN	Stock	138.05	138.95	136.21	137.83	40434700.0
2022-08-09	GOOGL	Stock	117.135	117.32	115.71	116.63	19086465.0
2022-08-09	META	Stock	168.95	169.53	166.6	168.53	18655100.0
2022-08-09	TSLA	Stock	290.2933	292.3967	279.3533	283.3333	86244600.0
2022-08-09	TLT	Stock	117.73	118.359	117.46	117.89	8223201.0
2022-08-09	ES	Stock	91.26	92.07	91.18	91.63	1467900.0
2022-08-09	CL	Stock	80.83	80.83	80.01	80.06	3254200.0
2022-08-09	A	Stock	132.5	132.5	128.02	128.88	894700.0
2022-08-09	AA	Stock	49.45	50.74	49.26	50.38	4725300.0
2022-08-09	AAC-DELISTED	Stock	9.88	9.885	9.875	9.88	111250.0
2022-08-09	AACG	Stock	1.85	1.91	1.83	1.9	23800.0
2022-08-09	AAIC-DELISTED	Stock	3.36	3.38	3.29	3.3655	91821.0
2022-08-09	AAIC.C-DELISTED	Stock	20.78	20.78	20.78	20.78	100.0
2022-08-09	AAL	Stock	14.87	14.88	14.38	14.62	23706400.0
2022-08-09	AAM.A-DELISTED	Stock	25.42	25.42	25.31	25.31	4038.0
2022-08-09	AAM.B-DELISTED	Stock	25.97	25.97	25.57	25.59	1298.0
2022-08-09	AAMC-DELISTED	Stock	7.45	8.0706	7.0618	7.1676	98110.0
2022-08-09	AAME	Stock	2.88	3.0	2.85	2.87	6500.0
2022-08-09	AAMI	Stock	19.03	19.05	18.39	18.47	199700.0
2022-08-09	AAN-DELISTED	Stock	14.31	14.38	13.75	13.93	321000.0
2022-08-09	AAOI	Stock	1.91	1.92	1.795	1.84	267900.0
2022-08-09	AAON	Stock	43.0	43.0	38.62	39.8933	525150.0
2022-08-09	AAP	Stock	194.31	194.72	191.69	191.77	400000.0
2022-08-09	AAQC-DELISTED	Stock	9.82	9.825	9.81	9.82	88670.0
2022-08-09	AAT	Stock	29.66	29.86	29.35	29.57	202300.0
2022-08-09	AATC	Stock	5.006	5.11	4.92	4.95	7140.0
2022-08-09	AAU-DELISTED	Stock	0.2335	0.2449	0.233	0.2397	110110.0
2022-08-09	AAUAF-DELISTED	Stock	0.2335	0.2449	0.233	0.2398	121924.0
2022-08-09	AAWW-DELISTED	Stock	99.8	100.59	99.8	100.48	1019218.0
2022-08-09	AAXJ	Stock	67.98	68.06	67.555	67.66	544277.0
2022-08-09	AB	Stock	44.0	44.2	43.03	43.33	232600.0
2022-08-09	ABB-DELISTED	Stock	29.4	29.5	29.255	29.28	1260620.0
2022-08-09	ABBNY-DELISTED	Stock	29.4	29.5	29.255	29.28	1410142.0
2022-08-09	ABBV	Stock	140.68	142.24	139.88	140.25	3819700.0
2022-08-09	ABC-DELISTED	Stock	141.67	145.86	141.38	144.75	827272.0
2022-08-09	ABCB	Stock	47.14	47.43	46.91	47.36	246100.0
2022-08-09	ABCL	Stock	11.8	11.92	10.86	11.11	2718800.0
2022-08-09	ABCM-DELISTED	Stock	14.75	14.81	14.52	14.68	192350.0
2022-08-09	ABEO	Stock	4.0	4.03	3.88	3.95	163700.0
2022-08-09	ABEV	Stock	2.85	2.87	2.8	2.82	19919500.0
2022-08-09	ABG	Stock	180.5	180.5	173.49	178.03	122700.0
2022-08-09	ABGI-DELISTED	Stock	9.85	9.85	9.85	9.85	200.0
2022-08-09	ABM	Stock	44.9	45.2	44.46	44.79	251900.0
2022-08-09	ABMD-DELISTED	Stock	292.78	292.78	281.52	281.52	87944.0
2022-08-09	ABNB	Stock	115.0	115.67	112.8	114.44	4201200.0
2022-08-09	ABOS	Stock	5.35	5.35	5.0	5.09	28900.0
2022-08-09	ABR	Stock	16.02	16.07	15.68	15.86	1702100.0

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

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