PREVIEW / stock_daily / 2011-04-21

all stock daily files

  file:    by_date/stock_daily/2011/2011-04-21.parquet
  size:    198 KB
  rows:    6,118
  symbols: 3,558

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-04-21	AAPL	Stock	12.6786	12.6832	12.4471	12.525	753810400.0
2011-04-21	MSFT	Stock	25.79	25.89	25.36	25.52	46892300.0
2011-04-21	NVDA	Stock	0.4692	0.4723	0.462	0.463	421300000.0
2011-04-21	AMZN	Stock	9.228	9.2985	9.1525	9.2945	66962000.0
2011-04-21	TSLA	Stock	1.7233	1.7987	1.706	1.7827	20791500.0
2011-04-21	TLT	Stock	92.89	93.23	92.56	92.6	3372139.0
2011-04-21	ES	Stock	34.25	34.43	34.13	34.37	1171300.0
2011-04-21	CL	Stock	40.415	40.595	40.205	40.325	4190200.0
2011-04-21	A	Stock	35.0	35.3362	34.8927	35.2933	4284171.0
2011-04-21	AABA-DELISTED	Stock	16.92	16.94	16.74	16.85	13096444.0
2011-04-21	AACC-DELISTED	Stock	5.5	5.5	5.45	5.48	6850.0
2011-04-21	AACG	Stock	7.0	7.11	6.8	7.06	36300.0
2011-04-21	AAI-DELISTED	Stock	7.4	7.43	7.33	7.34	8950730.0
2011-04-21	AAIC-DELISTED	Stock	29.95	30.5166	29.64	29.94	68372.0
2011-04-21	AAME	Stock	2.05	2.06	2.05	2.06	200.0
2011-04-21	AAON	Stock	6.5185	6.5264	6.4869	6.5185	224775.0
2011-04-21	AAP	Stock	66.34	66.5	65.83	66.42	319500.0
2011-04-21	AAT	Stock	21.75	21.75	21.31	21.68	128500.0
2011-04-21	AATI-DELISTED	Stock	4.23	4.23	4.11	4.15	59313.0
2011-04-21	AAU-DELISTED	Stock	4.64	4.68	4.43	4.49	378812.0
2011-04-21	AAUAF-DELISTED	Stock	4.64	4.68	4.43	4.51	379212.0
2011-04-21	AAV-DELISTED	Stock	8.56	8.6	8.44	8.55	227037.0
2011-04-21	AAWW-DELISTED	Stock	62.71	65.17	62.0	64.65	167208.0
2011-04-21	AAXJ	Stock	64.77	65.07	64.72	65.05	119034.0
2011-04-21	AAXN-DELISTED	Stock	4.14	4.24	3.94	3.96	897195.0
2011-04-21	AB	Stock	21.62	21.75	21.47	21.62	235700.0
2011-04-21	ABAC-DELISTED	Stock	3.4	3.4199	3.31	3.38	37204.0
2011-04-21	ABAX-DELISTED	Stock	29.1	29.19	28.77	28.99	51535.0
2011-04-21	ABB-DELISTED	Stock	25.37	25.39	25.15	25.35	2596164.0
2011-04-21	ABBC-DELISTED	Stock	12.14	12.14	11.85	11.95	14974.0
2011-04-21	ABBNY-DELISTED	Stock	25.37	25.39	25.15	25.34	2596929.0
2011-04-21	ABC-DELISTED	Stock	40.55	40.6	40.27	40.56	1401243.0
2011-04-21	ABCB	Stock	9.65	9.65	9.27	9.58	100400.0
2011-04-21	ABCD-DELISTED	Stock	3.36	3.37	3.3499	3.37	18833.0
2011-04-21	ABCO-DELISTED	Stock	23.84	24.55	23.38	23.5	66097.0
2011-04-21	ABCW-DELISTED	Stock	0.87	0.91	0.87	0.87	11370.0
2011-04-21	ABD-DELISTED	Stock	10.0	10.0	9.71	9.9	105180.0
2011-04-21	ABE-DELISTED	Stock	19.1	19.2	19.1	19.2	7049.0
2011-04-21	ABEO	Stock	2687.5	2875.0	2687.5	2875.0	4.0
2011-04-21	ABFS-DELISTED	Stock	25.68	25.72	25.1701	25.36	415400.0
2011-04-21	ABG	Stock	17.15	17.67	17.07	17.6	290200.0
2011-04-21	ABH-DELISTED	Stock	25.95	26.13	25.64	25.99	131809.0
2011-04-21	ABM	Stock	24.44	24.44	24.08	24.12	140000.0
2011-04-21	ABMD-DELISTED	Stock	16.79	16.79	16.39	16.57	252787.0
2011-04-21	ABR	Stock	5.17	5.17	5.08	5.12	44100.0
2011-04-21	ABT	Stock	24.3355	25.4102	24.2971	24.8536	38577949.0
2011-04-21	ABTL-DELISTED	Stock	6.875	6.9252	6.0721	6.875	52027.0
2011-04-21	ABUS	Stock	2.71	2.99	2.71	2.9	39000.0
2011-04-21	ABV-DELISTED	Stock	31.34	31.79	31.22	31.77	1284225.0
2011-04-21	ABVA-DELISTED	Stock	6.449	6.5999	6.39	6.46	15602.0

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

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