PREVIEW / stock_1hour / 2017-10-03

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-03.parquet
  size:    1.1 MB
  rows:    48,637
  symbols: 2,977

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-10-03 04:00:00	AAPL	Stock	38.4425	38.4425	38.4425	38.4425	3200.0
2017-10-03 05:00:00	AAPL	Stock	38.4625	38.4625	38.4625	38.4625	400.0
2017-10-03 07:00:00	AAPL	Stock	38.4625	38.4625	38.4375	38.445	54732.0
2017-10-03 08:00:00	AAPL	Stock	38.4425	38.505	38.44	38.4725	92380.0
2017-10-03 09:00:00	AAPL	Stock	38.47	38.755	38.465	38.578	11555192.0
2017-10-03 10:00:00	AAPL	Stock	38.5795	38.65	38.5088	38.6028	9380388.0
2017-10-03 11:00:00	AAPL	Stock	38.6	38.6825	38.5825	38.67	6232392.0
2017-10-03 12:00:00	AAPL	Stock	38.67	38.7725	38.65	38.6785	7641424.0
2017-10-03 13:00:00	AAPL	Stock	38.6788	38.6875	38.6287	38.685	3824120.0
2017-10-03 14:00:00	AAPL	Stock	38.6862	38.7385	38.66	38.685	4897760.0
2017-10-03 15:00:00	AAPL	Stock	38.6872	38.6888	38.5775	38.6175	11166384.0
2017-10-03 16:00:00	AAPL	Stock	38.62	38.6375	38.5975	38.6325	3774868.0
2017-10-03 17:00:00	AAPL	Stock	38.6325	38.6425	38.6275	38.6275	30872.0
2017-10-03 18:00:00	AAPL	Stock	38.6425	38.6425	38.625	38.625	8796.0
2017-10-03 19:00:00	AAPL	Stock	38.625	38.625	38.625	38.625	17600.0
2017-10-03 04:00:00	MSFT	Stock	74.74	74.74	74.74	74.74	200.0
2017-10-03 07:00:00	MSFT	Stock	74.61	74.61	74.61	74.61	100.0
2017-10-03 08:00:00	MSFT	Stock	74.73	74.73	74.58	74.69	1738.0
2017-10-03 09:00:00	MSFT	Stock	74.6	74.88	74.46	74.81	1150793.0
2017-10-03 10:00:00	MSFT	Stock	74.82	74.85	74.46	74.61	1376588.0
2017-10-03 11:00:00	MSFT	Stock	74.61	74.63	74.41	74.41	947170.0
2017-10-03 12:00:00	MSFT	Stock	74.41	74.42	74.31	74.354	865115.0
2017-10-03 13:00:00	MSFT	Stock	74.35	74.41	74.23	74.243	1133457.0
2017-10-03 14:00:00	MSFT	Stock	74.25	74.345	74.23	74.23	1155967.0
2017-10-03 15:00:00	MSFT	Stock	74.231	74.345	74.195	74.27	3026498.0
2017-10-03 16:00:00	MSFT	Stock	74.26	74.34	74.25	74.34	1346978.0
2017-10-03 17:00:00	MSFT	Stock	74.29	74.29	74.29	74.29	340.0
2017-10-03 18:00:00	MSFT	Stock	74.29	74.29	74.26	74.29	3220.0
2017-10-03 19:00:00	MSFT	Stock	74.31	74.31	74.31	74.31	226.0
2017-10-03 04:00:00	NVDA	Stock	4.4972	4.5125	4.4972	4.5078	20000.0
2017-10-03 05:00:00	NVDA	Stock	4.4975	4.5	4.4975	4.5	48000.0
2017-10-03 06:00:00	NVDA	Stock	4.4975	4.506	4.4788	4.4788	384040.0
2017-10-03 07:00:00	NVDA	Stock	4.495	4.4975	4.484	4.4875	565000.0
2017-10-03 08:00:00	NVDA	Stock	4.4875	4.4955	4.4812	4.4848	809400.0
2017-10-03 09:00:00	NVDA	Stock	4.482	4.49	4.4395	4.464	77358160.0
2017-10-03 10:00:00	NVDA	Stock	4.4645	4.5145	4.463	4.5001	114183400.0
2017-10-03 11:00:00	NVDA	Stock	4.5	4.5048	4.48	4.4875	40653640.0
2017-10-03 12:00:00	NVDA	Stock	4.4875	4.4962	4.4838	4.4865	23977080.0
2017-10-03 13:00:00	NVDA	Stock	4.4862	4.5018	4.4825	4.4968	24289560.0
2017-10-03 14:00:00	NVDA	Stock	4.4967	4.4988	4.4825	4.4845	16973200.0
2017-10-03 15:00:00	NVDA	Stock	4.4846	4.4858	4.4693	4.484	45478480.0
2017-10-03 16:00:00	NVDA	Stock	4.4842	4.4875	4.479	4.4855	7858760.0
2017-10-03 17:00:00	NVDA	Stock	4.485	4.49	4.4812	4.49	322800.0
2017-10-03 18:00:00	NVDA	Stock	4.4918	4.492	4.4862	4.4862	220720.0
2017-10-03 19:00:00	NVDA	Stock	4.4842	4.485	4.4805	4.485	416600.0
2017-10-03 08:00:00	AMZN	Stock	47.9895	47.9895	47.925	47.925	25460.0
2017-10-03 09:00:00	AMZN	Stock	47.852	48.0275	47.818	47.89	4372300.0
2017-10-03 10:00:00	AMZN	Stock	47.8957	48.06	47.5185	48.0285	13810600.0
2017-10-03 11:00:00	AMZN	Stock	48.0208	48.0285	47.8765	47.943	4353300.0
2017-10-03 12:00:00	AMZN	Stock	47.9408	48.137	47.9085	48.112	5149480.0

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

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