PREVIEW / stock_daily / 2011-05-18

all stock daily files

  file:    by_date/stock_daily/2011/2011-05-18.parquet
  size:    199 KB
  rows:    6,121
  symbols: 3,578

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-05-18	AAPL	Stock	12.0168	12.1804	12.0	12.1382	334776400.0
2011-05-18	MSFT	Stock	24.53	24.74	24.25	24.69	53931100.0
2011-05-18	NVDA	Stock	0.4425	0.4548	0.441	0.451	658844000.0
2011-05-18	AMZN	Stock	9.7065	9.914	9.6625	9.8545	99116000.0
2011-05-18	TSLA	Stock	1.74	1.7647	1.7013	1.7567	10942500.0
2011-05-18	TLT	Stock	96.27	96.39	95.28	95.31	7707846.0
2011-05-18	ES	Stock	36.27	36.33	35.92	36.31	1276700.0
2011-05-18	CL	Stock	43.15	43.215	42.77	43.105	4759000.0
2011-05-18	A	Stock	36.5737	37.0815	36.4807	37.0029	5553695.0
2011-05-18	AABA-DELISTED	Stock	16.07	16.16	15.75	15.95	24471242.0
2011-05-18	AACC-DELISTED	Stock	4.48	4.58	4.34	4.54	35709.0
2011-05-18	AACG	Stock	10.51	10.94	10.05	10.32	42200.0
2011-05-18	AAIC-DELISTED	Stock	26.69	28.28	26.69	27.35	96419.0
2011-05-18	AAME	Stock	2.04	2.05	2.04	2.05	200.0
2011-05-18	AAON	Stock	6.5027	6.5027	6.4494	6.4711	102769.0
2011-05-18	AAP	Stock	69.8	70.66	68.95	70.66	1473900.0
2011-05-18	AAT	Stock	21.69	21.94	21.6	21.88	100600.0
2011-05-18	AATI-DELISTED	Stock	3.66	3.94	3.66	3.8	204161.0
2011-05-18	AAU-DELISTED	Stock	3.53	3.72	3.48	3.66	535679.0
2011-05-18	AAUAF-DELISTED	Stock	3.53	3.72	3.48	3.66	536879.0
2011-05-18	AAV-DELISTED	Stock	7.86	8.08	7.8401	7.99	253289.0
2011-05-18	AAWW-DELISTED	Stock	61.5	62.51	60.77	62.42	345719.0
2011-05-18	AAXJ	Stock	62.65	63.43	62.59	63.35	620773.0
2011-05-18	AAXN-DELISTED	Stock	4.4	4.55	4.38	4.54	382715.0
2011-05-18	AB	Stock	21.4	21.47	21.28	21.37	478400.0
2011-05-18	ABAC-DELISTED	Stock	2.98	3.04	2.87	2.8792	31384.0
2011-05-18	ABAX-DELISTED	Stock	27.73	28.46	27.73	28.46	78134.0
2011-05-18	ABB-DELISTED	Stock	26.06	26.47	26.005	26.33	5166879.0
2011-05-18	ABBC-DELISTED	Stock	11.39	11.44	11.22	11.43	58721.0
2011-05-18	ABBNY-DELISTED	Stock	26.06	26.47	26.005	26.32	5590634.0
2011-05-18	ABC-DELISTED	Stock	42.01	42.01	41.7	41.83	2794516.0
2011-05-18	ABCB	Stock	8.91	9.1	8.9	9.05	150200.0
2011-05-18	ABCD-DELISTED	Stock	2.99	3.11	2.95	3.06	48716.0
2011-05-18	ABCO-DELISTED	Stock	25.12	25.49	25.09	25.33	76085.0
2011-05-18	ABCW-DELISTED	Stock	0.81	0.85	0.77	0.77	31680.0
2011-05-18	ABD-DELISTED	Stock	8.97	9.05	8.8	8.86	345810.0
2011-05-18	ABE-DELISTED	Stock	18.66	18.774	18.61	18.74	16518.0
2011-05-18	ABEO	Stock	2687.5	2812.5	2687.5	2812.5	2.0
2011-05-18	ABFS-DELISTED	Stock	23.84	24.27	23.53	24.21	377796.0
2011-05-18	ABG	Stock	16.23	16.64	16.08	16.59	452900.0
2011-05-18	ABH-DELISTED	Stock	24.29	24.97	24.23	24.44	1633771.0
2011-05-18	ABM	Stock	23.62	23.79	23.53	23.75	157100.0
2011-05-18	ABMD-DELISTED	Stock	18.22	18.49	17.42	17.65	731850.0
2011-05-18	ABR	Stock	5.0	5.09	4.93	4.98	80700.0
2011-05-18	ABT	Stock	25.7365	25.8852	25.6885	25.8228	14587953.0
2011-05-18	ABTL-DELISTED	Stock	5.65	6.0063	5.5991	5.65	62256.0
2011-05-18	ABUS	Stock	2.82	2.9	2.75	2.76	12600.0
2011-05-18	ABV-DELISTED	Stock	31.62	31.89	31.26	31.46	2426059.0
2011-05-18	ABVA-DELISTED	Stock	6.32	6.32	6.1	6.1	14096.0
2011-05-18	ABVT-DELISTED	Stock	64.35	64.62	63.88	64.08	95853.0

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

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