PREVIEW / stock_1hour / 2015-01-15

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-01-15.parquet
  size:    1.0 MB
  rows:    49,425
  symbols: 3,517

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-01-15 04:00:00	AAPL	Stock	27.645	27.665	27.1875	27.425	85480.0
2015-01-15 05:00:00	AAPL	Stock	27.3875	27.4625	27.255	27.31	43992.0
2015-01-15 06:00:00	AAPL	Stock	27.3125	27.3375	27.155	27.25	126876.0
2015-01-15 07:00:00	AAPL	Stock	27.2375	27.41	27.215	27.3	439732.0
2015-01-15 08:00:00	AAPL	Stock	27.31	27.5825	27.1775	27.5075	1262224.0
2015-01-15 09:00:00	AAPL	Stock	27.485	27.54	26.94	26.95	34689704.0
2015-01-15 10:00:00	AAPL	Stock	26.9425	27.21	26.885	27.0125	38412532.0
2015-01-15 11:00:00	AAPL	Stock	27.015	27.0575	26.6875	26.7825	37417140.0
2015-01-15 12:00:00	AAPL	Stock	26.7825	26.8675	26.665	26.75	23153264.0
2015-01-15 13:00:00	AAPL	Stock	26.75	26.86	26.7425	26.775	18891560.0
2015-01-15 14:00:00	AAPL	Stock	26.7728	26.9738	26.7425	26.9375	19773844.0
2015-01-15 15:00:00	AAPL	Stock	26.9375	26.9675	26.7025	26.7075	33809012.0
2015-01-15 16:00:00	AAPL	Stock	26.705	27.4955	26.7	26.705	11017024.0
2015-01-15 17:00:00	AAPL	Stock	26.72	26.7275	26.675	26.705	251792.0
2015-01-15 18:00:00	AAPL	Stock	26.715	26.7175	26.65	26.665	164956.0
2015-01-15 19:00:00	AAPL	Stock	26.665	26.675	26.54	26.55	440576.0
2015-01-15 04:00:00	MSFT	Stock	46.2	46.2	46.1	46.1	2100.0
2015-01-15 05:00:00	MSFT	Stock	45.91	45.91	45.9	45.9	2300.0
2015-01-15 06:00:00	MSFT	Stock	45.79	45.79	45.79	45.79	1200.0
2015-01-15 07:00:00	MSFT	Stock	46.0	46.19	45.95	45.95	2250.0
2015-01-15 08:00:00	MSFT	Stock	46.19	46.2	46.19	46.2	615.0
2015-01-15 09:00:00	MSFT	Stock	46.16	46.38	45.53	45.75	3799236.0
2015-01-15 10:00:00	MSFT	Stock	45.74	46.05	45.6	45.81	4582224.0
2015-01-15 11:00:00	MSFT	Stock	45.81	45.905	45.52	45.65	3426671.0
2015-01-15 12:00:00	MSFT	Stock	45.65	45.81	45.44	45.595	2748054.0
2015-01-15 13:00:00	MSFT	Stock	45.6	45.825	45.52	45.52	2296839.0
2015-01-15 14:00:00	MSFT	Stock	45.525	45.735	45.46	45.69	2903717.0
2015-01-15 15:00:00	MSFT	Stock	45.69	45.866	45.41	45.48	6210241.0
2015-01-15 16:00:00	MSFT	Stock	45.48	45.811	45.39	45.6	3900173.0
2015-01-15 17:00:00	MSFT	Stock	45.41	45.698	45.3	45.3	19721.0
2015-01-15 18:00:00	MSFT	Stock	45.31	45.31	45.31	45.31	100.0
2015-01-15 19:00:00	MSFT	Stock	45.31	45.36	45.15	45.22	4057.0
2015-01-15 09:00:00	NVDA	Stock	0.497	0.4995	0.4925	0.4942	20641040.0
2015-01-15 10:00:00	NVDA	Stock	0.4942	0.5	0.493	0.4968	19098040.0
2015-01-15 11:00:00	NVDA	Stock	0.4968	0.4989	0.4945	0.4963	22407760.0
2015-01-15 12:00:00	NVDA	Stock	0.4963	0.4978	0.4918	0.4928	14701960.0
2015-01-15 13:00:00	NVDA	Stock	0.4928	0.4955	0.4901	0.4905	14026680.0
2015-01-15 14:00:00	NVDA	Stock	0.4906	0.4948	0.4902	0.4942	27549560.0
2015-01-15 15:00:00	NVDA	Stock	0.494	0.4954	0.4898	0.49	53236080.0
2015-01-15 16:00:00	NVDA	Stock	0.4902	0.4939	0.49	0.49	1819880.0
2015-01-15 17:00:00	NVDA	Stock	0.4945	0.4945	0.4945	0.4945	997040.0
2015-01-15 18:00:00	NVDA	Stock	0.4912	0.4912	0.4912	0.4912	4000.0
2015-01-15 19:00:00	NVDA	Stock	0.49	0.49	0.49	0.49	7800.0
2015-01-15 04:00:00	AMZN	Stock	14.65	14.65	14.65	14.65	2000.0
2015-01-15 05:00:00	AMZN	Stock	14.5565	14.5565	14.5565	14.5565	2000.0
2015-01-15 06:00:00	AMZN	Stock	14.575	14.575	14.575	14.575	2000.0
2015-01-15 07:00:00	AMZN	Stock	14.6	14.663	14.6	14.663	9400.0
2015-01-15 08:00:00	AMZN	Stock	14.6375	14.6945	14.5735	14.6945	84240.0
2015-01-15 09:00:00	AMZN	Stock	14.687	14.8	14.521	14.5585	12163180.0
2015-01-15 10:00:00	AMZN	Stock	14.5475	14.6135	14.482	14.5	11165060.0

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

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