PREVIEW / stock_daily / 2011-11-18

all stock daily files

  file:    by_date/stock_daily/2011/2011-11-18.parquet
  size:    195 KB
  rows:    6,098
  symbols: 3,529

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-11-18	AAPL	Stock	13.5329	13.5711	13.3886	13.3907	371938000.0
2011-11-18	MSFT	Stock	25.48	25.5	25.15	25.3	47626200.0
2011-11-18	NVDA	Stock	0.3535	0.3535	0.3445	0.3482	501352000.0
2011-11-18	AMZN	Stock	10.2665	10.267	9.8555	9.857	168750000.0
2011-11-18	TSLA	Stock	2.2427	2.274	2.1693	2.1733	13542000.0
2011-11-18	TLT	Stock	119.1801	119.55	118.32	119.36	6794440.0
2011-11-18	ES	Stock	34.19	34.59	34.15	34.5	2528000.0
2011-11-18	CL	Stock	44.23	44.55	44.08	44.305	3874000.0
2011-11-18	A	Stock	26.824	26.824	26.1874	26.3305	5323444.0
2011-11-18	AABA-DELISTED	Stock	15.56	15.69	15.365	15.38	16665761.0
2011-11-18	AACC-DELISTED	Stock	2.95	3.06	2.85	3.0	50392.0
2011-11-18	AACG	Stock	9.7	9.71	9.7	9.7	2900.0
2011-11-18	AAIC-DELISTED	Stock	21.51	21.65	21.25	21.33	42986.0
2011-11-18	AAME	Stock	1.86	1.9	1.85	1.88	3000.0
2011-11-18	AAON	Stock	6.2815	6.3319	6.2074	6.2578	191363.0
2011-11-18	AAP	Stock	67.85	68.52	67.38	67.95	570900.0
2011-11-18	AAT	Stock	20.51	21.04	20.39	20.77	366700.0
2011-11-18	AATI-DELISTED	Stock	4.22	4.25	4.18	4.21	412590.0
2011-11-18	AAU-DELISTED	Stock	2.65	2.69	2.53	2.57	221396.0
2011-11-18	AAUAF-DELISTED	Stock	2.65	2.69	2.53	2.57	221696.0
2011-11-18	AAV-DELISTED	Stock	5.07	5.17	5.04	5.15	239033.0
2011-11-18	AAWW-DELISTED	Stock	39.57	39.97	38.75	39.2	212771.0
2011-11-18	AAXJ	Stock	51.07	51.21	50.58	50.84	222629.0
2011-11-18	AAXN-DELISTED	Stock	5.78	5.89	5.72	5.86	491501.0
2011-11-18	AB	Stock	13.25	13.66	13.2	13.36	367400.0
2011-11-18	ABAC-DELISTED	Stock	1.9	1.9499	1.75	1.9499	38714.0
2011-11-18	ABAX-DELISTED	Stock	26.54	26.61	26.12	26.46	66780.0
2011-11-18	ABB-DELISTED	Stock	17.95	17.995	17.69	17.75	1709913.0
2011-11-18	ABBNY-DELISTED	Stock	17.95	17.995	17.69	17.76	1711454.0
2011-11-18	ABC-DELISTED	Stock	37.78	37.84	37.25	37.29	1979156.0
2011-11-18	ABCB	Stock	10.03	10.1	9.98	9.99	86600.0
2011-11-18	ABCD-DELISTED	Stock	2.99	3.22	2.93	3.02	24492.0
2011-11-18	ABCO-DELISTED	Stock	34.63	34.72	34.09	34.38	76280.0
2011-11-18	ABCW-DELISTED	Stock	0.4752	0.4752	0.2179	0.22	341200.0
2011-11-18	ABD-DELISTED	Stock	8.955	9.225	8.785	8.965	1309850.0
2011-11-18	ABE-DELISTED	Stock	17.92	18.11	17.7195	17.95	2725.0
2011-11-18	ABEO	Stock	1675.0	1687.5	1625.0	1650.0	24.0
2011-11-18	ABFS-DELISTED	Stock	18.96	19.42	18.6	19.34	534548.0
2011-11-18	ABG	Stock	18.81	19.15	18.56	19.05	337300.0
2011-11-18	ABH-DELISTED	Stock	15.52	16.55	15.52	16.53	656295.0
2011-11-18	ABM	Stock	20.34	20.5	20.2	20.4	299400.0
2011-11-18	ABMD-DELISTED	Stock	18.76	18.99	18.31	18.4	181892.0
2011-11-18	ABR	Stock	3.6	3.65	3.58	3.6	21100.0
2011-11-18	ABT	Stock	25.7173	25.8708	25.6261	25.6789	12601917.0
2011-11-18	ABTL-DELISTED	Stock	3.9	4.0	3.7555	4.0	3016.0
2011-11-18	ABUS	Stock	1.6	1.68	1.48	1.6	19900.0
2011-11-18	ABV-DELISTED	Stock	33.18	33.24	32.64	32.81	2131126.0
2011-11-18	ABVA-DELISTED	Stock	5.14	5.19	5.14	5.16	13413.0
2011-11-18	ABVT-DELISTED	Stock	57.81	58.03	56.53	57.44	95818.0
2011-11-18	ABX-DELISTED	Stock	49.48	50.21	48.71	48.85	6100171.0

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

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