PREVIEW / stock_daily / 2021-07-07

all stock daily files

  file:    by_date/stock_daily/2021/2021-07-07.parquet
  size:    258 KB
  rows:    7,860
  symbols: 2,836

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-07	AAPL	Stock	143.54	144.89	142.66	144.57	104911600.0
2021-07-07	MSFT	Stock	279.4	280.69	277.15	279.93	23260000.0
2021-07-07	NVDA	Stock	20.8535	20.875	20.332	20.3718	418428000.0
2021-07-07	AMZN	Stock	185.869	186.71	183.9455	184.829	106562000.0
2021-07-07	GOOGL	Stock	127.162	127.284	126.153	126.474	24059020.0
2021-07-07	META	Stock	355.26	356.49	350.0	350.49	14218900.0
2021-07-07	TSLA	Stock	221.4233	221.9	212.7733	214.8833	56376000.0
2021-07-07	TLT	Stock	147.57	148.56	147.22	148.04	20964385.0
2021-07-07	ES	Stock	81.21	82.76	80.66	82.7	1441800.0
2021-07-07	CL	Stock	82.1	83.09	81.91	82.66	3220200.0
2021-07-07	A	Stock	149.59	149.62	148.09	149.49	2286300.0
2021-07-07	AA	Stock	36.66	37.28	35.83	36.23	4987900.0
2021-07-07	AAC-DELISTED	Stock	9.73	9.75	9.73	9.75	38145.0
2021-07-07	AACG	Stock	2.83	2.87	2.7	2.75	47700.0
2021-07-07	AAIC-DELISTED	Stock	3.9	3.93	3.79	3.82	247960.0
2021-07-07	AAIC.C-DELISTED	Stock	25.11	25.355	25.11	25.14	925.0
2021-07-07	AAL	Stock	20.79	21.05	20.17	20.31	30857000.0
2021-07-07	AAM.A-DELISTED	Stock	26.395	26.6103	26.395	26.6103	8848.0
2021-07-07	AAM.B-DELISTED	Stock	26.93	27.06	26.93	27.06	9432.0
2021-07-07	AAMC-DELISTED	Stock	5.4941	5.7353	5.0824	5.3971	295457.0
2021-07-07	AAME	Stock	4.46	4.46	4.28	4.45	68000.0
2021-07-07	AAMI	Stock	23.88	24.36	23.82	24.18	392700.0
2021-07-07	AAN-DELISTED	Stock	30.74	31.47	30.425	30.73	591900.0
2021-07-07	AAOI	Stock	8.14	8.265	7.76	7.8	526200.0
2021-07-07	AAON	Stock	41.58	42.8133	41.5267	42.26	164400.0
2021-07-07	AAP	Stock	207.43	209.77	206.6	209.44	689600.0
2021-07-07	AAQC-DELISTED	Stock	9.65	9.68	9.65	9.67	5408.0
2021-07-07	AAT	Stock	37.31	37.5	36.79	36.94	236100.0
2021-07-07	AAU-DELISTED	Stock	0.49	0.4966	0.462	0.4623	1002327.0
2021-07-07	AAUAF-DELISTED	Stock	0.49	0.4966	0.4612	0.4612	1035530.0
2021-07-07	AAWW-DELISTED	Stock	66.34	66.73	65.57	66.27	204861.0
2021-07-07	AAXJ	Stock	92.81	92.83	91.84	92.13	782722.0
2021-07-07	AB	Stock	46.91	47.13	45.65	45.82	391600.0
2021-07-07	ABB-DELISTED	Stock	34.92	35.165	34.81	35.1	1102016.0
2021-07-07	ABBNY-DELISTED	Stock	34.92	35.165	34.81	35.1	1198209.0
2021-07-07	ABBV	Stock	115.91	116.97	115.31	116.75	6695100.0
2021-07-07	ABC-DELISTED	Stock	114.95	116.12	114.62	115.04	565153.0
2021-07-07	ABCB	Stock	48.28	49.19	47.85	48.4	474200.0
2021-07-07	ABCL	Stock	19.8	19.9	18.3	19.0	3085800.0
2021-07-07	ABCM-DELISTED	Stock	19.38	19.45	18.91	18.93	132522.0
2021-07-07	ABEO	Stock	36.5	37.25	35.0	36.5	72484.0
2021-07-07	ABEV	Stock	3.4	3.41	3.32	3.37	22947100.0
2021-07-07	ABG	Stock	172.8	177.25	171.3	176.52	238200.0
2021-07-07	ABM	Stock	43.19	43.57	42.55	42.9	603200.0
2021-07-07	ABMD-DELISTED	Stock	329.12	335.89	325.28	334.4	176068.0
2021-07-07	ABNB	Stock	148.15	148.94	143.6	143.72	5650900.0
2021-07-07	ABOS	Stock	20.04	20.068	18.36	18.75	169200.0
2021-07-07	ABR	Stock	17.63	17.72	17.38	17.62	1065700.0
2021-07-07	ABR.D	Stock	25.48	25.52	25.43	25.45	135053.0
2021-07-07	ABST-DELISTED	Stock	14.26	14.5	14.02	14.08	44542.0

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

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