PREVIEW / stock_daily / 2009-10-21

all stock daily files

  file:    by_date/stock_daily/2009/2009-10-21.parquet
  size:    187 KB
  rows:    5,848
  symbols: 3,479

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
2009-10-21	AAPL	Stock	7.1257	7.4539	7.1154	7.3186	1193726800.0
2009-10-21	MSFT	Stock	26.46	26.75	26.39	26.58	61672700.0
2009-10-21	NVDA	Stock	0.3415	0.3468	0.3328	0.3345	503956000.0
2009-10-21	AMZN	Stock	4.7635	4.8315	4.6455	4.671	155224000.0
2009-10-21	TLT	Stock	96.16	96.21	95.51	96.14	3355106.0
2009-10-21	ES	Stock	23.44	23.71	23.37	23.43	1324100.0
2009-10-21	CL	Stock	39.69	40.075	39.41	39.46	4405000.0
2009-10-21	A	Stock	18.9485	19.4993	18.8984	19.2275	6195237.0
2009-10-21	AABA-DELISTED	Stock	17.98	18.02	17.57	17.66	45088077.0
2009-10-21	AACC-DELISTED	Stock	6.99	7.07	6.92	6.96	61679.0
2009-10-21	AACG	Stock	5.72	5.72	5.64	5.72	1800.0
2009-10-21	AAI-DELISTED	Stock	5.37	5.37	4.87	4.878	11245584.0
2009-10-21	AAIC-DELISTED	Stock	14.0	14.13	13.867	14.05	283650.0
2009-10-21	AAME	Stock	1.5	1.51	1.38	1.38	6200.0
2009-10-21	AAON	Stock	3.7017	3.8202	3.6899	3.7412	572569.0
2009-10-21	AAP	Stock	38.41	38.71	37.43	37.46	1362600.0
2009-10-21	AATI-DELISTED	Stock	3.32	3.4899	3.32	3.4	485634.0
2009-10-21	AAU-DELISTED	Stock	0.7	0.74	0.6991	0.701	136088.0
2009-10-21	AAUAF-DELISTED	Stock	0.7	0.74	0.7	0.702	140600.0
2009-10-21	AAV-DELISTED	Stock	7.52	7.92	7.34	7.65	1288754.0
2009-10-21	AAWW-DELISTED	Stock	36.9	37.48	35.8476	36.1	315277.0
2009-10-21	AAXJ	Stock	54.76	55.2199	54.25	54.5	141375.0
2009-10-21	AAXN-DELISTED	Stock	4.51	4.67	4.5	4.56	651992.0
2009-10-21	AB	Stock	26.67	27.47	26.52	27.04	338500.0
2009-10-21	ABAX-DELISTED	Stock	24.47	25.47	24.44	24.69	199045.0
2009-10-21	ABB-DELISTED	Stock	21.2	21.67	21.17	21.18	2230720.0
2009-10-21	ABBC-DELISTED	Stock	7.15	7.29	7.05	7.06	39722.0
2009-10-21	ABBNY-DELISTED	Stock	21.24	21.67	21.17	21.17	2234432.0
2009-10-21	ABC-DELISTED	Stock	23.66	23.84	23.46	23.48	4007463.0
2009-10-21	ABCB	Stock	6.655	6.8609	6.1258	6.214	20712.0
2009-10-21	ABCO-DELISTED	Stock	13.005	13.13	12.625	12.665	77728.0
2009-10-21	ABCW-DELISTED	Stock	1.01	1.05	0.91	1.02	194440.0
2009-10-21	ABD-DELISTED	Stock	7.16	7.689	7.1	7.18	390380.0
2009-10-21	ABE-DELISTED	Stock	17.12	17.221	17.0	17.0	135744.0
2009-10-21	ABEO	Stock	4362.5	4362.5	4187.5	4312.5	14.0
2009-10-21	ABFS-DELISTED	Stock	30.34	31.19	28.39	28.52	1079290.0
2009-10-21	ABG	Stock	13.97	14.83	13.97	14.43	434600.0
2009-10-21	ABII-DELISTED	Stock	36.4	36.66	36.0	36.62	18771.0
2009-10-21	ABK-DELISTED	Stock	1.2	1.31	1.17	1.2	12062495.0
2009-10-21	ABM	Stock	20.28	20.75	19.74	19.8	257500.0
2009-10-21	ABMD-DELISTED	Stock	10.54	10.85	10.29	10.33	171659.0
2009-10-21	ABR	Stock	2.58	2.59	2.43	2.43	124500.0
2009-10-21	ABT	Stock	24.9064	24.9304	24.4986	24.5418	14674239.0
2009-10-21	ABTL-DELISTED	Stock	3.0539	3.0719	2.7638	2.9461	10870.0
2009-10-21	ABV-DELISTED	Stock	94.41	95.98	93.31	93.58	570506.0
2009-10-21	ABVA-DELISTED	Stock	2.64	2.69	2.605	2.69	2586.0
2009-10-21	ABVT-DELISTED	Stock	48.0	49.51	48.0	48.05	92007.0
2009-10-21	ABX-DELISTED	Stock	37.57	39.28	37.42	38.11	15663984.0
2009-10-21	ACAD	Stock	1.62	1.69	1.62	1.66	426300.0
2009-10-21	ACAP-DELISTED	Stock	30.1	30.88	29.8	29.88	40181.0

> showing 50 of 5,848 rows — these rows as CSV

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