PREVIEW / stock_1hour / 2016-04-06

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-06.parquet
  size:    1.0 MB
  rows:    48,160
  symbols: 3,328

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-04-06 04:00:00	AAPL	Stock	27.525	27.525	27.525	27.525	400.0
2016-04-06 05:00:00	AAPL	Stock	27.55	27.5975	27.55	27.5975	1160.0
2016-04-06 07:00:00	AAPL	Stock	27.55	27.5825	27.5	27.5825	58572.0
2016-04-06 08:00:00	AAPL	Stock	27.53	27.6475	27.5	27.6075	361884.0
2016-04-06 09:00:00	AAPL	Stock	27.6175	27.6575	27.4175	27.4698	15482608.0
2016-04-06 10:00:00	AAPL	Stock	27.4675	27.51	27.3	27.475	19935452.0
2016-04-06 11:00:00	AAPL	Stock	27.475	27.5625	27.4525	27.55	12859288.0
2016-04-06 12:00:00	AAPL	Stock	27.5475	27.615	27.535	27.541	7499556.0
2016-04-06 13:00:00	AAPL	Stock	27.5425	27.6038	27.5025	27.5202	6835208.0
2016-04-06 14:00:00	AAPL	Stock	27.5225	27.5575	27.45	27.52	8956700.0
2016-04-06 15:00:00	AAPL	Stock	27.52	27.745	27.505	27.7378	18081516.0
2016-04-06 16:00:00	AAPL	Stock	27.74	27.77	27.4892	27.75	5841576.0
2016-04-06 17:00:00	AAPL	Stock	27.75	27.75	27.6975	27.705	352940.0
2016-04-06 18:00:00	AAPL	Stock	27.73	27.73	27.7	27.725	18600.0
2016-04-06 19:00:00	AAPL	Stock	27.7225	27.73	27.715	27.72	46120.0
2016-04-06 08:00:00	MSFT	Stock	54.7	54.75	54.66	54.66	1050.0
2016-04-06 09:00:00	MSFT	Stock	54.72	54.72	54.24	54.46	2924254.0
2016-04-06 10:00:00	MSFT	Stock	54.46	54.62	54.21	54.62	3153095.0
2016-04-06 11:00:00	MSFT	Stock	54.62	54.87	54.56	54.76	2178401.0
2016-04-06 12:00:00	MSFT	Stock	54.76	54.805	54.67	54.74	1158263.0
2016-04-06 13:00:00	MSFT	Stock	54.74	54.97	54.72	54.923	1535059.0
2016-04-06 14:00:00	MSFT	Stock	54.92	54.98	54.8	54.95	1921533.0
2016-04-06 15:00:00	MSFT	Stock	54.94	55.2	54.91	55.13	4856582.0
2016-04-06 16:00:00	MSFT	Stock	55.12	55.12	55.1	55.1	1987198.0
2016-04-06 17:00:00	MSFT	Stock	55.13	55.15	55.12	55.15	57845.0
2016-04-06 18:00:00	MSFT	Stock	55.12	55.12	55.1	55.1	1720.0
2016-04-06 19:00:00	MSFT	Stock	55.08	55.1	55.08	55.1	1400.0
2016-04-06 04:00:00	NVDA	Stock	0.8895	0.89	0.8895	0.89	148040.0
2016-04-06 06:00:00	NVDA	Stock	0.89	0.89	0.89	0.89	4320.0
2016-04-06 07:00:00	NVDA	Stock	0.885	0.8858	0.8842	0.8842	40320.0
2016-04-06 08:00:00	NVDA	Stock	0.8842	0.8842	0.8795	0.8812	526840.0
2016-04-06 09:00:00	NVDA	Stock	0.8805	0.8863	0.8658	0.8788	82113520.0
2016-04-06 10:00:00	NVDA	Stock	0.8788	0.8868	0.8764	0.8868	77108760.0
2016-04-06 11:00:00	NVDA	Stock	0.8868	0.8948	0.8865	0.889	85492600.0
2016-04-06 12:00:00	NVDA	Stock	0.8889	0.8912	0.886	0.89	40489480.0
2016-04-06 13:00:00	NVDA	Stock	0.89	0.8936	0.8891	0.8894	23352720.0
2016-04-06 14:00:00	NVDA	Stock	0.8895	0.8928	0.888	0.8925	34585320.0
2016-04-06 15:00:00	NVDA	Stock	0.8925	0.8955	0.8922	0.895	80982080.0
2016-04-06 16:00:00	NVDA	Stock	0.895	0.8975	0.8871	0.8975	12869800.0
2016-04-06 17:00:00	NVDA	Stock	0.895	0.8975	0.895	0.8975	8000.0
2016-04-06 18:00:00	NVDA	Stock	0.8975	0.8975	0.8975	0.8975	80000.0
2016-04-06 19:00:00	NVDA	Stock	0.8998	0.8998	0.8998	0.8998	24720.0
2016-04-06 05:00:00	AMZN	Stock	29.405	29.405	29.405	29.405	4000.0
2016-04-06 06:00:00	AMZN	Stock	29.404	29.4075	29.404	29.4075	18940.0
2016-04-06 07:00:00	AMZN	Stock	29.4	29.4125	29.4	29.41	8000.0
2016-04-06 08:00:00	AMZN	Stock	29.4075	29.505	29.405	29.4205	93140.0
2016-04-06 09:00:00	AMZN	Stock	29.45	29.7815	29.375	29.711	9671120.0
2016-04-06 10:00:00	AMZN	Stock	29.7185	29.759	29.5565	29.717	6373760.0
2016-04-06 11:00:00	AMZN	Stock	29.7195	29.8202	29.7105	29.792	5371500.0
2016-04-06 12:00:00	AMZN	Stock	29.7995	29.9185	29.7135	29.8275	4738760.0

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

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