PREVIEW / stock_1hour / 2015-06-26

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-26.parquet
  size:    1.1 MB
  rows:    49,269
  symbols: 3,502

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-26 04:00:00	AAPL	Stock	31.94	31.94	31.9	31.9125	7204.0
2015-06-26 05:00:00	AAPL	Stock	31.9175	31.9175	31.9175	31.9175	400.0
2015-06-26 06:00:00	AAPL	Stock	31.915	31.9375	31.9	31.9375	12436.0
2015-06-26 07:00:00	AAPL	Stock	31.93	31.9725	31.93	31.9375	166612.0
2015-06-26 08:00:00	AAPL	Stock	31.935	31.975	31.825	31.89	418252.0
2015-06-26 09:00:00	AAPL	Stock	31.8875	31.9975	31.73	31.975	22066452.0
2015-06-26 10:00:00	AAPL	Stock	31.975	31.995	31.76	31.7675	19958372.0
2015-06-26 11:00:00	AAPL	Stock	31.7675	31.845	31.6925	31.7282	14568524.0
2015-06-26 12:00:00	AAPL	Stock	31.7298	31.77	31.6425	31.65	13316656.0
2015-06-26 13:00:00	AAPL	Stock	31.6498	31.755	31.6275	31.7025	13442216.0
2015-06-26 14:00:00	AAPL	Stock	31.7012	31.715	31.6275	31.69	10472908.0
2015-06-26 15:00:00	AAPL	Stock	31.69	31.7725	31.665	31.695	23955740.0
2015-06-26 16:00:00	AAPL	Stock	31.71	31.7475	31.6875	31.72	27129756.0
2015-06-26 17:00:00	AAPL	Stock	31.72	31.7475	31.7175	31.745	56820.0
2015-06-26 18:00:00	AAPL	Stock	31.7325	31.7425	31.7125	31.715	59736.0
2015-06-26 19:00:00	AAPL	Stock	31.7182	31.725	31.6925	31.695	180552.0
2015-06-26 04:00:00	MSFT	Stock	45.65	45.65	45.64	45.65	2322.0
2015-06-26 07:00:00	MSFT	Stock	45.58	45.65	45.57	45.58	13000.0
2015-06-26 08:00:00	MSFT	Stock	45.57	45.6	45.47	45.56	10692.0
2015-06-26 09:00:00	MSFT	Stock	45.583	46.16	45.52	46.12	4104185.0
2015-06-26 10:00:00	MSFT	Stock	46.13	46.28	45.57	45.651	4900816.0
2015-06-26 11:00:00	MSFT	Stock	45.66	45.81	45.53	45.53	2531520.0
2015-06-26 12:00:00	MSFT	Stock	45.53	45.614	45.095	45.12	3705188.0
2015-06-26 13:00:00	MSFT	Stock	45.12	45.26	45.05	45.16	2964744.0
2015-06-26 14:00:00	MSFT	Stock	45.169	45.2	45.03	45.125	3063331.0
2015-06-26 15:00:00	MSFT	Stock	45.13	45.4	45.12	45.27	6346832.0
2015-06-26 16:00:00	MSFT	Stock	45.27	45.33	45.26	45.32	9886499.0
2015-06-26 17:00:00	MSFT	Stock	45.21	45.32	45.21	45.26	57930.0
2015-06-26 18:00:00	MSFT	Stock	45.3	45.3	45.3	45.3	761.0
2015-06-26 19:00:00	MSFT	Stock	45.3	45.31	45.26	45.26	19675.0
2015-06-26 09:00:00	NVDA	Stock	0.5245	0.5255	0.5198	0.521	49675400.0
2015-06-26 10:00:00	NVDA	Stock	0.521	0.524	0.5202	0.5202	50766680.0
2015-06-26 11:00:00	NVDA	Stock	0.5202	0.5222	0.5192	0.5204	44910520.0
2015-06-26 12:00:00	NVDA	Stock	0.5204	0.5225	0.5182	0.5182	31131640.0
2015-06-26 13:00:00	NVDA	Stock	0.5182	0.519	0.5162	0.5185	32217120.0
2015-06-26 14:00:00	NVDA	Stock	0.5185	0.5192	0.5178	0.5189	32454040.0
2015-06-26 15:00:00	NVDA	Stock	0.5188	0.5213	0.5168	0.5185	66254640.0
2015-06-26 16:00:00	NVDA	Stock	0.5188	0.5188	0.5185	0.5185	30186720.0
2015-06-26 17:00:00	NVDA	Stock	0.52	0.52	0.52	0.52	4000.0
2015-06-26 19:00:00	NVDA	Stock	0.5188	0.5188	0.5185	0.5185	24000.0
2015-06-26 06:00:00	AMZN	Stock	22.04	22.062	22.04	22.062	4340.0
2015-06-26 08:00:00	AMZN	Stock	22.065	22.065	22.065	22.065	2000.0
2015-06-26 09:00:00	AMZN	Stock	22.0765	22.1745	22.012	22.101	5456000.0
2015-06-26 10:00:00	AMZN	Stock	22.1105	22.1354	21.925	21.9285	5088680.0
2015-06-26 11:00:00	AMZN	Stock	21.93	22.009	21.9125	21.938	3799340.0
2015-06-26 12:00:00	AMZN	Stock	21.9365	21.982	21.81	21.8165	4647540.0
2015-06-26 13:00:00	AMZN	Stock	21.8105	21.907	21.753	21.887	5842220.0
2015-06-26 14:00:00	AMZN	Stock	21.887	21.887	21.83	21.859	2989020.0
2015-06-26 15:00:00	AMZN	Stock	21.8615	21.9375	21.8565	21.9105	6971600.0
2015-06-26 16:00:00	AMZN	Stock	21.905	21.9325	21.905	21.91	8150440.0

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

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