PREVIEW / stock_daily / 2021-07-16

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-16.parquet
  size:    257 KB
  rows:    7,896
  symbols: 2,854

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-16	AAPL	Stock	148.46	149.76	145.88	146.39	93251400.0
2021-07-16	MSFT	Stock	282.07	284.1	279.46	280.75	26186800.0
2021-07-16	NVDA	Stock	19.0305	19.157	18.073	18.161	688224000.0
2021-07-16	AMZN	Stock	181.6655	182.303	178.523	178.6815	80874000.0
2021-07-16	GOOGL	Stock	127.663	127.8115	126.1535	126.97	20424540.0
2021-07-16	META	Stock	344.91	345.99	340.14	341.16	11026100.0
2021-07-16	TSLA	Stock	218.2267	218.9	214.0667	214.74	49113000.0
2021-07-16	TLT	Stock	147.34	148.34	147.32	148.21	12787919.0
2021-07-16	ES	Stock	86.36	87.67	86.11	87.36	2194000.0
2021-07-16	CL	Stock	83.66	84.5	83.66	84.39	6527500.0
2021-07-16	A	Stock	149.33	149.82	148.27	148.93	2169800.0
2021-07-16	AA	Stock	35.35	35.7	32.732	32.95	14579700.0
2021-07-16	AAC-DELISTED	Stock	9.74	9.79	9.74	9.76	6295.0
2021-07-16	AACG	Stock	3.16	3.35	2.49	3.1	4465500.0
2021-07-16	AAIC-DELISTED	Stock	3.8	3.88	3.78	3.79	202311.0
2021-07-16	AAIC.C-DELISTED	Stock	25.25	25.3111	25.25	25.26	650.0
2021-07-16	AAL	Stock	20.68	20.73	19.72	19.79	34523500.0
2021-07-16	AAM.A-DELISTED	Stock	26.76	26.76	26.57	26.57	14418.0
2021-07-16	AAM.B-DELISTED	Stock	27.13	27.13	27.02	27.06	10281.0
2021-07-16	AAMC-DELISTED	Stock	5.0735	5.1315	4.8324	4.8676	42075.0
2021-07-16	AAME	Stock	4.5	4.99	4.05	4.09	128000.0
2021-07-16	AAMI	Stock	23.68	24.01	23.41	23.72	370000.0
2021-07-16	AAN-DELISTED	Stock	28.31	29.19	28.01	28.17	255900.0
2021-07-16	AAOI	Stock	7.56	7.66	7.3	7.31	406000.0
2021-07-16	AAON	Stock	41.0067	41.16	40.4533	40.5	142350.0
2021-07-16	AAP	Stock	210.13	210.51	205.65	205.85	467800.0
2021-07-16	AAQC-DELISTED	Stock	9.7	9.7017	9.69	9.7	132364.0
2021-07-16	AAT	Stock	37.49	37.64	36.96	37.0	233300.0
2021-07-16	AAU-DELISTED	Stock	0.45	0.46	0.45	0.4537	512654.0
2021-07-16	AAUAF-DELISTED	Stock	0.45	0.46	0.45	0.4525	525224.0
2021-07-16	AAWW-DELISTED	Stock	65.91	66.5773	63.71	63.99	360631.0
2021-07-16	AAXJ	Stock	92.5	92.63	91.62	91.81	134149.0
2021-07-16	AB	Stock	45.92	45.92	45.15	45.16	137400.0
2021-07-16	ABB-DELISTED	Stock	35.38	35.55	35.1843	35.25	1037743.0
2021-07-16	ABBNY-DELISTED	Stock	35.38	35.55	35.1843	35.25	1139542.0
2021-07-16	ABBV	Stock	117.91	118.33	116.92	117.5	6826100.0
2021-07-16	ABC-DELISTED	Stock	113.38	113.765	112.6	112.87	291624.0
2021-07-16	ABCB	Stock	48.92	48.92	47.02	47.16	284400.0
2021-07-16	ABCL	Stock	16.51	17.02	16.06	16.93	1544600.0
2021-07-16	ABCM-DELISTED	Stock	18.13	18.34	17.88	17.91	204293.0
2021-07-16	ABEO	Stock	33.25	33.75	31.75	32.0	33548.0
2021-07-16	ABEV	Stock	3.44	3.45	3.37	3.39	37988700.0
2021-07-16	ABG	Stock	189.43	189.43	183.34	184.17	171700.0
2021-07-16	ABGI-DELISTED	Stock	9.85	9.85	9.85	9.85	1139.0
2021-07-16	ABM	Stock	46.91	47.07	46.24	46.42	970800.0
2021-07-16	ABMD-DELISTED	Stock	311.35	318.58	309.97	317.97	91038.0
2021-07-16	ABNB	Stock	139.69	139.79	133.51	134.31	6094600.0
2021-07-16	ABOS	Stock	17.17	18.24	16.49	17.86	151300.0
2021-07-16	ABR	Stock	17.87	18.04	17.64	17.72	1010700.0
2021-07-16	ABR.D	Stock	25.52	25.55	25.44	25.44	48521.0

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

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