PREVIEW / stock_1hour / 2017-02-03

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-02-03.parquet
  size:    1.0 MB
  rows:    48,282
  symbols: 3,120

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
2017-02-03 05:00:00	AAPL	Stock	32.01	32.01	32.01	32.01	400.0
2017-02-03 06:00:00	AAPL	Stock	32.07	32.0875	32.07	32.0875	5880.0
2017-02-03 07:00:00	AAPL	Stock	32.0875	32.1225	32.0875	32.12	23572.0
2017-02-03 08:00:00	AAPL	Stock	32.1175	32.17	32.03	32.1375	369708.0
2017-02-03 09:00:00	AAPL	Stock	32.1375	32.279	32.04	32.2537	15932208.0
2017-02-03 10:00:00	AAPL	Stock	32.255	32.2975	32.1685	32.1775	13814824.0
2017-02-03 11:00:00	AAPL	Stock	32.1775	32.23	32.085	32.105	8566888.0
2017-02-03 12:00:00	AAPL	Stock	32.1075	32.15	32.0925	32.1125	5244352.0
2017-02-03 13:00:00	AAPL	Stock	32.1112	32.1275	32.086	32.1125	6308604.0
2017-02-03 14:00:00	AAPL	Stock	32.1142	32.175	32.1125	32.1725	7682596.0
2017-02-03 15:00:00	AAPL	Stock	32.1718	32.27	32.1608	32.2675	20216244.0
2017-02-03 16:00:00	AAPL	Stock	32.2675	32.2975	32.1195	32.2575	10321752.0
2017-02-03 17:00:00	AAPL	Stock	32.2625	32.2925	32.26	32.275	66704.0
2017-02-03 18:00:00	AAPL	Stock	32.2825	32.29	32.27	32.29	20484.0
2017-02-03 19:00:00	AAPL	Stock	32.2875	32.3	32.28	32.2975	38188.0
2017-02-03 04:00:00	MSFT	Stock	63.18	63.18	63.18	63.18	152.0
2017-02-03 05:00:00	MSFT	Stock	63.1	63.1	63.1	63.1	180.0
2017-02-03 06:00:00	MSFT	Stock	63.1	63.19	63.1	63.19	509.0
2017-02-03 07:00:00	MSFT	Stock	63.35	63.35	63.25	63.28	6207.0
2017-02-03 08:00:00	MSFT	Stock	63.29	63.5	63.25	63.41	57510.0
2017-02-03 09:00:00	MSFT	Stock	63.5	63.64	63.14	63.415	3972692.0
2017-02-03 10:00:00	MSFT	Stock	63.42	63.52	63.165	63.22	4099042.0
2017-02-03 11:00:00	MSFT	Stock	63.22	63.33	63.07	63.22	2852724.0
2017-02-03 12:00:00	MSFT	Stock	63.23	63.33	63.19	63.23	2698877.0
2017-02-03 13:00:00	MSFT	Stock	63.24	63.34	63.16	63.29	1934128.0
2017-02-03 14:00:00	MSFT	Stock	63.285	63.7	63.27	63.59	4742845.0
2017-02-03 15:00:00	MSFT	Stock	63.585	63.68	63.531	63.67	5540693.0
2017-02-03 16:00:00	MSFT	Stock	63.655	63.68	63.45	63.53	2413124.0
2017-02-03 17:00:00	MSFT	Stock	63.55	63.68	63.53	63.57	7323.0
2017-02-03 18:00:00	MSFT	Stock	63.58	63.58	63.53	63.58	1000.0
2017-02-03 19:00:00	MSFT	Stock	63.55	63.55	63.54	63.54	1950.0
2017-02-03 04:00:00	NVDA	Stock	2.88	2.8875	2.88	2.885	110160.0
2017-02-03 05:00:00	NVDA	Stock	2.8852	2.8852	2.88	2.88	68440.0
2017-02-03 06:00:00	NVDA	Stock	2.885	2.885	2.885	2.885	8400.0
2017-02-03 07:00:00	NVDA	Stock	2.8825	2.8875	2.8788	2.8833	88120.0
2017-02-03 08:00:00	NVDA	Stock	2.8838	2.905	2.875	2.9	1673280.0
2017-02-03 09:00:00	NVDA	Stock	2.9025	2.9025	2.87	2.8808	60204600.0
2017-02-03 10:00:00	NVDA	Stock	2.8798	2.885	2.8575	2.8721	74908680.0
2017-02-03 11:00:00	NVDA	Stock	2.8723	2.8798	2.8582	2.8678	52840600.0
2017-02-03 12:00:00	NVDA	Stock	2.8678	2.8733	2.8628	2.866	27335880.0
2017-02-03 13:00:00	NVDA	Stock	2.866	2.8683	2.8475	2.8495	39927240.0
2017-02-03 14:00:00	NVDA	Stock	2.8499	2.8638	2.849	2.8572	37879400.0
2017-02-03 15:00:00	NVDA	Stock	2.8573	2.8668	2.8562	2.8595	53125360.0
2017-02-03 16:00:00	NVDA	Stock	2.8595	2.8622	2.8565	2.8575	9481640.0
2017-02-03 17:00:00	NVDA	Stock	2.8575	2.862	2.8575	2.86	110600.0
2017-02-03 18:00:00	NVDA	Stock	2.8582	2.8618	2.858	2.8618	136040.0
2017-02-03 19:00:00	NVDA	Stock	2.8612	2.8612	2.859	2.8595	52760.0
2017-02-03 04:00:00	AMZN	Stock	40.4055	40.6	40.4055	40.5735	24000.0
2017-02-03 05:00:00	AMZN	Stock	40.55	40.55	40.4165	40.4165	25780.0
2017-02-03 06:00:00	AMZN	Stock	40.4205	40.4575	40.3515	40.4375	90080.0

> showing 50 of 48,282 rows — these rows as CSV

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