PREVIEW / stock_daily / 2011-04-07

all stock daily files

  file:    by_date/stock_daily/2011/2011-04-07.parquet
  size:    197 KB
  rows:    6,055
  symbols: 3,530

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-04-07	AAPL	Stock	12.075	12.1582	12.0011	12.0743	373447200.0
2011-04-07	MSFT	Stock	26.19	26.26	25.97	26.2	46134700.0
2011-04-07	NVDA	Stock	0.4375	0.4552	0.4358	0.4525	1021208000.0
2011-04-07	AMZN	Stock	9.139	9.2585	9.088	9.2455	91280000.0
2011-04-07	TSLA	Stock	1.79	1.8627	1.7633	1.816	42154500.0
2011-04-07	TLT	Stock	90.53	90.76	90.13	90.36	9266180.0
2011-04-07	ES	Stock	34.75	34.83	34.41	34.58	1381900.0
2011-04-07	CL	Stock	40.82	40.845	40.5	40.78	4862400.0
2011-04-07	A	Stock	32.3534	32.5036	31.6595	32.0959	2939155.0
2011-04-07	AABA-DELISTED	Stock	16.91	17.1	16.785	17.0	12104860.0
2011-04-07	AACC-DELISTED	Stock	5.4	5.4	5.28	5.3	5840.0
2011-04-07	AACG	Stock	7.77	7.98	7.77	7.98	20500.0
2011-04-07	AAI-DELISTED	Stock	7.44	7.44	7.38	7.38	2288531.0
2011-04-07	AAIC-DELISTED	Stock	30.35	30.53	30.0	30.08	32268.0
2011-04-07	AAME	Stock	2.12	2.12	2.0	2.08	14300.0
2011-04-07	AAON	Stock	6.4909	6.5659	6.4375	6.4415	187819.0
2011-04-07	AAP	Stock	67.48	67.81	66.27	67.3	617400.0
2011-04-07	AAT	Stock	21.89	21.89	21.29	21.53	218700.0
2011-04-07	AATI-DELISTED	Stock	3.81	3.83	3.66	3.72	207323.0
2011-04-07	AAU-DELISTED	Stock	4.75	5.14	4.6471	4.7632	1907073.0
2011-04-07	AAUAF-DELISTED	Stock	4.76	5.15	4.66	4.75	1902786.0
2011-04-07	AAV-DELISTED	Stock	9.1	9.1	8.83	8.94	389920.0
2011-04-07	AAWW-DELISTED	Stock	67.5	67.84	66.03	66.5	217313.0
2011-04-07	AAXJ	Stock	64.92	65.04	64.44	64.67	336215.0
2011-04-07	AAXN-DELISTED	Stock	4.05	4.11	4.01	4.03	198310.0
2011-04-07	AB	Stock	22.61	22.7	22.43	22.53	234400.0
2011-04-07	ABAC-DELISTED	Stock	4.0	4.0899	3.85	3.8601	45872.0
2011-04-07	ABAX-DELISTED	Stock	30.24	30.78	29.96	29.97	85720.0
2011-04-07	ABB-DELISTED	Stock	24.2	24.33	24.14	24.29	2152613.0
2011-04-07	ABBC-DELISTED	Stock	12.75	12.9699	12.71	12.77	63892.0
2011-04-07	ABBNY-DELISTED	Stock	24.2	24.33	24.14	24.29	2158113.0
2011-04-07	ABC-DELISTED	Stock	40.21	40.625	40.074	40.58	1832800.0
2011-04-07	ABCB	Stock	10.11	10.11	9.86	9.95	9500.0
2011-04-07	ABCD-DELISTED	Stock	3.35	3.35	3.3	3.35	6051.0
2011-04-07	ABCO-DELISTED	Stock	25.17	25.17	24.86	24.86	96544.0
2011-04-07	ABCW-DELISTED	Stock	0.85	0.93	0.82	0.93	62200.0
2011-04-07	ABD-DELISTED	Stock	10.295	10.385	9.935	9.945	267670.0
2011-04-07	ABE-DELISTED	Stock	19.1	19.12	19.03	19.0899	3796.0
2011-04-07	ABEO	Stock	2562.5	2725.0	2562.5	2725.0	2.0
2011-04-07	ABFS-DELISTED	Stock	26.11	26.42	26.0	26.09	322701.0
2011-04-07	ABG	Stock	18.76	19.32	18.64	18.96	249600.0
2011-04-07	ABH-DELISTED	Stock	27.67	27.9397	27.38	27.47	201721.0
2011-04-07	ABM	Stock	25.65	25.78	25.38	25.46	154100.0
2011-04-07	ABMD-DELISTED	Stock	15.54	15.68	15.17	15.32	388019.0
2011-04-07	ABR	Stock	5.44	5.6	5.44	5.6	32100.0
2011-04-07	ABT	Stock	24.2539	24.3019	24.0572	24.2251	12180492.0
2011-04-07	ABTL-DELISTED	Stock	6.65	6.9	6.3	6.9	56646.0
2011-04-07	ABUS	Stock	3.1	3.2	3.03	3.03	24400.0
2011-04-07	ABV-DELISTED	Stock	29.32	29.46	29.04	29.24	1783047.0
2011-04-07	ABVA-DELISTED	Stock	5.14	5.4	5.1	5.15	7519.0

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

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