PREVIEW / stock_daily / 2009-06-16

all stock daily files

  file:    by_date/stock_daily/2009/2009-06-16.parquet
  size:    181 KB
  rows:    5,764
  symbols: 3,441

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-06-16	AAPL	Stock	4.8807	4.9454	4.8607	4.8696	514805200.0
2009-06-16	MSFT	Stock	23.47	24.11	23.44	23.45	105295600.0
2009-06-16	NVDA	Stock	0.283	0.2865	0.2712	0.2752	594912000.0
2009-06-16	AMZN	Stock	4.185	4.1975	4.064	4.1075	109316000.0
2009-06-16	TLT	Stock	90.96	92.43	90.8	92.36	5376949.0
2009-06-16	ES	Stock	22.1	22.1	21.54	21.71	1142100.0
2009-06-16	CL	Stock	35.15	35.15	34.16	34.3	9194400.0
2009-06-16	A	Stock	13.5265	13.6695	13.2403	13.2833	4170653.0
2009-06-16	AABA-DELISTED	Stock	16.32	16.38	15.9	15.96	14780395.0
2009-06-16	AACC-DELISTED	Stock	9.04	9.04	8.695	8.79	23685.0
2009-06-16	AACG	Stock	7.1	7.2	7.06	7.06	5700.0
2009-06-16	AAI-DELISTED	Stock	5.39	5.87	5.3217	5.65	2624615.0
2009-06-16	AAIC-DELISTED	Stock	9.0	9.0	8.2	8.2	932249.0
2009-06-16	AAME	Stock	0.82	0.82	0.82	0.82	200.0
2009-06-16	AAON	Stock	3.9348	4.0178	3.7985	3.8025	188325.0
2009-06-16	AAP	Stock	41.82	41.82	40.65	40.84	1614500.0
2009-06-16	AATI-DELISTED	Stock	4.82	4.82	4.57	4.57	200275.0
2009-06-16	AAU-DELISTED	Stock	0.68	0.7	0.68	0.7	77600.0
2009-06-16	AAUAF-DELISTED	Stock	0.68	0.7	0.68	0.7	78000.0
2009-06-16	AAV-DELISTED	Stock	5.28	5.3448	4.83	5.1	1709222.0
2009-06-16	AAWW-DELISTED	Stock	24.13	24.3	22.64	22.84	206089.0
2009-06-16	AAXJ	Stock	44.2	44.22	43.08	43.31	229581.0
2009-06-16	AAXN-DELISTED	Stock	4.2	4.31	4.11	4.11	226164.0
2009-06-16	AB	Stock	21.2	21.36	19.96	20.5	498900.0
2009-06-16	ABAX-DELISTED	Stock	17.25	17.25	16.84	17.0	123398.0
2009-06-16	ABB-DELISTED	Stock	16.14	16.21	15.68	15.74	3771611.0
2009-06-16	ABBC-DELISTED	Stock	8.49	8.8	8.35	8.409	70090.0
2009-06-16	ABBNY-DELISTED	Stock	16.14	16.21	15.68	15.74	3772911.0
2009-06-16	ABC-DELISTED	Stock	17.99	18.23	17.74	17.75	2572532.0
2009-06-16	ABCB	Stock	6.1666	6.6431	5.9331	6.1471	22516.0
2009-06-16	ABCO-DELISTED	Stock	12.677	12.857	12.458	12.523	217234.0
2009-06-16	ABCW-DELISTED	Stock	1.25	1.272	1.06	1.06	289000.0
2009-06-16	ABD-DELISTED	Stock	3.2	3.38	3.02	3.14	416140.0
2009-06-16	ABE-DELISTED	Stock	14.83	15.2	14.83	14.92	17094.0
2009-06-16	ABEO	Stock	2812.5	2812.5	2687.5	2812.5	15.0
2009-06-16	ABFS-DELISTED	Stock	29.17	29.96	28.67	28.96	753695.0
2009-06-16	ABG	Stock	11.39	11.39	10.16	10.2	285800.0
2009-06-16	ABII-DELISTED	Stock	39.78	40.5	39.5	39.52	28100.0
2009-06-16	ABK-DELISTED	Stock	1.21	1.29	1.18	1.29	7695932.0
2009-06-16	ABM	Stock	18.13	18.22	17.76	17.82	128800.0
2009-06-16	ABMD-DELISTED	Stock	7.73	7.89	7.4918	7.7	348185.0
2009-06-16	ABR	Stock	1.95	2.04	1.88	2.01	283300.0
2009-06-16	ABT	Stock	21.4471	21.6966	21.2168	21.4615	16300750.0
2009-06-16	ABTL-DELISTED	Stock	2.0525	2.1474	2.0475	2.0975	18776.0
2009-06-16	ABV-DELISTED	Stock	65.95	65.9792	63.84	63.89	789083.0
2009-06-16	ABVA-DELISTED	Stock	3.0812	3.0812	3.0812	3.0812	100.0
2009-06-16	ABVT-DELISTED	Stock	78.5	78.88	76.15	77.12	21798.0
2009-06-16	ABX-DELISTED	Stock	33.73	34.09	33.0	33.42	8033455.0
2009-06-16	ACAD	Stock	2.2	2.34	2.2	2.2	186500.0
2009-06-16	ACAP-DELISTED	Stock	38.82	38.99	38.0	38.14	46520.0

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

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