PREVIEW / stock_1hour / 2016-02-09

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-02-09.parquet
  size:    1.0 MB
  rows:    49,082
  symbols: 3,347

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
2016-02-09 04:00:00	AAPL	Stock	23.6875	23.75	23.6875	23.75	16108.0
2016-02-09 05:00:00	AAPL	Stock	23.6875	23.75	23.6875	23.69	5200.0
2016-02-09 06:00:00	AAPL	Stock	23.69	23.69	23.65	23.65	6200.0
2016-02-09 07:00:00	AAPL	Stock	23.6	23.6125	23.5275	23.56	63812.0
2016-02-09 08:00:00	AAPL	Stock	23.58	23.6125	23.525	23.5875	663280.0
2016-02-09 09:00:00	AAPL	Stock	23.5875	23.845	23.5175	23.695	23616656.0
2016-02-09 10:00:00	AAPL	Stock	23.695	23.82	23.4825	23.5575	29488812.0
2016-02-09 11:00:00	AAPL	Stock	23.56	23.7675	23.555	23.6748	19508544.0
2016-02-09 12:00:00	AAPL	Stock	23.6725	23.76	23.61	23.665	13355660.0
2016-02-09 13:00:00	AAPL	Stock	23.6622	23.7125	23.5625	23.6875	15359176.0
2016-02-09 14:00:00	AAPL	Stock	23.6875	23.94	23.6752	23.9125	24752252.0
2016-02-09 15:00:00	AAPL	Stock	23.9125	23.985	23.7125	23.755	29359164.0
2016-02-09 16:00:00	AAPL	Stock	23.7475	23.7625	23.6875	23.7	7019396.0
2016-02-09 17:00:00	AAPL	Stock	23.7475	23.7475	23.6975	23.71	64992.0
2016-02-09 18:00:00	AAPL	Stock	23.735	23.805	23.735	23.805	36860.0
2016-02-09 19:00:00	AAPL	Stock	23.7925	23.805	23.7575	23.775	69448.0
2016-02-09 07:00:00	MSFT	Stock	49.05	49.16	49.03	49.14	23319.0
2016-02-09 08:00:00	MSFT	Stock	49.07	49.2	48.76	48.8	26175.0
2016-02-09 09:00:00	MSFT	Stock	48.74	49.7	48.74	49.56	5021277.0
2016-02-09 10:00:00	MSFT	Stock	49.56	50.24	49.5	49.57	6849898.0
2016-02-09 11:00:00	MSFT	Stock	49.56	50.07	49.52	49.625	4245744.0
2016-02-09 12:00:00	MSFT	Stock	49.625	49.79	48.94	49.015	5567149.0
2016-02-09 13:00:00	MSFT	Stock	49.01	49.08	48.67	48.995	5038028.0
2016-02-09 14:00:00	MSFT	Stock	49.0	49.68	48.885	49.51	6769844.0
2016-02-09 15:00:00	MSFT	Stock	49.51	49.97	49.19	49.28	7145006.0
2016-02-09 16:00:00	MSFT	Stock	49.28	49.36	49.16	49.25	2219475.0
2016-02-09 17:00:00	MSFT	Stock	49.25	49.28	49.2	49.28	129660.0
2016-02-09 18:00:00	MSFT	Stock	49.3	49.44	49.3	49.44	4950.0
2016-02-09 19:00:00	MSFT	Stock	49.44	49.44	49.33	49.4	1990.0
2016-02-09 04:00:00	NVDA	Stock	0.6305	0.6305	0.6305	0.6305	4000.0
2016-02-09 05:00:00	NVDA	Stock	0.6305	0.6305	0.6305	0.6305	4000.0
2016-02-09 06:00:00	NVDA	Stock	0.631	0.631	0.631	0.631	16000.0
2016-02-09 09:00:00	NVDA	Stock	0.6238	0.6553	0.62	0.6525	53840680.0
2016-02-09 10:00:00	NVDA	Stock	0.6522	0.6638	0.6426	0.6442	76720360.0
2016-02-09 11:00:00	NVDA	Stock	0.6442	0.6509	0.6402	0.647	53442120.0
2016-02-09 12:00:00	NVDA	Stock	0.647	0.6488	0.6398	0.6423	37939920.0
2016-02-09 13:00:00	NVDA	Stock	0.6423	0.6426	0.6336	0.639	37152440.0
2016-02-09 14:00:00	NVDA	Stock	0.639	0.6455	0.6388	0.6438	39864560.0
2016-02-09 15:00:00	NVDA	Stock	0.644	0.6485	0.6353	0.6372	94050560.0
2016-02-09 16:00:00	NVDA	Stock	0.6372	0.6372	0.6372	0.6372	12494080.0
2016-02-09 18:00:00	NVDA	Stock	0.6388	0.6388	0.6388	0.6388	12000.0
2016-02-09 04:00:00	AMZN	Stock	24.4	24.4	24.35	24.35	4000.0
2016-02-09 06:00:00	AMZN	Stock	24.3	24.3	24.3	24.3	2000.0
2016-02-09 07:00:00	AMZN	Stock	24.154	24.154	24.05	24.145	81900.0
2016-02-09 08:00:00	AMZN	Stock	24.1435	24.1523	23.9	23.95	351760.0
2016-02-09 09:00:00	AMZN	Stock	23.9255	24.919	23.7595	24.7095	24069740.0
2016-02-09 10:00:00	AMZN	Stock	24.718	24.875	24.134	24.1675	23870300.0
2016-02-09 11:00:00	AMZN	Stock	24.1512	24.43	24.0565	24.1465	13209180.0
2016-02-09 12:00:00	AMZN	Stock	24.1575	24.2345	23.9345	24.084	9058460.0
2016-02-09 13:00:00	AMZN	Stock	24.09	24.1268	23.7	23.9785	14351980.0

> showing 50 of 49,082 rows — these rows as CSV

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