PREVIEW / stock_1hour / 2017-02-15

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-02-15.parquet
  size:    1.1 MB
  rows:    48,778
  symbols: 3,111

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-02-15 04:00:00	AAPL	Stock	33.925	33.995	33.9	33.995	48268.0
2017-02-15 05:00:00	AAPL	Stock	34.0025	34.0925	34.0	34.0	52600.0
2017-02-15 06:00:00	AAPL	Stock	34.0	34.025	33.9125	33.925	166488.0
2017-02-15 07:00:00	AAPL	Stock	33.925	33.96	33.875	33.875	322504.0
2017-02-15 08:00:00	AAPL	Stock	33.8875	34.025	33.675	33.885	666124.0
2017-02-15 09:00:00	AAPL	Stock	33.885	34.0675	33.84	34.0462	29696592.0
2017-02-15 10:00:00	AAPL	Stock	34.0475	34.0475	33.8025	33.81	25031288.0
2017-02-15 11:00:00	AAPL	Stock	33.8075	33.865	33.735	33.7712	17141300.0
2017-02-15 12:00:00	AAPL	Stock	33.77	33.7925	33.7175	33.735	11664184.0
2017-02-15 13:00:00	AAPL	Stock	33.7375	33.825	33.655	33.775	10510988.0
2017-02-15 14:00:00	AAPL	Stock	33.776	33.845	33.755	33.815	6889620.0
2017-02-15 15:00:00	AAPL	Stock	33.8175	33.88	33.795	33.8775	14595252.0
2017-02-15 16:00:00	AAPL	Stock	33.875	33.8975	33.855	33.8825	7020796.0
2017-02-15 17:00:00	AAPL	Stock	33.8825	33.885	33.8525	33.8575	49444.0
2017-02-15 18:00:00	AAPL	Stock	33.875	33.8925	33.8625	33.89	63988.0
2017-02-15 19:00:00	AAPL	Stock	33.885	33.895	33.8775	33.895	53196.0
2017-02-15 04:00:00	MSFT	Stock	64.93	64.93	64.93	64.93	300.0
2017-02-15 07:00:00	MSFT	Stock	64.55	64.55	64.55	64.55	1370.0
2017-02-15 08:00:00	MSFT	Stock	64.64	64.64	64.55	64.55	7690.0
2017-02-15 09:00:00	MSFT	Stock	64.55	64.62	64.21	64.26	1717677.0
2017-02-15 10:00:00	MSFT	Stock	64.26	64.28	64.155	64.24	1753737.0
2017-02-15 11:00:00	MSFT	Stock	64.24	64.48	64.2	64.37	2140894.0
2017-02-15 12:00:00	MSFT	Stock	64.38	64.44	64.31	64.41	1031253.0
2017-02-15 13:00:00	MSFT	Stock	64.415	64.54	64.39	64.48	1283779.0
2017-02-15 14:00:00	MSFT	Stock	64.48	64.56	64.405	64.545	1573035.0
2017-02-15 15:00:00	MSFT	Stock	64.55	64.57	64.44	64.53	3307182.0
2017-02-15 16:00:00	MSFT	Stock	64.53	64.53	64.47	64.48	2268151.0
2017-02-15 17:00:00	MSFT	Stock	64.5	64.53	64.5	64.53	2379.0
2017-02-15 18:00:00	MSFT	Stock	64.53	64.53	64.48	64.5	2623.0
2017-02-15 19:00:00	MSFT	Stock	64.48	64.48	64.44	64.44	3880.0
2017-02-15 06:00:00	NVDA	Stock	2.7228	2.7228	2.7228	2.7228	4000.0
2017-02-15 07:00:00	NVDA	Stock	2.7253	2.7398	2.7253	2.73	191560.0
2017-02-15 08:00:00	NVDA	Stock	2.7365	2.7413	2.714	2.72	1705320.0
2017-02-15 09:00:00	NVDA	Stock	2.7225	2.745	2.7128	2.7183	76035200.0
2017-02-15 10:00:00	NVDA	Stock	2.7198	2.7228	2.694	2.7112	91950720.0
2017-02-15 11:00:00	NVDA	Stock	2.7108	2.7192	2.706	2.7125	33898920.0
2017-02-15 12:00:00	NVDA	Stock	2.713	2.7135	2.7078	2.7108	22102240.0
2017-02-15 13:00:00	NVDA	Stock	2.7105	2.7223	2.7075	2.7191	24891200.0
2017-02-15 14:00:00	NVDA	Stock	2.7195	2.7255	2.7145	2.725	35407040.0
2017-02-15 15:00:00	NVDA	Stock	2.7253	2.7298	2.7205	2.7245	55596240.0
2017-02-15 16:00:00	NVDA	Stock	2.725	2.725	2.7185	2.7185	1563120.0
2017-02-15 17:00:00	NVDA	Stock	2.72	2.7235	2.7195	2.7235	293320.0
2017-02-15 18:00:00	NVDA	Stock	2.7238	2.7238	2.7215	2.7238	130760.0
2017-02-15 19:00:00	NVDA	Stock	2.7195	2.723	2.7195	2.7195	227920.0
2017-02-15 05:00:00	AMZN	Stock	41.9995	42.0105	41.969	41.969	11480.0
2017-02-15 06:00:00	AMZN	Stock	41.96	41.96	41.959	41.959	4500.0
2017-02-15 07:00:00	AMZN	Stock	41.901	41.901	41.875	41.8825	38220.0
2017-02-15 08:00:00	AMZN	Stock	41.725	41.8735	41.725	41.782	94660.0
2017-02-15 09:00:00	AMZN	Stock	41.775	42.015	41.641	42.0	10489040.0
2017-02-15 10:00:00	AMZN	Stock	41.99	42.0745	41.8865	42.009	11252540.0

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

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