PREVIEW / stock_1hour / 2015-09-01

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-01.parquet
  size:    1.0 MB
  rows:    49,899
  symbols: 3,473

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-09-01 04:00:00	AAPL	Stock	27.8625	27.8625	27.4	27.445	92716.0
2015-09-01 05:00:00	AAPL	Stock	27.445	27.62	27.445	27.575	95040.0
2015-09-01 06:00:00	AAPL	Stock	27.52	27.62	27.5	27.5575	151660.0
2015-09-01 07:00:00	AAPL	Stock	27.5625	27.6775	27.55	27.6075	807872.0
2015-09-01 08:00:00	AAPL	Stock	27.6	27.6725	27.42	27.4375	2466080.0
2015-09-01 09:00:00	AAPL	Stock	27.4375	27.97	27.405	27.715	39987712.0
2015-09-01 10:00:00	AAPL	Stock	27.7125	27.925	27.57	27.735	43485380.0
2015-09-01 11:00:00	AAPL	Stock	27.7375	27.85	27.6675	27.78	25247480.0
2015-09-01 12:00:00	AAPL	Stock	27.78	27.825	27.4375	27.513	30431444.0
2015-09-01 13:00:00	AAPL	Stock	27.515	27.61	27.4525	27.5575	23617876.0
2015-09-01 14:00:00	AAPL	Stock	27.5528	27.56	27.22	27.2375	33465536.0
2015-09-01 15:00:00	AAPL	Stock	27.2375	27.2825	26.84	26.9325	73233508.0
2015-09-01 16:00:00	AAPL	Stock	26.93	27.7265	26.93	26.975	12025156.0
2015-09-01 17:00:00	AAPL	Stock	26.9825	26.985	26.7975	26.82	526944.0
2015-09-01 18:00:00	AAPL	Stock	26.82	26.92	26.7775	26.9	334136.0
2015-09-01 19:00:00	AAPL	Stock	26.9	27.125	26.8875	27.1125	309520.0
2015-09-01 04:00:00	MSFT	Stock	42.49	42.49	42.3	42.3	7770.0
2015-09-01 05:00:00	MSFT	Stock	42.3	42.5	42.3	42.41	12437.0
2015-09-01 06:00:00	MSFT	Stock	42.42	42.55	42.4	42.45	35591.0
2015-09-01 07:00:00	MSFT	Stock	42.45	42.67	42.45	42.56	3699.0
2015-09-01 08:00:00	MSFT	Stock	42.65	43.02	42.4	42.49	58071.0
2015-09-01 09:00:00	MSFT	Stock	42.41	42.541	42.0	42.315	5920764.0
2015-09-01 10:00:00	MSFT	Stock	42.31	42.59	42.18	42.345	8325733.0
2015-09-01 11:00:00	MSFT	Stock	42.35	42.48	42.16	42.22	3997979.0
2015-09-01 12:00:00	MSFT	Stock	42.22	42.275	41.85	41.866	4015936.0
2015-09-01 13:00:00	MSFT	Stock	41.86	42.2	41.75	42.16	3500191.0
2015-09-01 14:00:00	MSFT	Stock	42.15	42.2	41.88	42.07	4644421.0
2015-09-01 15:00:00	MSFT	Stock	42.07	42.095	41.66	41.83	12623499.0
2015-09-01 16:00:00	MSFT	Stock	41.84	42.173	41.75	41.9	4032782.0
2015-09-01 17:00:00	MSFT	Stock	41.9	41.9	41.82	41.83	5485.0
2015-09-01 18:00:00	MSFT	Stock	41.83	41.85	41.75	41.85	2091.0
2015-09-01 19:00:00	MSFT	Stock	41.77	42.0	41.77	42.0	1424.0
2015-09-01 09:00:00	NVDA	Stock	0.5455	0.555	0.5432	0.5532	45805320.0
2015-09-01 10:00:00	NVDA	Stock	0.553	0.5535	0.5478	0.5492	50803000.0
2015-09-01 11:00:00	NVDA	Stock	0.5492	0.5518	0.5482	0.5486	36907600.0
2015-09-01 12:00:00	NVDA	Stock	0.5488	0.5492	0.5415	0.5415	23502120.0
2015-09-01 13:00:00	NVDA	Stock	0.5415	0.5451	0.5401	0.5445	31895520.0
2015-09-01 14:00:00	NVDA	Stock	0.5448	0.5448	0.5395	0.5402	32720920.0
2015-09-01 15:00:00	NVDA	Stock	0.5402	0.5411	0.535	0.5391	103115600.0
2015-09-01 16:00:00	NVDA	Stock	0.5382	0.541	0.5382	0.541	589280.0
2015-09-01 04:00:00	AMZN	Stock	25.251	25.251	24.8915	24.8915	42900.0
2015-09-01 05:00:00	AMZN	Stock	24.95	25.0	24.95	24.9985	15000.0
2015-09-01 06:00:00	AMZN	Stock	25.0745	25.075	24.9625	25.0	31080.0
2015-09-01 07:00:00	AMZN	Stock	25.005	25.105	25.005	25.0735	82660.0
2015-09-01 08:00:00	AMZN	Stock	25.05	25.1575	24.9065	24.9105	680800.0
2015-09-01 09:00:00	AMZN	Stock	24.9105	25.5	24.9	25.3	10149080.0
2015-09-01 10:00:00	AMZN	Stock	25.2895	25.4405	25.1775	25.4	8406280.0
2015-09-01 11:00:00	AMZN	Stock	25.3912	25.4686	25.2515	25.278	6047380.0
2015-09-01 12:00:00	AMZN	Stock	25.291	25.326	25.0115	25.0395	7034440.0
2015-09-01 13:00:00	AMZN	Stock	25.027	25.1735	24.9875	25.089	5929960.0

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

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