PREVIEW / stock_daily / 2013-03-11

all stock daily files

  file:    by_date/stock_daily/2013/2013-03-11.parquet
  size:    207 KB
  rows:    6,271
  symbols: 3,487

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-11	AAPL	Stock	15.3482	15.6789	15.1836	15.6382	474236000.0
2013-03-11	MSFT	Stock	27.94	27.97	27.67	27.87	36627500.0
2013-03-11	NVDA	Stock	0.3173	0.3188	0.3148	0.3175	299748000.0
2013-03-11	AMZN	Stock	13.6715	13.6995	13.52	13.562	38098000.0
2013-03-11	META	Stock	28.01	28.64	27.83	28.14	35642100.0
2013-03-11	TSLA	Stock	2.5913	2.6293	2.5767	2.6067	23692500.0
2013-03-11	TLT	Stock	115.12	115.228	114.74	114.86	5816048.0
2013-03-11	ES	Stock	42.16	42.44	42.13	42.41	914600.0
2013-03-11	CL	Stock	57.915	57.98	57.62	57.82	2661000.0
2013-03-11	A	Stock	30.7511	30.7654	29.8498	30.6223	7650835.0
2013-03-11	AABA-DELISTED	Stock	22.77	23.0	22.57	22.6	16385261.0
2013-03-11	AACC-DELISTED	Stock	6.53	6.56	6.45	6.53	576215.0
2013-03-11	AACG	Stock	3.93	4.04	3.93	4.0	7800.0
2013-03-11	AAIC-DELISTED	Stock	25.47	25.79	25.46	25.73	536179.0
2013-03-11	AAMC-DELISTED	Stock	37.9412	38.8235	37.9412	37.9853	5100.0
2013-03-11	AAME	Stock	3.36	3.4	3.16	3.4	19100.0
2013-03-11	AAMRQ-DELISTED	Stock	3.115	3.32	3.11	3.25	9032495.0
2013-03-11	AAON	Stock	7.3867	7.4667	7.3659	7.4311	197775.0
2013-03-11	AAP	Stock	76.88	78.06	76.84	77.53	689400.0
2013-03-11	AAT	Stock	31.53	32.02	31.39	31.9	135600.0
2013-03-11	AAU-DELISTED	Stock	2.17	2.1927	2.14	2.145	115303.0
2013-03-11	AAUAF-DELISTED	Stock	2.18	2.1978	2.14	2.14	116853.0
2013-03-11	AAV-DELISTED	Stock	3.08	3.11	3.03	3.06	1407877.0
2013-03-11	AAWW-DELISTED	Stock	43.52	44.18	43.17	43.77	235866.0
2013-03-11	AAXJ	Stock	60.4	60.52	60.27	60.39	625801.0
2013-03-11	AAXN-DELISTED	Stock	7.84	7.9	7.75	7.87	445971.0
2013-03-11	AB	Stock	22.78	22.78	22.27	22.44	197900.0
2013-03-11	ABAC-DELISTED	Stock	0.8	0.81	0.76	0.76	19742.0
2013-03-11	ABAX-DELISTED	Stock	45.11	46.6	45.11	45.86	356515.0
2013-03-11	ABB-DELISTED	Stock	22.72	22.88	22.68	22.88	900752.0
2013-03-11	ABBNY-DELISTED	Stock	22.72	22.88	22.68	22.88	971209.0
2013-03-11	ABBV	Stock	37.25	38.15	37.08	37.67	4614400.0
2013-03-11	ABC-DELISTED	Stock	48.36	48.74	48.29	48.56	1411207.0
2013-03-11	ABCB	Stock	14.43	14.6	14.27	14.48	60900.0
2013-03-11	ABCD-DELISTED	Stock	1.14	1.14	1.1	1.11	5350.0
2013-03-11	ABCO-DELISTED	Stock	51.89	52.57	51.26	51.95	225964.0
2013-03-11	ABCW-DELISTED	Stock	0.63	0.63	0.56	0.56	3000.0
2013-03-11	ABE-DELISTED	Stock	21.63	21.65	21.3401	21.63	6997.0
2013-03-11	ABEO	Stock	612.5	675.0	612.5	650.0	4.0
2013-03-11	ABFS-DELISTED	Stock	11.8	11.97	11.8	11.855	107058.0
2013-03-11	ABG	Stock	36.12	36.8	35.98	36.61	502000.0
2013-03-11	ABM	Stock	21.86	22.02	21.72	21.83	326100.0
2013-03-11	ABMD-DELISTED	Stock	16.92	17.53	16.9	17.48	494402.0
2013-03-11	ABR	Stock	8.2	8.39	8.17	8.36	158000.0
2013-03-11	ABR.A-DELISTED	Stock	25.43	25.5	25.43	25.5	6785.0
2013-03-11	ABT	Stock	34.59	34.95	34.52	34.93	4903400.0
2013-03-11	ABTL-DELISTED	Stock	4.29	4.29	4.13	4.2	7640.0
2013-03-11	ABUS	Stock	4.42	4.42	4.33	4.38	39100.0
2013-03-11	ABV-DELISTED	Stock	45.59	45.65	45.25	45.38	1324698.0
2013-03-11	ABX-DELISTED	Stock	28.9	29.08	28.51	28.87	7037946.0

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

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