PREVIEW / stock_daily / 2010-07-14

all stock daily files

  file:    by_date/stock_daily/2010/2010-07-14.parquet
  size:    188 KB
  rows:    5,892
  symbols: 3,454

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
2010-07-14	AAPL	Stock	8.9064	9.1357	8.8929	9.0261	812047600.0
2010-07-14	MSFT	Stock	25.5	25.61	25.12	25.44	72808100.0
2010-07-14	NVDA	Stock	0.285	0.287	0.2718	0.2758	1355664000.0
2010-07-14	AMZN	Stock	6.1515	6.1875	6.0735	6.165	105140000.0
2010-07-14	TSLA	Stock	1.196	1.3433	1.184	1.3227	62928000.0
2010-07-14	TLT	Stock	98.72	99.49	98.39	99.32	5417267.0
2010-07-14	ES	Stock	27.21	27.3	26.98	27.29	1591800.0
2010-07-14	CL	Stock	41.485	41.68	41.24	41.655	2638200.0
2010-07-14	A	Stock	20.4721	20.9227	20.4435	20.5222	5884462.0
2010-07-14	AABA-DELISTED	Stock	15.36	15.42	15.2	15.37	11591280.0
2010-07-14	AACC-DELISTED	Stock	4.18	4.22	4.08	4.13	13514.0
2010-07-14	AACG	Stock	2.89	3.0	2.81	3.0	5600.0
2010-07-14	AAI-DELISTED	Stock	4.93	5.04	4.91	4.97	2884184.0
2010-07-14	AAIC-DELISTED	Stock	18.95	19.0	18.37	18.6	40009.0
2010-07-14	AAME	Stock	1.34	1.34	1.25	1.25	13400.0
2010-07-14	AAON	Stock	4.6993	4.7249	4.6005	4.7091	207562.0
2010-07-14	AAP	Stock	52.69	52.99	52.26	52.6	926300.0
2010-07-14	AATI-DELISTED	Stock	3.25	3.4325	3.25	3.37	158801.0
2010-07-14	AAU-DELISTED	Stock	0.89	0.91	0.89	0.89	18075.0
2010-07-14	AAUAF-DELISTED	Stock	0.89	0.91	0.89	0.89	20575.0
2010-07-14	AAV-DELISTED	Stock	6.32	6.44	6.29	6.37	437471.0
2010-07-14	AAWW-DELISTED	Stock	55.72	57.8489	55.39	56.98	706314.0
2010-07-14	AAXJ	Stock	54.87	55.2095	54.77	55.04	647833.0
2010-07-14	AAXN-DELISTED	Stock	4.0	4.02	3.82	3.82	422745.0
2010-07-14	AB	Stock	28.77	28.81	28.16	28.49	206900.0
2010-07-14	ABAX-DELISTED	Stock	20.11	20.17	19.0	19.13	326345.0
2010-07-14	ABB-DELISTED	Stock	18.45	18.69	18.41	18.6	1852318.0
2010-07-14	ABBC-DELISTED	Stock	9.18	9.235	8.99	9.01	34908.0
2010-07-14	ABBNY-DELISTED	Stock	18.45	18.69	18.41	18.63	1880947.0
2010-07-14	ABC-DELISTED	Stock	32.23	32.855	32.05	32.77	2989640.0
2010-07-14	ABCB	Stock	10.48	10.55	10.36	10.47	29800.0
2010-07-14	ABCD-DELISTED	Stock	3.66	3.66	3.54	3.56	26620.0
2010-07-14	ABCO-DELISTED	Stock	21.15	21.2	20.65	20.98	117570.0
2010-07-14	ABCW-DELISTED	Stock	0.48	0.55	0.4699	0.5	85120.0
2010-07-14	ABD-DELISTED	Stock	5.67	5.76	5.55	5.6	265760.0
2010-07-14	ABE-DELISTED	Stock	16.71	16.75	16.63	16.738	4585.0
2010-07-14	ABEO	Stock	2375.0	2375.0	2275.0	2375.0	44.0
2010-07-14	ABFS-DELISTED	Stock	22.34	22.66	22.04	22.38	244699.0
2010-07-14	ABG	Stock	10.82	11.19	10.65	11.08	194300.0
2010-07-14	ABII-DELISTED	Stock	74.65	75.0	74.64	74.85	36145.0
2010-07-14	ABK-DELISTED	Stock	0.7192	0.75	0.7061	0.749	9453936.0
2010-07-14	ABM	Stock	21.89	21.89	21.46	21.64	154300.0
2010-07-14	ABMD-DELISTED	Stock	10.92	11.22	10.74	11.13	163422.0
2010-07-14	ABR	Stock	5.72	6.05	5.72	5.97	87900.0
2010-07-14	ABT	Stock	22.8049	22.9632	22.6322	22.9584	11571697.0
2010-07-14	ABTL-DELISTED	Stock	5.95	5.95	5.8	5.85	21032.0
2010-07-14	ABV-DELISTED	Stock	105.18	106.14	104.66	105.64	347153.0
2010-07-14	ABVA-DELISTED	Stock	2.8	2.8	2.53	2.53	250.0
2010-07-14	ABVT-DELISTED	Stock	48.72	49.06	48.47	48.88	82768.0
2010-07-14	ABX-DELISTED	Stock	43.38	43.77	42.74	43.0	7450022.0

> showing 50 of 5,892 rows — these rows as CSV

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