PREVIEW / stock_1hour / 2017-05-25

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-05-25.parquet
  size:    1.0 MB
  rows:    48,023
  symbols: 3,037

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-05-25 04:00:00	AAPL	Stock	38.3575	38.3575	38.3575	38.3575	400.0
2017-05-25 05:00:00	AAPL	Stock	38.3925	38.4125	38.3925	38.4125	4344.0
2017-05-25 06:00:00	AAPL	Stock	38.4025	38.4425	38.3875	38.425	34320.0
2017-05-25 07:00:00	AAPL	Stock	38.4125	38.4525	38.375	38.4275	68668.0
2017-05-25 08:00:00	AAPL	Stock	38.4375	38.475	38.4	38.4425	284008.0
2017-05-25 09:00:00	AAPL	Stock	38.4475	38.4675	38.2625	38.285	10267904.0
2017-05-25 10:00:00	AAPL	Stock	38.285	38.4512	38.2575	38.4275	10922036.0
2017-05-25 11:00:00	AAPL	Stock	38.4288	38.525	38.395	38.4325	10959004.0
2017-05-25 12:00:00	AAPL	Stock	38.435	38.5875	38.4225	38.58	7903368.0
2017-05-25 13:00:00	AAPL	Stock	38.58	38.585	38.51	38.54	5776284.0
2017-05-25 14:00:00	AAPL	Stock	38.5375	38.5505	38.5125	38.5375	5060056.0
2017-05-25 15:00:00	AAPL	Stock	38.5388	38.5525	38.42	38.4775	14036024.0
2017-05-25 16:00:00	AAPL	Stock	38.4675	38.4675	38.435	38.4625	2549976.0
2017-05-25 17:00:00	AAPL	Stock	38.4525	38.4675	38.4525	38.4675	6412.0
2017-05-25 18:00:00	AAPL	Stock	38.45	38.4725	38.44	38.44	21960.0
2017-05-25 19:00:00	AAPL	Stock	38.4675	38.4725	38.45	38.45	27604.0
2017-05-25 04:00:00	MSFT	Stock	68.79	68.79	68.79	68.79	200.0
2017-05-25 06:00:00	MSFT	Stock	69.0	69.0	69.0	69.0	100.0
2017-05-25 07:00:00	MSFT	Stock	69.0	69.0	69.0	69.0	400.0
2017-05-25 08:00:00	MSFT	Stock	68.85	69.0	68.85	68.9	7562.0
2017-05-25 09:00:00	MSFT	Stock	68.96	69.1	68.91	69.08	1569087.0
2017-05-25 10:00:00	MSFT	Stock	69.084	69.45	69.055	69.43	2990665.0
2017-05-25 11:00:00	MSFT	Stock	69.424	69.48	69.2	69.275	2422823.0
2017-05-25 12:00:00	MSFT	Stock	69.275	69.55	69.253	69.55	1605178.0
2017-05-25 13:00:00	MSFT	Stock	69.55	69.55	69.42	69.545	1329988.0
2017-05-25 14:00:00	MSFT	Stock	69.54	69.81	69.49	69.73	2282431.0
2017-05-25 15:00:00	MSFT	Stock	69.735	69.88	69.58	69.62	4897783.0
2017-05-25 16:00:00	MSFT	Stock	69.63	69.68	69.55	69.68	3307389.0
2017-05-25 17:00:00	MSFT	Stock	69.71	69.71	69.53	69.53	2156.0
2017-05-25 18:00:00	MSFT	Stock	69.58	69.58	69.58	69.58	200.0
2017-05-25 19:00:00	MSFT	Stock	69.56	69.56	69.56	69.56	300.0
2017-05-25 04:00:00	NVDA	Stock	3.5112	3.5125	3.5112	3.5112	18040.0
2017-05-25 05:00:00	NVDA	Stock	3.4812	3.4812	3.4812	3.4812	6000.0
2017-05-25 06:00:00	NVDA	Stock	3.4938	3.4972	3.4812	3.4922	155360.0
2017-05-25 07:00:00	NVDA	Stock	3.495	3.498	3.4875	3.495	574720.0
2017-05-25 08:00:00	NVDA	Stock	3.495	3.4975	3.4788	3.484	2691920.0
2017-05-25 09:00:00	NVDA	Stock	3.484	3.5008	3.4335	3.4522	131282640.0
2017-05-25 10:00:00	NVDA	Stock	3.4525	3.4565	3.423	3.4288	113835880.0
2017-05-25 11:00:00	NVDA	Stock	3.4292	3.4388	3.411	3.4206	103769760.0
2017-05-25 12:00:00	NVDA	Stock	3.4208	3.4458	3.42	3.4452	62253120.0
2017-05-25 13:00:00	NVDA	Stock	3.4454	3.4508	3.44	3.4479	40434680.0
2017-05-25 14:00:00	NVDA	Stock	3.4478	3.465	3.4408	3.4642	51570840.0
2017-05-25 15:00:00	NVDA	Stock	3.4638	3.4693	3.4442	3.4565	78420040.0
2017-05-25 16:00:00	NVDA	Stock	3.4565	3.4575	3.4513	3.455	2885880.0
2017-05-25 17:00:00	NVDA	Stock	3.4522	3.4522	3.4505	3.4515	298360.0
2017-05-25 18:00:00	NVDA	Stock	3.455	3.4588	3.4515	3.4588	498840.0
2017-05-25 19:00:00	NVDA	Stock	3.4562	3.4595	3.4535	3.4578	296080.0
2017-05-25 06:00:00	AMZN	Stock	49.1715	49.254	49.1715	49.254	55040.0
2017-05-25 07:00:00	AMZN	Stock	49.271	49.271	49.1875	49.1875	213940.0
2017-05-25 08:00:00	AMZN	Stock	49.2125	49.225	49.175	49.204	443380.0

> showing 50 of 48,023 rows — these rows as CSV

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