PREVIEW / stock_daily / 2021-09-13

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-13.parquet
  size:    257 KB
  rows:    7,858
  symbols: 2,701

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-09-13	AAPL	Stock	150.63	151.42	148.75	149.55	102404300.0
2021-09-13	MSFT	Stock	297.55	298.54	294.08	296.99	23652900.0
2021-09-13	NVDA	Stock	22.684	22.964	21.858	22.152	297500000.0
2021-09-13	AMZN	Stock	174.14	174.898	171.9	172.8585	51380000.0
2021-09-13	GOOGL	Stock	141.9495	142.95	141.25	142.3325	22093840.0
2021-09-13	META	Stock	381.68	381.75	374.35	376.51	13026300.0
2021-09-13	TSLA	Stock	246.7367	248.26	236.2833	247.6667	68857500.0
2021-09-13	TLT	Stock	149.042	149.49	148.95	149.3	15036064.0
2021-09-13	ES	Stock	89.04	89.48	87.88	88.35	1550500.0
2021-09-13	CL	Stock	77.34	78.18	77.16	77.38	3371400.0
2021-09-13	A	Stock	177.66	178.0	170.22	172.08	2274300.0
2021-09-13	AA	Stock	50.25	51.169	49.06	49.22	8579100.0
2021-09-13	AAC-DELISTED	Stock	9.76	9.79	9.72	9.77	553343.0
2021-09-13	AACG	Stock	2.85	2.89	2.8	2.87	33900.0
2021-09-13	AACIU	Stock	9.89	9.89	9.88	9.88	552.0
2021-09-13	AAIC-DELISTED	Stock	3.76	3.82	3.76	3.82	111491.0
2021-09-13	AAIC.C-DELISTED	Stock	25.51	25.55	25.51	25.55	643.0
2021-09-13	AAL	Stock	19.16	19.52	18.64	19.31	42886000.0
2021-09-13	AAM.A-DELISTED	Stock	25.99	25.99	25.8434	25.9	7388.0
2021-09-13	AAM.B-DELISTED	Stock	26.97	27.08	26.8628	27.04	9417.0
2021-09-13	AAMC-DELISTED	Stock	8.5088	8.5088	7.7971	8.0529	156288.0
2021-09-13	AAME	Stock	3.93	3.99	3.83	3.9	78600.0
2021-09-13	AAMI	Stock	26.86	27.02	26.67	27.0	512900.0
2021-09-13	AAN-DELISTED	Stock	26.31	26.68	25.935	26.57	196600.0
2021-09-13	AAOI	Stock	7.44	7.52	7.216	7.45	372900.0
2021-09-13	AAON	Stock	43.66	43.9333	42.82	43.3467	443250.0
2021-09-13	AAP	Stock	201.41	201.94	197.5	199.26	542400.0
2021-09-13	AAQC-DELISTED	Stock	9.66	9.69	9.65	9.69	3806.0
2021-09-13	AAT	Stock	38.66	39.6	38.66	39.49	229200.0
2021-09-13	AATC	Stock	8.26	8.2754	7.83	8.01	39173.0
2021-09-13	AAU-DELISTED	Stock	0.41	0.42	0.4001	0.416	435906.0
2021-09-13	AAUAF-DELISTED	Stock	0.41	0.42	0.4001	0.416	454657.0
2021-09-13	AAWW-DELISTED	Stock	74.83	74.83	72.45	73.21	229138.0
2021-09-13	AAXJ	Stock	89.21	89.45	88.77	89.28	563004.0
2021-09-13	AB	Stock	52.0	52.54	51.71	51.92	159100.0
2021-09-13	ABB-DELISTED	Stock	36.99	37.045	36.55	36.73	863709.0
2021-09-13	ABBNY-DELISTED	Stock	36.99	37.045	36.55	36.74	987717.0
2021-09-13	ABBV	Stock	107.39	108.77	106.81	107.48	7398900.0
2021-09-13	ABC-DELISTED	Stock	123.31	123.81	122.58	123.67	440253.0
2021-09-13	ABCB	Stock	46.79	47.72	46.47	47.67	585900.0
2021-09-13	ABCL	Stock	18.93	18.99	17.628	17.73	2875100.0
2021-09-13	ABCM-DELISTED	Stock	20.52	20.62	20.14	20.22	70526.0
2021-09-13	ABEO	Stock	32.5	32.75	31.25	32.0	20648.0
2021-09-13	ABEV	Stock	3.1	3.14	3.06	3.07	26156500.0
2021-09-13	ABG	Stock	173.61	174.08	169.25	173.52	138900.0
2021-09-13	ABGI-DELISTED	Stock	9.65	9.69	9.65	9.69	10500.0
2021-09-13	ABM	Stock	46.43	46.87	45.86	46.26	465800.0
2021-09-13	ABMD-DELISTED	Stock	362.17	362.17	349.36	351.97	100697.0
2021-09-13	ABNB	Stock	160.25	162.99	154.79	160.32	7520900.0
2021-09-13	ABOS	Stock	16.89	17.67	15.61	16.03	184300.0

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

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