PREVIEW / stock_daily / 2012-06-25

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-25.parquet
  size:    198 KB
  rows:    6,177
  symbols: 3,529

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-25	AAPL	Stock	20.6179	20.7071	20.3704	20.3846	304382400.0
2012-06-25	MSFT	Stock	30.3	30.32	29.62	29.87	42217200.0
2012-06-25	NVDA	Stock	0.3253	0.3263	0.3135	0.3148	494616000.0
2012-06-25	AMZN	Stock	11.015	11.0795	10.9	11.0035	47646000.0
2012-06-25	META	Stock	32.86	33.02	31.55	32.06	24352900.0
2012-06-25	TSLA	Stock	2.2627	2.2747	2.1833	2.2073	22477500.0
2012-06-25	TLT	Stock	126.36	127.02	126.27	126.84	6114752.0
2012-06-25	ES	Stock	37.46	37.7	37.4	37.59	1155000.0
2012-06-25	CL	Stock	49.585	49.775	49.5	49.66	3051800.0
2012-06-25	A	Stock	27.4964	27.5751	26.7382	26.9385	4170793.0
2012-06-25	AABA-DELISTED	Stock	15.55	15.55	15.31	15.42	13362093.0
2012-06-25	AACC-DELISTED	Stock	5.88	6.6	5.57	6.4	177143.0
2012-06-25	AACG	Stock	4.32	4.49	4.1	4.11	8400.0
2012-06-25	AAIC-DELISTED	Stock	23.03	23.03	22.69	22.91	189442.0
2012-06-25	AAME	Stock	2.71	2.71	2.68	2.7	3000.0
2012-06-25	AAMRQ-DELISTED	Stock	0.505	0.5148	0.483	0.49	550169.0
2012-06-25	AAON	Stock	5.52	5.6178	5.5052	5.5644	103275.0
2012-06-25	AAP	Stock	67.15	67.27	66.1	66.48	1037900.0
2012-06-25	AAT	Stock	22.55	23.37	22.55	23.24	146200.0
2012-06-25	AAU-DELISTED	Stock	2.12	2.19	2.0801	2.1	61675.0
2012-06-25	AAUAF-DELISTED	Stock	2.12	2.19	2.0801	2.1	61875.0
2012-06-25	AAV-DELISTED	Stock	2.57	2.63	2.47	2.56	250339.0
2012-06-25	AAWW-DELISTED	Stock	43.18	43.37	40.88	41.39	174627.0
2012-06-25	AAXJ	Stock	50.37	50.37	49.96	50.15	647377.0
2012-06-25	AAXN-DELISTED	Stock	5.2	5.25	5.15	5.21	233288.0
2012-06-25	AB	Stock	12.0	12.29	11.89	12.24	313600.0
2012-06-25	ABAC-DELISTED	Stock	1.15	1.2	1.07	1.07	17449.0
2012-06-25	ABAX-DELISTED	Stock	35.44	35.81	35.23	35.36	55121.0
2012-06-25	ABB-DELISTED	Stock	15.57	15.57	15.39	15.41	7133360.0
2012-06-25	ABBNY-DELISTED	Stock	15.57	15.57	15.39	15.42	7176016.0
2012-06-25	ABC-DELISTED	Stock	37.58	37.85	37.43	37.745	2827225.0
2012-06-25	ABCB	Stock	11.81	11.81	11.56	11.69	25400.0
2012-06-25	ABCD-DELISTED	Stock	1.04	1.08	0.95	0.99	84679.0
2012-06-25	ABCO-DELISTED	Stock	48.33	48.77	47.34	47.77	317804.0
2012-06-25	ABCW-DELISTED	Stock	0.45	0.47	0.45	0.45	57013.0
2012-06-25	ABE-DELISTED	Stock	18.05	18.05	17.9689	17.9689	1976.0
2012-06-25	ABEO	Stock	837.5	837.5	775.0	812.5	24.0
2012-06-25	ABFS-DELISTED	Stock	12.3	12.34	11.85	12.1	475195.0
2012-06-25	ABG	Stock	23.37	23.56	22.26	22.31	346800.0
2012-06-25	ABM	Stock	20.18	20.18	19.41	19.47	345800.0
2012-06-25	ABMD-DELISTED	Stock	20.95	21.07	20.55	20.66	268579.0
2012-06-25	ABR	Stock	5.06	5.32	5.06	5.14	73200.0
2012-06-25	ABT	Stock	29.7092	29.9731	29.5653	29.8052	11633180.0
2012-06-25	ABTL-DELISTED	Stock	3.6993	3.8007	3.6502	3.75	12890.0
2012-06-25	ABUS	Stock	2.0	2.0	1.96	1.97	9600.0
2012-06-25	ABV-DELISTED	Stock	36.49	37.23	36.48	37.0	2433331.0
2012-06-25	ABVA-DELISTED	Stock	4.23	4.23	4.19	4.19	200.0
2012-06-25	ABVT-DELISTED	Stock	83.92	83.94	83.9	83.93	72815.0
2012-06-25	ABX-DELISTED	Stock	37.72	38.62	37.22	38.25	8548008.0
2012-06-25	ACAD	Stock	1.5	1.53	1.48	1.51	193500.0

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

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