PREVIEW / stock_daily / 2013-03-28

all stock daily files

  file:    by_date/stock_daily/2013/2013-03-28.parquet
  size:    209 KB
  rows:    6,300
  symbols: 3,512

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
2013-03-28	AAPL	Stock	16.065	16.1364	15.7721	15.8093	442839600.0
2013-03-28	MSFT	Stock	28.32	28.66	28.26	28.61	55453800.0
2013-03-28	NVDA	Stock	0.3155	0.321	0.3133	0.3208	349276000.0
2013-03-28	AMZN	Stock	13.291	13.369	13.203	13.3245	49474000.0
2013-03-28	META	Stock	26.09	26.17	25.52	25.58	28585700.0
2013-03-28	TSLA	Stock	2.5487	2.5493	2.5167	2.526	17380500.0
2013-03-28	TLT	Stock	118.12	118.45	117.68	117.76	5826335.0
2013-03-28	ES	Stock	42.99	43.49	42.92	43.46	2006000.0
2013-03-28	CL	Stock	58.555	59.225	58.14	59.015	3380000.0
2013-03-28	A	Stock	30.1001	30.1001	29.6853	30.0215	3002904.0
2013-03-28	AABA-DELISTED	Stock	23.63	23.77	23.45	23.52	17518406.0
2013-03-28	AACC-DELISTED	Stock	6.57	6.83	6.57	6.74	244948.0
2013-03-28	AAIC-DELISTED	Stock	25.5	25.81	25.38	25.81	567388.0
2013-03-28	AAMC-DELISTED	Stock	39.7059	40.5882	39.7059	39.7059	4770.0
2013-03-28	AAME	Stock	3.24	3.35	3.24	3.33	5400.0
2013-03-28	AAMRQ-DELISTED	Stock	4.16	4.26	4.11	4.15	5453874.0
2013-03-28	AAON	Stock	8.1659	8.3733	8.083	8.1748	411413.0
2013-03-28	AAP	Stock	81.34	83.07	81.29	82.65	1291300.0
2013-03-28	AAT	Stock	32.45	32.54	31.99	32.01	356100.0
2013-03-28	AAU-DELISTED	Stock	2.22	2.22	2.16	2.16	43495.0
2013-03-28	AAUAF-DELISTED	Stock	2.14	2.16	2.08	2.16	45478.0
2013-03-28	AAV-DELISTED	Stock	3.65	3.72	3.54	3.67	1522913.0
2013-03-28	AAWW-DELISTED	Stock	41.03	41.31	40.49	40.71	278554.0
2013-03-28	AAXJ	Stock	58.83	59.12	58.77	59.08	553738.0
2013-03-28	AAXN-DELISTED	Stock	7.97	8.05	7.86	7.95	384515.0
2013-03-28	AB	Stock	21.75	22.04	21.59	21.9	225100.0
2013-03-28	ABAC-DELISTED	Stock	0.71	0.7299	0.7099	0.7299	6700.0
2013-03-28	ABAX-DELISTED	Stock	47.22	47.98	46.83	47.32	162798.0
2013-03-28	ABB-DELISTED	Stock	22.65	22.77	22.5399	22.76	1612898.0
2013-03-28	ABBNY-DELISTED	Stock	22.65	22.77	22.5399	22.76	1705493.0
2013-03-28	ABBV	Stock	40.26	40.8	39.78	40.78	7263400.0
2013-03-28	ABC-DELISTED	Stock	50.96	51.57	50.795	51.44	2814712.0
2013-03-28	ABCB	Stock	14.46	14.49	14.28	14.35	78900.0
2013-03-28	ABCD-DELISTED	Stock	1.05	1.07	1.02	1.03	36590.0
2013-03-28	ABCO-DELISTED	Stock	52.48	52.9	51.93	52.52	129430.0
2013-03-28	ABCW-DELISTED	Stock	0.7	0.7	0.67	0.67	17512.0
2013-03-28	ABE-DELISTED	Stock	20.98	21.08	20.87	21.08	5849.0
2013-03-28	ABEO	Stock	525.0	612.5	512.5	612.5	98.0
2013-03-28	ABFS-DELISTED	Stock	11.77	11.83	11.67	11.68	145601.0
2013-03-28	ABG	Stock	36.93	36.94	36.26	36.69	247400.0
2013-03-28	ABM	Stock	22.04	22.28	21.96	22.24	162500.0
2013-03-28	ABMD-DELISTED	Stock	18.74	18.92	18.47	18.66	324079.0
2013-03-28	ABR	Stock	7.83	7.86	7.77	7.84	516600.0
2013-03-28	ABR.A-DELISTED	Stock	25.81	26.35	25.75	25.75	6925.0
2013-03-28	ABT	Stock	34.6	35.34	34.53	35.32	11468200.0
2013-03-28	ABTL-DELISTED	Stock	4.33	4.34	4.1782	4.34	17085.0
2013-03-28	ABUS	Stock	4.65	4.76	4.65	4.71	128700.0
2013-03-28	ABV-DELISTED	Stock	41.84	42.36	41.585	42.34	2158335.0
2013-03-28	ABX-DELISTED	Stock	29.19	29.46	29.02	29.41	4808946.0
2013-03-28	ACAD	Stock	8.05	8.19	7.9	7.94	2044100.0

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

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