PREVIEW / stock_1hour / 2017-04-10

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-04-10.parquet
  size:    1.0 MB
  rows:    47,837
  symbols: 3,061

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-10 04:00:00	AAPL	Stock	35.925	35.9875	35.91	35.9875	1544.0
2017-04-10 05:00:00	AAPL	Stock	35.9	35.9	35.895	35.895	3920.0
2017-04-10 06:00:00	AAPL	Stock	35.9	35.925	35.8775	35.915	4000.0
2017-04-10 07:00:00	AAPL	Stock	35.925	35.9325	35.88	35.92	27436.0
2017-04-10 08:00:00	AAPL	Stock	35.9125	35.93	35.865	35.875	121364.0
2017-04-10 09:00:00	AAPL	Stock	35.885	35.9698	35.8625	35.915	7939548.0
2017-04-10 10:00:00	AAPL	Stock	35.915	35.9188	35.8475	35.87	8531768.0
2017-04-10 11:00:00	AAPL	Stock	35.8675	35.9	35.7875	35.8125	7820368.0
2017-04-10 12:00:00	AAPL	Stock	35.8125	35.91	35.7625	35.905	8141912.0
2017-04-10 13:00:00	AAPL	Stock	35.905	35.94	35.8462	35.8625	5992428.0
2017-04-10 14:00:00	AAPL	Stock	35.8638	35.865	35.78	35.827	6380096.0
2017-04-10 15:00:00	AAPL	Stock	35.8288	35.865	35.725	35.79	12505212.0
2017-04-10 16:00:00	AAPL	Stock	35.7925	35.8418	35.765	35.795	8610156.0
2017-04-10 17:00:00	AAPL	Stock	35.79	35.795	35.78	35.78	25552.0
2017-04-10 18:00:00	AAPL	Stock	35.7925	35.8025	35.785	35.785	40556.0
2017-04-10 19:00:00	AAPL	Stock	35.7925	35.7925	35.775	35.7875	15952.0
2017-04-10 08:00:00	MSFT	Stock	65.79	65.89	65.79	65.82	1252.0
2017-04-10 09:00:00	MSFT	Stock	65.8	65.8	65.58	65.69	1260015.0
2017-04-10 10:00:00	MSFT	Stock	65.69	65.82	65.615	65.675	1330212.0
2017-04-10 11:00:00	MSFT	Stock	65.68	65.71	65.43	65.54	1375753.0
2017-04-10 12:00:00	MSFT	Stock	65.54	65.73	65.36	65.71	1686862.0
2017-04-10 13:00:00	MSFT	Stock	65.7	65.8	65.68	65.73	1078770.0
2017-04-10 14:00:00	MSFT	Stock	65.735	65.74	65.57	65.675	1382691.0
2017-04-10 15:00:00	MSFT	Stock	65.673	65.73	65.49	65.53	3150690.0
2017-04-10 16:00:00	MSFT	Stock	65.53	65.58	65.44	65.58	2487682.0
2017-04-10 17:00:00	MSFT	Stock	65.58	65.58	65.58	65.58	700.0
2017-04-10 07:00:00	NVDA	Stock	2.505	2.5075	2.505	2.5075	12000.0
2017-04-10 08:00:00	NVDA	Stock	2.5088	2.5188	2.5088	2.5125	354080.0
2017-04-10 09:00:00	NVDA	Stock	2.5125	2.5158	2.4885	2.4913	74568640.0
2017-04-10 10:00:00	NVDA	Stock	2.4908	2.4913	2.4528	2.455	130522160.0
2017-04-10 11:00:00	NVDA	Stock	2.455	2.473	2.4548	2.4615	87534760.0
2017-04-10 12:00:00	NVDA	Stock	2.461	2.4718	2.452	2.4715	54399200.0
2017-04-10 13:00:00	NVDA	Stock	2.4712	2.4758	2.4663	2.472	32478600.0
2017-04-10 14:00:00	NVDA	Stock	2.4725	2.4728	2.4595	2.462	52802720.0
2017-04-10 15:00:00	NVDA	Stock	2.4622	2.4665	2.44	2.4443	135155400.0
2017-04-10 16:00:00	NVDA	Stock	2.444	2.4458	2.4375	2.4415	39981400.0
2017-04-10 17:00:00	NVDA	Stock	2.4415	2.4415	2.435	2.4368	574680.0
2017-04-10 18:00:00	NVDA	Stock	2.4415	2.442	2.4388	2.442	204560.0
2017-04-10 19:00:00	NVDA	Stock	2.4415	2.4415	2.432	2.434	331400.0
2017-04-10 05:00:00	AMZN	Stock	44.725	44.8	44.725	44.8	9680.0
2017-04-10 06:00:00	AMZN	Stock	44.75	44.75	44.75	44.75	4100.0
2017-04-10 07:00:00	AMZN	Stock	44.8085	45.022	44.8085	44.975	401740.0
2017-04-10 08:00:00	AMZN	Stock	44.8625	44.9995	44.8625	44.9345	280120.0
2017-04-10 09:00:00	AMZN	Stock	44.9225	45.421	44.9225	45.3295	13759480.0
2017-04-10 10:00:00	AMZN	Stock	45.328	45.4255	45.2555	45.3115	8639140.0
2017-04-10 11:00:00	AMZN	Stock	45.3168	45.374	45.2055	45.2465	6105840.0
2017-04-10 12:00:00	AMZN	Stock	45.244	45.32	45.1415	45.2823	6222860.0
2017-04-10 13:00:00	AMZN	Stock	45.286	45.3325	45.265	45.3	3054300.0
2017-04-10 14:00:00	AMZN	Stock	45.3068	45.3445	45.215	45.324	3585500.0
2017-04-10 15:00:00	AMZN	Stock	45.315	45.3892	45.2855	45.352	8699440.0

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

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