PREVIEW / stock_daily / 2011-04-12

all stock daily files

  file:    by_date/stock_daily/2011/2011-04-12.parquet
  size:    198 KB
  rows:    6,091
  symbols: 3,556

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-12	AAPL	Stock	11.8032	11.9189	11.7929	11.8714	425639200.0
2011-04-12	MSFT	Stock	25.83	25.85	25.55	25.64	36920400.0
2011-04-12	NVDA	Stock	0.4288	0.4372	0.4208	0.4342	840756000.0
2011-04-12	AMZN	Stock	9.153	9.2295	8.971	9.024	106690000.0
2011-04-12	TSLA	Stock	1.672	1.6807	1.62	1.6433	20361000.0
2011-04-12	TLT	Stock	90.61	91.24	90.56	90.93	7686439.0
2011-04-12	ES	Stock	34.1	34.28	34.02	34.07	1711300.0
2011-04-12	CL	Stock	40.81	41.86	40.71	41.27	9322800.0
2011-04-12	A	Stock	32.0029	32.475	31.6738	32.1459	3874697.0
2011-04-12	AABA-DELISTED	Stock	16.52	16.64	16.29	16.36	19789665.0
2011-04-12	AACC-DELISTED	Stock	5.2	5.21	5.2	5.2	5940.0
2011-04-12	AACG	Stock	7.85	7.86	7.85	7.85	6100.0
2011-04-12	AAI-DELISTED	Stock	7.38	7.41	7.36	7.39	2574256.0
2011-04-12	AAIC-DELISTED	Stock	29.19	29.29	28.15	28.29	46362.0
2011-04-12	AAME	Stock	2.1	2.11	2.08	2.1	5500.0
2011-04-12	AAON	Stock	6.2736	6.3881	6.244	6.2637	112387.0
2011-04-12	AAP	Stock	65.33	66.0	65.27	65.64	754900.0
2011-04-12	AAT	Stock	21.17	21.32	21.14	21.23	263700.0
2011-04-12	AATI-DELISTED	Stock	3.97	4.12	3.84	3.96	190855.0
2011-04-12	AAU-DELISTED	Stock	4.38	4.5302	4.11	4.52	551646.0
2011-04-12	AAUAF-DELISTED	Stock	4.37	4.53	4.1	4.53	553709.0
2011-04-12	AAV-DELISTED	Stock	8.53	8.58	8.13	8.33	734452.0
2011-04-12	AAWW-DELISTED	Stock	64.23	64.73	63.3721	64.23	380597.0
2011-04-12	AAXJ	Stock	63.35	63.5	62.88	63.06	278363.0
2011-04-12	AAXN-DELISTED	Stock	3.87	3.92	3.8	3.84	384377.0
2011-04-12	AB	Stock	21.77	21.8	21.4	21.65	994200.0
2011-04-12	ABAC-DELISTED	Stock	3.78	3.8	3.61	3.62	65708.0
2011-04-12	ABAX-DELISTED	Stock	28.95	29.5	28.75	28.95	125248.0
2011-04-12	ABB-DELISTED	Stock	24.31	24.35	24.07	24.17	1992621.0
2011-04-12	ABBC-DELISTED	Stock	12.17	12.42	12.17	12.25	31645.0
2011-04-12	ABBNY-DELISTED	Stock	24.3	24.35	24.07	24.18	1998646.0
2011-04-12	ABC-DELISTED	Stock	39.95	40.19	39.47	39.6	2775620.0
2011-04-12	ABCB	Stock	9.72	9.89	9.66	9.66	26600.0
2011-04-12	ABCD-DELISTED	Stock	3.3	3.45	3.3	3.35	23214.0
2011-04-12	ABCO-DELISTED	Stock	24.25	24.66	24.12	24.36	96145.0
2011-04-12	ABCW-DELISTED	Stock	0.88	0.88	0.85	0.85	41710.0
2011-04-12	ABD-DELISTED	Stock	9.375	9.595	9.335	9.485	181680.0
2011-04-12	ABE-DELISTED	Stock	18.97	18.97	18.37	18.61	45159.0
2011-04-12	ABEO	Stock	2562.5	2750.0	2562.5	2687.5	13.0
2011-04-12	ABFS-DELISTED	Stock	24.86	25.27	24.82	24.94	175683.0
2011-04-12	ABG	Stock	17.89	18.26	17.55	17.56	299500.0
2011-04-12	ABH-DELISTED	Stock	26.41	26.62	25.71	25.87	280357.0
2011-04-12	ABM	Stock	24.58	24.76	24.21	24.22	171200.0
2011-04-12	ABMD-DELISTED	Stock	15.94	16.3	15.671	16.03	936061.0
2011-04-12	ABR	Stock	5.42	5.46	5.33	5.33	68800.0
2011-04-12	ABT	Stock	24.3834	24.6857	24.2779	24.4842	21058358.0
2011-04-12	ABTL-DELISTED	Stock	6.55	6.5505	6.1	6.3	72198.0
2011-04-12	ABUS	Stock	3.03	3.05	3.0	3.0	6000.0
2011-04-12	ABV-DELISTED	Stock	29.07	29.2	28.73	28.88	1574619.0
2011-04-12	ABVA-DELISTED	Stock	5.28	5.5	5.28	5.4	1200.0

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

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