PREVIEW / stock_daily / 2011-09-19

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-19.parquet
  size:    194 KB
  rows:    6,075
  symbols: 3,524

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
2011-09-19	AAPL	Stock	14.1786	14.7582	14.1143	14.7011	823860800.0
2011-09-19	MSFT	Stock	26.8	27.31	26.6	27.21	52324900.0
2011-09-19	NVDA	Stock	0.38	0.3828	0.3688	0.3785	968204000.0
2011-09-19	AMZN	Stock	11.8555	12.2	11.644	12.0845	164466000.0
2011-09-19	TSLA	Stock	1.6633	1.7207	1.588	1.718	17361000.0
2011-09-19	TLT	Stock	114.2	115.19	114.12	114.38	13033666.0
2011-09-19	ES	Stock	34.05	34.66	33.94	34.52	1557800.0
2011-09-19	CL	Stock	46.265	46.775	46.145	46.66	5026000.0
2011-09-19	A	Stock	25.329	25.329	24.2632	25.0072	8326907.0
2011-09-19	AABA-DELISTED	Stock	14.76	14.79	14.4	14.6	26902725.0
2011-09-19	AACC-DELISTED	Stock	3.9	4.03	3.8	3.89	4799.0
2011-09-19	AACG	Stock	9.48	10.0	9.36	9.91	37600.0
2011-09-19	AAIC-DELISTED	Stock	25.19	26.64	25.05	26.0	82037.0
2011-09-19	AAME	Stock	1.99	1.99	1.82	1.98	2700.0
2011-09-19	AAON	Stock	5.0696	5.0696	4.8296	4.9363	133650.0
2011-09-19	AAP	Stock	61.79	63.0	61.79	62.76	1104300.0
2011-09-19	AAT	Stock	19.1	19.3	18.91	18.92	119400.0
2011-09-19	AATI-DELISTED	Stock	4.17	4.25	3.66	3.98	4302207.0
2011-09-19	AAU-DELISTED	Stock	3.62	3.65	3.42	3.45	194359.0
2011-09-19	AAUAF-DELISTED	Stock	3.62	3.65	3.42	3.45	196459.0
2011-09-19	AAV-DELISTED	Stock	5.14	5.23	5.08	5.14	188892.0
2011-09-19	AAWW-DELISTED	Stock	46.0	46.3	44.92	45.8	145923.0
2011-09-19	AAXJ	Stock	51.91	52.28	51.51	52.07	167207.0
2011-09-19	AAXN-DELISTED	Stock	4.45	4.58	4.3831	4.51	231242.0
2011-09-19	AB	Stock	15.5	15.67	15.22	15.42	224700.0
2011-09-19	ABAC-DELISTED	Stock	2.02	2.025	1.8799	1.99	56359.0
2011-09-19	ABAX-DELISTED	Stock	24.96	25.27	24.59	25.07	127506.0
2011-09-19	ABB-DELISTED	Stock	18.07	18.33	17.88	18.19	2245644.0
2011-09-19	ABBC-DELISTED	Stock	8.23	8.24	7.95	8.07	23127.0
2011-09-19	ABBNY-DELISTED	Stock	18.07	18.33	17.88	18.21	2246644.0
2011-09-19	ABC-DELISTED	Stock	38.75	39.581	38.74	39.39	2447188.0
2011-09-19	ABCB	Stock	9.12	9.12	8.91	8.93	26500.0
2011-09-19	ABCD-DELISTED	Stock	3.0	3.08	3.0	3.01	72700.0
2011-09-19	ABCO-DELISTED	Stock	30.45	31.18	30.11	30.93	99640.0
2011-09-19	ABCW-DELISTED	Stock	0.55	0.61	0.55	0.55	23750.0
2011-09-19	ABD-DELISTED	Stock	5.79	5.95	5.7	5.85	233090.0
2011-09-19	ABE-DELISTED	Stock	17.78	17.78	17.46	17.57	2101.0
2011-09-19	ABEO	Stock	2312.5	2625.0	2312.5	2562.5	11.0
2011-09-19	ABFS-DELISTED	Stock	20.7	20.7	19.83	20.28	410919.0
2011-09-19	ABG	Stock	18.41	18.61	17.84	18.37	492200.0
2011-09-19	ABH-DELISTED	Stock	15.74	16.19	15.69	15.92	330547.0
2011-09-19	ABM	Stock	18.95	19.01	18.39	18.66	271000.0
2011-09-19	ABMD-DELISTED	Stock	11.84	12.09	11.56	11.59	114800.0
2011-09-19	ABR	Stock	3.96	4.05	3.9	4.0	27300.0
2011-09-19	ABT	Stock	24.6665	25.0168	24.6137	24.9448	14116924.0
2011-09-19	ABTL-DELISTED	Stock	4.355	4.4944	4.2951	4.395	8990.0
2011-09-19	ABUS	Stock	1.87	2.08	1.87	2.08	1000.0
2011-09-19	ABV-DELISTED	Stock	31.9	32.41	31.59	32.26	2885563.0
2011-09-19	ABVA-DELISTED	Stock	5.0	5.1	5.0	5.1	3341.0
2011-09-19	ABVT-DELISTED	Stock	55.92	56.43	55.17	55.8	68726.0

> showing 50 of 6,075 rows — these rows as CSV

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