PREVIEW / stock_daily / 2012-06-05

all stock daily files

  file:    by_date/stock_daily/2012/2012-06-05.parquet
  size:    197 KB
  rows:    6,162
  symbols: 3,528

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-05	AAPL	Stock	20.0454	20.2311	19.9404	20.1011	388214400.0
2012-06-05	MSFT	Stock	28.51	28.75	28.39	28.51	45715400.0
2012-06-05	NVDA	Stock	0.2918	0.3025	0.2918	0.3018	365224000.0
2012-06-05	AMZN	Stock	10.6925	10.843	10.558	10.6605	70878000.0
2012-06-05	META	Stock	26.7	27.76	25.75	25.87	42473400.0
2012-06-05	TSLA	Stock	1.856	1.8927	1.8373	1.8607	9463500.0
2012-06-05	TLT	Stock	128.53	128.64	127.59	127.6	12483509.0
2012-06-05	ES	Stock	36.18	36.41	36.14	36.21	1828600.0
2012-06-05	CL	Stock	48.525	48.745	48.185	48.625	3095200.0
2012-06-05	A	Stock	26.9027	27.6037	26.7597	27.3891	5202517.0
2012-06-05	AABA-DELISTED	Stock	15.0	15.14	14.91	15.09	9688608.0
2012-06-05	AACC-DELISTED	Stock	5.7	5.79	5.55	5.55	6440.0
2012-06-05	AACG	Stock	5.42	5.7	5.42	5.7	7300.0
2012-06-05	AAIC-DELISTED	Stock	20.96	21.52	20.85	21.28	65021.0
2012-06-05	AAME	Stock	2.78	2.8	2.61	2.8	8400.0
2012-06-05	AAMRQ-DELISTED	Stock	0.451	0.466	0.445	0.463	838883.0
2012-06-05	AAON	Stock	5.4548	5.523	5.437	5.4667	172125.0
2012-06-05	AAP	Stock	70.67	72.4	70.36	72.12	1585200.0
2012-06-05	AAT	Stock	22.28	23.32	22.28	23.3	170200.0
2012-06-05	AAU-DELISTED	Stock	2.18	2.38	2.18	2.355	208097.0
2012-06-05	AAUAF-DELISTED	Stock	2.18	2.38	2.18	2.355	208897.0
2012-06-05	AAV-DELISTED	Stock	2.57	2.78	2.57	2.78	398814.0
2012-06-05	AAWW-DELISTED	Stock	41.0	42.3	40.99	42.04	389003.0
2012-06-05	AAXJ	Stock	49.44	49.74	49.34	49.63	265979.0
2012-06-05	AAXN-DELISTED	Stock	5.19	5.23	5.061	5.17	327400.0
2012-06-05	AB	Stock	12.37	12.7	12.28	12.38	602100.0
2012-06-05	ABAC-DELISTED	Stock	1.3899	1.39	1.35	1.352	14223.0
2012-06-05	ABAX-DELISTED	Stock	31.34	31.94	31.04	31.5	129455.0
2012-06-05	ABB-DELISTED	Stock	15.49	15.62	15.46	15.589	1711160.0
2012-06-05	ABBNY-DELISTED	Stock	15.49	15.62	15.46	15.59	1731476.0
2012-06-05	ABC-DELISTED	Stock	36.28	36.81	36.05	36.76	1656519.0
2012-06-05	ABCB	Stock	11.07	11.49	11.07	11.43	41600.0
2012-06-05	ABCD-DELISTED	Stock	1.21	1.29	1.21	1.27	94206.0
2012-06-05	ABCO-DELISTED	Stock	47.08	47.34	46.75	47.23	303900.0
2012-06-05	ABCW-DELISTED	Stock	0.4267	0.5321	0.4267	0.5321	4560.0
2012-06-05	ABE-DELISTED	Stock	17.26	17.52	17.26	17.52	4357.0
2012-06-05	ABEO	Stock	1000.0	1112.5	837.5	975.0	46.0
2012-06-05	ABFS-DELISTED	Stock	11.97	12.01	11.67	11.82	351869.0
2012-06-05	ABG	Stock	24.13	24.51	23.89	24.07	534300.0
2012-06-05	ABM	Stock	20.36	20.83	20.36	20.71	301400.0
2012-06-05	ABMD-DELISTED	Stock	19.65	20.74	19.34	20.42	679333.0
2012-06-05	ABR	Stock	5.97	6.15	5.79	5.85	83100.0
2012-06-05	ABT	Stock	28.8072	29.0039	28.5289	28.9319	15802835.0
2012-06-05	ABTL-DELISTED	Stock	3.6344	3.7787	3.5839	3.7	449553.0
2012-06-05	ABUS	Stock	1.9	1.95	1.86	1.92	1200.0
2012-06-05	ABV-DELISTED	Stock	35.87	36.23	35.68	35.94	4416455.0
2012-06-05	ABVA-DELISTED	Stock	4.31	4.31	4.01	4.16	5240.0
2012-06-05	ABVT-DELISTED	Stock	83.11	83.33	83.1	83.3	550643.0
2012-06-05	ABX-DELISTED	Stock	42.07	42.21	41.67	42.04	6812049.0
2012-06-05	ACAD	Stock	1.33	1.39	1.3	1.31	269400.0

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

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