PREVIEW / stock_1hour / 2019-04-22

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-22.parquet
  size:    1.1 MB
  rows:    49,788
  symbols: 2,630

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
2019-04-22 04:00:00	AAPL	Stock	50.9	50.9	50.9	50.9	400.0
2019-04-22 05:00:00	AAPL	Stock	50.825	50.825	50.8125	50.8125	800.0
2019-04-22 07:00:00	AAPL	Stock	50.8675	50.875	50.7825	50.8	41120.0
2019-04-22 08:00:00	AAPL	Stock	50.875	50.875	50.6875	50.6875	237592.0
2019-04-22 09:00:00	AAPL	Stock	50.7	51.0975	50.585	50.909	12550880.0
2019-04-22 10:00:00	AAPL	Stock	50.9075	51.16	50.815	51.1562	8270140.0
2019-04-22 11:00:00	AAPL	Stock	51.1575	51.235	51.1125	51.15	6319224.0
2019-04-22 12:00:00	AAPL	Stock	51.15	51.1825	51.1025	51.1275	3607904.0
2019-04-22 13:00:00	AAPL	Stock	51.1287	51.164	51.045	51.116	4911760.0
2019-04-22 14:00:00	AAPL	Stock	51.1175	51.165	51.015	51.07	4808208.0
2019-04-22 15:00:00	AAPL	Stock	51.0675	51.175	51.0175	51.16	7552444.0
2019-04-22 16:00:00	AAPL	Stock	51.1325	51.215	51.1	51.145	15335776.0
2019-04-22 17:00:00	AAPL	Stock	51.1375	51.1475	51.1	51.1	47468.0
2019-04-22 18:00:00	AAPL	Stock	51.1	51.15	51.09	51.1325	13724.0
2019-04-22 19:00:00	AAPL	Stock	51.135	51.15	51.1	51.1325	22236.0
2019-04-22 04:00:00	MSFT	Stock	123.14	123.14	123.14	123.14	100.0
2019-04-22 07:00:00	MSFT	Stock	123.49	123.49	123.04	123.15	15400.0
2019-04-22 08:00:00	MSFT	Stock	123.4	123.45	122.88	122.92	27517.0
2019-04-22 09:00:00	MSFT	Stock	122.95	123.41	122.57	123.285	2053648.0
2019-04-22 10:00:00	MSFT	Stock	123.28	123.87	123.28	123.7	2226671.0
2019-04-22 11:00:00	MSFT	Stock	123.7	124.0	123.6	123.795	1663312.0
2019-04-22 12:00:00	MSFT	Stock	123.79	123.82	123.565	123.576	1125228.0
2019-04-22 13:00:00	MSFT	Stock	123.58	123.67	123.364	123.604	1241292.0
2019-04-22 14:00:00	MSFT	Stock	123.61	123.7	123.5	123.597	990191.0
2019-04-22 15:00:00	MSFT	Stock	123.6	123.77	123.46	123.76	2370127.0
2019-04-22 16:00:00	MSFT	Stock	123.76	123.8	123.66	123.8	1119973.0
2019-04-22 17:00:00	MSFT	Stock	123.78	123.85	123.78	123.81	6282.0
2019-04-22 18:00:00	MSFT	Stock	123.81	123.81	123.68	123.68	1535.0
2019-04-22 19:00:00	MSFT	Stock	123.76	123.87	123.76	123.79	5389.0
2019-04-22 07:00:00	NVDA	Stock	4.65	4.65	4.65	4.65	14480.0
2019-04-22 08:00:00	NVDA	Stock	4.6575	4.6575	4.625	4.625	371920.0
2019-04-22 09:00:00	NVDA	Stock	4.628	4.65	4.602	4.6408	39569280.0
2019-04-22 10:00:00	NVDA	Stock	4.6408	4.6812	4.6318	4.6798	44101800.0
2019-04-22 11:00:00	NVDA	Stock	4.68	4.692	4.6771	4.6848	30929320.0
2019-04-22 12:00:00	NVDA	Stock	4.6838	4.707	4.6828	4.7013	27276080.0
2019-04-22 13:00:00	NVDA	Stock	4.7005	4.714	4.6955	4.713	18278520.0
2019-04-22 14:00:00	NVDA	Stock	4.7135	4.7275	4.712	4.7198	18504800.0
2019-04-22 15:00:00	NVDA	Stock	4.72	4.7255	4.703	4.7112	38831320.0
2019-04-22 16:00:00	NVDA	Stock	4.7118	4.7155	4.7076	4.7138	32513560.0
2019-04-22 17:00:00	NVDA	Stock	4.7152	4.7175	4.7075	4.7125	142200.0
2019-04-22 18:00:00	NVDA	Stock	4.7175	4.7175	4.7	4.705	241760.0
2019-04-22 19:00:00	NVDA	Stock	4.705	4.71	4.7022	4.7022	197360.0
2019-04-22 04:00:00	AMZN	Stock	92.95	92.95	92.95	92.95	4000.0
2019-04-22 07:00:00	AMZN	Stock	92.935	92.935	92.85	92.855	15740.0
2019-04-22 08:00:00	AMZN	Stock	92.8924	92.9	92.6585	92.7125	216320.0
2019-04-22 09:00:00	AMZN	Stock	92.75	92.924	92.282	92.907	8565160.0
2019-04-22 10:00:00	AMZN	Stock	92.885	93.5355	92.828	93.5355	8440080.0
2019-04-22 11:00:00	AMZN	Stock	93.539	93.9245	93.4575	93.8393	7091340.0
2019-04-22 12:00:00	AMZN	Stock	93.827	94.15	93.7831	94.15	8933620.0
2019-04-22 13:00:00	AMZN	Stock	94.1532	94.4082	94.015	94.3707	6066520.0

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

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