PREVIEW / stock_1hour / 2017-09-28

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-09-28.parquet
  size:    1.1 MB
  rows:    50,228
  symbols: 2,948

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-09-28 04:00:00	AAPL	Stock	38.5575	38.5725	38.5525	38.5525	3080.0
2017-09-28 05:00:00	AAPL	Stock	38.5875	38.5875	38.5875	38.5875	400.0
2017-09-28 06:00:00	AAPL	Stock	38.575	38.6125	38.575	38.595	11328.0
2017-09-28 07:00:00	AAPL	Stock	38.5775	38.5925	38.465	38.465	46504.0
2017-09-28 08:00:00	AAPL	Stock	38.5862	38.595	38.4375	38.49	225684.0
2017-09-28 09:00:00	AAPL	Stock	38.475	38.57	38.3225	38.34	14163252.0
2017-09-28 10:00:00	AAPL	Stock	38.3375	38.3625	38.175	38.2225	18206344.0
2017-09-28 11:00:00	AAPL	Stock	38.2225	38.295	38.1825	38.2315	9860100.0
2017-09-28 12:00:00	AAPL	Stock	38.235	38.31	38.21	38.2925	6552152.0
2017-09-28 13:00:00	AAPL	Stock	38.2925	38.3875	38.2625	38.375	5491516.0
2017-09-28 14:00:00	AAPL	Stock	38.375	38.3815	38.23	38.2775	6422500.0
2017-09-28 15:00:00	AAPL	Stock	38.2762	38.325	38.2225	38.315	12382072.0
2017-09-28 16:00:00	AAPL	Stock	38.32	38.3475	38.25	38.3475	6256120.0
2017-09-28 17:00:00	AAPL	Stock	38.3325	38.3625	38.3325	38.35	22080.0
2017-09-28 18:00:00	AAPL	Stock	38.3375	38.3475	38.32	38.3375	29764.0
2017-09-28 19:00:00	AAPL	Stock	38.3375	38.3375	38.3125	38.3175	24808.0
2017-09-28 06:00:00	MSFT	Stock	73.9	73.9	73.9	73.9	500.0
2017-09-28 08:00:00	MSFT	Stock	73.9	73.9	73.7	73.7	4160.0
2017-09-28 09:00:00	MSFT	Stock	73.61	73.72	73.31	73.628	1667282.0
2017-09-28 10:00:00	MSFT	Stock	73.63	73.97	73.53	73.72	1410036.0
2017-09-28 11:00:00	MSFT	Stock	73.72	73.79	73.63	73.69	979796.0
2017-09-28 12:00:00	MSFT	Stock	73.69	73.816	73.585	73.755	697586.0
2017-09-28 13:00:00	MSFT	Stock	73.751	73.91	73.65	73.857	722173.0
2017-09-28 14:00:00	MSFT	Stock	73.86	73.89	73.673	73.77	877229.0
2017-09-28 15:00:00	MSFT	Stock	73.76	73.9	73.68	73.86	2059785.0
2017-09-28 16:00:00	MSFT	Stock	73.87	73.98	73.794	73.87	1695425.0
2017-09-28 17:00:00	MSFT	Stock	73.87	73.98	73.87	73.98	587.0
2017-09-28 18:00:00	MSFT	Stock	73.87	73.87	73.87	73.87	100.0
2017-09-28 04:00:00	NVDA	Stock	4.3938	4.394	4.3938	4.394	105080.0
2017-09-28 05:00:00	NVDA	Stock	4.4125	4.42	4.4053	4.409	88320.0
2017-09-28 06:00:00	NVDA	Stock	4.409	4.4125	4.409	4.4125	75280.0
2017-09-28 07:00:00	NVDA	Stock	4.4062	4.4083	4.3875	4.3875	341240.0
2017-09-28 08:00:00	NVDA	Stock	4.3965	4.4005	4.379	4.3882	1713400.0
2017-09-28 09:00:00	NVDA	Stock	4.3898	4.406	4.344	4.3788	81122240.0
2017-09-28 10:00:00	NVDA	Stock	4.3782	4.3908	4.35	4.3692	80122560.0
2017-09-28 11:00:00	NVDA	Stock	4.3698	4.3862	4.3602	4.3648	46643840.0
2017-09-28 12:00:00	NVDA	Stock	4.365	4.3758	4.361	4.3703	26622560.0
2017-09-28 13:00:00	NVDA	Stock	4.3699	4.3813	4.3662	4.378	24608080.0
2017-09-28 14:00:00	NVDA	Stock	4.3783	4.3802	4.3623	4.367	27208920.0
2017-09-28 15:00:00	NVDA	Stock	4.367	4.395	4.3658	4.3915	61238600.0
2017-09-28 16:00:00	NVDA	Stock	4.3915	4.392	4.3785	4.3898	21592560.0
2017-09-28 17:00:00	NVDA	Stock	4.3898	4.3898	4.387	4.3898	136360.0
2017-09-28 18:00:00	NVDA	Stock	4.3875	4.3898	4.3862	4.3898	152640.0
2017-09-28 19:00:00	NVDA	Stock	4.39	4.391	4.3888	4.39	376560.0
2017-09-28 04:00:00	AMZN	Stock	47.6	47.697	47.6	47.697	8000.0
2017-09-28 05:00:00	AMZN	Stock	47.707	47.707	47.65	47.65	9360.0
2017-09-28 07:00:00	AMZN	Stock	47.6	47.62	47.55	47.55	63980.0
2017-09-28 08:00:00	AMZN	Stock	47.525	47.55	47.45	47.55	60500.0
2017-09-28 09:00:00	AMZN	Stock	47.5125	47.8745	47.503	47.6745	8590740.0
2017-09-28 10:00:00	AMZN	Stock	47.674	47.985	47.5051	47.8	9276700.0

> showing 50 of 50,228 rows — these rows as CSV

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