PREVIEW / stock_1hour / 2016-05-19

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-19.parquet
  size:    1.0 MB
  rows:    47,875
  symbols: 3,280

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
2016-05-19 04:00:00	AAPL	Stock	23.65	23.665	23.6125	23.6125	4756.0
2016-05-19 05:00:00	AAPL	Stock	23.6075	23.64	23.6075	23.64	4924.0
2016-05-19 06:00:00	AAPL	Stock	23.655	23.655	23.6375	23.6375	8000.0
2016-05-19 07:00:00	AAPL	Stock	23.655	23.7025	23.65	23.69	27288.0
2016-05-19 08:00:00	AAPL	Stock	23.6925	23.6925	23.58	23.61	210800.0
2016-05-19 09:00:00	AAPL	Stock	23.61	23.6675	23.4125	23.43	20612968.0
2016-05-19 10:00:00	AAPL	Stock	23.4275	23.54	23.4125	23.4275	18904488.0
2016-05-19 11:00:00	AAPL	Stock	23.4275	23.4925	23.3925	23.4625	13273780.0
2016-05-19 12:00:00	AAPL	Stock	23.4605	23.525	23.4	23.4225	8911388.0
2016-05-19 13:00:00	AAPL	Stock	23.42	23.555	23.4132	23.495	10643728.0
2016-05-19 14:00:00	AAPL	Stock	23.495	23.54	23.415	23.4225	9950580.0
2016-05-19 15:00:00	AAPL	Stock	23.425	23.5975	23.4225	23.55	16457276.0
2016-05-19 16:00:00	AAPL	Stock	23.55	23.5825	23.4602	23.56	3412232.0
2016-05-19 17:00:00	AAPL	Stock	23.585	23.585	23.5575	23.57	12200.0
2016-05-19 18:00:00	AAPL	Stock	23.585	23.5875	23.56	23.575	35124.0
2016-05-19 19:00:00	AAPL	Stock	23.5825	23.59	23.565	23.5775	16484.0
2016-05-19 07:00:00	MSFT	Stock	50.69	50.71	50.64	50.71	6300.0
2016-05-19 08:00:00	MSFT	Stock	50.68	50.7	50.52	50.54	7380.0
2016-05-19 09:00:00	MSFT	Stock	50.53	50.62	49.94	49.95	3157238.0
2016-05-19 10:00:00	MSFT	Stock	49.95	50.08	49.84	49.95	5288264.0
2016-05-19 11:00:00	MSFT	Stock	49.96	50.015	49.82	49.96	3368161.0
2016-05-19 12:00:00	MSFT	Stock	49.96	50.07	49.89	49.94	1722394.0
2016-05-19 13:00:00	MSFT	Stock	49.94	50.23	49.92	50.08	1818543.0
2016-05-19 14:00:00	MSFT	Stock	50.08	50.27	50.05	50.065	1907898.0
2016-05-19 15:00:00	MSFT	Stock	50.07	50.37	50.065	50.32	3502538.0
2016-05-19 16:00:00	MSFT	Stock	50.32	50.32	50.25	50.31	1613629.0
2016-05-19 17:00:00	MSFT	Stock	50.33	50.37	50.3	50.32	7800.0
2016-05-19 18:00:00	MSFT	Stock	50.32	50.35	50.32	50.35	900.0
2016-05-19 19:00:00	MSFT	Stock	50.32	50.34	50.3	50.3	1955.0
2016-05-19 07:00:00	NVDA	Stock	1.083	1.083	1.0812	1.0812	8000.0
2016-05-19 08:00:00	NVDA	Stock	1.083	1.083	1.0825	1.0825	16000.0
2016-05-19 09:00:00	NVDA	Stock	1.0822	1.0965	1.0783	1.0785	60365000.0
2016-05-19 10:00:00	NVDA	Stock	1.0785	1.0858	1.0783	1.0805	68154520.0
2016-05-19 11:00:00	NVDA	Stock	1.0805	1.0845	1.0792	1.082	69755480.0
2016-05-19 12:00:00	NVDA	Stock	1.0815	1.0865	1.0798	1.0801	32898800.0
2016-05-19 13:00:00	NVDA	Stock	1.08	1.0883	1.0792	1.0848	42320600.0
2016-05-19 14:00:00	NVDA	Stock	1.085	1.0902	1.083	1.0838	34961600.0
2016-05-19 15:00:00	NVDA	Stock	1.0836	1.0915	1.0835	1.089	63508960.0
2016-05-19 16:00:00	NVDA	Stock	1.0887	1.0905	1.0875	1.0887	3172160.0
2016-05-19 17:00:00	NVDA	Stock	1.0895	1.0895	1.0895	1.0895	6920.0
2016-05-19 18:00:00	NVDA	Stock	1.0885	1.0887	1.0885	1.0887	8880.0
2016-05-19 06:00:00	AMZN	Stock	34.7065	34.7065	34.7065	34.7065	2400.0
2016-05-19 07:00:00	AMZN	Stock	34.76	34.84	34.75	34.7505	38540.0
2016-05-19 08:00:00	AMZN	Stock	34.85	34.8665	34.756	34.7905	88840.0
2016-05-19 09:00:00	AMZN	Stock	34.75	34.95	34.55	34.7255	9149560.0
2016-05-19 10:00:00	AMZN	Stock	34.7255	34.7765	34.5395	34.6505	12828640.0
2016-05-19 11:00:00	AMZN	Stock	34.677	34.7018	34.478	34.6	8552620.0
2016-05-19 12:00:00	AMZN	Stock	34.583	34.718	34.57	34.6424	4634500.0
2016-05-19 13:00:00	AMZN	Stock	34.6308	34.8675	34.602	34.7822	6125740.0
2016-05-19 14:00:00	AMZN	Stock	34.772	34.875	34.6765	34.7445	5303520.0

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

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