PREVIEW / stock_daily / 2022-10-06

all stock daily files

  file:    by_date/stock_daily/2022/2022-10-06.parquet
  size:    251 KB
  rows:    7,829
  symbols: 2,157

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-10-06	AAPL	Stock	145.81	147.54	145.22	145.43	68402200.0
2022-10-06	MSFT	Stock	247.93	250.34	246.08	246.79	20239900.0
2022-10-06	NVDA	Stock	13.22	13.656	13.103	13.13	644157000.0
2022-10-06	AMZN	Stock	120.77	121.53	119.5	120.3	42253800.0
2022-10-06	GOOGL	Stock	100.68	102.9254	100.59	101.42	22323989.0
2022-10-06	META	Stock	137.72	141.45	136.6	139.07	36231100.0
2022-10-06	TSLA	Stock	239.44	244.58	235.35	238.13	69298400.0
2022-10-06	TLT	Stock	102.59	102.84	101.53	101.98	13965691.0
2022-10-06	ES	Stock	78.19	78.49	75.39	75.49	1870400.0
2022-10-06	CL	Stock	70.97	71.06	69.49	69.56	3383000.0
2022-10-06	A	Stock	132.3	133.82	131.6	132.18	1218400.0
2022-10-06	AA	Stock	39.37	40.35	38.65	39.85	6853900.0
2022-10-06	AAC-DELISTED	Stock	9.95	9.95	9.93	9.94	538288.0
2022-10-06	AACG	Stock	1.87	1.98	1.87	1.96	6600.0
2022-10-06	AAIC-DELISTED	Stock	2.79	2.8493	2.76	2.83	50756.0
2022-10-06	AAIC.C-DELISTED	Stock	18.99	19.69	18.99	19.69	1025.0
2022-10-06	AAL	Stock	12.77	13.0	12.4	12.73	31569300.0
2022-10-06	AAM.A-DELISTED	Stock	24.03	24.03	23.61	23.61	6533.0
2022-10-06	AAM.B-DELISTED	Stock	23.53	23.73	23.43	23.43	6787.0
2022-10-06	AAMC-DELISTED	Stock	4.6735	4.7618	4.6735	4.7059	7582.0
2022-10-06	AAME	Stock	2.8	2.83	2.8	2.83	600.0
2022-10-06	AAMI	Stock	16.75	17.63	16.52	17.58	914100.0
2022-10-06	AAN-DELISTED	Stock	10.18	10.385	9.9	9.9	348000.0
2022-10-06	AAOI	Stock	3.03	3.115	2.9	2.93	261700.0
2022-10-06	AAON	Stock	37.1333	37.5867	36.5067	36.8333	135900.0
2022-10-06	AAP	Stock	167.8	168.61	164.77	165.14	671100.0
2022-10-06	AAQC-DELISTED	Stock	9.84	9.855	9.83	9.85	485361.0
2022-10-06	AAT	Stock	25.34	25.34	24.86	25.02	187100.0
2022-10-06	AATC	Stock	4.55	4.6164	4.51	4.51	7143.0
2022-10-06	AAU-DELISTED	Stock	0.23	0.2468	0.225	0.2467	163353.0
2022-10-06	AAUAF-DELISTED	Stock	0.23	0.2468	0.225	0.245	164965.0
2022-10-06	AAWW-DELISTED	Stock	97.7	98.5	97.7	98.14	170711.0
2022-10-06	AAXJ	Stock	60.97	61.32	60.75	60.76	628646.0
2022-10-06	AB	Stock	35.91	36.37	35.42	35.58	184100.0
2022-10-06	ABB-DELISTED	Stock	25.83	26.06	25.575	25.62	1605735.0
2022-10-06	ABBNY-DELISTED	Stock	25.83	26.06	25.575	25.62	1711276.0
2022-10-06	ABBV	Stock	142.79	142.99	139.9	140.29	5124800.0
2022-10-06	ABC-DELISTED	Stock	142.14	142.38	139.67	139.91	560283.0
2022-10-06	ABCB	Stock	48.15	49.04	48.1	48.86	269700.0
2022-10-06	ABCL	Stock	11.23	11.45	11.03	11.41	1543300.0
2022-10-06	ABCM-DELISTED	Stock	15.87	16.06	15.71	16.01	148606.0
2022-10-06	ABEO	Stock	3.2	3.79	3.2	3.52	1115300.0
2022-10-06	ABEV	Stock	3.05	3.09	3.04	3.05	38644000.0
2022-10-06	ABG	Stock	156.14	159.27	151.52	152.68	264600.0
2022-10-06	ABGI-DELISTED	Stock	9.9	9.9	9.9	9.9	3501.0
2022-10-06	ABM	Stock	41.24	41.97	41.24	41.85	278300.0
2022-10-06	ABMD-DELISTED	Stock	264.15	270.75	261.71	267.2	230111.0
2022-10-06	ABNB	Stock	112.0	114.41	110.2	111.58	3446500.0
2022-10-06	ABOS	Stock	10.01	10.68	9.67	10.07	436800.0
2022-10-06	ABR	Stock	12.35	12.41	11.85	12.05	2942000.0

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

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