PREVIEW / stock_daily / 2009-09-08

all stock daily files

  file:    by_date/stock_daily/2009/2009-09-08.parquet
  size:    184 KB
  rows:    5,796
  symbols: 3,438

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-09-08	AAPL	Stock	6.1779	6.1836	6.1429	6.1761	315047600.0
2009-09-08	MSFT	Stock	24.62	24.84	24.41	24.82	53737100.0
2009-09-08	NVDA	Stock	0.3805	0.3882	0.3775	0.3882	549712000.0
2009-09-08	AMZN	Stock	3.993	4.052	3.9435	4.045	140752000.0
2009-09-08	TLT	Stock	94.48	95.37	94.36	94.54	2468889.0
2009-09-08	ES	Stock	23.77	23.82	23.62	23.71	572100.0
2009-09-08	CL	Stock	35.72	35.955	35.6	35.745	4430000.0
2009-09-08	A	Stock	18.4979	18.8984	18.4621	18.8913	5757803.0
2009-09-08	AABA-DELISTED	Stock	14.65	14.66	14.37	14.49	17047246.0
2009-09-08	AACC-DELISTED	Stock	7.29	7.44	7.16	7.35	45634.0
2009-09-08	AACG	Stock	6.63	6.7	6.5	6.63	3800.0
2009-09-08	AAI-DELISTED	Stock	6.6	6.66	6.45	6.55	761126.0
2009-09-08	AAIC-DELISTED	Stock	9.0	11.0	9.0	10.0	787051.0
2009-09-08	AAME	Stock	0.71	0.83	0.71	0.79	1900.0
2009-09-08	AAON	Stock	4.0277	4.0435	3.9486	3.9862	269325.0
2009-09-08	AAP	Stock	41.36	41.81	40.99	41.5	1855500.0
2009-09-08	AATI-DELISTED	Stock	4.43	4.46	4.37	4.41	132202.0
2009-09-08	AAU-DELISTED	Stock	0.73	0.77	0.73	0.7501	236714.0
2009-09-08	AAUAF-DELISTED	Stock	0.73	0.77	0.73	0.7501	237114.0
2009-09-08	AAV-DELISTED	Stock	5.78	6.1	5.78	5.91	1210195.0
2009-09-08	AAWW-DELISTED	Stock	24.47	24.9	24.35	24.5	313203.0
2009-09-08	AAXJ	Stock	51.41	53.02	50.69	51.25	125723.0
2009-09-08	AAXN-DELISTED	Stock	4.63	4.66	4.55	4.6	391342.0
2009-09-08	AB	Stock	22.72	23.55	22.71	23.35	547400.0
2009-09-08	ABAX-DELISTED	Stock	26.67	27.0199	26.41	26.67	83437.0
2009-09-08	ABB-DELISTED	Stock	19.5	19.54	19.27	19.39	3089889.0
2009-09-08	ABBC-DELISTED	Stock	7.7	7.74	7.52	7.61	46334.0
2009-09-08	ABBNY-DELISTED	Stock	19.47	19.54	19.27	19.39	3090989.0
2009-09-08	ABC-DELISTED	Stock	21.4	21.4	21.02	21.16	1510021.0
2009-09-08	ABCB	Stock	6.3319	6.3416	5.7678	5.7678	83176.0
2009-09-08	ABCO-DELISTED	Stock	13.437	13.698	13.327	13.483	105139.0
2009-09-08	ABCW-DELISTED	Stock	1.3	1.3416	1.3	1.3	39180.0
2009-09-08	ABD-DELISTED	Stock	5.74	5.78	5.48	5.62	202980.0
2009-09-08	ABE-DELISTED	Stock	16.5	17.02	16.5	17.01	17398.0
2009-09-08	ABEO	Stock	4437.5	4562.5	4150.0	4312.5	77.0
2009-09-08	ABFS-DELISTED	Stock	32.77	32.94	31.46	32.07	513593.0
2009-09-08	ABG	Stock	12.8	13.12	12.57	12.77	183200.0
2009-09-08	ABII-DELISTED	Stock	26.32	26.32	25.46	25.53	60727.0
2009-09-08	ABK-DELISTED	Stock	1.71	1.73	1.54	1.59	17055253.0
2009-09-08	ABM	Stock	20.32	20.86	20.07	20.32	389500.0
2009-09-08	ABMD-DELISTED	Stock	7.87	7.87	7.51	7.81	107703.0
2009-09-08	ABR	Stock	1.9	1.95	1.9	1.92	72000.0
2009-09-08	ABT	Stock	21.9125	22.0276	21.711	22.0276	15070446.0
2009-09-08	ABTL-DELISTED	Stock	3.0002	3.0997	2.9498	2.9498	7276.0
2009-09-08	ABV-DELISTED	Stock	75.96	76.12	74.9	75.38	481490.0
2009-09-08	ABVA-DELISTED	Stock	2.9872	2.9872	2.9872	2.9872	100.0
2009-09-08	ABVT-DELISTED	Stock	44.89	45.58	44.4	45.0	73482.0
2009-09-08	ABX-DELISTED	Stock	41.93	42.13	39.11	39.35	19721268.0
2009-09-08	ACAD	Stock	2.01	2.04	1.95	1.97	2462900.0
2009-09-08	ACAP-DELISTED	Stock	31.99	31.99	30.93	31.11	43821.0

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

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