PREVIEW / stock_daily / 2015-01-02

all stock daily files

  file:    by_date/stock_daily/2015/2015-01-02.parquet
  size:    220 KB
  rows:    6,590
  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
2015-01-02	AAPL	Stock	27.8475	27.86	26.8375	27.3325	212818400.0
2015-01-02	MSFT	Stock	46.66	47.42	46.54	46.76	27913900.0
2015-01-02	NVDA	Stock	0.5032	0.507	0.4952	0.5032	113680000.0
2015-01-02	AMZN	Stock	15.629	15.7375	15.348	15.426	55664000.0
2015-01-02	GOOGL	Stock	26.63	26.79	26.394	26.4775	26557400.0
2015-01-02	META	Stock	78.58	78.93	77.7	78.45	18177500.0
2015-01-02	TSLA	Stock	14.858	14.8833	14.2173	14.6207	71466000.0
2015-01-02	TLT	Stock	126.29	127.66	126.15	127.32	9431997.0
2015-01-02	ES	Stock	53.53	53.8	52.93	53.74	1693400.0
2015-01-02	CL	Stock	69.17	69.26	68.7	69.04	2522800.0
2015-01-02	A	Stock	41.18	41.31	40.37	40.56	1529200.0
2015-01-02	AA.B-DELISTED	Stock	50.6501	51.37	50.6501	51.37	28560.0
2015-01-02	AABA-DELISTED	Stock	50.64	50.78	49.47	50.16	11367221.0
2015-01-02	AAC-DELISTED	Stock	30.87	31.58	29.22	30.25	42187.0
2015-01-02	AACG	Stock	4.64	4.7	4.13	4.7	18900.0
2015-01-02	AAIC-DELISTED	Stock	26.75	26.8	26.36	26.72	204233.0
2015-01-02	AAL	Stock	54.28	54.6	53.07	53.91	10748600.0
2015-01-02	AAMC-DELISTED	Stock	90.5882	102.525	90.5882	96.2294	39287.0
2015-01-02	AAME	Stock	3.99	4.03	3.98	4.03	11400.0
2015-01-02	AAMI	Stock	16.34	16.5	15.91	16.12	60000.0
2015-01-02	AAOI	Stock	11.28	11.28	10.72	10.79	184600.0
2015-01-02	AAON	Stock	15.0333	15.12	14.4	14.62	136050.0
2015-01-02	AAP	Stock	160.85	162.5	157.47	158.56	509800.0
2015-01-02	AAT	Stock	40.12	40.46	39.95	40.37	107500.0
2015-01-02	AAU-DELISTED	Stock	0.95	0.9709	0.931	0.9537	181138.0
2015-01-02	AAUAF-DELISTED	Stock	0.95	0.9747	0.935	0.9525	183900.0
2015-01-02	AAV-DELISTED	Stock	4.71	4.77	4.56	4.68	113607.0
2015-01-02	AAVL-DELISTED	Stock	54.6	59.13	54.0349	58.92	168830.0
2015-01-02	AAWW-DELISTED	Stock	49.71	49.82	47.73	48.42	173160.0
2015-01-02	AAXJ	Stock	61.17	61.17	60.49	60.63	509525.0
2015-01-02	AAXN-DELISTED	Stock	26.7	26.75	25.56	26.51	2179321.0
2015-01-02	AB	Stock	26.15	26.22	25.62	26.1	135200.0
2015-01-02	ABAC-DELISTED	Stock	1.72	1.82	1.72	1.81	10625.0
2015-01-02	ABAX-DELISTED	Stock	57.31	58.25	56.65	57.72	162740.0
2015-01-02	ABB-DELISTED	Stock	21.15	21.21	20.97	21.08	1146026.0
2015-01-02	ABBNY-DELISTED	Stock	21.15	21.21	20.97	21.08	1255486.0
2015-01-02	ABBV	Stock	65.44	66.4	65.44	65.89	5086100.0
2015-01-02	ABC-DELISTED	Stock	90.61	91.32	89.82	90.47	952994.0
2015-01-02	ABCB	Stock	25.83	25.86	24.92	25.27	73300.0
2015-01-02	ABCD-DELISTED	Stock	1.78	1.78	1.76	1.76	300.0
2015-01-02	ABCO-DELISTED	Stock	49.31	49.66	47.52	48.46	207325.0
2015-01-02	ABCW-DELISTED	Stock	34.27	35.0	34.2	34.28	21934.0
2015-01-02	ABDC-DELISTED	Stock	12.54	12.82	12.4	12.4	49921.0
2015-01-02	ABE-DELISTED	Stock	13.19	13.19	12.88	13.0399	21472.0
2015-01-02	ABEO	Stock	84.25	85.0	80.0	85.0	764.0
2015-01-02	ABEV	Stock	6.1	6.11	5.86	5.95	20472500.0
2015-01-02	ABG	Stock	76.59	77.12	74.77	76.09	330800.0
2015-01-02	ABGB-DELISTED	Stock	11.55	11.75	11.55	11.72	47850.0
2015-01-02	ABM	Stock	28.69	28.91	28.19	28.42	171000.0
2015-01-02	ABMD-DELISTED	Stock	38.27	38.51	36.86	37.3	221399.0

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

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