PREVIEW / stock_daily / 2009-10-14

all stock daily files

  file:    by_date/stock_daily/2009/2009-10-14.parquet
  size:    187 KB
  rows:    5,869
  symbols: 3,490

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-14	AAPL	Stock	6.8661	6.8686	6.7939	6.8318	375510800.0
2009-10-14	MSFT	Stock	26.14	26.2	25.82	25.96	45365500.0
2009-10-14	NVDA	Stock	0.3625	0.3625	0.3468	0.3485	1101948000.0
2009-10-14	AMZN	Stock	4.811	4.891	4.801	4.873	111136000.0
2009-10-14	TLT	Stock	95.51	96.1	94.9	95.12	5420948.0
2009-10-14	ES	Stock	23.51	23.58	23.26	23.42	939500.0
2009-10-14	CL	Stock	39.515	39.515	39.105	39.33	5493200.0
2009-10-14	A	Stock	19.7997	19.8355	19.6495	19.7353	3873299.0
2009-10-14	AABA-DELISTED	Stock	16.94	17.03	16.82	16.95	17446478.0
2009-10-14	AACC-DELISTED	Stock	7.22	7.31	7.06	7.13	26344.0
2009-10-14	AACG	Stock	5.92	5.96	5.92	5.92	1300.0
2009-10-14	AAI-DELISTED	Stock	5.0	5.13	4.87	5.1	8796290.0
2009-10-14	AAIC-DELISTED	Stock	11.8	12.4	11.2701	12.4	116749.0
2009-10-14	AAME	Stock	1.26	1.69	1.26	1.69	36500.0
2009-10-14	AAON	Stock	3.676	3.7333	3.6642	3.7096	308306.0
2009-10-14	AAP	Stock	38.55	39.3	38.55	39.2	1476800.0
2009-10-14	AATI-DELISTED	Stock	3.21	3.74	3.1901	3.55	1838428.0
2009-10-14	AAU-DELISTED	Stock	0.8	0.8	0.76	0.78	179935.0
2009-10-14	AAUAF-DELISTED	Stock	0.8	0.8	0.76	0.78	184635.0
2009-10-14	AAV-DELISTED	Stock	7.25	7.4	7.25	7.39	947187.0
2009-10-14	AAWW-DELISTED	Stock	35.38	36.94	35.29	36.87	350767.0
2009-10-14	AAXJ	Stock	54.61	55.11	54.26	55.11	461223.0
2009-10-14	AAXN-DELISTED	Stock	4.66	4.68	4.6	4.67	322903.0
2009-10-14	AB	Stock	28.27	28.91	28.25	28.73	556900.0
2009-10-14	ABAX-DELISTED	Stock	24.42	24.74	24.09	24.74	222009.0
2009-10-14	ABB-DELISTED	Stock	21.8	21.828	21.59	21.79	4817677.0
2009-10-14	ABBC-DELISTED	Stock	7.9	7.93	7.74	7.8	59495.0
2009-10-14	ABBNY-DELISTED	Stock	21.8	21.828	21.59	21.78	4821792.0
2009-10-14	ABC-DELISTED	Stock	22.73	23.11	22.63	23.06	3567601.0
2009-10-14	ABCB	Stock	6.6942	6.8413	6.6942	6.8413	10407.0
2009-10-14	ABCO-DELISTED	Stock	13.085	13.295	13.015	13.225	294138.0
2009-10-14	ABCW-DELISTED	Stock	1.178	1.178	1.0406	1.07	195840.0
2009-10-14	ABD-DELISTED	Stock	7.455	7.575	7.385	7.545	333330.0
2009-10-14	ABE-DELISTED	Stock	17.79	18.12	17.79	17.922	17098.0
2009-10-14	ABEO	Stock	4312.5	4375.0	4225.0	4250.0	41.0
2009-10-14	ABFS-DELISTED	Stock	29.9	30.46	29.59	30.33	629308.0
2009-10-14	ABG	Stock	13.39	14.27	13.39	14.18	365800.0
2009-10-14	ABII-DELISTED	Stock	37.73	38.45	37.125	38.34	43085.0
2009-10-14	ABK-DELISTED	Stock	1.5	1.52	1.46	1.48	7078935.0
2009-10-14	ABM	Stock	20.24	20.38	20.04	20.26	145300.0
2009-10-14	ABMD-DELISTED	Stock	10.74	10.99	10.58	10.95	223544.0
2009-10-14	ABR	Stock	2.67	2.67	2.48	2.67	332200.0
2009-10-14	ABT	Stock	24.3355	24.7049	24.1052	24.5658	27761776.0
2009-10-14	ABTL-DELISTED	Stock	3.2497	3.2997	3.1003	3.1003	7668.0
2009-10-14	ABV-DELISTED	Stock	93.85	94.83	93.52	94.29	596898.0
2009-10-14	ABVA-DELISTED	Stock	2.59	2.67	2.31	2.31	8226.0
2009-10-14	ABVT-DELISTED	Stock	50.15	50.6	49.69	50.54	146419.0
2009-10-14	ABX-DELISTED	Stock	40.48	40.51	39.71	39.9	12530536.0
2009-10-14	ACAD	Stock	1.85	1.92	1.75	1.89	1135600.0
2009-10-14	ACAP-DELISTED	Stock	30.1	30.11	29.531	29.83	68130.0

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

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