PREVIEW / stock_daily / 2014-04-01

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-01.parquet
  size:    219 KB
  rows:    6,541
  symbols: 3,571

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-04-01	AAPL	Stock	19.2057	19.3525	19.1704	19.3446	200760000.0
2014-04-01	MSFT	Stock	41.15	41.59	41.07	41.42	32605000.0
2014-04-01	NVDA	Stock	0.462	0.4718	0.4565	0.4662	656272000.0
2014-04-01	AMZN	Stock	16.9045	17.2215	16.9	17.1495	72002000.0
2014-04-01	META	Stock	60.46	62.66	60.24	62.62	59291000.0
2014-04-01	TSLA	Stock	13.9347	14.544	13.9053	14.4647	110571000.0
2014-04-01	TLT	Stock	108.26	108.36	107.84	107.89	9067266.0
2014-04-01	ES	Stock	45.51	45.51	44.88	45.11	1762400.0
2014-04-01	CL	Stock	64.87	65.1	64.03	64.22	3089100.0
2014-04-01	A	Stock	40.2003	40.5007	39.9428	40.3147	2922799.0
2014-04-01	AABA-DELISTED	Stock	36.2	36.86	36.15	36.49	14332818.0
2014-04-01	AACG	Stock	4.01	4.12	4.0	4.1	19500.0
2014-04-01	AAIC-DELISTED	Stock	26.48	26.6	26.36	26.5	241198.0
2014-04-01	AAL	Stock	36.95	38.19	36.85	37.94	11064900.0
2014-04-01	AAMC-DELISTED	Stock	319.1176	327.9412	312.7618	326.7647	56957.0
2014-04-01	AAME	Stock	3.62	3.72	3.62	3.63	12100.0
2014-04-01	AAOI	Stock	24.55	24.55	23.68	24.36	405600.0
2014-04-01	AAON	Stock	12.4844	12.7911	12.0667	12.7289	441000.0
2014-04-01	AAP	Stock	126.96	128.49	126.6	127.25	775400.0
2014-04-01	AAT	Stock	33.7	34.22	33.58	34.21	161300.0
2014-04-01	AAU-DELISTED	Stock	1.37	1.44	1.37	1.4299	103205.0
2014-04-01	AAUAF-DELISTED	Stock	1.37	1.44	1.37	1.4299	103716.0
2014-04-01	AAV-DELISTED	Stock	4.96	5.05	4.95	5.02	254267.0
2014-04-01	AAWW-DELISTED	Stock	35.37	35.7	35.08	35.67	254712.0
2014-04-01	AAXJ	Stock	59.66	59.84	59.5775	59.83	379710.0
2014-04-01	AAXN-DELISTED	Stock	18.4	19.17	18.4	18.98	1045671.0
2014-04-01	AB	Stock	25.06	25.41	24.9	25.38	428400.0
2014-04-01	ABAC-DELISTED	Stock	1.88	1.88	1.83	1.83	16900.0
2014-04-01	ABAX-DELISTED	Stock	39.04	39.64	38.5201	39.54	78324.0
2014-04-01	ABB-DELISTED	Stock	26.14	26.21	25.98	26.06	1458730.0
2014-04-01	ABBNY-DELISTED	Stock	26.14	26.21	25.98	26.07	1575781.0
2014-04-01	ABBV	Stock	51.62	52.38	51.54	52.1	4250800.0
2014-04-01	ABC-DELISTED	Stock	65.6	65.92	65.32	65.91	1600081.0
2014-04-01	ABCB	Stock	23.34	23.87	23.13	23.75	146100.0
2014-04-01	ABCD-DELISTED	Stock	2.13	2.2	2.09	2.16	59890.0
2014-04-01	ABCO-DELISTED	Stock	64.51	65.44	64.08	65.02	127574.0
2014-04-01	ABE-DELISTED	Stock	13.28	13.5	13.28	13.45	24705.0
2014-04-01	ABEO	Stock	687.5	712.5	637.5	675.0	46.0
2014-04-01	ABEV	Stock	7.42	7.5	7.41	7.5	6733500.0
2014-04-01	ABFS-DELISTED	Stock	37.21	38.65	36.58	38.49	379172.0
2014-04-01	ABG	Stock	55.56	56.87	55.56	56.51	245300.0
2014-04-01	ABGB-DELISTED	Stock	23.91	24.03	23.7212	23.949	4929.0
2014-04-01	ABIL-DELISTED	Stock	9.64	9.89	9.64	9.71	57321.0
2014-04-01	ABM	Stock	28.56	28.85	28.54	28.83	182800.0
2014-04-01	ABMD-DELISTED	Stock	26.15	26.57	25.93	26.2	1321193.0
2014-04-01	ABR	Stock	6.88	7.02	6.88	7.02	134000.0
2014-04-01	ABR.A-DELISTED	Stock	24.75	24.75	24.63	24.74	2800.0
2014-04-01	ABR.B-DELISTED	Stock	22.9999	23.0	22.999	22.9999	1335.0
2014-04-01	ABR.C-DELISTED	Stock	24.8099	24.85	24.7999	24.8338	2550.0
2014-04-01	ABT	Stock	38.49	38.83	38.23	38.47	5631200.0

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

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