PREVIEW / stock_daily / 2010-08-18

all stock daily files

  file:    by_date/stock_daily/2010/2010-08-18.parquet
  size:    189 KB
  rows:    5,952
  symbols: 3,490

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-08-18	AAPL	Stock	9.0129	9.0954	8.985	9.0382	339696000.0
2010-08-18	MSFT	Stock	24.68	24.95	24.41	24.82	46818900.0
2010-08-18	NVDA	Stock	0.231	0.235	0.2295	0.233	352920000.0
2010-08-18	AMZN	Stock	6.4625	6.5405	6.413	6.4825	158030000.0
2010-08-18	TSLA	Stock	1.306	1.306	1.24	1.2513	9019500.0
2010-08-18	TLT	Stock	105.0	105.65	104.49	104.53	7721936.0
2010-08-18	ES	Stock	29.19	29.31	28.85	28.99	1482300.0
2010-08-18	CL	Stock	38.145	38.545	38.06	38.4	3802200.0
2010-08-18	A	Stock	20.98	21.216	20.794	21.0587	4255512.0
2010-08-18	AABA-DELISTED	Stock	13.98	14.05	13.84	13.99	15429403.0
2010-08-18	AACC-DELISTED	Stock	4.09	4.21	4.05	4.07	20750.0
2010-08-18	AACG	Stock	2.91	2.91	2.84	2.91	3900.0
2010-08-18	AAI-DELISTED	Stock	4.68	4.79	4.66	4.78	1348469.0
2010-08-18	AAIC-DELISTED	Stock	20.42	20.84	20.34	20.39	84862.0
2010-08-18	AAME	Stock	1.3	1.3	1.25	1.3	13900.0
2010-08-18	AAON	Stock	4.4721	4.4721	4.4109	4.4286	193894.0
2010-08-18	AAP	Stock	54.57	55.36	54.24	55.19	896800.0
2010-08-18	AATI-DELISTED	Stock	3.26	3.36	3.23	3.28	76683.0
2010-08-18	AAU-DELISTED	Stock	1.73	1.75	1.65	1.67	325021.0
2010-08-18	AAUAF-DELISTED	Stock	1.73	1.75	1.65	1.67	328221.0
2010-08-18	AAV-DELISTED	Stock	6.26	6.26	6.08	6.09	293550.0
2010-08-18	AAWW-DELISTED	Stock	46.81	48.89	46.64	48.09	395484.0
2010-08-18	AAXJ	Stock	55.73	55.96	55.4336	55.67	121505.0
2010-08-18	AAXN-DELISTED	Stock	4.04	4.04	3.95	4.01	264012.0
2010-08-18	AB	Stock	25.89	25.92	25.5	25.74	381400.0
2010-08-18	ABAC-DELISTED	Stock	4.15	4.28	4.08	4.28	12800.0
2010-08-18	ABAX-DELISTED	Stock	19.87	20.0	19.55	19.86	100700.0
2010-08-18	ABB-DELISTED	Stock	19.81	19.9166	19.66	19.78	1004964.0
2010-08-18	ABBC-DELISTED	Stock	9.83	9.88	9.57	9.64	45297.0
2010-08-18	ABBNY-DELISTED	Stock	19.81	19.9166	19.66	19.78	1009905.0
2010-08-18	ABC-DELISTED	Stock	29.45	29.755	29.16	29.44	2568656.0
2010-08-18	ABCB	Stock	8.9	8.91	8.48	8.49	69700.0
2010-08-18	ABCD-DELISTED	Stock	3.21	3.21	3.11	3.13	14266.0
2010-08-18	ABCO-DELISTED	Stock	21.89	22.14	21.69	22.02	131520.0
2010-08-18	ABCW-DELISTED	Stock	0.6287	0.6487	0.6196	0.6213	33820.0
2010-08-18	ABD-DELISTED	Stock	6.325	6.425	6.2649	6.405	290620.0
2010-08-18	ABE-DELISTED	Stock	17.42	17.5	17.32	17.46	16417.0
2010-08-18	ABEO	Stock	2312.5	2312.5	2187.5	2300.0	18.0
2010-08-18	ABFS-DELISTED	Stock	20.18	20.86	19.84	20.4	170368.0
2010-08-18	ABG	Stock	13.09	13.42	12.88	13.32	220400.0
2010-08-18	ABII-DELISTED	Stock	75.26	75.5	75.06	75.2	48919.0
2010-08-18	ABK-DELISTED	Stock	0.62	0.6301	0.5501	0.5538	24283323.0
2010-08-18	ABM	Stock	20.73	21.0	20.5	20.78	170900.0
2010-08-18	ABMD-DELISTED	Stock	9.86	9.93	9.73	9.74	134243.0
2010-08-18	ABR	Stock	5.06	5.11	5.0	5.02	29200.0
2010-08-18	ABT	Stock	24.2923	24.3355	24.0956	24.1004	12794081.0
2010-08-18	ABTL-DELISTED	Stock	4.7493	4.7493	4.2562	4.5007	10697.0
2010-08-18	ABV-DELISTED	Stock	109.2	110.45	108.88	110.23	988306.0
2010-08-18	ABVT-DELISTED	Stock	51.65	52.63	51.245	52.17	101263.0
2010-08-18	ABX-DELISTED	Stock	44.04	45.49	43.86	45.21	7370883.0

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

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