PREVIEW / stock_daily / 2011-04-06

all stock daily files

  file:    by_date/stock_daily/2011/2011-04-06.parquet
  size:    198 KB
  rows:    6,080
  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-06	AAPL	Stock	12.1864	12.2821	12.0407	12.0729	402539200.0
2011-04-06	MSFT	Stock	25.98	26.31	25.86	26.15	65581400.0
2011-04-06	NVDA	Stock	0.4428	0.4432	0.4328	0.4365	856984000.0
2011-04-06	AMZN	Stock	9.3075	9.4135	9.056	9.138	108614000.0
2011-04-06	TSLA	Stock	1.7993	1.8007	1.72	1.766	19324500.0
2011-04-06	TLT	Stock	91.77	91.79	90.54	90.54	9093586.0
2011-04-06	ES	Stock	34.81	35.07	34.74	34.89	675200.0
2011-04-06	CL	Stock	40.5	40.83	40.42	40.765	5786800.0
2011-04-06	A	Stock	32.5536	32.6896	31.9886	32.3963	3287956.0
2011-04-06	AABA-DELISTED	Stock	17.2	17.2	16.94	17.04	13026331.0
2011-04-06	AACC-DELISTED	Stock	5.42	5.42	5.4	5.4125	6059.0
2011-04-06	AACG	Stock	7.83	7.83	7.61	7.78	11400.0
2011-04-06	AAI-DELISTED	Stock	7.42	7.45	7.41	7.44	2228318.0
2011-04-06	AAIC-DELISTED	Stock	30.5	30.5	30.09	30.35	20091.0
2011-04-06	AAON	Stock	6.3783	6.4968	6.3644	6.4948	135675.0
2011-04-06	AAP	Stock	68.12	68.85	67.27	67.59	769300.0
2011-04-06	AAT	Stock	21.77	22.01	21.69	21.95	244900.0
2011-04-06	AATI-DELISTED	Stock	3.82	3.84	3.78	3.8	141641.0
2011-04-06	AAU-DELISTED	Stock	4.84	4.912	4.53	4.75	1183486.0
2011-04-06	AAUAF-DELISTED	Stock	4.84	4.912	4.53	4.75	1185509.0
2011-04-06	AAV-DELISTED	Stock	8.99	9.29	8.99	9.13	782655.0
2011-04-06	AAWW-DELISTED	Stock	68.18	68.28	67.4	67.67	71780.0
2011-04-06	AAXJ	Stock	64.95	65.21	64.63	64.86	2819737.0
2011-04-06	AAXN-DELISTED	Stock	4.1	4.18	4.09	4.09	166551.0
2011-04-06	AB	Stock	22.59	22.66	22.33	22.62	505600.0
2011-04-06	ABAC-DELISTED	Stock	4.05	4.05	3.92	4.0	62837.0
2011-04-06	ABAX-DELISTED	Stock	29.33	30.389	29.33	30.29	100865.0
2011-04-06	ABB-DELISTED	Stock	24.37	24.51	24.26	24.32	2199586.0
2011-04-06	ABBC-DELISTED	Stock	12.51	12.9	12.48	12.76	73834.0
2011-04-06	ABBNY-DELISTED	Stock	24.37	24.51	24.26	24.33	2200386.0
2011-04-06	ABC-DELISTED	Stock	40.75	40.79	40.14	40.58	2596551.0
2011-04-06	ABCB	Stock	10.15	10.15	9.8	10.08	40500.0
2011-04-06	ABCD-DELISTED	Stock	3.39	3.39	3.3	3.35	12458.0
2011-04-06	ABCO-DELISTED	Stock	24.91	25.19	24.52	25.18	87310.0
2011-04-06	ABCW-DELISTED	Stock	0.89	0.93	0.8	0.87	209110.0
2011-04-06	ABD-DELISTED	Stock	10.17	10.36	10.11	10.32	164420.0
2011-04-06	ABE-DELISTED	Stock	19.15	19.16	18.95	19.05	13000.0
2011-04-06	ABEO	Stock	2500.0	2737.5	2500.0	2737.5	1.0
2011-04-06	ABFS-DELISTED	Stock	26.26	26.33	25.83	26.08	505050.0
2011-04-06	ABG	Stock	18.89	18.99	18.4	18.76	212100.0
2011-04-06	ABH-DELISTED	Stock	27.31	28.34	27.31	27.57	667334.0
2011-04-06	ABM	Stock	25.69	25.98	25.58	25.63	185000.0
2011-04-06	ABMD-DELISTED	Stock	15.06	15.64	15.06	15.48	310048.0
2011-04-06	ABR	Stock	5.57	5.6	5.47	5.47	38100.0
2011-04-06	ABT	Stock	24.0092	24.3403	24.0044	24.3163	16846394.0
2011-04-06	ABTL-DELISTED	Stock	7.36	7.36	6.8489	6.9	48387.0
2011-04-06	ABUS	Stock	3.21	3.21	3.06	3.1	5800.0
2011-04-06	ABV-DELISTED	Stock	29.44	29.48	29.06	29.17	1692926.0
2011-04-06	ABVA-DELISTED	Stock	5.21	5.26	5.1	5.15	3450.0
2011-04-06	ABVT-DELISTED	Stock	66.58	67.25	66.28	66.72	35821.0

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

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