PREVIEW / stock_daily / 2021-01-11

all stock daily files

  file:    by_date/stock_daily/2021/2021-01-11.parquet
  size:    241 KB
  rows:    7,307
  symbols: 2,655

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-01-11	AAPL	Stock	129.19	130.17	128.5	128.98	100384500.0
2021-01-11	MSFT	Stock	218.47	218.91	216.73	217.49	23031300.0
2021-01-11	NVDA	Stock	13.4188	13.961	13.3625	13.6215	518344000.0
2021-01-11	AMZN	Stock	157.4005	157.819	155.5	155.7105	73668000.0
2021-01-11	GOOGL	Stock	88.851	89.219	87.607	87.8145	34812360.0
2021-01-11	META	Stock	260.48	263.47	255.9	256.84	30412300.0
2021-01-11	TSLA	Stock	283.1333	284.81	267.8733	270.3967	177904800.0
2021-01-11	TLT	Stock	151.0	151.21	150.49	151.07	8380898.0
2021-01-11	ES	Stock	89.66	90.33	88.75	89.21	1401500.0
2021-01-11	CL	Stock	82.35	83.06	82.1	82.14	4430800.0
2021-01-11	A	Stock	126.45	129.34	126.23	128.15	1746800.0
2021-01-11	AA	Stock	23.86	24.9	23.53	24.56	3041900.0
2021-01-11	AACG	Stock	1.27	1.3	1.26	1.26	28300.0
2021-01-11	AACQ-DELISTED	Stock	10.64	10.65	10.53	10.5756	1073637.0
2021-01-11	AACQU-DELISTED	Stock	11.23	11.28	11.21	11.24	115899.0
2021-01-11	AACQW-DELISTED	Stock	2.06	2.19	2.0001	2.14	449225.0
2021-01-11	AAIC-DELISTED	Stock	3.9	3.98	3.9	3.98	175310.0
2021-01-11	AAIC.C-DELISTED	Stock	21.35	21.3961	21.0942	21.36	2450.0
2021-01-11	AAL	Stock	14.82	15.04	14.71	15.0	40545300.0
2021-01-11	AAM.A-DELISTED	Stock	26.24	26.27	26.05	26.23	39330.0
2021-01-11	AAM.B-DELISTED	Stock	26.96	26.96	26.6	26.73	18240.0
2021-01-11	AAMC-DELISTED	Stock	6.5853	6.6735	6.4824	6.4824	5250.0
2021-01-11	AAME	Stock	2.36	2.45	2.31	2.35	8500.0
2021-01-11	AAMI	Stock	19.83	21.21	19.625	20.69	1137100.0
2021-01-11	AAN-DELISTED	Stock	20.12	20.55	19.62	20.51	511700.0
2021-01-11	AAOI	Stock	10.06	10.33	9.74	10.28	771100.0
2021-01-11	AAON	Stock	45.5733	46.4133	45.5733	46.2467	222000.0
2021-01-11	AAP	Stock	167.95	173.85	167.35	171.02	1186300.0
2021-01-11	AAT	Stock	27.9	28.25	27.63	27.87	162200.0
2021-01-11	AAU-DELISTED	Stock	0.501	0.5348	0.49	0.5085	1481025.0
2021-01-11	AAUAF-DELISTED	Stock	0.501	0.5348	0.49	0.5148	1565192.0
2021-01-11	AAWW-DELISTED	Stock	50.3	52.205	50.22	51.38	362450.0
2021-01-11	AAXJ	Stock	94.22	94.4	93.89	94.02	2402748.0
2021-01-11	AAXN-DELISTED	Stock	125.18	127.87	123.6	124.8	429037.0
2021-01-11	AB	Stock	34.61	35.21	34.5	35.07	197800.0
2021-01-11	ABB-DELISTED	Stock	29.83	30.07	29.76	30.03	1889750.0
2021-01-11	ABBNY-DELISTED	Stock	29.83	30.07	29.76	30.04	2248352.0
2021-01-11	ABBV	Stock	107.07	109.56	107.07	109.02	6334200.0
2021-01-11	ABC-DELISTED	Stock	109.17	110.49	106.1	107.35	1166312.0
2021-01-11	ABCB	Stock	42.04	43.74	41.85	43.59	460400.0
2021-01-11	ABCL	Stock	40.36	40.5	36.27	36.59	872700.0
2021-01-11	ABCM-DELISTED	Stock	20.76	21.46	20.4	21.13	101871.0
2021-01-11	ABEO	Stock	43.5	47.0	41.75	46.0	98696.0
2021-01-11	ABEV	Stock	3.01	3.04	2.95	2.96	18833600.0
2021-01-11	ABG	Stock	160.51	164.49	160.51	163.78	90800.0
2021-01-11	ABM	Stock	40.17	40.81	40.17	40.71	211600.0
2021-01-11	ABMD-DELISTED	Stock	320.53	326.15	320.0	324.05	161419.0
2021-01-11	ABNB	Stock	147.99	150.5	144.02	148.13	2801900.0
2021-01-11	ABR	Stock	14.08	14.5	14.07	14.23	2391500.0
2021-01-11	ABR.A-DELISTED	Stock	25.62	25.62	25.5408	25.58	940.0

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

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