PREVIEW / stock_daily / 2014-01-09

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-09.parquet
  size:    217 KB
  rows:    6,444
  symbols: 3,524

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
2014-01-09	AAPL	Stock	19.5286	19.5307	19.1196	19.1614	279148800.0
2014-01-09	MSFT	Stock	35.88	35.91	35.4	35.53	36516300.0
2014-01-09	NVDA	Stock	0.4028	0.4035	0.3925	0.3938	292172000.0
2014-01-09	AMZN	Stock	20.1855	20.3445	19.922	20.0505	42060000.0
2014-01-09	META	Stock	58.65	58.96	56.65	57.22	92253300.0
2014-01-09	TSLA	Stock	10.1667	10.2287	9.79	9.8353	80730000.0
2014-01-09	TLT	Stock	102.97	103.205	102.51	103.18	6991080.0
2014-01-09	ES	Stock	41.75	41.98	41.44	41.92	2354100.0
2014-01-09	CL	Stock	64.13	65.28	63.8	65.02	4826400.0
2014-01-09	A	Stock	41.774	41.9742	41.3948	41.7811	2457125.0
2014-01-09	AABA-DELISTED	Stock	41.35	41.35	40.61	40.92	12408045.0
2014-01-09	AACG	Stock	4.05	4.09	4.0	4.0	19300.0
2014-01-09	AAIC-DELISTED	Stock	26.44	26.44	26.1	26.2	98131.0
2014-01-09	AAL	Stock	28.24	29.6	28.2	29.42	26049300.0
2014-01-09	AAMC-DELISTED	Stock	273.3765	291.1765	273.3765	289.4132	20230.0
2014-01-09	AAME	Stock	4.02	4.06	3.99	4.03	8300.0
2014-01-09	AAOI	Stock	14.65	14.65	14.01	14.16	42600.0
2014-01-09	AAON	Stock	14.2133	14.2133	13.8133	14.0311	484200.0
2014-01-09	AAP	Stock	113.06	114.22	112.71	113.55	486800.0
2014-01-09	AAT	Stock	31.54	31.54	30.76	31.27	143900.0
2014-01-09	AAU-DELISTED	Stock	1.22	1.2595	1.2003	1.22	40993.0
2014-01-09	AAUAF-DELISTED	Stock	1.23	1.2698	1.2101	1.22	41202.0
2014-01-09	AAV-DELISTED	Stock	4.5	4.5	4.22	4.26	165671.0
2014-01-09	AAWW-DELISTED	Stock	41.1	42.01	40.74	41.91	288567.0
2014-01-09	AAXJ	Stock	57.77	58.01	57.29	57.71	956787.0
2014-01-09	AAXN-DELISTED	Stock	17.97	18.12	17.4201	17.79	1195827.0
2014-01-09	AB	Stock	21.9	22.25	21.88	22.05	247800.0
2014-01-09	ABAC-DELISTED	Stock	2.11	2.15	2.02	2.06	61426.0
2014-01-09	ABAX-DELISTED	Stock	42.27	42.514	41.65	42.13	162991.0
2014-01-09	ABB-DELISTED	Stock	25.93	26.04	25.77	25.93	1637756.0
2014-01-09	ABBNY-DELISTED	Stock	25.93	26.04	25.77	25.94	1778316.0
2014-01-09	ABBV	Stock	50.59	51.65	49.87	51.22	6960300.0
2014-01-09	ABC-DELISTED	Stock	71.45	71.92	71.1	71.38	1447819.0
2014-01-09	ABCB	Stock	20.68	20.72	20.36	20.55	39300.0
2014-01-09	ABCD-DELISTED	Stock	2.17	2.32	2.1	2.14	102826.0
2014-01-09	ABCO-DELISTED	Stock	62.17	62.94	60.96	61.345	145700.0
2014-01-09	ABE-DELISTED	Stock	13.68	13.6899	13.5	13.62	13510.0
2014-01-09	ABEO	Stock	375.0	375.0	312.5	375.0	85.0
2014-01-09	ABEV	Stock	7.22	7.23	7.06	7.08	16323000.0
2014-01-09	ABFS-DELISTED	Stock	33.4	33.93	32.49	33.45	505785.0
2014-01-09	ABG	Stock	52.15	52.52	51.65	51.87	128200.0
2014-01-09	ABGB-DELISTED	Stock	15.49	15.745	15.33	15.6	24172.0
2014-01-09	ABM	Stock	28.39	28.57	28.22	28.45	158600.0
2014-01-09	ABMD-DELISTED	Stock	28.22	29.72	27.84	29.53	391417.0
2014-01-09	ABR	Stock	6.81	6.87	6.75	6.76	41600.0
2014-01-09	ABR.A-DELISTED	Stock	24.42	24.45	24.06	24.4	5378.0
2014-01-09	ABR.B-DELISTED	Stock	22.59	22.6	22.41	22.5999	3166.0
2014-01-09	ABT	Stock	39.27	39.34	38.97	39.27	4996800.0
2014-01-09	ABTL-DELISTED	Stock	15.25	15.25	14.27	14.47	121815.0
2014-01-09	ABUS	Stock	8.64	9.51	8.5	9.36	484000.0

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

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