PREVIEW / stock_daily / 2021-10-05

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-05.parquet
  size:    257 KB
  rows:    7,860
  symbols: 2,661

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-05	AAPL	Stock	139.49	142.24	139.36	141.11	80861100.0
2021-10-05	MSFT	Stock	284.05	290.4	284.05	288.76	24993000.0
2021-10-05	NVDA	Stock	19.95	20.648	19.854	20.451	279282000.0
2021-10-05	AMZN	Stock	160.225	163.0365	160.123	161.05	65384000.0
2021-10-05	GOOGL	Stock	134.041	137.2245	134.041	136.023	32403260.0
2021-10-05	META	Stock	328.58	335.18	326.16	332.96	35377900.0
2021-10-05	TSLA	Stock	261.6	265.77	258.0667	260.1967	55297800.0
2021-10-05	TLT	Stock	144.6	144.7	143.461	143.58	22659503.0
2021-10-05	ES	Stock	84.79	85.41	84.39	84.69	1442600.0
2021-10-05	CL	Stock	75.0	75.08	74.37	74.42	4915400.0
2021-10-05	A	Stock	153.48	155.78	152.34	153.03	1494300.0
2021-10-05	AA	Stock	49.59	49.82	48.39	49.05	4226400.0
2021-10-05	AAC-DELISTED	Stock	9.76	9.78	9.75	9.77	296706.0
2021-10-05	AACG	Stock	2.34	2.36	2.26	2.26	20100.0
2021-10-05	AAIC-DELISTED	Stock	3.7	3.749	3.69	3.73	85669.0
2021-10-05	AAIC.C-DELISTED	Stock	25.23	25.23	25.2	25.2	1100.0
2021-10-05	AAL	Stock	21.5	21.85	21.25	21.47	22580100.0
2021-10-05	AAM.A-DELISTED	Stock	25.67	25.67	25.5653	25.5886	10165.0
2021-10-05	AAM.B-DELISTED	Stock	27.03	27.03	26.84	26.95	17787.0
2021-10-05	AAMC-DELISTED	Stock	7.0588	7.1809	6.9118	6.95	110197.0
2021-10-05	AAME	Stock	4.14	4.3	4.07	4.18	21600.0
2021-10-05	AAMI	Stock	26.0	26.505	25.95	26.13	343400.0
2021-10-05	AAN-DELISTED	Stock	27.67	28.23	27.378	27.92	182700.0
2021-10-05	AAOI	Stock	6.81	7.03	6.8	6.87	309900.0
2021-10-05	AAON	Stock	44.7867	45.6533	44.32	45.2467	162300.0
2021-10-05	AAP	Stock	208.32	211.24	206.49	209.02	460700.0
2021-10-05	AAQC-DELISTED	Stock	9.73	9.75	9.73	9.74	1209.0
2021-10-05	AAT	Stock	38.26	38.26	37.59	37.67	237600.0
2021-10-05	AATC	Stock	7.3622	7.3999	7.1	7.32	34644.0
2021-10-05	AAU-DELISTED	Stock	0.3724	0.385	0.3724	0.38	404278.0
2021-10-05	AAUAF-DELISTED	Stock	0.3724	0.385	0.3724	0.3801	411451.0
2021-10-05	AAWW-DELISTED	Stock	84.31	86.45	83.7	85.58	516636.0
2021-10-05	AAXJ	Stock	83.6	84.31	83.6	83.99	717467.0
2021-10-05	AB	Stock	50.37	50.98	50.04	50.58	155900.0
2021-10-05	ABB-DELISTED	Stock	32.78	33.14	32.73	32.96	1128875.0
2021-10-05	ABBNY-DELISTED	Stock	32.78	33.14	32.73	32.96	1247829.0
2021-10-05	ABBV	Stock	109.39	110.58	109.1	109.51	7146900.0
2021-10-05	ABC-DELISTED	Stock	118.48	120.2	117.78	118.67	480892.0
2021-10-05	ABCB	Stock	53.06	54.0	52.12	52.62	360300.0
2021-10-05	ABCL	Stock	16.43	16.88	16.18	16.53	1672700.0
2021-10-05	ABCM-DELISTED	Stock	20.41	20.7	20.41	20.53	18997.0
2021-10-05	ABEO	Stock	26.25	26.75	21.0	23.75	154792.0
2021-10-05	ABEV	Stock	2.71	2.77	2.68	2.73	20877500.0
2021-10-05	ABG	Stock	204.11	205.15	198.19	200.26	174400.0
2021-10-05	ABGI-DELISTED	Stock	9.72	9.72	9.72	9.72	1950.0
2021-10-05	ABM	Stock	46.75	47.56	46.12	47.41	389300.0
2021-10-05	ABMD-DELISTED	Stock	315.36	334.56	315.36	332.28	231405.0
2021-10-05	ABNB	Stock	165.67	166.59	162.43	164.74	4340100.0
2021-10-05	ABOS	Stock	15.17	15.64	14.73	15.31	128000.0
2021-10-05	ABR	Stock	18.96	19.08	18.84	18.96	1151100.0

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

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