PREVIEW / stock_daily / 2022-05-12

all stock daily files

  file:    by_date/stock_daily/2022/2022-05-12.parquet
  size:    260 KB
  rows:    8,074
  symbols: 2,481

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-12	AAPL	Stock	142.77	146.2	138.8	142.56	182602000.0
2022-05-12	MSFT	Stock	257.69	259.88	250.02	255.35	51033800.0
2022-05-12	NVDA	Stock	16.219	16.788	15.567	16.175	708728000.0
2022-05-12	AMZN	Stock	102.75	110.7805	102.4055	106.9305	132026000.0
2022-05-12	GOOGL	Stock	111.3775	114.295	109.8245	112.844	53836180.0
2022-05-12	META	Stock	187.06	198.05	184.78	191.24	38262200.0
2022-05-12	TSLA	Stock	233.6667	253.22	226.6667	242.6667	140313000.0
2022-05-12	TLT	Stock	118.02	118.89	117.655	117.72	26405693.0
2022-05-12	ES	Stock	88.92	89.54	87.51	88.92	1844900.0
2022-05-12	CL	Stock	77.42	77.88	76.72	77.55	5244700.0
2022-05-12	A	Stock	113.61	116.25	112.78	116.13	1338000.0
2022-05-12	AA	Stock	54.85	56.36	53.34	54.58	7408800.0
2022-05-12	AAC-DELISTED	Stock	9.8	9.8	9.78	9.78	615351.0
2022-05-12	AACG	Stock	1.0	1.0	0.88	0.94	14600.0
2022-05-12	AACIW-DELISTED	Stock	0.26	0.26	0.26	0.26	624.0
2022-05-12	AAIC-DELISTED	Stock	2.95	3.11	2.88	2.92	119347.0
2022-05-12	AAIC.C-DELISTED	Stock	22.31	22.31	20.39	21.6812	4683.0
2022-05-12	AAL	Stock	15.71	16.13	15.09	15.49	40155400.0
2022-05-12	AAM.A-DELISTED	Stock	24.17	24.265	23.78	24.07	27844.0
2022-05-12	AAM.B-DELISTED	Stock	24.2	24.34	23.9	23.9	14448.0
2022-05-12	AAMC-DELISTED	Stock	3.0588	3.0588	2.9794	2.9794	7385.0
2022-05-12	AAME	Stock	2.76	3.0	2.65	2.86	2500.0
2022-05-12	AAMI	Stock	18.89	19.5	18.69	19.48	533100.0
2022-05-12	AAN-DELISTED	Stock	18.99	20.12	18.98	19.99	267400.0
2022-05-12	AAOI	Stock	2.11	2.26	2.06	2.175	199000.0
2022-05-12	AAON	Stock	33.7	35.3933	33.0133	35.34	307500.0
2022-05-12	AAP	Stock	201.07	209.55	200.53	208.9	1051800.0
2022-05-12	AAQC-DELISTED	Stock	9.76	9.77	9.72	9.765	48517.0
2022-05-12	AAT	Stock	32.05	32.42	31.63	32.34	305400.0
2022-05-12	AATC	Stock	5.74	5.81	5.475	5.5238	17305.0
2022-05-12	AAU-DELISTED	Stock	0.2701	0.2899	0.2651	0.2778	528510.0
2022-05-12	AAUAF-DELISTED	Stock	0.2701	0.2899	0.2651	0.288	537571.0
2022-05-12	AAWW-DELISTED	Stock	68.73	69.15	66.74	68.62	290207.0
2022-05-12	AAXJ	Stock	65.93	66.76	65.43	66.21	2042764.0
2022-05-12	AB	Stock	36.32	37.37	35.2	36.55	709000.0
2022-05-12	ABB-DELISTED	Stock	27.86	28.45	27.74	28.15	3274499.0
2022-05-12	ABBNY-DELISTED	Stock	27.86	28.45	27.74	28.15	3546386.0
2022-05-12	ABBV	Stock	153.38	154.35	150.15	154.29	6914800.0
2022-05-12	ABC-DELISTED	Stock	148.69	151.73	145.63	151.67	4167337.0
2022-05-12	ABCB	Stock	41.53	42.57	41.25	42.5	558600.0
2022-05-12	ABCL	Stock	5.61	6.78	5.42	6.71	7056900.0
2022-05-12	ABCM-DELISTED	Stock	12.54	13.08	12.54	13.0	144635.0
2022-05-12	ABEO	Stock	3.5	4.25	3.25	4.0	156272.0
2022-05-12	ABEV	Stock	2.66	2.8	2.65	2.78	51463600.0
2022-05-12	ABG	Stock	179.3	184.51	175.18	179.66	254100.0
2022-05-12	ABM	Stock	44.08	44.25	42.91	43.62	464500.0
2022-05-12	ABMD-DELISTED	Stock	231.46	239.43	228.27	234.69	194192.0
2022-05-12	ABNB	Stock	113.66	120.49	111.22	115.94	9264300.0
2022-05-12	ABOS	Stock	3.06	3.385	3.02	3.18	192600.0
2022-05-12	ABR	Stock	16.65	16.72	16.31	16.61	3936900.0

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

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