PREVIEW / stock_1hour / 2017-05-22

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-05-22.parquet
  size:    1.0 MB
  rows:    48,124
  symbols: 3,027

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-05-22 05:00:00	AAPL	Stock	38.3375	38.3375	38.3375	38.3375	2772.0
2017-05-22 06:00:00	AAPL	Stock	38.425	38.425	38.335	38.35	8912.0
2017-05-22 07:00:00	AAPL	Stock	38.375	38.45	38.3725	38.415	62828.0
2017-05-22 08:00:00	AAPL	Stock	38.4	38.465	38.3375	38.45	243780.0
2017-05-22 09:00:00	AAPL	Stock	38.4475	38.645	38.4175	38.4288	16925908.0
2017-05-22 10:00:00	AAPL	Stock	38.4288	38.455	38.2275	38.295	17306428.0
2017-05-22 11:00:00	AAPL	Stock	38.295	38.4475	38.275	38.415	8319012.0
2017-05-22 12:00:00	AAPL	Stock	38.4165	38.505	38.4025	38.4888	6478456.0
2017-05-22 13:00:00	AAPL	Stock	38.4892	38.5275	38.41	38.46	6886944.0
2017-05-22 14:00:00	AAPL	Stock	38.46	38.4775	38.395	38.4625	6712160.0
2017-05-22 15:00:00	AAPL	Stock	38.4638	38.5025	38.4175	38.49	11600668.0
2017-05-22 16:00:00	AAPL	Stock	38.4975	38.525	38.485	38.5075	7287020.0
2017-05-22 17:00:00	AAPL	Stock	38.495	38.5125	38.4925	38.5125	47228.0
2017-05-22 18:00:00	AAPL	Stock	38.5125	38.5125	38.475	38.4975	51172.0
2017-05-22 19:00:00	AAPL	Stock	38.4775	38.495	38.4175	38.4225	41228.0
2017-05-22 07:00:00	MSFT	Stock	67.81	67.81	67.81	67.81	845.0
2017-05-22 08:00:00	MSFT	Stock	67.81	67.82	67.68	67.8	3345.0
2017-05-22 09:00:00	MSFT	Stock	67.85	68.028	67.5	68.01	1864263.0
2017-05-22 10:00:00	MSFT	Stock	68.01	68.196	67.96	68.1	1679798.0
2017-05-22 11:00:00	MSFT	Stock	68.09	68.3	68.075	68.29	1513441.0
2017-05-22 12:00:00	MSFT	Stock	68.28	68.29	68.16	68.22	985182.0
2017-05-22 13:00:00	MSFT	Stock	68.23	68.29	68.01	68.211	870943.0
2017-05-22 14:00:00	MSFT	Stock	68.21	68.36	68.19	68.26	1268933.0
2017-05-22 15:00:00	MSFT	Stock	68.26	68.47	68.2	68.45	3255710.0
2017-05-22 16:00:00	MSFT	Stock	68.5	68.5	68.37	68.45	2737417.0
2017-05-22 17:00:00	MSFT	Stock	68.38	68.4	68.38	68.4	270.0
2017-05-22 18:00:00	MSFT	Stock	68.45	68.45	68.45	68.45	500.0
2017-05-22 19:00:00	MSFT	Stock	68.35	68.4	68.32	68.32	1601.0
2017-05-22 04:00:00	NVDA	Stock	3.4135	3.4135	3.405	3.405	66080.0
2017-05-22 05:00:00	NVDA	Stock	3.408	3.408	3.407	3.407	16000.0
2017-05-22 06:00:00	NVDA	Stock	3.4098	3.4468	3.4098	3.4468	160680.0
2017-05-22 07:00:00	NVDA	Stock	3.428	3.4338	3.4152	3.4238	552200.0
2017-05-22 08:00:00	NVDA	Stock	3.425	3.4438	3.4175	3.4182	3806080.0
2017-05-22 09:00:00	NVDA	Stock	3.418	3.485	3.4168	3.4688	172793800.0
2017-05-22 10:00:00	NVDA	Stock	3.4693	3.487	3.4583	3.4605	177783320.0
2017-05-22 11:00:00	NVDA	Stock	3.4602	3.4762	3.4465	3.457	125015480.0
2017-05-22 12:00:00	NVDA	Stock	3.457	3.4608	3.4395	3.448	68986680.0
2017-05-22 13:00:00	NVDA	Stock	3.4478	3.452	3.438	3.4425	61750800.0
2017-05-22 14:00:00	NVDA	Stock	3.4428	3.4558	3.4373	3.4444	63585320.0
2017-05-22 15:00:00	NVDA	Stock	3.4445	3.4748	3.4445	3.4725	107650200.0
2017-05-22 16:00:00	NVDA	Stock	3.475	3.475	3.47	3.4725	18420120.0
2017-05-22 17:00:00	NVDA	Stock	3.4725	3.4735	3.4722	3.4735	333320.0
2017-05-22 18:00:00	NVDA	Stock	3.4735	3.475	3.4712	3.4725	555640.0
2017-05-22 19:00:00	NVDA	Stock	3.4712	3.4712	3.4578	3.4625	267720.0
2017-05-22 04:00:00	AMZN	Stock	48.05	48.1475	48.05	48.1475	7380.0
2017-05-22 05:00:00	AMZN	Stock	48.167	48.196	48.155	48.155	13980.0
2017-05-22 06:00:00	AMZN	Stock	48.1375	48.1375	48.1375	48.1375	5020.0
2017-05-22 07:00:00	AMZN	Stock	48.15	48.235	48.15	48.1985	92540.0
2017-05-22 08:00:00	AMZN	Stock	48.209	48.209	48.0475	48.16	537020.0
2017-05-22 09:00:00	AMZN	Stock	48.175	48.533	48.1225	48.5065	14361060.0

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

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