PREVIEW / stock_1hour / 2016-10-20

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-20.parquet
  size:    1.0 MB
  rows:    46,840
  symbols: 3,170

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-10-20 05:00:00	AAPL	Stock	29.305	29.305	29.305	29.305	800.0
2016-10-20 06:00:00	AAPL	Stock	29.25	29.305	29.25	29.295	9236.0
2016-10-20 07:00:00	AAPL	Stock	29.275	29.335	29.15	29.1875	40468.0
2016-10-20 08:00:00	AAPL	Stock	29.2975	29.31	29.14	29.275	189800.0
2016-10-20 09:00:00	AAPL	Stock	29.28	29.2925	29.1425	29.25	11357572.0
2016-10-20 10:00:00	AAPL	Stock	29.2475	29.3275	29.0825	29.1625	20247524.0
2016-10-20 11:00:00	AAPL	Stock	29.165	29.255	29.16	29.2425	10662036.0
2016-10-20 12:00:00	AAPL	Stock	29.245	29.34	29.2375	29.2912	10543724.0
2016-10-20 13:00:00	AAPL	Stock	29.2925	29.345	29.2025	29.2225	10250204.0
2016-10-20 14:00:00	AAPL	Stock	29.2225	29.3075	29.21	29.2975	8557956.0
2016-10-20 15:00:00	AAPL	Stock	29.2975	29.3125	29.22	29.2525	12887600.0
2016-10-20 16:00:00	AAPL	Stock	29.2525	29.315	29.2525	29.265	5329004.0
2016-10-20 17:00:00	AAPL	Stock	29.275	29.2875	29.265	29.275	51420.0
2016-10-20 18:00:00	AAPL	Stock	29.275	29.28	29.27	29.27	32160.0
2016-10-20 19:00:00	AAPL	Stock	29.2925	29.305	29.28	29.305	31252.0
2016-10-20 04:00:00	MSFT	Stock	57.8	57.82	57.8	57.82	600.0
2016-10-20 06:00:00	MSFT	Stock	57.74	57.74	57.74	57.74	100.0
2016-10-20 07:00:00	MSFT	Stock	57.73	57.79	57.66	57.73	5308.0
2016-10-20 08:00:00	MSFT	Stock	57.74	57.74	57.56	57.6	19815.0
2016-10-20 09:00:00	MSFT	Stock	57.6	57.6	56.78	57.17	4814037.0
2016-10-20 10:00:00	MSFT	Stock	57.165	57.31	56.66	56.779	6577010.0
2016-10-20 11:00:00	MSFT	Stock	56.77	57.08	56.76	57.07	3977857.0
2016-10-20 12:00:00	MSFT	Stock	57.07	57.275	57.055	57.19	3426462.0
2016-10-20 13:00:00	MSFT	Stock	57.18	57.21	56.9	57.01	4285672.0
2016-10-20 14:00:00	MSFT	Stock	57.02	57.16	56.97	57.15	4298389.0
2016-10-20 15:00:00	MSFT	Stock	57.155	57.37	57.07	57.24	10420501.0
2016-10-20 16:00:00	MSFT	Stock	57.25	60.59	57.07	60.44	7339798.0
2016-10-20 17:00:00	MSFT	Stock	60.43	60.79	60.35	60.54	721607.0
2016-10-20 18:00:00	MSFT	Stock	60.55	60.65	60.34	60.45	211920.0
2016-10-20 19:00:00	MSFT	Stock	60.45	60.63	60.4	60.63	126609.0
2016-10-20 07:00:00	NVDA	Stock	1.6725	1.675	1.6712	1.6725	56000.0
2016-10-20 08:00:00	NVDA	Stock	1.6712	1.6778	1.668	1.6728	397760.0
2016-10-20 09:00:00	NVDA	Stock	1.6728	1.6922	1.6728	1.6786	44656480.0
2016-10-20 10:00:00	NVDA	Stock	1.6782	1.6792	1.6575	1.6683	42462600.0
2016-10-20 11:00:00	NVDA	Stock	1.6682	1.68	1.6678	1.6795	28956720.0
2016-10-20 12:00:00	NVDA	Stock	1.6792	1.6898	1.6765	1.689	27211520.0
2016-10-20 13:00:00	NVDA	Stock	1.6888	1.6901	1.68	1.681	26783280.0
2016-10-20 14:00:00	NVDA	Stock	1.681	1.6988	1.6802	1.6945	38633600.0
2016-10-20 15:00:00	NVDA	Stock	1.6945	1.6958	1.6889	1.6932	63995080.0
2016-10-20 16:00:00	NVDA	Stock	1.6932	1.6975	1.684	1.6938	14137800.0
2016-10-20 17:00:00	NVDA	Stock	1.6962	1.6972	1.694	1.6972	160960.0
2016-10-20 18:00:00	NVDA	Stock	1.695	1.6975	1.695	1.6975	166160.0
2016-10-20 19:00:00	NVDA	Stock	1.6975	1.6975	1.6975	1.6975	14360.0
2016-10-20 06:00:00	AMZN	Stock	40.9465	40.9465	40.9465	40.9465	4000.0
2016-10-20 07:00:00	AMZN	Stock	40.9	40.9	40.825	40.825	20000.0
2016-10-20 08:00:00	AMZN	Stock	40.93	40.93	40.615	40.683	228520.0
2016-10-20 09:00:00	AMZN	Stock	40.695	40.725	40.155	40.5455	14666000.0
2016-10-20 10:00:00	AMZN	Stock	40.5391	40.6215	40.4	40.4815	7457780.0
2016-10-20 11:00:00	AMZN	Stock	40.476	40.5405	40.4265	40.5405	4571140.0
2016-10-20 12:00:00	AMZN	Stock	40.5485	40.7855	40.5145	40.6638	6469000.0

> showing 50 of 46,840 rows — these rows as CSV

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