PREVIEW / stock_1hour / 2017-04-20

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-04-20.parquet
  size:    1.0 MB
  rows:    47,995
  symbols: 3,062

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-04-20 04:00:00	AAPL	Stock	35.25	35.35	35.25	35.35	20724.0
2017-04-20 05:00:00	AAPL	Stock	35.345	35.35	35.325	35.345	13068.0
2017-04-20 06:00:00	AAPL	Stock	35.3425	35.3425	35.3	35.3	8160.0
2017-04-20 07:00:00	AAPL	Stock	35.3125	35.345	35.2825	35.325	37296.0
2017-04-20 08:00:00	AAPL	Stock	35.325	35.3325	35.2875	35.315	87464.0
2017-04-20 09:00:00	AAPL	Stock	35.305	35.45	35.275	35.4052	12370936.0
2017-04-20 10:00:00	AAPL	Stock	35.4068	35.475	35.3875	35.4525	10271636.0
2017-04-20 11:00:00	AAPL	Stock	35.455	35.575	35.43	35.575	10290580.0
2017-04-20 12:00:00	AAPL	Stock	35.5775	35.73	35.57	35.6925	11847620.0
2017-04-20 13:00:00	AAPL	Stock	35.695	35.7275	35.6175	35.71	8632716.0
2017-04-20 14:00:00	AAPL	Stock	35.7088	35.7275	35.6575	35.695	7344960.0
2017-04-20 15:00:00	AAPL	Stock	35.695	35.72	35.5975	35.61	15927208.0
2017-04-20 16:00:00	AAPL	Stock	35.61	35.6725	35.6025	35.6125	9187120.0
2017-04-20 17:00:00	AAPL	Stock	35.6025	35.6125	35.5825	35.5875	31284.0
2017-04-20 18:00:00	AAPL	Stock	35.6025	35.6125	35.6	35.6125	25116.0
2017-04-20 19:00:00	AAPL	Stock	35.6025	35.625	35.6	35.605	39676.0
2017-04-20 05:00:00	MSFT	Stock	65.56	65.56	65.56	65.56	365.0
2017-04-20 08:00:00	MSFT	Stock	65.27	65.28	65.27	65.28	1500.0
2017-04-20 09:00:00	MSFT	Stock	65.28	65.46	65.16	65.365	2275684.0
2017-04-20 10:00:00	MSFT	Stock	65.365	65.535	65.21	65.3	2786465.0
2017-04-20 11:00:00	MSFT	Stock	65.3	65.33	65.14	65.22	1955802.0
2017-04-20 12:00:00	MSFT	Stock	65.215	65.53	65.2	65.47	2341257.0
2017-04-20 13:00:00	MSFT	Stock	65.475	65.67	65.42	65.63	1788756.0
2017-04-20 14:00:00	MSFT	Stock	65.63	65.66	65.525	65.575	2014173.0
2017-04-20 15:00:00	MSFT	Stock	65.575	65.75	65.49	65.5	5070502.0
2017-04-20 16:00:00	MSFT	Stock	65.5	65.54	65.48	65.5	2181610.0
2017-04-20 17:00:00	MSFT	Stock	65.51	65.51	65.5	65.5	700.0
2017-04-20 18:00:00	MSFT	Stock	65.54	65.57	65.54	65.57	750.0
2017-04-20 07:00:00	NVDA	Stock	2.4975	2.51	2.4975	2.5025	192000.0
2017-04-20 08:00:00	NVDA	Stock	2.4975	2.51	2.4975	2.5028	638880.0
2017-04-20 09:00:00	NVDA	Stock	2.5003	2.5195	2.4985	2.5035	43375560.0
2017-04-20 10:00:00	NVDA	Stock	2.5038	2.5195	2.4852	2.4958	76230840.0
2017-04-20 11:00:00	NVDA	Stock	2.496	2.5025	2.49	2.5008	29075920.0
2017-04-20 12:00:00	NVDA	Stock	2.5015	2.5184	2.5	2.5146	41545320.0
2017-04-20 13:00:00	NVDA	Stock	2.5146	2.5306	2.5145	2.5265	65122480.0
2017-04-20 14:00:00	NVDA	Stock	2.5268	2.5282	2.5203	2.5255	32498840.0
2017-04-20 15:00:00	NVDA	Stock	2.5258	2.5362	2.5245	2.5312	57628840.0
2017-04-20 16:00:00	NVDA	Stock	2.5315	2.5345	2.5275	2.5275	25902560.0
2017-04-20 17:00:00	NVDA	Stock	2.5278	2.5348	2.5275	2.5348	108560.0
2017-04-20 18:00:00	NVDA	Stock	2.528	2.5318	2.528	2.5318	94200.0
2017-04-20 19:00:00	NVDA	Stock	2.5293	2.5312	2.5293	2.5312	8000.0
2017-04-20 06:00:00	AMZN	Stock	45.0605	45.0605	45.015	45.015	73900.0
2017-04-20 07:00:00	AMZN	Stock	45.13	45.2	45.05	45.056	170620.0
2017-04-20 08:00:00	AMZN	Stock	45.15	45.175	44.785	44.9305	580540.0
2017-04-20 09:00:00	AMZN	Stock	44.97	45.17	44.8145	44.8798	9694720.0
2017-04-20 10:00:00	AMZN	Stock	44.8925	45.125	44.8685	45.079	8570820.0
2017-04-20 11:00:00	AMZN	Stock	45.0885	45.125	44.97	45.0055	5161860.0
2017-04-20 12:00:00	AMZN	Stock	45.0168	45.266	45.0168	45.1945	7209180.0
2017-04-20 13:00:00	AMZN	Stock	45.1855	45.2489	45.176	45.214	3353860.0
2017-04-20 14:00:00	AMZN	Stock	45.221	45.2332	45.161	45.195	3123640.0

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

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