PREVIEW / stock_daily / 2021-10-20

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-20.parquet
  size:    258 KB
  rows:    7,852
  symbols: 2,626

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-10-20	AAPL	Stock	148.7	149.75	148.12	149.26	58418800.0
2021-10-20	MSFT	Stock	309.21	309.7	306.11	307.41	16537100.0
2021-10-20	NVDA	Stock	22.305	22.433	21.982	22.103	146276000.0
2021-10-20	AMZN	Stock	172.633	173.143	170.0185	170.753	42796000.0
2021-10-20	GOOGL	Stock	143.338	143.5461	141.3765	141.769	23288060.0
2021-10-20	META	Stock	343.45	343.98	339.45	340.78	13639500.0
2021-10-20	TSLA	Stock	288.45	289.83	285.7933	288.6	42096300.0
2021-10-20	TLT	Stock	143.25	143.68	142.51	142.73	12782477.0
2021-10-20	ES	Stock	86.38	87.13	85.79	86.3	1552800.0
2021-10-20	CL	Stock	74.57	75.63	74.52	75.1	5317600.0
2021-10-20	A	Stock	156.93	158.12	156.31	157.59	1053000.0
2021-10-20	AA	Stock	52.8	53.9	52.02	52.51	7330400.0
2021-10-20	AAC-DELISTED	Stock	9.77	9.77	9.75	9.75	64198.0
2021-10-20	AACG	Stock	2.57	2.9	2.36	2.44	378800.0
2021-10-20	AACIU	Stock	9.9	9.95	9.9	9.95	14712.0
2021-10-20	AAIC-DELISTED	Stock	3.92	3.97	3.92	3.94	34251.0
2021-10-20	AAIC.C-DELISTED	Stock	25.1444	25.24	25.0901	25.0901	4197.0
2021-10-20	AAL	Stock	19.59	19.84	19.22	19.52	31618100.0
2021-10-20	AAM.A-DELISTED	Stock	26.0	26.1	25.9042	26.04	24392.0
2021-10-20	AAM.B-DELISTED	Stock	27.06	27.29	27.06	27.22	23957.0
2021-10-20	AAMC-DELISTED	Stock	7.1132	7.7382	7.1132	7.7382	90760.0
2021-10-20	AAME	Stock	4.2	4.25	4.18	4.25	5100.0
2021-10-20	AAMI	Stock	26.65	26.94	26.465	26.76	569500.0
2021-10-20	AAN-DELISTED	Stock	28.47	29.349	28.47	29.21	133700.0
2021-10-20	AAOI	Stock	7.42	7.57	7.3	7.41	305600.0
2021-10-20	AAON	Stock	47.5667	47.8533	46.9333	47.0267	75900.0
2021-10-20	AAP	Stock	224.29	229.24	224.29	226.66	442200.0
2021-10-20	AAQC-DELISTED	Stock	9.73	9.77	9.73	9.77	9660.0
2021-10-20	AAT	Stock	38.74	39.47	38.61	39.42	229800.0
2021-10-20	AATC	Stock	7.18	7.19	6.85	7.0	42575.0
2021-10-20	AAU-DELISTED	Stock	0.381	0.3879	0.377	0.378	441412.0
2021-10-20	AAUAF-DELISTED	Stock	0.381	0.3879	0.377	0.378	449602.0
2021-10-20	AAWW-DELISTED	Stock	77.72	78.56	77.04	78.33	560858.0
2021-10-20	AAXJ	Stock	88.81	88.91	88.45	88.62	562640.0
2021-10-20	AB	Stock	52.85	53.65	52.76	53.22	161100.0
2021-10-20	ABB-DELISTED	Stock	34.98	35.06	34.74	35.03	974035.0
2021-10-20	ABBNY-DELISTED	Stock	34.98	35.06	34.74	35.04	1089582.0
2021-10-20	ABBV	Stock	107.5	109.11	107.5	108.41	5626800.0
2021-10-20	ABC-DELISTED	Stock	119.73	123.28	119.73	122.26	434729.0
2021-10-20	ABCB	Stock	51.94	53.36	51.77	53.32	291300.0
2021-10-20	ABCL	Stock	15.99	16.12	15.79	16.04	717800.0
2021-10-20	ABCM-DELISTED	Stock	22.48	22.585	22.29	22.4	27050.0
2021-10-20	ABEO	Stock	22.25	23.0	22.25	22.5	14004.0
2021-10-20	ABEV	Stock	2.69	2.76	2.69	2.73	20729900.0
2021-10-20	ABG	Stock	215.07	219.15	215.06	215.27	100800.0
2021-10-20	ABM	Stock	45.13	45.54	44.71	45.01	201600.0
2021-10-20	ABMD-DELISTED	Stock	351.16	353.8211	345.3077	346.22	55591.0
2021-10-20	ABNB	Stock	170.06	171.94	168.2	169.76	2687000.0
2021-10-20	ABOS	Stock	14.01	14.41	13.59	14.16	30100.0
2021-10-20	ABR	Stock	19.65	19.8	19.56	19.64	897400.0

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

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