PREVIEW / stock_daily / 2012-12-07

all stock daily files

  file:    by_date/stock_daily/2012/2012-12-07.parquet
  size:    200 KB
  rows:    6,214
  symbols: 3,502

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-07	AAPL	Stock	19.7643	19.8286	18.9286	19.0446	787040800.0
2012-12-07	MSFT	Stock	26.82	26.82	26.37	26.46	46162100.0
2012-12-07	NVDA	Stock	0.2998	0.3012	0.2955	0.299	338288000.0
2012-12-07	AMZN	Stock	12.707	12.7605	12.6005	12.6635	43406000.0
2012-12-07	META	Stock	27.07	27.78	26.84	27.49	51751900.0
2012-12-07	TSLA	Stock	2.2867	2.2993	2.2567	2.278	9966000.0
2012-12-07	TLT	Stock	124.5	124.96	124.34	124.43	4020831.0
2012-12-07	ES	Stock	39.23	39.49	39.14	39.27	1009600.0
2012-12-07	CL	Stock	53.565	54.195	53.55	54.185	3134800.0
2012-12-07	A	Stock	27.5393	27.5465	27.0243	27.0458	4650307.0
2012-12-07	AABA-DELISTED	Stock	19.17	19.3	19.06	19.21	18890117.0
2012-12-07	AACC-DELISTED	Stock	5.05	5.16	4.54	4.76	41390.0
2012-12-07	AACG	Stock	3.9	3.93	3.7	3.93	4400.0
2012-12-07	AAIC-DELISTED	Stock	22.26	22.26	21.6	21.76	195304.0
2012-12-07	AAME	Stock	2.92	2.94	2.92	2.94	900.0
2012-12-07	AAMRQ-DELISTED	Stock	0.5127	0.575	0.5075	0.574	6916295.0
2012-12-07	AAON	Stock	6.2844	6.3615	6.163	6.1956	115088.0
2012-12-07	AAP	Stock	72.24	72.31	71.48	71.62	424700.0
2012-12-07	AAT	Stock	27.19	27.23	26.95	27.12	120800.0
2012-12-07	AAU-DELISTED	Stock	3.22	3.23	3.05	3.09	172753.0
2012-12-07	AAUAF-DELISTED	Stock	3.22	3.23	3.05	3.09	173153.0
2012-12-07	AAV-DELISTED	Stock	3.26	3.289	3.16	3.17	194457.0
2012-12-07	AAWW-DELISTED	Stock	42.66	42.76	42.0969	42.4	112326.0
2012-12-07	AAXJ	Stock	59.3	59.3	59.01	59.26	492129.0
2012-12-07	AAXN-DELISTED	Stock	8.26	8.29	8.12	8.28	334329.0
2012-12-07	AB	Stock	16.97	17.16	16.57	16.84	329500.0
2012-12-07	ABAC-DELISTED	Stock	0.91	0.98	0.9099	0.958	2650.0
2012-12-07	ABAX-DELISTED	Stock	37.14	38.47	37.0075	38.17	181306.0
2012-12-07	ABB-DELISTED	Stock	19.83	19.9	19.75	19.9	1022232.0
2012-12-07	ABBNY-DELISTED	Stock	19.83	19.9	19.75	19.89	1025415.0
2012-12-07	ABC-DELISTED	Stock	42.78	42.79	42.151	42.26	2482032.0
2012-12-07	ABCB	Stock	11.68	11.83	11.47	11.68	124200.0
2012-12-07	ABCD-DELISTED	Stock	1.16	1.25	1.11	1.13	37164.0
2012-12-07	ABCO-DELISTED	Stock	47.92	48.96	47.89	48.65	192416.0
2012-12-07	ABCW-DELISTED	Stock	0.4	0.4	0.37	0.37	51416.0
2012-12-07	ABE-DELISTED	Stock	20.51	20.66	20.18	20.457	285542.0
2012-12-07	ABEO	Stock	325.0	337.5	287.5	337.5	100.0
2012-12-07	ABFS-DELISTED	Stock	8.63	8.64	8.45	8.54	146102.0
2012-12-07	ABG	Stock	31.63	31.69	30.53	30.67	229000.0
2012-12-07	ABM	Stock	19.62	19.67	19.45	19.56	112100.0
2012-12-07	ABMD-DELISTED	Stock	12.0	12.88	11.8	12.5	3247243.0
2012-12-07	ABR	Stock	5.13	5.16	5.08	5.16	111500.0
2012-12-07	ABT	Stock	30.9615	31.4845	30.808	31.4413	19290955.0
2012-12-07	ABTL-DELISTED	Stock	3.855	3.855	3.765	3.77	19326.0
2012-12-07	ABUS	Stock	4.83	5.22	4.82	5.21	69400.0
2012-12-07	ABV-DELISTED	Stock	42.54	42.54	41.96	42.3	1384582.0
2012-12-07	ABVA-DELISTED	Stock	4.7	4.71	4.65	4.7	7614.0
2012-12-07	ABX-DELISTED	Stock	33.7	33.87	33.45	33.58	5708376.0
2012-12-07	ACAD	Stock	4.65	4.74	4.49	4.55	2526400.0
2012-12-07	ACAS-DELISTED	Stock	11.7	11.92	11.67	11.88	2293026.0

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

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