PREVIEW / stock_daily / 2011-05-27

all stock daily files

  file:    by_date/stock_daily/2011/2011-05-27.parquet
  size:    198 KB
  rows:    6,105
  symbols: 3,550

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
2011-05-27	AAPL	Stock	11.9571	12.0582	11.9396	12.0504	203599200.0
2011-05-27	MSFT	Stock	24.68	24.9	24.65	24.76	50251000.0
2011-05-27	NVDA	Stock	0.4725	0.4883	0.472	0.4875	658824000.0
2011-05-27	AMZN	Stock	9.738	9.806	9.675	9.7065	47052000.0
2011-05-27	TSLA	Stock	1.9693	1.978	1.9213	1.97	25306500.0
2011-05-27	TLT	Stock	96.13	96.51	95.88	96.47	5390680.0
2011-05-27	ES	Stock	35.22	35.3	34.92	35.02	928300.0
2011-05-27	CL	Stock	42.785	42.94	42.65	42.86	2344600.0
2011-05-27	A	Stock	35.3362	35.5866	35.1717	35.4793	2993957.0
2011-05-27	AABA-DELISTED	Stock	16.03	16.19	15.95	16.02	19407965.0
2011-05-27	AACC-DELISTED	Stock	4.13	4.15	3.77	4.03	31565.0
2011-05-27	AACG	Stock	11.03	11.33	11.01	11.08	40400.0
2011-05-27	AAIC-DELISTED	Stock	27.8	28.98	27.63	28.78	57891.0
2011-05-27	AAME	Stock	2.03	2.05	2.03	2.05	200.0
2011-05-27	AAON	Stock	6.5165	6.5383	6.4494	6.5185	76444.0
2011-05-27	AAP	Stock	62.63	62.75	61.79	62.12	1360800.0
2011-05-27	AAT	Stock	21.84	22.13	21.65	22.04	46900.0
2011-05-27	AATI-DELISTED	Stock	6.03	6.055	6.005	6.03	37418462.0
2011-05-27	AAU-DELISTED	Stock	3.78	3.89	3.67	3.78	413181.0
2011-05-27	AAUAF-DELISTED	Stock	3.78	3.89	3.67	3.78	414381.0
2011-05-27	AAV-DELISTED	Stock	8.1	8.26	8.06	8.21	410906.0
2011-05-27	AAWW-DELISTED	Stock	61.29	61.43	60.72	61.32	65454.0
2011-05-27	AAXJ	Stock	62.64	62.77	62.3701	62.51	254308.0
2011-05-27	AAXN-DELISTED	Stock	4.61	4.72	4.6	4.65	345198.0
2011-05-27	AB	Stock	20.92	20.92	20.53	20.79	404800.0
2011-05-27	ABAC-DELISTED	Stock	2.75	2.83	2.75	2.83	5849.0
2011-05-27	ABAX-DELISTED	Stock	30.26	30.465	30.11	30.44	59230.0
2011-05-27	ABB-DELISTED	Stock	26.31	26.515	26.28	26.395	1395236.0
2011-05-27	ABBC-DELISTED	Stock	11.13	11.303	11.12	11.29	66402.0
2011-05-27	ABBNY-DELISTED	Stock	26.31	26.515	26.28	26.41	1395436.0
2011-05-27	ABC-DELISTED	Stock	41.25	41.41	40.57	41.05	2410416.0
2011-05-27	ABCB	Stock	8.89	8.94	8.81	8.94	15200.0
2011-05-27	ABCD-DELISTED	Stock	3.29	3.29	3.21	3.25	17567.0
2011-05-27	ABCO-DELISTED	Stock	25.67	25.88	25.62	25.82	85473.0
2011-05-27	ABCW-DELISTED	Stock	0.7406	0.8094	0.7394	0.8094	13430.0
2011-05-27	ABD-DELISTED	Stock	8.03	8.16	8.0	8.16	275130.0
2011-05-27	ABE-DELISTED	Stock	18.78	18.85	18.75	18.77	4526.0
2011-05-27	ABEO	Stock	2837.5	2837.5	2587.5	2837.5	16.0
2011-05-27	ABFS-DELISTED	Stock	24.85	25.18	24.19	24.44	210496.0
2011-05-27	ABG	Stock	16.7	16.85	16.4	16.44	266300.0
2011-05-27	ABH-DELISTED	Stock	24.05	24.4	23.655	24.33	846881.0
2011-05-27	ABM	Stock	23.36	23.36	22.42	22.49	766200.0
2011-05-27	ABMD-DELISTED	Stock	18.89	18.9	18.05	18.52	269101.0
2011-05-27	ABR	Stock	4.86	5.04	4.79	5.01	55900.0
2011-05-27	ABT	Stock	25.0072	25.0696	24.6473	24.7337	19484785.0
2011-05-27	ABTL-DELISTED	Stock	6.0988	6.2475	5.9004	5.95	10262.0
2011-05-27	ABUS	Stock	3.0	3.19	2.77	3.19	24300.0
2011-05-27	ABV-DELISTED	Stock	31.32	31.76	31.3	31.51	1468404.0
2011-05-27	ABVA-DELISTED	Stock	5.76	5.76	5.64	5.64	1291.0
2011-05-27	ABVT-DELISTED	Stock	74.59	76.39	74.53	75.41	502353.0

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

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