PREVIEW / stock_1hour / 2015-04-10

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-10.parquet
  size:    1.0 MB
  rows:    48,314
  symbols: 3,511

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-04-10 04:00:00	AAPL	Stock	31.5625	31.5975	31.2625	31.3775	107664.0
2015-04-10 05:00:00	AAPL	Stock	31.4	31.425	31.3775	31.4	23252.0
2015-04-10 06:00:00	AAPL	Stock	31.4725	31.52	31.4125	31.4125	100908.0
2015-04-10 07:00:00	AAPL	Stock	31.425	31.5375	31.4225	31.4775	609524.0
2015-04-10 08:00:00	AAPL	Stock	31.5	31.545	31.425	31.4878	1002416.0
2015-04-10 09:00:00	AAPL	Stock	31.4875	31.56	31.315	31.5098	28579724.0
2015-04-10 10:00:00	AAPL	Stock	31.51	31.7025	31.5	31.7	31487280.0
2015-04-10 11:00:00	AAPL	Stock	31.6975	31.7225	31.58	31.5938	15935072.0
2015-04-10 12:00:00	AAPL	Stock	31.595	31.6725	31.5375	31.655	11228152.0
2015-04-10 13:00:00	AAPL	Stock	31.6575	31.7725	31.64	31.7525	13531108.0
2015-04-10 14:00:00	AAPL	Stock	31.7525	31.7975	31.6862	31.7725	16567820.0
2015-04-10 15:00:00	AAPL	Stock	31.7725	31.8025	31.7225	31.775	23976284.0
2015-04-10 16:00:00	AAPL	Stock	31.775	31.795	31.755	31.755	5482248.0
2015-04-10 17:00:00	AAPL	Stock	31.77	31.775	31.755	31.7725	111044.0
2015-04-10 18:00:00	AAPL	Stock	31.7702	31.775	31.76	31.76	55448.0
2015-04-10 19:00:00	AAPL	Stock	31.765	31.785	31.7575	31.7725	87372.0
2015-04-10 04:00:00	MSFT	Stock	41.43	41.43	41.43	41.43	100.0
2015-04-10 05:00:00	MSFT	Stock	41.44	41.47	41.44	41.47	400.0
2015-04-10 07:00:00	MSFT	Stock	41.54	41.68	41.51	41.51	685.0
2015-04-10 08:00:00	MSFT	Stock	41.56	41.57	41.54	41.57	4452.0
2015-04-10 09:00:00	MSFT	Stock	41.65	41.84	41.41	41.75	4337687.0
2015-04-10 10:00:00	MSFT	Stock	41.755	41.95	41.72	41.86	5259282.0
2015-04-10 11:00:00	MSFT	Stock	41.86	41.89	41.81	41.837	2665870.0
2015-04-10 12:00:00	MSFT	Stock	41.833	41.84	41.71	41.71	2419307.0
2015-04-10 13:00:00	MSFT	Stock	41.714	41.74	41.63	41.715	1994609.0
2015-04-10 14:00:00	MSFT	Stock	41.71	41.73	41.6	41.62	2686255.0
2015-04-10 15:00:00	MSFT	Stock	41.615	41.74	41.6	41.72	5256098.0
2015-04-10 16:00:00	MSFT	Stock	41.72	41.77	41.48	41.75	1521181.0
2015-04-10 17:00:00	MSFT	Stock	41.73	41.73	41.53	41.62	4021.0
2015-04-10 18:00:00	MSFT	Stock	41.71	41.72	41.71	41.72	1800.0
2015-04-10 19:00:00	MSFT	Stock	41.651	41.72	41.65	41.72	1845.0
2015-04-10 08:00:00	NVDA	Stock	0.5622	0.565	0.5622	0.565	48000.0
2015-04-10 09:00:00	NVDA	Stock	0.5638	0.565	0.5618	0.564	20473840.0
2015-04-10 10:00:00	NVDA	Stock	0.5642	0.5675	0.5635	0.5638	35433960.0
2015-04-10 11:00:00	NVDA	Stock	0.5635	0.5648	0.562	0.5645	26764400.0
2015-04-10 12:00:00	NVDA	Stock	0.5645	0.5658	0.5638	0.5638	19173560.0
2015-04-10 13:00:00	NVDA	Stock	0.564	0.5658	0.5632	0.5644	20694680.0
2015-04-10 14:00:00	NVDA	Stock	0.5644	0.5658	0.5635	0.5654	27080440.0
2015-04-10 15:00:00	NVDA	Stock	0.5655	0.5692	0.5655	0.569	80618080.0
2015-04-10 16:00:00	NVDA	Stock	0.569	0.569	0.569	0.569	588560.0
2015-04-10 07:00:00	AMZN	Stock	19.2	19.2	19.2	19.2	2000.0
2015-04-10 08:00:00	AMZN	Stock	19.215	19.215	19.15	19.215	9000.0
2015-04-10 09:00:00	AMZN	Stock	19.215	19.263	19.0658	19.256	8660460.0
2015-04-10 10:00:00	AMZN	Stock	19.259	19.356	19.256	19.28	10729640.0
2015-04-10 11:00:00	AMZN	Stock	19.275	19.283	19.2105	19.2495	5472480.0
2015-04-10 12:00:00	AMZN	Stock	19.25	19.277	19.2375	19.245	3073220.0
2015-04-10 13:00:00	AMZN	Stock	19.25	19.251	19.1905	19.209	3536460.0
2015-04-10 14:00:00	AMZN	Stock	19.211	19.233	19.1555	19.1945	5342740.0
2015-04-10 15:00:00	AMZN	Stock	19.197	19.207	19.1195	19.132	8224440.0
2015-04-10 16:00:00	AMZN	Stock	19.1325	19.3365	19.123	19.13	704440.0

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

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