PREVIEW / stock_1hour / 2017-01-19

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-01-19.parquet
  size:    1.0 MB
  rows:    48,026
  symbols: 3,113

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-01-19 05:00:00	AAPL	Stock	29.9775	29.9775	29.9625	29.9625	10148.0
2017-01-19 06:00:00	AAPL	Stock	30.0	30.0625	29.9925	30.0125	88328.0
2017-01-19 07:00:00	AAPL	Stock	30.0125	30.0125	29.9275	29.9375	112616.0
2017-01-19 08:00:00	AAPL	Stock	29.98	29.98	29.875	29.9	463728.0
2017-01-19 09:00:00	AAPL	Stock	29.905	30.0125	29.78	30.005	16157108.0
2017-01-19 10:00:00	AAPL	Stock	30.005	30.0125	29.9075	29.9625	10593828.0
2017-01-19 11:00:00	AAPL	Stock	29.9625	30.0225	29.9275	30.0025	9691052.0
2017-01-19 12:00:00	AAPL	Stock	30.0025	30.0075	29.945	29.96	9070264.0
2017-01-19 13:00:00	AAPL	Stock	29.96	29.9625	29.92	29.95	5060192.0
2017-01-19 14:00:00	AAPL	Stock	29.95	29.9725	29.8775	29.893	7943272.0
2017-01-19 15:00:00	AAPL	Stock	29.895	29.9475	29.88	29.9425	15206692.0
2017-01-19 16:00:00	AAPL	Stock	29.9425	30.0325	29.9175	29.97	11704476.0
2017-01-19 17:00:00	AAPL	Stock	29.97	29.97	29.93	29.9325	52216.0
2017-01-19 18:00:00	AAPL	Stock	29.9425	29.9625	29.94	29.9625	78200.0
2017-01-19 19:00:00	AAPL	Stock	29.96	29.9675	29.95	29.9575	21188.0
2017-01-19 07:00:00	MSFT	Stock	62.5	62.5	62.5	62.5	779.0
2017-01-19 08:00:00	MSFT	Stock	62.5	62.5	62.31	62.31	341.0
2017-01-19 09:00:00	MSFT	Stock	62.29	62.98	62.21	62.91	2766198.0
2017-01-19 10:00:00	MSFT	Stock	62.915	62.945	62.5	62.555	2419857.0
2017-01-19 11:00:00	MSFT	Stock	62.55	62.615	62.405	62.545	1504012.0
2017-01-19 12:00:00	MSFT	Stock	62.54	62.58	62.445	62.515	1130299.0
2017-01-19 13:00:00	MSFT	Stock	62.515	62.57	62.36	62.395	1498581.0
2017-01-19 14:00:00	MSFT	Stock	62.395	62.41	62.205	62.21	2122388.0
2017-01-19 15:00:00	MSFT	Stock	62.213	62.39	62.195	62.29	3437075.0
2017-01-19 16:00:00	MSFT	Stock	62.3	62.49	62.21	62.21	2155413.0
2017-01-19 17:00:00	MSFT	Stock	62.4	62.42	62.4	62.42	1000.0
2017-01-19 18:00:00	MSFT	Stock	62.35	62.35	62.35	62.35	100.0
2017-01-19 19:00:00	MSFT	Stock	62.32	62.32	62.32	62.32	150.0
2017-01-19 07:00:00	NVDA	Stock	2.5855	2.5922	2.5813	2.5813	104000.0
2017-01-19 08:00:00	NVDA	Stock	2.5875	2.5922	2.5645	2.585	776360.0
2017-01-19 09:00:00	NVDA	Stock	2.585	2.6288	2.5745	2.6205	102911680.0
2017-01-19 10:00:00	NVDA	Stock	2.6208	2.6408	2.5965	2.6296	114214600.0
2017-01-19 11:00:00	NVDA	Stock	2.6293	2.6468	2.612	2.6438	69308200.0
2017-01-19 12:00:00	NVDA	Stock	2.644	2.656	2.6378	2.6542	41167960.0
2017-01-19 13:00:00	NVDA	Stock	2.6541	2.6615	2.639	2.6588	51948720.0
2017-01-19 14:00:00	NVDA	Stock	2.6592	2.6592	2.631	2.636	95278200.0
2017-01-19 15:00:00	NVDA	Stock	2.636	2.6558	2.6258	2.6288	90262200.0
2017-01-19 16:00:00	NVDA	Stock	2.63	2.6388	2.6285	2.6365	17716360.0
2017-01-19 17:00:00	NVDA	Stock	2.6368	2.6375	2.6312	2.637	368600.0
2017-01-19 18:00:00	NVDA	Stock	2.6345	2.6363	2.6338	2.6363	105600.0
2017-01-19 19:00:00	NVDA	Stock	2.635	2.6372	2.6338	2.637	350400.0
2017-01-19 05:00:00	AMZN	Stock	40.406	40.406	40.406	40.406	3360.0
2017-01-19 06:00:00	AMZN	Stock	40.4485	40.4485	40.4485	40.4485	2000.0
2017-01-19 07:00:00	AMZN	Stock	40.4935	40.4935	40.484	40.484	11700.0
2017-01-19 08:00:00	AMZN	Stock	40.4945	40.5895	40.474	40.5125	151380.0
2017-01-19 09:00:00	AMZN	Stock	40.5125	40.6755	40.41	40.634	9371380.0
2017-01-19 10:00:00	AMZN	Stock	40.6235	40.6755	40.4155	40.45	9096740.0
2017-01-19 11:00:00	AMZN	Stock	40.4455	40.532	40.3885	40.481	5843420.0
2017-01-19 12:00:00	AMZN	Stock	40.4675	40.556	40.455	40.5448	2808740.0
2017-01-19 13:00:00	AMZN	Stock	40.543	40.56	40.4685	40.4801	2846600.0

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

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