PREVIEW / stock_daily / 2013-03-25

all stock daily files

  file:    by_date/stock_daily/2013/2013-03-25.parquet
  size:    207 KB
  rows:    6,277
  symbols: 3,492

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-25	AAPL	Stock	16.5961	16.7839	16.4921	16.5564	501135600.0
2013-03-25	MSFT	Stock	28.3	28.35	27.96	28.16	44154000.0
2013-03-25	NVDA	Stock	0.3138	0.314	0.308	0.3103	362076000.0
2013-03-25	AMZN	Stock	12.929	12.9715	12.725	12.801	50278000.0
2013-03-25	META	Stock	25.75	25.8	25.08	25.13	39199000.0
2013-03-25	TSLA	Stock	2.4733	2.568	2.4513	2.502	35682000.0
2013-03-25	TLT	Stock	116.77	117.78	116.67	117.22	5839792.0
2013-03-25	ES	Stock	42.78	43.05	42.38	42.54	1135000.0
2013-03-25	CL	Stock	57.385	57.545	57.05	57.2	3294600.0
2013-03-25	A	Stock	29.6781	29.7926	29.1774	29.4206	3911045.0
2013-03-25	AABA-DELISTED	Stock	23.39	23.88	23.305	23.38	22895339.0
2013-03-25	AACC-DELISTED	Stock	6.56	6.56	6.4805	6.5	164991.0
2013-03-25	AACG	Stock	4.01	4.01	3.98	3.98	2500.0
2013-03-25	AAIC-DELISTED	Stock	25.81	26.07	25.66	25.79	674936.0
2013-03-25	AAMC-DELISTED	Stock	39.7059	39.7059	39.7059	39.7059	1581.0
2013-03-25	AAME	Stock	3.39	3.39	3.35	3.35	3600.0
2013-03-25	AAMRQ-DELISTED	Stock	4.3	4.31	3.8	4.03	10750434.0
2013-03-25	AAON	Stock	8.1481	8.2667	8.0504	8.08	253800.0
2013-03-25	AAP	Stock	79.83	80.94	79.33	80.53	1150900.0
2013-03-25	AAT	Stock	32.25	32.31	32.02	32.22	76200.0
2013-03-25	AAU-DELISTED	Stock	2.2	2.2504	2.2	2.21	63736.0
2013-03-25	AAUAF-DELISTED	Stock	2.2	2.2199	2.18	2.21	67077.0
2013-03-25	AAV-DELISTED	Stock	3.46	3.52	3.35	3.48	508544.0
2013-03-25	AAWW-DELISTED	Stock	42.09	42.76	41.305	41.82	170043.0
2013-03-25	AAXJ	Stock	58.36	58.559	57.88	58.09	620539.0
2013-03-25	AAXN-DELISTED	Stock	8.16	8.2	7.95	8.02	457307.0
2013-03-25	AB	Stock	21.93	22.24	21.29	21.38	273600.0
2013-03-25	ABAC-DELISTED	Stock	0.67	0.72	0.67	0.7021	9165.0
2013-03-25	ABAX-DELISTED	Stock	46.86	47.37	46.56	47.0	152444.0
2013-03-25	ABB-DELISTED	Stock	22.76	22.82	22.39	22.5	1418549.0
2013-03-25	ABBNY-DELISTED	Stock	22.76	22.82	22.39	22.51	1435783.0
2013-03-25	ABBV	Stock	39.12	39.52	38.93	39.32	6065000.0
2013-03-25	ABC-DELISTED	Stock	49.95	50.95	49.84	50.59	3189520.0
2013-03-25	ABCB	Stock	14.33	14.49	14.17	14.39	53200.0
2013-03-25	ABCD-DELISTED	Stock	1.01	1.04	1.01	1.025	30500.0
2013-03-25	ABCO-DELISTED	Stock	51.36	51.48	50.8	51.11	187910.0
2013-03-25	ABCW-DELISTED	Stock	0.62	0.65	0.6	0.65	17272.0
2013-03-25	ABE-DELISTED	Stock	20.73	20.91	20.66	20.69	1905.0
2013-03-25	ABEO	Stock	662.5	662.5	625.0	625.0	64.0
2013-03-25	ABFS-DELISTED	Stock	11.9	12.08	11.68	11.88	180580.0
2013-03-25	ABG	Stock	37.11	37.64	36.75	36.98	256700.0
2013-03-25	ABM	Stock	22.02	22.15	21.86	22.04	132600.0
2013-03-25	ABMD-DELISTED	Stock	17.75	17.97	17.63	17.94	315799.0
2013-03-25	ABR	Stock	7.75	7.83	7.64	7.67	1003400.0
2013-03-25	ABR.A-DELISTED	Stock	25.83	25.83	25.53	25.61	9494.0
2013-03-25	ABT	Stock	33.76	34.08	33.57	33.8	7022200.0
2013-03-25	ABTL-DELISTED	Stock	4.21	4.25	4.17	4.25	24713.0
2013-03-25	ABUS	Stock	4.75	4.8	4.67	4.71	119300.0
2013-03-25	ABV-DELISTED	Stock	42.29	42.82	41.43	41.51	2118307.0
2013-03-25	ABX-DELISTED	Stock	29.28	29.45	28.86	29.02	6386290.0

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

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