PREVIEW / stock_daily / 2010-01-05

all stock daily files

  file:    by_date/stock_daily/2010/2010-01-05.parquet
  size:    189 KB
  rows:    5,912
  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
2010-01-05	AAPL	Stock	7.6643	7.6996	7.6161	7.6564	601904800.0
2010-01-05	MSFT	Stock	30.85	31.1	30.64	30.96	49749600.0
2010-01-05	NVDA	Stock	0.4605	0.474	0.4605	0.469	728648000.0
2010-01-05	AMZN	Stock	6.6715	6.774	6.5905	6.7345	177038000.0
2010-01-05	TLT	Stock	90.05	90.631	90.0	90.39	2841589.0
2010-01-05	ES	Stock	25.91	25.91	25.5	25.68	2014200.0
2010-01-05	CL	Stock	41.305	41.835	40.98	41.76	5296800.0
2010-01-05	A	Stock	22.3247	22.3319	22.0029	22.1459	4186031.0
2010-01-05	AABA-DELISTED	Stock	17.21	17.23	17.0	17.22	11577419.0
2010-01-05	AACC-DELISTED	Stock	7.16	7.33	7.11	7.27	49307.0
2010-01-05	AACG	Stock	4.74	4.74	4.65	4.65	300.0
2010-01-05	AAI-DELISTED	Stock	5.09	5.33	5.03	5.28	7349778.0
2010-01-05	AAIC-DELISTED	Stock	15.61	16.1873	15.61	16.09	13624.0
2010-01-05	AAME	Stock	1.3	1.4	1.26	1.4	21900.0
2010-01-05	AAON	Stock	3.9407	3.9467	3.7807	3.8341	645469.0
2010-01-05	AAP	Stock	40.3	40.31	39.72	40.14	1932400.0
2010-01-05	AATI-DELISTED	Stock	3.93	3.94	3.72	3.8	250296.0
2010-01-05	AAU-DELISTED	Stock	1.15	1.15	1.0901	1.15	250149.0
2010-01-05	AAUAF-DELISTED	Stock	1.15	1.15	1.0901	1.15	254649.0
2010-01-05	AAV-DELISTED	Stock	6.82	7.11	6.8	7.11	904409.0
2010-01-05	AAWW-DELISTED	Stock	38.48	40.61	38.05	40.32	424661.0
2010-01-05	AAXJ	Stock	57.34	57.83	57.3323	57.81	309376.0
2010-01-05	AAXN-DELISTED	Stock	4.62	4.72	4.62	4.7	316645.0
2010-01-05	AB	Stock	28.41	28.52	28.17	28.37	571100.0
2010-01-05	ABAX-DELISTED	Stock	24.93	25.55	24.51	24.91	228287.0
2010-01-05	ABB-DELISTED	Stock	19.61	19.78	19.54	19.77	2879516.0
2010-01-05	ABBC-DELISTED	Stock	6.89	6.89	6.65	6.71	140689.0
2010-01-05	ABBNY-DELISTED	Stock	19.6	19.8	19.54	19.77	2881636.0
2010-01-05	ABC-DELISTED	Stock	26.65	26.65	26.3793	26.45	2446181.0
2010-01-05	ABCB	Stock	7.1803	7.3482	7.0322	7.2989	57104.0
2010-01-05	ABCD-DELISTED	Stock	4.08	4.0999	4.01	4.01	23370.0
2010-01-05	ABCO-DELISTED	Stock	16.04	16.04	15.71	15.83	256454.0
2010-01-05	ABCW-DELISTED	Stock	0.6302	0.6794	0.6302	0.64	101540.0
2010-01-05	ABD-DELISTED	Stock	7.91	7.99	7.61	7.68	309590.0
2010-01-05	ABE-DELISTED	Stock	16.87	17.1	16.87	17.1	7579.0
2010-01-05	ABEO	Stock	4000.0	4062.5	3875.0	4062.5	15.0
2010-01-05	ABFS-DELISTED	Stock	28.46	28.68	27.22	28.42	1180550.0
2010-01-05	ABG	Stock	11.84	12.5	11.76	12.39	608400.0
2010-01-05	ABII-DELISTED	Stock	40.19	41.58	40.19	41.26	67178.0
2010-01-05	ABK-DELISTED	Stock	0.819	0.83	0.8	0.8	7495377.0
2010-01-05	ABM	Stock	21.12	21.2	20.75	20.97	184100.0
2010-01-05	ABMD-DELISTED	Stock	8.82	8.94	8.46	8.53	128879.0
2010-01-05	ABR	Stock	1.99	1.99	1.87	1.92	42800.0
2010-01-05	ABT	Stock	26.1347	26.1347	25.7892	25.9188	10562109.0
2010-01-05	ABTL-DELISTED	Stock	4.6525	4.9026	4.6525	4.7475	3420.0
2010-01-05	ABV-DELISTED	Stock	103.55	104.82	102.95	104.02	464381.0
2010-01-05	ABVT-DELISTED	Stock	66.12	66.93	65.55	66.48	114895.0
2010-01-05	ABX-DELISTED	Stock	40.66	41.1	40.04	40.88	12766277.0
2010-01-05	ACAD	Stock	1.36	1.38	1.32	1.34	337500.0
2010-01-05	ACAP-DELISTED	Stock	30.54	30.54	29.66	29.67	53065.0

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

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