PREVIEW / stock_1hour / 2015-01-13

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-01-13.parquet
  size:    1.0 MB
  rows:    49,066
  symbols: 3,523

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-13 04:00:00	AAPL	Stock	27.435	27.7125	27.36	27.64	120520.0
2015-01-13 05:00:00	AAPL	Stock	27.68	27.7	27.6375	27.645	69800.0
2015-01-13 06:00:00	AAPL	Stock	27.6375	27.7125	27.6375	27.71	140284.0
2015-01-13 07:00:00	AAPL	Stock	27.6925	27.695	27.625	27.6925	513024.0
2015-01-13 08:00:00	AAPL	Stock	27.6925	27.6925	27.605	27.67	1016092.0
2015-01-13 09:00:00	AAPL	Stock	27.67	28.0075	27.665	27.995	39715676.0
2015-01-13 10:00:00	AAPL	Stock	27.9962	28.2	27.97	28.1738	39654792.0
2015-01-13 11:00:00	AAPL	Stock	28.175	28.175	27.9525	27.9925	27073840.0
2015-01-13 12:00:00	AAPL	Stock	27.9948	28.0025	27.73	27.825	26372248.0
2015-01-13 13:00:00	AAPL	Stock	27.8225	27.8675	27.43	27.5052	32556920.0
2015-01-13 14:00:00	AAPL	Stock	27.505	27.5675	27.2275	27.435	39260560.0
2015-01-13 15:00:00	AAPL	Stock	27.4375	27.7225	27.3775	27.5562	39165024.0
2015-01-13 16:00:00	AAPL	Stock	27.555	28.171	27.25	27.5975	9167596.0
2015-01-13 17:00:00	AAPL	Stock	27.5975	27.8035	27.565	27.6	99432.0
2015-01-13 18:00:00	AAPL	Stock	27.5875	27.61	27.555	27.59	334604.0
2015-01-13 19:00:00	AAPL	Stock	27.6	27.6	27.5625	27.575	79176.0
2015-01-13 04:00:00	MSFT	Stock	46.63	46.63	46.63	46.63	100.0
2015-01-13 05:00:00	MSFT	Stock	46.7	46.7	46.7	46.7	169.0
2015-01-13 06:00:00	MSFT	Stock	46.8	46.8	46.8	46.8	1000.0
2015-01-13 07:00:00	MSFT	Stock	46.85	46.93	46.85	46.85	10402.0
2015-01-13 08:00:00	MSFT	Stock	46.85	46.91	46.68	46.8	43438.0
2015-01-13 09:00:00	MSFT	Stock	46.79	47.91	46.79	47.85	5268121.0
2015-01-13 10:00:00	MSFT	Stock	47.85	47.9	47.6	47.67	4566291.0
2015-01-13 11:00:00	MSFT	Stock	47.675	47.73	47.35	47.45	3238281.0
2015-01-13 12:00:00	MSFT	Stock	47.455	47.515	47.12	47.23	2668821.0
2015-01-13 13:00:00	MSFT	Stock	47.23	47.27	46.39	46.55	3806277.0
2015-01-13 14:00:00	MSFT	Stock	46.545	46.555	46.12	46.13	5482377.0
2015-01-13 15:00:00	MSFT	Stock	46.135	46.59	46.06	46.355	6374257.0
2015-01-13 16:00:00	MSFT	Stock	46.355	47.654	46.311	46.41	2837746.0
2015-01-13 17:00:00	MSFT	Stock	46.49	46.5	46.49	46.5	5200.0
2015-01-13 18:00:00	MSFT	Stock	46.49	46.49	46.42	46.42	825.0
2015-01-13 19:00:00	MSFT	Stock	46.43	46.43	46.41	46.41	5750.0
2015-01-13 09:00:00	NVDA	Stock	0.493	0.5025	0.493	0.5022	24788000.0
2015-01-13 10:00:00	NVDA	Stock	0.5022	0.506	0.5003	0.505	30255840.0
2015-01-13 11:00:00	NVDA	Stock	0.505	0.5058	0.501	0.501	19425920.0
2015-01-13 12:00:00	NVDA	Stock	0.501	0.5015	0.498	0.4991	13744280.0
2015-01-13 13:00:00	NVDA	Stock	0.499	0.5006	0.4898	0.492	23948080.0
2015-01-13 14:00:00	NVDA	Stock	0.492	0.496	0.4895	0.491	27323560.0
2015-01-13 15:00:00	NVDA	Stock	0.4909	0.4938	0.4881	0.4915	57097240.0
2015-01-13 16:00:00	NVDA	Stock	0.4914	0.5076	0.4911	0.4914	33479760.0
2015-01-13 04:00:00	AMZN	Stock	14.725	14.7535	14.725	14.7535	9100.0
2015-01-13 05:00:00	AMZN	Stock	14.775	14.775	14.775	14.775	20000.0
2015-01-13 06:00:00	AMZN	Stock	14.8665	14.8785	14.8665	14.8785	10000.0
2015-01-13 07:00:00	AMZN	Stock	14.88	14.925	14.8605	14.8665	26240.0
2015-01-13 08:00:00	AMZN	Stock	14.8325	14.8995	14.7165	14.8065	1081600.0
2015-01-13 09:00:00	AMZN	Stock	14.8185	14.9375	14.8	14.8855	13342120.0
2015-01-13 10:00:00	AMZN	Stock	14.885	15.071	14.8675	15.07	16375800.0
2015-01-13 11:00:00	AMZN	Stock	15.0715	15.0749	14.987	15.0005	8006460.0
2015-01-13 12:00:00	AMZN	Stock	15.0	15.0075	14.9025	14.943	6127880.0
2015-01-13 13:00:00	AMZN	Stock	14.9426	14.9815	14.745	14.7845	8200580.0

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

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