PREVIEW / stock_1hour / 2015-04-24

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-24.parquet
  size:    1.0 MB
  rows:    48,570
  symbols: 3,520

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-04-24 04:00:00	AAPL	Stock	32.625	32.635	32.5225	32.59	51448.0
2015-04-24 05:00:00	AAPL	Stock	32.59	32.59	32.55	32.55	32128.0
2015-04-24 06:00:00	AAPL	Stock	32.5275	32.5625	32.5	32.55	51868.0
2015-04-24 07:00:00	AAPL	Stock	32.56	32.6125	32.525	32.5625	182144.0
2015-04-24 08:00:00	AAPL	Stock	32.5625	32.625	32.5025	32.6225	1051544.0
2015-04-24 09:00:00	AAPL	Stock	32.625	32.6625	32.4375	32.5375	31411716.0
2015-04-24 10:00:00	AAPL	Stock	32.54	32.5573	32.33	32.355	30504628.0
2015-04-24 11:00:00	AAPL	Stock	32.355	32.485	32.3075	32.455	17050240.0
2015-04-24 12:00:00	AAPL	Stock	32.455	32.59	32.4175	32.455	21890660.0
2015-04-24 13:00:00	AAPL	Stock	32.4575	32.5375	32.44	32.475	10402976.0
2015-04-24 14:00:00	AAPL	Stock	32.4775	32.52	32.4325	32.495	12633392.0
2015-04-24 15:00:00	AAPL	Stock	32.495	32.5775	32.465	32.57	25501604.0
2015-04-24 16:00:00	AAPL	Stock	32.57	32.615	32.5625	32.595	10462268.0
2015-04-24 17:00:00	AAPL	Stock	32.5875	32.6225	32.5825	32.615	300932.0
2015-04-24 18:00:00	AAPL	Stock	32.6175	32.64	32.61	32.6325	618612.0
2015-04-24 19:00:00	AAPL	Stock	32.6325	32.64	32.6225	32.64	305664.0
2015-04-24 04:00:00	MSFT	Stock	44.67	44.67	44.49	44.64	5700.0
2015-04-24 05:00:00	MSFT	Stock	44.65	44.65	44.59	44.59	1993.0
2015-04-24 06:00:00	MSFT	Stock	44.57	44.9	44.24	44.73	76014.0
2015-04-24 07:00:00	MSFT	Stock	44.8	45.24	44.72	45.2	251626.0
2015-04-24 08:00:00	MSFT	Stock	45.2	45.69	44.72	45.55	981975.0
2015-04-24 09:00:00	MSFT	Stock	45.55	46.44	45.33	46.11	25916214.0
2015-04-24 10:00:00	MSFT	Stock	46.11	46.84	46.01	46.835	20457504.0
2015-04-24 11:00:00	MSFT	Stock	46.84	47.31	46.72	47.12	15834712.0
2015-04-24 12:00:00	MSFT	Stock	47.13	47.49	47.11	47.415	10796431.0
2015-04-24 13:00:00	MSFT	Stock	47.41	47.78	47.26	47.38	10669634.0
2015-04-24 14:00:00	MSFT	Stock	47.38	47.77	47.36	47.61	9024073.0
2015-04-24 15:00:00	MSFT	Stock	47.619	48.14	47.52	47.87	22821425.0
2015-04-24 16:00:00	MSFT	Stock	47.87	47.93	47.75	47.84	6892401.0
2015-04-24 17:00:00	MSFT	Stock	47.84	47.84	47.67	47.68	57988.0
2015-04-24 18:00:00	MSFT	Stock	47.66	47.7	47.66	47.66	9709.0
2015-04-24 19:00:00	MSFT	Stock	47.69	47.71	47.6	47.68	24298.0
2015-04-24 09:00:00	NVDA	Stock	0.557	0.557	0.5488	0.5492	25063280.0
2015-04-24 10:00:00	NVDA	Stock	0.5495	0.5525	0.547	0.5524	49603080.0
2015-04-24 11:00:00	NVDA	Stock	0.5524	0.5524	0.548	0.5488	25518000.0
2015-04-24 12:00:00	NVDA	Stock	0.549	0.549	0.5445	0.5458	25709800.0
2015-04-24 13:00:00	NVDA	Stock	0.5458	0.5492	0.5452	0.5488	18251960.0
2015-04-24 14:00:00	NVDA	Stock	0.5488	0.552	0.5485	0.551	24078320.0
2015-04-24 15:00:00	NVDA	Stock	0.5508	0.5518	0.5488	0.5508	41982760.0
2015-04-24 16:00:00	NVDA	Stock	0.5508	0.5508	0.5508	0.5508	1432360.0
2015-04-24 04:00:00	AMZN	Stock	20.9	20.95	20.8875	20.9465	152520.0
2015-04-24 05:00:00	AMZN	Stock	20.95	21.15	20.95	21.095	227520.0
2015-04-24 06:00:00	AMZN	Stock	21.1	21.5495	21.0875	21.5	803200.0
2015-04-24 07:00:00	AMZN	Stock	21.5	22.15	21.401	21.9995	3575880.0
2015-04-24 08:00:00	AMZN	Stock	21.9995	22.1465	21.401	21.8975	12053300.0
2015-04-24 09:00:00	AMZN	Stock	21.8585	22.622	21.852	22.5785	104497480.0
2015-04-24 10:00:00	AMZN	Stock	22.576	22.6325	22.2155	22.241	62229500.0
2015-04-24 11:00:00	AMZN	Stock	22.2465	22.3825	22.183	22.3465	30791040.0
2015-04-24 12:00:00	AMZN	Stock	22.347	22.509	22.3465	22.448	28563660.0
2015-04-24 13:00:00	AMZN	Stock	22.45	22.525	22.3545	22.375	22104140.0

> showing 50 of 48,570 rows — these rows as CSV

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