PREVIEW / stock_1hour / 2015-07-23

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-23.parquet
  size:    1.0 MB
  rows:    48,342
  symbols: 3,484

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-07-23 04:00:00	AAPL	Stock	31.45	31.5375	31.225	31.5375	134460.0
2015-07-23 05:00:00	AAPL	Stock	31.5275	31.5375	31.51	31.5375	28328.0
2015-07-23 06:00:00	AAPL	Stock	31.53	31.53	31.465	31.495	73236.0
2015-07-23 07:00:00	AAPL	Stock	31.5125	31.525	31.415	31.4725	248640.0
2015-07-23 08:00:00	AAPL	Stock	31.4625	31.525	31.42	31.42	603200.0
2015-07-23 09:00:00	AAPL	Stock	31.42	31.6875	31.4	31.4925	36817280.0
2015-07-23 10:00:00	AAPL	Stock	31.4925	31.7725	31.48	31.719	39986112.0
2015-07-23 11:00:00	AAPL	Stock	31.72	31.7375	31.585	31.5975	20860312.0
2015-07-23 12:00:00	AAPL	Stock	31.6	31.61	31.415	31.4925	19051132.0
2015-07-23 13:00:00	AAPL	Stock	31.492	31.5	31.3275	31.4702	15977236.0
2015-07-23 14:00:00	AAPL	Stock	31.4725	31.5	31.39	31.4075	12098464.0
2015-07-23 15:00:00	AAPL	Stock	31.405	31.4075	31.265	31.29	31414160.0
2015-07-23 16:00:00	AAPL	Stock	31.29	31.539	31.275	31.365	10588736.0
2015-07-23 17:00:00	AAPL	Stock	31.36	31.4125	31.345	31.4	303444.0
2015-07-23 18:00:00	AAPL	Stock	31.3882	31.405	31.375	31.395	159164.0
2015-07-23 19:00:00	AAPL	Stock	31.4	31.4075	31.3625	31.3625	226024.0
2015-07-23 07:00:00	MSFT	Stock	45.64	45.7	45.64	45.64	1113.0
2015-07-23 08:00:00	MSFT	Stock	45.64	45.7	45.57	45.6	19866.0
2015-07-23 09:00:00	MSFT	Stock	45.58	45.68	45.1	45.665	3954381.0
2015-07-23 10:00:00	MSFT	Stock	45.665	46.12	45.58	46.065	5227361.0
2015-07-23 11:00:00	MSFT	Stock	46.07	46.23	45.99	46.021	4329096.0
2015-07-23 12:00:00	MSFT	Stock	46.02	46.06	45.823	45.94	3334675.0
2015-07-23 13:00:00	MSFT	Stock	45.94	46.19	45.9	46.17	2641341.0
2015-07-23 14:00:00	MSFT	Stock	46.16	46.165	45.85	45.885	2633891.0
2015-07-23 15:00:00	MSFT	Stock	45.87	46.16	45.76	46.12	7271211.0
2015-07-23 16:00:00	MSFT	Stock	46.11	46.23	46.018	46.11	2401710.0
2015-07-23 17:00:00	MSFT	Stock	46.11	46.14	46.05	46.11	10440.0
2015-07-23 18:00:00	MSFT	Stock	46.11	46.11	46.05	46.11	141871.0
2015-07-23 19:00:00	MSFT	Stock	46.18	46.2	46.12	46.2	4890.0
2015-07-23 09:00:00	NVDA	Stock	0.486	0.4948	0.4852	0.4948	21691360.0
2015-07-23 10:00:00	NVDA	Stock	0.4945	0.498	0.4928	0.4978	28836840.0
2015-07-23 11:00:00	NVDA	Stock	0.4978	0.4985	0.4885	0.489	29411840.0
2015-07-23 12:00:00	NVDA	Stock	0.489	0.491	0.4865	0.4908	23551320.0
2015-07-23 13:00:00	NVDA	Stock	0.4907	0.4925	0.4886	0.4925	13200360.0
2015-07-23 14:00:00	NVDA	Stock	0.4925	0.4928	0.4898	0.49	14648480.0
2015-07-23 15:00:00	NVDA	Stock	0.4898	0.4918	0.489	0.4912	25678240.0
2015-07-23 16:00:00	NVDA	Stock	0.4912	0.4918	0.4912	0.4915	2319560.0
2015-07-23 18:00:00	NVDA	Stock	0.49	0.49	0.49	0.49	10800.0
2015-07-23 05:00:00	AMZN	Stock	24.515	24.515	24.515	24.515	10100.0
2015-07-23 06:00:00	AMZN	Stock	24.548	24.548	24.5375	24.548	14080.0
2015-07-23 07:00:00	AMZN	Stock	24.567	24.6	24.558	24.558	98460.0
2015-07-23 08:00:00	AMZN	Stock	24.5985	24.6	24.4875	24.5755	501020.0
2015-07-23 09:00:00	AMZN	Stock	24.577	24.597	24.2965	24.336	9156960.0
2015-07-23 10:00:00	AMZN	Stock	24.3355	24.354	24.1888	24.22	13530800.0
2015-07-23 11:00:00	AMZN	Stock	24.22	24.289	23.967	24.0075	11999280.0
2015-07-23 12:00:00	AMZN	Stock	24.0146	24.0225	23.85	23.9875	13671860.0
2015-07-23 13:00:00	AMZN	Stock	23.9874	24.1895	23.9775	24.1485	12803320.0
2015-07-23 14:00:00	AMZN	Stock	24.145	24.1875	23.961	23.9662	15241840.0
2015-07-23 15:00:00	AMZN	Stock	23.9673	24.1595	23.785	24.109	35389880.0
2015-07-23 16:00:00	AMZN	Stock	24.153	28.6725	23.9002	28.35	50805560.0

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

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