PREVIEW / stock_daily / 2012-10-04

all stock daily files

  file:    by_date/stock_daily/2012/2012-10-04.parquet
  size:    200 KB
  rows:    6,176
  symbols: 3,495

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
2012-10-04	AAPL	Stock	23.9732	24.0804	23.7696	23.8143	370725600.0
2012-10-04	MSFT	Stock	29.97	30.03	29.57	30.03	43634900.0
2012-10-04	NVDA	Stock	0.3268	0.3425	0.325	0.3405	502608000.0
2012-10-04	AMZN	Stock	12.8005	13.076	12.7935	13.0235	54008000.0
2012-10-04	META	Stock	22.32	22.4	21.41	21.95	46892100.0
2012-10-04	TSLA	Stock	2.0	2.0067	1.91	1.96	23119500.0
2012-10-04	TLT	Stock	123.46	123.8	122.57	122.74	6214730.0
2012-10-04	ES	Stock	38.87	39.07	38.71	38.8	1021700.0
2012-10-04	CL	Stock	54.25	54.54	54.055	54.23	2598400.0
2012-10-04	A	Stock	28.0544	28.3548	27.804	28.0401	7781967.0
2012-10-04	AABA-DELISTED	Stock	16.24	16.35	16.15	16.26	16871446.0
2012-10-04	AACC-DELISTED	Stock	7.34	7.65	7.12	7.64	20861.0
2012-10-04	AACG	Stock	5.57	5.57	5.39	5.57	2200.0
2012-10-04	AAIC-DELISTED	Stock	24.02	24.12	23.97	24.08	144395.0
2012-10-04	AAME	Stock	2.75	2.77	2.72	2.77	2500.0
2012-10-04	AAMRQ-DELISTED	Stock	0.387	0.398	0.387	0.394	721012.0
2012-10-04	AAON	Stock	5.7541	5.7659	5.6207	5.7156	84038.0
2012-10-04	AAP	Stock	68.37	69.65	68.11	69.49	631200.0
2012-10-04	AAT	Stock	27.57	27.77	27.36	27.45	196300.0
2012-10-04	AAU-DELISTED	Stock	2.5	2.68	2.5	2.64	185820.0
2012-10-04	AAUAF-DELISTED	Stock	2.5	2.68	2.5	2.65	186320.0
2012-10-04	AAV-DELISTED	Stock	4.07	4.07	3.98	4.04	155404.0
2012-10-04	AAWW-DELISTED	Stock	51.64	52.59	50.78	52.48	152659.0
2012-10-04	AAXJ	Stock	57.02	57.25	56.87	57.22	268225.0
2012-10-04	AAXN-DELISTED	Stock	5.9	6.0	5.88	5.99	251468.0
2012-10-04	AB	Stock	15.58	15.66	15.22	15.28	220900.0
2012-10-04	ABAC-DELISTED	Stock	1.6	1.6	1.2301	1.51	16044.0
2012-10-04	ABAX-DELISTED	Stock	37.9	38.45	37.57	38.0	84257.0
2012-10-04	ABB-DELISTED	Stock	19.15	19.42	19.14	19.35	1512688.0
2012-10-04	ABBNY-DELISTED	Stock	19.15	19.42	19.14	19.36	1705054.0
2012-10-04	ABC-DELISTED	Stock	39.23	39.7	39.14	39.36	2946698.0
2012-10-04	ABCB	Stock	12.54	12.54	12.28	12.5	48600.0
2012-10-04	ABCD-DELISTED	Stock	0.9915	1.05	0.991	1.05	7375.0
2012-10-04	ABCO-DELISTED	Stock	48.26	49.19	47.99	48.9	194633.0
2012-10-04	ABCW-DELISTED	Stock	0.39	0.4	0.39	0.4	3325.0
2012-10-04	ABE-DELISTED	Stock	20.84	20.9199	20.81	20.81	1432.0
2012-10-04	ABEO	Stock	525.0	575.0	475.0	525.0	27.0
2012-10-04	ABFS-DELISTED	Stock	7.66	7.84	7.5	7.78	270105.0
2012-10-04	ABG	Stock	28.77	29.3	28.53	29.11	559500.0
2012-10-04	ABM	Stock	19.0	19.06	18.9	18.97	388800.0
2012-10-04	ABMD-DELISTED	Stock	20.78	20.97	20.57	20.79	321628.0
2012-10-04	ABR	Stock	6.11	6.14	5.98	6.05	56700.0
2012-10-04	ABT	Stock	33.5572	34.0898	33.5332	33.9602	14207586.0
2012-10-04	ABTL-DELISTED	Stock	3.75	3.82	3.6698	3.76	46136.0
2012-10-04	ABUS	Stock	3.63	3.7	3.63	3.63	12600.0
2012-10-04	ABV-DELISTED	Stock	39.56	39.925	39.42	39.86	1416804.0
2012-10-04	ABVA-DELISTED	Stock	4.69	4.69	4.69	4.69	100.0
2012-10-04	ABX-DELISTED	Stock	41.65	42.18	41.42	42.18	7723305.0
2012-10-04	ACAD	Stock	2.55	2.83	2.53	2.76	3182900.0
2012-10-04	ACAS-DELISTED	Stock	11.6	11.75	11.6	11.68	2805618.0

> showing 50 of 6,176 rows — these rows as CSV

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