PREVIEW / stock_1hour / 2016-08-30

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-30.parquet
  size:    1.0 MB
  rows:    48,072
  symbols: 3,260

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-08-30 04:00:00	AAPL	Stock	26.6475	26.6475	26.61	26.61	4400.0
2016-08-30 05:00:00	AAPL	Stock	26.5825	26.5875	26.2675	26.27	86964.0
2016-08-30 06:00:00	AAPL	Stock	26.2675	26.3	25.875	26.225	806048.0
2016-08-30 07:00:00	AAPL	Stock	26.23	26.3975	26.1325	26.33	655104.0
2016-08-30 08:00:00	AAPL	Stock	26.3375	26.47	26.025	26.445	1472928.0
2016-08-30 09:00:00	AAPL	Stock	26.4475	26.705	26.375	26.5485	24170080.0
2016-08-30 10:00:00	AAPL	Stock	26.5525	26.5675	26.435	26.5	16432352.0
2016-08-30 11:00:00	AAPL	Stock	26.4975	26.5588	26.485	26.5075	9517536.0
2016-08-30 12:00:00	AAPL	Stock	26.5075	26.5575	26.4875	26.4975	6575924.0
2016-08-30 13:00:00	AAPL	Stock	26.4975	26.5075	26.4275	26.45	6915024.0
2016-08-30 14:00:00	AAPL	Stock	26.4475	26.475	26.3925	26.4588	8353052.0
2016-08-30 15:00:00	AAPL	Stock	26.46	26.5	26.4325	26.4975	12346376.0
2016-08-30 16:00:00	AAPL	Stock	26.5	26.5	26.472	26.5	4840120.0
2016-08-30 17:00:00	AAPL	Stock	26.4975	26.5175	26.4975	26.515	146912.0
2016-08-30 18:00:00	AAPL	Stock	26.515	26.515	26.5	26.5	17216.0
2016-08-30 19:00:00	AAPL	Stock	26.5	26.5075	26.48	26.4975	29856.0
2016-08-30 06:00:00	MSFT	Stock	58.1	58.1	58.1	58.1	5023.0
2016-08-30 07:00:00	MSFT	Stock	58.08	58.08	58.05	58.05	366.0
2016-08-30 08:00:00	MSFT	Stock	58.1	58.1	58.05	58.1	7654.0
2016-08-30 09:00:00	MSFT	Stock	58.1	58.19	57.95	58.1	2024020.0
2016-08-30 10:00:00	MSFT	Stock	58.1	58.19	57.73	57.82	2329075.0
2016-08-30 11:00:00	MSFT	Stock	57.81	57.88	57.7	57.765	1841488.0
2016-08-30 12:00:00	MSFT	Stock	57.77	57.9	57.77	57.82	1145482.0
2016-08-30 13:00:00	MSFT	Stock	57.813	57.89	57.75	57.815	1055022.0
2016-08-30 14:00:00	MSFT	Stock	57.805	57.81	57.61	57.72	1854841.0
2016-08-30 15:00:00	MSFT	Stock	57.73	57.89	57.66	57.89	3272854.0
2016-08-30 16:00:00	MSFT	Stock	57.89	57.89	57.88	57.89	2338972.0
2016-08-30 17:00:00	MSFT	Stock	57.82	57.82	57.82	57.82	100.0
2016-08-30 18:00:00	MSFT	Stock	57.89	57.89	57.89	57.89	100.0
2016-08-30 06:00:00	NVDA	Stock	1.55	1.55	1.55	1.55	18000.0
2016-08-30 07:00:00	NVDA	Stock	1.5505	1.5505	1.5505	1.5505	4000.0
2016-08-30 09:00:00	NVDA	Stock	1.549	1.5561	1.5425	1.5436	39384560.0
2016-08-30 10:00:00	NVDA	Stock	1.5438	1.547	1.5369	1.5412	38144600.0
2016-08-30 11:00:00	NVDA	Stock	1.541	1.5461	1.5392	1.5403	42993640.0
2016-08-30 12:00:00	NVDA	Stock	1.5403	1.5435	1.5392	1.542	25207440.0
2016-08-30 13:00:00	NVDA	Stock	1.542	1.5443	1.539	1.5408	28002840.0
2016-08-30 14:00:00	NVDA	Stock	1.5408	1.5408	1.5368	1.5388	29451920.0
2016-08-30 15:00:00	NVDA	Stock	1.5385	1.5418	1.5365	1.541	38956840.0
2016-08-30 16:00:00	NVDA	Stock	1.5408	1.5408	1.539	1.539	8251320.0
2016-08-30 18:00:00	NVDA	Stock	1.541	1.5412	1.541	1.5412	24800.0
2016-08-30 19:00:00	NVDA	Stock	1.5415	1.5415	1.5412	1.5412	91960.0
2016-08-30 04:00:00	AMZN	Stock	38.68	38.68	38.6275	38.6275	6000.0
2016-08-30 05:00:00	AMZN	Stock	38.5755	38.5755	38.5755	38.5755	2000.0
2016-08-30 06:00:00	AMZN	Stock	38.537	38.537	38.45	38.45	10880.0
2016-08-30 07:00:00	AMZN	Stock	38.5	38.5295	38.5	38.5225	12560.0
2016-08-30 08:00:00	AMZN	Stock	38.525	38.545	38.508	38.5445	28760.0
2016-08-30 09:00:00	AMZN	Stock	38.535	38.5918	38.4555	38.528	3463400.0
2016-08-30 10:00:00	AMZN	Stock	38.5285	38.5305	38.297	38.346	6692860.0
2016-08-30 11:00:00	AMZN	Stock	38.351	38.385	38.3155	38.3235	3205840.0
2016-08-30 12:00:00	AMZN	Stock	38.3275	38.4455	38.321	38.414	3268980.0

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

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