PREVIEW / stock_1hour / 2017-03-29

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-29.parquet
  size:    1.0 MB
  rows:    48,170
  symbols: 3,095

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-03-29 04:00:00	AAPL	Stock	35.925	35.9975	35.925	35.9625	30984.0
2017-03-29 05:00:00	AAPL	Stock	35.905	35.905	35.905	35.905	4800.0
2017-03-29 06:00:00	AAPL	Stock	35.93	35.9425	35.905	35.905	15936.0
2017-03-29 07:00:00	AAPL	Stock	35.875	35.93	35.855	35.885	63692.0
2017-03-29 08:00:00	AAPL	Stock	35.885	35.925	35.875	35.9175	177892.0
2017-03-29 09:00:00	AAPL	Stock	35.905	36.05	35.7975	35.9525	22147616.0
2017-03-29 10:00:00	AAPL	Stock	35.9525	35.9602	35.8275	35.9162	15211928.0
2017-03-29 11:00:00	AAPL	Stock	35.915	35.9275	35.8175	35.8862	10888276.0
2017-03-29 12:00:00	AAPL	Stock	35.8852	35.9525	35.8775	35.8825	7177052.0
2017-03-29 13:00:00	AAPL	Stock	35.8825	36.075	35.8775	36.0525	9727284.0
2017-03-29 14:00:00	AAPL	Stock	36.0525	36.1075	36.005	36.0825	10191524.0
2017-03-29 15:00:00	AAPL	Stock	36.0825	36.1225	36.0	36.04	17724944.0
2017-03-29 16:00:00	AAPL	Stock	36.03	36.045	36.025	36.0375	6839116.0
2017-03-29 17:00:00	AAPL	Stock	36.045	36.045	36.02	36.02	22416.0
2017-03-29 18:00:00	AAPL	Stock	36.0375	36.0525	36.0275	36.0375	25636.0
2017-03-29 19:00:00	AAPL	Stock	36.0375	36.0625	36.035	36.0625	27160.0
2017-03-29 06:00:00	MSFT	Stock	65.24	65.24	65.24	65.24	241.0
2017-03-29 07:00:00	MSFT	Stock	65.24	65.24	65.24	65.24	100.0
2017-03-29 08:00:00	MSFT	Stock	65.2	65.2	65.2	65.2	600.0
2017-03-29 09:00:00	MSFT	Stock	65.3	65.35	65.02	65.22	1665524.0
2017-03-29 10:00:00	MSFT	Stock	65.225	65.24	65.09	65.106	1730869.0
2017-03-29 11:00:00	MSFT	Stock	65.1	65.15	64.948	65.05	1215392.0
2017-03-29 12:00:00	MSFT	Stock	65.055	65.12	65.01	65.07	704374.0
2017-03-29 13:00:00	MSFT	Stock	65.06	65.26	65.06	65.26	1302569.0
2017-03-29 14:00:00	MSFT	Stock	65.25	65.34	65.205	65.3	1239151.0
2017-03-29 15:00:00	MSFT	Stock	65.305	65.5	65.28	65.48	3263471.0
2017-03-29 16:00:00	MSFT	Stock	65.47	65.57	65.47	65.5	1125402.0
2017-03-29 17:00:00	MSFT	Stock	65.49	65.49	65.49	65.49	105.0
2017-03-29 18:00:00	MSFT	Stock	65.49	65.5	65.49	65.5	200.0
2017-03-29 19:00:00	MSFT	Stock	65.5	65.51	65.47	65.51	3954.0
2017-03-29 05:00:00	NVDA	Stock	2.6962	2.6962	2.6962	2.6962	4400.0
2017-03-29 07:00:00	NVDA	Stock	2.6948	2.6948	2.6948	2.6948	62480.0
2017-03-29 08:00:00	NVDA	Stock	2.6973	2.702	2.6888	2.6995	378560.0
2017-03-29 09:00:00	NVDA	Stock	2.6973	2.7122	2.683	2.7018	60604080.0
2017-03-29 10:00:00	NVDA	Stock	2.7015	2.7115	2.6973	2.7037	66875320.0
2017-03-29 11:00:00	NVDA	Stock	2.7038	2.705	2.6875	2.6973	52251360.0
2017-03-29 12:00:00	NVDA	Stock	2.6973	2.6973	2.6832	2.6843	35881160.0
2017-03-29 13:00:00	NVDA	Stock	2.6843	2.693	2.6815	2.6905	27463560.0
2017-03-29 14:00:00	NVDA	Stock	2.6905	2.6908	2.6825	2.686	22268720.0
2017-03-29 15:00:00	NVDA	Stock	2.686	2.6901	2.6813	2.683	38373440.0
2017-03-29 16:00:00	NVDA	Stock	2.6835	2.6888	2.6823	2.6838	39055320.0
2017-03-29 17:00:00	NVDA	Stock	2.6872	2.6888	2.685	2.6863	148400.0
2017-03-29 18:00:00	NVDA	Stock	2.6882	2.6885	2.685	2.685	143400.0
2017-03-29 19:00:00	NVDA	Stock	2.6863	2.6885	2.686	2.686	44000.0
2017-03-29 04:00:00	AMZN	Stock	43.0005	43.05	43.0005	43.05	8260.0
2017-03-29 05:00:00	AMZN	Stock	43.05	43.05	43.0025	43.0025	25220.0
2017-03-29 06:00:00	AMZN	Stock	42.954	42.9975	42.954	42.9975	12000.0
2017-03-29 07:00:00	AMZN	Stock	42.9945	43.0	42.9375	43.0	94080.0
2017-03-29 08:00:00	AMZN	Stock	42.9915	43.001	42.95	42.975	173540.0
2017-03-29 09:00:00	AMZN	Stock	42.975	43.223	42.951	43.2225	12749740.0

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

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