PREVIEW / stock_daily / 2021-06-25

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-25.parquet
  size:    260 KB
  rows:    7,872
  symbols: 2,894

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-25	AAPL	Stock	133.46	133.89	132.81	133.11	70783700.0
2021-06-25	MSFT	Stock	266.23	267.25	264.76	265.02	25611100.0
2021-06-25	NVDA	Stock	19.2805	19.3455	18.8945	19.031	278364000.0
2021-06-25	AMZN	Stock	173.2	173.241	169.709	170.073	78820000.0
2021-06-25	GOOGL	Stock	122.0	122.633	121.5652	122.5085	34596380.0
2021-06-25	META	Stock	342.59	344.12	339.68	341.37	14594400.0
2021-06-25	TSLA	Stock	229.86	231.27	222.9	223.9567	97490100.0
2021-06-25	TLT	Stock	143.265	143.4	141.37	142.01	15562491.0
2021-06-25	ES	Stock	79.24	80.39	79.16	80.29	1427900.0
2021-06-25	CL	Stock	80.61	81.51	80.33	81.46	9475300.0
2021-06-25	A	Stock	147.01	147.76	146.21	147.28	8445100.0
2021-06-25	AA	Stock	36.95	37.11	35.78	35.8	32496800.0
2021-06-25	AAC-DELISTED	Stock	9.8	9.87	9.79	9.87	1879018.0
2021-06-25	AACG	Stock	3.07	3.1	2.98	3.05	63400.0
2021-06-25	AAIC-DELISTED	Stock	3.99	4.095	3.99	4.0	3803574.0
2021-06-25	AAIC.C-DELISTED	Stock	25.0	25.0001	24.88	24.9745	1390.0
2021-06-25	AAL	Stock	22.33	22.48	22.07	22.22	18738600.0
2021-06-25	AAM.A-DELISTED	Stock	26.3	26.3	26.25	26.25	18950.0
2021-06-25	AAM.B-DELISTED	Stock	27.11	27.1979	27.03	27.08	10017.0
2021-06-25	AAMC-DELISTED	Stock	5.7676	5.8176	5.6142	5.8176	20947.0
2021-06-25	AAME	Stock	4.2	4.33	4.15	4.26	50300.0
2021-06-25	AAMI	Stock	23.89	24.18	23.64	23.93	1239000.0
2021-06-25	AAN-DELISTED	Stock	33.36	34.74	32.52	32.98	1823700.0
2021-06-25	AAOI	Stock	8.47	8.84	8.461	8.82	3761300.0
2021-06-25	AAON	Stock	40.9667	41.4933	40.52	40.72	587100.0
2021-06-25	AAP	Stock	202.17	205.46	202.0	204.43	675000.0
2021-06-25	AAQC-DELISTED	Stock	9.73	9.73	9.6901	9.71	3678.0
2021-06-25	AAT	Stock	37.33	37.61	37.22	37.51	594400.0
2021-06-25	AAU-DELISTED	Stock	0.4975	0.509	0.4951	0.4985	821221.0
2021-06-25	AAUAF-DELISTED	Stock	0.4975	0.509	0.4951	0.5	911917.0
2021-06-25	AAWW-DELISTED	Stock	69.24	69.97	67.84	68.22	604287.0
2021-06-25	AAXJ	Stock	94.85	94.955	94.53	94.88	1986224.0
2021-06-25	AB	Stock	45.91	46.23	45.65	45.96	139900.0
2021-06-25	ABB-DELISTED	Stock	34.6	34.64	34.45	34.48	834561.0
2021-06-25	ABBNY-DELISTED	Stock	34.6	34.64	34.45	34.49	902615.0
2021-06-25	ABBV	Stock	112.9	113.59	112.14	112.98	11709400.0
2021-06-25	ABC-DELISTED	Stock	115.48	116.78	114.98	116.41	2069579.0
2021-06-25	ABCB	Stock	52.96	53.55	52.53	53.02	821900.0
2021-06-25	ABCL	Stock	21.12	21.2	20.15	20.74	3134700.0
2021-06-25	ABCM-DELISTED	Stock	19.29	19.31	19.045	19.24	105055.0
2021-06-25	ABEO	Stock	42.25	43.75	41.5	42.25	405004.0
2021-06-25	ABEV	Stock	3.63	3.64	3.42	3.44	42125500.0
2021-06-25	ABG	Stock	162.05	169.59	162.05	169.01	857500.0
2021-06-25	ABGI-DELISTED	Stock	9.87	9.95	9.82	9.85	15023.0
2021-06-25	ABM	Stock	45.13	45.9	44.91	45.02	951600.0
2021-06-25	ABMD-DELISTED	Stock	312.3	314.28	308.99	311.53	248319.0
2021-06-25	ABNB	Stock	151.23	153.17	149.28	149.67	6452400.0
2021-06-25	ABR	Stock	18.57	18.64	18.31	18.39	4516700.0
2021-06-25	ABR.D	Stock	25.5182	25.56	25.4	25.44	131915.0
2021-06-25	ABST-DELISTED	Stock	14.49	14.5	14.33	14.35	87115.0

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

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