PREVIEW / stock_daily / 2022-04-01

all stock daily files

  file:    by_date/stock_daily/2022/2022-04-01.parquet
  size:    262 KB
  rows:    8,014
  symbols: 2,481

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-04-01	AAPL	Stock	174.03	174.88	171.94	174.31	78751300.0
2022-04-01	MSFT	Stock	309.37	310.13	305.54	309.42	27110500.0
2022-04-01	NVDA	Stock	27.375	27.496	26.267	26.712	517235000.0
2022-04-01	AMZN	Stock	164.1495	165.827	162.3195	163.56	57090000.0
2022-04-01	GOOGL	Stock	139.5	140.4708	138.3075	140.1505	25941440.0
2022-04-01	META	Stock	224.55	227.28	222.7	224.85	19544800.0
2022-04-01	TSLA	Stock	360.3833	364.9167	355.5467	361.53	54263100.0
2022-04-01	TLT	Stock	130.01	132.96	129.71	132.38	23489724.0
2022-04-01	ES	Stock	88.19	89.87	87.62	89.84	1650500.0
2022-04-01	CL	Stock	75.87	76.44	75.11	76.42	6464700.0
2022-04-01	A	Stock	134.18	134.6	131.86	133.97	1466900.0
2022-04-01	AA	Stock	91.69	93.58	87.535	90.62	5746300.0
2022-04-01	AAC-DELISTED	Stock	9.82	9.82	9.79	9.8	248500.0
2022-04-01	AACG	Stock	1.56	1.6	1.4	1.44	151100.0
2022-04-01	AACIW-DELISTED	Stock	0.3099	0.31	0.305	0.305	2100.0
2022-04-01	AAIC-DELISTED	Stock	3.54	3.55	3.48	3.49	275510.0
2022-04-01	AAIC.C-DELISTED	Stock	24.6501	24.6501	24.6501	24.6501	1000.0
2022-04-01	AAL	Stock	18.3	18.4	18.07	18.24	25182700.0
2022-04-01	AAM.A-DELISTED	Stock	25.16	25.1828	25.14	25.17	1992.0
2022-04-01	AAM.B-DELISTED	Stock	25.5	25.6433	25.46	25.52	10019.0
2022-04-01	AAMC-DELISTED	Stock	4.2529	4.2529	4.1382	4.15	7613.0
2022-04-01	AAME	Stock	3.1	3.3	3.1	3.15	11700.0
2022-04-01	AAMI	Stock	24.57	24.79	24.32	24.63	331700.0
2022-04-01	AAN-DELISTED	Stock	20.51	20.56	19.98	20.15	332000.0
2022-04-01	AAOI	Stock	3.66	3.741	3.29	3.31	506100.0
2022-04-01	AAON	Stock	37.4133	37.6867	36.9533	37.4667	361650.0
2022-04-01	AAP	Stock	207.76	209.28	206.24	207.48	693400.0
2022-04-01	AAQC-DELISTED	Stock	9.75	9.75	9.75	9.75	1705.0
2022-04-01	AAT	Stock	38.03	38.72	38.03	38.71	331400.0
2022-04-01	AATC	Stock	6.37	6.37	6.25	6.28	9146.0
2022-04-01	AAU-DELISTED	Stock	0.3692	0.3692	0.3501	0.3584	348492.0
2022-04-01	AAUAF-DELISTED	Stock	0.3692	0.3692	0.3501	0.36	353675.0
2022-04-01	AAWW-DELISTED	Stock	86.5	87.43	81.26	82.23	492880.0
2022-04-01	AAXJ	Stock	76.55	76.84	75.905	76.3	3402190.0
2022-04-01	AB	Stock	47.06	47.85	46.9	47.83	256900.0
2022-04-01	ABB-DELISTED	Stock	32.87	32.93	32.5475	32.87	1954939.0
2022-04-01	ABBNY-DELISTED	Stock	32.87	32.93	32.5475	32.87	2186617.0
2022-04-01	ABBV	Stock	162.15	163.07	160.1	162.68	5703300.0
2022-04-01	ABC-DELISTED	Stock	154.93	157.46	154.075	156.52	577831.0
2022-04-01	ABCB	Stock	44.44	44.83	42.69	42.99	601400.0
2022-04-01	ABCL	Stock	9.83	10.27	9.83	10.13	1379600.0
2022-04-01	ABCM-DELISTED	Stock	18.21	18.76	18.17	18.7	78284.0
2022-04-01	ABEO	Stock	8.0	8.75	7.75	8.0	128860.0
2022-04-01	ABEV	Stock	3.25	3.29	3.19	3.29	22548600.0
2022-04-01	ABG	Stock	159.62	163.42	155.67	157.86	261900.0
2022-04-01	ABGI-DELISTED	Stock	9.81	9.81	9.81	9.81	200.0
2022-04-01	ABM	Stock	46.09	46.46	45.23	46.38	928900.0
2022-04-01	ABMD-DELISTED	Stock	333.72	340.845	331.07	338.46	129129.0
2022-04-01	ABNB	Stock	173.06	177.94	172.23	173.07	3644900.0
2022-04-01	ABOS	Stock	3.9	4.09	3.69	4.01	271600.0

> showing 50 of 8,014 rows — these rows as CSV

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