PREVIEW / stock_1hour / 2018-07-12

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-12.parquet
  size:    1.1 MB
  rows:    49,112
  symbols: 2,829

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
2018-07-12 04:00:00	AAPL	Stock	47.1175	47.1525	47.1175	47.1525	6988.0
2018-07-12 05:00:00	AAPL	Stock	47.15	47.15	47.15	47.15	2800.0
2018-07-12 06:00:00	AAPL	Stock	47.0875	47.2625	47.0875	47.2625	5100.0
2018-07-12 07:00:00	AAPL	Stock	47.2625	47.3	47.25	47.3	72164.0
2018-07-12 08:00:00	AAPL	Stock	47.2675	47.3525	47.2525	47.3375	296024.0
2018-07-12 09:00:00	AAPL	Stock	47.3375	47.5925	47.2925	47.505	9904960.0
2018-07-12 10:00:00	AAPL	Stock	47.5025	47.665	47.495	47.5075	8829232.0
2018-07-12 11:00:00	AAPL	Stock	47.5075	47.75	47.5	47.7425	7861220.0
2018-07-12 12:00:00	AAPL	Stock	47.7425	47.8275	47.665	47.8	7025748.0
2018-07-12 13:00:00	AAPL	Stock	47.8015	47.8525	47.6775	47.69	5266320.0
2018-07-12 14:00:00	AAPL	Stock	47.69	47.775	47.645	47.7662	3895532.0
2018-07-12 15:00:00	AAPL	Stock	47.765	47.79	47.645	47.76	11092252.0
2018-07-12 16:00:00	AAPL	Stock	47.7575	47.7775	47.705	47.72	9720596.0
2018-07-12 17:00:00	AAPL	Stock	47.72	47.7575	47.7125	47.72	171336.0
2018-07-12 18:00:00	AAPL	Stock	47.705	47.72	47.625	47.7	49452.0
2018-07-12 19:00:00	AAPL	Stock	47.7	47.7775	47.7	47.7725	97400.0
2018-07-12 04:00:00	MSFT	Stock	102.4	102.4	102.15	102.15	200.0
2018-07-12 05:00:00	MSFT	Stock	102.5	102.5	102.5	102.5	200.0
2018-07-12 06:00:00	MSFT	Stock	102.49	102.63	102.49	102.62	2800.0
2018-07-12 07:00:00	MSFT	Stock	102.41	102.65	102.4	102.65	16142.0
2018-07-12 08:00:00	MSFT	Stock	102.45	102.72	102.45	102.71	42824.0
2018-07-12 09:00:00	MSFT	Stock	102.71	103.32	102.58	103.164	3459549.0
2018-07-12 10:00:00	MSFT	Stock	103.16	103.53	103.1	103.405	3473645.0
2018-07-12 11:00:00	MSFT	Stock	103.41	104.15	103.405	104.145	2541963.0
2018-07-12 12:00:00	MSFT	Stock	104.135	104.41	103.94	104.07	2468961.0
2018-07-12 13:00:00	MSFT	Stock	104.074	104.355	104.07	104.18	1557660.0
2018-07-12 14:00:00	MSFT	Stock	104.18	104.38	104.07	104.21	1756581.0
2018-07-12 15:00:00	MSFT	Stock	104.2	104.29	103.88	104.16	4320814.0
2018-07-12 16:00:00	MSFT	Stock	104.19	104.27	104.0	104.15	2595133.0
2018-07-12 17:00:00	MSFT	Stock	104.15	104.15	104.023	104.05	1142.0
2018-07-12 18:00:00	MSFT	Stock	104.14	104.19	104.14	104.19	1595.0
2018-07-12 19:00:00	MSFT	Stock	104.15	104.41	104.15	104.4	2416.0
2018-07-12 04:00:00	NVDA	Stock	6.215	6.2153	6.215	6.215	33040.0
2018-07-12 06:00:00	NVDA	Stock	6.2158	6.2298	6.2125	6.2298	51400.0
2018-07-12 07:00:00	NVDA	Stock	6.225	6.252	6.225	6.2462	700200.0
2018-07-12 08:00:00	NVDA	Stock	6.2373	6.25	6.2133	6.2375	1569240.0
2018-07-12 09:00:00	NVDA	Stock	6.238	6.3058	6.224	6.3038	63760760.0
2018-07-12 10:00:00	NVDA	Stock	6.3058	6.3292	6.2922	6.2922	63431520.0
2018-07-12 11:00:00	NVDA	Stock	6.295	6.322	6.291	6.3158	34734960.0
2018-07-12 12:00:00	NVDA	Stock	6.3165	6.325	6.2943	6.2943	22400600.0
2018-07-12 13:00:00	NVDA	Stock	6.2961	6.3023	6.2675	6.272	36232600.0
2018-07-12 14:00:00	NVDA	Stock	6.2717	6.297	6.2665	6.2833	24238840.0
2018-07-12 15:00:00	NVDA	Stock	6.285	6.305	6.273	6.2808	55552720.0
2018-07-12 16:00:00	NVDA	Stock	6.2775	6.2808	6.2693	6.28	3274320.0
2018-07-12 17:00:00	NVDA	Stock	6.275	6.28	6.275	6.2785	59400.0
2018-07-12 18:00:00	NVDA	Stock	6.2733	6.2853	6.2733	6.285	156480.0
2018-07-12 19:00:00	NVDA	Stock	6.285	6.2888	6.285	6.2875	178120.0
2018-07-12 04:00:00	AMZN	Stock	88.0	88.0995	88.0	88.0505	34740.0
2018-07-12 05:00:00	AMZN	Stock	88.2495	88.2495	88.2495	88.2495	4060.0
2018-07-12 06:00:00	AMZN	Stock	88.2425	88.2425	88.1985	88.225	37700.0

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

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