PREVIEW / stock_daily / 2013-03-07

all stock daily files

  file:    by_date/stock_daily/2013/2013-03-07.parquet
  size:    208 KB
  rows:    6,313
  symbols: 3,507

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
2013-03-07	AAPL	Stock	15.1607	15.4289	15.0379	15.3779	468473600.0
2013-03-07	MSFT	Stock	28.11	28.28	28.01	28.14	29196700.0
2013-03-07	NVDA	Stock	0.3215	0.3248	0.3173	0.319	314824000.0
2013-03-07	AMZN	Stock	13.705	13.74	13.5925	13.694	38780000.0
2013-03-07	META	Stock	27.57	28.68	27.47	28.58	74540200.0
2013-03-07	TSLA	Stock	2.5153	2.5767	2.4587	2.5487	17374500.0
2013-03-07	TLT	Stock	116.41	116.51	115.91	115.96	8529824.0
2013-03-07	ES	Stock	42.52	42.7	42.31	42.32	650100.0
2013-03-07	CL	Stock	58.355	58.355	57.645	57.705	3718800.0
2013-03-07	A	Stock	30.9728	31.1016	30.6223	30.9371	3375052.0
2013-03-07	AABA-DELISTED	Stock	22.95	23.0	22.65	22.69	12785220.0
2013-03-07	AACC-DELISTED	Stock	6.45	7.0	6.45	6.56	791470.0
2013-03-07	AACG	Stock	3.9	3.9	3.9	3.9	2000.0
2013-03-07	AAIC-DELISTED	Stock	26.28	26.65	26.24	26.42	187585.0
2013-03-07	AAMC-DELISTED	Stock	38.6765	38.8971	38.6765	38.8235	6633.0
2013-03-07	AAME	Stock	3.41	3.43	3.4	3.42	3300.0
2013-03-07	AAMRQ-DELISTED	Stock	2.965	2.97	2.92	2.96	4859991.0
2013-03-07	AAON	Stock	7.3363	7.3956	7.2622	7.3807	208575.0
2013-03-07	AAP	Stock	76.04	76.75	75.7	76.22	965500.0
2013-03-07	AAT	Stock	31.3	31.39	31.04	31.33	113600.0
2013-03-07	AAU-DELISTED	Stock	2.0	2.13	2.0	2.08	202659.0
2013-03-07	AAUAF-DELISTED	Stock	2.0	2.13	2.0	2.06	202959.0
2013-03-07	AAV-DELISTED	Stock	3.04	3.17	3.04	3.16	234829.0
2013-03-07	AAWW-DELISTED	Stock	45.21	45.3275	44.09	44.24	542134.0
2013-03-07	AAXJ	Stock	60.29	60.4	60.2	60.39	620158.0
2013-03-07	AAXN-DELISTED	Stock	7.89	8.0	7.86	7.98	433511.0
2013-03-07	AB	Stock	22.95	23.07	22.54	22.6	247900.0
2013-03-07	ABAC-DELISTED	Stock	0.8	0.84	0.77	0.8	23213.0
2013-03-07	ABAX-DELISTED	Stock	43.19	43.48	42.82	43.36	84520.0
2013-03-07	ABB-DELISTED	Stock	23.03	23.11	22.91	22.97	979260.0
2013-03-07	ABBNY-DELISTED	Stock	23.03	23.11	22.91	22.98	984691.0
2013-03-07	ABBV	Stock	37.65	38.01	37.44	37.49	4442500.0
2013-03-07	ABC-DELISTED	Stock	48.44	48.65	47.68	48.07	1773089.0
2013-03-07	ABCB	Stock	14.28	14.48	14.14	14.39	81100.0
2013-03-07	ABCD-DELISTED	Stock	1.17	1.22	1.13	1.19	18317.0
2013-03-07	ABCO-DELISTED	Stock	52.51	52.81	51.42	51.63	244872.0
2013-03-07	ABCW-DELISTED	Stock	0.6	0.6499	0.56	0.61	5813.0
2013-03-07	ABE-DELISTED	Stock	21.33	21.489	21.33	21.489	2433.0
2013-03-07	ABEO	Stock	562.5	612.5	562.5	612.5	15.0
2013-03-07	ABFS-DELISTED	Stock	11.67	11.88	11.54	11.64	100737.0
2013-03-07	ABG	Stock	35.25	35.75	34.85	35.28	328700.0
2013-03-07	ABM	Stock	22.0	22.14	21.97	21.98	201200.0
2013-03-07	ABMD-DELISTED	Stock	16.18	16.74	16.0	16.73	375322.0
2013-03-07	ABR	Stock	8.07	8.23	8.07	8.21	84200.0
2013-03-07	ABR.A-DELISTED	Stock	25.5	25.55	25.46	25.46	5700.0
2013-03-07	ABT	Stock	34.3	34.54	34.16	34.43	5666000.0
2013-03-07	ABTL-DELISTED	Stock	4.35	4.35	4.26	4.26	12400.0
2013-03-07	ABUS	Stock	4.44	4.46	4.39	4.44	35200.0
2013-03-07	ABV-DELISTED	Stock	45.62	45.75	45.065	45.2	1197940.0
2013-03-07	ABX-DELISTED	Stock	29.77	30.1	28.93	29.04	9828414.0

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

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