PREVIEW / stock_1hour / 2016-07-12

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-07-12.parquet
  size:    1.0 MB
  rows:    49,056
  symbols: 3,275

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
2016-07-12 04:00:00	AAPL	Stock	24.235	24.395	24.235	24.39	6640.0
2016-07-12 05:00:00	AAPL	Stock	24.3775	24.3775	24.3725	24.3775	2428.0
2016-07-12 06:00:00	AAPL	Stock	24.35	24.35	24.35	24.35	400.0
2016-07-12 07:00:00	AAPL	Stock	24.3525	24.375	24.3375	24.3475	77828.0
2016-07-12 08:00:00	AAPL	Stock	24.35	24.375	24.3375	24.3475	269984.0
2016-07-12 09:00:00	AAPL	Stock	24.35	24.425	24.28	24.3925	16431992.0
2016-07-12 10:00:00	AAPL	Stock	24.3912	24.4075	24.3175	24.35	14646132.0
2016-07-12 11:00:00	AAPL	Stock	24.3475	24.3725	24.3162	24.3625	9387032.0
2016-07-12 12:00:00	AAPL	Stock	24.3635	24.3825	24.35	24.3525	7332984.0
2016-07-12 13:00:00	AAPL	Stock	24.3525	24.3618	24.3125	24.32	7426508.0
2016-07-12 14:00:00	AAPL	Stock	24.32	24.3725	24.31	24.3412	9013532.0
2016-07-12 15:00:00	AAPL	Stock	24.3435	24.3675	24.3025	24.355	17511844.0
2016-07-12 16:00:00	AAPL	Stock	24.3525	24.3825	24.335	24.3575	7130644.0
2016-07-12 17:00:00	AAPL	Stock	24.3725	24.3825	24.355	24.3575	47904.0
2016-07-12 18:00:00	AAPL	Stock	24.355	24.355	24.35	24.3525	22020.0
2016-07-12 19:00:00	AAPL	Stock	24.355	24.3625	24.3525	24.3625	63960.0
2016-07-12 06:00:00	MSFT	Stock	52.97	52.98	52.97	52.98	7167.0
2016-07-12 07:00:00	MSFT	Stock	52.97	53.07	52.97	53.0	8269.0
2016-07-12 08:00:00	MSFT	Stock	53.0	53.05	52.9	53.04	17971.0
2016-07-12 09:00:00	MSFT	Stock	53.04	53.07	52.785	52.87	2773723.0
2016-07-12 10:00:00	MSFT	Stock	52.875	53.205	52.85	53.137	5128308.0
2016-07-12 11:00:00	MSFT	Stock	53.14	53.37	53.12	53.335	2578533.0
2016-07-12 12:00:00	MSFT	Stock	53.339	53.4	53.235	53.28	2227601.0
2016-07-12 13:00:00	MSFT	Stock	53.28	53.38	53.2	53.22	2006376.0
2016-07-12 14:00:00	MSFT	Stock	53.22	53.39	53.22	53.295	2496593.0
2016-07-12 15:00:00	MSFT	Stock	53.3	53.36	53.135	53.21	5865306.0
2016-07-12 16:00:00	MSFT	Stock	53.21	53.22	53.21	53.21	2288488.0
2016-07-12 17:00:00	MSFT	Stock	53.25	53.25	53.22	53.25	2226.0
2016-07-12 18:00:00	MSFT	Stock	53.2	53.2	53.16	53.16	4424.0
2016-07-12 19:00:00	MSFT	Stock	53.22	53.22	53.22	53.22	100.0
2016-07-12 07:00:00	NVDA	Stock	1.31	1.3135	1.31	1.3135	79040.0
2016-07-12 08:00:00	NVDA	Stock	1.3088	1.315	1.3088	1.315	226880.0
2016-07-12 09:00:00	NVDA	Stock	1.3138	1.332	1.3125	1.3171	72463040.0
2016-07-12 10:00:00	NVDA	Stock	1.3172	1.3172	1.2985	1.3088	87908480.0
2016-07-12 11:00:00	NVDA	Stock	1.3085	1.3128	1.3063	1.3087	53410720.0
2016-07-12 12:00:00	NVDA	Stock	1.3085	1.3135	1.3072	1.3123	30076480.0
2016-07-12 13:00:00	NVDA	Stock	1.3123	1.3172	1.3098	1.314	34514400.0
2016-07-12 14:00:00	NVDA	Stock	1.3143	1.321	1.3138	1.3182	28092360.0
2016-07-12 15:00:00	NVDA	Stock	1.318	1.3208	1.3152	1.32	70042320.0
2016-07-12 16:00:00	NVDA	Stock	1.32	1.32	1.3175	1.3175	27161240.0
2016-07-12 17:00:00	NVDA	Stock	1.3175	1.3205	1.3175	1.3175	153360.0
2016-07-12 18:00:00	NVDA	Stock	1.32	1.32	1.3175	1.3175	46000.0
2016-07-12 19:00:00	NVDA	Stock	1.32	1.32	1.3198	1.3198	35840.0
2016-07-12 04:00:00	AMZN	Stock	37.744	37.828	37.744	37.828	5800.0
2016-07-12 05:00:00	AMZN	Stock	37.9305	37.9305	37.9305	37.9305	2000.0
2016-07-12 06:00:00	AMZN	Stock	37.95	37.95	37.95	37.95	22280.0
2016-07-12 07:00:00	AMZN	Stock	37.95	37.9625	37.9	37.947	106860.0
2016-07-12 08:00:00	AMZN	Stock	37.925	38.0	37.885	37.928	397640.0
2016-07-12 09:00:00	AMZN	Stock	37.9275	37.9685	37.5255	37.5422	13170480.0
2016-07-12 10:00:00	AMZN	Stock	37.5555	37.6165	37.3305	37.4663	14551600.0

> showing 50 of 49,056 rows — these rows as CSV

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