PREVIEW / stock_1hour / 2019-06-19

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-06-19.parquet
  size:    1.1 MB
  rows:    50,273
  symbols: 2,573

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-06-19 04:00:00	AAPL	Stock	49.77	49.77	49.5625	49.575	13144.0
2019-06-19 05:00:00	AAPL	Stock	49.625	49.85	49.5875	49.85	23964.0
2019-06-19 06:00:00	AAPL	Stock	49.7875	49.9	49.7675	49.875	32868.0
2019-06-19 07:00:00	AAPL	Stock	49.875	49.91	49.7175	49.8575	62968.0
2019-06-19 08:00:00	AAPL	Stock	49.725	49.925	49.725	49.83	240352.0
2019-06-19 09:00:00	AAPL	Stock	49.8615	49.9325	49.4625	49.5875	9525612.0
2019-06-19 10:00:00	AAPL	Stock	49.5925	49.6745	49.4825	49.615	8474748.0
2019-06-19 11:00:00	AAPL	Stock	49.6175	49.685	49.5025	49.5475	4416684.0
2019-06-19 12:00:00	AAPL	Stock	49.545	49.5925	49.5025	49.5275	3975620.0
2019-06-19 13:00:00	AAPL	Stock	49.5275	49.54	49.36	49.5075	5233668.0
2019-06-19 14:00:00	AAPL	Stock	49.5	49.97	49.3275	49.5012	16416788.0
2019-06-19 15:00:00	AAPL	Stock	49.5025	49.6975	49.4375	49.465	13496388.0
2019-06-19 16:00:00	AAPL	Stock	49.4625	49.52	49.4	49.4675	10748908.0
2019-06-19 17:00:00	AAPL	Stock	49.41	49.4675	49.41	49.4675	4040.0
2019-06-19 18:00:00	AAPL	Stock	49.425	49.555	49.425	49.555	38080.0
2019-06-19 19:00:00	AAPL	Stock	49.5625	49.65	49.55	49.59	73664.0
2019-06-19 04:00:00	MSFT	Stock	135.75	135.75	135.53	135.53	475.0
2019-06-19 05:00:00	MSFT	Stock	135.5	135.6	135.19	135.4	1871.0
2019-06-19 06:00:00	MSFT	Stock	135.55	135.55	135.25	135.35	3983.0
2019-06-19 07:00:00	MSFT	Stock	135.55	135.55	135.26	135.33	12221.0
2019-06-19 08:00:00	MSFT	Stock	135.3	135.6	135.16	135.16	35029.0
2019-06-19 09:00:00	MSFT	Stock	135.35	135.4	134.21	134.518	2470269.0
2019-06-19 10:00:00	MSFT	Stock	134.51	134.56	134.08	134.415	2048220.0
2019-06-19 11:00:00	MSFT	Stock	134.43	134.64	134.3	134.595	1350926.0
2019-06-19 12:00:00	MSFT	Stock	134.61	134.65	134.255	134.355	873354.0
2019-06-19 13:00:00	MSFT	Stock	134.35	134.355	133.88	134.18	1364756.0
2019-06-19 14:00:00	MSFT	Stock	134.16	135.23	133.81	135.02	3215710.0
2019-06-19 15:00:00	MSFT	Stock	135.02	135.93	134.98	135.59	4215885.0
2019-06-19 16:00:00	MSFT	Stock	135.69	135.95	135.69	135.734	4897095.0
2019-06-19 17:00:00	MSFT	Stock	135.72	135.85	135.69	135.69	7581.0
2019-06-19 18:00:00	MSFT	Stock	135.83	135.95	135.83	135.95	3532.0
2019-06-19 19:00:00	MSFT	Stock	135.95	136.3	135.95	136.3	8349.0
2019-06-19 04:00:00	NVDA	Stock	3.8695	3.8695	3.8618	3.8668	74000.0
2019-06-19 06:00:00	NVDA	Stock	3.8648	3.8738	3.8648	3.8675	24000.0
2019-06-19 07:00:00	NVDA	Stock	3.8625	3.8625	3.8408	3.8475	649920.0
2019-06-19 08:00:00	NVDA	Stock	3.85	3.8625	3.8388	3.8548	1346880.0
2019-06-19 09:00:00	NVDA	Stock	3.8548	3.865	3.8065	3.8128	67934120.0
2019-06-19 10:00:00	NVDA	Stock	3.813	3.8305	3.8093	3.8128	36857960.0
2019-06-19 11:00:00	NVDA	Stock	3.8138	3.8388	3.8112	3.8362	32806360.0
2019-06-19 12:00:00	NVDA	Stock	3.8371	3.841	3.8188	3.8242	22923400.0
2019-06-19 13:00:00	NVDA	Stock	3.824	3.8258	3.81	3.8153	21763520.0
2019-06-19 14:00:00	NVDA	Stock	3.8158	3.8689	3.8019	3.8154	54475360.0
2019-06-19 15:00:00	NVDA	Stock	3.8168	3.8361	3.815	3.8278	43941320.0
2019-06-19 16:00:00	NVDA	Stock	3.828	3.834	3.8218	3.822	6078520.0
2019-06-19 17:00:00	NVDA	Stock	3.825	3.828	3.8182	3.8182	2551000.0
2019-06-19 18:00:00	NVDA	Stock	3.8235	3.8352	3.82	3.8352	242960.0
2019-06-19 19:00:00	NVDA	Stock	3.8375	3.841	3.8338	3.8408	579640.0
2019-06-19 04:00:00	AMZN	Stock	95.482	95.482	95.425	95.425	9120.0
2019-06-19 06:00:00	AMZN	Stock	95.4695	95.4695	95.4695	95.4695	6100.0
2019-06-19 07:00:00	AMZN	Stock	95.311	95.35	95.3	95.35	19760.0

> showing 50 of 50,273 rows — these rows as CSV

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