PREVIEW / stock_daily / 2013-09-12

all stock daily files

  file:    by_date/stock_daily/2013/2013-09-12.parquet
  size:    212 KB
  rows:    6,367
  symbols: 3,522

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-09-12	AAPL	Stock	16.7321	16.9786	16.6432	16.8818	404051200.0
2013-09-12	MSFT	Stock	32.72	32.78	32.59	32.69	32860200.0
2013-09-12	NVDA	Stock	0.3908	0.3975	0.3908	0.3925	303808000.0
2013-09-12	AMZN	Stock	14.9695	15.1	14.883	14.943	32124000.0
2013-09-12	META	Stock	45.53	45.62	44.65	44.75	68072300.0
2013-09-12	TSLA	Stock	10.9333	11.1173	10.7007	10.9953	92400000.0
2013-09-12	TLT	Stock	103.85	104.0	103.06	103.15	6254696.0
2013-09-12	ES	Stock	40.48	40.61	40.01	40.09	1178300.0
2013-09-12	CL	Stock	59.11	59.38	58.92	59.28	1737700.0
2013-09-12	A	Stock	34.9785	35.0072	34.6853	34.7783	2052963.0
2013-09-12	AABA-DELISTED	Stock	29.72	30.27	29.5	29.65	21670730.0
2013-09-12	AACG	Stock	4.98	4.98	4.88	4.88	1500.0
2013-09-12	AAIC-DELISTED	Stock	24.59	24.7079	24.48	24.49	90990.0
2013-09-12	AAMC-DELISTED	Stock	103.5294	106.7647	103.5294	103.5294	3400.0
2013-09-12	AAME	Stock	3.86	3.94	3.79	3.94	7600.0
2013-09-12	AAMRQ-DELISTED	Stock	3.52	3.76	3.52	3.65	10317007.0
2013-09-12	AAON	Stock	11.2	11.3422	11.12	11.1289	94725.0
2013-09-12	AAP	Stock	81.33	81.5	80.04	80.37	380100.0
2013-09-12	AAT	Stock	30.09	30.31	29.86	29.93	176900.0
2013-09-12	AAU-DELISTED	Stock	1.54	1.55	1.46	1.48	247276.0
2013-09-12	AAUAF-DELISTED	Stock	1.54	1.55	1.46	1.48	247676.0
2013-09-12	AAV-DELISTED	Stock	3.91	3.94	3.825	3.86	88340.0
2013-09-12	AAWW-DELISTED	Stock	48.52	48.79	47.04	47.09	125479.0
2013-09-12	AAXJ	Stock	58.58	58.67	58.045	58.09	969890.0
2013-09-12	AAXN-DELISTED	Stock	12.45	12.4799	12.21	12.26	657803.0
2013-09-12	AB	Stock	20.19	20.3	19.9	19.95	186100.0
2013-09-12	ABAC-DELISTED	Stock	0.86	0.8601	0.7801	0.81	14700.0
2013-09-12	ABAX-DELISTED	Stock	41.54	41.54	40.41	40.94	61691.0
2013-09-12	ABB-DELISTED	Stock	22.98	23.15	22.955	23.05	832084.0
2013-09-12	ABBNY-DELISTED	Stock	22.98	23.15	22.955	23.04	845520.0
2013-09-12	ABBV	Stock	44.84	44.95	44.5	44.7	2597900.0
2013-09-12	ABC-DELISTED	Stock	60.42	61.02	60.37	60.46	1422681.0
2013-09-12	ABCB	Stock	19.21	19.29	18.8	18.82	15400.0
2013-09-12	ABCD-DELISTED	Stock	1.597	1.5999	1.46	1.46	2500.0
2013-09-12	ABCO-DELISTED	Stock	58.62	59.07	57.43	58.17	70576.0
2013-09-12	ABE-DELISTED	Stock	19.06	19.62	19.06	19.6	14249.0
2013-09-12	ABEO	Stock	400.0	475.0	400.0	475.0	57.0
2013-09-12	ABFS-DELISTED	Stock	27.83	28.1	27.36	27.57	592964.0
2013-09-12	ABG	Stock	53.23	53.39	51.88	52.63	185200.0
2013-09-12	ABM	Stock	25.67	25.76	25.5	25.66	108800.0
2013-09-12	ABMD-DELISTED	Stock	23.01	23.21	22.62	22.68	386305.0
2013-09-12	ABR	Stock	7.2	7.23	7.07	7.12	39100.0
2013-09-12	ABR.A-DELISTED	Stock	24.4	24.4	24.04	24.4	2400.0
2013-09-12	ABR.B-DELISTED	Stock	23.6999	23.6999	23.66	23.69	2400.0
2013-09-12	ABT	Stock	34.76	34.91	34.59	34.76	7105600.0
2013-09-12	ABTL-DELISTED	Stock	7.35	7.4	7.25	7.27	42031.0
2013-09-12	ABUS	Stock	5.52	5.63	5.43	5.43	49300.0
2013-09-12	ABV-DELISTED	Stock	37.14	37.18	36.665	37.09	2833035.0
2013-09-12	ABX-DELISTED	Stock	17.9	18.04	17.57	17.62	18439928.0
2013-09-12	ACAD	Stock	22.94	23.35	22.64	22.71	1258900.0

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

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