PREVIEW / stock_daily / 2009-10-07

all stock daily files

  file:    by_date/stock_daily/2009/2009-10-07.parquet
  size:    185 KB
  rows:    5,807
  symbols: 3,457

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
2009-10-07	AAPL	Stock	6.7771	6.8054	6.7511	6.7946	465668000.0
2009-10-07	MSFT	Stock	24.99	25.18	24.88	25.1	38472700.0
2009-10-07	NVDA	Stock	0.3478	0.3515	0.3438	0.3475	459608000.0
2009-10-07	AMZN	Stock	4.575	4.724	4.5575	4.6985	148902000.0
2009-10-07	TLT	Stock	98.67	99.33	98.6	99.19	3591239.0
2009-10-07	ES	Stock	23.24	23.26	23.05	23.19	1005700.0
2009-10-07	CL	Stock	38.83	38.915	38.635	38.88	3057000.0
2009-10-07	A	Stock	19.3634	19.4564	19.2346	19.3848	2222261.0
2009-10-07	AABA-DELISTED	Stock	17.23	17.49	17.15	17.49	12356336.0
2009-10-07	AACC-DELISTED	Stock	7.17	7.2	7.07	7.15	5490.0
2009-10-07	AACG	Stock	5.81	5.98	5.81	5.9	1100.0
2009-10-07	AAI-DELISTED	Stock	5.29	5.48	4.95	5.06	17071486.0
2009-10-07	AAIC-DELISTED	Stock	9.5	10.58	9.414	10.56	127529.0
2009-10-07	AAME	Stock	1.23	1.4	1.23	1.35	48700.0
2009-10-07	AAON	Stock	3.7254	3.7946	3.678	3.7432	1309162.0
2009-10-07	AAP	Stock	38.05	38.74	37.31	38.59	3804300.0
2009-10-07	AATI-DELISTED	Stock	3.23	3.35	3.23	3.25	563482.0
2009-10-07	AAU-DELISTED	Stock	0.76	0.77	0.74	0.75	150350.0
2009-10-07	AAUAF-DELISTED	Stock	0.76	0.77	0.74	0.75	151950.0
2009-10-07	AAV-DELISTED	Stock	6.48	6.5722	6.35	6.57	1400168.0
2009-10-07	AAWW-DELISTED	Stock	31.36	32.56	31.36	31.83	136815.0
2009-10-07	AAXJ	Stock	52.95	53.03	52.65	52.88	93696.0
2009-10-07	AAXN-DELISTED	Stock	4.47	4.566	4.47	4.53	195116.0
2009-10-07	AB	Stock	25.95	26.87	25.95	26.35	413800.0
2009-10-07	ABAX-DELISTED	Stock	26.95	27.2899	26.58	26.99	66089.0
2009-10-07	ABB-DELISTED	Stock	19.79	19.8985	19.57	19.78	2510123.0
2009-10-07	ABBC-DELISTED	Stock	7.99	8.0	7.91	7.98	66082.0
2009-10-07	ABBNY-DELISTED	Stock	19.79	19.8985	19.57	19.77	2516201.0
2009-10-07	ABC-DELISTED	Stock	22.02	22.41	21.93	22.4	3384110.0
2009-10-07	ABCB	Stock	6.9981	7.1157	6.6452	6.9099	9591.0
2009-10-07	ABCO-DELISTED	Stock	12.935	13.045	12.84	12.885	57071.0
2009-10-07	ABCW-DELISTED	Stock	1.3206	1.3413	1.3	1.3	89700.0
2009-10-07	ABD-DELISTED	Stock	7.11	7.29	7.06	7.21	173110.0
2009-10-07	ABE-DELISTED	Stock	17.75	17.76	17.56	17.56	17876.0
2009-10-07	ABEO	Stock	4250.0	4375.0	4125.0	4350.0	119.0
2009-10-07	ABFS-DELISTED	Stock	27.94	28.61	27.51	28.56	474919.0
2009-10-07	ABG	Stock	12.96	13.08	12.33	12.69	114200.0
2009-10-07	ABII-DELISTED	Stock	37.18	38.0	36.75	37.8	42173.0
2009-10-07	ABK-DELISTED	Stock	1.59	1.6	1.52	1.53	7622377.0
2009-10-07	ABM	Stock	19.93	20.2	19.9	19.99	80200.0
2009-10-07	ABMD-DELISTED	Stock	10.08	10.25	9.98	10.23	118992.0
2009-10-07	ABR	Stock	2.62	2.65	2.54	2.56	117900.0
2009-10-07	ABT	Stock	24.0332	24.9976	23.9564	24.0092	11910171.0
2009-10-07	ABTL-DELISTED	Stock	3.2	3.25	3.0055	3.15	24079.0
2009-10-07	ABV-DELISTED	Stock	88.94	89.5	87.56	88.69	465121.0
2009-10-07	ABVA-DELISTED	Stock	2.24	2.24	2.04	2.06	8256.0
2009-10-07	ABVT-DELISTED	Stock	48.5	48.6599	48.0	48.3	93743.0
2009-10-07	ABX-DELISTED	Stock	39.22	39.74	38.55	39.3	14811351.0
2009-10-07	ACAD	Stock	1.81	1.88	1.76	1.82	1440300.0
2009-10-07	ACAP-DELISTED	Stock	30.03	30.29	29.23	29.31	41546.0

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

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