PREVIEW / stock_daily / 2011-08-18

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-18.parquet
  size:    195 KB
  rows:    6,136
  symbols: 3,565

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-08-18	AAPL	Stock	13.2443	13.3089	12.9061	13.0732	851435200.0
2011-08-18	MSFT	Stock	24.57	25.09	24.03	24.67	105714200.0
2011-08-18	NVDA	Stock	0.3058	0.3088	0.295	0.2985	802564000.0
2011-08-18	AMZN	Stock	9.5605	9.567	8.986	9.126	165504000.0
2011-08-18	TSLA	Stock	1.6667	1.6767	1.5647	1.6173	15849000.0
2011-08-18	TLT	Stock	110.09	112.14	109.28	110.31	27274526.0
2011-08-18	ES	Stock	32.61	32.72	32.23	32.6	2244800.0
2011-08-18	CL	Stock	42.49	42.94	41.765	42.52	7562200.0
2011-08-18	A	Stock	24.7425	24.7568	22.8898	23.0544	10285366.0
2011-08-18	AABA-DELISTED	Stock	13.05	13.09	12.8	12.95	30397209.0
2011-08-18	AACC-DELISTED	Stock	4.32	4.32	3.97	4.16	12020.0
2011-08-18	AACG	Stock	8.98	9.0	8.68	8.83	4100.0
2011-08-18	AAIC-DELISTED	Stock	25.35	26.1	24.61	24.94	70515.0
2011-08-18	AAME	Stock	1.89	1.89	1.77	1.81	5600.0
2011-08-18	AAON	Stock	5.3185	5.3511	4.8889	4.8948	711113.0
2011-08-18	AAP	Stock	55.43	57.1	54.97	56.55	2583800.0
2011-08-18	AAT	Stock	19.41	19.51	18.15	18.48	215900.0
2011-08-18	AATI-DELISTED	Stock	5.85	5.87	5.73	5.75	763124.0
2011-08-18	AAU-DELISTED	Stock	3.14	3.185	3.04	3.05	243380.0
2011-08-18	AAUAF-DELISTED	Stock	3.14	3.185	3.04	3.05	243580.0
2011-08-18	AAV-DELISTED	Stock	5.55	5.68	5.43	5.58	984534.0
2011-08-18	AAWW-DELISTED	Stock	42.11	42.44	40.57	40.77	412848.0
2011-08-18	AAXJ	Stock	54.35	54.56	53.2	53.72	675543.0
2011-08-18	AAXN-DELISTED	Stock	3.95	4.05	3.81	3.82	631244.0
2011-08-18	AB	Stock	14.01	14.51	13.69	14.45	550600.0
2011-08-18	ABAC-DELISTED	Stock	2.29	2.51	2.19	2.51	8530.0
2011-08-18	ABAX-DELISTED	Stock	22.9	22.9	22.02	22.23	180350.0
2011-08-18	ABB-DELISTED	Stock	20.38	20.43	19.75	19.95	5203687.0
2011-08-18	ABBC-DELISTED	Stock	8.17	8.17	7.82	7.9	72606.0
2011-08-18	ABBNY-DELISTED	Stock	20.38	20.43	19.75	19.94	5206287.0
2011-08-18	ABC-DELISTED	Stock	37.63	38.13	37.2	37.69	5536730.0
2011-08-18	ABCB	Stock	8.8	9.03	8.65	8.96	143400.0
2011-08-18	ABCD-DELISTED	Stock	2.83	3.12	2.75	2.82	94434.0
2011-08-18	ABCO-DELISTED	Stock	29.07	29.28	28.12	28.51	210912.0
2011-08-18	ABCW-DELISTED	Stock	0.63	0.66	0.61	0.61	36200.0
2011-08-18	ABD-DELISTED	Stock	6.29	6.32	5.8417	5.91	236800.0
2011-08-18	ABE-DELISTED	Stock	17.7	17.7	17.4	17.68	12282.0
2011-08-18	ABFS-DELISTED	Stock	19.89	19.99	18.92	19.07	500609.0
2011-08-18	ABG	Stock	16.91	16.97	16.27	16.49	708000.0
2011-08-18	ABH-DELISTED	Stock	16.45	16.67	16.2	16.43	482619.0
2011-08-18	ABM	Stock	18.67	18.82	18.39	18.66	475400.0
2011-08-18	ABMD-DELISTED	Stock	12.09	12.5	11.7	11.81	360206.0
2011-08-18	ABR	Stock	3.9	3.9	3.65	3.8	131100.0
2011-08-18	ABT	Stock	23.6493	23.8365	23.136	23.4478	20759066.0
2011-08-18	ABTL-DELISTED	Stock	4.2931	4.4429	4.097	4.1569	25372.0
2011-08-18	ABUS	Stock	1.9	2.34	1.9	2.06	10100.0
2011-08-18	ABV-DELISTED	Stock	32.0	32.55	31.73	32.44	4509994.0
2011-08-18	ABVA-DELISTED	Stock	4.67	4.678	4.501	4.678	1174.0
2011-08-18	ABVT-DELISTED	Stock	56.4	56.87	54.94	55.66	387868.0
2011-08-18	ABX-DELISTED	Stock	50.63	50.63	49.64	49.89	10085210.0

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

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