PREVIEW / stock_daily / 2012-05-21

all stock daily files

  file:    by_date/stock_daily/2012/2012-05-21.parquet
  size:    199 KB
  rows:    6,173
  symbols: 3,535

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
2012-05-21	AAPL	Stock	19.0893	20.055	19.0732	20.0457	631106000.0
2012-05-21	MSFT	Stock	29.1	29.79	29.06	29.75	38787900.0
2012-05-21	NVDA	Stock	0.3025	0.3088	0.3005	0.3073	416260000.0
2012-05-21	AMZN	Stock	10.7015	10.999	10.641	10.9055	71596000.0
2012-05-21	META	Stock	36.53	36.66	33.0	34.03	168192700.0
2012-05-21	TSLA	Stock	1.8387	1.9507	1.808	1.918	22128000.0
2012-05-21	TLT	Stock	123.9	124.45	123.62	123.94	9585766.0
2012-05-21	ES	Stock	34.96	35.77	34.96	35.73	2405000.0
2012-05-21	CL	Stock	49.5	49.515	49.0	49.48	4970000.0
2012-05-21	A	Stock	27.7754	28.6981	27.7539	28.6052	3890215.0
2012-05-21	AABA-DELISTED	Stock	16.0	16.0	15.1	15.57	50879732.0
2012-05-21	AACC-DELISTED	Stock	5.55	5.6599	5.55	5.6299	8657.0
2012-05-21	AACG	Stock	6.81	6.81	6.81	6.81	700.0
2012-05-21	AAIC-DELISTED	Stock	22.52	22.86	22.43	22.81	53753.0
2012-05-21	AAME	Stock	2.75	2.85	2.75	2.85	800.0
2012-05-21	AAMRQ-DELISTED	Stock	0.48	0.487	0.451	0.466	1841950.0
2012-05-21	AAON	Stock	5.6681	5.7452	5.5822	5.7304	313200.0
2012-05-21	AAP	Stock	66.92	70.34	66.03	69.82	3489000.0
2012-05-21	AAT	Stock	22.7	22.99	22.55	22.9	262800.0
2012-05-21	AAU-DELISTED	Stock	1.92	2.28	1.9	2.07	118266.0
2012-05-21	AAUAF-DELISTED	Stock	1.92	2.28	1.9	2.07	120166.0
2012-05-21	AAV-DELISTED	Stock	2.86	2.99	2.86	2.95	116439.0
2012-05-21	AAWW-DELISTED	Stock	45.79	47.5	45.29	47.38	214571.0
2012-05-21	AAXJ	Stock	50.63	51.38	50.6	51.27	649032.0
2012-05-21	AAXN-DELISTED	Stock	5.15	5.39	5.09	5.32	650405.0
2012-05-21	AB	Stock	13.78	13.94	13.58	13.78	102500.0
2012-05-21	ABAC-DELISTED	Stock	1.45	1.47	1.26	1.31	36289.0
2012-05-21	ABAX-DELISTED	Stock	32.84	33.29	32.14	33.11	143410.0
2012-05-21	ABB-DELISTED	Stock	16.24	16.46	16.16	16.45	2249821.0
2012-05-21	ABBNY-DELISTED	Stock	16.26	16.47	16.16	16.47	2250795.0
2012-05-21	ABC-DELISTED	Stock	35.98	36.42	35.975	36.085	1929537.0
2012-05-21	ABCB	Stock	11.64	11.81	11.49	11.69	49000.0
2012-05-21	ABCD-DELISTED	Stock	1.25	1.37	1.21	1.32	27199.0
2012-05-21	ABCO-DELISTED	Stock	47.22	48.01	46.73	47.86	237697.0
2012-05-21	ABCW-DELISTED	Stock	0.4217	0.5422	0.4217	0.5422	7450.0
2012-05-21	ABE-DELISTED	Stock	18.13	18.176	17.95	18.176	4580.0
2012-05-21	ABEO	Stock	675.0	675.0	625.0	675.0	23.0
2012-05-21	ABFS-DELISTED	Stock	12.53	12.9	12.34	12.87	297568.0
2012-05-21	ABG	Stock	25.56	26.49	25.38	26.4	246700.0
2012-05-21	ABH-DELISTED	Stock	10.35	10.615	10.25	10.535	110464.0
2012-05-21	ABM	Stock	21.63	21.98	21.36	21.67	285400.0
2012-05-21	ABMD-DELISTED	Stock	23.03	24.5	23.03	24.29	612186.0
2012-05-21	ABR	Stock	5.88	6.05	5.69	6.0	65000.0
2012-05-21	ABT	Stock	29.5557	29.8196	29.5557	29.6564	12592330.0
2012-05-21	ABTL-DELISTED	Stock	3.8514	3.9048	3.647	3.8	11515.0
2012-05-21	ABUS	Stock	2.13	2.13	2.02	2.13	1200.0
2012-05-21	ABV-DELISTED	Stock	37.84	38.232	37.33	37.58	3122509.0
2012-05-21	ABVA-DELISTED	Stock	4.15	4.15	3.76	4.1	22300.0
2012-05-21	ABVT-DELISTED	Stock	83.11	83.33	83.1	83.25	265830.0
2012-05-21	ABX-DELISTED	Stock	37.14	38.3	37.03	38.17	4879743.0

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

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