PREVIEW / stock_daily / 2022-08-04

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-04.parquet
  size:    253 KB
  rows:    7,848
  symbols: 2,224

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-04	AAPL	Stock	166.01	167.19	164.43	165.81	55474100.0
2022-08-04	MSFT	Stock	281.8	283.8	280.17	283.65	18098700.0
2022-08-04	NVDA	Stock	18.849	19.274	18.76	19.215	409652000.0
2022-08-04	AMZN	Stock	140.58	143.56	139.55	142.57	70585000.0
2022-08-04	GOOGL	Stock	117.48	118.78	116.89	118.19	21602925.0
2022-08-04	META	Stock	168.3	172.15	166.8	170.57	23938200.0
2022-08-04	TSLA	Stock	311.0	313.6067	305.0	308.6333	72256200.0
2022-08-04	TLT	Stock	118.98	119.55	118.54	119.31	11003006.0
2022-08-04	ES	Stock	90.95	91.7	90.48	91.0	1746900.0
2022-08-04	CL	Stock	81.15	81.52	80.46	80.89	2787900.0
2022-08-04	A	Stock	134.69	135.0	132.74	133.77	895600.0
2022-08-04	AA	Stock	48.54	49.64	47.2	47.85	4494600.0
2022-08-04	AAC-DELISTED	Stock	9.9	9.9	9.87	9.87	1073954.0
2022-08-04	AACG	Stock	1.95	1.97	1.8	1.86	62100.0
2022-08-04	AAIC-DELISTED	Stock	3.05	3.19	3.05	3.12	34585.0
2022-08-04	AAIC.C-DELISTED	Stock	20.85	20.85	20.78	20.78	6979.0
2022-08-04	AAL	Stock	14.53	14.97	14.51	14.86	27102900.0
2022-08-04	AAM.A-DELISTED	Stock	25.2201	25.4	25.2201	25.4	8221.0
2022-08-04	AAM.B-DELISTED	Stock	26.56	26.7	26.01	26.51	17635.0
2022-08-04	AAMC-DELISTED	Stock	5.2294	5.4088	5.0265	5.1324	43571.0
2022-08-04	AAME	Stock	3.09	3.09	2.71	2.99	8800.0
2022-08-04	AAMI	Stock	18.98	19.07	18.64	18.73	183300.0
2022-08-04	AAN-DELISTED	Stock	13.23	13.79	13.23	13.34	263800.0
2022-08-04	AAOI	Stock	1.95	2.05	1.87	1.97	380200.0
2022-08-04	AAON	Stock	40.92	41.8333	40.72	41.64	295500.0
2022-08-04	AAP	Stock	194.8	195.9	191.51	191.56	531400.0
2022-08-04	AAQC-DELISTED	Stock	9.81	9.81	9.81	9.81	200.0
2022-08-04	AAT	Stock	30.24	30.24	28.85	28.94	310300.0
2022-08-04	AATC	Stock	5.01	5.05	5.0	5.0	6044.0
2022-08-04	AAU-DELISTED	Stock	0.2371	0.2492	0.235	0.2471	257470.0
2022-08-04	AAUAF-DELISTED	Stock	0.2371	0.2492	0.235	0.2471	272971.0
2022-08-04	AAWW-DELISTED	Stock	99.88	99.9	99.33	99.71	6273421.0
2022-08-04	AAXJ	Stock	68.18	68.37	67.91	68.25	1250447.0
2022-08-04	AB	Stock	44.97	45.75	44.88	45.12	269300.0
2022-08-04	ABB-DELISTED	Stock	30.01	30.205	29.94	30.13	948680.0
2022-08-04	ABBNY-DELISTED	Stock	30.01	30.205	29.94	30.12	1064933.0
2022-08-04	ABBV	Stock	142.09	142.58	138.69	138.92	7071700.0
2022-08-04	ABC-DELISTED	Stock	141.31	146.4	139.06	139.28	1016448.0
2022-08-04	ABCB	Stock	47.11	47.16	46.4	46.9	366200.0
2022-08-04	ABCL	Stock	11.0	11.46	11.0	11.33	1343900.0
2022-08-04	ABCM-DELISTED	Stock	15.52	15.665	15.45	15.54	91600.0
2022-08-04	ABEO	Stock	4.26	4.8	4.25	4.26	995200.0
2022-08-04	ABEV	Stock	2.74	2.78	2.71	2.78	27368300.0
2022-08-04	ABG	Stock	178.99	180.09	176.34	176.89	100200.0
2022-08-04	ABGI-DELISTED	Stock	9.85	9.85	9.85	9.85	200.0
2022-08-04	ABM	Stock	44.94	45.1	44.5	44.74	230800.0
2022-08-04	ABMD-DELISTED	Stock	300.2	300.2	280.82	292.24	174045.0
2022-08-04	ABNB	Stock	114.31	119.24	114.255	119.22	9180300.0
2022-08-04	ABOS	Stock	4.532	5.335	4.532	5.05	21700.0
2022-08-04	ABR	Stock	15.5	15.65	15.25	15.62	2195500.0

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

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