PREVIEW / stock_1hour / 2015-06-30

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-30.parquet
  size:    1.1 MB
  rows:    49,932
  symbols: 3,518

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-06-30 04:00:00	AAPL	Stock	31.275	31.305	31.2375	31.275	95496.0
2015-06-30 05:00:00	AAPL	Stock	31.29	31.4225	31.2875	31.3575	30380.0
2015-06-30 06:00:00	AAPL	Stock	31.34	31.3575	31.2875	31.33	78528.0
2015-06-30 07:00:00	AAPL	Stock	31.33	31.3875	31.305	31.365	271020.0
2015-06-30 08:00:00	AAPL	Stock	31.365	31.4125	31.305	31.3875	1017816.0
2015-06-30 09:00:00	AAPL	Stock	31.39	31.45	31.215	31.255	23323068.0
2015-06-30 10:00:00	AAPL	Stock	31.2575	31.425	31.245	31.375	28012880.0
2015-06-30 11:00:00	AAPL	Stock	31.3775	31.4575	31.345	31.375	20030248.0
2015-06-30 12:00:00	AAPL	Stock	31.375	31.4425	31.2775	31.3375	15833384.0
2015-06-30 13:00:00	AAPL	Stock	31.3375	31.505	31.2775	31.45	15413732.0
2015-06-30 14:00:00	AAPL	Stock	31.45	31.53	31.385	31.4	18040004.0
2015-06-30 15:00:00	AAPL	Stock	31.3988	31.44	31.35	31.355	29624884.0
2015-06-30 16:00:00	AAPL	Stock	31.3562	31.425	31.2825	31.3425	13437688.0
2015-06-30 17:00:00	AAPL	Stock	31.3425	31.3675	31.3325	31.3642	76684.0
2015-06-30 18:00:00	AAPL	Stock	31.355	31.3625	31.3375	31.3375	50052.0
2015-06-30 19:00:00	AAPL	Stock	31.3375	31.3542	31.335	31.3475	15620.0
2015-06-30 04:00:00	MSFT	Stock	44.6	44.6	44.6	44.6	100.0
2015-06-30 05:00:00	MSFT	Stock	44.6	44.67	44.6	44.67	850.0
2015-06-30 06:00:00	MSFT	Stock	44.66	44.66	44.66	44.66	100.0
2015-06-30 07:00:00	MSFT	Stock	44.66	44.66	44.62	44.62	4200.0
2015-06-30 08:00:00	MSFT	Stock	44.647	44.75	44.56	44.67	13972.0
2015-06-30 09:00:00	MSFT	Stock	44.66	44.72	44.12	44.15	4176319.0
2015-06-30 10:00:00	MSFT	Stock	44.15	44.22	43.96	44.15	5496490.0
2015-06-30 11:00:00	MSFT	Stock	44.15	44.34	44.0	44.01	3699644.0
2015-06-30 12:00:00	MSFT	Stock	44.015	44.14	43.94	44.095	2603595.0
2015-06-30 13:00:00	MSFT	Stock	44.1	44.27	44.01	44.195	2255201.0
2015-06-30 14:00:00	MSFT	Stock	44.2	44.4	44.13	44.18	2641631.0
2015-06-30 15:00:00	MSFT	Stock	44.18	44.34	44.11	44.15	7454636.0
2015-06-30 16:00:00	MSFT	Stock	44.15	44.23	44.12	44.15	4953477.0
2015-06-30 17:00:00	MSFT	Stock	44.16	44.21	44.16	44.21	680.0
2015-06-30 18:00:00	MSFT	Stock	44.17	44.2	44.17	44.2	1100.0
2015-06-30 08:00:00	NVDA	Stock	0.5142	0.5142	0.5142	0.5142	10000.0
2015-06-30 09:00:00	NVDA	Stock	0.5062	0.5082	0.5045	0.5049	40098000.0
2015-06-30 10:00:00	NVDA	Stock	0.5048	0.5062	0.4995	0.5003	42826840.0
2015-06-30 11:00:00	NVDA	Stock	0.5003	0.5035	0.4992	0.503	36918680.0
2015-06-30 12:00:00	NVDA	Stock	0.503	0.504	0.5005	0.5024	28048960.0
2015-06-30 13:00:00	NVDA	Stock	0.5022	0.5066	0.5015	0.5064	28318840.0
2015-06-30 14:00:00	NVDA	Stock	0.5065	0.5078	0.505	0.5055	34059080.0
2015-06-30 15:00:00	NVDA	Stock	0.5054	0.5059	0.5028	0.503	70599720.0
2015-06-30 16:00:00	NVDA	Stock	0.5028	0.5028	0.5028	0.5028	21374760.0
2015-06-30 17:00:00	NVDA	Stock	0.5102	0.5125	0.508	0.5121	686400.0
2015-06-30 18:00:00	NVDA	Stock	0.5125	0.5125	0.5125	0.5125	84000.0
2015-06-30 19:00:00	NVDA	Stock	0.5122	0.5125	0.5122	0.5125	12000.0
2015-06-30 04:00:00	AMZN	Stock	21.501	21.501	21.501	21.501	2000.0
2015-06-30 06:00:00	AMZN	Stock	21.6755	21.6755	21.6755	21.6755	6000.0
2015-06-30 07:00:00	AMZN	Stock	21.675	21.675	21.627	21.627	11720.0
2015-06-30 08:00:00	AMZN	Stock	21.6725	21.7125	21.6545	21.6735	151900.0
2015-06-30 09:00:00	AMZN	Stock	21.6585	21.725	21.5685	21.7007	4817560.0
2015-06-30 10:00:00	AMZN	Stock	21.7075	21.7785	21.6265	21.6795	6097260.0
2015-06-30 11:00:00	AMZN	Stock	21.6795	21.7415	21.6175	21.6275	4266300.0

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

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