PREVIEW / stock_1hour / 2015-10-26

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-26.parquet
  size:    1.0 MB
  rows:    48,192
  symbols: 3,445

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
2015-10-26 04:00:00	AAPL	Stock	29.755	29.755	29.6075	29.7125	71936.0
2015-10-26 05:00:00	AAPL	Stock	29.715	29.715	29.5625	29.575	208920.0
2015-10-26 06:00:00	AAPL	Stock	29.575	29.66	29.53	29.575	202188.0
2015-10-26 07:00:00	AAPL	Stock	29.575	29.575	29.3725	29.4975	625168.0
2015-10-26 08:00:00	AAPL	Stock	29.4975	29.625	29.38	29.5	2626928.0
2015-10-26 09:00:00	AAPL	Stock	29.5025	29.5325	28.9	28.9825	56668084.0
2015-10-26 10:00:00	AAPL	Stock	28.985	29.0725	28.83	29.015	48433324.0
2015-10-26 11:00:00	AAPL	Stock	29.015	29.0275	28.775	28.795	31449468.0
2015-10-26 12:00:00	AAPL	Stock	28.7975	28.9775	28.7775	28.865	20522812.0
2015-10-26 13:00:00	AAPL	Stock	28.865	28.9275	28.73	28.78	22591456.0
2015-10-26 14:00:00	AAPL	Stock	28.7825	28.8362	28.7525	28.8328	15818288.0
2015-10-26 15:00:00	AAPL	Stock	28.8338	28.9725	28.76	28.8175	39807796.0
2015-10-26 16:00:00	AAPL	Stock	28.8162	28.9442	28.775	28.8125	9205476.0
2015-10-26 17:00:00	AAPL	Stock	28.8125	28.82	28.79	28.81	231872.0
2015-10-26 18:00:00	AAPL	Stock	28.815	28.82	28.7875	28.795	183196.0
2015-10-26 19:00:00	AAPL	Stock	28.795	28.8125	28.785	28.8	246128.0
2015-10-26 04:00:00	MSFT	Stock	52.86	52.86	52.53	52.53	1596.0
2015-10-26 05:00:00	MSFT	Stock	52.52	52.6	52.5	52.6	6549.0
2015-10-26 06:00:00	MSFT	Stock	52.6	52.75	52.6	52.6	4852.0
2015-10-26 07:00:00	MSFT	Stock	52.61	52.65	52.5	52.5	7644.0
2015-10-26 08:00:00	MSFT	Stock	52.57	52.84	52.5	52.76	83430.0
2015-10-26 09:00:00	MSFT	Stock	52.8	53.33	52.5	53.131	7684471.0
2015-10-26 10:00:00	MSFT	Stock	53.14	53.61	52.95	53.55	9497881.0
2015-10-26 11:00:00	MSFT	Stock	53.56	53.79	53.4	53.505	7861585.0
2015-10-26 12:00:00	MSFT	Stock	53.51	53.98	53.28	53.9	6466431.0
2015-10-26 13:00:00	MSFT	Stock	53.905	53.94	53.57	53.59	5942503.0
2015-10-26 14:00:00	MSFT	Stock	53.59	53.8	53.51	53.785	5406366.0
2015-10-26 15:00:00	MSFT	Stock	53.78	54.32	53.715	54.27	15492299.0
2015-10-26 16:00:00	MSFT	Stock	54.25	54.27	53.7	54.26	3742932.0
2015-10-26 17:00:00	MSFT	Stock	54.25	54.26	54.21	54.26	38917.0
2015-10-26 18:00:00	MSFT	Stock	54.26	54.3	54.23	54.25	11471.0
2015-10-26 19:00:00	MSFT	Stock	54.24	54.3	54.24	54.27	7152.0
2015-10-26 09:00:00	NVDA	Stock	0.7148	0.717	0.7058	0.7095	41167560.0
2015-10-26 10:00:00	NVDA	Stock	0.7095	0.7108	0.7072	0.708	27392880.0
2015-10-26 11:00:00	NVDA	Stock	0.7081	0.7103	0.705	0.7095	31395160.0
2015-10-26 12:00:00	NVDA	Stock	0.7098	0.7155	0.7094	0.7133	25754760.0
2015-10-26 13:00:00	NVDA	Stock	0.7133	0.7145	0.7103	0.7105	29436280.0
2015-10-26 14:00:00	NVDA	Stock	0.7108	0.7128	0.7078	0.7125	19721840.0
2015-10-26 15:00:00	NVDA	Stock	0.7123	0.7135	0.7114	0.7118	35928040.0
2015-10-26 16:00:00	NVDA	Stock	0.7115	0.7115	0.7103	0.7103	20547880.0
2015-10-26 04:00:00	AMZN	Stock	29.755	29.8	29.7025	29.735	13280.0
2015-10-26 05:00:00	AMZN	Stock	29.7975	29.7995	29.7975	29.7995	10820.0
2015-10-26 06:00:00	AMZN	Stock	29.751	29.751	29.7055	29.7055	6800.0
2015-10-26 07:00:00	AMZN	Stock	29.775	29.775	29.775	29.775	3000.0
2015-10-26 08:00:00	AMZN	Stock	29.8475	30.075	29.75	30.05	377060.0
2015-10-26 09:00:00	AMZN	Stock	30.05	30.115	29.855	29.94	12083940.0
2015-10-26 10:00:00	AMZN	Stock	29.9415	30.231	29.8145	30.157	18104500.0
2015-10-26 11:00:00	AMZN	Stock	30.16	30.199	30.047	30.1635	8797120.0
2015-10-26 12:00:00	AMZN	Stock	30.166	30.2845	30.12	30.2435	7237280.0
2015-10-26 13:00:00	AMZN	Stock	30.2355	30.3085	30.1865	30.207	8017820.0

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

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