PREVIEW / stock_daily / 2021-09-29

all stock daily files

  file:    by_date/stock_daily/2021/2021-09-29.parquet
  size:    257 KB
  rows:    7,863
  symbols: 2,689

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-09-29	AAPL	Stock	142.47	144.45	142.03	142.83	74602000.0
2021-09-29	MSFT	Stock	285.1	286.77	283.01	284.0	26353700.0
2021-09-29	NVDA	Stock	20.94	21.017	20.467	20.517	218394000.0
2021-09-29	AMZN	Stock	166.1055	167.565	164.8935	165.056	51246000.0
2021-09-29	GOOGL	Stock	136.98	137.151	133.865	134.3535	30848700.0
2021-09-29	META	Stock	343.15	345.23	338.88	339.61	14452200.0
2021-09-29	TSLA	Stock	259.9333	264.5	256.8933	260.4367	62828700.0
2021-09-29	TLT	Stock	144.8	145.43	143.69	144.34	23569416.0
2021-09-29	ES	Stock	81.3	82.5	81.02	82.14	1076800.0
2021-09-29	CL	Stock	75.82	77.36	75.69	77.08	4094300.0
2021-09-29	A	Stock	161.39	161.81	159.83	160.0	1268200.0
2021-09-29	AA	Stock	52.075	52.08	50.161	50.58	4609100.0
2021-09-29	AAC-DELISTED	Stock	9.77	9.77	9.72	9.73	108099.0
2021-09-29	AACG	Stock	2.48	2.48	2.31	2.35	18500.0
2021-09-29	AAIC-DELISTED	Stock	3.76	3.77	3.7	3.71	179774.0
2021-09-29	AAIC.C-DELISTED	Stock	25.17	25.525	25.17	25.1701	1428.0
2021-09-29	AAL	Stock	21.51	21.58	21.0	21.01	20467900.0
2021-09-29	AAM.A-DELISTED	Stock	25.67	25.83	25.659	25.83	12702.0
2021-09-29	AAM.B-DELISTED	Stock	26.63	26.96	26.63	26.96	26051.0
2021-09-29	AAMC-DELISTED	Stock	6.8147	7.2382	6.5059	6.7794	409272.0
2021-09-29	AAME	Stock	4.04	4.04	3.93	3.96	7400.0
2021-09-29	AAMI	Stock	26.25	26.25	25.87	26.04	464800.0
2021-09-29	AAN-DELISTED	Stock	28.32	29.0	27.92	28.49	158200.0
2021-09-29	AAOI	Stock	7.13	7.18	6.98	7.04	273400.0
2021-09-29	AAON	Stock	44.1733	44.6733	44.12	44.1867	138600.0
2021-09-29	AAP	Stock	216.13	218.04	214.58	216.77	740200.0
2021-09-29	AAQC-DELISTED	Stock	9.71	9.71	9.71	9.71	457.0
2021-09-29	AAT	Stock	38.06	38.28	37.86	37.9	276900.0
2021-09-29	AATC	Stock	7.75	7.75	7.42	7.51	13548.0
2021-09-29	AAU-DELISTED	Stock	0.3999	0.4	0.382	0.3826	310511.0
2021-09-29	AAUAF-DELISTED	Stock	0.3999	0.4	0.382	0.3822	318838.0
2021-09-29	AAWW-DELISTED	Stock	84.03	85.77	83.34	85.12	500417.0
2021-09-29	AAXJ	Stock	84.96	85.2	84.355	84.38	1036854.0
2021-09-29	AB	Stock	49.99	50.04	49.17	49.8	244100.0
2021-09-29	ABB-DELISTED	Stock	33.78	33.84	33.6	33.65	1094079.0
2021-09-29	ABBNY-DELISTED	Stock	33.78	33.84	33.6	33.64	1226238.0
2021-09-29	ABBV	Stock	107.85	109.58	107.48	108.84	6270100.0
2021-09-29	ABC-DELISTED	Stock	121.4	123.07	121.4	122.5	557548.0
2021-09-29	ABCB	Stock	51.78	53.41	51.78	53.29	297800.0
2021-09-29	ABCL	Stock	19.69	20.02	19.11	19.45	1262400.0
2021-09-29	ABCM-DELISTED	Stock	19.86	19.94	19.68	19.92	63806.0
2021-09-29	ABEO	Stock	28.75	29.25	27.25	27.5	31080.0
2021-09-29	ABEV	Stock	2.82	2.86	2.8	2.8	24114300.0
2021-09-29	ABG	Stock	202.67	204.55	200.1	203.24	148600.0
2021-09-29	ABGI-DELISTED	Stock	9.69	9.73	9.67	9.73	52288.0
2021-09-29	ABM	Stock	45.02	45.67	44.75	45.58	185900.0
2021-09-29	ABMD-DELISTED	Stock	333.41	336.4479	328.91	329.0	55635.0
2021-09-29	ABNB	Stock	170.1	171.221	166.55	168.07	2788700.0
2021-09-29	ABOS	Stock	14.72	15.445	14.56	14.85	46900.0
2021-09-29	ABR	Stock	18.31	18.49	18.22	18.47	816900.0

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

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