PREVIEW / stock_daily / 2012-04-18

all stock daily files

  file:    by_date/stock_daily/2012/2012-04-18.parquet
  size:    198 KB
  rows:    6,132
  symbols: 3,515

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-04-18	AAPL	Stock	21.9186	22.1518	21.5254	21.7264	954531200.0
2012-04-18	MSFT	Stock	31.28	31.31	31.04	31.14	40552900.0
2012-04-18	NVDA	Stock	0.3482	0.35	0.3425	0.3468	400764000.0
2012-04-18	AMZN	Stock	9.441	9.6725	9.437	9.5535	80038000.0
2012-04-18	TSLA	Stock	2.1393	2.1833	2.102	2.1773	12346500.0
2012-04-18	TLT	Stock	117.05	117.12	116.73	116.94	4074331.0
2012-04-18	ES	Stock	36.15	36.42	36.03	36.19	1705400.0
2012-04-18	CL	Stock	49.11	49.385	48.955	49.25	2653000.0
2012-04-18	A	Stock	30.2504	30.4649	30.0501	30.2718	2405399.0
2012-04-18	AABA-DELISTED	Stock	15.4	15.57	15.3	15.48	35590558.0
2012-04-18	AACC-DELISTED	Stock	5.0	5.0	4.97	5.0	10800.0
2012-04-18	AACG	Stock	6.63	6.7	6.44	6.7	5900.0
2012-04-18	AAIC-DELISTED	Stock	22.57	22.64	22.28	22.49	84063.0
2012-04-18	AAME	Stock	2.94	2.94	2.86	2.92	2600.0
2012-04-18	AAMRQ-DELISTED	Stock	0.49	0.49	0.473	0.48	866818.0
2012-04-18	AAON	Stock	5.8074	5.8074	5.6148	5.7156	121500.0
2012-04-18	AAP	Stock	89.85	90.86	89.69	90.68	664200.0
2012-04-18	AAT	Stock	22.95	23.05	22.52	22.57	156200.0
2012-04-18	AAU-DELISTED	Stock	2.25	2.28	2.21	2.21	95379.0
2012-04-18	AAUAF-DELISTED	Stock	2.25	2.28	2.2	2.2	95779.0
2012-04-18	AAV-DELISTED	Stock	3.09	3.09	2.95	2.98	245643.0
2012-04-18	AAWW-DELISTED	Stock	47.98	48.51	46.84	47.31	354963.0
2012-04-18	AAXJ	Stock	55.99	56.23	55.9	56.1	237790.0
2012-04-18	AAXN-DELISTED	Stock	4.19	4.214	4.12	4.16	177778.0
2012-04-18	AB	Stock	14.58	14.69	14.17	14.31	153400.0
2012-04-18	ABAC-DELISTED	Stock	1.83	2.11	1.8	2.1	88719.0
2012-04-18	ABAX-DELISTED	Stock	27.21	27.31	26.43	26.67	53534.0
2012-04-18	ABB-DELISTED	Stock	20.04	20.27	20.03	20.111	2269847.0
2012-04-18	ABBNY-DELISTED	Stock	20.04	20.27	20.03	20.1	2271878.0
2012-04-18	ABC-DELISTED	Stock	38.11	38.2	37.41	37.45	3726796.0
2012-04-18	ABCB	Stock	12.94	13.05	12.83	12.94	48400.0
2012-04-18	ABCD-DELISTED	Stock	2.39	2.39	2.31	2.33	8284.0
2012-04-18	ABCO-DELISTED	Stock	43.76	44.57	43.7	44.28	162129.0
2012-04-18	ABCW-DELISTED	Stock	0.7832	0.8534	0.6526	0.753	36340.0
2012-04-18	ABD-DELISTED	Stock	11.335	11.485	10.975	11.315	1446680.0
2012-04-18	ABE-DELISTED	Stock	19.02	19.133	19.02	19.133	3475.0
2012-04-18	ABEO	Stock	1475.0	1475.0	1475.0	1475.0	7.0
2012-04-18	ABFS-DELISTED	Stock	18.56	18.65	18.33	18.4	165945.0
2012-04-18	ABG	Stock	27.68	27.84	27.28	27.29	371100.0
2012-04-18	ABH-DELISTED	Stock	13.23	13.3	13.06	13.08	211494.0
2012-04-18	ABM	Stock	23.24	23.44	22.92	23.39	184600.0
2012-04-18	ABMD-DELISTED	Stock	20.7	20.92	20.57	20.79	112837.0
2012-04-18	ABR	Stock	5.62	5.82	5.56	5.63	25100.0
2012-04-18	ABT	Stock	29.0327	29.2966	28.668	29.0087	15899541.0
2012-04-18	ABTL-DELISTED	Stock	4.4	4.75	4.2	4.55	223827.0
2012-04-18	ABV-DELISTED	Stock	42.7	43.07	42.6	43.06	3370943.0
2012-04-18	ABVT-DELISTED	Stock	82.94	83.06	82.89	82.95	428579.0
2012-04-18	ABX-DELISTED	Stock	41.0	41.59	40.76	41.08	6262660.0
2012-04-18	ACAD	Stock	1.5	1.54	1.49	1.5	189400.0
2012-04-18	ACAS-DELISTED	Stock	8.67	8.72	8.6	8.61	1284861.0

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

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