PREVIEW / stock_1hour / 2016-08-31

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-31.parquet
  size:    1.0 MB
  rows:    48,291
  symbols: 3,269

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-08-31 04:00:00	AAPL	Stock	26.48	26.48	26.455	26.455	21288.0
2016-08-31 05:00:00	AAPL	Stock	26.4825	26.5525	26.4825	26.525	24564.0
2016-08-31 06:00:00	AAPL	Stock	26.4875	26.5125	26.4825	26.5125	7632.0
2016-08-31 07:00:00	AAPL	Stock	26.505	26.54	26.505	26.54	17984.0
2016-08-31 08:00:00	AAPL	Stock	26.5375	26.5525	26.475	26.475	180156.0
2016-08-31 09:00:00	AAPL	Stock	26.475	26.6	26.41	26.5875	13650516.0
2016-08-31 10:00:00	AAPL	Stock	26.59	26.6162	26.5125	26.5835	13953792.0
2016-08-31 11:00:00	AAPL	Stock	26.5825	26.6425	26.565	26.5925	10863676.0
2016-08-31 12:00:00	AAPL	Stock	26.59	26.625	26.5025	26.5825	12172132.0
2016-08-31 13:00:00	AAPL	Stock	26.5838	26.625	26.55	26.585	6525612.0
2016-08-31 14:00:00	AAPL	Stock	26.5875	26.615	26.5125	26.515	8299960.0
2016-08-31 15:00:00	AAPL	Stock	26.5125	26.57	26.5062	26.5275	19407740.0
2016-08-31 16:00:00	AAPL	Stock	26.525	26.56	26.5175	26.525	19125288.0
2016-08-31 17:00:00	AAPL	Stock	26.5225	26.5375	26.5	26.525	36572.0
2016-08-31 18:00:00	AAPL	Stock	26.52	26.52	26.5125	26.5125	3120.0
2016-08-31 19:00:00	AAPL	Stock	26.51	26.5125	26.5	26.5	17024.0
2016-08-31 07:00:00	MSFT	Stock	58.06	58.08	58.06	58.08	400.0
2016-08-31 08:00:00	MSFT	Stock	57.89	57.89	57.89	57.89	175.0
2016-08-31 09:00:00	MSFT	Stock	57.83	57.83	57.61	57.69	1988834.0
2016-08-31 10:00:00	MSFT	Stock	57.695	57.75	57.535	57.64	1969844.0
2016-08-31 11:00:00	MSFT	Stock	57.635	57.7	57.5	57.556	1419525.0
2016-08-31 12:00:00	MSFT	Stock	57.55	57.55	57.3	57.375	1842804.0
2016-08-31 13:00:00	MSFT	Stock	57.375	57.47	57.32	57.34	1485692.0
2016-08-31 14:00:00	MSFT	Stock	57.34	57.49	57.34	57.39	1852957.0
2016-08-31 15:00:00	MSFT	Stock	57.39	57.59	57.375	57.47	4511352.0
2016-08-31 16:00:00	MSFT	Stock	57.47	57.47	57.06	57.14	3871302.0
2016-08-31 17:00:00	MSFT	Stock	57.14	57.46	57.11	57.2	267667.0
2016-08-31 18:00:00	MSFT	Stock	57.15	57.15	57.15	57.15	100.0
2016-08-31 19:00:00	MSFT	Stock	57.23	57.23	57.23	57.23	1000.0
2016-08-31 08:00:00	NVDA	Stock	1.538	1.538	1.538	1.538	8000.0
2016-08-31 09:00:00	NVDA	Stock	1.5328	1.5448	1.5328	1.5398	25101120.0
2016-08-31 10:00:00	NVDA	Stock	1.5395	1.5405	1.5293	1.5295	35100320.0
2016-08-31 11:00:00	NVDA	Stock	1.5295	1.5406	1.529	1.5375	53659160.0
2016-08-31 12:00:00	NVDA	Stock	1.5375	1.5391	1.5325	1.5383	19864120.0
2016-08-31 13:00:00	NVDA	Stock	1.5383	1.5445	1.537	1.5438	28209440.0
2016-08-31 14:00:00	NVDA	Stock	1.544	1.548	1.5355	1.536	32358320.0
2016-08-31 15:00:00	NVDA	Stock	1.536	1.5405	1.5335	1.5335	107923360.0
2016-08-31 16:00:00	NVDA	Stock	1.5335	1.5335	1.5325	1.5325	974440.0
2016-08-31 17:00:00	NVDA	Stock	1.5385	1.5388	1.5338	1.5383	113600.0
2016-08-31 18:00:00	NVDA	Stock	1.538	1.5385	1.5348	1.5348	44000.0
2016-08-31 19:00:00	NVDA	Stock	1.535	1.535	1.5338	1.5338	111320.0
2016-08-31 06:00:00	AMZN	Stock	38.4455	38.4455	38.4455	38.4455	2000.0
2016-08-31 08:00:00	AMZN	Stock	38.3265	38.375	38.314	38.375	16140.0
2016-08-31 09:00:00	AMZN	Stock	38.35	38.38	38.222	38.222	3913420.0
2016-08-31 10:00:00	AMZN	Stock	38.225	38.3725	38.2	38.304	5152580.0
2016-08-31 11:00:00	AMZN	Stock	38.2975	38.386	38.2615	38.3715	2885980.0
2016-08-31 12:00:00	AMZN	Stock	38.3695	38.3695	38.225	38.2605	2509660.0
2016-08-31 13:00:00	AMZN	Stock	38.245	38.3115	38.2215	38.297	1684520.0
2016-08-31 14:00:00	AMZN	Stock	38.306	38.37	38.288	38.3372	1669380.0
2016-08-31 15:00:00	AMZN	Stock	38.319	38.482	38.2975	38.458	7630460.0

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

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