PREVIEW / stock_1hour / 2017-01-03

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-01-03.parquet
  size:    1.1 MB
  rows:    49,358
  symbols: 3,142

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
2017-01-03 04:00:00	AAPL	Stock	29.005	29.06	29.0	29.0125	35136.0
2017-01-03 05:00:00	AAPL	Stock	29.0075	29.015	29.0	29.005	14952.0
2017-01-03 06:00:00	AAPL	Stock	29.0175	29.07	29.0175	29.07	10192.0
2017-01-03 07:00:00	AAPL	Stock	29.0575	29.095	29.005	29.005	55756.0
2017-01-03 08:00:00	AAPL	Stock	29.02	29.1	29.0	29.05	350924.0
2017-01-03 09:00:00	AAPL	Stock	29.05	29.0825	28.69	28.9175	23740836.0
2017-01-03 10:00:00	AAPL	Stock	28.915	28.9575	28.8175	28.8625	15991040.0
2017-01-03 11:00:00	AAPL	Stock	28.8625	28.92	28.7825	28.844	11588080.0
2017-01-03 12:00:00	AAPL	Stock	28.8475	28.8825	28.815	28.8662	6702300.0
2017-01-03 13:00:00	AAPL	Stock	28.8675	28.88	28.8075	28.8088	6187064.0
2017-01-03 14:00:00	AAPL	Stock	28.81	28.865	28.7875	28.8575	8363272.0
2017-01-03 15:00:00	AAPL	Stock	28.86	29.035	28.8475	29.035	21329680.0
2017-01-03 16:00:00	AAPL	Stock	29.0375	29.0625	28.8968	29.0025	12342636.0
2017-01-03 17:00:00	AAPL	Stock	29.02	29.02	28.9925	29.0025	12888.0
2017-01-03 18:00:00	AAPL	Stock	29.005	29.0175	29.005	29.005	4000.0
2017-01-03 19:00:00	AAPL	Stock	29.0175	29.0175	29.0075	29.0175	8328.0
2017-01-03 04:00:00	MSFT	Stock	62.71	62.71	62.65	62.65	4182.0
2017-01-03 06:00:00	MSFT	Stock	62.85	62.85	62.8	62.8	1100.0
2017-01-03 07:00:00	MSFT	Stock	62.85	62.85	62.8	62.8	3279.0
2017-01-03 08:00:00	MSFT	Stock	62.8	62.8	62.14	62.55	34674.0
2017-01-03 09:00:00	MSFT	Stock	62.6	62.82	62.42	62.57	3130401.0
2017-01-03 10:00:00	MSFT	Stock	62.57	62.84	62.33	62.34	2332276.0
2017-01-03 11:00:00	MSFT	Stock	62.34	62.48	62.25	62.41	2459611.0
2017-01-03 12:00:00	MSFT	Stock	62.42	62.43	62.285	62.37	1129875.0
2017-01-03 13:00:00	MSFT	Stock	62.37	62.42	62.24	62.27	1594457.0
2017-01-03 14:00:00	MSFT	Stock	62.265	62.33	62.14	62.23	1492160.0
2017-01-03 15:00:00	MSFT	Stock	62.23	62.58	62.125	62.57	4311662.0
2017-01-03 16:00:00	MSFT	Stock	62.57	62.58	62.347	62.44	2712912.0
2017-01-03 17:00:00	MSFT	Stock	62.44	62.44	62.42	62.42	99082.0
2017-01-03 18:00:00	MSFT	Stock	62.4	62.42	62.4	62.42	300.0
2017-01-03 19:00:00	MSFT	Stock	62.42	62.42	62.42	62.42	100.0
2017-01-03 04:00:00	NVDA	Stock	2.7063	2.7175	2.7	2.7	448560.0
2017-01-03 05:00:00	NVDA	Stock	2.7068	2.71	2.7003	2.701	126520.0
2017-01-03 06:00:00	NVDA	Stock	2.7003	2.71	2.6938	2.7	213040.0
2017-01-03 07:00:00	NVDA	Stock	2.6975	2.721	2.6952	2.721	682080.0
2017-01-03 08:00:00	NVDA	Stock	2.7152	2.7218	2.6145	2.633	9982880.0
2017-01-03 09:00:00	NVDA	Stock	2.6355	2.6425	2.5702	2.6168	217044560.0
2017-01-03 10:00:00	NVDA	Stock	2.6159	2.6592	2.5815	2.5858	220950280.0
2017-01-03 11:00:00	NVDA	Stock	2.5853	2.607	2.5502	2.555	148100160.0
2017-01-03 12:00:00	NVDA	Stock	2.555	2.5552	2.4845	2.5163	271933200.0
2017-01-03 13:00:00	NVDA	Stock	2.5153	2.5265	2.493	2.5209	171648640.0
2017-01-03 14:00:00	NVDA	Stock	2.5205	2.5468	2.5062	2.5328	174448000.0
2017-01-03 15:00:00	NVDA	Stock	2.5337	2.5545	2.5225	2.55	241491040.0
2017-01-03 16:00:00	NVDA	Stock	2.5498	2.558	2.5483	2.5538	19275240.0
2017-01-03 17:00:00	NVDA	Stock	2.5542	2.557	2.55	2.555	785760.0
2017-01-03 18:00:00	NVDA	Stock	2.5545	2.5568	2.5512	2.5533	562320.0
2017-01-03 19:00:00	NVDA	Stock	2.5525	2.555	2.5512	2.5512	661040.0
2017-01-03 04:00:00	AMZN	Stock	37.815	37.8935	37.815	37.888	27780.0
2017-01-03 05:00:00	AMZN	Stock	37.913	37.913	37.892	37.892	49860.0
2017-01-03 06:00:00	AMZN	Stock	37.8995	37.95	37.8995	37.95	16100.0

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

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