PREVIEW / stock_daily / 2010-07-21

all stock daily files

  file:    by_date/stock_daily/2010/2010-07-21.parquet
  size:    188 KB
  rows:    5,927
  symbols: 3,480

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-21	AAPL	Stock	9.4675	9.4696	9.0714	9.08	1185671200.0
2010-07-21	MSFT	Stock	25.6	25.65	24.98	25.12	73297300.0
2010-07-21	NVDA	Stock	0.2705	0.2708	0.2568	0.2592	624940000.0
2010-07-21	AMZN	Stock	6.031	6.0625	5.863	5.8715	100234000.0
2010-07-21	TSLA	Stock	1.3773	1.3933	1.3	1.348	18787500.0
2010-07-21	TLT	Stock	100.45	102.28	100.41	102.03	7894192.0
2010-07-21	ES	Stock	27.68	27.68	27.14	27.27	1044100.0
2010-07-21	CL	Stock	42.055	42.1	41.34	41.515	4568800.0
2010-07-21	A	Stock	19.7997	20.1717	19.6066	19.7282	6225154.0
2010-07-21	AABA-DELISTED	Stock	14.27	14.28	13.75	13.91	76926508.0
2010-07-21	AACC-DELISTED	Stock	4.02	4.07	3.85	3.9	18330.0
2010-07-21	AACG	Stock	3.01	3.1	2.99	3.05	13400.0
2010-07-21	AAI-DELISTED	Stock	4.68	4.94	4.66	4.75	4904541.0
2010-07-21	AAIC-DELISTED	Stock	18.29	18.37	17.7701	18.04	69164.0
2010-07-21	AAME	Stock	1.26	1.26	1.26	1.26	200.0
2010-07-21	AAON	Stock	4.7249	4.7269	4.6044	4.6143	217687.0
2010-07-21	AAP	Stock	53.25	53.31	51.58	51.69	1162100.0
2010-07-21	AATI-DELISTED	Stock	3.45	3.47	3.31	3.31	63780.0
2010-07-21	AAU-DELISTED	Stock	0.8776	0.908	0.8775	0.8924	40797.0
2010-07-21	AAUAF-DELISTED	Stock	0.8751	0.905	0.875	0.8899	41210.0
2010-07-21	AAV-DELISTED	Stock	6.26	6.34	6.11	6.19	296739.0
2010-07-21	AAWW-DELISTED	Stock	55.6	56.33	54.1301	54.77	247364.0
2010-07-21	AAXJ	Stock	54.94	54.94	53.99	54.2	1881909.0
2010-07-21	AAXN-DELISTED	Stock	3.87	4.39	3.84	4.33	2913559.0
2010-07-21	AB	Stock	27.43	27.47	26.25	26.4	383300.0
2010-07-21	ABAC-DELISTED	Stock	5.27	5.31	4.08	4.25	226700.0
2010-07-21	ABAX-DELISTED	Stock	18.95	19.23	18.26	18.33	146296.0
2010-07-21	ABB-DELISTED	Stock	18.81	18.84	18.37	18.47	3158320.0
2010-07-21	ABBC-DELISTED	Stock	9.1	9.15	8.8	8.82	65322.0
2010-07-21	ABBNY-DELISTED	Stock	18.8	18.84	18.37	18.45	3193879.0
2010-07-21	ABC-DELISTED	Stock	32.35	32.44	31.85	32.0	3183647.0
2010-07-21	ABCB	Stock	10.06	10.12	9.63	9.75	97400.0
2010-07-21	ABCD-DELISTED	Stock	3.3	3.43	3.14	3.14	49250.0
2010-07-21	ABCO-DELISTED	Stock	20.73	20.88	20.54	20.79	171382.0
2010-07-21	ABCW-DELISTED	Stock	0.5295	0.5436	0.52	0.52	31080.0
2010-07-21	ABD-DELISTED	Stock	5.0	5.05	4.8194	4.89	267020.0
2010-07-21	ABE-DELISTED	Stock	16.83	16.85	16.7	16.73	8325.0
2010-07-21	ABEO	Stock	2500.0	2500.0	2312.5	2500.0	7.0
2010-07-21	ABFS-DELISTED	Stock	21.05	21.88	20.57	20.89	817047.0
2010-07-21	ABG	Stock	11.14	11.34	10.77	10.88	188200.0
2010-07-21	ABII-DELISTED	Stock	74.72	74.91	74.02	74.17	145630.0
2010-07-21	ABK-DELISTED	Stock	0.7097	0.72	0.6626	0.6793	4445967.0
2010-07-21	ABM	Stock	21.24	21.25	20.63	20.71	162100.0
2010-07-21	ABMD-DELISTED	Stock	11.22	11.22	10.69	10.85	182888.0
2010-07-21	ABR	Stock	6.1	6.11	5.88	6.1	244700.0
2010-07-21	ABT	Stock	22.9009	23.6925	21.3943	23.3567	29586078.0
2010-07-21	ABTL-DELISTED	Stock	5.65	5.8	5.4	5.45	37594.0
2010-07-21	ABV-DELISTED	Stock	107.92	107.92	105.52	106.38	691153.0
2010-07-21	ABVT-DELISTED	Stock	48.62	49.3	48.45	49.11	239174.0
2010-07-21	ABX-DELISTED	Stock	42.16	42.43	41.43	41.74	7074934.0

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

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