PREVIEW / stock_1hour / 2016-08-09

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-09.parquet
  size:    1.0 MB
  rows:    48,481
  symbols: 3,250

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-09 04:00:00	AAPL	Stock	27.1025	27.1025	27.0975	27.0975	3748.0
2016-08-09 05:00:00	AAPL	Stock	27.125	27.1475	27.125	27.135	5852.0
2016-08-09 06:00:00	AAPL	Stock	27.135	27.1575	27.135	27.1575	6160.0
2016-08-09 07:00:00	AAPL	Stock	27.1475	27.1625	27.13	27.1375	76380.0
2016-08-09 08:00:00	AAPL	Stock	27.1475	27.1625	27.0225	27.0375	508980.0
2016-08-09 09:00:00	AAPL	Stock	27.0375	27.15	27.025	27.0475	15443620.0
2016-08-09 10:00:00	AAPL	Stock	27.0462	27.1125	27.0025	27.0725	17248648.0
2016-08-09 11:00:00	AAPL	Stock	27.0725	27.1175	27.055	27.0925	8939568.0
2016-08-09 12:00:00	AAPL	Stock	27.095	27.125	27.0475	27.085	10016776.0
2016-08-09 13:00:00	AAPL	Stock	27.085	27.16	27.085	27.1425	9820020.0
2016-08-09 14:00:00	AAPL	Stock	27.1435	27.1875	27.13	27.1775	9668324.0
2016-08-09 15:00:00	AAPL	Stock	27.1775	27.235	27.1675	27.205	17524512.0
2016-08-09 16:00:00	AAPL	Stock	27.205	27.2075	27.1775	27.1775	6758036.0
2016-08-09 17:00:00	AAPL	Stock	27.1875	27.1875	27.165	27.175	68904.0
2016-08-09 18:00:00	AAPL	Stock	27.1675	27.18	27.1675	27.18	16576.0
2016-08-09 19:00:00	AAPL	Stock	27.1675	27.1725	27.1675	27.1675	20800.0
2016-08-09 07:00:00	MSFT	Stock	58.12	58.12	58.12	58.12	400.0
2016-08-09 09:00:00	MSFT	Stock	58.1	58.34	58.03	58.26	1646319.0
2016-08-09 10:00:00	MSFT	Stock	58.26	58.45	58.155	58.29	2151110.0
2016-08-09 11:00:00	MSFT	Stock	58.296	58.5	58.28	58.296	2032687.0
2016-08-09 12:00:00	MSFT	Stock	58.29	58.4	58.15	58.156	1913218.0
2016-08-09 13:00:00	MSFT	Stock	58.16	58.265	58.06	58.14	1611262.0
2016-08-09 14:00:00	MSFT	Stock	58.14	58.22	58.02	58.16	1859509.0
2016-08-09 15:00:00	MSFT	Stock	58.164	58.205	58.08	58.2	3323901.0
2016-08-09 16:00:00	MSFT	Stock	58.2	58.23	58.12	58.2	1367725.0
2016-08-09 17:00:00	MSFT	Stock	58.24	58.45	58.18	58.3	7000.0
2016-08-09 18:00:00	MSFT	Stock	58.3	58.3	58.22	58.22	680.0
2016-08-09 19:00:00	MSFT	Stock	58.23	58.23	58.2	58.2	1200.0
2016-08-09 05:00:00	NVDA	Stock	1.475	1.475	1.475	1.475	4000.0
2016-08-09 07:00:00	NVDA	Stock	1.4813	1.4813	1.475	1.475	83360.0
2016-08-09 08:00:00	NVDA	Stock	1.475	1.4773	1.475	1.4765	581960.0
2016-08-09 09:00:00	NVDA	Stock	1.475	1.4793	1.4705	1.4715	56097200.0
2016-08-09 10:00:00	NVDA	Stock	1.4715	1.473	1.4685	1.4722	46384360.0
2016-08-09 11:00:00	NVDA	Stock	1.472	1.4852	1.472	1.4849	46082200.0
2016-08-09 12:00:00	NVDA	Stock	1.485	1.4865	1.4811	1.4824	28442720.0
2016-08-09 13:00:00	NVDA	Stock	1.4822	1.4847	1.4778	1.4806	26239800.0
2016-08-09 14:00:00	NVDA	Stock	1.4806	1.4808	1.473	1.4762	59103480.0
2016-08-09 15:00:00	NVDA	Stock	1.4762	1.4775	1.4695	1.4722	80824480.0
2016-08-09 16:00:00	NVDA	Stock	1.4722	1.4728	1.4713	1.4722	14016560.0
2016-08-09 17:00:00	NVDA	Stock	1.4722	1.48	1.4722	1.48	124760.0
2016-08-09 18:00:00	NVDA	Stock	1.478	1.4788	1.4762	1.4788	98000.0
2016-08-09 19:00:00	NVDA	Stock	1.4788	1.4788	1.4788	1.4788	12000.0
2016-08-09 06:00:00	AMZN	Stock	38.4065	38.4065	38.4065	38.4065	2680.0
2016-08-09 08:00:00	AMZN	Stock	38.3685	38.417	38.34	38.34	284160.0
2016-08-09 09:00:00	AMZN	Stock	38.345	38.5925	38.345	38.572	7490160.0
2016-08-09 10:00:00	AMZN	Stock	38.558	38.6055	38.461	38.577	6498060.0
2016-08-09 11:00:00	AMZN	Stock	38.573	38.63	38.545	38.5805	3433680.0
2016-08-09 12:00:00	AMZN	Stock	38.584	38.6035	38.486	38.5	2294540.0
2016-08-09 13:00:00	AMZN	Stock	38.5025	38.518	38.428	38.4524	2595700.0
2016-08-09 14:00:00	AMZN	Stock	38.4495	38.4775	38.3755	38.4265	3620460.0

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

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