PREVIEW / stock_1hour / 2010-10-08

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-08.parquet
  size:    909 KB
  rows:    44,320
  symbols: 3,484

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2010-10-08 06:00:00	AAPL	Stock	10.3071	10.3071	10.3071	10.3071	14000.0
2010-10-08 07:00:00	AAPL	Stock	10.3054	10.3282	10.2961	10.3157	83160.0
2010-10-08 08:00:00	AAPL	Stock	10.3111	10.3768	10.25	10.3429	9751644.0
2010-10-08 09:00:00	AAPL	Stock	10.3446	10.4536	10.3336	10.4268	107033360.0
2010-10-08 10:00:00	AAPL	Stock	10.4275	10.4382	10.3571	10.4168	104010928.0
2010-10-08 11:00:00	AAPL	Stock	10.4171	10.5157	10.4107	10.4975	134065456.0
2010-10-08 12:00:00	AAPL	Stock	10.4971	10.5139	10.4546	10.4875	68137216.0
2010-10-08 13:00:00	AAPL	Stock	10.4889	10.5	10.4643	10.4768	42790552.0
2010-10-08 14:00:00	AAPL	Stock	10.4775	10.5029	10.4564	10.4933	46078872.0
2010-10-08 15:00:00	AAPL	Stock	10.4921	10.5179	10.4886	10.5039	107662576.0
2010-10-08 16:00:00	AAPL	Stock	10.5043	10.5118	10.3293	10.5071	34424572.0
2010-10-08 17:00:00	AAPL	Stock	10.5075	10.5075	10.5	10.5	564424.0
2010-10-08 18:00:00	AAPL	Stock	10.5	10.5025	10.4893	10.4929	844984.0
2010-10-08 19:00:00	AAPL	Stock	10.4911	10.4968	10.4893	10.4939	406812.0
2010-10-08 04:00:00	MSFT	Stock	24.52	24.52	24.52	24.52	1000.0
2010-10-08 07:00:00	MSFT	Stock	24.6	24.6	24.6	24.6	200.0
2010-10-08 08:00:00	MSFT	Stock	24.48	24.57	24.4	24.47	19345.0
2010-10-08 09:00:00	MSFT	Stock	24.51	24.65	24.47	24.545	4793969.0
2010-10-08 10:00:00	MSFT	Stock	24.54	24.55	24.37	24.44	4591029.0
2010-10-08 11:00:00	MSFT	Stock	24.45	24.64	24.44	24.6	5490768.0
2010-10-08 12:00:00	MSFT	Stock	24.6	24.65	24.52	24.601	4182696.0
2010-10-08 13:00:00	MSFT	Stock	24.602	24.62	24.49	24.545	2330360.0
2010-10-08 14:00:00	MSFT	Stock	24.55	24.59	24.5	24.55	4489080.0
2010-10-08 15:00:00	MSFT	Stock	24.55	24.63	24.54	24.55	9750554.0
2010-10-08 16:00:00	MSFT	Stock	24.55	24.612	24.5	24.58	4841273.0
2010-10-08 17:00:00	MSFT	Stock	24.58	24.6	24.58	24.58	23667.0
2010-10-08 18:00:00	MSFT	Stock	24.57	24.57	24.56	24.57	936.0
2010-10-08 19:00:00	MSFT	Stock	24.61	24.61	24.58	24.58	420.0
2010-10-08 08:00:00	NVDA	Stock	0.2668	0.2668	0.266	0.2663	164000.0
2010-10-08 09:00:00	NVDA	Stock	0.2663	0.2685	0.2628	0.2679	74517360.0
2010-10-08 10:00:00	NVDA	Stock	0.2679	0.2684	0.2645	0.2668	92070600.0
2010-10-08 11:00:00	NVDA	Stock	0.2666	0.2728	0.2663	0.2705	153411280.0
2010-10-08 12:00:00	NVDA	Stock	0.2706	0.2728	0.2692	0.2718	88719000.0
2010-10-08 13:00:00	NVDA	Stock	0.2718	0.2738	0.27	0.2708	91800520.0
2010-10-08 14:00:00	NVDA	Stock	0.2706	0.2728	0.2699	0.272	55853400.0
2010-10-08 15:00:00	NVDA	Stock	0.2718	0.2728	0.2711	0.2715	128461520.0
2010-10-08 16:00:00	NVDA	Stock	0.2715	0.2728	0.2675	0.2718	21332480.0
2010-10-08 17:00:00	NVDA	Stock	0.271	0.271	0.271	0.271	22000.0
2010-10-08 18:00:00	NVDA	Stock	0.2715	0.2715	0.271	0.271	28000.0
2010-10-08 19:00:00	NVDA	Stock	0.2715	0.2715	0.2698	0.27	205680.0
2010-10-08 07:00:00	AMZN	Stock	7.7	7.7415	7.7	7.7375	81400.0
2010-10-08 08:00:00	AMZN	Stock	7.728	7.7825	7.7	7.723	524840.0
2010-10-08 09:00:00	AMZN	Stock	7.73	7.7675	7.664	7.7225	17824800.0
2010-10-08 10:00:00	AMZN	Stock	7.719	7.7365	7.639	7.7162	24247480.0
2010-10-08 11:00:00	AMZN	Stock	7.7175	7.798	7.7094	7.7845	19223700.0
2010-10-08 12:00:00	AMZN	Stock	7.7875	7.7875	7.7545	7.7645	12961280.0
2010-10-08 13:00:00	AMZN	Stock	7.7655	7.8035	7.7636	7.7835	19179080.0
2010-10-08 14:00:00	AMZN	Stock	7.7838	7.814	7.7665	7.783	14088620.0
2010-10-08 15:00:00	AMZN	Stock	7.784	7.803	7.7635	7.776	24754100.0
2010-10-08 16:00:00	AMZN	Stock	7.765	7.7848	7.707	7.775	1699880.0

> showing 50 of 44,320 rows — these rows as CSV

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