PREVIEW / stock_daily / 2021-06-11

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-11.parquet
  size:    257 KB
  rows:    7,858
  symbols: 2,939

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-06-11	AAPL	Stock	126.53	127.44	126.1	127.35	53522400.0
2021-06-11	MSFT	Stock	257.99	258.49	256.61	257.89	18999700.0
2021-06-11	NVDA	Stock	17.4795	17.9392	17.4438	17.8252	416308000.0
2021-06-11	AMZN	Stock	167.4825	168.329	166.6725	167.3415	56348000.0
2021-06-11	GOOGL	Stock	122.0	122.086	120.948	121.51	21958140.0
2021-06-11	META	Stock	332.58	332.83	328.93	331.26	13587900.0
2021-06-11	TSLA	Stock	203.41	204.1867	200.5067	203.2967	48615900.0
2021-06-11	TLT	Stock	142.305	142.4	141.84	142.31	8646698.0
2021-06-11	ES	Stock	82.87	83.18	82.17	82.81	1583100.0
2021-06-11	CL	Stock	83.7	83.89	83.11	83.63	2560000.0
2021-06-11	A	Stock	143.36	143.6	141.9	143.53	995100.0
2021-06-11	AA	Stock	38.23	38.56	37.11	37.38	4649400.0
2021-06-11	AAC-DELISTED	Stock	9.82	9.82	9.79	9.8	19746.0
2021-06-11	AACG	Stock	3.24	3.28	3.14	3.19	29400.0
2021-06-11	AACQ-DELISTED	Stock	10.05	10.05	9.99	10.0	1388313.0
2021-06-11	AACQU-DELISTED	Stock	10.85	10.85	10.78	10.8	745.0
2021-06-11	AACQW-DELISTED	Stock	2.46	2.5	2.32	2.41	279268.0
2021-06-11	AAIC-DELISTED	Stock	4.12	4.155	4.09	4.14	123015.0
2021-06-11	AAIC.C-DELISTED	Stock	25.3	25.3	25.2577	25.298	1506.0
2021-06-11	AAL	Stock	23.43	23.74	23.4	23.53	24368000.0
2021-06-11	AAM.A-DELISTED	Stock	26.14	26.2	26.04	26.19	6336.0
2021-06-11	AAM.B-DELISTED	Stock	27.13	27.13	27.05	27.05	1613.0
2021-06-11	AAMC-DELISTED	Stock	5.6618	5.9206	5.6618	5.7206	30814.0
2021-06-11	AAME	Stock	4.18	4.38	4.18	4.28	84600.0
2021-06-11	AAMI	Stock	22.37	22.87	22.37	22.73	195600.0
2021-06-11	AAN-DELISTED	Stock	36.01	36.59	36.0	36.55	161600.0
2021-06-11	AAOI	Stock	8.845	8.845	8.655	8.79	279600.0
2021-06-11	AAON	Stock	42.7533	43.1133	42.6133	43.06	143250.0
2021-06-11	AAP	Stock	196.35	200.55	196.15	199.44	812800.0
2021-06-11	AAQC-DELISTED	Stock	9.68	9.73	9.67	9.73	8112.0
2021-06-11	AAT	Stock	38.32	38.76	37.93	38.76	264200.0
2021-06-11	AAU-DELISTED	Stock	0.56	0.56	0.5376	0.54	423379.0
2021-06-11	AAUAF-DELISTED	Stock	0.56	0.56	0.5376	0.541	437171.0
2021-06-11	AAWW-DELISTED	Stock	73.89	74.74	73.89	74.15	156502.0
2021-06-11	AAXJ	Stock	94.51	94.62	94.13	94.62	4302224.0
2021-06-11	AB	Stock	45.91	45.92	45.51	45.9	192600.0
2021-06-11	ABB-DELISTED	Stock	34.6	34.65	34.45	34.55	893905.0
2021-06-11	ABBNY-DELISTED	Stock	34.6	34.65	34.45	34.55	987131.0
2021-06-11	ABBV	Stock	116.24	116.36	114.87	115.42	4471400.0
2021-06-11	ABC-DELISTED	Stock	120.71	121.32	119.02	119.85	433957.0
2021-06-11	ABCB	Stock	54.42	54.91	53.65	54.27	387100.0
2021-06-11	ABCL	Stock	25.47	26.49	24.99	25.9	4290200.0
2021-06-11	ABCM-DELISTED	Stock	18.57	18.86	18.29	18.49	220301.0
2021-06-11	ABEO	Stock	46.5	47.25	44.75	45.5	33292.0
2021-06-11	ABEV	Stock	3.81	3.82	3.69	3.74	22248500.0
2021-06-11	ABG	Stock	176.27	178.57	175.69	177.14	186700.0
2021-06-11	ABGI-DELISTED	Stock	9.94	9.94	9.9	9.94	18712.0
2021-06-11	ABM	Stock	47.86	48.5	47.81	48.47	244700.0
2021-06-11	ABMD-DELISTED	Stock	299.88	299.88	296.62	299.38	100516.0
2021-06-11	ABNB	Stock	145.87	148.95	145.2	148.44	4819900.0

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

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