PREVIEW / stock_1hour / 2017-06-13

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-06-13.parquet
  size:    1.0 MB
  rows:    47,667
  symbols: 3,038

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
2017-06-13 04:00:00	AAPL	Stock	36.7125	36.7125	36.575	36.6725	31968.0
2017-06-13 05:00:00	AAPL	Stock	36.65	36.67	36.56	36.6625	34620.0
2017-06-13 06:00:00	AAPL	Stock	36.66	36.7075	36.605	36.6125	27644.0
2017-06-13 07:00:00	AAPL	Stock	36.6175	36.7975	36.6125	36.75	208092.0
2017-06-13 08:00:00	AAPL	Stock	36.7275	36.8	36.6175	36.7875	956224.0
2017-06-13 09:00:00	AAPL	Stock	36.79	36.8625	36.5775	36.6815	24134404.0
2017-06-13 10:00:00	AAPL	Stock	36.68	36.68	36.3	36.315	25922580.0
2017-06-13 11:00:00	AAPL	Stock	36.3125	36.535	36.2875	36.5275	13073788.0
2017-06-13 12:00:00	AAPL	Stock	36.5275	36.6375	36.5175	36.5838	8825820.0
2017-06-13 13:00:00	AAPL	Stock	36.5825	36.605	36.445	36.54	7817480.0
2017-06-13 14:00:00	AAPL	Stock	36.5388	36.62	36.4825	36.5975	7995300.0
2017-06-13 15:00:00	AAPL	Stock	36.5995	36.725	36.565	36.6475	15440336.0
2017-06-13 16:00:00	AAPL	Stock	36.6475	36.6925	36.375	36.68	11166996.0
2017-06-13 17:00:00	AAPL	Stock	36.6775	36.7225	36.6775	36.72	65592.0
2017-06-13 18:00:00	AAPL	Stock	36.72	36.735	36.705	36.7225	43760.0
2017-06-13 19:00:00	AAPL	Stock	36.715	36.725	36.7025	36.725	33692.0
2017-06-13 04:00:00	MSFT	Stock	69.98	70.0	69.98	70.0	1100.0
2017-06-13 07:00:00	MSFT	Stock	69.98	70.07	69.98	70.06	15248.0
2017-06-13 08:00:00	MSFT	Stock	70.0	70.2	70.0	70.07	10188.0
2017-06-13 09:00:00	MSFT	Stock	70.15	70.62	69.94	70.62	3679120.0
2017-06-13 10:00:00	MSFT	Stock	70.61	70.66	70.14	70.15	4358193.0
2017-06-13 11:00:00	MSFT	Stock	70.15	70.44	70.021	70.38	2651479.0
2017-06-13 12:00:00	MSFT	Stock	70.375	70.77	70.32	70.73	1698324.0
2017-06-13 13:00:00	MSFT	Stock	70.73	70.82	70.59	70.69	1973320.0
2017-06-13 14:00:00	MSFT	Stock	70.68	70.78	70.635	70.69	1807872.0
2017-06-13 15:00:00	MSFT	Stock	70.69	70.81	70.49	70.65	4468608.0
2017-06-13 16:00:00	MSFT	Stock	70.65	70.8	70.64	70.65	2682551.0
2017-06-13 17:00:00	MSFT	Stock	70.78	70.78	70.73	70.73	350.0
2017-06-13 18:00:00	MSFT	Stock	70.65	70.73	70.65	70.7	700.0
2017-06-13 19:00:00	MSFT	Stock	70.7	70.7	70.65	70.65	512.0
2017-06-13 04:00:00	NVDA	Stock	3.8325	3.8742	3.8325	3.8742	285120.0
2017-06-13 05:00:00	NVDA	Stock	3.865	3.8725	3.8415	3.8472	252440.0
2017-06-13 06:00:00	NVDA	Stock	3.8438	3.8575	3.8383	3.84	442560.0
2017-06-13 07:00:00	NVDA	Stock	3.8488	3.8653	3.8405	3.8625	2585400.0
2017-06-13 08:00:00	NVDA	Stock	3.8638	3.867	3.8333	3.843	9364040.0
2017-06-13 09:00:00	NVDA	Stock	3.8418	3.87	3.7838	3.7965	233581520.0
2017-06-13 10:00:00	NVDA	Stock	3.7962	3.8013	3.6412	3.6483	350546360.0
2017-06-13 11:00:00	NVDA	Stock	3.6472	3.758	3.6448	3.7518	277977320.0
2017-06-13 12:00:00	NVDA	Stock	3.751	3.7545	3.6988	3.7383	127292320.0
2017-06-13 13:00:00	NVDA	Stock	3.7375	3.7448	3.7	3.7241	77493480.0
2017-06-13 14:00:00	NVDA	Stock	3.7232	3.7608	3.7065	3.7578	112278720.0
2017-06-13 15:00:00	NVDA	Stock	3.7581	3.8048	3.7544	3.7848	266630720.0
2017-06-13 16:00:00	NVDA	Stock	3.785	3.8013	3.7107	3.796	119400680.0
2017-06-13 17:00:00	NVDA	Stock	3.7928	3.7988	3.789	3.7962	732200.0
2017-06-13 18:00:00	NVDA	Stock	3.7955	3.7988	3.7912	3.7912	1411280.0
2017-06-13 19:00:00	NVDA	Stock	3.7912	3.797	3.7872	3.7915	1021240.0
2017-06-13 06:00:00	AMZN	Stock	48.5475	48.5945	48.5475	48.5945	9500.0
2017-06-13 07:00:00	AMZN	Stock	48.5	48.65	48.5	48.65	99900.0
2017-06-13 08:00:00	AMZN	Stock	48.625	48.789	48.5495	48.7075	684920.0
2017-06-13 09:00:00	AMZN	Stock	48.725	49.1565	48.7	48.9395	20575020.0

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

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