PREVIEW / stock_daily / 2011-10-05

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-05.parquet
  size:    193 KB
  rows:    6,084
  symbols: 3,531

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-10-05	AAPL	Stock	13.1379	13.565	12.8679	13.5089	786469600.0
2011-10-05	MSFT	Stock	25.42	26.16	25.16	25.89	94061300.0
2011-10-05	NVDA	Stock	0.3218	0.337	0.3153	0.334	856708000.0
2011-10-05	AMZN	Stock	10.6265	11.0085	10.424	10.975	130164000.0
2011-10-05	TSLA	Stock	1.602	1.7227	1.5567	1.6913	18442500.0
2011-10-05	TLT	Stock	121.66	121.78	120.66	121.36	14275349.0
2011-10-05	ES	Stock	31.4	31.4	30.98	31.09	5022700.0
2011-10-05	CL	Stock	44.195	44.815	43.785	44.75	6267800.0
2011-10-05	A	Stock	22.2675	23.0114	21.9599	22.9757	6863481.0
2011-10-05	AABA-DELISTED	Stock	14.66	16.15	14.39	15.98	94310246.0
2011-10-05	AACC-DELISTED	Stock	3.05	3.1	3.01	3.06	165688.0
2011-10-05	AACG	Stock	8.93	9.0	8.93	8.96	1200.0
2011-10-05	AAIC-DELISTED	Stock	24.66	24.97	24.13	24.78	40247.0
2011-10-05	AAME	Stock	1.83	1.89	1.56	1.8	9300.0
2011-10-05	AAON	Stock	4.9511	5.1081	4.4089	4.9837	236925.0
2011-10-05	AAP	Stock	58.44	58.94	57.5	58.62	704700.0
2011-10-05	AAT	Stock	18.07	18.07	17.09	17.67	512200.0
2011-10-05	AATI-DELISTED	Stock	4.33	4.41	4.27	4.39	219504.0
2011-10-05	AAU-DELISTED	Stock	2.22	2.59	2.22	2.46	209706.0
2011-10-05	AAUAF-DELISTED	Stock	2.29	2.59	2.29	2.49	209106.0
2011-10-05	AAV-DELISTED	Stock	4.03	4.111	3.89	4.09	518930.0
2011-10-05	AAWW-DELISTED	Stock	31.49	33.3997	30.74	32.95	289705.0
2011-10-05	AAXJ	Stock	45.9399	47.18	45.5	47.02	507915.0
2011-10-05	AAXN-DELISTED	Stock	4.27	4.33	4.19	4.19	417469.0
2011-10-05	AB	Stock	13.88	14.09	13.43	13.98	247700.0
2011-10-05	ABAC-DELISTED	Stock	1.46	1.74	1.42	1.6	21101.0
2011-10-05	ABAX-DELISTED	Stock	22.9	23.75	22.7	23.56	77693.0
2011-10-05	ABB-DELISTED	Stock	16.79	17.15	16.62	17.07	4942253.0
2011-10-05	ABBNY-DELISTED	Stock	16.79	17.15	16.62	17.06	4970896.0
2011-10-05	ABC-DELISTED	Stock	35.92	36.91	35.81	36.39	4126248.0
2011-10-05	ABCB	Stock	9.37	9.37	9.03	9.28	87300.0
2011-10-05	ABCD-DELISTED	Stock	2.97	3.05	2.9	2.97	35583.0
2011-10-05	ABCO-DELISTED	Stock	30.82	30.85	29.78	30.22	251578.0
2011-10-05	ABCW-DELISTED	Stock	0.5	0.5	0.48	0.49	3620.0
2011-10-05	ABD-DELISTED	Stock	4.96	4.98	4.7	4.89	227710.0
2011-10-05	ABE-DELISTED	Stock	16.4	16.83	16.4	16.8	11299.0
2011-10-05	ABEO	Stock	2200.0	2350.0	2062.5	2325.0	21.0
2011-10-05	ABFS-DELISTED	Stock	16.15	16.47	15.52	16.1822	510608.0
2011-10-05	ABG	Stock	17.54	18.05	17.02	17.73	395000.0
2011-10-05	ABH-DELISTED	Stock	14.2	15.03	13.88	14.99	331211.0
2011-10-05	ABM	Stock	18.99	19.58	18.66	19.27	392000.0
2011-10-05	ABMD-DELISTED	Stock	11.25	11.8	11.02	11.67	150828.0
2011-10-05	ABR	Stock	3.41	3.42	3.25	3.33	89800.0
2011-10-05	ABT	Stock	24.3019	24.5562	24.062	24.5226	15107753.0
2011-10-05	ABTL-DELISTED	Stock	3.9452	4.0094	3.8089	3.9548	6474.0
2011-10-05	ABUS	Stock	1.61	1.84	1.6	1.83	9600.0
2011-10-05	ABV-DELISTED	Stock	30.53	31.485	30.35	31.37	3951569.0
2011-10-05	ABVA-DELISTED	Stock	4.87	4.9	4.8	4.9	3600.0
2011-10-05	ABVT-DELISTED	Stock	55.28	56.6	54.35	55.97	151329.0
2011-10-05	ABX-DELISTED	Stock	44.2	46.4	44.15	46.3	8329780.0

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

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