PREVIEW / stock_daily / 2012-06-21

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-21.parquet
  size:    198 KB
  rows:    6,132
  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
2012-06-21	AAPL	Stock	20.9086	21.0079	20.6229	20.6311	326351200.0
2012-06-21	MSFT	Stock	30.96	31.14	30.06	30.14	48456600.0
2012-06-21	NVDA	Stock	0.336	0.336	0.3203	0.321	516376000.0
2012-06-21	AMZN	Stock	11.192	11.3015	11.026	11.0285	56860000.0
2012-06-21	META	Stock	31.67	32.5	31.51	31.84	21875300.0
2012-06-21	TSLA	Stock	2.284	2.2853	2.1227	2.146	28378500.0
2012-06-21	TLT	Stock	125.95	127.25	125.89	126.71	9777395.0
2012-06-21	ES	Stock	38.17	38.33	37.53	37.57	1666500.0
2012-06-21	CL	Stock	50.45	50.45	49.72	49.725	3446000.0
2012-06-21	A	Stock	29.1059	29.3848	27.9185	27.9828	4337854.0
2012-06-21	AABA-DELISTED	Stock	15.74	15.8	15.47	15.49	13055731.0
2012-06-21	AACC-DELISTED	Stock	6.2	6.3	6.06	6.1	81058.0
2012-06-21	AACG	Stock	3.77	3.89	3.75	3.75	1800.0
2012-06-21	AAIC-DELISTED	Stock	23.03	23.08	22.95	22.97	113448.0
2012-06-21	AAME	Stock	2.71	2.72	2.7	2.72	5800.0
2012-06-21	AAMRQ-DELISTED	Stock	0.49	0.518	0.48	0.51	1426249.0
2012-06-21	AAON	Stock	5.8667	5.8815	5.5526	5.597	275400.0
2012-06-21	AAP	Stock	69.19	69.27	67.22	67.23	1793400.0
2012-06-21	AAT	Stock	23.49	23.53	23.15	23.29	207400.0
2012-06-21	AAU-DELISTED	Stock	2.21	2.2205	2.04	2.07	157525.0
2012-06-21	AAUAF-DELISTED	Stock	2.21	2.2205	2.04	2.06	157821.0
2012-06-21	AAV-DELISTED	Stock	2.8	2.8	2.62	2.64	397400.0
2012-06-21	AAWW-DELISTED	Stock	44.0	44.28	43.26	43.51	177358.0
2012-06-21	AAXJ	Stock	52.28	52.28	50.87	50.93	1458326.0
2012-06-21	AAXN-DELISTED	Stock	5.41	5.45	5.27	5.29	289818.0
2012-06-21	AB	Stock	12.1	12.23	11.98	12.17	505900.0
2012-06-21	ABAC-DELISTED	Stock	1.23	1.3299	1.15	1.15	56442.0
2012-06-21	ABAX-DELISTED	Stock	35.28	35.61	34.78	34.93	106379.0
2012-06-21	ABB-DELISTED	Stock	16.63	16.65	16.03	16.06	2221074.0
2012-06-21	ABBNY-DELISTED	Stock	16.63	16.65	16.03	16.07	2220833.0
2012-06-21	ABC-DELISTED	Stock	38.05	38.19	37.61	37.7	1601879.0
2012-06-21	ABCB	Stock	11.95	12.05	11.46	11.69	64300.0
2012-06-21	ABCD-DELISTED	Stock	1.06	1.12	0.9746	0.9901	95886.0
2012-06-21	ABCO-DELISTED	Stock	49.67	50.21	48.66	48.87	250497.0
2012-06-21	ABCW-DELISTED	Stock	0.483	0.483	0.4819	0.483	8460.0
2012-06-21	ABE-DELISTED	Stock	18.41	18.41	18.14	18.14	3280.0
2012-06-21	ABEO	Stock	912.5	912.5	825.0	875.0	6.0
2012-06-21	ABFS-DELISTED	Stock	12.53	12.5408	12.13	12.34	488097.0
2012-06-21	ABG	Stock	24.7	24.7	23.41	23.71	282800.0
2012-06-21	ABM	Stock	20.83	20.84	20.5	20.55	327600.0
2012-06-21	ABMD-DELISTED	Stock	22.13	22.3287	21.06	21.14	451285.0
2012-06-21	ABR	Stock	5.12	5.15	5.07	5.07	102500.0
2012-06-21	ABT	Stock	30.1458	30.285	29.8532	29.8628	12525219.0
2012-06-21	ABTL-DELISTED	Stock	3.898	4.1059	3.8757	3.95	24931.0
2012-06-21	ABUS	Stock	1.98	2.02	1.98	2.01	4800.0
2012-06-21	ABV-DELISTED	Stock	38.41	38.65	37.54	37.59	2848438.0
2012-06-21	ABVA-DELISTED	Stock	4.18	4.18	4.18	4.18	1502.0
2012-06-21	ABVT-DELISTED	Stock	83.87	83.91	83.87	83.9	130173.0
2012-06-21	ABX-DELISTED	Stock	39.49	39.61	38.28	38.29	7831206.0
2012-06-21	ACAD	Stock	1.59	1.59	1.45	1.46	621300.0

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

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