PREVIEW / stock_1hour / 2014-09-15

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-15.parquet
  size:    1.0 MB
  rows:    49,018
  symbols: 3,592

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
2014-09-15 04:00:00	AAPL	Stock	25.42	25.4575	25.4025	25.4475	24640.0
2014-09-15 05:00:00	AAPL	Stock	25.4475	25.46	25.425	25.4375	180308.0
2014-09-15 06:00:00	AAPL	Stock	25.48	25.5	25.44	25.475	16488.0
2014-09-15 07:00:00	AAPL	Stock	25.48	25.55	25.4525	25.535	329888.0
2014-09-15 08:00:00	AAPL	Stock	25.53	25.7225	25.4475	25.7125	4857312.0
2014-09-15 09:00:00	AAPL	Stock	25.71	25.865	25.409	25.48	56085552.0
2014-09-15 10:00:00	AAPL	Stock	25.48	25.6	25.4275	25.545	34732048.0
2014-09-15 11:00:00	AAPL	Stock	25.5425	25.665	25.4925	25.5075	33921516.0
2014-09-15 12:00:00	AAPL	Stock	25.51	25.5875	25.4425	25.575	21200272.0
2014-09-15 13:00:00	AAPL	Stock	25.575	25.59	25.4	25.42	23688476.0
2014-09-15 14:00:00	AAPL	Stock	25.4205	25.5375	25.4	25.4475	21446724.0
2014-09-15 15:00:00	AAPL	Stock	25.4468	25.5	25.36	25.4025	29211972.0
2014-09-15 16:00:00	AAPL	Stock	25.4075	26.0165	25.4	25.4325	5309852.0
2014-09-15 17:00:00	AAPL	Stock	25.4425	25.47	25.4075	25.4425	420820.0
2014-09-15 18:00:00	AAPL	Stock	25.4475	25.4475	25.4075	25.4175	218004.0
2014-09-15 19:00:00	AAPL	Stock	25.4175	25.4425	25.415	25.4375	142292.0
2014-09-15 07:00:00	MSFT	Stock	46.55	46.55	46.55	46.55	1722.0
2014-09-15 08:00:00	MSFT	Stock	46.5	46.58	46.5	46.57	2146.0
2014-09-15 09:00:00	MSFT	Stock	46.6	46.71	46.24	46.409	4847771.0
2014-09-15 10:00:00	MSFT	Stock	46.41	46.47	46.23	46.25	5292895.0
2014-09-15 11:00:00	MSFT	Stock	46.24	46.38	46.19	46.28	4124440.0
2014-09-15 12:00:00	MSFT	Stock	46.285	46.35	46.25	46.3	3721115.0
2014-09-15 13:00:00	MSFT	Stock	46.29	46.32	46.12	46.169	3705820.0
2014-09-15 14:00:00	MSFT	Stock	46.16	46.27	46.14	46.205	3794816.0
2014-09-15 15:00:00	MSFT	Stock	46.206	46.24	46.1	46.24	6928482.0
2014-09-15 16:00:00	MSFT	Stock	46.24	46.37	46.196	46.3	2175608.0
2014-09-15 17:00:00	MSFT	Stock	46.31	46.36	46.284	46.284	1177.0
2014-09-15 18:00:00	MSFT	Stock	46.33	46.4	46.24	46.37	35326.0
2014-09-15 19:00:00	MSFT	Stock	46.45	46.45	46.44	46.44	1500.0
2014-09-15 09:00:00	NVDA	Stock	0.4795	0.4803	0.4713	0.4723	31061360.0
2014-09-15 10:00:00	NVDA	Stock	0.4723	0.4755	0.4723	0.4731	38044360.0
2014-09-15 11:00:00	NVDA	Stock	0.473	0.4738	0.4695	0.4695	25603040.0
2014-09-15 12:00:00	NVDA	Stock	0.4695	0.4731	0.4695	0.4731	43296840.0
2014-09-15 13:00:00	NVDA	Stock	0.4732	0.4755	0.473	0.4732	28430520.0
2014-09-15 14:00:00	NVDA	Stock	0.473	0.476	0.4724	0.4735	19868640.0
2014-09-15 15:00:00	NVDA	Stock	0.4732	0.4742	0.471	0.4715	50805800.0
2014-09-15 16:00:00	NVDA	Stock	0.4715	0.4716	0.4713	0.4716	1994280.0
2014-09-15 08:00:00	AMZN	Stock	16.575	16.575	16.559	16.5605	52000.0
2014-09-15 09:00:00	AMZN	Stock	16.559	16.6025	16.313	16.3298	8612300.0
2014-09-15 10:00:00	AMZN	Stock	16.3285	16.361	16.091	16.1065	15712320.0
2014-09-15 11:00:00	AMZN	Stock	16.101	16.159	16.018	16.1338	11444960.0
2014-09-15 12:00:00	AMZN	Stock	16.1375	16.355	16.0875	16.1135	4925940.0
2014-09-15 13:00:00	AMZN	Stock	16.1075	16.108	15.9755	15.992	9384320.0
2014-09-15 14:00:00	AMZN	Stock	15.9905	16.175	15.95	16.1215	9869320.0
2014-09-15 15:00:00	AMZN	Stock	16.118	16.197	16.108	16.195	9984460.0
2014-09-15 16:00:00	AMZN	Stock	16.1945	16.2445	16.071	16.213	2214900.0
2014-09-15 17:00:00	AMZN	Stock	16.225	16.225	16.2125	16.214	10000.0
2014-09-15 18:00:00	AMZN	Stock	16.2	16.2	16.1945	16.1945	98860.0
2014-09-15 19:00:00	AMZN	Stock	16.2	16.2015	16.2	16.2015	24000.0
2014-09-15 08:00:00	GOOGL	Stock	29.267	29.275	29.22	29.22	92260.0

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

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