PREVIEW / stock_daily / 2021-07-01

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-01.parquet
  size:    259 KB
  rows:    7,925
  symbols: 2,909

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
2021-07-01	AAPL	Stock	136.6	137.33	135.76	137.27	52485800.0
2021-07-01	MSFT	Stock	269.61	271.84	269.6	271.6	16725300.0
2021-07-01	NVDA	Stock	20.125	20.456	20.019	20.212	480136000.0
2021-07-01	AMZN	Stock	171.7305	172.85	170.471	171.6485	40742000.0
2021-07-01	GOOGL	Stock	121.725	122.587	121.5315	122.4445	18112820.0
2021-07-01	META	Stock	346.82	354.67	346.5	354.39	17137000.0
2021-07-01	TSLA	Stock	227.9733	229.33	224.2667	225.9733	55903500.0
2021-07-01	TLT	Stock	143.98	144.31	143.53	144.17	10809998.0
2021-07-01	ES	Stock	80.0	80.69	79.57	79.86	1840400.0
2021-07-01	CL	Stock	81.5	81.88	81.25	81.74	3596100.0
2021-07-01	A	Stock	147.77	148.37	147.01	147.79	1426500.0
2021-07-01	AA	Stock	37.4	37.69	36.47	36.96	6118600.0
2021-07-01	AAC-DELISTED	Stock	9.75	9.77	9.75	9.76	64651.0
2021-07-01	AACG	Stock	3.09	3.18	2.95	2.96	39200.0
2021-07-01	AAIC-DELISTED	Stock	4.05	4.08	4.04	4.07	136545.0
2021-07-01	AAIC.C-DELISTED	Stock	25.1256	25.14	25.12	25.14	2535.0
2021-07-01	AAL	Stock	21.47	21.79	21.33	21.51	22082700.0
2021-07-01	AAM.A-DELISTED	Stock	26.4	26.44	26.318	26.4	11284.0
2021-07-01	AAM.B-DELISTED	Stock	26.89	26.95	26.8704	26.93	10646.0
2021-07-01	AAMC-DELISTED	Stock	5.6882	5.6882	5.4647	5.628	20281.0
2021-07-01	AAME	Stock	4.38	4.48	4.3	4.38	38600.0
2021-07-01	AAMI	Stock	23.64	24.12	23.335	23.95	349100.0
2021-07-01	AAN-DELISTED	Stock	32.26	32.87	31.95	32.17	325000.0
2021-07-01	AAOI	Stock	8.58	8.6	8.34	8.4	387600.0
2021-07-01	AAON	Stock	41.8	42.3	41.54	41.7333	579900.0
2021-07-01	AAP	Stock	205.81	209.18	204.83	208.94	611300.0
2021-07-01	AAQC-DELISTED	Stock	9.69	9.7	9.66	9.67	91877.0
2021-07-01	AAT	Stock	37.46	37.92	37.19	37.6	236300.0
2021-07-01	AAU-DELISTED	Stock	0.502	0.5096	0.501	0.5026	331745.0
2021-07-01	AAUAF-DELISTED	Stock	0.502	0.5096	0.501	0.5026	350028.0
2021-07-01	AAWW-DELISTED	Stock	68.32	69.02	67.38	68.37	190241.0
2021-07-01	AAXJ	Stock	94.47	94.47	93.44	93.84	995375.0
2021-07-01	AB	Stock	46.7	46.84	46.25	46.77	95600.0
2021-07-01	ABB-DELISTED	Stock	34.04	34.06	33.89	33.96	839684.0
2021-07-01	ABBNY-DELISTED	Stock	34.04	34.06	33.89	33.96	953845.0
2021-07-01	ABBV	Stock	112.95	114.55	112.89	114.26	5306900.0
2021-07-01	ABC-DELISTED	Stock	114.9	117.03	114.9	116.47	687762.0
2021-07-01	ABCB	Stock	50.88	51.62	50.43	51.32	267600.0
2021-07-01	ABCL	Stock	22.51	22.51	20.5	20.56	1958900.0
2021-07-01	ABCM-DELISTED	Stock	19.6	19.955	19.56	19.67	397740.0
2021-07-01	ABEO	Stock	39.5	39.75	38.25	38.75	32824.0
2021-07-01	ABEV	Stock	3.43	3.45	3.38	3.38	26478100.0
2021-07-01	ABG	Stock	173.51	177.49	173.21	176.01	260200.0
2021-07-01	ABM	Stock	44.91	45.06	44.52	44.59	394900.0
2021-07-01	ABMD-DELISTED	Stock	311.02	317.57	311.02	312.85	167463.0
2021-07-01	ABNB	Stock	154.5	157.41	151.41	153.08	9787100.0
2021-07-01	ABR	Stock	17.87	18.17	17.81	18.08	970600.0
2021-07-01	ABR.D	Stock	25.38	25.44	25.38	25.43	101062.0
2021-07-01	ABST-DELISTED	Stock	14.45	14.5	14.33	14.46	22705.0
2021-07-01	ABT	Stock	115.61	117.29	115.48	117.16	4739600.0

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

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