PREVIEW / stock_daily / 2010-01-06

all stock daily files

  file:    by_date/stock_daily/2010/2010-01-06.parquet
  size:    189 KB
  rows:    5,899
  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
2010-01-06	AAPL	Stock	7.6564	7.6868	7.5268	7.5346	552160000.0
2010-01-06	MSFT	Stock	30.88	31.08	30.52	30.77	58182400.0
2010-01-06	NVDA	Stock	0.4688	0.473	0.4643	0.472	649168000.0
2010-01-06	AMZN	Stock	6.73	6.7365	6.5825	6.6125	143576000.0
2010-01-06	TLT	Stock	90.17	90.26	89.12	89.18	4099754.0
2010-01-06	ES	Stock	25.77	26.14	25.75	26.01	1550300.0
2010-01-06	CL	Stock	41.81	41.875	41.2	41.665	7195200.0
2010-01-06	A	Stock	22.0672	22.1745	22.0029	22.0672	3243779.0
2010-01-06	AABA-DELISTED	Stock	17.11	17.3	17.07	17.17	16047512.0
2010-01-06	AACC-DELISTED	Stock	7.24	7.41	6.81	6.82	43417.0
2010-01-06	AACG	Stock	4.51	4.51	4.51	4.51	100.0
2010-01-06	AAI-DELISTED	Stock	5.28	5.3	5.04	5.08	5373327.0
2010-01-06	AAIC-DELISTED	Stock	16.15	16.23	15.78	16.08	33657.0
2010-01-06	AAON	Stock	3.8341	3.8815	3.682	3.682	1064137.0
2010-01-06	AAP	Stock	40.05	40.78	40.05	40.49	1406200.0
2010-01-06	AATI-DELISTED	Stock	3.75	3.81	3.64	3.8	425328.0
2010-01-06	AAU-DELISTED	Stock	1.2	1.32	1.1995	1.29	629743.0
2010-01-06	AAUAF-DELISTED	Stock	1.2	1.32	1.1995	1.29	634243.0
2010-01-06	AAV-DELISTED	Stock	7.05	7.38	7.05	7.3	759722.0
2010-01-06	AAWW-DELISTED	Stock	39.9	40.22	38.42	38.63	290224.0
2010-01-06	AAXJ	Stock	58.16	58.19	57.67	57.76	2535956.0
2010-01-06	AAXN-DELISTED	Stock	5.05	5.95	5.03	5.84	8399437.0
2010-01-06	AB	Stock	28.45	28.64	28.29	28.38	516000.0
2010-01-06	ABAX-DELISTED	Stock	24.97	26.08	24.71	25.72	200500.0
2010-01-06	ABB-DELISTED	Stock	19.81	20.04	19.79	20.02	2482653.0
2010-01-06	ABBC-DELISTED	Stock	6.68	6.78	6.6	6.6	98344.0
2010-01-06	ABBNY-DELISTED	Stock	19.81	20.04	19.79	20.0	2483757.0
2010-01-06	ABC-DELISTED	Stock	26.39	26.43	26.08	26.18	4037203.0
2010-01-06	ABCB	Stock	7.2099	7.7532	7.1704	7.447	78671.0
2010-01-06	ABCD-DELISTED	Stock	4.03	4.0399	3.96	4.0	33685.0
2010-01-06	ABCO-DELISTED	Stock	15.768	16.067	15.763	15.917	210065.0
2010-01-06	ABCW-DELISTED	Stock	0.69	0.69	0.66	0.66	88750.0
2010-01-06	ABD-DELISTED	Stock	7.69	8.05	7.66	7.9	236010.0
2010-01-06	ABE-DELISTED	Stock	17.1	17.16	17.01	17.03	4254.0
2010-01-06	ABEO	Stock	3937.5	3975.0	3875.0	3975.0	29.0
2010-01-06	ABFS-DELISTED	Stock	28.33	29.0	28.03	28.22	466145.0
2010-01-06	ABG	Stock	12.4	12.97	12.35	12.76	376800.0
2010-01-06	ABII-DELISTED	Stock	41.79	42.0	41.47	42.0	18997.0
2010-01-06	ABK-DELISTED	Stock	0.8	0.82	0.79	0.8002	4896717.0
2010-01-06	ABM	Stock	20.91	21.24	20.89	20.97	152100.0
2010-01-06	ABMD-DELISTED	Stock	8.52	8.595	8.36	8.4	117015.0
2010-01-06	ABR	Stock	1.94	2.18	1.92	2.14	399400.0
2010-01-06	ABT	Stock	25.8804	26.0963	25.8372	26.0627	11401417.0
2010-01-06	ABTL-DELISTED	Stock	4.8621	5.069	4.3966	4.5	18318.0
2010-01-06	ABV-DELISTED	Stock	103.68	105.12	103.23	104.52	252542.0
2010-01-06	ABVA-DELISTED	Stock	2.61	3.25	2.6	3.24	4155.0
2010-01-06	ABVT-DELISTED	Stock	66.65	66.65	64.8	65.54	128404.0
2010-01-06	ABX-DELISTED	Stock	41.32	42.34	41.14	41.77	12197923.0
2010-01-06	ACAD	Stock	1.36	1.37	1.3	1.33	341500.0
2010-01-06	ACAP-DELISTED	Stock	29.66	29.89	29.4105	29.58	41241.0

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

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