PREVIEW / stock_daily / 2013-06-04

all stock daily files

  file:    by_date/stock_daily/2013/2013-06-04.parquet
  size:    210 KB
  rows:    6,336
  symbols: 3,519

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-06-04	AAPL	Stock	16.1864	16.2296	15.9782	16.0468	292728800.0
2013-06-04	MSFT	Stock	35.62	35.74	34.77	34.99	65529500.0
2013-06-04	NVDA	Stock	0.3635	0.37	0.3595	0.3618	363676000.0
2013-06-04	AMZN	Stock	13.35	13.444	13.151	13.285	41772000.0
2013-06-04	META	Stock	23.89	23.93	23.32	23.52	34760800.0
2013-06-04	TSLA	Stock	6.1833	6.428	6.16	6.3227	132841500.0
2013-06-04	TLT	Stock	113.96	114.49	113.66	113.72	7504245.0
2013-06-04	ES	Stock	41.76	41.82	41.24	41.54	1488800.0
2013-06-04	CL	Stock	58.8	59.22	58.24	58.87	3066800.0
2013-06-04	A	Stock	33.0329	33.226	32.4607	32.4893	4703152.0
2013-06-04	AABA-DELISTED	Stock	26.46	26.565	25.97	26.25	13206799.0
2013-06-04	AACC-DELISTED	Stock	6.87	6.91	6.83	6.91	406744.0
2013-06-04	AACG	Stock	4.3	4.46	4.3	4.32	2500.0
2013-06-04	AAIC-DELISTED	Stock	27.5	27.58	27.24	27.32	115927.0
2013-06-04	AAMC-DELISTED	Stock	75.0	75.0	68.9706	70.0	15807.0
2013-06-04	AAME	Stock	3.95	3.97	3.95	3.96	5400.0
2013-06-04	AAMRQ-DELISTED	Stock	5.18	5.47	5.18	5.27	4208134.0
2013-06-04	AAON	Stock	9.5467	9.68	9.4637	9.5348	1304438.0
2013-06-04	AAP	Stock	82.39	83.39	81.88	81.99	548800.0
2013-06-04	AAT	Stock	32.71	32.78	31.78	31.81	358800.0
2013-06-04	AAU-DELISTED	Stock	1.8	1.86	1.72	1.75	95698.0
2013-06-04	AAUAF-DELISTED	Stock	1.8	1.86	1.72	1.75	95898.0
2013-06-04	AAV-DELISTED	Stock	4.18	4.25	4.16	4.18	153541.0
2013-06-04	AAWW-DELISTED	Stock	46.12	46.73	45.44	45.85	251873.0
2013-06-04	AAXJ	Stock	58.81	58.93	58.281	58.47	514800.0
2013-06-04	AAXN-DELISTED	Stock	9.51	9.59	9.39	9.48	536389.0
2013-06-04	AB	Stock	24.75	25.18	24.25	24.31	297300.0
2013-06-04	ABAC-DELISTED	Stock	0.61	0.6201	0.57	0.6	40004.0
2013-06-04	ABAX-DELISTED	Stock	44.76	44.98	44.09	44.6	121139.0
2013-06-04	ABB-DELISTED	Stock	22.16	22.21	21.92	22.07	1487690.0
2013-06-04	ABBNY-DELISTED	Stock	22.16	22.21	21.92	22.07	1742274.0
2013-06-04	ABBV	Stock	43.42	44.47	43.38	43.63	4528400.0
2013-06-04	ABC-DELISTED	Stock	52.73	53.4	52.69	53.24	2691322.0
2013-06-04	ABCB	Stock	16.87	16.88	16.1	16.5	97400.0
2013-06-04	ABCD-DELISTED	Stock	1.4	1.453	1.2924	1.4	24168.0
2013-06-04	ABCO-DELISTED	Stock	52.31	52.66	51.68	52.12	204421.0
2013-06-04	ABCW-DELISTED	Stock	0.62	0.65	0.57	0.61	14875.0
2013-06-04	ABE-DELISTED	Stock	21.52	21.59	21.16	21.5	13023.0
2013-06-04	ABEO	Stock	625.0	675.0	600.0	675.0	15.0
2013-06-04	ABFS-DELISTED	Stock	18.83	19.1	18.35	18.7	438229.0
2013-06-04	ABG	Stock	41.27	41.79	41.13	41.4	340000.0
2013-06-04	ABM	Stock	25.52	26.38	24.93	25.44	816500.0
2013-06-04	ABMD-DELISTED	Stock	21.82	21.92	20.95	21.11	372415.0
2013-06-04	ABR	Stock	6.86	6.9	6.78	6.86	402500.0
2013-06-04	ABR.A-DELISTED	Stock	24.85	24.9	24.8	24.879	1973.0
2013-06-04	ABR.B-DELISTED	Stock	24.59	24.7	24.5799	24.68	1400.0
2013-06-04	ABT	Stock	37.06	37.21	36.53	36.8	6066400.0
2013-06-04	ABTL-DELISTED	Stock	4.94	4.94	4.7	4.82	12299.0
2013-06-04	ABUS	Stock	4.88	4.94	4.82	4.88	32400.0
2013-06-04	ABV-DELISTED	Stock	38.19	38.265	37.08	37.34	4959057.0

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

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