PREVIEW / stock_1hour / 2015-09-04

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-04.parquet
  size:    1023 KB
  rows:    47,715
  symbols: 3,437

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
2015-09-04 04:00:00	AAPL	Stock	27.5025	27.5025	27.325	27.35	32740.0
2015-09-04 05:00:00	AAPL	Stock	27.3725	27.3825	27.35	27.35	6400.0
2015-09-04 06:00:00	AAPL	Stock	27.3275	27.3575	27.2525	27.3375	29516.0
2015-09-04 07:00:00	AAPL	Stock	27.3275	27.4325	27.3275	27.4	214988.0
2015-09-04 08:00:00	AAPL	Stock	27.41	27.5675	27.2175	27.25	1902936.0
2015-09-04 09:00:00	AAPL	Stock	27.255	27.6125	27.1625	27.429	31942828.0
2015-09-04 10:00:00	AAPL	Stock	27.4275	27.55	27.295	27.365	27663928.0
2015-09-04 11:00:00	AAPL	Stock	27.3675	27.405	27.2425	27.302	20238840.0
2015-09-04 12:00:00	AAPL	Stock	27.3	27.32	27.13	27.1825	18691612.0
2015-09-04 13:00:00	AAPL	Stock	27.185	27.31	27.1275	27.245	17313780.0
2015-09-04 14:00:00	AAPL	Stock	27.245	27.2788	27.14	27.275	17429152.0
2015-09-04 15:00:00	AAPL	Stock	27.2725	27.44	27.215	27.2925	37683956.0
2015-09-04 16:00:00	AAPL	Stock	27.2975	27.35	27.26	27.2875	9313296.0
2015-09-04 17:00:00	AAPL	Stock	27.2925	27.325	27.2825	27.295	174352.0
2015-09-04 18:00:00	AAPL	Stock	27.295	27.3075	27.275	27.2925	70356.0
2015-09-04 19:00:00	AAPL	Stock	27.2925	27.2925	27.2525	27.2625	69584.0
2015-09-04 04:00:00	MSFT	Stock	43.1	43.1	43.1	43.1	1000.0
2015-09-04 06:00:00	MSFT	Stock	42.97	42.97	42.97	42.97	100.0
2015-09-04 07:00:00	MSFT	Stock	43.0	43.0	43.0	43.0	1200.0
2015-09-04 08:00:00	MSFT	Stock	43.15	43.19	42.85	42.85	77613.0
2015-09-04 09:00:00	MSFT	Stock	42.81	43.04	42.49	42.65	4973747.0
2015-09-04 10:00:00	MSFT	Stock	42.65	42.88	42.5	42.525	4212855.0
2015-09-04 11:00:00	MSFT	Stock	42.54	42.7	42.43	42.6	3523094.0
2015-09-04 12:00:00	MSFT	Stock	42.6	42.61	42.35	42.425	3282792.0
2015-09-04 13:00:00	MSFT	Stock	42.43	42.52	42.32	42.34	3306848.0
2015-09-04 14:00:00	MSFT	Stock	42.34	42.475	42.195	42.475	3563405.0
2015-09-04 15:00:00	MSFT	Stock	42.473	42.82	42.44	42.6	8878929.0
2015-09-04 16:00:00	MSFT	Stock	42.61	42.71	42.61	42.63	3660820.0
2015-09-04 17:00:00	MSFT	Stock	42.61	42.61	42.61	42.61	890.0
2015-09-04 18:00:00	MSFT	Stock	42.61	42.63	42.61	42.61	3324.0
2015-09-04 19:00:00	MSFT	Stock	42.6	42.6	42.59	42.6	1556.0
2015-09-04 08:00:00	NVDA	Stock	0.5462	0.5542	0.5253	0.5253	64000.0
2015-09-04 09:00:00	NVDA	Stock	0.5468	0.556	0.5462	0.5512	31179280.0
2015-09-04 10:00:00	NVDA	Stock	0.551	0.5544	0.5492	0.5534	31864600.0
2015-09-04 11:00:00	NVDA	Stock	0.5535	0.5552	0.5502	0.5545	23727280.0
2015-09-04 12:00:00	NVDA	Stock	0.5545	0.555	0.5495	0.5495	15743400.0
2015-09-04 13:00:00	NVDA	Stock	0.5498	0.5502	0.5474	0.5475	19057560.0
2015-09-04 14:00:00	NVDA	Stock	0.5475	0.5481	0.5445	0.548	21762240.0
2015-09-04 15:00:00	NVDA	Stock	0.5481	0.5485	0.5435	0.5438	108058360.0
2015-09-04 16:00:00	NVDA	Stock	0.5442	0.5478	0.5438	0.547	4383640.0
2015-09-04 17:00:00	NVDA	Stock	0.547	0.547	0.547	0.547	16000.0
2015-09-04 19:00:00	NVDA	Stock	0.5438	0.5438	0.5438	0.5438	36000.0
2015-09-04 04:00:00	AMZN	Stock	25.012	25.012	25.012	25.012	2000.0
2015-09-04 07:00:00	AMZN	Stock	24.991	24.991	24.95	24.95	16500.0
2015-09-04 08:00:00	AMZN	Stock	25.012	25.1	24.823	24.9	331400.0
2015-09-04 09:00:00	AMZN	Stock	24.8755	25.1425	24.8575	25.034	7161360.0
2015-09-04 10:00:00	AMZN	Stock	25.0275	25.1195	24.925	24.964	5283800.0
2015-09-04 11:00:00	AMZN	Stock	24.973	25.0685	24.9136	25.011	5019940.0
2015-09-04 12:00:00	AMZN	Stock	25.009	25.0365	24.8575	24.87	3407140.0
2015-09-04 13:00:00	AMZN	Stock	24.8855	24.9725	24.85	24.8692	4282720.0

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

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