PREVIEW / stock_1hour / 2015-10-19

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-19.parquet
  size:    1.0 MB
  rows:    47,909
  symbols: 3,424

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-10-19 04:00:00	AAPL	Stock	27.8225	27.8225	27.7625	27.7625	5600.0
2015-10-19 05:00:00	AAPL	Stock	27.7875	27.7875	27.7625	27.7675	6304.0
2015-10-19 06:00:00	AAPL	Stock	27.77	27.7875	27.75	27.7825	12248.0
2015-10-19 07:00:00	AAPL	Stock	27.7675	27.825	27.7175	27.775	75404.0
2015-10-19 08:00:00	AAPL	Stock	27.775	27.835	27.685	27.685	363504.0
2015-10-19 09:00:00	AAPL	Stock	27.685	27.7475	27.5275	27.705	17227688.0
2015-10-19 10:00:00	AAPL	Stock	27.7	27.87	27.6175	27.865	19121076.0
2015-10-19 11:00:00	AAPL	Stock	27.865	27.895	27.72	27.7975	14071156.0
2015-10-19 12:00:00	AAPL	Stock	27.795	27.81	27.7575	27.775	7691736.0
2015-10-19 13:00:00	AAPL	Stock	27.775	27.8	27.7125	27.7875	11248708.0
2015-10-19 14:00:00	AAPL	Stock	27.785	27.895	27.7675	27.8925	14426592.0
2015-10-19 15:00:00	AAPL	Stock	27.8925	27.9375	27.83	27.9325	19213808.0
2015-10-19 16:00:00	AAPL	Stock	27.9325	27.9325	27.8875	27.9	7582708.0
2015-10-19 17:00:00	AAPL	Stock	27.9025	27.925	27.8875	27.9025	83724.0
2015-10-19 18:00:00	AAPL	Stock	27.9125	27.9325	27.9025	27.9025	59224.0
2015-10-19 19:00:00	AAPL	Stock	27.9025	27.915	27.8875	27.9025	48268.0
2015-10-19 05:00:00	MSFT	Stock	47.57	47.71	47.57	47.71	1212.0
2015-10-19 06:00:00	MSFT	Stock	47.69	47.69	47.6	47.6	2082.0
2015-10-19 07:00:00	MSFT	Stock	47.6	47.62	47.51	47.62	21018.0
2015-10-19 08:00:00	MSFT	Stock	47.65	47.72	47.4	47.4	29225.0
2015-10-19 09:00:00	MSFT	Stock	47.38	47.54	47.02	47.23	2845115.0
2015-10-19 10:00:00	MSFT	Stock	47.23	47.29	47.025	47.28	3250569.0
2015-10-19 11:00:00	MSFT	Stock	47.28	47.71	47.158	47.62	2868597.0
2015-10-19 12:00:00	MSFT	Stock	47.61	47.88	47.53	47.82	3644367.0
2015-10-19 13:00:00	MSFT	Stock	47.816	47.84	47.635	47.7	2885048.0
2015-10-19 14:00:00	MSFT	Stock	47.696	47.71	47.5	47.6	2577554.0
2015-10-19 15:00:00	MSFT	Stock	47.604	47.71	47.52	47.62	5400962.0
2015-10-19 16:00:00	MSFT	Stock	47.62	47.64	47.47	47.63	1921430.0
2015-10-19 17:00:00	MSFT	Stock	47.64	47.7	47.62	47.62	13200.0
2015-10-19 18:00:00	MSFT	Stock	47.62	47.65	47.6	47.64	8100.0
2015-10-19 19:00:00	MSFT	Stock	47.65	47.65	47.6	47.65	4695.0
2015-10-19 07:00:00	NVDA	Stock	0.7005	0.7005	0.6975	0.6975	58000.0
2015-10-19 08:00:00	NVDA	Stock	0.6965	0.7	0.6965	0.7	157080.0
2015-10-19 09:00:00	NVDA	Stock	0.699	0.7019	0.6958	0.6962	28990880.0
2015-10-19 10:00:00	NVDA	Stock	0.6961	0.6964	0.6902	0.695	43135960.0
2015-10-19 11:00:00	NVDA	Stock	0.6951	0.6962	0.6928	0.6951	25508960.0
2015-10-19 12:00:00	NVDA	Stock	0.6951	0.6981	0.693	0.6945	42382960.0
2015-10-19 13:00:00	NVDA	Stock	0.6944	0.6948	0.6872	0.6874	26694680.0
2015-10-19 14:00:00	NVDA	Stock	0.6875	0.6944	0.6874	0.694	37987520.0
2015-10-19 15:00:00	NVDA	Stock	0.6942	0.6968	0.6938	0.6955	48207240.0
2015-10-19 16:00:00	NVDA	Stock	0.6952	0.6968	0.6952	0.6968	31855960.0
2015-10-19 17:00:00	NVDA	Stock	0.6955	0.6955	0.6955	0.6955	44000.0
2015-10-19 18:00:00	NVDA	Stock	0.6962	0.6962	0.6955	0.6955	28000.0
2015-10-19 19:00:00	NVDA	Stock	0.6962	0.6962	0.6962	0.6962	8000.0
2015-10-19 04:00:00	AMZN	Stock	28.5	28.5	28.4975	28.5	31780.0
2015-10-19 06:00:00	AMZN	Stock	28.6	28.6	28.453	28.453	30560.0
2015-10-19 07:00:00	AMZN	Stock	28.4995	28.55	28.45	28.5345	97960.0
2015-10-19 08:00:00	AMZN	Stock	28.54	28.575	28.491	28.493	429480.0
2015-10-19 09:00:00	AMZN	Stock	28.4905	28.668	28.369	28.4825	13844840.0
2015-10-19 10:00:00	AMZN	Stock	28.4875	28.7885	28.4055	28.787	13253080.0

> showing 50 of 47,909 rows — these rows as CSV

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