PREVIEW / stock_1hour / 2015-10-20

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-20.parquet
  size:    1.0 MB
  rows:    47,665
  symbols: 3,423

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-20 04:00:00	AAPL	Stock	27.8325	27.8325	27.8125	27.8125	1200.0
2015-10-20 05:00:00	AAPL	Stock	27.805	27.805	27.805	27.805	1200.0
2015-10-20 06:00:00	AAPL	Stock	27.8675	27.8675	27.8625	27.865	3396.0
2015-10-20 07:00:00	AAPL	Stock	27.8675	27.9	27.8575	27.8925	30628.0
2015-10-20 08:00:00	AAPL	Stock	27.8825	28.05	27.8675	28.0375	589056.0
2015-10-20 09:00:00	AAPL	Stock	28.0375	28.085	27.685	28.045	27264792.0
2015-10-20 10:00:00	AAPL	Stock	28.045	28.4738	28.0375	28.43	50248396.0
2015-10-20 11:00:00	AAPL	Stock	28.4298	28.4825	28.29	28.4125	26543464.0
2015-10-20 12:00:00	AAPL	Stock	28.4078	28.5425	28.3825	28.512	23696384.0
2015-10-20 13:00:00	AAPL	Stock	28.51	28.5112	28.35	28.424	15305300.0
2015-10-20 14:00:00	AAPL	Stock	28.4225	28.475	28.3875	28.425	12441296.0
2015-10-20 15:00:00	AAPL	Stock	28.425	28.4825	28.38	28.45	22206720.0
2015-10-20 16:00:00	AAPL	Stock	28.4425	28.4625	28.3425	28.365	6788748.0
2015-10-20 17:00:00	AAPL	Stock	28.3775	28.4	28.35	28.4	48188.0
2015-10-20 18:00:00	AAPL	Stock	28.3975	28.4025	28.3675	28.3825	16728.0
2015-10-20 19:00:00	AAPL	Stock	28.3825	28.405	28.3825	28.385	50560.0
2015-10-20 07:00:00	MSFT	Stock	47.55	47.55	47.55	47.55	1000.0
2015-10-20 08:00:00	MSFT	Stock	47.55	47.6	47.5	47.54	10068.0
2015-10-20 09:00:00	MSFT	Stock	47.5	47.59	47.02	47.485	5127537.0
2015-10-20 10:00:00	MSFT	Stock	47.49	47.575	47.35	47.49	3774564.0
2015-10-20 11:00:00	MSFT	Stock	47.485	47.69	47.25	47.64	3397241.0
2015-10-20 12:00:00	MSFT	Stock	47.64	47.79	47.5	47.717	2567812.0
2015-10-20 13:00:00	MSFT	Stock	47.71	47.77	47.6	47.645	2176337.0
2015-10-20 14:00:00	MSFT	Stock	47.645	47.78	47.63	47.725	2517112.0
2015-10-20 15:00:00	MSFT	Stock	47.727	47.81	47.56	47.77	6304309.0
2015-10-20 16:00:00	MSFT	Stock	47.77	47.8	47.68	47.73	3532624.0
2015-10-20 17:00:00	MSFT	Stock	47.75	47.76	47.73	47.76	3283.0
2015-10-20 18:00:00	MSFT	Stock	47.72	47.73	47.71	47.73	3700.0
2015-10-20 19:00:00	MSFT	Stock	47.7	47.73	47.7	47.73	1100.0
2015-10-20 08:00:00	NVDA	Stock	0.6965	0.6965	0.6868	0.6868	42400.0
2015-10-20 09:00:00	NVDA	Stock	0.6952	0.6975	0.6898	0.6944	26999120.0
2015-10-20 10:00:00	NVDA	Stock	0.6945	0.6968	0.6921	0.695	42563680.0
2015-10-20 11:00:00	NVDA	Stock	0.6949	0.6954	0.6918	0.692	26674560.0
2015-10-20 12:00:00	NVDA	Stock	0.692	0.6936	0.6892	0.6912	20598720.0
2015-10-20 13:00:00	NVDA	Stock	0.691	0.6912	0.6878	0.6878	20267160.0
2015-10-20 14:00:00	NVDA	Stock	0.688	0.6918	0.687	0.6918	33534000.0
2015-10-20 15:00:00	NVDA	Stock	0.6918	0.6949	0.6902	0.6942	42822880.0
2015-10-20 16:00:00	NVDA	Stock	0.6942	0.6942	0.6888	0.6935	1498680.0
2015-10-20 18:00:00	NVDA	Stock	0.699	0.699	0.699	0.699	4840.0
2015-10-20 19:00:00	NVDA	Stock	0.6942	0.6942	0.6942	0.6942	20000.0
2015-10-20 07:00:00	AMZN	Stock	28.6065	28.6075	28.5895	28.6075	49620.0
2015-10-20 08:00:00	AMZN	Stock	28.6	28.714	28.6	28.6895	231940.0
2015-10-20 09:00:00	AMZN	Stock	28.6995	28.6995	28.1055	28.231	15990980.0
2015-10-20 10:00:00	AMZN	Stock	28.252	28.3255	28.1255	28.171	12339700.0
2015-10-20 11:00:00	AMZN	Stock	28.1795	28.1795	27.88	27.9805	9943900.0
2015-10-20 12:00:00	AMZN	Stock	27.969	28.0685	27.915	27.9808	7211860.0
2015-10-20 13:00:00	AMZN	Stock	27.9805	27.9805	27.764	27.8928	6566860.0
2015-10-20 14:00:00	AMZN	Stock	27.8935	28.043	27.755	28.041	8331080.0
2015-10-20 15:00:00	AMZN	Stock	28.0435	28.1135	27.9085	28.044	11706540.0
2015-10-20 16:00:00	AMZN	Stock	28.044	28.143	28.015	28.015	2947700.0

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

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