PREVIEW / stock_1hour / 2015-06-15

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-15.parquet
  size:    1.1 MB
  rows:    49,418
  symbols: 3,513

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-06-15 04:00:00	AAPL	Stock	31.75	31.75	31.615	31.625	128488.0
2015-06-15 05:00:00	AAPL	Stock	31.625	31.6425	31.6175	31.6175	33812.0
2015-06-15 06:00:00	AAPL	Stock	31.6175	31.655	31.6125	31.6425	53836.0
2015-06-15 07:00:00	AAPL	Stock	31.64	31.64	31.555	31.5675	104556.0
2015-06-15 08:00:00	AAPL	Stock	31.575	31.6475	31.5375	31.5825	968552.0
2015-06-15 09:00:00	AAPL	Stock	31.58	31.635	31.4275	31.5625	28911732.0
2015-06-15 10:00:00	AAPL	Stock	31.565	31.6725	31.5225	31.5725	24129416.0
2015-06-15 11:00:00	AAPL	Stock	31.57	31.74	31.57	31.7075	18214216.0
2015-06-15 12:00:00	AAPL	Stock	31.705	31.765	31.5975	31.67	15390600.0
2015-06-15 13:00:00	AAPL	Stock	31.67	31.7375	31.615	31.6825	10112744.0
2015-06-15 14:00:00	AAPL	Stock	31.68	31.81	31.68	31.7325	15163400.0
2015-06-15 15:00:00	AAPL	Stock	31.73	31.78	31.6625	31.7325	19794680.0
2015-06-15 16:00:00	AAPL	Stock	31.73	31.745	31.7028	31.735	8179156.0
2015-06-15 17:00:00	AAPL	Stock	31.7375	31.7425	31.71	31.7292	291516.0
2015-06-15 18:00:00	AAPL	Stock	31.7175	31.7275	31.71	31.7175	52020.0
2015-06-15 19:00:00	AAPL	Stock	31.7125	31.7275	31.705	31.7175	26372.0
2015-06-15 04:00:00	MSFT	Stock	45.96	45.96	45.76	45.76	2200.0
2015-06-15 07:00:00	MSFT	Stock	45.78	45.78	45.76	45.77	1380.0
2015-06-15 08:00:00	MSFT	Stock	45.76	45.76	45.72	45.72	2062.0
2015-06-15 09:00:00	MSFT	Stock	45.78	45.88	45.02	45.08	5936414.0
2015-06-15 10:00:00	MSFT	Stock	45.08	45.4	45.08	45.236	4618870.0
2015-06-15 11:00:00	MSFT	Stock	45.24	45.44	45.22	45.32	2978107.0
2015-06-15 12:00:00	MSFT	Stock	45.32	45.46	45.2	45.46	2101974.0
2015-06-15 13:00:00	MSFT	Stock	45.46	45.65	45.38	45.47	2562373.0
2015-06-15 14:00:00	MSFT	Stock	45.47	45.57	45.37	45.41	2054006.0
2015-06-15 15:00:00	MSFT	Stock	45.405	45.55	45.35	45.48	4720883.0
2015-06-15 16:00:00	MSFT	Stock	45.475	45.5	45.45	45.475	3533593.0
2015-06-15 17:00:00	MSFT	Stock	45.45	45.45	45.45	45.45	150.0
2015-06-15 18:00:00	MSFT	Stock	45.45	45.45	45.45	45.45	500.0
2015-06-15 08:00:00	NVDA	Stock	0.525	0.5272	0.525	0.5272	34920.0
2015-06-15 09:00:00	NVDA	Stock	0.525	0.5262	0.5218	0.5218	46088800.0
2015-06-15 10:00:00	NVDA	Stock	0.5218	0.5235	0.521	0.5228	39968920.0
2015-06-15 11:00:00	NVDA	Stock	0.5228	0.5287	0.5228	0.527	33895400.0
2015-06-15 12:00:00	NVDA	Stock	0.527	0.529	0.5268	0.529	16704360.0
2015-06-15 13:00:00	NVDA	Stock	0.5291	0.5291	0.5245	0.5253	25649880.0
2015-06-15 14:00:00	NVDA	Stock	0.5253	0.5278	0.5247	0.5247	24334000.0
2015-06-15 15:00:00	NVDA	Stock	0.525	0.5268	0.524	0.5266	42131040.0
2015-06-15 16:00:00	NVDA	Stock	0.5268	0.5268	0.5268	0.5268	40614040.0
2015-06-15 18:00:00	NVDA	Stock	0.5287	0.5287	0.5287	0.5287	100000.0
2015-06-15 19:00:00	NVDA	Stock	0.5285	0.5285	0.5285	0.5285	20000.0
2015-06-15 04:00:00	AMZN	Stock	21.4575	21.4575	21.4575	21.4575	2100.0
2015-06-15 05:00:00	AMZN	Stock	21.4	21.4	21.4	21.4	7000.0
2015-06-15 06:00:00	AMZN	Stock	21.4	21.4	21.4	21.4	12920.0
2015-06-15 07:00:00	AMZN	Stock	21.4345	21.435	21.4345	21.435	10000.0
2015-06-15 08:00:00	AMZN	Stock	21.446	21.475	21.415	21.427	141100.0
2015-06-15 09:00:00	AMZN	Stock	21.4226	21.4315	21.132	21.1515	8194760.0
2015-06-15 10:00:00	AMZN	Stock	21.152	21.2435	21.1425	21.184	7267220.0
2015-06-15 11:00:00	AMZN	Stock	21.183	21.287	21.183	21.2175	3731220.0
2015-06-15 12:00:00	AMZN	Stock	21.216	21.254	21.1892	21.202	2403500.0
2015-06-15 13:00:00	AMZN	Stock	21.2055	21.278	21.1925	21.25	3051760.0

> showing 50 of 49,418 rows — these rows as CSV

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