PREVIEW / stock_daily / 2022-06-07

all stock daily files

  file:    by_date/stock_daily/2022/2022-06-07.parquet
  size:    258 KB
  rows:    7,994
  symbols: 2,407

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
2022-06-07	AAPL	Stock	144.35	149.0	144.1	148.71	67808200.0
2022-06-07	MSFT	Stock	266.64	273.13	265.94	272.5	22860700.0
2022-06-07	NVDA	Stock	18.472	19.0	18.188	18.926	388914000.0
2022-06-07	AMZN	Stock	122.01	124.1	120.63	123.0	85156700.0
2022-06-07	GOOGL	Stock	115.4805	117.691	115.052	117.1495	31590460.0
2022-06-07	META	Stock	191.93	196.53	191.49	195.65	18828700.0
2022-06-07	TSLA	Stock	234.0	239.9967	230.0933	238.8867	72808500.0
2022-06-07	TLT	Stock	114.61	115.775	114.58	115.12	14278653.0
2022-06-07	ES	Stock	92.14	92.89	91.27	92.84	1032900.0
2022-06-07	CL	Stock	77.99	78.76	77.6	78.71	6609400.0
2022-06-07	A	Stock	126.57	131.2	126.57	128.9	1236300.0
2022-06-07	AA	Stock	62.8	65.55	62.23	65.51	3811100.0
2022-06-07	AAC-DELISTED	Stock	9.81	9.825	9.81	9.825	177647.0
2022-06-07	AACG	Stock	1.05	1.06	1.05	1.06	8400.0
2022-06-07	AACIW-DELISTED	Stock	0.2998	0.2998	0.2998	0.2998	100.0
2022-06-07	AAIC-DELISTED	Stock	3.54	3.65	3.53	3.64	57144.0
2022-06-07	AAIC.C-DELISTED	Stock	23.56	23.56	23.56	23.56	300.0
2022-06-07	AAL	Stock	16.1	16.73	15.96	16.69	29278100.0
2022-06-07	AAM.A-DELISTED	Stock	24.8	24.8	24.71	24.71	31206.0
2022-06-07	AAM.B-DELISTED	Stock	25.7	25.7	25.49	25.6	6857.0
2022-06-07	AAMC-DELISTED	Stock	3.2941	3.5882	3.2941	3.4971	40246.0
2022-06-07	AAME	Stock	3.0	3.01	2.93	2.93	14200.0
2022-06-07	AAMI	Stock	20.69	21.02	20.5	21.0	319000.0
2022-06-07	AAN-DELISTED	Stock	18.41	19.36	18.13	19.28	381400.0
2022-06-07	AAOI	Stock	2.16	2.38	2.15	2.29	225500.0
2022-06-07	AAON	Stock	37.1667	37.3267	36.32	36.9667	163650.0
2022-06-07	AAP	Stock	187.96	189.38	185.46	186.84	1070400.0
2022-06-07	AAQC-DELISTED	Stock	9.765	9.78	9.76	9.78	12057.0
2022-06-07	AAT	Stock	31.98	32.96	31.78	32.94	400400.0
2022-06-07	AATC	Stock	5.99	6.0	5.91	5.91	4667.0
2022-06-07	AAU-DELISTED	Stock	0.2502	0.258	0.2462	0.2579	199172.0
2022-06-07	AAUAF-DELISTED	Stock	0.2502	0.258	0.2462	0.2579	202061.0
2022-06-07	AAWW-DELISTED	Stock	70.93	72.53	69.89	72.12	150331.0
2022-06-07	AAXJ	Stock	71.49	72.275	71.35	72.21	2293520.0
2022-06-07	AB	Stock	43.35	44.34	43.0	44.25	349900.0
2022-06-07	ABB-DELISTED	Stock	31.17	31.62	31.11	31.6	1450102.0
2022-06-07	ABBNY-DELISTED	Stock	31.17	31.62	31.11	31.6	1690976.0
2022-06-07	ABBV	Stock	146.92	149.35	145.87	149.14	4991200.0
2022-06-07	ABC-DELISTED	Stock	147.74	149.7345	146.4	149.5	703798.0
2022-06-07	ABCB	Stock	45.31	46.04	45.06	45.97	214200.0
2022-06-07	ABCL	Stock	7.62	8.091	7.55	7.83	1414300.0
2022-06-07	ABCM-DELISTED	Stock	14.79	15.09	14.77	15.04	60537.0
2022-06-07	ABEO	Stock	4.0	4.0	3.75	4.0	29928.0
2022-06-07	ABEV	Stock	2.81	2.81	2.74	2.79	35196600.0
2022-06-07	ABG	Stock	186.04	188.25	182.06	186.87	85900.0
2022-06-07	ABGI-DELISTED	Stock	9.79	9.79	9.79	9.79	3205.0
2022-06-07	ABM	Stock	49.61	50.16	49.49	50.11	297100.0
2022-06-07	ABMD-DELISTED	Stock	256.58	268.78	256.58	268.15	106000.0
2022-06-07	ABNB	Stock	119.76	123.912	119.12	122.9	3331200.0
2022-06-07	ABOS	Stock	3.64	4.04	3.61	3.99	307100.0

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

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