PREVIEW / stock_daily / 2011-05-04

all stock daily files

  file:    by_date/stock_daily/2011/2011-05-04.parquet
  size:    198 KB
  rows:    6,121
  symbols: 3,571

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-04	AAPL	Stock	12.4379	12.5654	12.3886	12.4846	389250400.0
2011-05-04	MSFT	Stock	25.85	26.25	25.79	26.06	73292300.0
2011-05-04	NVDA	Stock	0.4713	0.4765	0.4575	0.4662	639356000.0
2011-05-04	AMZN	Stock	9.9125	10.093	9.7685	9.9985	131000000.0
2011-05-04	TSLA	Stock	1.7853	1.8	1.7167	1.7793	15667500.0
2011-05-04	TLT	Stock	94.31	94.72	94.27	94.59	7419160.0
2011-05-04	ES	Stock	35.68	35.85	35.39	35.73	1442500.0
2011-05-04	CL	Stock	42.28	42.93	42.19	42.825	9848200.0
2011-05-04	A	Stock	36.166	36.2732	35.1502	35.4077	5215239.0
2011-05-04	AABA-DELISTED	Stock	17.97	18.38	17.96	18.18	23270084.0
2011-05-04	AACC-DELISTED	Stock	5.14	5.16	5.1	5.1	25956.0
2011-05-04	AACG	Stock	8.18	8.18	7.84	8.0	2100.0
2011-05-04	AAIC-DELISTED	Stock	29.58	29.77	29.13	29.13	42797.0
2011-05-04	AAME	Stock	2.01	2.07	1.91	2.06	6600.0
2011-05-04	AAON	Stock	6.3723	6.3723	6.1867	6.2222	103275.0
2011-05-04	AAP	Stock	66.05	66.55	65.28	65.76	894700.0
2011-05-04	AAT	Stock	22.05	22.08	21.73	21.93	107000.0
2011-05-04	AATI-DELISTED	Stock	3.95	4.07	3.91	3.95	107097.0
2011-05-04	AAU-DELISTED	Stock	4.2	4.42	4.05	4.28	962570.0
2011-05-04	AAUAF-DELISTED	Stock	4.2	4.42	4.05	4.26	963479.0
2011-05-04	AAV-DELISTED	Stock	8.11	8.11	7.67	7.93	804327.0
2011-05-04	AAWW-DELISTED	Stock	63.98	64.74	62.1	63.17	379172.0
2011-05-04	AAXJ	Stock	63.82	63.83	62.88	63.33	680661.0
2011-05-04	AAXN-DELISTED	Stock	4.35	4.41	4.27	4.34	462624.0
2011-05-04	AB	Stock	21.42	21.89	21.21	21.88	418200.0
2011-05-04	ABAC-DELISTED	Stock	3.183	3.25	3.18	3.2	22575.0
2011-05-04	ABAX-DELISTED	Stock	28.54	28.54	28.2	28.21	49349.0
2011-05-04	ABB-DELISTED	Stock	27.0	27.02	26.41	26.52	4343431.0
2011-05-04	ABBC-DELISTED	Stock	11.99	12.07	11.81	12.06	44597.0
2011-05-04	ABBNY-DELISTED	Stock	27.0	27.02	26.41	26.51	4349131.0
2011-05-04	ABC-DELISTED	Stock	41.1	41.11	40.63	40.74	2697652.0
2011-05-04	ABCB	Stock	9.6	9.62	9.35	9.35	45600.0
2011-05-04	ABCD-DELISTED	Stock	3.27	3.31	3.26	3.26	20058.0
2011-05-04	ABCO-DELISTED	Stock	24.13	24.55	24.01	24.29	122242.0
2011-05-04	ABCW-DELISTED	Stock	0.86	0.86	0.8	0.81	20270.0
2011-05-04	ABD-DELISTED	Stock	9.66	9.66	9.27	9.48	331660.0
2011-05-04	ABE-DELISTED	Stock	19.03	19.29	18.93	18.94	13437.0
2011-05-04	ABEO	Stock	2875.0	2875.0	2687.5	2875.0	13.0
2011-05-04	ABFS-DELISTED	Stock	22.34	22.54	22.17	22.43	302174.0
2011-05-04	ABG	Stock	16.68	16.83	16.45	16.71	283000.0
2011-05-04	ABH-DELISTED	Stock	26.62	26.62	26.01	26.11	263902.0
2011-05-04	ABM	Stock	23.99	24.16	23.7	24.14	471400.0
2011-05-04	ABMD-DELISTED	Stock	16.83	16.95	16.44	16.59	159488.0
2011-05-04	ABR	Stock	5.05	5.14	5.05	5.07	67000.0
2011-05-04	ABT	Stock	25.367	25.4294	25.3238	25.4006	14542935.0
2011-05-04	ABTL-DELISTED	Stock	7.1	7.1	6.5	6.8	33358.0
2011-05-04	ABUS	Stock	3.13	3.13	2.97	3.07	1400.0
2011-05-04	ABV-DELISTED	Stock	31.98	32.11	31.35	31.46	2530464.0
2011-05-04	ABVA-DELISTED	Stock	6.6	6.6	6.25	6.4	3689.0
2011-05-04	ABVT-DELISTED	Stock	66.89	68.23	66.67	68.01	203621.0

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

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