PREVIEW / stock_1hour / 2017-09-21

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-09-21.parquet
  size:    1.0 MB
  rows:    47,179
  symbols: 2,944

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-21 04:00:00	AAPL	Stock	39.0125	39.05	39.0	39.02	4316.0
2017-09-21 05:00:00	AAPL	Stock	39.0	39.01	38.9625	38.9825	5204.0
2017-09-21 06:00:00	AAPL	Stock	38.9625	39.025	38.9375	39.0	33836.0
2017-09-21 07:00:00	AAPL	Stock	39.0	39.0125	38.9375	38.975	38432.0
2017-09-21 08:00:00	AAPL	Stock	38.965	39.0375	38.955	39.0125	174668.0
2017-09-21 09:00:00	AAPL	Stock	39.0075	39.01	38.4	38.4625	25839288.0
2017-09-21 10:00:00	AAPL	Stock	38.46	38.5175	38.1875	38.485	38183992.0
2017-09-21 11:00:00	AAPL	Stock	38.4875	38.575	38.41	38.51	13524236.0
2017-09-21 12:00:00	AAPL	Stock	38.5125	38.55	38.39	38.4725	8711580.0
2017-09-21 13:00:00	AAPL	Stock	38.4725	38.6375	38.4575	38.5325	9956676.0
2017-09-21 14:00:00	AAPL	Stock	38.535	38.59	38.44	38.4888	8489292.0
2017-09-21 15:00:00	AAPL	Stock	38.4885	38.5	38.335	38.3525	17249316.0
2017-09-21 16:00:00	AAPL	Stock	38.3475	38.3575	38.305	38.3325	12210848.0
2017-09-21 17:00:00	AAPL	Stock	38.325	38.3475	38.2425	38.2525	382328.0
2017-09-21 18:00:00	AAPL	Stock	38.2525	38.28	38.2525	38.2725	63072.0
2017-09-21 19:00:00	AAPL	Stock	38.2725	38.285	38.25	38.255	102376.0
2017-09-21 07:00:00	MSFT	Stock	75.26	75.26	75.26	75.26	125.0
2017-09-21 08:00:00	MSFT	Stock	74.95	75.07	74.92	75.07	2800.0
2017-09-21 09:00:00	MSFT	Stock	75.05	75.24	74.76	74.786	2043737.0
2017-09-21 10:00:00	MSFT	Stock	74.785	74.84	74.11	74.505	2711386.0
2017-09-21 11:00:00	MSFT	Stock	74.51	74.66	74.4	74.61	1331753.0
2017-09-21 12:00:00	MSFT	Stock	74.61	74.724	74.5	74.56	863601.0
2017-09-21 13:00:00	MSFT	Stock	74.57	74.9	74.57	74.81	1018655.0
2017-09-21 14:00:00	MSFT	Stock	74.82	74.835	74.45	74.55	1296831.0
2017-09-21 15:00:00	MSFT	Stock	74.55	74.61	74.2	74.22	3820305.0
2017-09-21 16:00:00	MSFT	Stock	74.21	74.32	74.21	74.32	5040186.0
2017-09-21 17:00:00	MSFT	Stock	74.3	74.3	74.24	74.29	1626.0
2017-09-21 19:00:00	MSFT	Stock	74.28	74.28	74.28	74.28	100.0
2017-09-21 04:00:00	NVDA	Stock	4.5812	4.5925	4.563	4.5725	760800.0
2017-09-21 05:00:00	NVDA	Stock	4.58	4.613	4.58	4.6083	586920.0
2017-09-21 06:00:00	NVDA	Stock	4.5938	4.5982	4.5675	4.588	782560.0
2017-09-21 07:00:00	NVDA	Stock	4.5883	4.6	4.523	4.5725	6892000.0
2017-09-21 08:00:00	NVDA	Stock	4.575	4.6	4.525	4.5585	11883960.0
2017-09-21 09:00:00	NVDA	Stock	4.5535	4.5688	4.4795	4.5288	250503200.0
2017-09-21 10:00:00	NVDA	Stock	4.527	4.5342	4.4403	4.4868	261267960.0
2017-09-21 11:00:00	NVDA	Stock	4.4869	4.5215	4.4755	4.4848	123593200.0
2017-09-21 12:00:00	NVDA	Stock	4.4855	4.509	4.4608	4.478	86676720.0
2017-09-21 13:00:00	NVDA	Stock	4.4773	4.5168	4.4685	4.514	78743280.0
2017-09-21 14:00:00	NVDA	Stock	4.5145	4.521	4.4903	4.508	75433840.0
2017-09-21 15:00:00	NVDA	Stock	4.508	4.5445	4.4975	4.519	147885080.0
2017-09-21 16:00:00	NVDA	Stock	4.52	4.5293	4.5068	4.508	15643120.0
2017-09-21 17:00:00	NVDA	Stock	4.5075	4.5142	4.505	4.5112	502920.0
2017-09-21 18:00:00	NVDA	Stock	4.5112	4.5125	4.5025	4.5125	307320.0
2017-09-21 19:00:00	NVDA	Stock	4.512	4.521	4.5075	4.5138	439200.0
2017-09-21 07:00:00	AMZN	Stock	48.6845	48.6845	48.6845	48.6845	2000.0
2017-09-21 08:00:00	AMZN	Stock	48.65	48.65	48.5215	48.575	115020.0
2017-09-21 09:00:00	AMZN	Stock	48.5885	48.5975	48.1255	48.2258	7998480.0
2017-09-21 10:00:00	AMZN	Stock	48.206	48.331	48.101	48.253	8630800.0
2017-09-21 11:00:00	AMZN	Stock	48.2545	48.469	48.235	48.376	4826100.0
2017-09-21 12:00:00	AMZN	Stock	48.3732	48.4182	48.2435	48.3505	3210640.0

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

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