PREVIEW / stock_1hour / 2015-06-02

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-02.parquet
  size:    1.0 MB
  rows:    48,439
  symbols: 3,480

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-02 04:00:00	AAPL	Stock	32.6025	32.6175	32.32	32.32	78624.0
2015-06-02 05:00:00	AAPL	Stock	32.375	32.5075	32.3725	32.5	81452.0
2015-06-02 06:00:00	AAPL	Stock	32.5025	32.69	32.5	32.5925	78692.0
2015-06-02 07:00:00	AAPL	Stock	32.6125	32.625	32.5	32.605	210916.0
2015-06-02 08:00:00	AAPL	Stock	32.61	32.6375	32.4975	32.59	478704.0
2015-06-02 09:00:00	AAPL	Stock	32.5875	32.6075	32.33	32.4275	25670568.0
2015-06-02 10:00:00	AAPL	Stock	32.4275	32.6	32.38	32.5075	21573956.0
2015-06-02 11:00:00	AAPL	Stock	32.51	32.56	32.445	32.5175	13247972.0
2015-06-02 12:00:00	AAPL	Stock	32.515	32.5975	32.5025	32.5775	14159512.0
2015-06-02 13:00:00	AAPL	Stock	32.5775	32.6625	32.5628	32.645	12657596.0
2015-06-02 14:00:00	AAPL	Stock	32.6428	32.6638	32.475	32.5125	15641272.0
2015-06-02 15:00:00	AAPL	Stock	32.5125	32.5235	32.4525	32.49	18699896.0
2015-06-02 16:00:00	AAPL	Stock	32.49	32.526	32.4775	32.5025	4226940.0
2015-06-02 17:00:00	AAPL	Stock	32.505	32.505	32.49	32.5	123964.0
2015-06-02 18:00:00	AAPL	Stock	32.5	32.5075	32.5	32.505	41308.0
2015-06-02 19:00:00	AAPL	Stock	32.5025	32.5225	32.495	32.5175	111952.0
2015-06-02 04:00:00	MSFT	Stock	47.16	47.16	47.05	47.05	517.0
2015-06-02 06:00:00	MSFT	Stock	47.26	47.3	47.26	47.3	300.0
2015-06-02 07:00:00	MSFT	Stock	47.23	47.23	47.23	47.23	486.0
2015-06-02 08:00:00	MSFT	Stock	47.3	47.3	47.051	47.2	2460.0
2015-06-02 09:00:00	MSFT	Stock	47.17	47.17	46.62	46.82	2906424.0
2015-06-02 10:00:00	MSFT	Stock	46.83	47.2	46.79	47.115	3009596.0
2015-06-02 11:00:00	MSFT	Stock	47.11	47.16	46.91	46.97	1679356.0
2015-06-02 12:00:00	MSFT	Stock	46.975	47.25	46.96	47.21	1692767.0
2015-06-02 13:00:00	MSFT	Stock	47.2	47.35	47.14	47.24	1803491.0
2015-06-02 14:00:00	MSFT	Stock	47.24	47.29	47.02	47.125	1656844.0
2015-06-02 15:00:00	MSFT	Stock	47.13	47.155	46.915	46.92	4839524.0
2015-06-02 16:00:00	MSFT	Stock	46.92	47.042	46.92	46.96	2298688.0
2015-06-02 17:00:00	MSFT	Stock	46.96	46.98	46.96	46.98	1170.0
2015-06-02 18:00:00	MSFT	Stock	46.99	47.0	46.92	46.92	5052.0
2015-06-02 19:00:00	MSFT	Stock	46.98	47.0	46.98	47.0	800.0
2015-06-02 08:00:00	NVDA	Stock	0.5595	0.5595	0.5595	0.5595	12000.0
2015-06-02 09:00:00	NVDA	Stock	0.5555	0.559	0.5532	0.5532	23815120.0
2015-06-02 10:00:00	NVDA	Stock	0.5532	0.5572	0.553	0.5544	29714720.0
2015-06-02 11:00:00	NVDA	Stock	0.5542	0.5552	0.553	0.5548	14069160.0
2015-06-02 12:00:00	NVDA	Stock	0.5545	0.5572	0.5544	0.555	17885120.0
2015-06-02 13:00:00	NVDA	Stock	0.555	0.5556	0.5538	0.5554	24224120.0
2015-06-02 14:00:00	NVDA	Stock	0.5552	0.5558	0.5488	0.551	31385560.0
2015-06-02 15:00:00	NVDA	Stock	0.551	0.551	0.548	0.5482	64521200.0
2015-06-02 16:00:00	NVDA	Stock	0.5484	0.5525	0.5482	0.5525	3654400.0
2015-06-02 19:00:00	NVDA	Stock	0.547	0.547	0.547	0.547	4000.0
2015-06-02 04:00:00	AMZN	Stock	21.508	21.51	21.5005	21.5005	22000.0
2015-06-02 06:00:00	AMZN	Stock	21.4605	21.525	21.46	21.525	14040.0
2015-06-02 08:00:00	AMZN	Stock	21.501	21.525	21.485	21.525	16520.0
2015-06-02 09:00:00	AMZN	Stock	21.4985	21.5035	21.3125	21.4115	7099140.0
2015-06-02 10:00:00	AMZN	Stock	21.4085	21.524	21.4075	21.455	4649360.0
2015-06-02 11:00:00	AMZN	Stock	21.4525	21.486	21.405	21.45	3341900.0
2015-06-02 12:00:00	AMZN	Stock	21.4515	21.637	21.4515	21.6035	2694120.0
2015-06-02 13:00:00	AMZN	Stock	21.608	21.6615	21.5893	21.6345	2988860.0
2015-06-02 14:00:00	AMZN	Stock	21.6412	21.6412	21.5345	21.57	2667400.0

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

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