PREVIEW / stock_1hour / 2015-11-13

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-11-13.parquet
  size:    1.0 MB
  rows:    48,564
  symbols: 3,383

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-11-13 04:00:00	AAPL	Stock	28.93	28.9375	28.93	28.9375	1200.0
2015-11-13 05:00:00	AAPL	Stock	28.9	28.95	28.895	28.95	2204.0
2015-11-13 06:00:00	AAPL	Stock	28.895	28.9	28.74	28.775	45300.0
2015-11-13 07:00:00	AAPL	Stock	28.775	28.845	28.75	28.8175	54316.0
2015-11-13 08:00:00	AAPL	Stock	28.845	28.885	28.775	28.8375	272204.0
2015-11-13 09:00:00	AAPL	Stock	28.8475	28.905	28.5375	28.555	23374064.0
2015-11-13 10:00:00	AAPL	Stock	28.555	28.625	28.3288	28.393	32995460.0
2015-11-13 11:00:00	AAPL	Stock	28.395	28.4225	28.17	28.4225	28897312.0
2015-11-13 12:00:00	AAPL	Stock	28.4225	28.535	28.3025	28.3325	15861048.0
2015-11-13 13:00:00	AAPL	Stock	28.335	28.3675	28.2588	28.3325	11690612.0
2015-11-13 14:00:00	AAPL	Stock	28.33	28.3525	28.1975	28.2325	15550748.0
2015-11-13 15:00:00	AAPL	Stock	28.2325	28.2675	28.0675	28.0825	32083516.0
2015-11-13 16:00:00	AAPL	Stock	28.085	28.15	28.0025	28.0375	9964544.0
2015-11-13 17:00:00	AAPL	Stock	28.0375	28.0425	27.8775	27.9125	297404.0
2015-11-13 18:00:00	AAPL	Stock	27.9125	27.9125	27.6225	27.7625	406020.0
2015-11-13 19:00:00	AAPL	Stock	27.7575	27.805	27.675	27.725	255844.0
2015-11-13 04:00:00	MSFT	Stock	53.22	53.22	53.21	53.22	2460.0
2015-11-13 05:00:00	MSFT	Stock	53.13	53.13	53.13	53.13	200.0
2015-11-13 06:00:00	MSFT	Stock	53.0	53.0	52.83	52.84	6617.0
2015-11-13 07:00:00	MSFT	Stock	52.96	52.99	52.9	52.98	4975.0
2015-11-13 08:00:00	MSFT	Stock	53.0	53.07	52.85	52.88	42223.0
2015-11-13 09:00:00	MSFT	Stock	52.9	53.29	52.595	53.04	5634703.0
2015-11-13 10:00:00	MSFT	Stock	53.03	53.03	52.53	52.726	5688875.0
2015-11-13 11:00:00	MSFT	Stock	52.73	52.85	52.58	52.819	3132733.0
2015-11-13 12:00:00	MSFT	Stock	52.81	53.157	52.8	53.07	2930056.0
2015-11-13 13:00:00	MSFT	Stock	53.07	53.16	52.96	53.091	3056782.0
2015-11-13 14:00:00	MSFT	Stock	53.09	53.165	52.74	52.964	4004888.0
2015-11-13 15:00:00	MSFT	Stock	52.96	53.15	52.83	52.84	7263511.0
2015-11-13 16:00:00	MSFT	Stock	52.84	52.87	52.754	52.83	3006184.0
2015-11-13 17:00:00	MSFT	Stock	52.84	52.84	52.62	52.62	107900.0
2015-11-13 18:00:00	MSFT	Stock	52.55	52.6	52.51	52.51	12620.0
2015-11-13 19:00:00	MSFT	Stock	52.51	52.55	52.4	52.4	15291.0
2015-11-13 08:00:00	NVDA	Stock	0.7598	0.76	0.7598	0.76	40000.0
2015-11-13 09:00:00	NVDA	Stock	0.76	0.764	0.755	0.7563	28918480.0
2015-11-13 10:00:00	NVDA	Stock	0.756	0.7561	0.7445	0.7448	66105440.0
2015-11-13 11:00:00	NVDA	Stock	0.745	0.7515	0.7412	0.7513	29250760.0
2015-11-13 12:00:00	NVDA	Stock	0.7515	0.7538	0.7498	0.751	20752440.0
2015-11-13 13:00:00	NVDA	Stock	0.751	0.7525	0.7478	0.751	28087480.0
2015-11-13 14:00:00	NVDA	Stock	0.751	0.751	0.745	0.746	28927280.0
2015-11-13 15:00:00	NVDA	Stock	0.7461	0.7485	0.7448	0.7452	66753400.0
2015-11-13 16:00:00	NVDA	Stock	0.7452	0.7463	0.745	0.7463	898440.0
2015-11-13 18:00:00	NVDA	Stock	0.74	0.74	0.7335	0.7335	58000.0
2015-11-13 19:00:00	NVDA	Stock	0.7375	0.7375	0.7375	0.7375	5360.0
2015-11-13 04:00:00	AMZN	Stock	33.255	33.255	33.25	33.25	10000.0
2015-11-13 05:00:00	AMZN	Stock	33.1965	33.1965	33.15	33.15	17460.0
2015-11-13 07:00:00	AMZN	Stock	33.1	33.15	33.1	33.118	65040.0
2015-11-13 08:00:00	AMZN	Stock	33.1105	33.145	33.05	33.125	399160.0
2015-11-13 09:00:00	AMZN	Stock	33.1205	33.35	33.0485	33.223	13212540.0
2015-11-13 10:00:00	AMZN	Stock	33.2085	33.25	32.456	32.72	27886540.0
2015-11-13 11:00:00	AMZN	Stock	32.72	32.7325	32.5005	32.6668	13047200.0

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

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