PREVIEW / stock_daily / 2022-06-30

all stock daily files

  file:    by_date/stock_daily/2022/2022-06-30.parquet
  size:    256 KB
  rows:    8,017
  symbols: 2,413

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-06-30	AAPL	Stock	137.25	138.37	133.77	136.72	98964500.0
2022-06-30	MSFT	Stock	257.05	259.53	252.9	256.83	31730900.0
2022-06-30	NVDA	Stock	15.361	15.567	14.862	15.159	686070000.0
2022-06-30	AMZN	Stock	108.11	108.18	102.52	106.21	97679400.0
2022-06-30	GOOGL	Stock	110.0	110.888	106.75	108.963	43169060.0
2022-06-30	META	Stock	162.15	165.23	158.49	161.25	35250600.0
2022-06-30	TSLA	Stock	224.51	229.4567	218.8633	224.4733	94600500.0
2022-06-30	TLT	Stock	114.859	115.77	114.75	114.87	25802128.0
2022-06-30	ES	Stock	83.01	84.96	82.83	84.47	2060800.0
2022-06-30	CL	Stock	79.41	80.57	79.01	80.14	3565600.0
2022-06-30	A	Stock	116.0	119.95	116.0	118.77	1612000.0
2022-06-30	AA	Stock	46.18	46.59	44.27	45.58	6217300.0
2022-06-30	AAC-DELISTED	Stock	9.83	9.85	9.83	9.835	114861.0
2022-06-30	AACG	Stock	1.08	1.08	1.06	1.06	14700.0
2022-06-30	AACIW-DELISTED	Stock	0.1601	0.28	0.1601	0.2697	12316.0
2022-06-30	AAIC-DELISTED	Stock	3.23	3.29	3.2	3.25	55006.0
2022-06-30	AAIC.C-DELISTED	Stock	22.3	22.52	22.0	22.0	8001.0
2022-06-30	AAL	Stock	12.6	12.88	12.25	12.68	37521400.0
2022-06-30	AAM.A-DELISTED	Stock	24.26	24.3801	24.06	24.2	17891.0
2022-06-30	AAM.B-DELISTED	Stock	25.0	25.25	25.0	25.11	7559.0
2022-06-30	AAMC-DELISTED	Stock	2.7324	3.0144	2.7324	3.0144	15093.0
2022-06-30	AAME	Stock	2.69	2.71	2.59	2.67	4600.0
2022-06-30	AAMI	Stock	17.99	18.32	17.653	18.01	488700.0
2022-06-30	AAN-DELISTED	Stock	14.5	14.74	14.17	14.55	236800.0
2022-06-30	AAOI	Stock	1.66	1.66	1.52	1.55	217600.0
2022-06-30	AAON	Stock	34.7667	36.5067	34.58	36.5067	340200.0
2022-06-30	AAP	Stock	175.0	175.77	171.91	173.09	999900.0
2022-06-30	AAQC-DELISTED	Stock	9.76	9.78	9.76	9.76	119818.0
2022-06-30	AAT	Stock	29.37	29.99	29.12	29.7	214600.0
2022-06-30	AATC	Stock	5.29	5.51	5.29	5.46	5408.0
2022-06-30	AAU-DELISTED	Stock	0.23	0.248	0.2201	0.2201	381763.0
2022-06-30	AAUAF-DELISTED	Stock	0.23	0.248	0.2201	0.2236	386589.0
2022-06-30	AAWW-DELISTED	Stock	61.93	62.4	60.48	61.7	282423.0
2022-06-30	AAXJ	Stock	68.46	69.22	68.045	69.2	1657585.0
2022-06-30	AB	Stock	41.07	41.97	40.65	41.58	319800.0
2022-06-30	ABB-DELISTED	Stock	26.37	26.83	26.17	26.725	1808896.0
2022-06-30	ABBNY-DELISTED	Stock	26.37	26.83	26.17	26.73	2095476.0
2022-06-30	ABBV	Stock	153.17	154.04	150.87	153.16	7289500.0
2022-06-30	ABC-DELISTED	Stock	142.29	143.48	140.81	141.47	909639.0
2022-06-30	ABCB	Stock	39.53	40.67	39.37	40.18	424800.0
2022-06-30	ABCL	Stock	9.98	10.95	9.94	10.65	3061600.0
2022-06-30	ABCM-DELISTED	Stock	14.16	14.49	14.1	14.48	83228.0
2022-06-30	ABEO	Stock	5.0	5.25	4.75	5.25	90232.0
2022-06-30	ABEV	Stock	2.53	2.55	2.5	2.51	27500400.0
2022-06-30	ABG	Stock	171.51	172.36	164.63	169.34	238800.0
2022-06-30	ABM	Stock	41.94	43.54	41.87	43.42	373600.0
2022-06-30	ABMD-DELISTED	Stock	253.84	256.0	245.76	247.51	202569.0
2022-06-30	ABNB	Stock	92.49	92.91	86.71	89.08	9007800.0
2022-06-30	ABOS	Stock	4.92	5.03	4.62	4.7	225900.0
2022-06-30	ABR	Stock	13.12	13.26	13.02	13.11	1736200.0

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

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