PREVIEW / stock_daily / 2009-07-07

all stock daily files

  file:    by_date/stock_daily/2009/2009-07-07.parquet
  size:    180 KB
  rows:    5,749
  symbols: 3,420

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-07-07	AAPL	Stock	4.9457	4.9886	4.8279	4.8357	461596800.0
2009-07-07	MSFT	Stock	23.08	23.14	22.46	22.53	52842500.0
2009-07-07	NVDA	Stock	0.2648	0.2663	0.2515	0.2523	1072996000.0
2009-07-07	AMZN	Stock	3.9265	3.9345	3.7705	3.7815	129830000.0
2009-07-07	TLT	Stock	93.62	94.88	93.61	94.75	2592443.0
2009-07-07	ES	Stock	22.34	22.58	21.95	22.06	1204800.0
2009-07-07	CL	Stock	37.14	37.14	36.455	36.56	7122000.0
2009-07-07	A	Stock	13.9914	14.0844	13.5551	13.5837	3558889.0
2009-07-07	AABA-DELISTED	Stock	14.93	14.94	14.36	14.43	21936190.0
2009-07-07	AACC-DELISTED	Stock	7.71	7.92	7.34	7.41	77130.0
2009-07-07	AACG	Stock	8.01	8.01	7.64	7.69	7400.0
2009-07-07	AAI-DELISTED	Stock	6.35	6.35	5.87	5.98	2173133.0
2009-07-07	AAIC-DELISTED	Stock	7.2	7.8	7.2	7.4	369058.0
2009-07-07	AAME	Stock	0.82	0.82	0.78	0.82	3700.0
2009-07-07	AAON	Stock	3.9585	3.9901	3.8459	3.8637	153394.0
2009-07-07	AAP	Stock	42.3	42.49	41.65	41.75	1061400.0
2009-07-07	AATI-DELISTED	Stock	4.48	4.5	4.28	4.28	217483.0
2009-07-07	AAU-DELISTED	Stock	0.615	0.62	0.5915	0.6	63600.0
2009-07-07	AAUAF-DELISTED	Stock	0.615	0.62	0.5915	0.6	64600.0
2009-07-07	AAV-DELISTED	Stock	3.89	3.89	3.56	3.77	1246931.0
2009-07-07	AAWW-DELISTED	Stock	22.17	22.44	21.1	21.13	206875.0
2009-07-07	AAXJ	Stock	43.49	43.72	42.73	42.78	119002.0
2009-07-07	AAXN-DELISTED	Stock	4.5	4.61	4.43	4.43	253446.0
2009-07-07	AB	Stock	19.25	19.25	18.5	18.61	297800.0
2009-07-07	ABAX-DELISTED	Stock	19.49	19.68	19.21	19.25	319085.0
2009-07-07	ABB-DELISTED	Stock	15.28	15.31	14.81	14.84	4103105.0
2009-07-07	ABBC-DELISTED	Stock	7.98	8.06	7.9	7.9	34234.0
2009-07-07	ABBNY-DELISTED	Stock	15.28	15.31	14.81	14.85	5385725.0
2009-07-07	ABC-DELISTED	Stock	17.76	18.44	17.74	18.2	3542461.0
2009-07-07	ABCB	Stock	6.1568	6.4584	6.1277	6.1277	57677.0
2009-07-07	ABCO-DELISTED	Stock	12.422	12.677	12.073	12.083	128911.0
2009-07-07	ABCW-DELISTED	Stock	1.2	1.23	1.09	1.15	77860.0
2009-07-07	ABD-DELISTED	Stock	2.67	2.89	2.55	2.58	331710.0
2009-07-07	ABE-DELISTED	Stock	14.83	15.13	14.5	14.5	8266.0
2009-07-07	ABEO	Stock	2600.0	2625.0	2562.5	2625.0	5.0
2009-07-07	ABFS-DELISTED	Stock	26.71	28.15	26.38	27.73	1374931.0
2009-07-07	ABG	Stock	9.16	9.25	8.64	8.99	543500.0
2009-07-07	ABII-DELISTED	Stock	35.18	36.15	35.18	35.91	25868.0
2009-07-07	ABK-DELISTED	Stock	0.8699	0.88	0.8	0.81	2603646.0
2009-07-07	ABM	Stock	17.62	17.62	17.15	17.27	101200.0
2009-07-07	ABMD-DELISTED	Stock	8.46	8.71	8.43	8.55	293098.0
2009-07-07	ABR	Stock	1.61	1.66	1.57	1.61	178500.0
2009-07-07	ABT	Stock	21.7925	22.114	21.6966	21.7541	17745102.0
2009-07-07	ABTL-DELISTED	Stock	2.0475	2.2373	2.0475	2.0525	20148.0
2009-07-07	ABV-DELISTED	Stock	64.71	64.97	63.04	63.14	347095.0
2009-07-07	ABVT-DELISTED	Stock	75.47	75.99	70.5	72.67	55070.0
2009-07-07	ABX-DELISTED	Stock	33.24	33.6	32.72	32.8	5296741.0
2009-07-07	ACAD	Stock	1.93	2.15	1.93	2.0	106800.0
2009-07-07	ACAP-DELISTED	Stock	39.86	39.86	38.61	38.62	39572.0
2009-07-07	ACAS-DELISTED	Stock	3.1	3.11	2.9	2.94	2715456.0

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

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