PREVIEW / stock_1hour / 2016-07-27

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-07-27.parquet
  size:    1.0 MB
  rows:    48,914
  symbols: 3,275

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
2016-07-27 04:00:00	AAPL	Stock	25.465	25.7975	25.465	25.62	279536.0
2016-07-27 05:00:00	AAPL	Stock	25.625	25.65	25.56	25.6375	196336.0
2016-07-27 06:00:00	AAPL	Stock	25.6375	25.8375	25.6375	25.7975	711300.0
2016-07-27 07:00:00	AAPL	Stock	25.8	25.9875	25.785	25.9375	2568368.0
2016-07-27 08:00:00	AAPL	Stock	25.9375	26.0925	25.6125	26.025	10438668.0
2016-07-27 09:00:00	AAPL	Stock	26.025	26.17	25.89	25.9938	103633216.0
2016-07-27 10:00:00	AAPL	Stock	25.995	26.05	25.765	25.7752	59874880.0
2016-07-27 11:00:00	AAPL	Stock	25.7775	25.7875	25.6875	25.7377	34670596.0
2016-07-27 12:00:00	AAPL	Stock	25.7375	25.78	25.72	25.751	20920624.0
2016-07-27 13:00:00	AAPL	Stock	25.7512	25.835	25.745	25.8122	20184188.0
2016-07-27 14:00:00	AAPL	Stock	25.81	25.9425	25.7475	25.9025	27673252.0
2016-07-27 15:00:00	AAPL	Stock	25.9025	25.95	25.6875	25.7425	41564712.0
2016-07-27 16:00:00	AAPL	Stock	25.7375	25.99	25.7375	25.79	11831148.0
2016-07-27 17:00:00	AAPL	Stock	25.7875	25.85	25.7375	25.8125	4500804.0
2016-07-27 18:00:00	AAPL	Stock	25.8125	25.835	25.78	25.8	148016.0
2016-07-27 19:00:00	AAPL	Stock	25.8	25.8625	25.8	25.8575	153788.0
2016-07-27 05:00:00	MSFT	Stock	56.95	56.96	56.95	56.96	879.0
2016-07-27 06:00:00	MSFT	Stock	56.8	56.8	56.74	56.74	689.0
2016-07-27 07:00:00	MSFT	Stock	56.75	56.95	56.74	56.94	6613.0
2016-07-27 08:00:00	MSFT	Stock	56.93	56.93	56.74	56.74	11434.0
2016-07-27 09:00:00	MSFT	Stock	56.76	56.8	56.3	56.59	3861227.0
2016-07-27 10:00:00	MSFT	Stock	56.585	56.585	56.24	56.375	4506250.0
2016-07-27 11:00:00	MSFT	Stock	56.38	56.49	56.32	56.34	2490868.0
2016-07-27 12:00:00	MSFT	Stock	56.33	56.45	56.31	56.355	1945002.0
2016-07-27 13:00:00	MSFT	Stock	56.35	56.37	56.18	56.298	2950631.0
2016-07-27 14:00:00	MSFT	Stock	56.3	56.495	56.11	56.44	5201944.0
2016-07-27 15:00:00	MSFT	Stock	56.44	56.52	56.18	56.19	6657992.0
2016-07-27 16:00:00	MSFT	Stock	56.19	56.605	56.1	56.18	3062033.0
2016-07-27 17:00:00	MSFT	Stock	56.2	56.2	56.16	56.19	125413.0
2016-07-27 18:00:00	MSFT	Stock	56.18	56.2	56.18	56.2	1500.0
2016-07-27 19:00:00	MSFT	Stock	56.19	56.19	56.18	56.18	1200.0
2016-07-27 06:00:00	NVDA	Stock	1.4408	1.4408	1.4408	1.4408	23960.0
2016-07-27 07:00:00	NVDA	Stock	1.4408	1.4425	1.44	1.441	117640.0
2016-07-27 08:00:00	NVDA	Stock	1.4413	1.4413	1.435	1.4375	533040.0
2016-07-27 09:00:00	NVDA	Stock	1.4378	1.4435	1.3953	1.4013	79416160.0
2016-07-27 10:00:00	NVDA	Stock	1.4013	1.4038	1.393	1.3952	66702440.0
2016-07-27 11:00:00	NVDA	Stock	1.3953	1.401	1.3938	1.3988	55087360.0
2016-07-27 12:00:00	NVDA	Stock	1.3986	1.4002	1.3978	1.399	35281080.0
2016-07-27 13:00:00	NVDA	Stock	1.3993	1.4053	1.3973	1.4053	53164440.0
2016-07-27 14:00:00	NVDA	Stock	1.4053	1.4053	1.3971	1.4013	44507200.0
2016-07-27 15:00:00	NVDA	Stock	1.4014	1.4048	1.3995	1.4015	82337120.0
2016-07-27 16:00:00	NVDA	Stock	1.4015	1.404	1.4012	1.4035	3405480.0
2016-07-27 17:00:00	NVDA	Stock	1.4035	1.405	1.4015	1.4015	624720.0
2016-07-27 18:00:00	NVDA	Stock	1.4038	1.4048	1.4038	1.4043	57840.0
2016-07-27 19:00:00	NVDA	Stock	1.405	1.412	1.405	1.4098	54800.0
2016-07-27 07:00:00	AMZN	Stock	36.95	36.963	36.9335	36.9505	18400.0
2016-07-27 08:00:00	AMZN	Stock	36.9795	37.0375	36.96	36.9815	76180.0
2016-07-27 09:00:00	AMZN	Stock	36.986	37.047	36.7295	36.9755	7509640.0
2016-07-27 10:00:00	AMZN	Stock	36.9755	36.996	36.7935	36.8738	6425380.0
2016-07-27 11:00:00	AMZN	Stock	36.889	36.9857	36.854	36.8738	3765160.0

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

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