PREVIEW / stock_daily / 2012-06-18

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-18.parquet
  size:    199 KB
  rows:    6,168
  symbols: 3,526

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-06-18	AAPL	Stock	20.3914	20.9961	20.3704	20.9207	440412000.0
2012-06-18	MSFT	Stock	29.99	30.03	29.71	29.84	58679900.0
2012-06-18	NVDA	Stock	0.305	0.3125	0.3025	0.31	304424000.0
2012-06-18	AMZN	Stock	10.864	11.188	10.8365	11.133	67392000.0
2012-06-18	META	Stock	29.96	32.08	29.41	31.41	42978900.0
2012-06-18	TSLA	Stock	1.996	2.1553	1.9667	2.1227	18852000.0
2012-06-18	TLT	Stock	127.15	127.34	126.26	127.08	6698323.0
2012-06-18	ES	Stock	38.34	38.74	38.3	38.71	1491400.0
2012-06-18	CL	Stock	50.7	50.875	50.445	50.835	3005600.0
2012-06-18	A	Stock	28.505	28.7482	28.226	28.7196	3669610.0
2012-06-18	AABA-DELISTED	Stock	15.33	15.54	15.27	15.49	9489676.0
2012-06-18	AACC-DELISTED	Stock	5.8	5.96	5.726	5.95	61533.0
2012-06-18	AACG	Stock	3.39	3.9	3.35	3.68	27400.0
2012-06-18	AAIC-DELISTED	Stock	22.59	22.79	22.59	22.62	73402.0
2012-06-18	AAME	Stock	2.72	2.72	2.7	2.72	1600.0
2012-06-18	AAMRQ-DELISTED	Stock	0.45	0.463	0.442	0.445	774637.0
2012-06-18	AAON	Stock	5.9259	6.0237	5.8578	5.8785	138038.0
2012-06-18	AAP	Stock	69.91	71.37	69.2	70.69	1374200.0
2012-06-18	AAT	Stock	23.0	23.49	22.99	23.4	133100.0
2012-06-18	AAU-DELISTED	Stock	2.21	2.25	2.1899	2.24	50841.0
2012-06-18	AAUAF-DELISTED	Stock	2.21	2.25	2.1899	2.24	52241.0
2012-06-18	AAV-DELISTED	Stock	2.81	2.91	2.78	2.85	239256.0
2012-06-18	AAWW-DELISTED	Stock	42.18	43.408	41.99	43.12	164072.0
2012-06-18	AAXJ	Stock	52.32	52.59	52.09	52.46	183852.0
2012-06-18	AAXN-DELISTED	Stock	5.16	5.39	5.15	5.37	419346.0
2012-06-18	AB	Stock	11.73	11.88	11.55	11.83	363200.0
2012-06-18	ABAC-DELISTED	Stock	1.3601	1.47	1.36	1.42	12899.0
2012-06-18	ABAX-DELISTED	Stock	34.22	35.09	34.08	34.89	97651.0
2012-06-18	ABB-DELISTED	Stock	16.0	16.11	15.92	16.05	1999147.0
2012-06-18	ABBNY-DELISTED	Stock	16.0	16.11	15.92	16.06	2233232.0
2012-06-18	ABC-DELISTED	Stock	37.19	38.03	37.12	37.8	1679617.0
2012-06-18	ABCB	Stock	11.86	11.98	11.57	11.66	50100.0
2012-06-18	ABCD-DELISTED	Stock	1.17	1.19	1.07	1.13	53946.0
2012-06-18	ABCO-DELISTED	Stock	47.98	48.37	47.7	47.99	331152.0
2012-06-18	ABCW-DELISTED	Stock	0.4819	0.4819	0.4819	0.4819	1490.0
2012-06-18	ABE-DELISTED	Stock	17.86	18.13	17.86	18.08	3394.0
2012-06-18	ABEO	Stock	850.0	912.5	850.0	850.0	12.0
2012-06-18	ABFS-DELISTED	Stock	12.25	12.58	12.19	12.51	415599.0
2012-06-18	ABG	Stock	24.24	24.68	24.08	24.33	291800.0
2012-06-18	ABM	Stock	20.36	20.65	20.26	20.56	228000.0
2012-06-18	ABMD-DELISTED	Stock	21.94	22.07	21.63	21.7	316213.0
2012-06-18	ABR	Stock	5.09	5.19	5.0	5.03	127900.0
2012-06-18	ABT	Stock	29.9779	30.1602	29.9779	30.0835	8211755.0
2012-06-18	ABTL-DELISTED	Stock	3.8489	3.9491	3.7476	3.9	15623.0
2012-06-18	ABUS	Stock	1.98	2.06	1.98	2.06	2900.0
2012-06-18	ABV-DELISTED	Stock	36.85	37.66	36.71	37.54	2624540.0
2012-06-18	ABVA-DELISTED	Stock	4.36	4.36	3.5	4.19	18844.0
2012-06-18	ABVT-DELISTED	Stock	83.88	83.88	83.86	83.88	120701.0
2012-06-18	ABX-DELISTED	Stock	39.15	40.23	38.97	40.19	10045667.0
2012-06-18	ACAD	Stock	1.48	1.54	1.48	1.53	224300.0

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

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