PREVIEW / stock_daily / 2012-12-05

all stock daily files

  file:    by_date/stock_daily/2012/2012-12-05.parquet
  size:    201 KB
  rows:    6,212
  symbols: 3,496

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-12-05	AAPL	Stock	20.3182	20.3304	19.2418	19.2425	1044638000.0
2012-12-05	MSFT	Stock	26.38	26.93	26.26	26.67	68283800.0
2012-12-05	NVDA	Stock	0.3	0.302	0.2948	0.299	633024000.0
2012-12-05	AMZN	Stock	12.622	12.7775	12.519	12.698	57044000.0
2012-12-05	META	Stock	27.75	27.9	27.26	27.71	58976300.0
2012-12-05	TSLA	Stock	2.2547	2.2793	2.2387	2.2473	9922500.0
2012-12-05	TLT	Stock	125.4	125.81	125.17	125.32	1978111.0
2012-12-05	ES	Stock	38.52	39.5	38.46	39.29	1484000.0
2012-12-05	CL	Stock	53.85	53.895	53.495	53.605	2765400.0
2012-12-05	A	Stock	27.2818	27.8612	27.2461	27.6538	5490645.0
2012-12-05	AABA-DELISTED	Stock	18.98	19.03	18.77	18.89	23961660.0
2012-12-05	AACC-DELISTED	Stock	5.3	5.37	5.04	5.13	11248.0
2012-12-05	AACG	Stock	3.99	3.99	3.87	3.89	13100.0
2012-12-05	AAIC-DELISTED	Stock	21.35	21.44	21.07	21.19	94888.0
2012-12-05	AAME	Stock	2.94	2.94	2.89	2.93	3600.0
2012-12-05	AAMRQ-DELISTED	Stock	0.5175	0.52	0.5025	0.505	1063148.0
2012-12-05	AAON	Stock	6.2519	6.3704	6.2311	6.2578	351675.0
2012-12-05	AAP	Stock	72.59	72.96	72.02	72.2	692500.0
2012-12-05	AAT	Stock	27.25	27.3	26.88	26.97	65400.0
2012-12-05	AAU-DELISTED	Stock	2.88	3.14	2.78	3.09	1090762.0
2012-12-05	AAUAF-DELISTED	Stock	2.88	3.14	2.78	3.07	1091762.0
2012-12-05	AAV-DELISTED	Stock	3.34	3.38	3.27	3.34	229429.0
2012-12-05	AAWW-DELISTED	Stock	42.79	42.95	42.16	42.59	169599.0
2012-12-05	AAXJ	Stock	58.67	59.0799	58.57	58.75	421818.0
2012-12-05	AAXN-DELISTED	Stock	8.32	8.35	8.013	8.15	442059.0
2012-12-05	AB	Stock	17.67	17.68	17.18	17.25	856200.0
2012-12-05	ABAC-DELISTED	Stock	0.86	0.928	0.86	0.928	5402.0
2012-12-05	ABAX-DELISTED	Stock	37.05	37.1685	36.23	36.82	60545.0
2012-12-05	ABB-DELISTED	Stock	19.75	19.94	19.68	19.87	1679327.0
2012-12-05	ABBNY-DELISTED	Stock	19.75	19.94	19.68	19.87	1707710.0
2012-12-05	ABC-DELISTED	Stock	42.75	42.75	42.02	42.27	2729318.0
2012-12-05	ABCB	Stock	11.56	11.7	11.36	11.37	36500.0
2012-12-05	ABCD-DELISTED	Stock	1.04	1.15	1.01	1.1	12964.0
2012-12-05	ABCO-DELISTED	Stock	45.93	47.2	45.93	47.03	347860.0
2012-12-05	ABCW-DELISTED	Stock	0.381	0.395	0.38	0.395	47630.0
2012-12-05	ABE-DELISTED	Stock	20.59	20.64	20.506	20.63	27867.0
2012-12-05	ABEO	Stock	312.5	337.5	300.0	325.0	164.0
2012-12-05	ABFS-DELISTED	Stock	8.5	8.55	8.42	8.45	245164.0
2012-12-05	ABG	Stock	31.71	31.75	31.04	31.3	283100.0
2012-12-05	ABM	Stock	19.3	19.43	19.07	19.35	140600.0
2012-12-05	ABMD-DELISTED	Stock	13.08	13.2284	12.86	12.88	376662.0
2012-12-05	ABR	Stock	5.19	5.19	5.14	5.15	26900.0
2012-12-05	ABT	Stock	30.8415	31.091	30.7456	30.9663	10307837.0
2012-12-05	ABTL-DELISTED	Stock	3.86	3.87	3.86	3.87	700.0
2012-12-05	ABUS	Stock	4.75	4.91	4.72	4.83	22100.0
2012-12-05	ABV-DELISTED	Stock	41.62	41.91	41.42	41.79	1811304.0
2012-12-05	ABVA-DELISTED	Stock	4.7	4.73	4.69	4.7101	6808.0
2012-12-05	ABX-DELISTED	Stock	34.22	34.22	33.33	33.39	8633192.0
2012-12-05	ACAD	Stock	4.99	4.99	4.62	4.67	4939900.0
2012-12-05	ACAS-DELISTED	Stock	11.85	11.88	11.67	11.695	2158159.0

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

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