PREVIEW / stock_1hour / 2017-09-22

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-09-22.parquet
  size:    1.0 MB
  rows:    47,591
  symbols: 2,958

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-09-22 04:00:00	AAPL	Stock	38.3125	38.325	38.255	38.3075	19216.0
2017-09-22 05:00:00	AAPL	Stock	38.255	38.255	38.0375	38.135	66672.0
2017-09-22 06:00:00	AAPL	Stock	38.1	38.1625	38.0625	38.1	40800.0
2017-09-22 07:00:00	AAPL	Stock	38.125	38.2	38.075	38.125	383224.0
2017-09-22 08:00:00	AAPL	Stock	38.1188	38.2125	38.065	38.16	741204.0
2017-09-22 09:00:00	AAPL	Stock	38.16	38.175	37.6925	37.767	37094956.0
2017-09-22 10:00:00	AAPL	Stock	37.7675	37.955	37.6425	37.6488	31988712.0
2017-09-22 11:00:00	AAPL	Stock	37.65	37.785	37.64	37.7725	20645120.0
2017-09-22 12:00:00	AAPL	Stock	37.7675	37.915	37.7175	37.7845	17433816.0
2017-09-22 13:00:00	AAPL	Stock	37.785	37.8962	37.7275	37.866	14244192.0
2017-09-22 14:00:00	AAPL	Stock	37.8645	37.98	37.7195	37.9175	13988180.0
2017-09-22 15:00:00	AAPL	Stock	37.915	38.0025	37.8352	37.94	23982516.0
2017-09-22 16:00:00	AAPL	Stock	37.94	37.985	37.9275	37.955	7559864.0
2017-09-22 17:00:00	AAPL	Stock	37.9625	37.9975	37.9525	37.9975	122816.0
2017-09-22 18:00:00	AAPL	Stock	37.995	37.9975	37.9875	37.9975	67392.0
2017-09-22 19:00:00	AAPL	Stock	37.9975	38.0	37.9925	37.9925	87000.0
2017-09-22 04:00:00	MSFT	Stock	74.25	74.25	74.18	74.18	300.0
2017-09-22 07:00:00	MSFT	Stock	74.22	74.22	74.15	74.15	2372.0
2017-09-22 08:00:00	MSFT	Stock	74.13	74.13	74.07	74.08	2892.0
2017-09-22 09:00:00	MSFT	Stock	74.07	74.29	73.85	74.12	1795103.0
2017-09-22 10:00:00	MSFT	Stock	74.125	74.45	74.11	74.22	1909699.0
2017-09-22 11:00:00	MSFT	Stock	74.22	74.31	74.18	74.27	1074896.0
2017-09-22 12:00:00	MSFT	Stock	74.275	74.39	74.23	74.325	941190.0
2017-09-22 13:00:00	MSFT	Stock	74.33	74.37	74.095	74.15	892114.0
2017-09-22 14:00:00	MSFT	Stock	74.15	74.22	74.11	74.15	1063853.0
2017-09-22 15:00:00	MSFT	Stock	74.155	74.51	74.14	74.36	3273667.0
2017-09-22 16:00:00	MSFT	Stock	74.41	74.41	74.33	74.33	2092307.0
2017-09-22 17:00:00	MSFT	Stock	74.33	74.33	74.33	74.33	100.0
2017-09-22 18:00:00	MSFT	Stock	74.41	74.41	74.41	74.41	218.0
2017-09-22 19:00:00	MSFT	Stock	74.36	74.39	74.36	74.36	1934.0
2017-09-22 04:00:00	NVDA	Stock	4.5138	4.5465	4.5138	4.5465	144960.0
2017-09-22 05:00:00	NVDA	Stock	4.528	4.528	4.528	4.528	14240.0
2017-09-22 06:00:00	NVDA	Stock	4.5388	4.5395	4.538	4.5395	65560.0
2017-09-22 07:00:00	NVDA	Stock	4.5392	4.5623	4.4915	4.5038	3491600.0
2017-09-22 08:00:00	NVDA	Stock	4.5495	4.5495	4.4908	4.5165	1770840.0
2017-09-22 09:00:00	NVDA	Stock	4.5175	4.5578	4.5	4.5042	118707240.0
2017-09-22 10:00:00	NVDA	Stock	4.5042	4.5362	4.4702	4.477	110047920.0
2017-09-22 11:00:00	NVDA	Stock	4.477	4.5095	4.4735	4.5008	65572680.0
2017-09-22 12:00:00	NVDA	Stock	4.501	4.5072	4.4873	4.5	34763600.0
2017-09-22 13:00:00	NVDA	Stock	4.4998	4.5034	4.4862	4.4882	28463080.0
2017-09-22 14:00:00	NVDA	Stock	4.4895	4.4922	4.4815	4.4875	32844560.0
2017-09-22 15:00:00	NVDA	Stock	4.4873	4.4922	4.465	4.4743	81562600.0
2017-09-22 16:00:00	NVDA	Stock	4.475	4.4798	4.4738	4.4778	2033600.0
2017-09-22 17:00:00	NVDA	Stock	4.4762	4.4762	4.4718	4.4725	247600.0
2017-09-22 18:00:00	NVDA	Stock	4.4702	4.4725	4.47	4.4725	241600.0
2017-09-22 19:00:00	NVDA	Stock	4.4725	4.4775	4.4713	4.475	414000.0
2017-09-22 04:00:00	AMZN	Stock	48.2	48.2	48.2	48.2	2000.0
2017-09-22 05:00:00	AMZN	Stock	48.205	48.205	48.205	48.205	2000.0
2017-09-22 06:00:00	AMZN	Stock	48.2325	48.2325	48.2325	48.2325	2000.0
2017-09-22 07:00:00	AMZN	Stock	48.2325	48.2325	48.175	48.175	15400.0

> showing 50 of 47,591 rows — these rows as CSV

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