PREVIEW / stock_1hour / 2017-12-28

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-12-28.parquet
  size:    1.1 MB
  rows:    48,954
  symbols: 2,920

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-12-28 04:00:00	AAPL	Stock	42.69	42.7125	42.63	42.6375	5068.0
2017-12-28 05:00:00	AAPL	Stock	42.6575	42.6975	42.625	42.6325	13048.0
2017-12-28 06:00:00	AAPL	Stock	42.675	42.725	42.675	42.725	6380.0
2017-12-28 07:00:00	AAPL	Stock	42.7225	42.7925	42.6825	42.75	122780.0
2017-12-28 08:00:00	AAPL	Stock	42.745	42.7875	42.7	42.7375	205440.0
2017-12-28 09:00:00	AAPL	Stock	42.7375	42.9325	42.7	42.8875	12230632.0
2017-12-28 10:00:00	AAPL	Stock	42.8875	42.9625	42.8325	42.87	9868208.0
2017-12-28 11:00:00	AAPL	Stock	42.87	42.885	42.8075	42.8275	5298096.0
2017-12-28 12:00:00	AAPL	Stock	42.8275	42.8475	42.7525	42.7575	4560472.0
2017-12-28 13:00:00	AAPL	Stock	42.76	42.7625	42.675	42.7088	4879184.0
2017-12-28 14:00:00	AAPL	Stock	42.7098	42.7175	42.62	42.6338	4997340.0
2017-12-28 15:00:00	AAPL	Stock	42.6338	42.7675	42.625	42.7675	11615228.0
2017-12-28 16:00:00	AAPL	Stock	42.765	42.77	42.6875	42.6875	5667500.0
2017-12-28 17:00:00	AAPL	Stock	42.7	42.71	42.6775	42.6875	57692.0
2017-12-28 18:00:00	AAPL	Stock	42.6875	42.725	42.6875	42.715	28080.0
2017-12-28 19:00:00	AAPL	Stock	42.715	42.7225	42.705	42.71	30068.0
2017-12-28 04:00:00	MSFT	Stock	86.02	86.02	86.02	86.02	300.0
2017-12-28 07:00:00	MSFT	Stock	85.95	85.95	85.95	85.95	935.0
2017-12-28 08:00:00	MSFT	Stock	85.95	85.98	85.9	85.98	4336.0
2017-12-28 09:00:00	MSFT	Stock	85.9	86.0	85.61	85.72	1371964.0
2017-12-28 10:00:00	MSFT	Stock	85.72	85.76	85.55	85.725	1312660.0
2017-12-28 11:00:00	MSFT	Stock	85.73	85.76	85.61	85.655	883326.0
2017-12-28 12:00:00	MSFT	Stock	85.655	85.67	85.58	85.62	561452.0
2017-12-28 13:00:00	MSFT	Stock	85.619	85.68	85.566	85.68	664952.0
2017-12-28 14:00:00	MSFT	Stock	85.68	85.69	85.57	85.645	754557.0
2017-12-28 15:00:00	MSFT	Stock	85.64	85.76	85.64	85.7	2164426.0
2017-12-28 16:00:00	MSFT	Stock	85.72	85.72	85.6	85.7	1330191.0
2017-12-28 18:00:00	MSFT	Stock	85.7	85.71	85.7	85.71	1200.0
2017-12-28 04:00:00	NVDA	Stock	4.945	4.945	4.945	4.945	4000.0
2017-12-28 05:00:00	NVDA	Stock	4.945	4.945	4.945	4.945	28160.0
2017-12-28 06:00:00	NVDA	Stock	4.94	4.9425	4.94	4.9425	54000.0
2017-12-28 07:00:00	NVDA	Stock	4.938	4.9425	4.93	4.9362	367400.0
2017-12-28 08:00:00	NVDA	Stock	4.9418	4.9425	4.9338	4.9338	508480.0
2017-12-28 09:00:00	NVDA	Stock	4.935	4.9725	4.9318	4.9658	43640160.0
2017-12-28 10:00:00	NVDA	Stock	4.9648	4.9713	4.9418	4.9686	46770640.0
2017-12-28 11:00:00	NVDA	Stock	4.9679	4.9845	4.9642	4.9718	34843040.0
2017-12-28 12:00:00	NVDA	Stock	4.9718	4.9775	4.966	4.9693	13596480.0
2017-12-28 13:00:00	NVDA	Stock	4.9685	4.9702	4.945	4.951	21445800.0
2017-12-28 14:00:00	NVDA	Stock	4.9508	4.9553	4.947	4.9474	18075480.0
2017-12-28 15:00:00	NVDA	Stock	4.948	4.9545	4.9288	4.9335	38445360.0
2017-12-28 16:00:00	NVDA	Stock	4.935	4.9438	4.9338	4.9362	8995480.0
2017-12-28 17:00:00	NVDA	Stock	4.935	4.9385	4.935	4.9362	56640.0
2017-12-28 18:00:00	NVDA	Stock	4.9375	4.9385	4.9375	4.9385	132000.0
2017-12-28 19:00:00	NVDA	Stock	4.934	4.9385	4.934	4.935	121360.0
2017-12-28 06:00:00	AMZN	Stock	59.3895	59.3895	59.3	59.3	4600.0
2017-12-28 07:00:00	AMZN	Stock	59.345	59.345	59.345	59.345	2000.0
2017-12-28 08:00:00	AMZN	Stock	59.35	59.445	59.3495	59.4	229820.0
2017-12-28 09:00:00	AMZN	Stock	59.375	59.505	59.279	59.429	8449460.0
2017-12-28 10:00:00	AMZN	Stock	59.4375	59.455	59.219	59.3025	6746380.0
2017-12-28 11:00:00	AMZN	Stock	59.301	59.3875	59.25	59.2635	3281920.0

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

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