PREVIEW / stock_daily / 2012-10-12

all stock daily files

  file:    by_date/stock_daily/2012/2012-10-12.parquet
  size:    197 KB
  rows:    6,119
  symbols: 3,460

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-10-12	AAPL	Stock	22.4843	22.6921	22.3321	22.4896	460014800.0
2012-10-12	MSFT	Stock	28.97	29.32	28.8	29.2	46464700.0
2012-10-12	NVDA	Stock	0.3163	0.3188	0.3138	0.3158	260696000.0
2012-10-12	AMZN	Stock	12.159	12.273	12.0955	12.118	44064000.0
2012-10-12	META	Stock	19.75	19.8	19.48	19.52	18809400.0
2012-10-12	TSLA	Stock	1.888	1.9153	1.8333	1.8427	14814000.0
2012-10-12	TLT	Stock	124.07	124.78	123.78	123.97	4934839.0
2012-10-12	ES	Stock	38.87	38.98	38.48	38.68	1404600.0
2012-10-12	CL	Stock	54.205	54.365	53.66	53.945	2574800.0
2012-10-12	A	Stock	26.9599	27.0243	26.5522	26.6237	3731681.0
2012-10-12	AABA-DELISTED	Stock	15.9	16.02	15.86	15.88	12172298.0
2012-10-12	AACC-DELISTED	Stock	7.52	7.71	7.495	7.7	10995.0
2012-10-12	AACG	Stock	4.98	5.11	4.98	5.11	1300.0
2012-10-12	AAIC-DELISTED	Stock	22.75	22.75	22.14	22.28	204863.0
2012-10-12	AAME	Stock	2.78	2.8	2.78	2.79	1100.0
2012-10-12	AAMRQ-DELISTED	Stock	0.385	0.389	0.3811	0.382	457479.0
2012-10-12	AAON	Stock	5.5852	5.6267	5.437	5.4637	138375.0
2012-10-12	AAP	Stock	68.55	68.55	67.9	67.97	520800.0
2012-10-12	AAT	Stock	27.66	27.88	27.66	27.76	160500.0
2012-10-12	AAU-DELISTED	Stock	2.55	2.55	2.51	2.53	36100.0
2012-10-12	AAUAF-DELISTED	Stock	2.56	2.56	2.52	2.52	36261.0
2012-10-12	AAV-DELISTED	Stock	3.88	3.91	3.8	3.81	132645.0
2012-10-12	AAWW-DELISTED	Stock	52.52	52.64	51.58	51.65	72093.0
2012-10-12	AAXJ	Stock	56.02	56.34	55.96	56.05	167718.0
2012-10-12	AAXN-DELISTED	Stock	5.91	6.0	5.87	5.99	235485.0
2012-10-12	AB	Stock	15.9	15.99	15.73	15.97	207800.0
2012-10-12	ABAC-DELISTED	Stock	1.42	1.53	1.42	1.5	6414.0
2012-10-12	ABAX-DELISTED	Stock	36.94	37.44	36.26	36.37	64259.0
2012-10-12	ABB-DELISTED	Stock	19.01	19.1	18.84	18.88	1372181.0
2012-10-12	ABBNY-DELISTED	Stock	19.01	19.1	18.84	18.89	1520436.0
2012-10-12	ABC-DELISTED	Stock	39.51	39.72	39.38	39.49	1735133.0
2012-10-12	ABCB	Stock	12.67	12.67	12.36	12.42	19800.0
2012-10-12	ABCD-DELISTED	Stock	0.98	0.98	0.98	0.98	100.0
2012-10-12	ABCO-DELISTED	Stock	47.2	48.3	47.2	48.07	97408.0
2012-10-12	ABCW-DELISTED	Stock	0.4	0.4	0.36	0.3601	49449.0
2012-10-12	ABE-DELISTED	Stock	20.64	20.65	20.56	20.56	300.0
2012-10-12	ABEO	Stock	425.0	500.0	425.0	500.0	48.0
2012-10-12	ABFS-DELISTED	Stock	8.32	8.52	8.15	8.18	391314.0
2012-10-12	ABG	Stock	29.68	30.06	29.39	29.61	120300.0
2012-10-12	ABM	Stock	18.28	18.28	18.1	18.12	332600.0
2012-10-12	ABMD-DELISTED	Stock	20.19	20.37	19.94	20.0	321757.0
2012-10-12	ABR	Stock	5.7	5.75	5.6	5.65	131500.0
2012-10-12	ABT	Stock	33.3989	33.6532	33.1974	33.2405	12070446.0
2012-10-12	ABTL-DELISTED	Stock	3.75	3.8899	3.75	3.85	2300.0
2012-10-12	ABUS	Stock	3.91	3.91	3.88	3.88	2000.0
2012-10-12	ABV-DELISTED	Stock	40.19	40.52	39.52	39.72	944884.0
2012-10-12	ABVA-DELISTED	Stock	4.61	4.63	4.46	4.6	7835.0
2012-10-12	ABX-DELISTED	Stock	39.83	39.88	38.89	39.01	7032050.0
2012-10-12	ACAD	Stock	2.49	2.55	2.35	2.4	821200.0
2012-10-12	ACAS-DELISTED	Stock	11.64	11.75	11.51	11.59	1823057.0

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

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