PREVIEW / stock_daily / 2021-07-15

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-15.parquet
  size:    258 KB
  rows:    7,886
  symbols: 2,847

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-15	AAPL	Stock	149.24	150.0	147.09	148.48	106820300.0
2021-07-15	MSFT	Stock	282.0	282.51	279.83	281.03	22604200.0
2021-07-15	NVDA	Stock	19.8118	19.847	18.8585	18.9662	550564000.0
2021-07-15	AMZN	Stock	184.71	184.77	181.046	181.56	63706000.0
2021-07-15	GOOGL	Stock	128.649	128.7	126.53	127.005	24218800.0
2021-07-15	META	Stock	349.23	349.23	340.22	344.46	14781600.0
2021-07-15	TSLA	Stock	219.4633	222.0467	212.6267	216.8667	60628800.0
2021-07-15	TLT	Stock	147.95	148.6	147.03	148.49	18462700.0
2021-07-15	ES	Stock	83.94	86.36	83.89	86.11	2875900.0
2021-07-15	CL	Stock	83.33	83.77	82.65	83.63	4200800.0
2021-07-15	A	Stock	148.34	149.31	147.84	148.96	1733600.0
2021-07-15	AA	Stock	35.27	35.93	34.235	34.54	8560200.0
2021-07-15	AAC-DELISTED	Stock	9.79	9.79	9.75	9.77	73134.0
2021-07-15	AACG	Stock	2.98	4.75	2.94	3.83	43796200.0
2021-07-15	AAIC-DELISTED	Stock	3.79	3.82	3.735	3.76	692873.0
2021-07-15	AAL	Stock	20.56	21.06	20.15	20.46	34187500.0
2021-07-15	AAM.A-DELISTED	Stock	26.62	26.71	26.6	26.67	14117.0
2021-07-15	AAM.B-DELISTED	Stock	27.05	27.185	26.93	27.115	14965.0
2021-07-15	AAMC-DELISTED	Stock	5.2559	5.2559	5.1529	5.1616	10033.0
2021-07-15	AAME	Stock	4.35	5.18	4.33	4.66	800400.0
2021-07-15	AAMI	Stock	23.21	23.8	23.21	23.49	354700.0
2021-07-15	AAN-DELISTED	Stock	28.59	28.99	27.9	27.98	375000.0
2021-07-15	AAOI	Stock	7.63	7.69	7.39	7.52	489700.0
2021-07-15	AAON	Stock	40.8133	41.0733	40.4467	40.6467	138000.0
2021-07-15	AAP	Stock	208.4	210.54	207.57	209.25	547200.0
2021-07-15	AAQC-DELISTED	Stock	9.69	9.7	9.67	9.7	133338.0
2021-07-15	AAT	Stock	37.17	37.46	37.09	37.2	276700.0
2021-07-15	AAU-DELISTED	Stock	0.4522	0.4539	0.45	0.45	587121.0
2021-07-15	AAUAF-DELISTED	Stock	0.4522	0.4539	0.45	0.45	600607.0
2021-07-15	AAWW-DELISTED	Stock	65.71	66.52	64.85	66.04	133722.0
2021-07-15	AAXJ	Stock	92.53	92.85	92.26	92.44	422102.0
2021-07-15	AB	Stock	45.59	45.91	45.18	45.49	93300.0
2021-07-15	ABB-DELISTED	Stock	35.53	35.8	35.455	35.63	987228.0
2021-07-15	ABBNY-DELISTED	Stock	35.53	35.8	35.455	35.63	1090240.0
2021-07-15	ABBV	Stock	116.81	117.49	115.75	117.18	4544600.0
2021-07-15	ABC-DELISTED	Stock	112.79	114.03	112.79	113.16	559851.0
2021-07-15	ABCB	Stock	47.33	48.6	47.33	48.54	292600.0
2021-07-15	ABCL	Stock	17.14	17.29	16.3	16.53	2254800.0
2021-07-15	ABCM-DELISTED	Stock	18.43	18.44	17.64	17.92	113683.0
2021-07-15	ABEO	Stock	35.25	35.25	33.0	33.75	16604.0
2021-07-15	ABEV	Stock	3.48	3.49	3.37	3.4	19507300.0
2021-07-15	ABG	Stock	188.59	192.33	186.18	186.88	141700.0
2021-07-15	ABGI-DELISTED	Stock	9.8	9.8	9.8	9.8	1100.0
2021-07-15	ABM	Stock	44.9	46.75	44.9	46.57	960800.0
2021-07-15	ABMD-DELISTED	Stock	311.21	314.175	305.76	309.81	84051.0
2021-07-15	ABNB	Stock	139.18	140.52	136.54	137.5	6576100.0
2021-07-15	ABOS	Stock	18.35	18.92	17.21	17.3	98800.0
2021-07-15	ABR	Stock	17.62	17.88	17.49	17.72	1309700.0
2021-07-15	ABR.D	Stock	25.43	25.5196	25.41	25.5	27413.0
2021-07-15	ABST-DELISTED	Stock	13.69	13.85	13.615	13.63	53350.0

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

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