PREVIEW / stock_daily / 2012-06-01

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-01.parquet
  size:    199 KB
  rows:    6,207
  symbols: 3,553

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-01	AAPL	Stock	20.3271	20.4518	20.0186	20.0354	520987600.0
2012-06-01	MSFT	Stock	28.76	28.96	28.44	28.45	56634300.0
2012-06-01	NVDA	Stock	0.3042	0.3073	0.299	0.2995	440984000.0
2012-06-01	AMZN	Stock	10.422	10.5615	10.365	10.411	79030000.0
2012-06-01	META	Stock	28.89	29.15	27.39	27.72	41855500.0
2012-06-01	TSLA	Stock	1.902	1.944	1.8507	1.8767	13287000.0
2012-06-01	TLT	Stock	128.87	130.38	128.53	130.36	23526832.0
2012-06-01	ES	Stock	35.7	36.47	35.57	36.42	3351700.0
2012-06-01	CL	Stock	48.855	49.03	48.21	48.24	4616800.0
2012-06-01	A	Stock	28.0401	28.2117	27.2246	27.3391	7578698.0
2012-06-01	AABA-DELISTED	Stock	15.04	15.1201	14.85	14.92	14327961.0
2012-06-01	AACC-DELISTED	Stock	5.65	5.73	5.53	5.68	14850.0
2012-06-01	AACG	Stock	5.36	5.4	5.36	5.4	1300.0
2012-06-01	AAIC-DELISTED	Stock	22.38	22.51	21.75	21.85	136612.0
2012-06-01	AAME	Stock	2.75	2.78	2.7	2.78	2200.0
2012-06-01	AAMRQ-DELISTED	Stock	0.46	0.478	0.46	0.461	1006960.0
2012-06-01	AAON	Stock	5.4015	5.4844	5.3837	5.4015	260888.0
2012-06-01	AAP	Stock	71.51	72.39	71.1	71.14	1090600.0
2012-06-01	AAT	Stock	22.2	22.5	22.13	22.16	119000.0
2012-06-01	AAU-DELISTED	Stock	1.9	2.05	1.8832	2.04	159960.0
2012-06-01	AAUAF-DELISTED	Stock	1.92	2.07	1.9017	2.04	155001.0
2012-06-01	AAV-DELISTED	Stock	2.73	2.73	2.571	2.64	283919.0
2012-06-01	AAWW-DELISTED	Stock	44.34	46.32	42.17	42.3	276433.0
2012-06-01	AAXJ	Stock	49.74	50.01	49.42	49.46	407406.0
2012-06-01	AAXN-DELISTED	Stock	5.27	5.35	5.22	5.26	543002.0
2012-06-01	AB	Stock	12.87	12.87	12.35	12.43	211600.0
2012-06-01	ABAC-DELISTED	Stock	1.42	1.5	1.42	1.44	14890.0
2012-06-01	ABAX-DELISTED	Stock	32.01	32.4301	31.63	31.7	116265.0
2012-06-01	ABB-DELISTED	Stock	15.5	15.65	15.39	15.61	4305010.0
2012-06-01	ABBNY-DELISTED	Stock	15.5	15.65	15.39	15.63	4296355.0
2012-06-01	ABC-DELISTED	Stock	36.65	36.83	36.26	36.28	2189199.0
2012-06-01	ABCB	Stock	11.16	11.31	10.88	10.88	63500.0
2012-06-01	ABCD-DELISTED	Stock	1.2	1.28	1.15	1.21	40053.0
2012-06-01	ABCO-DELISTED	Stock	47.64	47.83	47.25	47.43	177056.0
2012-06-01	ABCW-DELISTED	Stock	0.4619	0.4619	0.4619	0.4619	1990.0
2012-06-01	ABE-DELISTED	Stock	17.78	17.78	17.26	17.36	23718.0
2012-06-01	ABEO	Stock	1125.0	1125.0	975.0	1100.0	33.0
2012-06-01	ABFS-DELISTED	Stock	12.37	12.84	12.3021	12.65	297108.0
2012-06-01	ABG	Stock	26.02	26.5	24.67	24.79	627100.0
2012-06-01	ABM	Stock	21.06	21.2	20.45	20.47	402900.0
2012-06-01	ABMD-DELISTED	Stock	19.84	20.275	18.74	18.92	813919.0
2012-06-01	ABR	Stock	6.11	6.24	5.88	5.94	45300.0
2012-06-01	ABT	Stock	29.3398	29.5221	28.9607	29.0375	17083785.0
2012-06-01	ABTL-DELISTED	Stock	3.5522	3.7483	3.5522	3.7478	9725.0
2012-06-01	ABUS	Stock	2.04	2.04	1.77	1.95	9900.0
2012-06-01	ABV-DELISTED	Stock	37.23	37.818	35.99	36.08	6050143.0
2012-06-01	ABVA-DELISTED	Stock	4.32	4.32	4.26	4.26	400.0
2012-06-01	ABVT-DELISTED	Stock	83.24	83.35	83.19	83.27	339114.0
2012-06-01	ABX-DELISTED	Stock	40.19	42.15	40.03	41.91	17274010.0
2012-06-01	ACAD	Stock	1.35	1.37	1.3	1.31	395200.0

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

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